Where was James Bond death scene filmed?

Can you enlighten me on the location where the iconic death scene of the renowned spy, James Bond, was filmed? I'm intrigued to know if it was a real-life location that captured the essence of the film's climax or a specially crafted set that immersed the audience in the moment. Does the filming location hold any significance to the Bond franchise or did the crew simply choose it for its aesthetic appeal? I'm fascinated by the details surrounding this iconic scene and would love to hear more.