Everyone except Kyon and Haruhi will die in the last book. That's been the set-up since Koizumi "jokingly" mentioned them being like Adam and Eve back in the first one. And I don't mean "everyone in the cast," I mean, "Kyon and Haruhi are the only sentient beings left, period."
At least, that's my crazy theory