Video shows moment a retired detective was shot