And, assuming that Scotty survives longer than the events of Star Trek Generations, after being rescued from that transporter, he’ll have lived longer than any of them. Pretty sure he hasn’t had an in universe death yet which has been stated, but he was still kicking in 2369.

To be fair, the engine room would be the first place to blow up in a catastrophe.