You might be thinking of "Apocalypse Now", which famously used "Ride of the Valkyries" during a helicopter attack scene.