The reason Dwyer shot himself is that he was facing prison time for a corruption scheme and if he died while still in office, his family got full benefits. Oh, and it turned out he was innocent.

Edit: sorry, turns out I was spreading disinformation. I read the Wikipedia article and it turns out the evidence against Dwyer was pretty solid. Thanks u/TopRamenBinLaden for setting me straight.