Gunman committed suicide as family apologises for shooting