Database Help

The searchable databases and lists contain a mixture of the following fields:

  • Action Code – Type of accident. See our Action Code List for what each of these abbreviations mean.
  • AF – Army Air Force to which the aircraft was assigned
  • Airline – For civil crashes, the name of the airline involved.
  • Aircraft Nickname – Name given to the aircraft by its crew.
  • Aircraft Manufacturer – Name of the aircraft manufacturer.
  • Aircraft Model – The model of aircraft involved in the accident.
  • Aircraft S/N - Aircraft serial number.
  • Aircraft Type - Aircraft type and model.
  • Bureau# – Bureau of Aeronautics Number.
  • Command – The command the aircraft was assigned to.
  • Country – The country in which the accident occurred. See our Country Code List (abbreviations) and use the code to search for all crashes in that country.
  • Crash Date – Date is in YYMMDD (year-month-day) format. 441021 is 1944 October 21st.
  • Crew Position – The crewmember's crew position.
  • Co-Pilot – Name of the co-pilot charged with the accident. If you are looking for a crewmember, also try our Names Database.
  • Damage Code – Summarizes damage to aircraft. See our Damage Code List for what each of these abbreviations mean.
  • E&E Report# – The escape and evasion report number.
  • Flight# – For civil crashes, the flight number of the aircraft involved.
  • Group – The group the aircraft was assigned to.
  • Home Base – Air Base to which the aircraft was assigned.
  • KU Location – Location given in the German KU report.
  • Location – Be careful using this field, this is the least reliable way to search. If you find the accident, great, but if not, do not give up! Try searching other ways (date, pilot name, home base, etc). If the crash occurred in between two towns, which one would be listed? It might be neither; the report may list a town farther away, or it may list a different or incorrect place name altogether.
  • MACR Location – Missing Aircrew Report location.
  • MACR# – Missing Aircrew Report number.
  • MIA Date – Date the person went missing as reported on the MACR or date given on the E&E Report. May be off by a couple of days.
  • N# – For civil accidents, the N number (registration number) of the aircraft involved.
  • Pilot – Name of the pilot charged with the accident. If you are looking for a crewmember, also try our Names Database.
  • Rank – The rank of the crewmember.
  • Remarks – Additional useful information.
  • Ret UK Date – The date from the E&E cover page that the individual returned to the United Kingdom.
  • Squadron – Squadron to which the aircraft was assigned.
  • State - The US state in which the accident occurred.
  • Station – The station the aircraft was assigned to.
  • Unit – The unit the crew member was assigned to.
  • Wing – Wing to which the aircraft was assigned.