Morbid little tidbit: If I haven't missed someone three people who have written TNGish novels have died:
A.C. Crispin
Gene DeWeese
Josepha Sherman (since Vulcan's Soul wasn't officially TNG I used the ish qualifier above.
I was thinking of John M. Ford, too, but, come to think of it, he only did a couple of TOS books. Ditto for Janet Kagan. And, on the editorial front, you have David Hartwell, who launched the whole Pocket Books STAR TREK line back in the eighties, but he had moved on from Pocket Books by the time TNG came along.