NTSB investigations: Amateur-built UNKNOWN ENG, 2002
64 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\") = 2002
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") = 2002
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 ATL03LA026Accident · No injuriesLimited investigationFinal reportPreceptor Ultra pup · Smithville, TNThe pilot's inadequate preflight fuel planning of fuel resulted in fuel starvation, the total loss of engine power and the subsequent forced landing.NTSB LAX03LA041Accident · Serious injuriesLimited investigationFinal reportClyde K Carrier Team 1400Z · Woodland, CAthe builder/pilot's improper modification of wing fuel caps resulting in the failure of the vent system to adequately compensate for the pressure differential between the fuel tank and the external low pressure area of the wing. This led to the partial loss…NTSB SEA03LA011Accident · Serious injuriesLimited investigationFinal reportPeterson Dragonfly · Mulino, ORFuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing.NTSB LAX03LA036Accident · No injuriesLimited investigationFinal reportAsmus Exec 162F · Monterey, CAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB FTW03LA058Accident · No injuriesLimited investigationFinal reportRamsay Lancair IV-P · Bulverde, TXThe pilot's misjudgment of speed and distance.NTSB SEA03LA007Accident · 1 fatalLimited investigationFinal reportRiddell IV-P · Bozeman, MTThe loss of power for undetermined reason(s) and the pilot's failure to maintain the aircraft's flying speed above the power off stall speed in the landing configuration.NTSB CHI03LA012Accident · No injuriesLimited investigationFinal reportMork Kitfox III · Evansville, WIThe loss of power for undetermined reasons. A contributing factor is the unsuitable terrain.NTSB ATL03FA009Accident · 2 fatalField investigationFinal reportBeechcraft A60 · Jesup, GAThe loss of power in one engine and the loss of control for undetermined reasons.NTSB IAD03IA017Incident · No injuriesIncident investigationFinal reportCraig N. Moen RV-8 · Leesburg, VAA low-stress, high-cycle fatigue fracture of the right ignition timing rotor.NTSB LAX03LA011Accident · No injuriesLimited investigationFinal reportRotorway 162F · Tucson, AZthe failure of the secondary drive shaft.NTSB FTW03LA015Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Edinburg, TXThe loss of tailrotor effectiveness due to the right quartering tailwind, which resulted in a hard landing. Factors were the lack of suitable surrounding terrain for landing, which included numerous surrounding obstacles, and the tailwind.NTSB CHI03LA009Accident · Minor injuriesLimited investigationFinal reportDavis Early Bird Jenny · Scottsburg, INThe pilot not maintaining aircraft control. Factors to the accident included the pilot's lack of familiarity with the airplane, which resulted in an inadvertent stall/spin at a low altitude.NTSB CHI03LA006Accident · No injuriesLimited investigationFinal reportWolf Rotorway Exec-162F · Gregory, MIFailure of the secondary drive shaft, which resulted in a complete loss of power to the main rotor, and a high forward airspeed on touchdown, causing the helicopter to flip forward.NTSB MIA03LA002Accident · 2 fatalLimited investigationFinal reportGolden RV6A · Tuskegee, ALthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB LAX02FA300Accident · Serious injuriesField investigationFinal reportFairchild SA227-AC · Hawthorne, CAThe pilot-in-command's failure to maintain directional control during the rejected takeoff. The loss of directional control was caused by the crew's failure to follow prescribed pretakeoff and takeoff checklist procedures to ensure the both propellers were…NTSB MIA02LA171Accident · No injuriesLimited investigationFinal reportJohnson Hornet · Archdale, NCthe pilot's failure to maintain directional control during final approach, which resulted in the airplane drifting off course and impacting with trees. Factors in this accident were the pilot's attention being diverted due to the right door not being secured.NTSB ATL02LA170Accident · 1 fatalLimited investigationFinal reportMikoyan Gurevich Mig-15 · Whiteville, NCThe pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation which resulted in a loss of control and the subsequent collision with the ground .NTSB CHI02LA286Accident · Serious injuriesLimited investigationFinal reportBailey DSA-1 · Washington, IAThe selection of unsuitable terrain and the failure of the oil pressure gage line. Factors were, the pilot/owners failure to obtain an annual condition inspection, and the corn crop.NTSB LAX02LA284Accident · No injuriesLimited investigationFinal reportSiemens Rotorway Exec 162 F · Overgaard, AZThe pilot's failure to check the wind direction prior to practicing autorotations, and his misjudged flare maneuver. The tailwind was a factor.NTSB LAX02LA283Accident · 1 fatalLimited investigationFinal reportMinkler Venture M20 · Reno, NVthe overload failure of the horizontal stabilizers and elevators due to a pilot induced oscillation at a speed at or above Vne, which exceeded the design stress limits of the structure. Also causal was the intentional alteration by an unknown person or…NTSB CHI02LA283Accident · Serious injuriesLimited investigationFinal reportTerning Sky Scout · Sedan, KSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.NTSB CHI02LA277Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Martin, MIThe pilot's inadequate aircraft preflight and his inability to abort the takeoff due to the obscured windshield. Contributing to the accident was the bent hopper latch and the pilot's failure to maintain directional control.NTSB SEA02LA168Accident · Serious injuriesLimited investigationFinal reportNolley BD-5 · Corvallis, ORFuel starvation resulting in a loss of engine power during the aircraft's initial climb. A disconnected fuel line was a factor.NTSB CHI02CA267Accident · No injuriesData collectionFinal reportTomash Avid Flyer · Camp Lake, WIThe total failure of the engine ignition system, and the unsuitable terrain encountered during the forced landing. The low altitude was a contributing factor.NTSB LAX02FA266Accident · Serious injuriesField investigationFinal reportAirbus Industrie A320-231 · Phoenix, AZThe captain's failure to maintain directional control and his inadvertent application of asymmetrical engine thrust while attempting to move the #1 thrust lever out of reverse. A factor in the accident was the crew's inadequate coordination and crew resource…NTSB MIA02LA154Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Union, SCthe pilot's failure to maintain obstacle clearance.NTSB NYC02FA159Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Hilltown, PAThe pilot's improper pre-flight, and failure to follow procedures in the flight manual to determine that the stabilator was properly connected prior to flight, and which resulted in a loss of control while under tow, and uncontrolled impact with the ground.NTSB FTW02LA230Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Aledo, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the performance of aerobatic maneuvers with low altitude.NTSB FTW02LA223Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Altus, OKThe loss of engine power as a result of the fracture of a compressor turbine blade due to fatigue. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD02IA076Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · New York, NYThe partial loss of flight display information for undetermined reasons.NTSB MIA02LA139Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · Santa Rosa Bch, FLThe separation of the canopy for undetermined reasons.NTSB CHI02CA203Accident · Minor injuriesData collectionFinal reportBilgri Sonerai II Lts · Juneau, WIThe pilot's failure to maintain sufficient airspeed while maneuvering to return to the airport. A reduction in handling quality and the distraction due to the open canopy were contributing factors.NTSB LAX02LA230Accident · Serious injuriesLimited investigationFinal reportViolet Dragonfly · Tucson, AZThe pilot's loss of control resulting from his improperly planned approach and an inadvertent encounter with wake turbulence.NTSB MIA02LA136Accident · No injuriesLimited investigationFinal reportYakovlev Yak 52 · Parrish, FLThe in-flight failure of a carburetor/fuel line fitting, resulting in loss of engine power, a forced landing to unsuitable terrain, and a ground collision with a farm vehicle during the emergency landing.NTSB DEN02FA076Accident · 2 fatalField investigationFinal reportWheeler Doug 2000 · Ogden, UTthe pilot's failure to obtain and maintain adequate main rotor rpm, resulting in blade flapping and subsequent blade contact with the airframe, severing of the tailboom, and causing loss of aircraft control. Contributing factors were the high gusty winds, and…NTSB SEA02LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kittitas, WAThe pilot's failure to conduct an adequate preflight inspection of the fuel resulting in fuel exhaustion and a subsequent forced landing. A contributing factor was the rocky terrain encountered during the forced landing.NTSB ATL02LA142Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Atlanta, GAThe pilot's improper flare which resulted in a hard landing.NTSB NYC02FA138Accident · Serious injuriesField investigationFinal reportYakovlev YAK 52 · Matawan, NJThe pilot's excessive maneuvering and failure to maintain aircraft control, following a partial power loss during the initial climb, which resulted in an inadvertent stall/spin. A factor in the accident was an inadequate annual condition inspection performed…NTSB LAX02LA223Accident · 1 fatalLimited investigationFinal reportSteen SE-1 · Tucson, AZthe loss of engine power during takeoff for undetermined reasons.NTSB SEA02LA130Accident · No injuriesLimited investigationFinal reportThurmond Moni · Laurel, MTUndertorqued mounting bolts which resulted in fatigue to the wooden propeller blade and subsequent in flight separation of one of the blades while in cruise flight. An improper installation of the propeller assembly and soft terrain encountered during the…NTSB DEN02FA070Accident · No injuriesField investigationFinal reportBoone Rotorway 162-F · Englewood, COthe pilot encountering settling with power. A factor contributing to the accident was the tailwind.NTSB SEA02LA115Accident · No injuriesLimited investigationFinal reportSeattle Aerotech Helipower 2500 · Arlington, WAAircraft control not maintained during a run-on landing. A vibration of unknown origin was a factor in the accident.NTSB ATL02LA134Accident · Serious injuriesLimited investigationFinal reportFay Velocity Elite · Theodore, ALThe pilot's inadequate inflight planning for required fuel resulted in fuel exhaustion and the subsequent loss of engine power. A factor was unsuitable terrain.NTSB FTW02LA187Accident · 1 fatalLimited investigationFinal reportLidster Wittman Tailwind W-8 · Mesquite, TXThe in-flight separation of the outboard portion of the left wing due to the failure of the wing spar resulting from the builder's improper installation of a wing that did not meet the drawing specifications.NTSB ATL02LA125Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Concord, NCThe pilot's improper use of cyclic while attempting a hover resulting in dynamic rollover.NTSB ANC02LA052Accident · No injuriesLimited investigationFinal reportGrumman G-21 · Northway, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in an inadvertent ground loop/swerve. A factor associated with the accident was a crosswind.NTSB CHI02LA165Accident · No injuriesLimited investigationFinal reportFirm Kit Fox 4-1200 · Virginia, MNAn in-flight collision with a bird that resulted in severed fuel lines and the subsequent in-flight fire and loss of engine power. A factor in the accident was the soft terrain condition.NTSB LAX02LA206Accident · No injuriesLimited investigationFinal reportBeech BE76 · Prescott, AZThe student pilot's decision to abort the takeoff with insufficient runway remaining, resulting in a runway overrun and collision with a berm. A factor was the cabin door opening during the takeoff roll.NTSB MIA02FA106Accident · Minor injuriesField investigationFinal reportHelicopters & Exec 162F · Tampa, FLThe pilot's intentional operation of the helicopter while impaired by alcohol and a drug (zolpidem) resulting in the in-flight collision with a house.NTSB FTW02LA167Accident · No injuriesLimited investigationFinal reportAero Commander 500-S · La Porte, TXThe failure of a hydraulic line, which resulted in the loss of the brakes.