NTSB investigations: Amateur-built UNKNOWN ENG
165 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 4 |
|---|---|
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 4 |
| 1987 | 4 |
| 1988 | 2 |
| 1990 | 6 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 6 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 9 |
| 2001 | 9 |
| 2002 | 11 |
| 2003 | 14 |
| 2004 | 11 |
| 2005 | 19 |
| 2006 | 15 |
| 2007 | 16 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 DEN08CA045Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Gunnison, COThe pilot's failure to maintain directional control of the airplane during takeoff resulting in the airplane hitting a snowbank and subsequently, the ground.NTSB NYC08LA024Accident · 2 fatalLimited investigationFinal reportBlondin 601HDS · Farmington, DEThe reason for this occurrence could not be determined.NTSB DFW08LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · New Iberia, LAThe private pilot's failure to maintain main rotor rpm, which resulted in a hard landing and subsequent rollover. Also causal was the flight instructor's delayed remedial action. A factor was the lack of suitable terrain the forced landing.NTSB SEA07FA263Accident · 1 fatalField investigationFinal reportAero Vodochody L-39C · Reno, NVThe pilot's encounter with wake turbulence while maneuvering over a race course. Contributing to the accident was the low altitude at which the encounter occurred.NTSB MIA07CA151Accident · No injuriesData collectionFinal reportSchleicher ASW-24E · Morganton, NCThe failure of the pilot to maintain airspeed while turning base to final resulting in the left wing contacting the ground.NTSB MIA07CA138Accident · No injuriesData collectionFinal reportAnthony J. Bencivenga Aventura II · Okeechobee, FLThe pilot's failure to maintain directional control of the airplane during landing, which resulted in the pilot being inadvertently ejected and the airplane's impact with the water during an uncontrolled descent.NTSB NYC07LA201Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-31 · Markham, VAThe pilot's failure to maintain aircraft control. Contributing to the accident were a fuel leak as reported by the pilot, the pilot's diverted attention, a low cloud ceiling, and fog.NTSB CHI07LA272Accident · 1 fatalLimited investigationFinal reportClifford Titan Tornado II · Henning, MNThe inadvertent stall and low airspeed while maneuvering. A contributing factor was the low altitude of the maneuver.NTSB DFW07LA183Accident · 1 fatalLimited investigationFinal reportHuggles Sonex · Bonham, TXThe pilot's failure to maintain control of the airplane on take off, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB SEA07FA231Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus-CM · Benton, CAThe pilot's failure to maintain aircraft control while maneuvering and the inadvertent entry into a stall/spin. Contributing to the accident were the mountainous terrain conditions, unfavorable wind conditions, and the terrain-induced turbulent wind…NTSB CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.NTSB CHI07CA165Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Manito, ILThe pilot's failure to maintain proper airspeed and his decision to attempt flight over maximum gross weight. A factor to the accident was the stall encountered while attempting to avoid obstacles.NTSB CHI07LA113Accident · 2 fatalLimited investigationFinal reportMurphy Aircraft Mfg SR3500 Moose · Cotter, ARThe pilot not maintaining airplane control and airspeed during the approach. Factors were the gusty wind conditions, the inadvertent stall the pilot encountered, and the power lines that were impacted during the uncontrolled descent.NTSB SEA07CA084Accident · No injuriesData collectionFinal reportBoykin Rotorway Exec 162F · Camarillo, CAThe pilot's failure to maintain main rotor RPM resulting in an uncontrolled descent to a hard landing. A contributing factor was his lack of experience in make and model of aircraft.NTSB DFW07FA071Accident · 1 fatalField investigationFinal reportStevens KB-2 · Oklahoma City, OKThe pilot's failure to maintain control of the gyroplane while in the traffic pattern. Contributing to the accident was the high wind with terrain induced turbulence and the absence of the gyroplane's horizontal stabilizer.NTSB ATL07CA043Accident · No injuriesData collectionFinal reportBurkhart-Grob G109 · Monticello, GAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control, an in-flight collision with a hangar, and subsequent in-flight collision with the runway.NTSB LAX07LA047Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · San Pedro, CALoss of control for undetermined reasons.NTSB NYC07LA022Accident · 1 fatalLimited investigationFinal reportMonard RAF 2000 GTX · Ridgely, MDThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB ATL07CA009Accident · No injuriesData collectionFinal reportLawing Thomas R Exec 162-F · Aiken, SCThe pilot’s failure to adequately compensate for wind conditions during takeoff which resulted in a loss of tail rotor effectiveness and a roll over during an attempted forced landing.NTSB ANC06FA136Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed while maneuvering to reverse direction, which resulted in an inadvertent stall and an uncontrolled descent. Factors associated with the accident were the inadvertent stall and wind gusts.NTSB NYC06FA205Accident · 1 fatalField investigationFinal reportScheibe SF-28A · Canandaigua, NYThe private pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and impact with trees. Factors were the FAA inspector's delayed remedial action, and his lack of experience in the make and model motorglider.NTSB SEA06FA142Accident · 1 fatalField investigationFinal reportHawker Siddeley MK-58A Hunter · Hillsboro, ORLoss of aircraft control for undetermined reasons during the takeoff sequence.NTSB SEA06LA134Accident · 3 fatalLimited investigationFinal reportTaylor Royal T · Davenport, WAThe pilot's failure to maintain aircraft control while maneuvering, resulting in a collision with terrain.NTSB NYC06CA172Accident · No injuriesData collectionFinal reportRotorway 162-F · Brookhaven, NYThe student pilot inadvertently allowing the skids to contact the ground resulting in dynamic rollover.NTSB DFW06CA156Accident · Minor injuriesData collectionFinal reportCampbell W/Smiley J Execytive 162F · Porter, TXThe pilot's loss of control after encountering dynamic rollover while hovering.NTSB LAX06CA163Accident · No injuriesData collectionFinal reportIndus T211 · Death Valley, CAthe pilot's failure to maintain an adequate airspeed during final approach, which resulted in an inadvertent stall/mush and collision with terrain.NTSB CHI06CA116Accident · No injuriesData collectionFinal reportPalulis John Exec 162F · Kalkaska, MIThe compensation for wind conditions not performed by the pilot during hover. An additional cause was the tailwind.NTSB SEA06CA069Accident · No injuriesData collectionFinal reportKearsley Exec 162F · Morgan, UTThe pilot's inadequate in-flight decision to attempt to hover out of ground effect above the kit manufacturers published recommendations. A factor was mountainous terrain.NTSB LAX06LA110Accident · 3 fatalLimited investigationFinal reportCarpenter BJ/Carpenter Glasair II-S FT · Roseville, CAThe pilot's failure to maintain an adequate airspeed while performing low level aerobatics that led to a stall/spin.NTSB ATL06FA045Accident · 1 fatalField investigationFinal reportSwearingen SA-226-TC · Paris, TNThe pilot's inflight loss of control following a reported fuel asymmetry condition for undetermined reasons.NTSB LAX06LA096Accident · 1 fatalLimited investigationFinal reportReichel Lancair 360 · Santa Ynez, CALoss of airplane control for undetermined reasons.NTSB DFW06CA042Accident · No injuriesData collectionFinal reportCASA 1.131E · McKinney, TXThe pilot's failure to maintain directional control and airspeed, which resulted in an inadvertent stall. A contributing factor was the pilot's helmet and goggles shifting while maneuvering.NTSB LAX06CA037Accident · Serious injuriesData collectionFinal reportHopkins Rutan VariViggen · Aguila, AZthe pilot's failure to maintain an adequate airspeed during landing approach, which resulted in an inadvertent stall. A contributing factor was the pilot's lack of experience in the accident airplane.NTSB DFW06LA028Accident · 1 fatalLimited investigationFinal reportRehler Gyrocopter · New Braunfels, TXThe pilot's failure to maintain control while landing. A contributing factor was the high winds.NTSB LAX06LA016Accident · 1 fatalLimited investigationFinal reportNord 3202 · Casa Grande, AZthe pilot's failure to maintain airspeed during a low-altitude evasive maneuver away from another airplane, which resulted in a stall and uncontrolled descent.NTSB DFW06CA003Accident · No injuriesData collectionFinal reportHarms KitFox Series 5 · La Porte, TXThe pilot's failure to obtain/maintain adequate airspeed on takeoff, which resulted in two hard landings and subsequent loss of control.NTSB SEA05LA172Accident · 2 fatalLimited investigationFinal reportMK II Legacy Sport · Madras, ORThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall/spin and subsequent collision with the ground.NTSB DFW05LA187Accident · 1 fatalLimited investigationFinal reportYakovlev Yak 52 · Claremore, OKThe pilot's failure to obtain adequate airspeed while executing a low altitude aerobatic maneuver, which resulted in an aerodynamic stall while inverted. A factor was the low altitude.NTSB NYC05LA121Accident · 1 fatalLimited investigationFinal reportRatliff Hummel Bird · Pittsville, MDA loss of control for undetermined reasons, which resulted in an uncontrolled descent into terrain.NTSB LAX05LA239Accident · 1 fatalLimited investigationFinal reportAs+ AC4 · Sparks, NVthe pilot's failure to maintain an adequate airspeed while performing S-turns on final approach, which resulted in a stall and uncontrolled descent into terrain. A contributing factor in the accident was the pilot's impairment due to ingestion of an…NTSB SEA05LA137Accident · No injuriesLimited investigationFinal reportScheibe SF-28A Tandem-Falke · North Plains, ORThe pilot's failure to maintain airspeed during landing. Inadequate emergency procedures training and high vegetation were factors.NTSB ATL05LA121Accident · 1 fatalLimited investigationFinal reportDenmark Mini-Max · Covington, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, uncontrolled descent, and subsequent collision with the ground.NTSB DFW05FA152Accident · 1 fatalField investigationFinal reportBeech 76 · Conroe, TXThe pilot's failure to maintain sufficient airspeed resulting in a loss of control. Contributing factors were the high density altitude, the pilot's improper decision to secure the left engine, and his attempt to perform a single-engine go-around.NTSB DFW05LA110Accident · Minor injuriesLimited investigationFinal reportFriddle Super Cub Replica · Springtown, TXThe pilot's failure to compensate for wind conditions and his failure to maintain aircraft control during a go-around, which resulted in collision with trees.NTSB DFW05LA102Accident · 2 fatalLimited investigationFinal reportSpearman Raptor · Bogalusa, LAThe pilot's failure to maintain control of the airplane. A contributing factor was the pilot's lack of experience in the make/model airplane.NTSB CHI05LA082Accident · 2 fatalLimited investigationFinal reportMatthews Christen Eagle II · Iowa City, IAThe pilot not maintaining airplane control and airspeed, and the stall/spin encountered during aerobatic maneuvering. A factor in the accident was the pilot exceeding the published airplane's aft center of gravity limit and a factor in the pilot rated…NTSB MIA05CA074Accident · No injuriesData collectionFinal reportDgflugzeugbau DG-800S · Clermont, FLThe pilots failure to maintain airspeed which resulted in the glider stalling and impact with trees during the uncontrolled descent.NTSB DEN05LA059Accident · 1 fatalLimited investigationFinal reportBourgeois-Avid Flyer MK IV · Kaycee, WYthe pilot's failure to maintain airspeed which resulted in a stall.NTSB ANC05LA033Accident · 2 fatalLimited investigationFinal reportTwente Pitts Model 12 · Marion, MSThe pilot's failure to maintain control of the airplane while performing a low altitude, aerobatic maneuver, which resulted in an uncontrolled descent, and an in-flight collision with terrain. A factor associated with the accident was the initiation of a low…NTSB LAX05LA060Accident · Minor injuriesLimited investigationFinal reportEurocopter France EC135T1 · Casa Grande, AZthe separation of a main rotor control link due to improper maintenance installation.