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 CHI07CA214Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Sheldon, ILThe pilot's inability to maintain a proper rate of climb during takeoff. Factors associated with the accident were the pilot's failure to dump the chemical load and the ditch which the airplane contacted.NTSB SEA07FA195Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Everett, WAThe pilot's inadequate preflight planning and inspection that led to oil exhaustion and a catastrophic engine failure. Also causal was the pilot's attempted operation of an aircraft with known deficiencies, and the lack of a current airworthiness inspection.…NTSB LAX07LA220Accident · Serious injuriesLimited investigationFinal reportMurrin Frederick L Sopwith F1 · Greenville, PAa fuel starvation induced loss of engine power due to inadequate fuel system pressure. A factor in the accident was the pilot/builder's failure to adequately adjust the fuel system pressure.NTSB DFW07CA161Accident · No injuriesData collectionFinal reportRodgers Zodiac 601XL · Levelland, TXThe loss of engine power for undermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07LA210Accident · Minor injuriesLimited investigationFinal reportAviation International Rotors CH-54A · Los Olivos, CAThe company mechanic's inadequately performed maintenance and inspection, which resulted in a flight control malfunction and loss of control during takeoff.NTSB LAX07CA205Accident · Minor injuriesData collectionFinal reportSaunders Stiletto · Quartzsite, AZFuel exhaustion due to the pilot's inadequate preflight inspection during which he failed to insure security of the fuel tank's cap.NTSB CHI07LA203Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Belle Plaine, IAThe pilot's failure to maintain directional control during landing rollout.NTSB LAX07LA197Accident · Minor injuriesLimited investigationFinal reportEvenson Roger J Vans RV-9A · Tucson, AZthe loss of engine power during takeoff-initial climb, which resulted from the owner/builder's improper adjustment of the supercharger waste gate valve, that resulted in the failure of the waste gate servo motor.NTSB CHI07CA196Accident · Minor injuriesData collectionFinal reportAnderson Glasair FT II · Cedar Rapids, IAThe loss of engine power for undetermined reasons during the downwind leg, which resulted in a forced landing. A factor in the accident was the unsuitable terrain encountered.NTSB SEA07LA173Accident · Minor injuriesLimited investigationFinal reportHalsted Flightstar Pioneer · Nampa, IDThe failure (fracture) of the crankshaft of the non-certificated two-cycle engine during cruise flight. Factors include a ditch running through the field in which the pilot executed his engine-out forced landing.NTSB SEA07CA167Accident · No injuriesData collectionFinal reportRallison Rotorway 162F · Logan, UTThe total loss of engine power due to the pilot inadvertently deactivating the rotor drive clutch assembly. A contributing factor was the downhill terrain condition where he landed, which exceeded the slope limitations of the helicopter.NTSB NYC07LA140Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Washington, NCA loss of engine power for undetermined reasons. Contributing to the accident was the proximity of trees.NTSB CHI07CA165Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Manito, ILThe pilot's failure to maintain proper airspeed and his decision to attempt flight over maximum gross weight. A factor to the accident was the stall encountered while attempting to avoid obstacles.NTSB DEN07LA098Accident · Serious injuriesLimited investigationFinal reportBoeing 757-251 · Denver, COThe inadvertent encounter with moderate turbulence during the approach which resulted in a serious injury to the flight attendantNTSB LAX07LA184Accident · No injuriesLimited investigationFinal reportBrook Lancair IV-P · Parowan, UTA loss of engine power due to engine inlet icing. Contributing to the accident was the lack of engine inlet anti-icing capability.NTSB CHI07CA152Accident · No injuriesData collectionFinal reportCessna 421C · Kokomo, INThe pilot not obtaining proper alignment with the runway during the emergency landing after takeoff, which imparted an excessive side load on the landing gear. Factors contributing to the accident were the unstabilized approach and engine shutdown due to the…NTSB ATL07CA084Accident · No injuriesData collectionFinal reportRotorway Rotorway Intl 162F · Argyle, NYThe loss of engine power due to the sticking of the exhaust valves that resulted from carbon buildup.NTSB NYC07CA122Accident · Minor injuriesData collectionFinal reportHanson Gerald Hanson Bucker 131E · Memphis, TNThe pilot's inadequate visual lookout that resulted in a collision with a lighting structure in the grass while landing. A factor in the accident was the pilot's intentional landing in the runway safety area.NTSB DFW07LA103Accident · 2 fatalLimited investigationFinal reportLivpt Lancair IV-P · McAllen, TXA loss of power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07FA089Accident · 1 fatalField investigationFinal reportSchleicher Alexander ASH 26E · Castle Rock, COthe pilot's failure to maintain aircraft control resulting in an inadvertent stall/mush.NTSB CHI07CA124Accident · No injuriesData collectionFinal reportWilkinson Daniel V Rotorway Exec 90 · Kalamazoo, MIThe failure of the sprag clutch which resulted in the disengagement of the drive unit and the pilot's misjudged landing during the autorotation. A factor was the low altitude at which the failure occurred.NTSB LAX07CA133Accident · No injuriesData collectionFinal reportJiran FJ-1 · Banks, ORthe pilot's misjudged distance/altitude that led to a failure to attain the proper touchdown point.NTSB CHI07LA113Accident · 2 fatalLimited investigationFinal reportMurphy Aircraft Mfg SR3500 Moose · Cotter, ARThe pilot not maintaining airplane control and airspeed during the approach. Factors were the gusty wind conditions, the inadvertent stall the pilot encountered, and the power lines that were impacted during the uncontrolled descent.NTSB CHI07LA106Accident · Minor injuriesLimited investigationFinal reportBrowns Vans RV-7A · Gardner, ILEngine failure during cruise flight for undetermined reasons. A factor was the rough/uneven terrainNTSB SEA07LA095Accident · No injuriesLimited investigationFinal reportDiemert/Rotorway Exec 162 F · Roseburg, ORa total loss of engine power due to the failure of the primary and secondary electronic control units (ECU's) within the engine's Fully Automated Digital Electronic Control.NTSB SEA07CA084Accident · No injuriesData collectionFinal reportBoykin Rotorway Exec 162F · Camarillo, CAThe pilot's failure to maintain main rotor RPM resulting in an uncontrolled descent to a hard landing. A contributing factor was his lack of experience in make and model of aircraft.NTSB DFW07LA087Accident · No injuriesLimited investigationFinal reportPZL 101A · Spicewood, TXThe loss of engine power due to water contamination in the fuel system. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB SEA07CA083Accident · No injuriesData collectionFinal reportDuffy/Wagner Vans RV-4 · Ogden, UTThe pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA07CA061Accident · Minor injuriesData collectionFinal reportBruce E. Hotz Wind Wagon · Leesburg, FLThe failure of the pilot to abort the takeoff after recognizing that the engine rpm was 760 less than desired after becoming airborne, and the inability of the airplane to maintain a positive rate of climb resulting in a controlled descent, and in-flight…NTSB CHI07LA091Accident · Serious injuriesLimited investigationFinal reportHaddan Sonerai IIL · Fort Atkinson, WIThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons. A low altitude and an inadvertent stall were factors.NTSB DFW07FA071Accident · 1 fatalField investigationFinal reportStevens KB-2 · Oklahoma City, OKThe pilot's failure to maintain control of the gyroplane while in the traffic pattern. Contributing to the accident was the high wind with terrain induced turbulence and the absence of the gyroplane's horizontal stabilizer.NTSB ATL07CA043Accident · No injuriesData collectionFinal reportBurkhart-Grob G109 · Monticello, GAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control, an in-flight collision with a hangar, and subsequent in-flight collision with the runway.NTSB MIA07CA046Accident · Minor injuriesData collectionFinal reportC.W Crane T2 · Bunnell, FLThe pilot's inadvertent encounter with adverse weather that resulted in a descent and an impact with terrain.NTSB CHI07LA070Accident · Minor injuriesLimited investigationFinal reportReisinger Sonerai II L · Alma, MIThe loss of engine power during takeoff-initial climb for an undetermined reason. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB DEN07LA044Accident · Serious injuriesLimited investigationFinal reportMarino Exec 162F-1995 · Baldwin City, KSthe failure of the tail rotor drive belt for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07FA052Accident · 1 fatalField investigationFinal reportBeech 58 · Washington, INThe pilot's failure to maintain clearance from trees and terrain while attempting to return to the departure airport for undetermined reasons after takeoff. The intervening tree line was a contributing factor.NTSB LAX07CA063Accident · No injuriesData collectionFinal reportBelcher Helicycle · Boulder City, NVa loss of engine power due to a fractured fuel line.NTSB CHI07LA037Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Waterloo, IAThe go-around not performed and the improper flare by the pilot during landing.NTSB SEA07LA025Accident · 2 fatalLimited investigationFinal reportHolloway RV6A · North Bend, ORThe pilot's failure to maintain clearance from the water while performing low altitude maneuvering flight resulting in an in flight collision with the water.NTSB LAX07LA047Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · San Pedro, CALoss of control for undetermined reasons.NTSB NYC07LA026Accident · 1 fatalLimited investigationFinal reportVogel Glastar 41 · Snow Shoe, PAThe builder's improper installation of an additional alternator. Contributing to the accident were the night lighting conditions.NTSB NYC07LA022Accident · 1 fatalLimited investigationFinal reportMonard RAF 2000 GTX · Ridgely, MDThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB CHI07FA009Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Lawrenceville, ILThe improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…NTSB ATL07CA009Accident · No injuriesData collectionFinal reportLawing Thomas R Exec 162-F · Aiken, SCThe pilot’s failure to adequately compensate for wind conditions during takeoff which resulted in a loss of tail rotor effectiveness and a roll over during an attempted forced landing.NTSB SEA07LA011Accident · No injuriesLimited investigationFinal reportSorensen Searey · Marysville, WAThe pilot's failure to identify an unsafe condition (strong tidal currents) prior to a water landing, which resulted in the airplane nosing over when the pilot was unable to maintain aircraft control.NTSB CHI06LA273Accident · Minor injuriesLimited investigationFinal reportDaub Pawnee Chief · McCook, NEThe failure of a welded joint at a cyclic control cable bracket located on the main rotor mast which made control of the helicopter impossible for the pilot.NTSB ANC06FA136Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot's failure to maintain adequate airspeed while maneuvering to reverse direction, which resulted in an inadvertent stall and an uncontrolled descent. Factors associated with the accident were the inadvertent stall and wind gusts.NTSB NYC06LA224Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · East Bridgewate, MAThe completion center's installation of the incorrect (shorter) release cable, and the ground crewmember's improper movement under the flight path during a bin transfer.NTSB CHI06CA265Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Dayton, OHThe pilot's inadvertent wheels up landing.NTSB CHI06LA260Accident · No injuriesLimited investigationFinal reportEndless Skies L164 · Durand, MIThe kit builder's improper installation of the aileron bracket leading to the aileron flutter during cruise that resulted in the wing spars' failure.