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 LAX00LA034Accident · Serious injuriesLimited investigationFinal reportHawker Siddeley Hunter T MK 7 · Mesa, AZThe fatigue failure and separation the stage 3 compressor blades due to corrosion pitting of the blade retention lug bores. A factor in the accident was the failure of the various post military surplus operators of this engine to incorporate the…NTSB IAD00LA005Accident · No injuriesLimited investigationFinal reportAnkenbruck SEA Hawk · Somerset, PAThe pilot's improper preflight which resulted in a loss of power due to contaminated fuel, and the pilot's failure to maintain aircraft control after the loss of power. A factor in the accident was fuel contamination.NTSB SEA00IA007Incident · No injuriesIncident investigationFinal reportCessna 172P · Wenatchee, WAThe failure of the pilots in both aircraft to maintain an adequate visual lookout. Haze was a factor.NTSB FTW00LA017Accident · No injuriesLimited investigationFinal reportWright Avid Flyer Mark IV · Seabrook, TXThe pilot's failure to maintain directional control during a downwind landing. Factors were his improper weather evaluation, the prevailing tailwind, and the engine vibration.NTSB LAX00LA023Accident · 1 fatalLimited investigationFinal reportLuhnau BD-5B · Boulder City, NVThe pilot's failure to secure an electrical wire terminal in the propeller pitch control circuit following a maintenance adjustment, which resulted in the propeller malfunctioning and going to a flat pitch. The flat pitch of the propeller produced a high drag…NTSB LAX00LA011Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Jean, NVThe pilot of the other airplane's failure to maintain an adequate visual lookout while taxiing for departure. Factors in the accident were: the narrow nature of the taxiway and the pilot of the other airplane's subsequent inability to S-turn for better…NTSB LAX00LA015Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Phoenix, AZThe airline's failure to fully review the obstruction clearances and revise the pushback procedures in an area of the ramp where new construction had impinged on the available ramp space. Also causal was the failure of the tug driver and the wing walkers to…NTSB FTW00LA006Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M18 · Weldon, ARThe cause of the accident was undetermined.NTSB LAX99LA323Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Beatty, NVthe failure of the injured passengers to remain seated with their seat belts fastened as directed by the captain.NTSB LAX99LA304Accident · Minor injuriesLimited investigationFinal reportGlover Teenie TWO · Chino, CAThe in-flight separation and loss of the carburetor fuel jet resulting from the pilot's improper installation of the component. Also causal was the pilot's failure to maintain an adequate airspeed margin following the loss of power, which resulted in an…NTSB NYC99LA221Accident · 1 fatalLimited investigationFinal reportValenza Volksplane VP-II · Westmore, VTThe pilot's failure to maintain adequate altitude/clearance from the trees. A related factor was the pilot's lack of familiarity with the airplane.NTSB LAX99LA298Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Prescott, AZThe pilot's failure to maintain an adequate clearance from ground obstructions during an off-airport landing. The pilot's inability to locate suitable thermal activity to remain aloft is a factor in the accident.NTSB IAD99WA062Accident · 2 fatalForeign investigationLearjet 35A · Adwa, EthiopiaNTSB NYC99LA215Accident · No injuriesLimited investigationFinal reportLet L-33-SOLO · Wellington, OHThe pilot's failure to attain the proper touchdown point. A factor related to the accident was a downdraft.NTSB SEA99FA146Accident · 2 fatalField investigationFinal reportRepublic RC-3 · Chimacum, WAThe inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…NTSB CHI99FA263Accident · No injuriesField investigationFinal reportUnderwood Brokaw Bullet · Oshkosh, WIthe pilot failed to maintain directional control of the airplane.NTSB CHI99LA200Accident · Serious injuriesLimited investigationFinal reportGillmore Benson B&M · Greencastle, INthe failure of the cyclic control rod. Factors were aircraft control not possible for the pilot.NTSB NYC99LA148Accident · No injuriesLimited investigationFinal reportAdams Rotorway EXEC-90 · Evington, VAThe pilot's selection of unsuitable terrain for a run on landing. A factor was the dirt bank.NTSB SEA99LA081Accident · 1 fatalLimited investigationFinal reportD. Wayne Smith Wayncraft 14 · Libby, MTCollision with terrain for undetermined reasons.NTSB IAD99LA047Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Ocean City, MDWas the pilot leaving the magneto switch in the on position while hand rotating the propeller.NTSB SEA99LA071Accident · No injuriesLimited investigationFinal reportBen Travis Kitfox IV · Carnation, WALoss of engine power due to a cracked engine impulse line, which disabled the fuel pump. A factor was the intentional ground loop by the pilot.NTSB SEA99LA061Accident · No injuriesLimited investigationFinal reportEugene Hughes Lancair IV · Butte, MTThe pilot's improper flare.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 LAX99LA167Accident · No injuriesLimited investigationFinal reportMassey Super Stallion · Shafter, CAThe pilot's decision to attempt a landing with insufficient runway remaining to stop the airplane.NTSB DEN99LA068Accident · No injuriesLimited investigationFinal reportWeatherly 201-C · Two Buttes, COThe pilot's selection of an unsuitable landing area. Factors associated with the accident were an unknown object in the landing area, a failure of a main landing gear tire, and the pilot's inadvertent ground loop/swerve.NTSB MIA99FA108Accident · 1 fatalField investigationFinal reportPushkar Hornet · Fort Lauderdale, FLthe pilot's (owner/builder) inadvertent aerodynamic stall of the airplane after a total loss of engine power. Factors were the pilot's improper maintenance action and his lack of total experience in the airplane type.NTSB NYC99LA072Accident · Minor injuriesLimited investigationFinal reportMiner Rotorway Exec 162F · Mechanicsburg, PAThe pilot's inadvertent induced dynamic rollover. A factor in the accident was the pilot's lack of helicopter experience.NTSB CHI99IA100Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Salina, KSThe ARTCC personnel failed to maintain radio communications with both airplanes and failed to maintain IFR separation standards. Factors relating to the incident were the FAA does not require cargo airplanes to be equipped with TCAS and neither airplane was…NTSB CHI99LA099Accident · No injuriesLimited investigationFinal reportCalkins Kitfox 5 · Waunakee, WIthe fracture of the trim actuator.NTSB NYC99IA062Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Columbus, OHa failure of the external o-rings in the nose landing gear steering module.NTSB IAD99LA030Accident · Minor injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Kutztown, PAwas the in-flight encounter with thermal sink over unsuitable terrain for landing.NTSB LAX99LA089Accident · Minor injuriesLimited investigationFinal reportStern Rotorway Exec 162F · Tucson, AZThe sudden development of a wind gust which resulted in the pilot losing control, and the helicopter's dynamic rollover when a skid contacted the ground.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 MIA99FA043Accident · 3 fatalField investigationFinal reportCessna 402B · Pahokee, FLThe pilot's failure to maintain adequate altitude during the approach.NTSB LAX99LA025Accident · No injuriesLimited investigationFinal reportde Havilland Tiger Moth DH 82A · Petaluma, CAFailure of the pilot in the Tiger Moth to see and avoid traffic. A contributing factor was the delayed reaction of the student pilot in the Cessna to initiate a turnoff of the taxiway once it became apparent that the other airplane did not see him.NTSB MIA99FA012Accident · Minor injuriesField investigationFinal reportAerospatiale ATR-42-300 · San Juan, PRThe pilot's failure to verify that the parking brake was applied prior to engine start, and the resultant inadvertent movement of the aircraft and collision with the ground power cart once No. 2 was started.NTSB MIA99LA015Accident · No injuriesLimited investigationFinal reportPeters Strojnik S2A · Pensacola, FLThe aircraft's uncontrolled climb after encountering a wind gust or thermal during landing flare without engine power resulting in the pilot having to force the aircraft onto the runway making a hard landing prior to the end of the runway.NTSB DCA99WA008Incident · No injuriesForeign investigationBoeing 727 · Point A Pitre, FranceNTSB NYC99LA011Accident · No injuriesLimited investigationFinal reportZeidler Sonerai II · Kenton, OHThe pilot's premature rotation and failure to obtain/maintain airspeed during the takeoff, which resulted in a stall and impact with the ground. Factors in this accident were the pilot's lack of total experience in tail-wheeled aircraft, and the nose high…NTSB NYC99LA008Accident · No injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Hilltown, PAThe pilot's misjudgment of altitude/distance which resulted in an in-flight collision which trees.NTSB LAX98LA302Accident · No injuriesLimited investigationFinal reportBognuda Livio IV Lancair · Reno, NVThe failure of the pilot-in-command to maintain adequate visual surveillance of the taxiway in front of his aircraft to avoid the collision.NTSB LAX98LA293Accident · Serious injuriesLimited investigationFinal reportPZL-Bielsko SZD-59 · Truckee, CAThe failure of the pilot to maintain sufficient airspeed which resulted in a inadvertent stall/spin.NTSB MIA98LA230Accident · No injuriesLimited investigationFinal reportBell 47D1 · Dawson, GAThe pilot's selection of unsuitable terrain for landing resulting in debris being blown up during landing resulting in damage to the tail rotor and loss of control.NTSB SEA98LA163Accident · No injuriesLimited investigationFinal reportSix/Huber RV-6 · Roseburg, ORA total loss of engine power for undetermined reasons.NTSB FTW98FA354Accident · 1 fatalField investigationFinal reportMooney M20J · Centennial, WYThe pilot's disregard of information provided in weather briefs, and his flight into known adverse weather in mountainous terrain which resulted in an in-flight collision with a mountain. Factors were rain and low ceiling/visibility.NTSB LAX98LA253Accident · No injuriesLimited investigationFinal reportYakovlev YAK-55M · Lincoln, CAThe pilot of the other aircraft's inadequate visual lookoutNTSB LAX98FA236Accident · 3 fatalField investigationFinal reportSikorsky CH-54A · Yucca Valley, CAAn in-flight main rotor blade spar separation as a result of the pilot-in-command's decision to continue to fly the aircraft after it had failed an AD directed BIM check. Factors were the failure of the operator's chief pilot to maintain proper supervision…NTSB CHI98FAMS1Accident · 2 fatalMissing aircraftFinal reportAero Vodochody Aero. Works L-39C · Traverse City, MIUndetermined.NTSB IAD98LA074Accident · No injuriesLimited investigationFinal reportAmerican Blimp ABC-A-60 · Lock Haven, PAthe pilot's encounter with unforecasted downdrafts.NTSB IAD98LA073Accident · No injuriesLimited investigationFinal reportSaab-Scania F-35 Draken · Oceana, VAThe pilot-in-command's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. A related factor was the pilot's unfamiliarity with the fuel system.