‘I don’t think that anything could have prepared our first responders of the city for what they saw,’ a detective said