Fatal NTSB investigations: Amateur-built UNKNOWN ENG, 2004

18 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19642026
Fatal NTSB investigations: Amateur-built UNKNOWN ENG, 2004 per year, 1964–2026: 421 cases
19641
19651
19662
19701
19712
19721
19751
19761
19772
19783
19792
19801
19812
19826
19835
19842
19855
19865
19878
19881
19891
19905
19912
19925
19935
19947
19958
19965
19973
19987
19997
20009
20018
200215
200321
200418
200520
200621
200719
200817
200919
201010
201112
201214
201314
201413
20157
20168
20175
201811
201913
20207
20217
20226
20235
20249
20252
20264

Latest cases

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 2004
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB MIA05FA017Accident · 1 fatalField investigationFinal reportCessna P206 · Jacksonville, FLThe improper setting of the elevator trim by the pilot-in-command, his failure to follow the checklist related to elevator trim setting, and his failure to maintain VS during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and…Oct 30, 2004 · N2588X · Substantial damageNTSB NYC05LA012Accident · 1 fatalLimited investigationFinal reportDouglas Adventure Air Ampib · Pawtucket, RIThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall.Oct 29, 2004 · N469PD · DestroyedNTSB DFW05LA012Accident · 1 fatalLimited investigationFinal reportHuber DR 107 · Fletcher, OKThe pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.Oct 28, 2004 · N255HR · DestroyedNTSB LAX05LA014Accident · 1 fatalLimited investigationFinal reportAMS Flight Carat A · Minden, NVthe pilot's likely inadvertent entry into instrument meteorological conditions created by the rapidly changing cloud conditions that resulted in his spatial disorientation and exceeding the glider's ultimate design loads while in a spiral dive, which resulted…Oct 23, 2004 · N418AP · DestroyedNTSB SEA05LA133Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hyak, WAThe loss of aircraft control during climb to cruise due to an undetermined flight control malfunction.Oct 19, 2004 · N39TJ · DestroyedNTSB DEN05FA002Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Santa Fe, NMthe pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…Oct 2, 2004 · N92CG · DestroyedNTSB LAX04LA322Accident · 2 fatalLimited investigationFinal reportWolf Glassair IIS · Mesa, AZa partial loss of power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and a collision with terrain.Sep 18, 2004 · N110UX · DestroyedNTSB LAX04LA313Accident · 2 fatalLimited investigationFinal reportRedgate Europa Classic · Marble Canyon, AZan in-flight collision with terrain for undetermined reasons.Sep 2, 2004 · N912EE · DestroyedNTSB ANC04LA098Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-3 · McGrath, AKThe pilot's inadequate in-flight planning/decision making, his continued VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Factors contributing to the accident were low ceilings due to smoke, rain, and mist.Aug 28, 2004 · N197TT · DestroyedNTSB ANC04LA093Accident · 1 fatalLimited investigationFinal reportHudson Hiperbipe SNS-7 · Palmer, AKThe pilot's failure to maintain control of the airplane, which resulted in an uncontrolled descent and subsequent in-flight collision with trees. A factor associated with the accident was a low altitude maneuver preformed by the pilot just after takeoff.Aug 18, 2004 · N898DH · DestroyedNTSB LAX04LA274Accident · 1 fatalLimited investigationFinal reportFinke Rotorway Exec 162F · Cameron Park, CAThe owner-builder's improper main rotor blade (MRB) maintenance/installation by under torquing the blade retaining nut.Jul 21, 2004 · N103RW · DestroyedNTSB FTW04FA167Accident · 2 fatalField investigationFinal reportBell 206B · Cushing, OKthe pilot's inadequate in-flight planning/decision and his failure to maintain obstacle clearance. Contributing factors were low altitude flight, sun glare, and the static wires.Jun 27, 2004 · N27TV · DestroyedNTSB ATL04LA104Accident · 1 fatalLimited investigationFinal reportSukhoi SU-31 · Fort Lauderdale, FLThe pilot's failure to recover from an intentional spin during an attempted aerobatic maneuver.Apr 30, 2004 · N31SU · Substantial damageNTSB SEA04LA063Accident · 1 fatalLimited investigationFinal reportGlasflugel STD Libelle 201B · Oso, WAThe pilot of the Glaser-Dirks (lead glider) failure to maintain clearance from the Glasflugel (trailing glider) resulting in a mid-air collision while maneuvering.Apr 2, 2004 · N161D · 2 aircraft · Substantial damageNTSB LAX04TA161Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · Safford, AZA loss of engine power due to fuel starvation and at least one ensuing engine power surge, which caused the airplane to pitch up abruptly into a stall at an altitude too low for recovery. Contributing to the accident were the pilot's mismanagement of the fuel…Mar 16, 2004 · N6259N · DestroyedNTSB MIA04LA058Accident · 1 fatalLimited investigationFinal reportOrtmayer/Parson none · Bunnell, FLThe owner/pilot mechanic's failure to comply with a manufacture notice to replace the rotor blades and hub bar assembly, resulting in a failure of the hub bar to hub bar wing attaching bolt and separation of a main rotor blade.Mar 12, 2004 · N69EP · Substantial damageNTSB LAX04FA150Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Oakdale, CAthe in-flight separation of the main spar due to corrosion in the wing center section not detectable by inspection methods described in manufacturer's service bulletins and FAA Airworthiness Directives.Mar 9, 2004 · N93707 · DestroyedNTSB LAX04LA125Accident · 2 fatalLimited investigationFinal reportKnapple/Wray Lancair IV-P · Apache Junction, AZthe pilot/builder's failure to maintain an adequate airspeed while maneuvering that resulted in an inadvertent stall/spin.Feb 17, 2004 · N330KT · Destroyed