Fatal NTSB investigations: Amateur-built UNKNOWN ENG, 2011
12 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\") = 2011
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") = 2011
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 ERA12FA120Accident · 1 fatalField investigationFinal reportCessna 441 · Nashville, PAThe pilot's failure to maintain minimum control airspeed after a loss of power to the right engine, which resulted in an uncontrollable roll into an inadvertent stall/spin. Contributing to the accident was the failure of the airplane's right engine for…NTSB WPR12FA059Accident · 1 fatalField investigationFinal reportVans RV7 - A · Surprise, AZAn electrical or engine electronic problem, which resulted in a loss of engine power, followed by a low-altitude stall.NTSB ERA12LA011Accident · 1 fatalLimited investigationFinal reportRivers William J KR-2 · Wytheville, VAThe pilot's failure to maintain control, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's lack of experience in the airplane make and model.NTSB WPR11MA454Accident · 11 fatalClass 1 · MajorFinal reportNorth American/Aero Classics P-51D · Reno, NVThe reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…NTSB ERA11FA468Accident · 1 fatalField investigationFinal reportMitchell David N Lancair IV P · Hammonton, NJThe Lancair pilot's failure to see and avoid the aerobatic airplane. Contributing to the accident was the Lancair pilot's inadequate use of collision avoidance strategies while inbound to an area of known potential aerobatic activity.NTSB CEN11FA469Accident · 1 fatalField investigationFinal reportBowie Richard Sonerai II · Dudley, MOFuel starvation due to the pilot’s improper fuel management and his decision to conduct the flight while under the influence of marijuana.NTSB CEN11FA443Accident · 2 fatalField investigationFinal reportKoen Lancair Laser IV-P · Port O'Connor, TXThe pilot’s loss of airplane control for reasons that could not be determined from the available information.NTSB ERA11FA374Accident · 1 fatalField investigationFinal reportBinkley Richard Sonex · Calhoun, GAThe total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.NTSB CEN11FA431Accident · 2 fatalField investigationFinal reportBosonetto Thorp T-18 · Howell, MIThe pilot's failure to maintain airplane control and airspeed during final approach, which resulted in an aerodynamic stall/spin at a low altitude.NTSB ERA11LA234Accident · 1 fatalLimited investigationFinal reportLet L 33 Solo · New Castle, VAPilot incapacitation shortly after takeoff for unknown reasons.NTSB ERA11FA222Accident · 2 fatalField investigationFinal reportReplogle Lancair 360 · Chesapeake, VAThe pilot did not maintain airspeed following a loss of engine power, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's selection of the wrong fuel tank at takeoff, which resulted in fuel starvation and the total…NTSB WPR11FA147Accident · 1 fatalField investigationFinal reportNeefjes Lancair 360 MK-II · Milford, UTThe pilot's loss of control of the airplane due to spatial disorientation after inadvertently entering instrument meteorological conditions. Contributing to the accident were the pilot's inadequate preflight preparation, his en route decision-making, and his…