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 LAX05LA244Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Globe, AZThe fatigue failure of the compressor turbine stator vane, the liberation of vane material into the compressor turbine, and the total loss of engine power. Also causal was the operator's failure to inspect the compressor turbine vane during fuel nozzle checks.NTSB LAX05GA231Accident · 2 fatalFinal reportEurocopter France EC120B · Fair Oaks, CAThe failure of the constant delta P diaphragm in the fuel control unit, which resulted in an increased fuel flow and subsequent catastrophic failure of the engine. The diaphragm's failure was the result of improper installation by the engine manufacturer. A…NTSB DEN05LA106Accident · Serious injuriesLimited investigationFinal reportClarke YAK 3UR 2000 · Heber City, UTloss of engine power due to a leaking carburetor and an inoperative float, and the pilot's failure to maintain aircraft control during the restart attempt. Contributing factors were the sudden engine power surge during the attempted restart, and unsuitable…NTSB MIA05TA124Accident · Minor injuriesFinal reportBell OH-58A · St. Augustine, FLThe failure of the compressor section of the engine for undetermined reasons resulting in the total loss of engine power during the initial climb. A factor in the accident was the operator's use of a confined area for takeoff during non-emergency or routine…NTSB IAD05LA084Accident · No injuriesLimited investigationFinal reportBell 206B · Cleveland, OHA failure of the main drive shaft for undetermined reasons, which resulted in a total loss of engine power. A factor was pilot's improper flare, which resulted in a hard landing.NTSB LAX05LA208Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Pasadena, CAa fuel starvation induced loss of engine power due a failure of the electric fuel pump. A factor in the accident was the dark night lighting conditions.NTSB ATL05LA103Accident · 1 fatalLimited investigationFinal reportRutherford Seawind 3000 · Sarasota, FLMaintenance personnel failure to secure throttle linkage on the carburetor which resulted in loss of engine power and a collision with a building.NTSB ATL05LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLA loss of engine power due to the connecting rod cap separation for undetermined reasons. Related factors were trees and the swampy terrain condition.NTSB IAD05LA077Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Southampton, NJA lack of lubrication for undetermined reasons which resulted in the failure of the Nos. 4 and 5 connecting rods, and a subsequent total loss of engine power. A factor in the accident was the furrowed cornfield.NTSB MIA05FA123Accident · Serious injuriesField investigationFinal reportDouglas R4D-8 · Fort Lauderdale, FLThe inadequate maintenance inspection by company maintenance personnel/pilot and other maintenance personnel of the left engine resulting in a total failure of the master rod bearing, and nose case partial separation, which prevented the left propeller from…NTSB IAD05LA076Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Toughkenamon, PAThe failure of the crankshaft, which resulted in a forced landing and subsequent collision with wires. A factor was the wires.NTSB MIA05LA111Accident · Minor injuriesLimited investigationFinal reportHamilton Stoddard Glassair II S · Palm City, FLImproper maintenance by other maintenance personnel, which resulted in the throttle cable being loose and detaching from the throttle arm during takeoff, resulting in a loss of engine power.NTSB IAD05FA068Accident · 2 fatalField investigationFinal reportCessna R182 · New Fairfield, CTFailure of the aluminum-clad, number two connecting rod bearings, which resulted in a total loss of engine power. A factor was the relatively short forced landing area.NTSB MIA05LA107Accident · Serious injuriesLimited investigationFinal reportC.W. Smith Rans S6 Coyote II · Louisville, MSGalling of the front piston and cylinder of the Rotax 503 2-stroke engine, consistent with the engine running hot and lean for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB CHI05IA116Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Kansas City, MOThe fatigue failure during cruise flight of the fan spinner and forward fan retaining ring due to an interference between the mating parts resulting from the inadequate design by the manufacturer.NTSB LAX05LA172Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Geyserville, CAA loss of engine power due to failure of the number 1 connecting rod bearing due to a probable oil starvation.NTSB IAD05LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dover, DEThe separated baffle which blocked the tailpipe resulting in a subsequent total loss of engine power.NTSB DFW05IA119Incident · No injuriesIncident investigationFinal reportEurocopter France EC120B · S.Timbalier 265The loss of engine power as result of the failure of the oil pump assembly.NTSB LAX05LA159Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Tucson, AZa loss of engine power due to the fatigue fracture and separation of the mixture control cable. The fatigue crack resulted from inadequate installation techniques by unknown maintenance personnel.NTSB LAX05LA146Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22A · Kailua-Kona, HIa total loss of engine power due to the failure of the engine's #3 exhaust valve due to an excessive valve guide clearance. Contributing to the accident was the failure of maintenance personnel to adequately check the valve guide clearance during the last…NTSB DEN05LA070Accident · No injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Longmont, COthe loss of engine power due to oil starvation. A contributing factor was the contamination in the inverted oil system's separator.NTSB NYC05LA074Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Southbury, CTThe failure of the counter weight aft snap ring to hold the associated plate and pin in place, which resulted in a total loss of engine power.NTSB LAX05LA140Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Paso Robles, CAthe separation of the number 4 engine cylinder due to improperly torqued cylinder hold down nuts. A finding in this accident was the lack of a shoulder restraint system in the airplane, which contributed to the occupants' injuries.NTSB NYC05LA071Accident · No injuriesLimited investigationFinal reportBrennan Flightstar · Middleboro, MAA loss of engine power for undetermined reasons.NTSB LAX05LA136Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Phoenix, AZa loss of power for undetermined reasons.NTSB SEA05LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Covington, WAThe failure of connecting rods during cruise flight resulting in a loss of engine power. Trees were a factor.NTSB CHI05LA076Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Rochester, MNThe loss of engine power due to oil starvation and the subsequent failure of a connecting rod. Additional causes were the improper maintenance due to under-torqued fasteners, and inadequate airframe manufacturer maintenance procedures resulting in an improper…NTSB ATL05TA055Accident · Serious injuriesFinal reportCessna T-41B · Sparta, TNImproper installation of the timing reference plug by other maintenance personnel, which resulted in oil starvation, and the loss of engine power.NTSB CHI05CA074Accident · Serious injuriesData collectionFinal reportCessna 177RG · Fargo, NDThe mechanic's improper installation of the oil filter canister base gasket, which resulted in an oil leak and the separation of the connecting rod due to oil starvation. Factors to the accident were the unsuitable terrain encountered during the forced…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 ATL05LA051Accident · Serious injuriesLimited investigationFinal reportMooney 20P · Smith, ALMaintenance personnel failure to properly torque the cylinder head during installation that resulted in the separation from the engine assembly and the subsequent loss of power.NTSB LAX05LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIForeign object damage inside an engine cylinder, which resulted in a loss of engine power during climb to cruise, and an off-airport forced landing.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 ATL05LA047Accident · No injuriesLimited investigationFinal reportBeech C-23 · Roseboro, NCThe overload fracture of the engine oil cooler for undetermined reasons.NTSB LAX05LA070Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Pauma Valley, CAthe loss of engine power due to an undetermined obstruction in the vent system for the fuel tanks and failure of the fuel caps to vent.NTSB ATL05LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Polkton, NCA loss of engine power due to the failure of the engine-driven fuel pump, which resulted in fuel starvation.NTSB CHI05FA048Accident · 2 fatalField investigationFinal reportBeech S35 · Herman, WIThe installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…NTSB DFW05FA032Accident · Serious injuriesField investigationFinal reportHughes 369D · Zachary, LAThe loss of engine power as a result of fatigue cracking of the compressor adaptor coupling initiated by fretting on the pilot diameter and subsequent disconnection of the compressor from the turbine assembly. A contributing factor was the low operating…NTSB MIA05FA040Accident · No injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340 · N. Miami Beach, FLThe improper maintenance of the left engine by company maintenance personnel (failure to flush metal from the oil system and failure to properly preserve the engine for storage) resulting in a total failure of the master rod bearing and contamination of the…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 ATL05LA026Accident · Serious injuriesLimited investigationFinal reportGolden Circle Air T-Bird II · Dunlap, TNThe pilot's improper flare during forced landing following a loss of engine power for undetermined reasons, which resulted in a hard landing. A factor was the separation of a fuel line, which resulted in fuel starvation to the engine.NTSB IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.NTSB CHI05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo Grove, ILFatigue fracture of the engine crankshaft during initial climb after takeoff resulting in a complete loss of engine power. Contributing factors were the trees and the highway.NTSB MIA05LA016Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Raymond, MSThe total loss of engine power which was initiated by fretting of the crankcase halves for undetermined reasons, causing rotation of several of the main bearings, oil starvation, and subsequent failure of several of the connecting rods. A contributing factor…NTSB ATL05FA013Accident · 4 fatalField investigationFinal reportBeech BE-60 · Asheville, NCThe pilot's failure to follow emergency procedures and to maintain airspeed following a loss of engine power during takeoff, which resulted in an inadvertent stall/spin and subsequent uncontrolled impact with terrain. Contributing to the cause was inadequate…NTSB LAX05TA018Accident · Serious injuriesFinal reportHughes OH-6A · Tucson, AZThe loss of engine power due to a fatigue fracture of the PC line from the governor to fuel control, resulting from fretting damage induced by excessive vibration, which was due to the failure of maintenance personnel to install the proper bearings in the…NTSB ATL05LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Guntersville, ALTotal loss of engine power due to engine oil contamination, engine oil starvation, and multiple connecting rod bearing failures.NTSB DFW05LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Denton, TXThe loss of engine power due to the separation of the accessory drive gear bolts, and the failure of the starter-clutch assembly. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC05FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Madison, CTA loss of engine power due to separation of the propeller due to under-torqued retention bolts.NTSB FTW04CA246Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe failure of a piston connecting rod for undetermined reasons resulting in the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.