Honestly, now we're just trying to learn something for ourselves--screw that guy.
Anyway, for the OP, unless your friend wrecked a plane while texting and taking swigs of Nyquil, a FNAEB might not actually take his wings. Unless you can be specific, no one can say. Now, whether he'll actually stay flying is another matter entirely. He might end up being the Assistant MWR Officer and count basketballs for the rest of his time. Who knows?
Now, if he gives up his wings, or rather, asks to be taken off flight status, he may still rate the insignia, but he's basically already given himself the worst punishment a FNAEB could have given in the first place. It's like going to your own murder trial, pleading guilty, and requesting the death penalty before the cute female DA can even give her opening statement.
That said, if someone requests out of flight status, barring some extraordinary circumstance, he should take off his wings, whether required or not. On my first pump, the Ship's SuppO was one of those--she had pulled a Cougar after a difficult night landing on the boat in a SH-60B (really!), and was now a chop. She still wore wings and kept wanting to talk to us about pilot stuff. "Uhh, yeah, gotta go...'Firebirds' is on ship's TV again, and I just love seeing Nick Cage scream 'I am the greatest!'"