NTSB investigations: Amateur-built UNKNOWN ENG
59 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Loss of control - on ground/water”. 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 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 7 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 1 |
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\" = 260))
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" = 260))
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 CHI07LA203Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Belle Plaine, IAThe pilot's failure to maintain directional control during landing rollout.NTSB SEA07LA011Accident · No injuriesLimited investigationFinal reportSorensen Searey · Marysville, WAThe pilot's failure to identify an unsafe condition (strong tidal currents) prior to a water landing, which resulted in the airplane nosing over when the pilot was unable to maintain aircraft control.NTSB NYC06CA067Accident · No injuriesData collectionFinal reportPergerson Highlander · Appomattox, VAThe pilot's failure to maintain directional control during landing. A factor in the accident was the pilot's improper use of flaps.NTSB NYC06CA021Accident · Serious injuriesData collectionFinal reportCraig Sonerai II LT · Ashland, KYA loss of directional control during an emergency landing. A factor in the accident was an unlatched canopy requiring the pilot to hold it closed to maintain aircraft control.NTSB DEN05IA083Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe reason for the occurrence was not determined.NTSB DEN05CA040Accident · No injuriesData collectionFinal reportDaniels Vans RV-8 · Albuquerque, NMthe pilot's failure to maintain directional control resulting in a ground loop.NTSB MIA05CA038Accident · No injuriesData collectionFinal reportSteven W. Jones KR2 · Zellwood, FLThe failure of the pilot to maintain directional control during landing resulting in the on-ground collision with a drainage ditch.NTSB IAD04LA019Accident · Minor injuriesLimited investigationFinal reportKrotje VM-1 Esqual · Cambridge, OHThe pilot's failure to maintain directional control. A factor was the inadequate brake system installed on the airplane.NTSB LAX04LA195Accident · No injuriesLimited investigationFinal reportSpirangam Velocity · Boulder City, NVthe pilot's failure to maintain directional control of the airplane during the landing rollout.NTSB ATL03LA141Accident · No injuriesLimited investigationFinal reportBellanca CH-300 · Peachtree City, GAThe pilots failure to maintain directional control during landing roll that resulted in a ground loop and subsequent collapse of the main landing gear.NTSB CHI03LA195Accident · No injuriesLimited investigationFinal reportRuminski Ultra Pup · Richmond, INThe pilot failed to maintain directional control and the airplane ground looped.NTSB ATL03CA105Accident · Minor injuriesData collectionFinal reportAyers RV-6A · St. Simons Isld, GAThe pilot's inadequate preflight inspection that resulted in his failure to remove the seatbelt (flight control gust lock) from the right side flight control stick.NTSB SEA03LA080Accident · No injuriesLimited investigationFinal reportAllen SA-300 · Yakima, WADirectional control was not maintained during the landing roll. A steering spring disconnected as a result of a tailwheel shimmy was a factor.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 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 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 ANC01LA150Accident · No injuriesLimited investigationFinal reportSlepcev Storch SS-MK4 · Anchorage, AKThe pilot's failure to maintain directional control and an inadvertent ground loop/swerve during the landing roll.NTSB NYC01LA230Accident · No injuriesLimited investigationFinal reportCarver RAF 2000 GTX SE · Barre, VTThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident were wind gusts.NTSB SEA01LA126Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Big Creek, IDThe pilot's failure to adequately compensate for the wind conditions during the landing roll. High and gusting winds were factors.NTSB FTW01LA055Accident · No injuriesLimited investigationFinal reportSchmidt Questair Venture · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll. Factors were the crosswind and soft terrain condition.NTSB CHI00LA225Accident · Minor injuriesLimited investigationFinal reportComeau Avid Flyer · Gladstone, MIaircraft control not maintained by the pilot.NTSB DEN00LA098Accident · No injuriesLimited investigationFinal reportRosenvall Avid MK IV · Salina, UTThe pilot's failure to maintain aircraft control during landing roll. A factor was gusting winds from nearby thunderstorms.NTSB MIA00LA143Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Lakeland, FLthe pilot's improper inflight planning/decision to land long, with a tailwind, on a wet grass runway that resulted in the loss of control and the airplane exiting the runway, incurring substantial damage.NTSB LAX99LA170Accident · No injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Reno, NVThe flight instructor's improper supervision of the pilot trainee and his failure to make timely control inputs in order to maintain aircraft control.NTSB LAX99LA060Accident · No injuriesLimited investigationFinal reportAegerter, Simon Velocity 173E-RG · San Diego, CAThe pilot's inadequate modification to the control systems, which resulted in a restricted elevator control.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 SEA96LA191Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lander, WYthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors relating to the accident were: the variable and gusty wind conditions.NTSB LAX96LA212Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Sparks, NVthe pilot's inadequate compensation for wind conditions during the takeoff roll, and his failure to maintain control of the glider. The gusty wind condition was a related factor.NTSB NYC96LA114Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · East Canton, PAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control and subsequent collision with obstacles. The gusty crosswind condition was a related factor.NTSB LAX95LA260Accident · Minor injuriesLimited investigationFinal reportStinson L-5E · Elko, NVthe failure of the student pilot to maintain directional control and the inadequate supervision by the instructor pilot in taking timely corrective action.NTSB LAX94LA293Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Tehachapi, CAthe pilot's failure to secure the canopy before takeoff, and his failure to maintain directional control during landing rollout.NTSB CHI94LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Harvard, ILthe pilot's excessive taxi speed. A factor in the accident was the wet grass runway.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 FTW92DPG12Accident · No injuriesFinal reportGrumman G-164A · Mc Crory, ARThe pilots failure to maintain directional control.NTSB SEA92LA172Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe pilot misjudged the landing flare. Factors include a lack of total pilot expereince.NTSB ATL91LA165Accident · Serious injuriesLimited investigationFinal reportIcard, Claude M. Sonerai II LT · Morganton, NCThe pilot's failure to maintain directional control of the airplane on the runway, and the inadvertent rotation of the airplane, resulting in an unplanned flight.NTSB NYC91LA007Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Erwinna, PAThe pilot's failure to maintain directional control during the take off roll.NTSB MKC90LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Altheimer, ARDirectional control was not maintained by the pilot in command. Contributing factors were landing with a tailwind. Compensation for wind conditions not considered and selection of the wrong runway.NTSB MKC90LA118Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morton, ARThe pilot's failure to maintain directional control due to inadequate compensation for wind conditions.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 FTW89LA019Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Houston, TXNTSB SEA88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAPlt landed with 80 deg right cross wind of 8 KTS, groundlooped to right. The plt said that ATIS info gave the wind as 220 degrees at 8 KTS; however his EST from windsock observation included gusts of 15 KTS. The observing station reported no gusts on the date…NTSB ANC88LA118Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe plt was practicing touch-&-go landings. On the first landing, the acft bounced & a successful go-around was made. During the second landing, the plt lost directional control of the acft & it went off the left side of the rwy & was damaged.NTSB LAX88LA292Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Bullhead City, AZAt the end of a cross country flight, the pilot had to abort the landing the first time due to heavy rain showers and turbulence. The pilot returned for landing and during the landing roll on the wet runway, the pilot lost control of the airplane. The…NTSB CHI88FA178Accident · No injuriesField investigationFinal reportSonerai IIL · Oshkosh, WINTSB CHI88LA168Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Menominee, MIDuring a demonstration of an autorotation to a run-on landing, the helicopter skids dragged in the soft grass upon touchdown, and the helicopter veered to the left. The pilot failed to maintain aircraft control when the helicopter veered left, the right skid…NTSB ANC88LA050Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot returned to Fairbanks int'l airport from an intended cross-country flight due to deteriorating weather. During the flight the airplane felt out of trim, and she elected to land on the longest runway available (10,300). During the landing roll she…NTSB LAX87LA244Accident · No injuriesLimited investigationFinal reportNord 3202 · Bishop, CADuring a relocation flight of a newly purchased acft, the plt was making a cross wind landing when on touchdown the left wing raised. The plt corrected by applying left aileron, however, he also relaxed the back pressure on the control stick allowing the tail…NTSB ANC86LA164Accident · No injuriesLimited investigationFinal reportCessna 195A · Willow, AKThe pilot reported that while demonstrating high speed taxi, the airplane veered to the left, entered an open trench, and was damaged. An exam of the flight control and brake systems revealed no pre-accident mechanical malfunction or failure.