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 CHI04LA280Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Kingman, KSThe lack of engine oil due to the mechanic's improper maintenance in not securing the loose "B" nut for the oil pressure line to the turbocharger leading to the loss of engine power while maneuvering. An additional cause was the unsuitable terrain the pilot…NTSB NYC04LA214Accident · Serious injuriesLimited investigationFinal reportRyan ST3KR · Bealeton, VAThe improper installation of fuel lines by maintenance personnel resulting in a total loss of engine power.NTSB CHI04LA283Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Houstonia, MOThe fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.NTSB FTW04LA238Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sweeny, TXThe fracture failure of the left engine crankshaft for undetermined reasons.NTSB SEA04LA189Accident · No injuriesLimited investigationFinal reportCessna P206A · Clearwater, IDA loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.NTSB MIA04LA127Accident · No injuriesLimited investigationFinal reportMooney M20F · Brandon, MSA loss of engine power due to the fatigue failure of all studs and/or thru-bolts of the No. 3 cylinder for undetermined reasons causing separation of the cylinder. Contributing to the accident was the unsuitable terrain encountered by the pilot.NTSB NYC04LA201Accident · No injuriesLimited investigationFinal reportPZL 101 · Chazy, NYThe total loss of engine power due to the fractured crankshaft.NTSB FTW04LA227Accident · No injuriesLimited investigationFinal reportGrumman 164B · East Bernard, TXThe loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB LAX04IA311Incident · No injuriesIncident investigationFinal reportSikorsky S-70A · Pacoima, CAthe failure of the operator's mechanics to install the turboshaft engine's forward curvic seal during a gas generator turbine (GGT) replacement. Contributing factors to the incident were the failure of the manufacturer to provide a forward curvic seal with…NTSB LAX04LA292Accident · No injuriesLimited investigationFinal reportAmerican Champion 7ECA · Manchester, CAmaintenance personnel's failure to adequately torque the top spark plug on the number one cylinder, which resulted in a separation of that plug and a loss of engine power.NTSB CHI04FA203Accident · 1 fatalField investigationFinal reportKnoepflein Lancair Legacy 2000 · Madison, WIA loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…NTSB LAX04LA280Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ontario, CAa catastrophic engine failure due to the overheating of a connecting rod bearing, and the resulting failure of the rod, for undetermined reasons.NTSB DEN04LA107Accident · No injuriesLimited investigationFinal reportCessna P210N · Douglas, WYthe failure of the engine's crankshaft due to the rotation of the engine's number two bearing, which resulted in the oil starvation of the crankshaft's number 2 main journal. Contributing factors include the engine's improper maintenance, and the in-flight…NTSB DEN04LA105Accident · No injuriesLimited investigationFinal reportMooney M20C · Escalante, UTthe improper installation of an oil pan quick-drain fitting resulting in the loss of engine oil, failure of the engine, and subsequent impact with terrain following an attempted forced landing. A contributing factor was the lack of suitable terrain for a…NTSB CHI04LA185Accident · Serious injuriesLimited investigationFinal reportVarga 2150A · Winterset, IAThe inadequate supervision by the certified flight instructor, fuel starvation, visual/aural detection precluded by the certified flight instructor's seat position, and the inadequate crew coordination of both pilots during the instructional flight. A…NTSB ATL04LA157Accident · Minor injuriesLimited investigationFinal reportBeech A45 · LaGrange, GAThe maintenance personnel under-torquing of the crankcase throughbolts during top overhaul, which resulted in crankcase fretting, and the subsequent fatigue failure of the crankshaft at the No. 4 main journal. A factor was the lack of suitable terrain for…NTSB LAX04LA257Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Castaic, CAa catastrophic engine failure due to oil exhaustion, which was caused by the failure of maintenance personnel to completely tighten the oil screen.NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB DEN04LA098Accident · No injuriesLimited investigationFinal reportCessna T210N · Spanish Fork, UTthe improper reassembly of the engine following major overhaul (application of Permatex over entire crankcase surfaces). Contributing factors included the number 2 main bearing and crankshaft shifting forward, causing the alternator drive shaft and other…NTSB CHI04LA187Accident · No injuriesLimited investigationFinal reportBeech A36 · Algona, IAThe failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…NTSB LAX04LA251Accident · No injuriesLimited investigationFinal reportSocata TB-20 · Perris, CAA loss of engine power due to oil exhaustion as a result of the mechanic's use of an incorrect gasket during the installation of the vacuum pump.NTSB CHI04CA162Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Britton, SDThe loss of engine power due to a stuck exhaust valve and the unsuitable terrain encountered during the forced landing. A factor to the accident was the soft terrain condition.NTSB MIA04LA099Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Deland, FLA loss of engine power due to an engine master rod bearing failure for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB LAX04LA232Accident · No injuriesLimited investigationFinal reportBeech S35 · Flagstaff, AZoil exhaustion due to a leak from the bottom oil drain line gasket and o-ring for the turbo charger.NTSB CHI04LA147Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Manitowoc, WIFailure of the number 4 piston articulating rod resulting in a complete loss of engine power during initial climb. The ditch was a contributing factor.NTSB CHI04LA144Accident · No injuriesLimited investigationFinal reportBeech M35 · Strafford, MOThe improper installation of the cylinder during the engine overhaul which resulted in the fatigue failure of the cylinder studs and through-bolts and the subsequent separation of the cylinder. Factors associated with the accident were the fence and the guy…NTSB DEN04LA083Accident · No injuriesLimited investigationFinal reportAyres S-2R · Beaver, UTthe in-flight failure of the engine's P3 tube which resulted in the loss of engine power and the subsequent impact with terrain during a forced landing. Contributing factors include the lack of suitable terrain for a forced landing and the fence.NTSB LAX04LA229Accident · No injuriesLimited investigationFinal reportSimmons BD-5 · Goodyear, AZThe overheating and failure of the number 4 connecting rod, which resulted in a total loss of engine power during descent.NTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…NTSB LAX04LA228Accident · Minor injuriesLimited investigationFinal reportWilson Avid Bandit · Paso Robles, CAthe loss of engine power during takeoff climb due to a cold seizure of the rear cylinder.NTSB CHI04CA142Accident · No injuriesData collectionFinal reportKauffman Bede IV · Acme, MIEngine oil starvation and inadequate maintenance by the pilot.NTSB LAX04TA202Accident · No injuriesFinal reportBell OH-58A+ · Bakersfield, CAloss of engine power due to the separation of the diaphragm portion of the repaired second-stage turbine nozzle from the rim portion due to the use of an inadequate cleaning method to clean the joint prior to the braze repair during overhaul by the…NTSB DEN04FA064Accident · Minor injuriesField investigationFinal reportCessna 150H · Boulder, COthe failed magneto and the lack of suitable terrain (lake) for a forced landing.NTSB FTW04LA110Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Locust Grove, OKThe improper installation of the generator, which resulted in oil starvation. A factor was the unsuitable terrain.NTSB NYC04LA105Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Taylor, PAThe failure of the number 2 connecting rod, after a main bearing shift, which resulted in a catastrophic engine failure.NTSB MIA04LA067Accident · No injuriesLimited investigationFinal reportCessna 206 · Clewiston, FLThe failure of the No. 2 cylinder connecting rod for undetermined reasons, and the failure of one of the connecting rod bolts due to tension overload resulting in the total loss of engine power and subsequent collision with a ditch during the forced landing.NTSB ATL04FA090Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Johns Island, SCThe pilot's failure to maintain airspeed during emergency descent, which resulted in an inadvertent stall/spin and uncontrolled descent into trees and terrain. A factor was the loss of engine power in one engine due to pre-ignition/detonation.NTSB LAX04LA171Accident · No injuriesLimited investigationFinal reportMaule M-7-260C · Paso Robles, CAfuel system vapor lock due to the failure of the left exhaust stack clamp pin, which caused a separation of the exhaust stack from the muffler and the porting of hot exhaust gases onto the fuel lines.NTSB LAX04LA169Accident · Minor injuriesLimited investigationFinal reportStanley Glasair SH-2 · San Luis Obispo, CAThe loss of engine power due to the failure of the #3 cylinder piston and connecting rod for undetermined reasons.NTSB LAX04LA141Accident · No injuriesLimited investigationFinal reportVogt KR2S · Lompoc, CAa failure of the fuel pump, which induced a total loss of engine power.NTSB LAX04LA140Accident · No injuriesLimited investigationFinal reportAlan Wilson Tandum Air Bike · Elko, NVA total loss of engine power during cruise flight due to the failure of an ignition system component.NTSB LAX04LA132Accident · 1 fatalLimited investigationFinal reportGillespie Sport Copter Vortex · Yuba City, CAa loss of engine power due to the incorrect installation of the fuel line, which resulted in fuel starvation, and the pilot's failure to maintain rotor RPM, which resulted in an inflight loss of control. A factor to the accident was the pilot's lack of…NTSB DEN04LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTthe failure of the exhaust valve for the engine's number one cylinder, resulting in the exhaust valve/piston contact and the subsequent total loss of engine power. Contributing factors include the lack of suitable terrain for a forced landing and the snow…NTSB NYC04LA065Accident · No injuriesLimited investigationFinal reportCessna 150F · Suffolk, VAThe failure of the number four cylinder barrel due to fatigue which originated from a corrosion pit at the base of a cooling fin.NTSB MIA04LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Immokalee, FLA loss of engine power due to the airplane mechanic's improper maintenance/installation and failure to ensure that the B-nut on the inlet side of the fuel manifold was properly tightened, which resulted in a fuel leak, and fuel starvation.NTSB LAX04LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Santa Rosa, CAthe failure of the number 2 cylinder barrel due to fatigue. The lack of suitable landing terrain was a factor in the accident.NTSB ATL04LA066Accident · Minor injuriesLimited investigationFinal reportCurrent Kitfox 313 · Selma, ALThe pilot's inadequate installation, and his failure to secure the main fuel line, which resulted in fuel starvation.NTSB FTW04FA057Accident · 1 fatalField investigationFinal reportCessna 182RG · El Dorado, ARThe loss of engine power as a result of loss of engine oil due to the failure of the oil filter converter plate gasket and the noncompliance to an airworthiness directive. Contributing factors were the lack of suitable terrain for the forced landing and the…NTSB LAX04LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Riverside, CAengine oil exhaustion due to the extrusion of an oil filter converter plate gasket and the failure of the aircraft owner to comply with a mandatory Service Bulletin and a Federal Aviation Administration emergency Airworthiness Directive.NTSB LAX04LA069Accident · Serious injuriesLimited investigationFinal reportAllison KR-2 · Glendale, AZloss of engine power due to a loose carburetor jet. A contributing factor was the owner/operators failure to have a condition inspection performed on the aircraft.