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 NYC95LA066Accident · No injuriesLimited investigationFinal reportCessna 175 · Quantico, VAthe failure of a connecting rod, which resulted in the total loss of engine power. Subsequently, the airplane was ditched.NTSB ATL95LA058Accident · No injuriesLimited investigationFinal reportCessna 150L · Jefferson, GAThe loss of engine power because of sticking valves. A factor was the continuous use of an improper fuel grade.NTSB CHI95LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Joliet, ILthe failure of the number four cylinder due to a loose cylinder hold down stud. A factor in the accident was the embankment.NTSB FTW95LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Carlsbad, NMFuel exhaustion engine power loss due to a leak in the fuel system. Factors were dark night conditions and the lack of suitable terrain for the forced landing.NTSB SEA95LA056Accident · No injuriesLimited investigationFinal reportPitts S-2B · Spokane, WAFatigue failure of the crankshaft. Factors were the soft terrain and the pilot/owner's failure to conduct recurring crankshaft inspections recommended by the manufacturer.NTSB ATL95LA055Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Salisbury, NCThe separation of the oil line to the oil cooler which resulted in a loss of engine oil and subsequent engine seizure.NTSB NYC95LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Shadyside, OHThe loss of oil pressure, which resulted in the number six connecting rod failure and penetration through the crankcase.NTSB MIA95LA080Accident · No injuriesLimited investigationFinal reportMooney M20E · Mclain, MSThe improper reassembly of the servo fuel injector during overhaul by maintenance personnel. This resulted in a total loss of engine power during cruise flight due to fuel starvation, forced landing, and subsequent on-ground collision with a fixed object…NTSB FTW95LA119Accident · No injuriesLimited investigationFinal reportBeech 60 · Santa Rosa, NMThe failure of the right engine's turbocharger resulting in oil starvation and subsequent failure of the #5 connecting rod which penetrated the crankcase, and the failure of the left engine's turbocharger resulting in the loss of power on both engines.…NTSB MIA95LA078Accident · No injuriesLimited investigationFinal reportHughes 500C · Key Largo, FLThe pilot's misjudgment of altitude and failure to apply collective cushioning pitch during an autorotation resulting in a hard landing. Contributing to the accident was a total loss of engine power due to a loose coupling B-nut on the pneumatic fuel control…NTSB FTW95LA117Accident · No injuriesLimited investigationFinal reportCessna 172RG · Plano, TXThe disengagement of the crankshaft gear due to the loosening of the gear retaining bolt and the subsequent fracture of the gear alignment dowel. A factor was the lack of suitable terrain available for the forced landing.NTSB ATL95LA051Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Tullahoma, TNA lack of lubricant to the starter/roller clutch, seizure of the starter, and failure of the four crankshaft gear capscrews (bolts), which resulted in disengagement of the crankshaft (accessory) gear and subsequent loss of engine power.NTSB SEA95LA050Accident · No injuriesLimited investigationFinal reportBeech S-35 · Wolf Point, MTThe loss of power due to lost oil pressure and a failed connecting rod. Factors include fence posts and dusk lighting conditions which limited visibility.NTSB MIA95LA066Accident · No injuriesLimited investigationFinal reportBeech 35 · Sardis, MSA loss of engine power due to fuel starvation caused by a fuel selector stem failure, due to wear, that precluded the pilot from selecting a fuel tank that had fuel.NTSB MIA95LA065Accident · No injuriesLimited investigationFinal reportBell 206-B3 · Miami, FLInadequate maintenance and inspection, and a loose fuel pc line. The wires were a factor which necessitated early collective pitch.NTSB CHI95LA075Accident · No injuriesLimited investigationFinal reportBeech C45H · New Hudson, MIThe owner/pilot's inadequate maintenance practices which resulted in a loss of engine power shortly after takeoff and the pilot's inadequate emergency procedure after the power loss occurred. Related factors are trees, diminished airspeed and abrupt touchdown.NTSB CHI95FA071Accident · 2 fatalField investigationFinal reportBacon QUESTAIR-VENTURE · Des Moines, IAThe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall/spin. Factors were material defects in the material used to manufacture the crankshaft, resulting in the crankshaft fracturing after approximately 200 hours in…NTSB FTW95GA090Accident · No injuriesFinal reportHughes 269C · Dumont, TXThe loss of engine power due to overstress fractures of the #3 cylinder connecting rod cap bolts. The origin of the fractures could not be determined.NTSB ATL95FA036Accident · 4 fatalField investigationFinal reportCessna 414 · Augusta, GAThe loss of power on the left engine for undetermined reasons. A factor was the failure of the right engine due to maintenance personnel's failure to properly torque the cylinder through bolts.NTSB NYC95FA049Accident · 1 fatalField investigationFinal reportBeech G35 · West Palm Beach, FLImproper top overhaul by maintenance personnel, and improperly torqued crackcase thru-bolts and cylinder deck studs at the number one cylinder, which led to fatigue failure of four of the bolts, failure and/or separation of the number one cylinder, and a…NTSB MIA95LA056Accident · Minor injuriesLimited investigationFinal reportMooney 20J · St. Petersburg, FLThe failure of the No. 3 connecting rod bolt due to oil starvation for undetermined reasons. This resulted in a total loss of engine power, forced landing, and subsequent ditching.NTSB FTW95FA082Accident · 3 fatalField investigationFinal reportBeech A60 · Hurley, NMThe pilot's failure to maintain airspeed during a single engine approach resulting in an inadvertent stall. Factors were a fatigue separation of a shaft in the left engine turbocharger due to use of a Federal Aviation Administration approved overhaul…NTSB CHI95LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Int'L Falls, MNengine oil exhaustion due to a frozen crankcase breather line and noncompliance with an airworthiness directive.NTSB FTW95LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · La Porte, TXLoss of engine power due to fuel starvation as result of the failure of the glass bowl on the gascolator. A factor was the lack of suitable terrain at the pilot's disposal to execute a forced landing.NTSB FTW95LA065Accident · No injuriesLimited investigationFinal reportCommonwealth Rearwin 185 · Longmont, COOil exhaustion and subsequent engine seizure due to a missing oil drain plug. Factors were the inadequate maintenance and the lack of suitable terrain for a forced landing.NTSB SEA95LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Medicine Bow, WYThe failure of the magneto system due to shorting of both magneto coils to the magneto housing and the lack of suitable terrain to make a forced landing.NTSB ATL95LA025Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Greenwood, SCUnapproved maintenance work done by uncertificated persons which resulted in a broken starter drive which was not properly removed from the engine. The particles sheared the magneto shafts causing the loss of engine power.NTSB SEA95LA027Accident · No injuriesLimited investigationFinal reportCessna 180 · Lonetree, WYThe restricted movement of the carburebor float.NTSB LAX95LA041Accident · Serious injuriesLimited investigationFinal reportBritten-Norman Islander BN2B-20 · Pacific Ocean (Pacific Ocean)An undetermined failure of the left engine. The inability of the airplane to maintain level flight and exceeding the one-engine capability was a factor in the accident.NTSB FTW95LA056Accident · No injuriesLimited investigationFinal reportBell 206B · Natchitoches, LAThe delayed flare and the improper touchdown by the pilot in command. Factors were the operation of the aircraft with known deficiencies by the operator and the pilot, delayed maintenance, and, an engine compressor assembly stall, combined with erosion and…NTSB CHI95LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · La Porte City, IAa material defect which resulted in the fatigue failure of the crankshaft and the aircraft owner's failure to comply with a Mandatory Service Bulletin addressing the defect. A factor related to the accident was the rough terrain on which the forced landing…NTSB CHI95LA047Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Aurora, MOAn undetermined failure of the engine crankshaft resulting in total loss of engine power. The terrain at the emergency landing site and nighttime darkness were contributing factors.NTSB MIA95LA024Accident · Serious injuriesLimited investigationFinal reportAyres S2R-R1820 · Arcadia, FLFailure of the engine due to a undetermined failure in the engine power section.NTSB SEA95IA021Incident · No injuriesIncident investigationFinal reportFairchild SA227 · Missoula, MTThe fatigue failure of the first stage compressor impeller.NTSB CHI95LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Carlock, ILThe total failure of the connecting rod bolts.NTSB NYC95LA023Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Coventry, RIimproper emergency procedures by the pilot and inadequate supervision by the flight instructor which resulted in their failure to restart the engine after it lost power due to a failed engine driven fuel pump.NTSB FTW95LA039Accident · No injuriesLimited investigationFinal reportHughes 269A · Monticello, ARThe loss of engine power due to a fatigued rod end bolt. A factor was the lack of suitable terrain for landing.NTSB CHI95LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hudson, WIinadequate maintenance (major overhaul) by maintenance personnel which resulted in the total loss of engine power. Soft terrain was a related factor.NTSB LAX95LA019Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350D · Kaupo, HIa total loss of engine power by the corrosion fatigue failure of the compressor impeller due to the failure of company maintenance personnel to perform the prescribed daily compressor wash procedures and the inadequate maintenance inspections, which failed to…NTSB CHI95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Grand Forks, NDthe fatigue failure of the crankshaft.NTSB BFO95LA005Accident · Minor injuriesLimited investigationFinal reportS M A N Hydroplum Petrel · Center Village, OHLoss of engine power due to a malfunction of the fuel pump.NTSB NYC95LA028Accident · No injuriesLimited investigationFinal reportRans/Hine S-10 · Hampton, NHa seized piston in the foward cylinder due to a lean mixture.NTSB FTW95IA013Incident · No injuriesIncident investigationFinal reportGates Learjet 35A · San Antonio, TXThe uncontained failure of the turbine wheel. A factor was the resultant loss of hydraulic power.NTSB NYC95LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · New London, NHthe failure of the number four push rod, which resulted in the complete loss of engine power and forced landing, and the subsequent nose over on soft terrain.NTSB CHI94LA351Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · West Chicago, ILthe pilot's failure to use the manual hydraulic pump to lower the landing gear. Factors were the failure of the fuel selector handle, the subsequent fuel starvation, and the pilot's failure to properly crossfeed and restart the left engine.NTSB ATL94LA180Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Ozark, ALThe failure of the engines' main bearings because of a lack of lubrication. A factor was the heavily wooded terrain.NTSB CHI94LA328Accident · No injuriesLimited investigationFinal reportMooney M20E · Plymouth, MIthe pilot's improper (maintenance) modification and his initiating an operation with known deficiencies in equipmentNTSB ATL94FA171Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Glenville, NCThe fatigue failure of #4 intake valve. A factor was hilly terrain.NTSB NYC94LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · North Anson, MEthe inadequately installed cylinder mounting stud nuts, by the engine overhaul facility, which resulted in the separation of the number two cylinder and the subsequent forced landing.NTSB NYC94LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lockwood, WVAn electrical ground short of the ignition wires which resulted in a loss of engine power.