A long public career found its zenith with his investigation into Russian interference in the 2016 presidential election