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 ATL01LA095Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Homerville, GAThe improper replacement of an accessory drive component with an unapproved part by maintenance personnel, which resulted in a fatigue fracture of the component and loss of engine power. The airplane subsequently collided with power lines and trees during an…NTSB LAX01LA288Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Camarillo, CAThe improper fabrication/reassembly and inspection of the engine throttle control linkage during aircraft restoration by the operator, and the failure of the operator's inspection personnel to detect the error during subsequent annual inspections.NTSB ANC01LA118Accident · No injuriesLimited investigationFinal reportThomson Avid Flyer · Chugiak, AKThe loss of engine power during initial climb due to a broken spark plug.NTSB DEN01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Rock Springs, WYthe mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent failure of a connecting rod during cruise flight. A contributing factor was the…NTSB MIA01LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Winder, GAA total loss of engine power due to fatigue failure of the number two piston immediately after takeoff, resulting in collision with trees and the terrain during an emergency descent.NTSB CHI01LA286Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Petersburg, NEThe failure of the engine cylinder, and the unsuitable terrain for landing encountered by the pilot. Factors were the low altitude and the muddy field.NTSB NYC01IA211Incident · No injuriesIncident investigationFinal reportCessna 210L · Bluefield, WVImproper maintenance which resulted in the installation of an unserviceable piston assembly, and the subsequent catastrophic engine failure. Factors in this accident were the improper inspection by the piston supplier and the softening of the piston.NTSB SEA01LA154Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Chimacum, WAAn internal ground in the right magneto followed by an internal ground evidenced by arcing in the left ignition coil unit, which led to failure of both the right magneto and the left coil ignition system respectively during cruise. Contributing factors were a…NTSB SEA01LA149Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Quincy, WAThe failure of the impeller assembly as a consequence of impeller rub and binding within the impeller collector case for undetermined reasons.NTSB FTW01LA178Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Grand Coteau, LAthe loss of engine power while maneuvering, which resulted from a fractured #4 cylinder head at the exhaust valve rocker arm boss. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · Sugar Grove, ILthe inadequate maintenance inspection and the unsuitable terrain encountered by the pilot mechanic. The fuel system leak was a contributing factor.NTSB ANC01FA095Accident · Serious injuriesField investigationFinal reportCessna 172 · Eagle River, AKThe fatigue induced fracture of a connecting rod wrist pin, resulting in a complete loss of engine power.NTSB NYC01LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · New Milford, CTSeparation of the number two connecting rod for reasons undetermined.NTSB LAX01LA254Accident · Minor injuriesLimited investigationFinal reportWatkins Velocity · Winslow, AZThe separation of the number three cylinder head from the barrel resulting in a loss of engine oil during flight. Factors were the lack of suitable terrain for the forced landing, and the rough uneven ground of the forced landing site.NTSB DEN01LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Calhan, COthe loss of engine power due to fuel contamination (water). A contributing factor was the lack of suitable terrain on which to perform a forced landing.NTSB CHI01FA220Accident · 1 fatalField investigationFinal reportMooney M-20R · Eden Prairie, MNThe fractured camshaft gear and the pilot not maintaining aircraft control. Factors relating to this accident were metal fatigue in the camshaft gear teeth, the inadvertent stall, the low airspeed, and the trees.NTSB ATL01IA083Incident · No injuriesIncident investigationFinal reportBoeing B-727-100 · Memphis, TNThe failure of the #3 engine starter turbine.NTSB LAX01LA243Accident · No injuriesLimited investigationFinal reportBell 206B · San Francisco, CAThe failure of the accessory gearbox 2 1/2 bearing in fatigue resulting in the complete loss of engine power and a subsequent forced landing. The pilot's failure to maintain directional control during the autorotational flare maneuver is also causal. The…NTSB CHI01IA211Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Whiteman AFB, MOThe separation of a fan blade due to fatigue failure which led to case separation and loss of engine power in the left engine.NTSB NYC01LA164Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Friendly, MDA baffling failure within the exhaust system. Factors were an inadequate annual inspection and the pilot's operation of the airplane with known deficiencies in equipment.NTSB LAX01LA231Accident · No injuriesLimited investigationFinal reportCessna 172N · Boulder City, NVthe loss of engine power while in cruise flight due to the mechanic's improper magneto timing.NTSB FTW01LA156Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Sabinal, TXa loss of engine power due to a crack in the #9 cylinder, which result in the failure of the connecting rod during the aerial application flight. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA01LA121Accident · Minor injuriesLimited investigationFinal reportKaman HH-43B · Mullan, IDThe development of multiple fatigue cracks which ultimately resulted in the fracture of the 1st stage gas producer turbine rotor sealing disc. Factors contributing to the accident were mountainous/hilly and unsuitable terrain conditions.NTSB MIA01LA168Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Key West, FLThe improper installation of the cylinders by other maintenance personnel for failure to assure that the cylinders were properly torqued resulting in fatigue crack in the crankshaft, and crankshaft failure. A finding in the investigation was fretting of both…NTSB FTW01LA143Accident · Minor injuriesLimited investigationFinal reportCommander 114-B · Okmulgee, OKthe failure of the #6 cylinder's connecting rod, which resulted in a complete loss of engine power. A contributing factor to the accident was the lack of suitable terrain for the forced landing.NTSB NYC01FA141Accident · 3 fatalField investigationFinal reportCessna P210N · Honesdale, PAAn improperly manufactured torquemeter gearshaft assembly, which resulted in gearshaft assembly failure, an N2 overspeed, and a subsequent uncontained engine failure.NTSB LAX01FA200Accident · No injuriesField investigationFinal reportHughes 369D · Hanapepe, HIa loss of engine power while in cruise flight resulting from the failure and liberation of several turbine blades due to hot corrosion effects which weakened the blades. The hot corrosion damage was the result of multiple turbine over temperature events which…NTSB DEN01LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Albuquerque, NMthe pilot's diminished visual lookout, resulting in the wire strike. Contributing factors were the total mechanical failure of the cylinder, dusk, and the power transmission line.NTSB MIA01LA150Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Fort Pierce, FLThe loss of engine power during takeoff/initial climb due to compressor turbine blade separation.NTSB FTW01LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Georgetown, TXthe pilot's failure to refuel the aircraft resulting in fuel exhaustion during cruise flight. A contributing factor was the gusty wind encountered during the forced landing.NTSB DEN01LA103Accident · Minor injuriesLimited investigationFinal reportHall Lancair 4P · Bennett, COunsuitable terrain on which to make a forced landing. A contributing factor was a fatigue fracture of the starter adapter drive shaft, which resulted in a loss of engine power due to oil starvation.NTSB LAX01FA186Accident · 1 fatalField investigationFinal reportBeech M35 · North Las Vegas, NVThe pilot/owner's failure to correctly install the oil filter, which resulted in oil exhaustion and a loss of engine power. Also causal was his attempt to modify the design of the oil filter element adapter by breaking the bond between the base and the…NTSB ANC01IA058Incident · No injuriesIncident investigationFinal reportCessna 207 · Quinhagak, AKAn in-flight fracture of the engine crankshaft during descent, precipitated by restricted oil flow through an internal engine oil passage/port.NTSB LAX01LA179Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paulden, AZCatastropic engine failure due to oil depletetion caused by an oil filter gasket failure.NTSB NYC01FA122Accident · 1 fatalField investigationFinal reportCessna U206E · New Market, VAA loss of engine power due to a failure of the number 5 piston for undetermined reasons. A factor in this accident was the inadequate emergency handling provided by the air route traffic controller.NTSB CHI01LA135Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Warsaw, ILthe rocker assembly failure during low level maneuvering. Factors were the soft and sandy terrain and the unsuitable terrain the pilot encountered during the forced landing.NTSB FTW01FA111Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · The Woodlands, TXThe pilot's failure to maintain airplane control following a loss of right engine power, which resulted in impact with terrain in an uncontrolled descent. A contributing factor was the loss of right engine power as a result of the fatigue failure of the…NTSB LAX01LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Oxnard, CAThe fracture and separation of the number 3 cylinder exhaust valve head resulting in a loss of engine power and a forced landing. A factor in the accident was the soft field where the forced landing occurred.NTSB IAD01LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · King George, VAThe failure of cylinder case and thru studs due to fatigue, which resulted in a loss of engine power over unsuitable terrain.NTSB ANC01LA050Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Glennallen, AKA total failure of the engine and subsequent rupture of the crankcase during cruise flight. A factor in the accident was unsuitable terrain for a forced landing.NTSB MIA01LA127Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Alexander City, ALA total loss of engine power during cruise flight due to an internal disconnection in the fuel injector control assembly as a result of a failure of the maintenance facility to follow proper installation procedures, resulting in a forced landing and collision…NTSB FTW01LA085Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXthe failure of the number four cylinder exhaust valve which resulted in a total loss of engine power during cruise. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX01LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Stanford, CAFailure of company maintenance personnel to properly install and safety wire the oil filter, which subsequently lead to a loss of engine power.NTSB LAX01TA119Accident · No injuriesFinal reportEurocopter France AS350-B2 · Hayward, CAThe fatigue fracture of the engine accessory drive gear while maneuvering, which resulted in a loss of engine power and collision with a residential transmission line during the ensuing forced landing. A factor associated with the accident was the residential…NTSB LAX01FA113Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Essex, CARupture of the fuel injection flow divider diaphragm due to improper manufacture of the raw material stock from which the diaphragm was fabricated. The diaphragm tear resulted in complete engine power loss, which required the pilot to descend into an…NTSB LAX01LA107Accident · No injuriesLimited investigationFinal reportChristian Rans S-12 · Ramona, CAThe in-flight failure of the engine crankshaft for undetermined reasons.NTSB FTW01LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Brenham, TXthe in-flight separation of the throttle linkage, which resulted in the loss of engine power.NTSB FTW01LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA32-R-301T · Haslet, TXthe improper installation of the oil filter bypass valve by an unknown person, which resulted in the loss of engine oil and subsequent loss of total power during a normal descent. A contributing factor to the accident was the lack of suitable terrain for the…NTSB LAX01LA088Accident · No injuriesLimited investigationFinal reportFish RV6 · Georgetown, CAThe total loss of engine power due to fracture and separation of the engine crankshaft.NTSB FTW01LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Lancaster, TXmaintenance personnel's improper installation of the throttle lever lock nut. A contributory factor was the lack of suitable terrain for the forced landing.