NTSB investigations: Amateur-built UNKNOWN ENG, 1993
27 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\") = 1993
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") = 1993
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 FTW94LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally RX7 · Albuquerque, NMPilot's failure to maintain aircraft control. A factor was the gusty winds.NTSB LAX93LA370Accident · No injuriesLimited investigationFinal reportBeech A-36 · Firebaugh, CAthe CFI's inadequate supervision of the flight and his delay in taking remedial action; the dual student's premature liftoff and improper use of the flight controls. The high vegetation and soft terrain were factors in this accident.NTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.NTSB MIA93LA196Accident · Minor injuriesLimited investigationFinal reportSukhoi SU-26M · Natchez, MSThe pilot-in-command's failure to accurately calculate fuel consumption resulting in total loss of engine power due to fuel exhaustion while approaching the destination airport.NTSB ANC93IA176Incident · No injuriesIncident investigationFinal reportSikorsky C54A · Anita Bay, AKThe separation of the turbine blade from the power turbine disc.NTSB MIA93LA185Accident · Serious injuriesLimited investigationFinal reportKeuthan Buccaneer II · Cocoa, FLFailure of maintenance personnel to properly reinstall a bolt and nut in the elevator control linkage, which resulted in a disconnect of the linkage and loss of elevator control.NTSB SEA93LA202Accident · Serious injuriesLimited investigationFinal reportKope Zenith CH200 · Waterville, WAA short in the electrical wiring to the fuel pump.NTSB CHI93DEC01Accident · Minor injuriesFinal reportBradford Pietenpol Skyscout · Eaton Rapids, MIthe pilot's failure to maintain airspeed which resulted in an inadvertant stall. Factors related to the accident were the low altitude and the restricted movement of the carburetor needle.NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.NTSB SEA93LA174Accident · 2 fatalLimited investigationFinal reportBrauch Glasair · Blanding, UTThe loss of engine power resulting from inadequate maintenance inspection by the pilot, a leak from loose fuel system line fittings, and fuel exhaustion. A factor relating to the accident was the rough/uneven terrain.NTSB CHI93LA295Accident · Minor injuriesLimited investigationFinal reportGardner SEA RAY · Oshkosh, WIThe pilot in command's not maintaining proper climb rate. A factor was the abrupt control interference by the passenger.NTSB DEN93LA086Accident · Serious injuriesLimited investigationFinal reportBalloon Works 7B-15 · Colorado Sprgs, COThe passenger's failure to assume the proper landing position as instructed by the pilot in command. A factor was: the high wind.NTSB SEA93LA150Accident · No injuriesLimited investigationFinal reportHoopes Hummelbird · Salt Lake City, UTA fractured crankshaft.NTSB DEN93FA075Accident · 1 fatalField investigationFinal reportWiley Pitts S-1-E · Walters, OKPerformance of an aerobatic maneuver at an altitude insufficient for adequate terrain clearance.NTSB NYC93LA119Accident · No injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Columbus, OHThe pilot's selection of unsuitable terrain for landing. A factor related to the accident was the interruption of the glider pilot's planned approach by a powered airplane.NTSB FTW93LA188Accident · No injuriesLimited investigationFinal reportReims Cessna FA 150K · Willis, TXLoss of partial engine power due to stuck exhaust valve and exhaust and intake valve binding with carbon buildup. A factor was the lack of suitable terrainNTSB MIA93LA142Accident · No injuriesLimited investigationFinal reportSayer, Trevor A. Rans S-12 · New Smyrna Bch, FLFailure of the pilot to maintain adequate airspeed and inadvertent stall/spin. Contributing to the accident was total loss of engine power due to fuel starvation. This was due to improper placement of a component of the fuel system by the builder/pilot.NTSB DEN93LA065Accident · No injuriesLimited investigationFinal reportCessna 182A · Stratton, COThe selection of unsuitable terrain for a precautionary landing by the pilot in command. A factor was: misjudging the deteriorating weather.NTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.NTSB LAX93LA228Accident · No injuriesLimited investigationFinal reportWSK PZL KR-03A · Avenal, CAThe glider's encounter with the downdraft. Contributing to this accidents were the turbulence and the powerlines.NTSB SEA93LA116Accident · Serious injuriesLimited investigationFinal reportRambow Monnett Moni · Ritzville, WAThe improper landing flare.NTSB FTW93LA146Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec PZL-M-18 · De Witt, ARCompensation for wind improper by pilot. Factors were tailwind and downdraftNTSB FTW93LA124Accident · No injuriesLimited investigationFinal reportViolet Dragonfly · Carlsbad, NMThe improper installation of the control stick assembly and the subsequent separation of the flight control stick assembly from the mountNTSB MIA93LA088Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S1-T · Naples, FLThe installation of an improper designed intake tube and air filter by the nonmechanic rated pilot-in-command, which resulted in moisture build up and collapse of the air filter, which resulted in blockage of air flow to the engine and loss of engine power.…NTSB LAX93LA148Accident · 1 fatalLimited investigationFinal reportLangerud Varieze · Zenia, CAThe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The low ceiling was a factor.NTSB LAX93LA135Accident · Serious injuriesLimited investigationFinal reportDowner Aircraft Industries KR-1 · Prescott, AZThe total loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing area at the time of the power interruption.NTSB LAX93LA124Accident · 1 fatalLimited investigationFinal reportBertone Challenger II · Boulder City, NVThe pilot's loss of airplane control due to physical impairment as a result of either drugs or other cardiovascular reasons, or both.