Fatal NTSB investigations: Amateur-built UNKNOWN ENG, 2000
9 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\") = 2000
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") = 2000
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 SEA01LA008Accident · 1 fatalLimited investigationFinal reportWildman Adventurer · Yelm, WAA main rotor blade strike (impact) with both a pusher propeller blade and the rudder during an unknown phase of operation resulting in a loss of control and uncontrolled descent to terrain.NTSB MIA00LA234Accident · 1 fatalLimited investigationFinal reportEachon Time Warp Spitfire 9 · Lakeland, FLa loss of control which resulted in an inadvertent stall at too low an altitude to allow recovery. Factors in this accident were, the pilot/owner did not verify that the airplane was balanced before the flight, and he did not perform any weight or balance…NTSB CHI00FAMS2Accident · 1 fatalMissing aircraftFinal reportPeters RAF 2000 · Manistique, MIundetermined.NTSB CHI00LA226Accident · 1 fatalLimited investigationFinal reportHalsmer Crazy 8 · Lafayette, INAircraft control not being maintained by the pilot during the forced landing. Factors to the accident were the engine failure due to an overtemperature, the pilot's lack of familiarity with the aircraft, and the trees.NTSB LAX00LA245Accident · 1 fatalLimited investigationFinal reportGarlick HH-1K · Live Oak, CAThe inadequate lubrication of the tail rotor drive shaft coupling by unknown maintenance personnel that resulted in the in-flight failure and separation of the helicopter's tail boom.NTSB LAX00LA242Accident · 1 fatalLimited investigationFinal reportWorldwide Aero AEROS-40B · San Bernadino, CAThe ground crew's diverted attention toward the landing airship while trying to catch a mooring rope, which resulted in their failure to detect an immenient collision with each other.NTSB NYC00LA141Accident · 1 fatalLimited investigationFinal reportCarlson Criquet · East Palestine, OHThe failure of the powerplant to produce adequate power for undetermined reasons, and the pilot's continued operation of the airplane with known deficiencies.NTSB LAX00FA148Accident · 2 fatalField investigationFinal reportFouga 6 CM 170 · San Joaquin, CAThe pilot's intentional performance of aerobatic maneuvers that resulted in the aircraft stalling and entering a spin from which he did not recover. A factor in the accident was the pilot's lack of experience in the aircraft.NTSB LAX00FA122Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cima, CAIn-flight collision with terrain for undetermined reasons.