I used a Microsoft Sidewinder 3d Pro for this and other flight sim games. The throttle, plus twisting joystick, and extra buttons on the base gave you just about everything you needed.
Descent: Freespace series remains my favorite games of all time. Infinite space, dogfighting where you can match the enemy 's speed and target subsystems to disable them.... and online multiplayer. Honestly wayyyy ahead of its time.