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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 3 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 6 |
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 8 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 5 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 7 |
| 1995 | 8 |
| 1996 | 5 |
| 1997 | 3 |
| 1998 | 7 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 8 |
| 2002 | 15 |
| 2003 | 21 |
| 2004 | 18 |
| 2005 | 20 |
| 2006 | 21 |
| 2007 | 19 |
| 2008 | 17 |
| 2009 | 19 |
| 2010 | 10 |
| 2011 | 12 |
| 2012 | 14 |
| 2013 | 14 |
| 2014 | 13 |
| 2015 | 7 |
| 2016 | 8 |
| 2017 | 5 |
| 2018 | 11 |
| 2019 | 13 |
| 2020 | 7 |
| 2021 | 7 |
| 2022 | 6 |
| 2023 | 5 |
| 2024 | 9 |
| 2025 | 2 |
| 2026 | 4 |
Where
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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX01LA244Accident · 1 fatalLimited investigationFinal reportLevitsky BD-5T · Cameron Park, CAan in-flight collision with terrain for undetermined reasons.NTSB 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.NTSB 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.NTSB SEA01LA116Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Custer, WAThe first pilot's failure to maintain aircraft control while maneuvering. Factors include an inadvertent stall.