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 DEN91FA061Accident · Serious injuriesField investigationFinal reportCessna T210M · Littleton, COImproper reassembly of the overhauled turbocharger by maintenance personnel, and the pilot's improper use of the mixture control and boost pump. Factors related to the accident were: the adverse weather conditions and unsuitable terrain in the emergency…NTSB SEA91IA081Incident · Minor injuriesIncident investigationFinal reportBoeing 737-222 · Seattle, WATurbine blade failure from fatigue. Factors to the incident were inoperative engine fire extinguisher, inadequate service of aircraft and delayed deployment of emergency slide.NTSB CHI91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Griffith, INContaminated fuel in the carburetor, and inadequate inspection/maintenance of the airplane by the pilot in command.NTSB ATL91FA077Accident · 1 fatalField investigationFinal reportCessna 172D · Mocksville, NCThe loss of engine power due to open circuits in the ignition wiring harness, and the pilot's failure to maintain flying airspeed during the forced landing attempt. Factors in this accident were the dark night lighting conditions at the time of the accident.NTSB LAX91LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAThe installation by maintenance personnel of an incorrect gasket that resulted in the loss of the engine magneto.NTSB CHI91LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILThe mechanic's not understanding the identifying marks on the replacement part. A factor in the accident was that the mechanic was provided with an improper part.NTSB MIA91LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Vero Beach, FLFailure of maintenance personnel to follow directions of a service bulletin during the major overhaul of the engine. This resulted in failure to detect a foreign object under the crankshaft gear. As a result the crankshaft gear became loose and quit turning…NTSB LAX91LA150Accident · No injuriesLimited investigationFinal reportBeech A35 · Hilt, CAThe application of a sealant instead of a lubricant to the internal 'o' rings seals in the fuel selector by maintenance personnel. Factors contributing to the accident were the pilot's inability to select a fuel source and fuel starvation that resulted in an…NTSB SEA91FA076Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Chehalis, WAA loss of engine power due to an improper overhaul.NTSB MIA91LA109Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Crystal River, FLThe loss of power because of oil pump failure due to contamination. Unknown maintenance personnel performed a component change without using appropriate publications and procedures and failed to clean contaminants from the engine.NTSB NYC91LA092Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Westbrook, MEImproper emergency procedures by the pilot. Factors related to the accident were: the pilot's lack of experience and flight time in type of airplane, the pilots decision to take an airplane with a known mechanical defect, a leaky accelerator pump seal on the…NTSB FTW91LA054Accident · No injuriesLimited investigationFinal reportCessna 210 · New Orleans, LAThe power loss due to fatigue induced crankshaft failure. Factors were the pilot's continued operation with known mechanical malfunction and the lack of suitable terrain for the forced landing.NTSB LAX91LA137Accident · No injuriesLimited investigationFinal reportSikorsky H-19/S55 · Richvale, CAThe failure of the engine's number 4 cylinder intake valve keeper. Trees under the helicopter at the time of the loss of engine power were factors in the accident.NTSB FTW91DRD03Accident · No injuriesFinal reportGrumman G-164A · Bonita, LAA power loss due to a cracked cylinder. A factor was the soft terrain in which the forced landing was performed.NTSB LAX91LA126Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZEngine failure due to oil starvation caused by a rotation of the main bearing. A factor in the accident was the failure of the operator maintenance personnel to accomplish an engine overhaul within the interval specified by the manufacturer.NTSB FTW91FA045Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Fort Chaffee, ARThe pilot's operation of the aircraft with known deficiencies in equipment. Factors were the improper overhaul of the engines by other maintenance personnel resulting in oil loss, deteriorated engine performance, and unsuitable terrain.NTSB LAX91LA121Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Mesa, AZ1) The failure of the airplane's engine upper crankcase oil breather line; 2) total loss of engine power caused by a lack of lubricating oil. A factor in this accident was the pilot inadvertantly stalling the aircraft to avoid a collision with a wire.NTSB LAX91LA109Accident · No injuriesLimited investigationFinal reportRockwell S2R-600 · Corcoran, CAFailure of the aircraft engine's fuel pump valve assembly bypass.NTSB DEN91IA046Incident · No injuriesIncident investigationFinal reportAvions Marcel Dassault Mistert Falcon 900 · Eagle, COImproper engine maintenance by maintenance personnel, improper assembly of the combustion assembly transition liner, and the rupture of the first stage lp turbine wheel.NTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.NTSB LAX91LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA22-160 · Bagdad, AZThat the pilot misjudged the landing flare altitude. Contributing to this accident was the failure of the exhaust valve and the pilot's anxiety during the emergency.NTSB FTW91FA036Accident · Minor injuriesField investigationFinal reportCessna 182K · Mansfield, TXThe failure of the number two cylinder piston due to inadequate maintenance.NTSB DEN91LA041Accident · Minor injuriesLimited investigationFinal reportBeech P-35 · Durango, COEngine failure due to oil starvation caused by turbocharger oil feed line failure and subsequent loss of lubricating oil to the engine.NTSB LAX91LA095Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAThe failure of the no. 5 cylinder due to fatigue. Contributing to this accident was the wet terrain and crops.NTSB CHI91LA094Accident · No injuriesLimited investigationFinal reportCessna R172K · Herington, KSLoss of engine power due to failure of a connecting rod bolt. A factor related to the accident was: the soft, unsuitable terrain.NTSB BFO91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wise, VAThe loss of engine power brought on by a failure of the number three clyinder exhaust valve. Contributing to the accident was unsuitable terrain on the emergency landing field.NTSB ANC91LA022Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-3 · Nome, AKThe failure of the 1, 2, 6, 7, 8 and 9 piston linkrods which were broken at the master rod attach end. Contributing to the accident was the rough, uneven terrain.NTSB NYC91LA059Accident · No injuriesLimited investigationFinal reportCessna 172P · Charleston, WVTotal loss of engine power in cruise flight due to failure of the accessory drive gear dowel pin resulting in a forced landing over unsuitable terrain and subsequent nose over on landing roll. A factor related to the accident was the improper procedure used…NTSB DEN91IA028Incident · No injuriesIncident investigationFinal reportBoeing 727-22 · Denver, COFailure of an engine bearing.NTSB DEN91IA026Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200 · Denver, COThe catastrophic failure of the no.12 blade on the 4th stage turbine wheel, and failure of company maintenance personnel to identify the preexisting crack during maintenance inspection.NTSB ATL91LA030Accident · No injuriesLimited investigationFinal reportBeech S35 · N. Myrtle Beach, SCThe pilot's failure to ensure that the engine oil filter was properly installed prior to flight, resulting in engine oil loss and eventual failure of the engine.NTSB SEA91LA031Accident · No injuriesLimited investigationFinal reportBeech 3NM · Bozeman, MTThe failure of the right engine master rod.NTSB LAX91LA048Accident · No injuriesLimited investigationFinal reportCessna T-206 · Tonto Basin, AZThe failure of a connecting rod in the engine.NTSB ATL91IA024Incident · No injuriesIncident investigationFinal reportCessna S550 · Columbus, GAA fatigue failure of a spot weld on the gas generator case, which resulted in an engine explosion.NTSB LAX91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Fallbrook, CAThe failure of the number 5 cylinder piston connecting rod due to bending and subsequent fatigue fracture. Contributing to the accident was the improper starting procedure accomplished by an unidentified person which resulted in excessive fuel in the cylinder…NTSB ATL91LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Winston-Salem, NCFailure of a piston pin plug which resulted in a total loss of power. Factors in the accident were an inadequate engine overhaul which led to premature engine wear, and the pilot's failure to obtain proper maintenance following a loss of engine oil pressure.NTSB DEN91IA019Incident · No injuriesIncident investigationFinal reportBeech J-35 · Brighton, COThe failure of the engine fuel feed line resulting in a complete loss of power. Contributing to the incident was improper installation of the fuel feed transducer.NTSB BFO91LA014Accident · No injuriesLimited investigationFinal reportHughes 269C · Louisville, KYFatigue failure of the number 1 cylinder connecting rod.NTSB NYC91LA020Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 50 · Parkersburg, WVCatastrophic failure of the left engine fan disc due to low cycle fatigue.NTSB LAX91LA017Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Mobile, AZA fuel flow interruption due to a fuel system seal fragment becoming lodged in the fuel control unit and the manufacturer's inadequate quality control procedures.NTSB ATL91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GATotal failure of a connecting rod cap bolt which resulted in a total loss of power.NTSB NYC91LA013Accident · Minor injuriesLimited investigationFinal reportPorterfield Porterfield FP65 · Moravia, NYPower loss after takeoff due to a partially clogged fuel line between the fuel tank and the gascolator. Contributing to the accident was unsuitable terrain under the airplane when power loss occurred.NTSB SEA91LA006Accident · No injuriesLimited investigationFinal reportMooney M20F · Casper, WYThe loss of engine power due to fatigue fracture of the number 2 cylinder connecting rod. Factors related to the accident were: rough and uneven terrain at the accident site and the lack of suitable terrain for forced landing.NTSB LAX91FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Redlands, CAA total loss of engine power due to fuel starvation as a result of a fuel system leak of an undetermined origin.NTSB DEN91LA006Accident · No injuriesLimited investigationFinal reportCessna T210M · Englewood, COEngine failiure resulting from maintenance discrepancies.NTSB FTW91LA004Accident · Minor injuriesLimited investigationFinal reportWaco RNF · Lampasas, TXThe failure of a cylinder intake valve spring.NTSB LAX90LA338Accident · Serious injuriesLimited investigationFinal reportMooney M-20-M · Flagstaff, AZEngine failure due to a ruptured fuel pump diaphragm. A factor in the accident was the unsuitable nature of the terrain to make a forced landing.NTSB FTW90DPA09Accident · Minor injuriesFinal reportMoffitt, William A. Windryder · Mesquite, TXThe power loss due to failure of the ignition system due to improper installation by the operator. A factor was the wire struck during the emerency descent.NTSB ATL90LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Stokesdale, NCThe failure of the engine driven oil pump which resulted in oil starvation to the engine. Factors were: the faa's failure to provide sufficient standards for airworthiness directive compliance, and the rough terrain.NTSB MIA90LA187Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Mulberry, FLAn engine failure which required an emergency landing off airport.