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 CHI96LA262Accident · Minor injuriesLimited investigationFinal reportPiper PA-J3C · Camp Lake, WIseizure of the number 2 piston. Inadequate maintenance was a related factor.NTSB LAX96LA291Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Tracy, CAA loss of engine power due to the disengagement of the crankshaft gear from it's hub due to the overload shear of the eight retaining screws.NTSB LAX96LA293Accident · No injuriesLimited investigationFinal reportThompson Long EZ TR · Yucca Valley, CAFuel starvation due to the internal failure of the electric fuel pump and the subsequent fuel flow blockage to the gascolator.NTSB CHI96LA282Accident · No injuriesLimited investigationFinal reportCessna 188-230 · Santanta, KSa loss of power due to a broken number four cylinder exhaust valve push rod and a bent number four cylinder intake valve push rod. The wet, soft cornfield was a factor.NTSB ATL96LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Memphis, TNInadequate annual inspection that resulted in the in-flight loss of the fuel system strainer and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.NTSB ANC96LA103Accident · No injuriesLimited investigationFinal reportCessna 172XP · Kenai, AKThe loss of engine power due to seized piston connecting rod bearings, and subsequent failure of the piston connecting rod cap and fracture of the piston connecting rod. A factor associated with the accident was the rough and uneven emergency landing site.NTSB LAX96LA280Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Scottsdale, AZan uncontained failure of the second stage turbine wheel due to fatigue. Factors were: obstructions in the forced landing area and the inability of the airplane to climb after the turbine wheel failure.NTSB CHI96LA248Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Rose Hill, KSthe worn carburetor, and inadequate inspection of the aircraft by other maintenance personnel.NTSB ANC96FA102Accident · 4 fatalField investigationFinal reportDouglas DC-6A · Russian Mission, AKfatigue failure of the master connecting rod, which originated from corrosion pitting, subsequently compromised the engine crankcase, and resulted in a fire; and failure of the flight crew to follow emergency procedures by pulling the fire handle before…NTSB LAX96LA274Accident · No injuriesLimited investigationFinal reportCessna 172N · Daggett, CAThe fracture and separation of an exhaust valve head for undetermined reasons.NTSB MIA96LA183Accident · No injuriesLimited investigationFinal reportRockwell S2R · Belzoni, MSfatigue failure of the #5 cylinder skirt, which resulted in debris that caused the oil scavenge pump to fail, oil starvation, cam drive seizure, loss of engine power, and a subsequent forced landing in a field of cotton.NTSB LAX96LA270Accident · No injuriesLimited investigationFinal reportCessna 177RG · Folsom, CAAn oil starvation failure of the engine due to a mechanic's failure to put the proper gasket stack on when the propeller governor was replaced. The mechanic's omission was due to the airframe manufacturer's failure to ensure that the service and parts manuals…NTSB MIA96LA180Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pigeon Forge, TNfatigue failure of the engine PC line, induced by damage from improper installation, which resulted in a loss of engine power and an autorotative landing to unsuitable terrain.NTSB DCA96MA068Accident · 2 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Pensacola, FLthe fracture of the left engine's front compressor fan hub, which resulted from the failure of Delta Air Lines' fluorescent penetrant inspection process to detect a detectable fatigue crack initiating from an area of altered microstructure that was created…NTSB NYC96LA141Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Boston, MAa fracture failure of the crankcase, which resulted in separation of the number five cylinder, loss of engine power, and a ditched landing.NTSB ATL96LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsborough, NCThe failure of the magneto impulse coupling spring. A factor was the power line at the approach end of the forced landing site.NTSB CHI96LA229Accident · Minor injuriesLimited investigationFinal reportHewitt Cassutt 3M · Vermillion, SDthe failure of the unapproved fuel pump.NTSB ANC96TA095Accident · Minor injuriesFinal reportCessna 185 · Fairbanks, AKfatigue failure of the engine crankshaft. A factor related to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW96FA282Accident · No injuriesField investigationFinal reportSaab-Scania SF340B · Dfw Airport, TXThe manufacturer's inadequate procedure for manufacturing the number two turbine disk.NTSB FTW96LA280Accident · No injuriesLimited investigationFinal reportCessna 182N · Truth Or Conseq, NMThe loss of engine power due to the fatigue failure of the number one piston. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA213Accident · No injuriesLimited investigationFinal reportCessna 172 · Conway, MIA crack in the intake manifold which led to oil exhaustion and subsequent piston failure. A factor was the soft field.NTSB MIA96LA161Accident · No injuriesLimited investigationFinal reportCessna 170A · Southside, ALfailure of an oil line between the engine and the oil cooler, which resulted in loss of oil, oil starvation, and subsequent seizure of the engine. Factors relating to the accident were: the effects of a tailwind during the forced landing, and failure of the…NTSB FTW96LA272Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Holyoke, COthe total failure of the engine main bearing. A factor was the soft terrain condition on which the forced landing was made.NTSB FTW96LA264Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Littlefield, TXThe total loss of engine power due to the failure of the number 5 and 6 connecting rods. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA263Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec AN-2 · Weir, TXengine seizure for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96FA130Accident · 1 fatalField investigationFinal reportHughes 269C · Eldon, WAfatigue failure of the connecting rod cap, which resulted in loss of engine power and ditching at sea.NTSB ATL96LA093Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lake Placid, FLmaintenance personnel's failure to properly torque the cylinder installation bolts.NTSB ANC96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gustavus, AKA loss of engine power due to low fuel pressure from the engine driven fuel pump and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.NTSB FTW96IA248Incident · No injuriesIncident investigationFinal reportFairchild SA227-DC · Enid, OKfailure of the accessory drive bearing, causing the accessory drive gear teeth to shear and disengage the fuel pump accessory drive shaft, resulting in a disabled fuel pump and subsequent fuel starvation.NTSB IAD96LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · New Carlisle, OHinadequate maintenance and inspection, and the pilot overshooting the approach to land.NTSB CHI96LA189Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Greenville, MIforeign material, probably due to improper maintenance, which blocked the main fuel metering jet of the carburetor, and resulted in fuel starvation and loss of engine power.NTSB LAX96LA215Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Sonora, CAfailure of the number 1 connecting rod due to oil starvation caused by inadequate bearing crush.NTSB NYC96LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Williamstown, NJinadequate maintenance, which resulted in a failure of the magneto housing hold-down flange, a disconnect of the magneto from the engine, and loss of engine power. The obstruction (fence post) in the emergency landing area was a related factor.NTSB LAX96LA213Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lost Hills, CAthe loss of engine power due to a cylinder failure. A contributing factor was the lack of a suitable field for the forced landing.NTSB NYC96LA117Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chatham, MAfailure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…NTSB CHI96LA186Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Crookston, MNcatastrophic engine failure.NTSB FTW96LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Griffithville, ARloss of engine oil (leak) for an undetermined reason, which resulted in oil starvation and a loss of engine power; and failure of the pilot to maintain airspeed during the emergency descent/landing phase, which resulted in an inadvertent stall and subsequent…NTSB CHI96LA163Accident · No injuriesLimited investigationFinal reportJohnson Avid Flyer · Rockford, MIengine overtemperature which occurred for an undetermined reason. A factor was the excessive descent rate.NTSB FTW96FA216Accident · 2 fatalField investigationFinal reportNanchang CJ-6A · Shreveport, LAa loss of engine power due to failure of the pressure carburetor diaphragm which led to restricted fuel flow through the carburetor and eventual fuel starvation. Factors contributing to the accident were the unsuitable terrain and tall trees which resulted in…NTSB LAX96LA196Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Williams, CAThe pilot's failure to maintain directional control during a rejected takeoff, and the catastrophic failure of the engine's turbine section due to an improper overhaul procedure. A factor in the accident was the close proximity of the drainage ditch to the…NTSB NYC96LA100Accident · No injuriesLimited investigationFinal reportCessna P206D · Harrison, NYseparation of the number one connecting rod bolt, which resulted in a total loss of engine power.NTSB MIA96LA131Accident · No injuriesLimited investigationFinal reportCessna 210M · Meridian, MSprevious engine damage; failure of the pilot of the previous flight to report to the operator and/or mechanics that the engine had been operated with low (or no) oil pressure; inadequate maintenance/inspection after most of the oil had leaked from the engine…NTSB FTW96LA184Accident · Minor injuriesLimited investigationFinal reportCessna T210M · El Paso, TXfailure of the #2 cylinder connecting rod bolt due to oil starvation as a result of the shifting of the main bearing. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA178Accident · No injuriesLimited investigationFinal reportCessna 152 · Bullard, TXfailure of an engine exhaust valve, which resulted in a loss of engine power, a forced landing, and subsequent damage to the airplane. Factors relating to the accident were: the tailwind, and the wet grass runway.NTSB ANC96LA053Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Grayling, AKdisintegration of the alternator drive coupling, jamming of the accessory drive gear, shearing of the oil pump drive, oil starvation, and failure of the number 6 cylinder connecting rod. Non-compliance with a manufacturer's service bulletin and soft snow were…NTSB IAD96LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Dover, DEthe overhaul maintenance personnel's improper major overhaul procedure (improper torque on the engine block center through bolts), which resulted in an in flight loss of engine power. A related factor was the lack of suitable terrain available for a forced…NTSB MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA167Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Akron, COa total loss of engine power due to failure of the number 2 cylinder. A factor was the limited cockpit visibility due to windscreen damage and engine oil coating.NTSB LAX96FA155Accident · Serious injuriesField investigationFinal reportCessna 182RG · Beaver Dam, AZan engine failure due to oil starvation resulting from the pilot's improper aircraft preflight. A factor relating to the accident was: failure of the operator to ascertain that proper maintenance was performed after the airplane's high oil consumption rate…NTSB SEA96FA076Accident · No injuriesField investigationFinal reportBell UH-1H · Rainier, WAfailure of the forward power shaft (number 21) bearing. A factor relating to the accident was: the lack of suitable, unobstructed terrain for an emergency landing.