A gunman has been killed after US police stormed the underground where he was holding a five-year-old boy hostage for nearly a week.