Stephen Cotgreave was on foot patrol when he accidentally dropped the magazine from his firearm