Police say a man who wanted to kill himself went to explosive lengths that nearly took out the neighborhood