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 DFW05LA110Accident · Minor injuriesLimited investigationFinal reportFriddle Super Cub Replica · Springtown, TXThe pilot's failure to compensate for wind conditions and his failure to maintain aircraft control during a go-around, which resulted in collision with trees.NTSB LAX05LA144Accident · Serious injuriesLimited investigationFinal reportBishop RV6A · Dulzura, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with rising mountainous terrain.NTSB CHI05CA100Accident · Minor injuriesData collectionFinal reportMitchell KR-2S · Cameron, MOThe loss of engine power for an undetermined reason and the misjudged landing flare which resulted in the bounced landing. Additional causes were the improper recovery from the bounced landing and the inadvertent stall. A factor was the pilot's lack of…NTSB DFW05LA102Accident · 2 fatalLimited investigationFinal reportSpearman Raptor · Bogalusa, LAThe pilot's failure to maintain control of the airplane. A contributing factor was the pilot's lack of experience in the make/model airplane.NTSB CHI05LA094Accident · No injuriesLimited investigationFinal reportTschida Glastar · Kendallville, INA loss of engine power due to fuel starvation as a result of the fuel flow restriction at the internal engine fuel filter due the presence of the silicone sealant material. Contributing factors were the unsuitable terrain for a forced landing short of the…NTSB CHI05LA082Accident · 2 fatalLimited investigationFinal reportMatthews Christen Eagle II · Iowa City, IAThe pilot not maintaining airplane control and airspeed, and the stall/spin encountered during aerobatic maneuvering. A factor in the accident was the pilot exceeding the published airplane's aft center of gravity limit and a factor in the pilot rated…NTSB LAX05LA115Accident · No injuriesLimited investigationFinal reportSukhoi SU-26 · Tucson, AZthe pilot's inadequate in-flight planning and fuel consumption calculations, which resulted in fuel exhaustion.NTSB DFW05LA080Accident · Minor injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Shreveport, LAThe pilot's misjudgment of airspeed and his failure to abort the landing resulting in an overrun. A contributing factor was the wet runway.NTSB MIA05CA074Accident · No injuriesData collectionFinal reportDgflugzeugbau DG-800S · Clermont, FLThe pilots failure to maintain airspeed which resulted in the glider stalling and impact with trees during the uncontrolled descent.NTSB DEN05LA059Accident · 1 fatalLimited investigationFinal reportBourgeois-Avid Flyer MK IV · Kaycee, WYthe pilot's failure to maintain airspeed which resulted in a stall.NTSB ATL05CA053Accident · Serious injuriesData collectionFinal reportBennett Ra Oliver Zodiac CH 601 HDS · Mt. Olive, NCRupture of the engine's cooling system radiator, which allowed steam to fill the cockpit.NTSB ATL05LA052Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Macedonia, SCThe fatigue cracking of the planetary gear housing, which resulted in the loss of engine power.NTSB ANC05LA033Accident · 2 fatalLimited investigationFinal reportTwente Pitts Model 12 · Marion, MSThe pilot's failure to maintain control of the airplane while performing a low altitude, aerobatic maneuver, which resulted in an uncontrolled descent, and an in-flight collision with terrain. A factor associated with the accident was the initiation of a low…NTSB IAD05LA033Accident · No injuriesLimited investigationFinal reportGhiles MCR-01 VLA · Cincinnati, OHA total loss of engine power due to an oil hose collapse, which resulted in failure of the #4 connecting rod.NTSB LAX05LA060Accident · Minor injuriesLimited investigationFinal reportEurocopter France EC135T1 · Casa Grande, AZthe separation of a main rotor control link due to improper maintenance installation.NTSB DEN05CA040Accident · No injuriesData collectionFinal reportDaniels Vans RV-8 · Albuquerque, NMthe pilot's failure to maintain directional control resulting in a ground loop.NTSB SEA05CA027Accident · Minor injuriesData collectionFinal reportBreit Zodiac (CH-601-HDS) · Everett, WAThe pilot's failure to maintain aircraft control immediately after takeoff. A factor was the wake turbulence from the preceding airplane.NTSB DFW05CA042Accident · Minor injuriesData collectionFinal reportOhlemeier/Stratton RV-7A · Gordonville, TXThe pilot's misjudged flare. Contributing factors were the uphill slope of the runway and the soft condition of the landing area.NTSB ATL05LA035Accident · No injuriesLimited investigationFinal reportBell UH-1H · Rockford, ALThe pilot's failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tree.NTSB CHI05CA032Accident · Serious injuriesData collectionFinal reportOlson Sonex · Oconomowoc, WIThe loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…NTSB MIA05LA029Accident · Serious injuriesLimited investigationFinal reportJoseph R. Sirgo Aquilla · Eustis, FLThe passenger's control interference, which resulted in a loss of control, and the airplane impacting a hangar during takeoff/initial climb.NTSB DEN05IA025Incident · No injuriesIncident investigationFinal reportBlair-American USA · Fort Collins, COthe Blair-American and the Cessna pilot's inadequate visual lookout, and student pilot's failure to give right-of-way to a landing aircraft, which resulted in a runway incursion and subsequent collision. Contributing factors include the student instructor's…NTSB MIA05FA017Accident · 1 fatalField investigationFinal reportCessna P206 · Jacksonville, FLThe improper setting of the elevator trim by the pilot-in-command, his failure to follow the checklist related to elevator trim setting, and his failure to maintain VS during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and…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 ATL05LA017Accident · Serious injuriesLimited investigationFinal reportDavid Nielson Ison Hi-Max 1700 · Hendersonville, NCThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB NYC05LA012Accident · 1 fatalLimited investigationFinal reportDouglas Adventure Air Ampib · Pawtucket, RIThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall.NTSB DFW05LA012Accident · 1 fatalLimited investigationFinal reportHuber DR 107 · Fletcher, OKThe pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.NTSB LAX05LA014Accident · 1 fatalLimited investigationFinal reportAMS Flight Carat A · Minden, NVthe pilot's likely inadvertent entry into instrument meteorological conditions created by the rapidly changing cloud conditions that resulted in his spatial disorientation and exceeding the glider's ultimate design loads while in a spiral dive, which resulted…NTSB SEA05LA133Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hyak, WAThe loss of aircraft control during climb to cruise due to an undetermined flight control malfunction.NTSB ATL05LA005Accident · Serious injuriesLimited investigationFinal reportMoody Easy Riser · Augusta, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin, and subsequent collision with the ground.NTSB CHI05CA005Accident · No injuriesData collectionFinal reportBuss Rotorway Exec · Eden Prairie, MNThe pilot's inadvertent deactivation of the battery switch leading to the helicopter's loss of engine power on base leg. A factor was the crops he encountered during the emergency landing.NTSB ANC05LA003Accident · No injuriesLimited investigationFinal reportScan 30 · Anchorage, AKAn in-flight fire during cruise flight for an undetermined reason.NTSB SEA05LA008Accident · No injuriesLimited investigationFinal reportHiggins Acro-Sport II · Coeur d'Alene, IDThe airplane's wood propeller separated from the airplane during cruise. A factor was the ditch that the airplane impacted during the landing roll subsequent to the forced landing.NTSB DEN05FA002Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Santa Fe, NMthe pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…NTSB FTW04CA240Accident · No injuriesData collectionFinal reportCarter-Jones Volmer Sportsman · Grand Prarie, TXThe pilot's failure to complete a pre-landing checklist, which resulted in a gear down landing on the water. A factor was the pilot's diverted attention as a result of abnormal engine indications.NTSB FTW04CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Haskell, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB LAX04LA322Accident · 2 fatalLimited investigationFinal reportWolf Glassair IIS · Mesa, AZa partial loss of power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and a collision with terrain.NTSB CHI04IA260Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Chicago, ILAn in-flight collision with a flock of birds during climb out after takeoff, which damaged the left engine fan module and ruptured a fuel line to the fuel-oil cooler causing an engine fire.NTSB LAX04CA316Accident · No injuriesData collectionFinal reportSmith S-51D · Lancaster, CAthe pilot's misjudged landing flare, failure to correct the descent rate, and failure to execute a go-around during an unstablized landing approach.NTSB LAX04LA313Accident · 2 fatalLimited investigationFinal reportRedgate Europa Classic · Marble Canyon, AZan in-flight collision with terrain for undetermined reasons.NTSB NYC04LA201Accident · No injuriesLimited investigationFinal reportPZL 101 · Chazy, NYThe total loss of engine power due to the fractured crankshaft.NTSB ANC04LA098Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-3 · McGrath, AKThe pilot's inadequate in-flight planning/decision making, his continued VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Factors contributing to the accident were low ceilings due to smoke, rain, and mist.NTSB CHI04LA245Accident · Serious injuriesLimited investigationFinal reportFall Cub · Rockville, INThe fuel starvation encountered due to the builder's inadequate fuel system design and the subsequent loss of engine power during a maneuver for the landing approach. Factors were the tree and corn.NTSB ANC04LA093Accident · 1 fatalLimited investigationFinal reportHudson Hiperbipe SNS-7 · Palmer, AKThe pilot's failure to maintain control of the airplane, which resulted in an uncontrolled descent and subsequent in-flight collision with trees. A factor associated with the accident was a low altitude maneuver preformed by the pilot just after takeoff.NTSB MIA04LA111Accident · No injuriesLimited investigationFinal reportRobert J. Labonte Defiant · DeLand, FLThe failure of the pilot to fully extend the nose landing gear resulting in collapse of it during the landing roll. A contributing factor in the accident was the lack of a nose landing gear down and locked indicator.NTSB FTW04LA196Accident · Minor injuriesLimited investigationFinal reportEverett Vidrine Dragonfly · Covington, LAthe pilot's inadequate preflight planning which failed to assure adequate takeoff performance for the airplane to clear obstacles. A contributing factor was the pilot's failure to abort the takeoff.NTSB LAX04LA274Accident · 1 fatalLimited investigationFinal reportFinke Rotorway Exec 162F · Cameron Park, CAThe owner-builder's improper main rotor blade (MRB) maintenance/installation by under torquing the blade retaining nut.NTSB DEN04LA108Accident · No injuriesLimited investigationFinal reportDavis-Zenair Stol CH 801 · Erie, COimpact with terrain during a forced landing following a loss of engine power for underdetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB FTW04CA192Accident · Minor injuriesData collectionFinal reportRotorway Exec · Conroe, TXThe loss of engine power due to the tripped fuel pump circuit breaker which resulted in the failure of the electric fuel pump.NTSB CHI04CA190Accident · No injuriesData collectionFinal reportSelby Dean KR-2-SS · Lake Elmo, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control. A related factor was the crosswind.