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 CHI00LA173Accident · Minor injuriesLimited investigationFinal reportMcclish Funk B85C · Gardner, KSan improper modification to the engine which allowed a bearing to be misaligned, thus restricted the flow of oil through the engine. A factor associated with the accident was the wet field in which the forced landing was made.NTSB LAX00LA237Accident · No injuriesLimited investigationFinal reportCessna 150M · El Monte, CAThe inadequate maintenance inspection by other maintenance personnel of the exhaust system that resulted in an eroded muffler that allowed hot gases to impinge on magneto wiring and resulted in loss of engine power. A factor was the soft terrain at the forced…NTSB ATL00LA063Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Hampton, GAA total loss of engine power due to foreign object damage to the turbine wheel assembly.NTSB NYC00LA156Accident · Minor injuriesLimited investigationFinal reportStewart S-51 · Forty Fort, PAThe owner/builder's inadequate design, resulting in total failure of the reduction gear assembly accessory drive shaft.NTSB NYC00IA159Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE Jetstream 3201 · Lexington, KYA misalignment between the bull gear and high speed pinion gearshaft, which resulted in fatigue and a subsequent failure of the bull gear.NTSB CHI00LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNthe failure of the engine and the unsuitable terrain for landing encountered by the pilot-in-command. Factors to the accident were the fracture of the crankshaft due to fatigue, excessive main bearing wear, and the swampy terrain condition.NTSB FTW00LA178Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Welsh, LAThe excessive wear of the reduction gearbox's 1st stage sungear, which resulted in its subsequent fatigue fracture and failure. Factors were the operator not performing the recommended overhaul of the engine, and a lack of suitable terrain for the forced…NTSB FTW00LA168Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXthe loss of engine power in cruise flight as a result of the failure of the right magneto. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA159Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXThe failure of the supercharger seal resulting in the loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.NTSB NYC00LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Toms River, NJThe failure of the number 9 cylinder connecting rod, due to a primer leak initiation of a partial hydraulic lock. A factor in the accident was the unsuitable terrain, to which the forced landing had to be made.NTSB DEN00IA093Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Erie, COImproper installation of cylinders by unknown maintenance personnel who failed to torque the cylinder stud nuts sufficiently.NTSB LAX00LA202Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Boulder City, NVThe fracture and separation of the oil pressure line fitting, which resulted in a loss of oil and an oil starvation failure of the engine.NTSB MIA00LA157Accident · Serious injuriesLimited investigationFinal reportNavion L-17B · Sharpsburg, GATotal loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.NTSB ANC00FA056Accident · No injuriesField investigationFinal reportBeech B24R · Anchorage, AKA fatigue failure of the crankcase through bolt, the separation of number 3 cylinder assembly, and the inadequate maintenance/service of the airplane by company maintenance personnel.NTSB SEA00LA082Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Ephrata, WALoss of engine power due to failure of the number three cylinder exhaust valve push rod. Soft terrain encountered during the landing roll-out was a factor.NTSB NYC00LA125Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Nassawadox, VAA loss of engine power caused by detonation of the #2 piston.NTSB LAX00LA167Accident · No injuriesLimited investigationFinal reportEurocopter AS-350 BA · Kahului, HIFailure of the manufacturer to ensure proper quality control of the ignition solenoid housing chamfer area, which allowed for insufficient clamping forces between the ignition solenoid housing and T-fitting, and the eventual separation of the T-fitting, loss…NTSB FTW00LA127Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Tomball, TXEngine seizure due to the rupture of an oil cooler line.NTSB MIA00LA132Accident · Serious injuriesLimited investigationFinal reportHartline Glastar · Woodstock, ALa total engine failure for undetermined reason, resulting in a forced landing and subsequent impact with a tree.NTSB DEN00LA072Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Rocky Ford, COA total loss of power due to an engine rocker arm failure and soft/unsuitable terrain during the subsequent forced landing.NTSB DEN00IA076Incident · No injuriesIncident investigationFinal reportBeech A60 · Englewood, COThe failure of a number one cylinder connecting rod bolt due to under-torquing during engine major overhaul.NTSB FTW00LA118Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Oak Grove, LAThe failure of a spur gear from the torque sensor gear assembly resulting in a loss of engine power. A factor was the muddy terrain encountered during the forced landing.NTSB LAX00LA153Accident · No injuriesLimited investigationFinal reportQuicksilver Sprint 2 · Fresno, CAThe overheating and seizure of the number 2 piston for undetermined reasons. Also causal was the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which led to an inadvertent stall/mush.NTSB DEN00LA069Accident · Minor injuriesLimited investigationFinal reportHawkins & Powers UH-1B · Helper, UTTotal failure of the number 1 bearing due to lack of lubrication, the oil flow being restricted by a foreign object (epoxy hardener). Factors were trees and the unavailability of suitable terrain for a forced landing.NTSB DEN00LA064Accident · Minor injuriesLimited investigationFinal reportJohnson Zodiac CH 601 HDS · West Jordan, UTTotal failure of an oil line fitting, resulting in oil exhaustion and subsequent engine seizure. Factors were the poor fitting installation by the pilot, and unsuitable terrain on which to make a forced landing.NTSB DEN00LA066Accident · No injuriesLimited investigationFinal reportCessna 310C · Cedar City, UTThe failure of the right engine mixture control cable, which prevented the pilot from restarting the engine. Contributing factors were the pilot's failure to follow procedures by not feathering the right propeller, the rough terrain, and the high vegetation.NTSB LAX00FA123Accident · Serious injuriesField investigationFinal reportBoeing 369D · Rough And Ready, CAa loss of engine power due to oil starvation. The oil starvation was due to the seizure and failure of the turbine element oil pump shaft, which was caused by debris from a failed bearing seizing the pump. A factor in the accident was the lack of a suitable…NTSB ANC00LA035Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Delta Junction, AKThe disintegration of the number two piston. A factor in this accident was the subsequent metal fouling of the spark plugs, which resulted in total loss of engine power.NTSB SEA00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Richland, WAFailure of a connecting rod for undetermined reasons. Factors include unsuitable terrain for the forced landing attempt.NTSB CHI00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Macomb, ILthe inadequate maintenance inspection prior to the ferry flight by the pilot/mechanic rated passenger who endorsed the airplane as airworthy, the shift in the number two main bearing left half, and the fractured crankshaft. A factor was the rough/uneven…NTSB LAX00LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Bernardino, CAthe total failure of the engine number 1 cylinder exhaust valve.NTSB DEN00IA052Incident · No injuriesIncident investigationFinal reportCessna TR182 · Fort Carson, COThe pilot electing to fly the aircraft with known deficiencies which resulted in a catastrophic engine failure. Factors were a connecting rod failure, and low engine oil level.NTSB LAX00GA102Accident · No injuriesFinal reportCessna T210M · Elfrida, AZThe company mechanic's failure to correctly install one or more of the crankshaft counterweight pin retaining plate snap rings, specifically ensuring that the snap rings were fully seated in their grooves. This led to the complete separation of the No. 2…NTSB FTW00FA080Accident · 1 fatalField investigationFinal reportBeech B23 · New Braunfels, TXthe seizure of the engine while maneuvering due to the oil pressure relief valve plug ball seat becoming contaminated with metal. Contributing factors were the inadequate engine maintenance, and the lack of suitable terrain for the forced landing.NTSB LAX00LA087Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brawley, CAFailure of the engine due to improper installation of the intake and exhaust push rods (components were switched) by unknown maintenance personnel.NTSB FTW00LA074Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Rayville, LAThe loss of engine power due to a crack in the #6 cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB MIA00TA070Accident · Minor injuriesFinal reportBell UH-1H · Fort Myers, FLA total loss of engine power due to turbine wheel fracture resulting from fatigue for undetermined reasons that resulted in an autorotation to unsuitable terrain and hard touchdown and rollover.NTSB FTW00LA068Accident · No injuriesLimited investigationFinal reportMooney M20K · Tyler, TXThe failure of the crankshaft drive gear as a result of fatigue, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00TA065Accident · No injuriesFinal reportCessna 150F · Livingston, TXThe total loss of engine power resulting from an exhaust valve failure. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA074Accident · No injuriesLimited investigationFinal reportBeech F-33A · Mobile, AZthe manufacturer representative's improper reinstallation of the crankshaft counterweight snap rings which subsequently separated, allowing the crankshaft counterweight to contact the crankshaft resulting in a total power loss of engine power.NTSB FTW00LA061Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Sherman, TXA jammed carburetor needle which resulted in fuel starvation and the subsequent hard forced landing after takeoff. Contributing factors were the fence, trees, and pilot's maneuver to avoid these objects.NTSB FTW00LA057Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Odessa, TXThe separation of the #1 piston pin due to fatigue, which resulted in a total loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00FA046Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Edgewood, TXthe pilot's failure to maintain aircraft control during a forced landing which resulted in a stall/spin. Contributing factors were the failure of the engine driven fuel pump, the engine manufacturer's use of an inadequate fuel pump which was only intended for…NTSB NYC00LA054Accident · No injuriesLimited investigationFinal reportMooney 20J · New Milford, CTFailure of 3 of the 4 connecting rods for an undetermined reason.NTSB LAX00LA047Accident · No injuriesLimited investigationFinal reportBoeing 369E · Taft, CAThe fatigue failure of a second stage compressor vane due to erosion, which resulted in a catastrophic engine failure. An inadequate inspection of the compressor section by company maintenance personnel during the last 300-hour inspection was also causal in…NTSB FTW00LA038Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Stillwater, OKThe total loss of engine power due to the dry-rotted diaphragms in the pressure carburetor. A factor was the hilly terrain encountered during the forced landing.NTSB LAX00LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hilo, HIAn oil starvation induced failure and seizure of the engine. The reasons for the oil starvation event are undetermined.NTSB LAX00LA034Accident · Serious injuriesLimited investigationFinal reportHawker Siddeley Hunter T MK 7 · Mesa, AZThe fatigue failure and separation the stage 3 compressor blades due to corrosion pitting of the blade retention lug bores. A factor in the accident was the failure of the various post military surplus operators of this engine to incorporate the…NTSB FTW00LA033Accident · No injuriesLimited investigationFinal reportCessna TU206G · Lafayette, LAThe partial blockage of oil within the engine's oil galley resulting in a total power loss. Contributing factors were the failure of the #1 connecting rod, the failure of the pilot to achieve the proper touchdown point during the forced landing, the tailwind…