David Bowie's "Space Oddity" tells the story of an astronaut who cuts off communication and floats into space. The BBC used it extensively in their coverage of the 1969 moon landing - an odd choice considering the lyrics.
"Friends In Low Places" by Garth Brooks was written by two Nashville songwriters after a meal in a local restaurant. One of them forgot his money, but said not to worry, "I have friends in low places. I know the cook."
Pete Townshend never had a #1 UK hit with The Who or as a solo artist, but he did produce and play on a song that hit the top spot there: "Something In The Air" by Thunderclap Newman, a group he assembled.