They won't fire him over this. Don't forget that being a cop is a government job. They will probably bust his pay and put him on shit duty for a long while and pass him over for promotion.

The real question is: How liable is the police department for totaling his car?