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 ANC08CA065Accident · No injuriesData collectionFinal reportde Havilland DHC-3 · Talkeetna, AKThe pilot's selection of an unsuitable landing site, which resulted in an overload failure of the tail ski assembly during the landing roll.NTSB SEA08LA114Accident · No injuriesLimited investigationFinal reportCanup Titan Tornado S · Council, IDThe failure of the tip of the wood propeller due to damage caused by a foreign object.NTSB LAX08FA122Accident · 3 fatalField investigationFinal reportCarlton M. Cadwell Lancair IV-P · Mesa, AZThe pilot's failure to maintain an adequate airspeed during climb out resulting in an aerodynamic stall/spin.NTSB DFW08LA108Accident · Serious injuriesLimited investigationFinal reportWoods Challenger II · Corning, ARThe pilot's failure to maintain clearance from transmission lines. A contributing factor was the low altitude selected by the pilot.NTSB MIA08CA085Accident · No injuriesData collectionFinal reportThomas J. Dorsey Searey · Mount Dora, FLThe pilot's failure to verify the position of the landing gear prior to making a water landing.NTSB LAX08LA078Accident · 1 fatalLimited investigationFinal reportJenkins RV-7A · Winslow, AZThe pilot's failure to maintain an adequate airspeed that resulted in a stall/spin.NTSB NYC08LA107Accident · Serious injuriesLimited investigationFinal reportChrister Vans RV9-A · Princeton, NJA loss of engine power due to the pilot/owner's improper installation of a new ignition/fuel control system for the engine. Contributing was the unsuitable terrain for a forced landing.NTSB LAX08LA063Accident · 1 fatalLimited investigationFinal reportWilson RV-7 · Nevada City, CAThe improper installation of the fuel pump, leading to a fatigue failure of the pump's lever arm and subsequent loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB LAX08LA056Accident · No injuriesLimited investigationFinal reportSmith Zodiac 601XL · Murrieta, CAA loss of engine power due to fuel starvation, which was induced by the electrical system lacking sufficient power to run all of the electrical devices on the airplane and the electrical fuel pump.NTSB MIA08LA048Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Marathon, FLThe pilot’s failure to maintain control of the airplane during a water landing.NTSB NYC08CA093Accident · No injuriesData collectionFinal reportJames Dayton Pit Bull JD-3 · Leonardtown, MDThe pilot's improper flare during the landing.NTSB CHI08CA063Accident · No injuriesData collectionFinal reportNewbold Newbold 2000 · Newark, OHThe CFI's failure to maintain control of the gyrocopter which resulted in settling with power and the subsequent hard landing. Factors associated with the accident were the CFI's decision to excessively flare the gyrocopter at a low altitude.NTSB DEN08CA045Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Gunnison, COThe pilot's failure to maintain directional control of the airplane during takeoff resulting in the airplane hitting a snowbank and subsequently, the ground.NTSB NYC08LA062Accident · No injuriesLimited investigationFinal reportBoeing B747-433BCF · New York, NYThe infringement of the parked EMB-190 into the airport movement area, and the B-747 crew's failure to maintain separation between the airplanes in conditions of darkness. Contributing to the accident was the contaminated ramp, which obscured airport markings.NTSB MIA08CA025Accident · No injuriesData collectionFinal reportMessing Roy Sonex · New Smyrna Beac, FLThe pilot's failure to maintain altitude/clearance while on final approach for landing.NTSB LAX08CA033Accident · Minor injuriesData collectionFinal reportSenft/Anderson/salmon C-5 · Tucson, AZa total loss of engine power due to the failure of the number 3 articulating rod.NTSB DEN08WA037Accident · 1 fatalForeign investigationCirrus Design SR-20 · Jagel, GermanyNTSB CHI08LA037Accident · 2 fatalLimited investigationFinal reportPadelt PG37-1 · Hampton, IAThe pilot's inadequate in-flight planning which resulted in the failure to maintain clearance with the power lines. Contributing to the accident was the power line.NTSB DEN08LA038Accident · No injuriesLimited investigationFinal reportRotorway Exec 162-F · New Century, KSWhile on approach the tail rotor spar failed due to metal fatigue .NTSB NYC08LA024Accident · 2 fatalLimited investigationFinal reportBlondin 601HDS · Farmington, DEThe reason for this occurrence could not be determined.NTSB NYC08FA023Accident · 1 fatalField investigationFinal reportDaniel R. Lloyd Trish's Ride Home · Greenville, PAThe pilot/builder's improper installation of the electrical system.NTSB LAX08CA019Accident · Minor injuriesData collectionFinal reportPloof Progressive Aerodyne's Searey · Lake Berryessa, CAThe airplane's encounter with a submerged object during landing in water, which resulted in the airplane nosing over.NTSB CHI08CA008Accident · Serious injuriesData collectionFinal reportVeltman, Robert CH701 · Owosso, MIThe pilot inadvertantly turned the fuel selector to the off position and failed to maintain aircraft control during the subsequent loss of engine power. A factor associated with the accident was the pilot's change in his normal habit pattern.NTSB MIA08LA007Accident · No injuriesLimited investigationFinal reportCatchot Angus Kitfox IV · Crescent City, FLThe loss of engine power for undetermine reasons.NTSB DFW08LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · New Iberia, LAThe private pilot's failure to maintain main rotor rpm, which resulted in a hard landing and subsequent rollover. Also causal was the flight instructor's delayed remedial action. A factor was the lack of suitable terrain the forced landing.NTSB DFW08CA016Accident · No injuriesData collectionFinal reportWard RC 350 HP · Magnolia, TXThe in-flight fire and loss of engine power as a result of a ruptured fuel line for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA08CA010Accident · No injuriesData collectionFinal reportWelch RV-9 · Bigfork, MTFuel starvation while on downwind for landing. The pilot's inadequate in-flight fuel management planning was a factor.NTSB DFW08LA012Accident · Serious injuriesLimited investigationFinal reportFormhals RV-8 · San Antonio, TXThe automobile driver's failure to yield right-a-way to the airplane before crossing an active runway.NTSB SEA08LA007Accident · Minor injuriesLimited investigationFinal reportHaring Clay RV8A · Brigham City, UTFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. Factors include an inaccurate fuel quantity measuring system, and soft terrain encountered during the landing roll.NTSB LAX08LA004Accident · No injuriesLimited investigationFinal reportYakovlev YAK-50 · El Cajon, CAThe inadequate visual lookout of the pilot of another airplane and his failure to maintain clearance from a taxiing airplane.NTSB LAX08CA003Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hemet, CAThe pilot's failure to maintain a proper descent rate due to his failure to close the air brake and/or partially retract the flaps during an encounter with lost lift on final approach.NTSB DFW08LA001Accident · Serious injuriesLimited investigationFinal reportIndus T211 Thorpedo · Denton, TXThe pilot's improper preflight planning and preparation which led to his getting lost on a local area flight and his failure to maintain clearance from the trees. Contributing to the accident were the prevailing dark night illumination and the pilot's lack of…NTSB CHI08CA001Accident · No injuriesData collectionFinal reportDusenberry 1905 Wright Flyer · Dayton, OHThe altitude not maintained by the pilot for a turning maneuver.NTSB MIA07LA158Accident · No injuriesLimited investigationFinal reportFly BY Sea Comp AIR 1 · Rockledge, FLLoss of engine power for undetermined reasons.NTSB SEA07FA263Accident · 1 fatalField investigationFinal reportAero Vodochody L-39C · Reno, NVThe pilot's encounter with wake turbulence while maneuvering over a race course. Contributing to the accident was the low altitude at which the encounter occurred.NTSB MIA07CA151Accident · No injuriesData collectionFinal reportSchleicher ASW-24E · Morganton, NCThe failure of the pilot to maintain airspeed while turning base to final resulting in the left wing contacting the ground.NTSB LAX07CA266Accident · No injuriesData collectionFinal reportAmerican Air Racing Thunder Mustang · Reno, NVFire resulting from vegetation contacting hot brakes following an aborted takeoff.NTSB CHI07FA286Accident · 2 fatalField investigationFinal reportYakovlev Yak 52 · Lake-in-Hills, ILThe airplane descended and impacted terrain during initial climb for undetermined reasons. Contributing to the accident was the soft, uphill terrain.NTSB MIA07FA137Accident · 5 fatalField investigationFinal reportBeech A36 · Elizabethton, TNThe poor in-flight planning by the pilot-in-command for flying towards rising terrain with inadequate clearance.NTSB MIA07CA138Accident · No injuriesData collectionFinal reportAnthony J. Bencivenga Aventura II · Okeechobee, FLThe pilot's failure to maintain directional control of the airplane during landing, which resulted in the pilot being inadvertently ejected and the airplane's impact with the water during an uncontrolled descent.NTSB DEN07LA148Accident · 2 fatalLimited investigationFinal reportElliott Cirrus VK30 · Watrous, NMThe pilot's failure to maintain control of the airplane during a forced landing that resulted in a hard landing. Contributing to the accident was the ruptured pressurized oil line.NTSB NYC07LA201Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-31 · Markham, VAThe pilot's failure to maintain aircraft control. Contributing to the accident were a fuel leak as reported by the pilot, the pilot's diverted attention, a low cloud ceiling, and fog.NTSB CHI07LA273Accident · 1 fatalLimited investigationFinal reportTerpstra Exec 162F · Winamac, INThe inadequate installation of the horizontal stabilizer bracket by the pilot, the fatigue fracture seperation of vertical stabilizer bracket during cruise flight, and the aircraft control not possible by the pilot.NTSB CHI07LA272Accident · 1 fatalLimited investigationFinal reportClifford Titan Tornado II · Henning, MNThe inadvertent stall and low airspeed while maneuvering. A contributing factor was the low altitude of the maneuver.NTSB DFW07LA183Accident · 1 fatalLimited investigationFinal reportHuggles Sonex · Bonham, TXThe pilot's failure to maintain control of the airplane on take off, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB MIA07LA132Accident · Minor injuriesLimited investigationFinal reportRoger A Dalke E.B. Jenny · Wakefield, VAThe pilot/owner's inadequate maintenance which resulted in a radiator leak, a loss of engine coolant, the engine overheating, and partial loss of engine power.NTSB SEA07FA231Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus-CM · Benton, CAThe pilot's failure to maintain aircraft control while maneuvering and the inadvertent entry into a stall/spin. Contributing to the accident were the mountainous terrain conditions, unfavorable wind conditions, and the terrain-induced turbulent wind…NTSB CHI07CA262Accident · No injuriesData collectionFinal reportBeech BE-77 · Bloomington, INThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.NTSB NYC07LA191Accident · No injuriesLimited investigationFinal reportBass RV-6A · Harrisonburg, VAThe limited fork-to-ground clearance provided by the nose gear design. Contributing to the accident was the uneven turf/dirt surface of the runway.NTSB CHI07LA237Accident · 1 fatalLimited investigationFinal reportOpus Motorsports BD02 · Dayton, OHThe pilot not maintaining clearance from terrain during the aerobatic maneuver. Factors contributing to the accident were the pilot's restricted ability to see the terrain and the oil smoke present in the air show performer's box.