The most proximate risk is that your colleagues will no longer trust you to "cover their asses". That usually results in you being driven out of the department or worse.
You're usually not talking about a "mistake" (although that happens too, eg, cops arresting someone after accidentally hitting them in a crosswalk), you're talking about an intentional on-street retaliation for affronting their honor.