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
| 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\") = 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.
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" 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 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…NTSB NYC05LA012Accident · 1 fatalLimited investigationFinal reportDouglas Adventure Air Ampib · Pawtucket, RIThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall.NTSB DFW05LA012Accident · 1 fatalLimited investigationFinal reportHuber DR 107 · Fletcher, OKThe pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB LAX04LA313Accident · 2 fatalLimited investigationFinal reportRedgate Europa Classic · Marble Canyon, AZan in-flight collision with terrain for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ATL04LA104Accident · 1 fatalLimited investigationFinal reportSukhoi SU-31 · Fort Lauderdale, FLThe pilot's failure to recover from an intentional spin during an attempted aerobatic maneuver.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.