In Star Trek: Nemesis. A genuine blown-into-tiny-pieces, final death, too - none of your “he’ll be back online in no time” stuff. Quite sad. :(