NTSB investigations: Amateur-built UNKNOWN ENG
2,048 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, newest first
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'))
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'))
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 SEA98FA109Accident · No injuriesField investigationFinal reportNolley BD-5T · Corvallis, ORThe introduction of a fuel containing an ethanol additive into fuel tanks sloshed/sealed with a compound incompatible with alcohols, resulting in debonding of the compound from the fuel tank walls, leading to partial blockage of an in-line fuel filter, and a…NTSB NYC98FA129Accident · 1 fatalField investigationFinal reportHawker Hunter T MK 8 · Manchester, NHFuel exhaustion, resulting from the pilot's reliance on an inaccurate fuel quantity indicating system. A factor in the pilot's death was his intentional delay of the ejection sequence in order to avoid people and property on the ground.NTSB ANC98LA071Accident · No injuriesLimited investigationFinal reportCessna 172 · Angoon, AKThe pilot's failure to maintain directional control during the aborted takeoff. A factor associated with the accident was rough and uneven terrain.NTSB LAX98LA192Accident · No injuriesLimited investigationFinal reportArner Challenger II S · Pleasant Valley, AZLoss of engine power due to a loose spark plug wire cap caused by a broken spark plug retainer spring.NTSB MIA98LA179Accident · No injuriesLimited investigationFinal reportRotorway Executive 162F · New Port Richey, FLThe pilot's improper use of the collective. Contributing to the accident was pilot fatigue due to lack of sleep.NTSB MIA98LA163Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Pageland, SCWas the inadvertent stall of the airplane by the pilot-in-command while attempting to clear trees beneath the airplane during the descent for the forced landing. Contributing to the accident was the partial loss of engine power due to separation of the No.9…NTSB CHI98LA152Accident · No injuriesLimited investigationFinal reportRead Rotorway Executive · Valparaiso, INthe pilot not maintaining adequate clearance with the ground during hover. Factors which contributed to this accident were the pilot's execution of a hovering turn at too low of an altitude, inadequate preflight preparation, and failing to remove the…NTSB IAD98FA054Accident · 4 fatalField investigationFinal reportBeech A36 · Davis, WVThe pilot's spatial disorientation, his subsequent loss of control of the airplane, and his overload of the horizontal stabilizer during a recovery attempt. Factors include the pilot's continued flight into icing conditions, his lack of airspeed control, and…NTSB IAD98FA049Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Stevensville, MDThe pilot's abrupt, low-g maneuver, which resulted in mast bumping and separation of the main rotor system.NTSB MIA98LA143Accident · Minor injuriesLimited investigationFinal reportOrlando Heli Air TR-2000 · Lakeland, FLThe pilot's failure to obtain the proper touch down point (landed left of runway) on landing.NTSB ATL98LA062Accident · No injuriesLimited investigationFinal reportStewart 51 S-51D · Vero Beach, FLThe maintenance personnel failure to remove a plastic plug from the oil tank breather that resulted in the rupture of the engine oil tank. Factors were, a tailwind during the emergency landing, and a ditch on the departure end of the runway.NTSB FTW98LA179Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Carlisle, ARThe pilot's inadequate preflight and inflight planning/decision, which resulted in fuel exhaustion and the lost of engine power. A factor was the lack of suitable terrain for a forced landing.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.NTSB MIA97LA045Accident · No injuriesLimited investigationFinal reportIssoire-Aviation PIK-30 · Boynton Beach, FLfailure of the engine to restart for undetermined reason(s), after gliding (sailing) for about 3 hours, resulting in a forced landing in a swamp.NTSB SEA97LA020Accident · Minor injuriesLimited investigationFinal reportKarmy Rotorway Exec · Redmond, ORThe pilot's failure to remove the dolly wheels during the preflight inspection.NTSB SEA96LA220Accident · No injuriesLimited investigationFinal reportRalph Taylor Royal T · Kent, WAin-flight collision with an unknown object.NTSB FTW96LA377Accident · Serious injuriesLimited investigationFinal reportPzl-Mielec MIG-17 · Amarillo, TXThe pilot's excessive takeoff rotation which led to premature lift-off at a speed inadequate to maintain flight. A factor was the pilot's lack of experience in the MIG-17.NTSB FTW96LA360Accident · Minor injuriesLimited investigationFinal reportCresap Early Bird Jenny · Kersey, COFailure of the throttle linkage. A related factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA356Accident · No injuriesLimited investigationFinal reportBell 47 Soloy · Intracoastal, LAthe loss of aircraft control by unknown person(s).NTSB SEA96LA196Accident · Serious injuriesLimited investigationFinal reportWestcott Glasair I-FT · Puyallup, WAfailure of the air inlet screen, and subsequent ingestion of the foam air filter. An inadequate maintenance modification by the amateur builder and no suitable landing area were related factors.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 SEA96LA188Accident · Minor injuriesLimited investigationFinal reportJonas Exec 90 · Hermiston, ORslippage of the drive belts, while hover taxiing in ground effect, which resulted in loss of power to the rotor system; and inadequate remedial action by the pilot, which led to a roll over during touch down (forced landing). A factor relating to the accident…NTSB SEA96LA162Accident · No injuriesLimited investigationFinal reportConkey/Wapelhorst Lancair 235 · Cottage Grove, ORrelease of the main landing gear locking mechanism for undetermined reason(s).NTSB FTW96LA294Accident · Minor injuriesLimited investigationFinal reportO'Day Sonerai II-LS · Friendswood, TXa loss of engine power for undetermined reasons, and the pilot's failure to attain the proper traffic pattern altitude on the downwind leg prior to turning the base leg.NTSB CHI96LA225Accident · Serious injuriesLimited investigationFinal reportSisk BD-5 · Lake Geneva, WIfailure of the pilot to abort the takeoff, while there was sufficient runway remaining. The high temperature and calm wind were related factors.NTSB MIA96FA168Accident · 2 fatalField investigationFinal reportHiller FH-1100 · Webster, FLinadequate compliance with AD 77-07-08 (and SB FH1100-55-2A) by other maintenance personnel, and subsequent fatigue failure of plates in the tail rotor torsion tension bar. Factors related to the accident were: manufacturing discontinuities…NTSB CHI96LA208Accident · No injuriesLimited investigationFinal reportAerotechnik L-13 · Wichita, KSthe pilot's inadequate in-flight planning. Factors were the insufficient altitude and the dead battery.NTSB CHI96LA192Accident · No injuriesLimited investigationFinal reportCarrison-Seiman Schukert D-1 · Gardner, KSan aileron control malfunction of undetermined origin. A factor was the pilot's inability to control the airplane.NTSB NYC96LA117Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chatham, MAfailure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…