NTSB investigations: Amateur-built UNKNOWN ENG, 1997
22 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 | 25 |
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\") = 1997
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") = 1997
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 SEA98LA016Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-60 · Billings, MTThe co-pilot's failure to maintain the proper descent rate on final approach, the pilot-in-command's delayed remedial action, and overload of the left main landing gear assembly. Factors contributing were snow, crosswind conditions and deteriorating…NTSB FTW98LA034Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Roanoke, LAloss of engine power for an undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB SEA98LA008Accident · 1 fatalLimited investigationFinal reportBeckham RV-4 · Scio, ORThe pilot-in-command's loss of control of the aircraft for undetermined reasons.NTSB FTW98LA015Accident · No injuriesLimited investigationFinal reportSego Tool Hawk H2X · Tooele, UTThe pilot's failure to maintain aircraft control. Contributing was the inadequate design of the flight control systems, resulting in slow response to pilot input.NTSB NYC98LA010Accident · No injuriesLimited investigationFinal reportSukhoi SU-29 · Williamstown, NJThe pilot misjudged his altitude and airspeed.NTSB FTW97LA360Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Heber City, UTThe pilot's improper use of spoilers during the landing sequence. Factors were the embankment and the fence.NTSB IAD97LA121Accident · Minor injuriesLimited investigationFinal reportPohlman/Pohlman Rotorway Exec 90 · Westminster, MDThe loss of power due to carburetor icing. A factor to this accident was the carburetor heat was not accessible from within the cockpit.NTSB FTW97LA337Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Saratoga, WYThe pilot's failure to consult airplane performance data based upon the weather conditions that prevailed. Factors were terrain induced turbulence and high density altitude.NTSB SEA97LA189Accident · Minor injuriesLimited investigationFinal reportRotz RAF 2000 GTX SE · Olympia, WAThe pilot's failure to attain adequate rotor rpm prior to takeoff.NTSB NYC97LA163Accident · 1 fatalLimited investigationFinal reportElliot Monnett Moni · Hollis, NHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall spin and collision with terrain.NTSB FTW97LA300Accident · No injuriesLimited investigationFinal reportPoor Boys Toys Exec 90 · Patricia, TXThe failure of the pilot to maintain terrain clearance with the crops during a surveying flight. A factor was the pilots diverted attention.NTSB LAX97LA265Accident · No injuriesLimited investigationFinal reportSchempp-Hirth DUO Discus · Minden, NVThe pilot's failure to ensure that the wings were maintained at a lateral level attitude during the initial landing rollout. A factor in the accident was the rough, uneven nature of the terrain chosen for the landing.NTSB ATL97LA111Accident · No injuriesLimited investigationFinal reportAvid IV · Memphis, TNThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the repositioning of the control stick.NTSB ATL97LA103Accident · No injuriesLimited investigationFinal reportHughes 269C · Johnston, SCfailure of the pilot to maintain the proper rotor RPM during the approach and flare for landing.NTSB CHI97LA190Accident · Serious injuriesLimited investigationFinal reportDietrich Nieuport 12 · Byron, MIThe owner/pilot mechanic's inadequate inspection of the aircraft which led to contamination (other than water) of the fuel filter.NTSB NYC97LA127Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Rochester, VTThe pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.NTSB LAX97LA183Accident · No injuriesLimited investigationFinal reportNorth American Navion NA-1 · Morristown, AZfailure to replace an old and abraded oil feedline hose which led to its rupture and the in-flight loss of engine oil pressure. A related factor was the pilot's misjudgment of distance-to-go versus altitude remaining during the subsequent forced landing.NTSB FTW97IA362Incident · No injuriesIncident investigationFinal reportAyres S2R-G10 · Munday, TXblockage of both fuel lines from the left wing tank to the header tank by silicone rubber contaminants (foreign material), which resulted in fuel starvation. A related factor was the lack of suitable terrain for the forced landing.NTSB MIA97LA091Accident · 1 fatalLimited investigationFinal reportHackett Windex 1200C · Wauchula, FLfailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall/spin and subsequent collision with terrain.NTSB LAX97LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works AX-8B · Parker, AZthe pilot's inadequate in-flight planning, which resulted in an excessive descent and subsequent hard landing, due to a drop in fuel pressure along with shifting winds at low altitude.NTSB ATL97IA035Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAfailure of the Stage 1 High Pressure Turbine due to a fatigue fracture in a disk blade retention lug.NTSB FTW97LA079Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Wellington, COThe pilot's failure to maintain control of the aircraft and his improper autorotation technique that induced the roll and subsequent ground collision. A factor was his lack of recurrent training.