I remember reading a PC Magazine article about Rogue Squadron for the N64. Apparently it was one of the first games to feature a context specific soundtrack.
First one I remember it in was X-Wing (1993), five years before Rogue Squadron. Looks like Monkey Island 2 (1991) was the first to use the system. Dark Forces used it, too.