The military is sadly well-versed in aircraft mishap investigations. There will be an investigation team and protocol well underway. They will look at aircrew, training, mechanical, procedures, etc. If pilot error is found to be a cause, a “long green table” proceeding may be initiated. A worst-case outcome can be administrative removal of the naval aviation warfare designator, in effect, “de-winged.” I had a LCDR P-3 pilot get “stashed” on TDY orders working for me at a shore command many years ago. Dewinged. He was waiting to be assigned to an “any line officer/any LCDR” billet. Assistant Security officer for the base, etc. No longer promotable. I can’t recall what happened to him. If the Navy found a need for his warm body and he got to 20 years, he could retire as a LCDR. If you are more junior than LCDR, have completed your ADSO, are not promotable, not accepted for lateral transfer into another community, you are not given another set of orders and are separated.