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 ANC06LA130Accident · Minor injuriesLimited investigationFinal reportMcNabb Bushmaster · Delta Junction, AKAn electrical short that disabled the electronic ignition system of the airplane's engine during the final approach phase for landing, which resulted in a forced landing and collision with high vegetation. A factor contributing to the accident was the failure…NTSB DEN06WA122Accident · No injuriesForeign investigationCessna C210P · Hoexter, GermanyNTSB SEA06CA173Accident · No injuriesData collectionFinal reportCessna 182RG · Fairfield, UTThe failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…NTSB LAX06CA278Accident · No injuriesData collectionFinal reportGlaser Dirks DG 300 · Truckee, CAthe pilot's misjudged landing approach that led to a runway overshoot. A contributing factor was the pilot's hypoxic condition.NTSB SEA06LA167Accident · Minor injuriesLimited investigationFinal reportKinnson Lancair IV-P Turbine · Helena, MTThe total loss of engine power as a result of turbine over temperature due to the pilot's failure to follow proper procedures for engine operation. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB LAX06LA270Accident · No injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G109 · Glendale, AZThe failure and separation of one propeller blade for undetermined reasons.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 CHI06CA233Accident · No injuriesData collectionFinal reportHoyt Kolb Mark III Clsc · Lakeville, MNThe pilot's failure to maintain clearance from the crops which resulted in the subsequent impact with the ground.NTSB CHI06CA217Accident · No injuriesData collectionFinal reportVeltman CH701 · Owosso, MIThe pilot's inadequate preflight planning and inadequate compensation for the tailwind condition. Factors included the tailwind and the power lines.NTSB CHI06CA219Accident · Serious injuriesData collectionFinal reportShempp-Hirth Discuss B · Tipton, INThe glider pilot's improper in-flight decision to continue searching for thermal lift, instead of landing when the glider was in range of a suitable landing area. Contributing factors to the accident was the lack of thermal lift which resulted in a hard…NTSB DEN06LA103Accident · 1 fatalLimited investigationFinal reportAyres S2R-G10 · Dexter, NMThe pilot's failure to remain clear of the airplane's propeller resulting in the propeller contacting the pilot and causing fatal injuries to the pilot.NTSB SEA06FA142Accident · 1 fatalField investigationFinal reportHawker Siddeley MK-58A Hunter · Hillsboro, ORLoss of aircraft control for undetermined reasons during the takeoff sequence.NTSB SEA06LA133Accident · No injuriesLimited investigationFinal reportNanchang China CJ-6 · Brewster, WAThe failure of the engine's three planetary gears for undetermined reasons. A factor contributing to the accident was the tree orchard.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 CHI06LA164Accident · 1 fatalLimited investigationFinal reportMiller Zenair Cricket MC-12 · Lee's Summit, MOThe pilot's failure to maintain airspeed while operating in the traffic pattern after the loss of power in one engine, resulting in an inadvertent stall/spin. An additional cause was the loss of engine power in one of the two engines for undetermined reasons.NTSB LAX06CA207Accident · Minor injuriesData collectionFinal reportRonald D. Murray RV-6A · Hesperia, CAthe pilot's inadequate in-flight planning and selection of the wrong runway, which resulted in a downwind landing, the pilot's failure to attain the proper touchdown point, and a runway overrun.NTSB CHI06LA157Accident · 1 fatalLimited investigationFinal reportGood RV-6A · Peru, ILFailure of the pilot of the second airplane in the formation to maintain clearance with the lead airplane during the overhead recovery maneuver prior to landing.NTSB CHI06CA155Accident · No injuriesData collectionFinal reportMcFarland Rotorway Exec · Mooresville, INAn in-flight fire for undetermined reasons.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 DEN06CA085Accident · No injuriesData collectionFinal reportBrent W. Brown Murphy Moose · St. Francis, KSthe pilot's failure to open the fuel selector valve, resulting in fuel starvation. Contributing factors were the pilot's failure to use a checklist, his attention being diverted, and the fence.NTSB SEA06FA116Accident · 3 fatalField investigationFinal reportLciv Lancair IV-P Propjet · Provo, UTThe pilot's failure to maintain altitude/clearance during a VFR approach, which resulted in an in-flight collision with water. Contributing factors were the dark night light conditions and the low clouds.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 LAX06LA185Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries HK 36 TTC · Payson, AZpartial loss of engine power for undetermined reasons.NTSB NYC06CA118Accident · Minor injuriesData collectionFinal reportEspinal Velocity Jet 900 · Millbrook, NYThe pilot/owner's inadequate preflight which resulted in a partial loss of engine power due to a clogged fuel vent.NTSB SEA06CA102Accident · No injuriesData collectionFinal reportHughes 369A · Banks, ORThe pilot's failure to maintain rotor rpm while performing a simulated autorotation, which resulted in a hard landing. A contributing factor was the pilot's incorrect interpretation of the examiner's instruction to add power.NTSB LAX06LA166Accident · No injuriesLimited investigationFinal reportMcKenzie Lancair IV-P Turbine · San Diego, CAThe collapse of the left main gear for undetermined reasons. A factor was the pilot's inadequate remedial action in response to the left main gear not locked warning light by not attempting to manually extend the gear to ensure it was fully down and locked.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 LAX06LA153Accident · 1 fatalLimited investigationFinal reportRonald R Russell RV-6 · Death Valley, CAa fuel starvation induced loss of engine power due to a likely vapor lock condition in the fuel lines.NTSB SEA06CA080Accident · No injuriesData collectionFinal reportPitrolo GL-25 · Worden, MTThe loss of engine power due to failure of both electronic ignition systems. A contributing factor was the lack of suitable terrain for the forced landing.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 SEA06LA074Accident · No injuriesLimited investigationFinal reportCentral Copters Lancair IV-P · Belgrade, MTThe total loss of drive power to the aircraft's propeller while on a visual final approach, due to the decoupling of the quill shaft between the reduction gearbox and the engine power section. Factors include a dark night, no suitable terrain on which to…NTSB CHI06LA112Accident · No injuriesLimited investigationFinal reportDassault Falcon 2000 · Stilesville, INThe separation of the left engine cowling during cruise flight for undetermined reasons.NTSB NYC06LA092Accident · Minor injuriesLimited investigationFinal reportMichaud KR2S · North Andover, MAA partial loss of engine power for undetermined reasons, during the initial climb, which resulted in a forced landing into trees.NTSB DEN06LA058Accident · No injuriesLimited investigationFinal reportEldredge NXT · Glenwood, NMthe loss of engine power due to the partial failure of the crankcase nose seal for undetermined reasons. A contributing factor was the pilot's diminished visibility during the forced landing due to oil on the windscreen, resulting in a runway excursion and…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 CHI06LA088Accident · No injuriesLimited investigationFinal reportIrwin Sonex 2180 · Rockford, ILThe loss of engine power due to the restricted movement of the throttle cable during cruise flight. A factor in the accident was the trees contacted during the forced landing.NTSB LAX06FA124Accident · 2 fatalField investigationFinal reportAero Vodochody L39 · California City, CAThe flight crew's failure to maintain terrain clearance during an intentionally performed course reversal turn at low altitude.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 LAX06LA105Accident · 2 fatalLimited investigationFinal reportHooker Zodiac 601XL · Oakdale, CAthe structural failure of the wings for undetermined reasons.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 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 LAX06LA096Accident · 1 fatalLimited investigationFinal reportReichel Lancair 360 · Santa Ynez, CALoss of airplane control for undetermined reasons.NTSB ANC06FA018Accident · 1 fatalField investigationFinal reportAero Vodochody L-39MS · Ketchikan, AKThe pilot's failure to follow published instrument landing procedures and his descent below approach minimums during an IFR circle to land approach, which resulted in the airplane striking the ocean and a loss of engine power. Factors contributing to the…NTSB CHI06LA071Accident · 1 fatalLimited investigationFinal reportVillarubia RV-6 · Decatur, NEAn inflight collision with the terrain for undetermined reasons.NTSB CHI06LA069Accident · No injuriesLimited investigationFinal reportZilz Zenith CH801 · Moscow Mills, MOA loss of engine power due to inadequate design of the engine compartment which resulted in inadequate engine cooling and fuel starvation due to vapor lock. Factors associated with the accident were the utility pole and trees which were contacted during the…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 NYC06LA042Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Dunkirk, NYThe Piper Malibu pilot's failure to use the correct radio frequency for traffic advisories, and his selection of the wrong, inactive runway, which resulted in an on-ground collision with another airplane while landing.NTSB MIA06LA028Accident · No injuriesLimited investigationFinal reportMestas Felix R Velocity LWFG-E · Punta Gorda, FLA loss of engine power for undetermined reasons.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.