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 FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.NTSB SEA95LA007Accident · Minor injuriesLimited investigationFinal reportBony MB-1 · Madras, ORThe jamming of the rudder during due to undetermined reasons. Contributing to the accident was the pilot-in-command's failure to maintain adequate flying speed while attempting to take remedial action.NTSB SEA94LA244Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Bozeman, MTThe student pilot's improper compensation for wind. The crosswind was a factor.NTSB NYC94LA173Accident · No injuriesLimited investigationFinal reportSchleicher ASW15B · Dansville, NYThe pilot allowed the speed of the glider to get to low on final approach which resulted in a rapid descent, subsequent undershoot of the runway, and impact with a tree. A factor in this accident was a downdraft condition.NTSB ANC94FA130Accident · 1 fatalField investigationFinal reportPiper PA-18 · Gulkana, AKThe pilot's failure to maintain clearance from terrain.NTSB LAX94LA337Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Sedona, AZa tip over of the balloon and basket during a high wind landing due to the pilot's inability to compensate for the increased wind speed conditions during the final stages of the flight and landing.NTSB CHI94LA279Accident · No injuriesLimited investigationFinal reportHughes TH-55A · Houghton, MIfailure of the pilot to maintain control of the aircraft.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 LAX94LA273Accident · Minor injuriesLimited investigationFinal reportAdams Thorpe T-18 · Stockton, CAA vapor lock induced engine failure due to inadequate thermal shielding of the fuel pump and lines. Soft terrain in the landing area was a factor.NTSB CHI94LA198Accident · No injuriesLimited investigationFinal reportBeech 18 · Belleville, MIthe failure of the fuel line on the unique STC'd engine installation. A related factor is the improper installation of a fuel line by company maintenance personnel.NTSB ATL94LA118Accident · 1 fatalLimited investigationFinal reportMonnett Moni · Ashville, NCThe failure of the pilot to maintain control of the aircraft. A factor in the accident was the thunderstorm off the departure end of the runway.NTSB ATL94LA117Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Bainbridge, GAThe loss of engine power for undetermined reasons.NTSB SEA94LA143Accident · No injuriesLimited investigationFinal reportWray KR-2 · Puyallup, WAAn improperly functioning fuel boost pump.NTSB LAX94LA222Accident · No injuriesLimited investigationFinal reportHillberg EH-101 · Corona, CAthe pilot's loss of control of the helicopter while hovering downwind. A lack of test-flight data to establish the aircraft's performance limitations was a factor in the accident.NTSB LAX94LA221Accident · Minor injuriesLimited investigationFinal reportBell 206A · Ukiah, CAthe pilot's inadequate compensation for the existing wind conditions which resulted in a loss of tail rotor effectiveness event and a subsequent loss of directional control.NTSB SEA94LA119Accident · 1 fatalLimited investigationFinal reportHallstrom BD-5B · St. George, UTCarburetor contamination and low output, and the pilot's improper decision to attempt to continue the approach. A factor was the pilot's lack of recent flight experience.NTSB CHI94LA145Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rochelle, ILthe pilot's inadequate use of carburetor heat. Factors associated with the accident were carburetor icing conditions and rough terrain.NTSB CHI94DEE01Accident · 2 fatalFinal reportRemote Sensing Cirrus VK-30 · Lk In The Hills, ILfuel starvation resulting from the modification of the fuel system. A factor was the modification to the fuel system.NTSB NYC94LA072Accident · Serious injuriesLimited investigationFinal reportRandolph Flagg Boredom Fighter · Norridgewock, METhe loss of engine power for undetermined reasons.NTSB CHI94IA095Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace ATP · Mosinee, WIthe inadequate design of the PBSI electrical switch(es), and the operator's failure to expeditiously implement corrective Service Bulletins.NTSB FTW94LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally RX7 · Albuquerque, NMPilot's failure to maintain aircraft control. A factor was the gusty winds.NTSB LAX93LA370Accident · No injuriesLimited investigationFinal reportBeech A-36 · Firebaugh, CAthe CFI's inadequate supervision of the flight and his delay in taking remedial action; the dual student's premature liftoff and improper use of the flight controls. The high vegetation and soft terrain were factors in this accident.NTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.NTSB MIA93LA196Accident · Minor injuriesLimited investigationFinal reportSukhoi SU-26M · Natchez, MSThe pilot-in-command's failure to accurately calculate fuel consumption resulting in total loss of engine power due to fuel exhaustion while approaching the destination airport.NTSB ANC93IA176Incident · No injuriesIncident investigationFinal reportSikorsky C54A · Anita Bay, AKThe separation of the turbine blade from the power turbine disc.NTSB MIA93LA185Accident · Serious injuriesLimited investigationFinal reportKeuthan Buccaneer II · Cocoa, FLFailure of maintenance personnel to properly reinstall a bolt and nut in the elevator control linkage, which resulted in a disconnect of the linkage and loss of elevator control.NTSB SEA93LA202Accident · Serious injuriesLimited investigationFinal reportKope Zenith CH200 · Waterville, WAA short in the electrical wiring to the fuel pump.NTSB CHI93DEC01Accident · Minor injuriesFinal reportBradford Pietenpol Skyscout · Eaton Rapids, MIthe pilot's failure to maintain airspeed which resulted in an inadvertant stall. Factors related to the accident were the low altitude and the restricted movement of the carburetor needle.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 SEA93LA174Accident · 2 fatalLimited investigationFinal reportBrauch Glasair · Blanding, UTThe loss of engine power resulting from inadequate maintenance inspection by the pilot, a leak from loose fuel system line fittings, and fuel exhaustion. A factor relating to the accident was the rough/uneven terrain.NTSB CHI93LA295Accident · Minor injuriesLimited investigationFinal reportGardner SEA RAY · Oshkosh, WIThe pilot in command's not maintaining proper climb rate. A factor was the abrupt control interference by the passenger.NTSB DEN93LA086Accident · Serious injuriesLimited investigationFinal reportBalloon Works 7B-15 · Colorado Sprgs, COThe passenger's failure to assume the proper landing position as instructed by the pilot in command. A factor was: the high wind.NTSB SEA93LA150Accident · No injuriesLimited investigationFinal reportHoopes Hummelbird · Salt Lake City, UTA fractured crankshaft.NTSB DEN93FA075Accident · 1 fatalField investigationFinal reportWiley Pitts S-1-E · Walters, OKPerformance of an aerobatic maneuver at an altitude insufficient for adequate terrain clearance.NTSB NYC93LA119Accident · No injuriesLimited investigationFinal reportStart & Flug H-101 Salto · Columbus, OHThe pilot's selection of unsuitable terrain for landing. A factor related to the accident was the interruption of the glider pilot's planned approach by a powered airplane.NTSB FTW93LA188Accident · No injuriesLimited investigationFinal reportReims Cessna FA 150K · Willis, TXLoss of partial engine power due to stuck exhaust valve and exhaust and intake valve binding with carbon buildup. A factor was the lack of suitable terrainNTSB MIA93LA142Accident · No injuriesLimited investigationFinal reportSayer, Trevor A. Rans S-12 · New Smyrna Bch, FLFailure of the pilot to maintain adequate airspeed and inadvertent stall/spin. Contributing to the accident was total loss of engine power due to fuel starvation. This was due to improper placement of a component of the fuel system by the builder/pilot.NTSB DEN93LA065Accident · No injuriesLimited investigationFinal reportCessna 182A · Stratton, COThe selection of unsuitable terrain for a precautionary landing by the pilot in command. A factor was: misjudging the deteriorating weather.NTSB CHI93LA186Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Derby, KSThe pilot in command's misjudged approach to landing.NTSB LAX93LA228Accident · No injuriesLimited investigationFinal reportWSK PZL KR-03A · Avenal, CAThe glider's encounter with the downdraft. Contributing to this accidents were the turbulence and the powerlines.NTSB SEA93LA116Accident · Serious injuriesLimited investigationFinal reportRambow Monnett Moni · Ritzville, WAThe improper landing flare.NTSB FTW93LA146Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec PZL-M-18 · De Witt, ARCompensation for wind improper by pilot. Factors were tailwind and downdraftNTSB FTW93LA124Accident · No injuriesLimited investigationFinal reportViolet Dragonfly · Carlsbad, NMThe improper installation of the control stick assembly and the subsequent separation of the flight control stick assembly from the mountNTSB MIA93LA088Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S1-T · Naples, FLThe installation of an improper designed intake tube and air filter by the nonmechanic rated pilot-in-command, which resulted in moisture build up and collapse of the air filter, which resulted in blockage of air flow to the engine and loss of engine power.…NTSB LAX93LA148Accident · 1 fatalLimited investigationFinal reportLangerud Varieze · Zenia, CAThe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The low ceiling was a factor.NTSB LAX93LA135Accident · Serious injuriesLimited investigationFinal reportDowner Aircraft Industries KR-1 · Prescott, AZThe total loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing area at the time of the power interruption.NTSB LAX93LA124Accident · 1 fatalLimited investigationFinal reportBertone Challenger II · Boulder City, NVThe pilot's loss of airplane control due to physical impairment as a result of either drugs or other cardiovascular reasons, or both.NTSB LAX93LA076Accident · Minor injuriesLimited investigationFinal reportCurtiss JN-4D · Livermore, CAThe shearing of the number 8 cylinder rocker arm support pedestal/coolant housing retaining bolts. Contributing to the accident was a loss of engine coolant.NTSB NYC93LA047Accident · No injuriesLimited investigationFinal reportBeech C-24R · Meriden, CTThe pilot's improper airplane preflight, resulting in no airspeed indication during takeoff, and the subsequent abort with insufficient runway available to stop prior to a collision with the terrain.