NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 FTW96LA010Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crockett, TXfailure of both magnetos to operate properly due to inadequate maintenance by other maintenance personnel. A factor was the lack of suitable terrain available for the forced landing.NTSB NYC96FA003Accident · 2 fatalField investigationFinal reportEnstrom 280C · Quakertown, PAimproper installation of the magneto by maintenance personnel, which resulted in the loss of ignition and the loss of engine power. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB LAX96LA007Accident · No injuriesLimited investigationFinal reportSchlitter Rans S-9 · Chandler, AZseizure of the #2 cylinder for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB FTW96LA007Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamburg, ARLoss of engine power due to a cylinder failure. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB NYC96LA001Accident · No injuriesLimited investigationFinal reportCheney Avid Flyer · Newton, NHThe seizure of a piston during the takeoff climb, resulting in a loss of engine power, forced landing, and subsequent collision with trees.NTSB LAX95LA345Accident · Minor injuriesLimited investigationFinal reportPro-built Kitfox IV Speedster · Lakeport, CAthe pilot's improper installation of the carburetors.NTSB ATL95LA176Accident · No injuriesLimited investigationFinal reportCessna 182R · Tuscaloosa, ALEngine oil starvation for undetermined reasons, which resulted in a connecting rod cap failure.NTSB CHI95LA334Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Belleville, ILthe rupture of the oil pressure line which led to oil system exhaustion, the stuck intake valves, and the powerlines.NTSB ATL95LA171Accident · No injuriesLimited investigationFinal reportBell 47G · Union City, TNFailure of a #4 connecting rod bolt, which resulted in engine stoppage and a forced landing.NTSB SEA95LA221Accident · Serious injuriesLimited investigationFinal reportBell UH-1L · Grace, IDthe fatigue failure of the centrifugal impeller and the lack of suitable terrain for a forced landing. Factors contributing to the accident were: the lack of required compliance with the FAA Airworthiness Directive by the operator, the insufficiently defined…NTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.NTSB MIA95FA223Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Dalton, GAthe pilot's improper action by turning off the right engine fuel selector valve after the left engine had failed, and her failure to maintain control of the airplane after losing power in both engines. Factors relating to the accident were: a worn rocker arm…NTSB SEA95FA213Accident · 1 fatalField investigationFinal reportCessna P210N · Black Diamond, WAimproper maintenance which led to oil starvation due to a inadequately tightened B-nut in an oil line. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Lago Vista, TXThe loss of engine power due to the failure of a connecting rod for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB LAX95LA309Accident · No injuriesLimited investigationFinal reportJosephson MC-15 Cricket · San Diego, CAthe failure of the left engine due to inadequate maintenance of the ignition system.NTSB MIA95LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic Ocean (Atlantic Ocean)The failure of the oil lubrication system for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB BFO95LA089Accident · No injuriesLimited investigationFinal reportCessna R172K · Lisbon, OHLoss of oil, where an oil filter adapter had separated from the crankcase cover, due to stripped threads that were caused or allowed by inadequate maintenance or inspection, which resulted in oil exhaustion and subsequent loss of engine power. A factor…NTSB FTW95LA360Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Evadale, TXA failure that resulted in separation of the #5 cylinder and loss of engine oil. The lack of suitable terrain for a forced landing was a related factor.NTSB SEA95LA190Accident · No injuriesLimited investigationFinal reportMooney M20K · Roundup, MTan engine failure due to foreign object ingestion into the oil pump. A ruptured oil inlet screen contributed to the accident.NTSB CHI95LA295Accident · No injuriesLimited investigationFinal reportKraetzner SKY-BUGGY · Princeton, WIthe loss of engine power due to the blocked float valve seat in the carburetor and the pilot's failure to have the proper maintenance inspection performed on the airplane.NTSB CHI95LA290Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Port Washington, WIthe failure of the #2 cylinder due to fatigue cracking. A factor was the soft terrain.NTSB LAX95LA300Accident · No injuriesLimited investigationFinal reportGettig Pitts Special S1C · Goodyear, AZThe owner/builder's improper installation of the fuel injection system unit by misaligning the drive shaft that resulted in the fracture of the shaft. The road sign was a factor in this accident.NTSB SEA95LA186Accident · No injuriesLimited investigationFinal reportBeech P-35 · Bend, ORseizure of the #4 connecting rod bearing due to overtemperature resulting in the separation of the connecting rod and total loss of engine power. A factor contributing to the accident was the lack of suitable terrain for a forced landing.NTSB CHI95IA286Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Champaign, ILfatigue cracking and subsequent catastrophic failure of the number two engine helical drive (bull) gear, which resulted in an overtemperature condition, bursting of the combustion plenum, and a subsequent in-flight fire.NTSB ATL95FA159Accident · 1 fatalField investigationFinal reportWSK PZL Mielec M-26 · Jonesborough, TNa blocked fuel injector nozzle, which increased the engine fuel consumption; failure of the pilot to adequately monitor fuel consumption, which resulted in fuel exhaustion before the airplane reached the destination; and the passenger's interference with the…NTSB LAX95LA296Accident · No injuriesLimited investigationFinal reportCessna 172P · Hesperia, CAThe failure of the connecting rod due to the rod bolt backing off, and the pilot's misjudging the distance and altitude.NTSB SEA95LA183Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Chimacum, WAthe improper top overhaul of the engine and subsequent release of the cylinder hold-down nuts/breakage of hold-down and through-bolts. Factors contributing to the accident were the fence posts and rough/uneven terrain.NTSB NYC95IA192Incident · No injuriesIncident investigationFinal reportBoeing 747-130 · Jamaica, NYfailure and separation of the #1 engine turbine shroud assembly, which resulted in an uncontained engine failure, a puncture of the #2 outboard reserve fuel tank plate, and a fuel leak.NTSB NYC95FA188Accident · 1 fatalField investigationFinal reportBeech 58 · Mapleton, METhe pilot inadvertently shut down the right engine and feathered the propeller after a loss of power in the left engine, and he failed to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor relating…NTSB FTW95LA343Accident · No injuriesLimited investigationFinal reportPark Wizard · Mineral Wells, TXA seized engine following the total loss of engine coolant from a loose line due to an inadequate maintenance installation by the builder. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA266Accident · No injuriesLimited investigationFinal reportGrumman G164B · Bloomington, NEthe disintegration of the engine's super charger bearings. Factors associated with the accident were the total failure of the engine's super charger and the unsuitable terrain surrounding the airplane's departure path encountered by the pilot.NTSB LAX95LA283Accident · No injuriesLimited investigationFinal reportPZL-Mielec PZL-M-18 · Sacaton, AZThe loss of engine power due to a decoupling of the accessory drive that runs the high pressure engine-driven fuel pump.NTSB NYC95LA183Accident · No injuriesLimited investigationFinal reportBeech C23 · Dublin, NHThe loss of engine power due to improper major overhaul of the engine by the reuse of worn piston pins. The rough/ uneven terrain in the emergency landing area was a factor.NTSB MIA95LA192Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Quitman, MSImproper (low) outflow from the fuel control unit, due to improper maintenance, which resulted in a loss of engine power and a forced landing.NTSB ANC95LA119Accident · 4 fatalLimited investigationFinal reportCessna 421C · Cordova, AKMechanical loss of engine power for undetermined reason(s), and subsequent in-flight collision with water (or ditching at sea).NTSB FTW95LA317Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95FA242Accident · No injuriesField investigationFinal reportRevolution Helicopter MINI-500 · Oshkosh, WIthe inadequate design of the helicopter skid shoes. Factors related to the accident were: false indications of rotor rpm and EGT which led to seizure of the piston.NTSB SEA95LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Havre, MTthe loss of power due to a failure of the cylinder head exhaust valve rocker box. The tall crop encountered during the forced landing is a factor.NTSB NYC95LA173Accident · Minor injuriesLimited investigationFinal reportRyan ST3-KR · Kennett Square, PAThe failure of the no. 3 cylinder connecting rod.NTSB CHI95LA225Accident · No injuriesLimited investigationFinal reportCessna 206 · Williston, NDengine failure due to low fuel pressure at high power settings and subsequent detonation. A factor was an evasive maneuver to avoid obstacles which precipitated a stall. Additional factors include the hay bales, farm equipment, and the runway berm.NTSB ATL95LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Statesville, NCA cracked cylinder that resulted in a loss of engine power.NTSB SEA95LA155Accident · No injuriesLimited investigationFinal reportCessna 172P · Vashon, WAThe loss of engine power due to connecting rod bolt overload failure. The rough, uneven terrain in the emergency landing area was a factor.NTSB FTW95LA297Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe loss of engine power due to a failed supercharger/blower. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA293Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Simmesport, LAThe loss of engine power as result of the failure of the number 7 cylinder. A factor was the lack suitable terrain for the forced landing.NTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB CHI95LA211Accident · 1 fatalLimited investigationFinal reportFirst Strike Bobcat · Burlington, IAfatigue failure of a copper fuel line at the carburetor ferrule fitting, which resulted in fuel starvation. The proximity of trees was a related factor.NTSB SEA95LA143Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WALoss of engine power due to a cracked cylinder.NTSB ATL95LA123Accident · Minor injuriesLimited investigationFinal reportKnosp Corbin JR. ACE-E · Whiteville, NCContamination of the fuel system which resulted in fuel starvation and a total loss of engine power. .NTSB NYC95LA134Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Morehead, KYThe pilot's failure to assure that an inadequate oil supply was available fot the flight.NTSB MIA95LA163Accident · No injuriesLimited investigationFinal reportBeech A36 · Titusville, FLfailure of the No. 6 cylinder barrel due to corrosion fatigue, which resulted in a loss of power. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.