David Bowie's character Major Tom, who debuted in 1969 with "Space Oddity," was referenced in three other songs, with his story concluding in the 2016 album Blackstar. The character originated from Bowie's experiences with the film 2001: A Space Odyssey and the Apollo 8 Earthrise photograph. Major Tom's story continued in "Ashes To Ashes" and "Hallo Spaceboy," exploring themes of drug addiction and isolation. The conclusion to Major Tom's story came in the "Blackstar" music video, depicting his fate after years of loneliness and addiction.
Source: https://americansongwriter.com/all-the-david-bowie-songs-that-feature-his-character-major-tom