Best movie soundtracks of all time: From Ghost to Titanic via Wayne’s World and Dirty Dancing

We asked celebrity film-goers for their all-time favourites

Twice as ice: Frozen heroines Anna (pictured) and Elsa are identical but for their hair colour (Disney)

Queen's "Bohemian Rhapsody" has been voted the best song from a movie. The anthem, on the soundtrack of Wayne's World, was one of two Queen hits to feature in the top ten.

The poll, which surveyed 3,000 people, among them a host of well-known names, was compiled by British Airways to coincide with its Rooftop Film Club event this summer.

Tear-jerkers made up half of the top ten, including "Unchained Melody" from Ghost, "Wind Beneath My Wings" from Beaches, and "My Heart Will Go On" from Titanic.

Actress Sophie Turner, from Game of Thrones, has named the Celine Dion classic as her favourite song from a movie. "It's a film I grew up with," she said, "and every time I think of it, I think of Leonardo DiCaprio!"

Idina Menzel's blockbuster hit "Let It Go", from Disney's Frozen, was the most popular song for voters under 24.

Professor Brian Cox , TV presenter

"My favourite song in a movie comes from one of the first films I saw at the cinema – perhaps it's nostalgia, but I still think it's brilliant! I was on holiday in Llandudno in North Wales in 1977 and my Dad took me to see the Bond film The Spy Who Loved Me. The film starts with Roger Moore in a bright yellow suit skiing of a cliff and opening a Union Jack parachute, followed by the best Bond theme of all time, 'Nobody Does It Better'. It still sends tingles down the spine to this day!"

Dexter Fletcher, actor and director

"The theme tune from The Good, the Bad and the Ugly is my favourite because somehow Ennio Morricone manages to create tension, suspense and drama within it."

Amanda Berry, CEO Bafta

"'Moon River' is a song covered by a number of people, but used so brilliantly in Breakfast at Tiffany's. I cannot think of the film without thinking about the song, and vice versa. The lyrics (a mere handful of lines) and music come together to create movie magic. As soon as I hear the first few bars, I'm transported back to a time when I fell in love with New York (and with George Peppard!) and wanted to be Audrey Hepburn when I grew up."

Cameron Crowe, director and screenwriter

"Some say the lyrics of a song should never comment on the scene. This is not one of those times. The world crumbles and, of course, David Fincher knows the precise song to turn out the lights to in Fight Club – Pixies' 'Where Is My Mind'."

Alexander Armstrong, TV presenter and comedian

"'A Real Hero' by College and Electric Youth – the theme music to Drive. It evokes so much of what I loved about Eighties electropop – the music of my teens – and Drive is such a blindingly good film. It was still haunting me months after I saw it."

Mark Kermode, film critic

"My favourite song from a movie is 'Feed the Birds' from Mary Poppins. The film is practically perfect in every way, and that beautiful song never fails to reduce me to tears. Anyone who doesn't love Poppins simply has no soul!"

Justin Rose, golfer

"I find the entire 8 Mile soundtrack inspirational, especially 'Lose Yourself' by Eminem. Its lyrics are relevant to owning the moment in a big competition."

Charlotte Crosby, reality-TV star

"I'm a big fan of the song 'Show Me How You Burlesque', performed by Christina Aguilera, from the film Burlesque. I have worshipped her since I was about 12!"

Charlie Hedges, DJ, Kiss FM

"It has to be 'Born Slippy' by Underworld from the amazing Trainspotting. Even now when I'm DJing I'll drop this in a club and the reactions are always massive... It brings back a lot of good memories for people born in that dance era, but it's also recognised by today's clubbers too. A classic film and a brilliant soundtrack to go with it."

Gerry Cottle Jr, founder of the Rooftop Film Club

"Frankie Valli's 'Grease' is my favourite tune from a movie soundtrack. The moment that kicks in you know you're in for a treat. Even though it was written and performed before I was born it reminds me of my youth – and takes me back there every time I see that film and enjoy the amazing soundtrack."

In association with British Airways, the pop-up cinema 'Rooftop Film Club' runs until September (rooftopfilmclub.com)