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 SEA96LA073Accident · No injuriesLimited investigationFinal reportCessna 500 · Salt Lake City, UTfatigue failure of the engine compressor impeller. Inadequate quality control by the manufacturer was a related factor.NTSB CHI96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Thief Rvr Falls, MNA ruptured oil line, which resulted in oil exhaustion and subsequent loss of engine power.NTSB LAX96LA164Accident · Minor injuriesLimited investigationFinal reportRussman Avid Flyer · Searchlight, NVan engine failure from oil exhaustion due to a leak in the oil line.NTSB IAD96FA055Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Wareham, MALoss of engine power due to bearing insert being destroyed by excess heat. A factor in this accident is the pilot's experience level.NTSB LAX96LA141Accident · Minor injuriesLimited investigationFinal reportScheperle Mustang II MOD · Merced, CAa loss of engine power due to a malfunctioning thermostat valve in the liquid cooling system.NTSB LAX96LA126Accident · Serious injuriesLimited investigationFinal reportWorthington BD-5B · San Martin, CAthe pilot/builder's improper installation (overtorque) of the ignition switch on the instrument panel, which caused an internal switch failure and subsequent malfunction of the ignition system.NTSB FTW96LA135Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARFailure of the engine master rod. A factor relating to the accident was: the lack of suitable terrain for a forced landing, due to the proximity of a power line and trees.NTSB FTW96LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dewitt, ARa loss of engine power due to the malfunction of the carburetor as a result of an improper overhaul. A factor was the unsuitable terrain for the forced landing.NTSB IAD96LA047Accident · No injuriesLimited investigationFinal reportBeech F35 · Mt. Sterling, KYa loss of engine power due to the failure of the number one piston. Related factors were the unsuitable terrain available for the forced landing, and the strong tailwind encountered during the forced landing.NTSB IAD96LA046Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Hazard, KYfailure of the engine crankshaft, which resulted in loss of engine power, a forced landing, and subsequent damage to the airplane. A factor relating to the accident was: lack of suitable terrain for a forced landing.NTSB LAX96LA124Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Tracy, CAoverheating and failure of the engine's master rod and master rod bearing due to oil starvation. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB CHI96LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Worthington, MNProgressive failure of the engine, beginning with failure of the left magneto, which resulted in preignition or detonation, a burned hole in the #3 piston, subsequent oil exhaustion, and failure of the #1 and #2 connecting rods.NTSB ATL96TA047Accident · Minor injuriesFinal reportPiper PA-32-300 · Windermere, FLthe use of improper connecting rod bolts, failure of the overhaul facility to record the correct overhaul date on the work orders for the stored connecting rod assemblies, and subsequent failure of the connecting rod bolts.NTSB ATL96LA046Accident · Minor injuriesLimited investigationFinal reportNorth American P-51D · Palm City, FLAn improperly adjusted carburetor which resulted in fuel starvation.NTSB FTW96LA116Accident · No injuriesLimited investigationFinal reportCessna 172K · Hedley, TXthe failure of maintenance personnel to properly torque the connecting rod bolts. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA110Accident · Serious injuriesLimited investigationFinal reportStolp Starduster II · Kahului, HIa faulty engine magneto, and decision by the pilot-in-command to operate the airplane with known deficiencies. A factor relating to the accident was: the airplane was overdue for an annual inspection.NTSB MIA96LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Boca Raton, FLthe partial loss of engine power due to the fatigue failure of the number 3 cylinder hold down studs and nut. A factor was the pilot'e evasive maneuver to avoid golphers on a golf course.NTSB LAX96LA104Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kamuela, HIfailure of the nose case (No.1) bearing resulting in oil starvation.NTSB LAX96FA097Accident · Minor injuriesField investigationFinal reportPiper PA-28-236 · Seal Beach, CAa total loss of engine power from an improperly installed magneto that separated from the engine housing due to fatigue from vibration.NTSB ATL96FA037Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Fort Pierce, FLimproper re-assembly of the engine induction air filter by maintenance personnel, during an annual inspection, which resulted in a loss of engine power during takeoff; failure of the pilot to abort the takeoff before lift-off; and failure of the pilot to…NTSB CHI96FA113Accident · 1 fatalField investigationFinal reportPiper PA-32 · Milwaukee, WIInadequate maintenance and inspection in that the Airworthiness Directive which applied to the fuel pump had not been complied with. A factor was the pilot was unable to reach land.NTSB FTW96LA094Accident · No injuriesLimited investigationFinal reportCessna A188B · Enid, OKThe pilot's failure to maintain sufficient airspeed during the forced landing and to jettison the aircraft's load for a forced landing. A factor was the engine's failure due to a disconnected fuel line which was the result of improper maintenance.NTSB MIA96LA052Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Eastover, SCinadequate overhaul procedures by maintenance personnel resulting in an oil pump failure and subsequent loss of engine power.NTSB FTW96LA081Accident · No injuriesLimited investigationFinal reportRepublic RC 3 · Whitewright, TXThe separation of a spark plug and 4 other spark plugs being 'finger' tight as a result of undertorquing by maintenance personnel when they were reinstalled following inspection. A factor was a lack of suitable terrain for the forced landing.NTSB MIA96FA049Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Ocala, FLoil starvation resulting in connecting rod failure in three of the six cylinders due to lack of lubrication. Contributing to the accident was the failure of the pilot to adhere to a ATC vector toward the nearest airport following engine failure which resulted…NTSB CHI96LA060Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe failure of the turbocharger, caused by a unapproved rebuild of the turbocharger which contained automotive parts. Debris from the failed turbocharger damaged the oil pump resulting in lack of engine lubrication.NTSB CHI96LA054Accident · Minor injuriesLimited investigationFinal reportBitonti Wittman WT-8 · Plymouth, MIa stuck exhaust valve resulting in an overtemperature condition of the cylinder, the pilot's continued operation without corrective maintenance, and his failure to maintain aircraft control.NTSB CHI96LA051Accident · No injuriesLimited investigationFinal reportCessna 182 · Tamms, ILfuel exhaustion due to inadequate maintenance performed on the fuel cap by the maintenance personnel, fuel siphoning out of the left fuel cap, and the failure of the pilot to properly monitor his fuel consumption.NTSB FTW96IA066Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Dfw Airport, TXfatigue failure of a first stage, high pressure, turbine blade.NTSB NYC96IA036Incident · No injuriesIncident investigationFinal reportBoeing 747-240 · Jamaica, NYfailure of the number two engine fan mid shaft, due a fatigue fracture caused by a previous bearing failure, and failure of the operator's maintenance personnel to detect the cracks during subsequent inspections.NTSB ATL96LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Athens, GAThe mechanic's failure to adequately inspect and repair the engine, which resulted in engine oil contamination, and the subsequent loss of engine power. A factor was the low ceiling.NTSB FTW96LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Eads, COFailure of the engine connecting rod bolts and separation of the cylinder from the crankcase. Factors were the lack of suitable terrain for the forced landing, and reduced light conditions (dark night).NTSB ATL96LA016Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Alexander City, ALThe leaking fuel injector, which created a rich mixture, and caused the aircraft engine to lose power.NTSB NYC96LA028Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Southbridge, MAfatigue failure of the engine crankshaft.NTSB FTW96LA050Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Estancia, NMimproper maintenance and inspection of the engine, ingestion of an air intake bypass door into the engine intake, detonation (or preignition), and failure of the #1 and #2 piston and connecting rod assemblies. A factor relating to the accident was: the lack…NTSB ATL96LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Durham, NCThe aircraft mechanic's failure to follow engine overhaul procedures which resulted in the failure of the camshaft drive gear.NTSB ATL96LA013Accident · No injuriesLimited investigationFinal reportFleet ONE · Holly Springs, NCa loss of engine power due to a cracked crankshaft. A factor was the rough/uneven terrain encountered during the forced landing.NTSB ATL96LA012Accident · No injuriesLimited investigationFinal reportWaco ASO · Ridgeland, SCFailure of the ignition system after takeoff, which resulted the loss of engine power.NTSB ANC96LA017Accident · No injuriesLimited investigationFinal reportCessna 207 · Aniak, AKfatigue failure of the engine crankshaft at the number 2 main bearing journal, where rubbing contact had occurred with the number 2 main bearing. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB MIA96LA018Accident · Minor injuriesLimited investigationFinal reportBoeing E75N1 · Wauchula, FLA total loss of engine power due to worn serrated teeth on the valve timing gear and intermediate camshaft drive gear which prevented the valve train and generator from operating. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Congress, AZfailure of the #3 cylinder exhaust valve. A factor was the pilot's need to perform an evasive maneuver to avoid colliding with an automobile.NTSB NYC96LA019Accident · Serious injuriesLimited investigationFinal reportPezold Lancair IV-P · Somerset, PAfailure of the fuel pump driveshaft, which resulted in fuel starvation and loss of engine power.NTSB FTW96LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Dibble, OKan overload failure of the #1 connecting rod bolt and resulting connecting rod fatigue failure. A factor was the lack of suitable terrain for the forced landing.NTSB MIA96FA013Accident · No injuriesField investigationFinal reportBoeing 747-121 · Miami, FLfailure of the No. 4 engine fifth stage turbine hub due to a cyclic stress rupture for undetermined reasons, which resulted in an uncontained failure of the engine.NTSB ATL96LA008Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Tuscaloosa, ALFatigue failure of the number one piston assembly, which resulted in a loss of engine power.NTSB CHI96LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocie, MOfailure of the number three exhaust valve.NTSB NYC96FA012Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Atlantic Ocean (Atlantic Ocean)a total loss of left engine power as a result of an in-flight separation of the #2 cylinder. The cylinder separated due to high stress fatigue cracking of the cylinder hold down studs and the #3 main bearing thru-studs. Factors in this accident were: improper…NTSB ATL96LA005Accident · No injuriesLimited investigationFinal reportMooney M20K · Dalton, GAOil starvation for an unknown reason, which resulted in progressive connecting rod failure and subsequent loss of engine power. Factors relating to the accident were: the unfavoable weather and light conditions (low ceiling and fog at dusk), which hampered…NTSB LAX96LA009Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Hana, HIthe loss of engine power due to inadequate maintenance inspection of the fuel system which permitted air to enter the engine fuel supply. A factor in the accident was the pilot's improper execution of the autorotation landing.NTSB CHI96LA007Accident · Minor injuriesLimited investigationFinal reportRoisum Team MINI-MAX · Neenah, WIFuel starvation due to fuel filter blockage. Factors associated with the accident were the manufacturers design of the fuel filter and the builder/pilots decision to use an automotive type fuel filter.