NTSB investigations: Amateur-built UNKNOWN ENG, 2002, TX
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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 3 |
| 1975 | 2 |
| 1976 | 4 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 5 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 3 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 7 |
| 2006 | 1 |
| 2007 | 7 |
| 2008 | 7 |
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 3 |
| 2012 | 6 |
| 2013 | 6 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 1 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 3 |
| 2026 | 1 |
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\") = 2002
AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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") = 2002
AND c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
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 FTW03LA058Accident · No injuriesLimited investigationFinal reportRamsay Lancair IV-P · Bulverde, TXThe pilot's misjudgment of speed and distance.NTSB FTW03LA015Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Edinburg, TXThe loss of tailrotor effectiveness due to the right quartering tailwind, which resulted in a hard landing. Factors were the lack of suitable surrounding terrain for landing, which included numerous surrounding obstacles, and the tailwind.NTSB FTW02LA230Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Aledo, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the performance of aerobatic maneuvers with low altitude.NTSB FTW02LA187Accident · 1 fatalLimited investigationFinal reportLidster Wittman Tailwind W-8 · Mesquite, TXThe in-flight separation of the outboard portion of the left wing due to the failure of the wing spar resulting from the builder's improper installation of a wing that did not meet the drawing specifications.NTSB FTW02LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-S · La Porte, TXThe failure of a hydraulic line, which resulted in the loss of the brakes.NTSB FTW02LA150Accident · Serious injuriesLimited investigationFinal reportAubrey Challenger II · Lubbock, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02FA087Accident · 2 fatalField investigationFinal reportBeech A36 · Austin, TXThe pilot's failure to maintain airspeed, resulting in a stall. Contributing factors were the low ceiling, fog, and the unforecast weather conditions..NTSB FTW02LA069Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Plainview, TXthe pilot's failure to maintain the proper glidepath, which resulted in landing short of the runway.