The incident caught on video was a “total, catastrophic failure of the containment vehicle,” said police chief Michel Moore