Fatal NTSB investigations: Amateur-built UNKNOWN ENG, 2001

8 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, 2001 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\") = 2001
    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 LAX02LA043Accident · 1 fatalLimited investigationFinal reportRominger Zic Zac Bird · Marina, CAthe failure the right wing spar and the subsequent separation of the right wing. Contributing factors were the pilot's inadequate maintenance, and the weakened wing structure due to a preexisting fuel tank leak.Dec 9, 2001 · N204ED · DestroyedNTSB NYC01LA224Accident · 1 fatalLimited investigationFinal reportYakovlev YAK-52 · Washington, CTThe pilot's failure to maintain aircraft control. Factors in the accident were the dark night, reduced visibility, and the pilot's decision to conduct VFR operations at night in adverse weather conditions.Sep 11, 2001 · N1189N · DestroyedNTSB LAX01LA294Accident · 1 fatalLimited investigationFinal reportHarter Kitfox Classic · Sedona, AZThe failure of the pilot to initiate a course reversal in a timely manner after flying into a box canyon and his failure to maintain airspeed during the attempted course reversal, which resulted in a stall spin.Aug 29, 2001 · N46MH · DestroyedNTSB FTW01LA179Accident · 1 fatalLimited investigationFinal reportPdps PZL-Bielsko SZD-55-1 · Uvalde, TXthe pilot's failure to maintain aircraft control during the base turn, which resulted in an inadvertant stall/spin.Aug 12, 2001 · N55VW · DestroyedNTSB LAX01LA244Accident · 1 fatalLimited investigationFinal reportLevitsky BD-5T · Cameron Park, CAan in-flight collision with terrain for undetermined reasons.Jul 14, 2001 · N104BD · DestroyedNTSB NYC01FA158Accident · 1 fatalField investigationFinal reportMoravan Zlin 526F · Queen Anne, MDThe pilot's failure to maintain airspeed during an aerobatic maneuver, which resulted in an inadvertent inverted spin.Jul 2, 2001 · N526GC · DestroyedNTSB MIA01LA164Accident · 1 fatalLimited investigationFinal reportBroyles P51 · Conestee, SCPartial loss of engine power due to an engine cylinder experiencing detonation resulting in a forced landing to none suitable terrain.Jun 16, 2001 · N251RB · DestroyedNTSB SEA01LA116Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Custer, WAThe first pilot's failure to maintain aircraft control while maneuvering. Factors include an inadvertent stall.Jun 10, 2001 · N52BG · Destroyed