NTSB investigations: Amateur-built UNKNOWN ENG, 1989
15 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 | 11 |
|---|---|
| 1965 | 12 |
| 1966 | 20 |
| 1967 | 16 |
| 1968 | 7 |
| 1969 | 11 |
| 1970 | 14 |
| 1971 | 16 |
| 1972 | 10 |
| 1973 | 12 |
| 1974 | 17 |
| 1975 | 13 |
| 1976 | 20 |
| 1977 | 19 |
| 1978 | 25 |
| 1979 | 18 |
| 1980 | 20 |
| 1981 | 19 |
| 1982 | 29 |
| 1983 | 21 |
| 1984 | 26 |
| 1985 | 22 |
| 1986 | 27 |
| 1987 | 31 |
| 1988 | 29 |
| 1989 | 15 |
| 1990 | 28 |
| 1991 | 20 |
| 1992 | 22 |
| 1993 | 27 |
| 1994 | 26 |
| 1995 | 31 |
| 1996 | 30 |
| 1997 | 22 |
| 1998 | 30 |
| 1999 | 34 |
| 2000 | 49 |
| 2001 | 45 |
| 2002 | 64 |
| 2003 | 67 |
| 2004 | 58 |
| 2005 | 70 |
| 2006 | 59 |
| 2007 | 74 |
| 2008 | 63 |
| 2009 | 62 |
| 2010 | 62 |
| 2011 | 44 |
| 2012 | 58 |
| 2013 | 43 |
| 2014 | 46 |
| 2015 | 40 |
| 2016 | 39 |
| 2017 | 43 |
| 2018 | 34 |
| 2019 | 40 |
| 2020 | 28 |
| 2021 | 36 |
| 2022 | 41 |
| 2023 | 41 |
| 2024 | 34 |
| 2025 | 32 |
| 2026 | 26 |
Where
Open the mapLatest 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\") = 1989
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") = 1989
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 LAX90LA048Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Chandler, AZImproper planning/decision by the pilot. Factors related to the accident were: variable and high wind conditions.NTSB CHI90IA006Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · San Francisco, CAThe extreme wear and eventual failure of a torque tube in the inboard trailing edge flap system. Inspection and lubrication intervals were a factor, as was the physical location of the torque tube with reference to external factors.NTSB ATL89LA221Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Hatteras, NCLoss of engine power for an unknown reason.NTSB ATL89LA212Accident · No injuriesLimited investigationFinal reportSikorsky H-34J · Louisville, GAAn undetermined malfunction of the main rotor drive system.NTSB ATL89FA196Accident · 1 fatalField investigationFinal reportBeech A-36 · Chapel Hill, NCThe pilot's failure to maintain control of the airplane while maneuvering for a landing. Contributing factors were: the pilot's failure to follow the emergency procedures for an autopilot malfunction, and pilot fatigue.NTSB BFO89LA067Accident · No injuriesLimited investigationFinal reportTravel Air B-4000 · Midland, VAThe pilot's improper compensation for wind conditions and improper flare during the landing. Contributing factors were:the wind conditions and the pilot's lack of experience in this make and model of aircraft.NTSB LAX89LA245Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Maricopa, AZThe pilot's inability to maintain airspeed, resulting in a hard landing. Also causal to the accident was the opening of the canopy for undetermined reasons.NTSB DEN89LA165Accident · Minor injuriesLimited investigationFinal reportHenry Vickers HCV-110 · Newcastle, WYThe failure to the magneto. The selection of a powerplant with a single magneto system was an improper choice and directly contributed to the cause. The pilot's misjudgement of the wind for the approach to a forced landing resulted in an improper ground…NTSB LAX89LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Haleiwa, Oahu, HIThe pilot's failure to adequately compensate for wind conditions and the failure to maintain sufficient altitude to clear obstacles. Contributing to the accident were the downdrafts along the ridge line.NTSB FTW89LA119Accident · No injuriesLimited investigationFinal reportCessna A185F · Marksville, LAFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and a subsequent nose over.NTSB LAX89DVG05Accident · No injuriesFinal reportMorse F85P-1 · Redding, CAAn animal on the runway. Factors were: the pilot's intentional ground loop and the resultant loss of control.NTSB DEN89LA088Accident · Minor injuriesLimited investigationFinal reportMiller S.A.L. 2/3 Mustang · Erie, COLoss of engine power for an unknown reason. Soft uneven terrain was a contributing factor.NTSB ATL89LA108Accident · No injuriesLimited investigationFinal reportBeech A36 · Chamblee, GAThe inattention of the pilot which resulted in the inadvertent retraction of the landing gear during the landing roll.NTSB MKC89LA065Accident · No injuriesLimited investigationFinal reportComposite Aircraft Mfg Cozy · Hudson, IAImproper preflight by the pilot which resulted in an inadequate fuel supply and fuel exhaustion.NTSB SEA89IA042Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Seattle, WAInoperative nosewheel steering due to improper maintenance. Contributing to the incident was the lack of adequate maintenance information available in the aircraft manuals.