007 Film: The World Is Not Enough
Actor: Robert Carlyle
Destroy Istanbul by detonating a nuclear submarine in the Bosphorus, thus satisfying his lust for chaos and allowing Elektra to monopolize the oil market.
Fate of the Bond villain:
Impaled by a plutonium rod shot out of the sub's reactor core at high speed by Bond.
See more information here
See more Bond villains here