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 BFO93FA131Accident · 1 fatalField investigationFinal reportBeech C33A · Paintsville, KY1) Fatigue failure of the engine crankshaft at the number 2 main journal due to undetermined reason (s) which resulted in the total loss of engine power, and 2) the pilot not maintaining an adequate airspeed which resulted in an inadvertent stall/spin. A…NTSB DEN93LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Dermott, ARPower loss due to the total failure of the engine's master rod. Factors were an improper engine overhaul and the lack of suitable terrain for a forced landing.NTSB FTW93LA215Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.NTSB BFO93LA122Accident · Serious injuriesLimited investigationFinal reportSchultz/Bowers FLY Baby 1A · Conneaut, OHOperational failure of the left magneto's high tension wiring due to grease/corrosion, which resulted in a progressive power loss and subsequent forced landing.NTSB BFO93LA121Accident · No injuriesLimited investigationFinal reportCessna 404 · Cincinnati, OHThe failure of a number three engine cylinder hold down bolt due to fatigue.NTSB SEA93LA150Accident · No injuriesLimited investigationFinal reportHoopes Hummelbird · Salt Lake City, UTA fractured crankshaft.NTSB BFO93FA113Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Madison Heights, VAEngine failure due to oil starvation as a result of inadequate maintenance and inspection of the oil cooler lines.NTSB CHI93LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Felton, MNThe pilot-in-command's failure to maintain airspeed. Factors contributing to the accident were a cracked carburetor float, fuel starvation, and the failure to perform an annual inspection.NTSB ATL93FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clayton, ALInadequate maintenance and inspection of the carburetor by maintenance personnel.NTSB NYC93LA135Accident · No injuriesLimited investigationFinal reportBeech C23 · Montgomery, NYA power loss due to a collapsed air duct and a consequent blockage of induction air, which resulted in a forced landing and an on ground collision with a ditch.NTSB ATL93LA119Accident · Minor injuriesLimited investigationFinal reportWaco ATO · Alma, GAThe failure of the aircraft engine master rod bearing.NTSB ATL93LA118Accident · No injuriesLimited investigationFinal reportCessna 188B · Centre, ALThe failure of maintenance personnel to properly torque the crankcase through bolts.NTSB CHI93DEE02Accident · Minor injuriesFinal reportDouglas B-26B · Kankakee, ILthe failure of the piston assembly in the number ten cylinder of the right engine. A factor associated with the accident was the inoperative propeller feathering system for the right engine.NTSB ATL93LA116Accident · No injuriesLimited investigationFinal reportGrumman G164A · Brundidge, ALThe broken carburetor accelerator pump piston rivet which lodged under the needle valve, allowed the float chamber to flood with fuel, and the engine to quit. The lack of suitable terrain for a forced landing was a factor.NTSB CHI93LA219Accident · No injuriesLimited investigationFinal reportBeech B19 · Victoria, MNThe loss of engine power due to a jammed carburetor float and the inability of the pilot to maintain clearance during the emergency landing.NTSB LAX93LA263Accident · Minor injuriesLimited investigationFinal reportSill/Thomas Long EZ · Lone Pine, CAthe failure of the number four cylinder exhaust valve due to excessive heat exposure and lack of maintenance.NTSB CHI93LA215Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilton, NDFailure of the engine-driven fuel pump. A factor was the pilot's failure to select the auxiliary fuel pump.NTSB CHI93LA216Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Malden, MOA broken mixture control cable resulting in fuel starvation.NTSB NYC93LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Holbrook, NYThe engine failure as the result of a fractured crankshaft due to metal fatigue.NTSB FTW93LA190Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wynne, ARThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB CHI93LA212Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Buckner, MOThe nut backing off the connecting rod bolt resulting in rod failure. A factor involved in this accident was the lack of suitable terrain for the pilot in command to make a run on landing.NTSB CHI93LA207Accident · No injuriesLimited investigationFinal reportRobert L. Kennedy Avid Flyer · White Pigeon, MIThe pilot in command's inability to attain proper touch down point. The improperly adjusted idle setting which resulted in the loss of engine power was also a cause.NTSB FTW93LA186Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Edgewood, NMPower loss to the right engine due to the magneto grounding leads being loose and an inadequate annual inspection. A factor was a lack of suitable terrain.NTSB ATL93LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Attalla, ALThe failure of the left engine turbocharger due to rotor shaft seizure, which resulted in a loss of engine power.NTSB CHI93LA197Accident · No injuriesLimited investigationFinal reportCessna 210L · Indianola, IAA fatigue fracture of the crankshaft.NTSB CHI93DEE01Accident · No injuriesFinal reportMark Streitz Skybolt · Joliet, ILthe failure of the number two connecting rod bolt.NTSB ANC93LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Skagway, AKA total loss of engine power as a result of a fatigue failure of the #2 connecting rod. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.NTSB FTW93LA171Accident · No injuriesLimited investigationFinal reportAyres SR2-T34 · Harrisburg, ARThe loss of engine power due to the failure of the reduction gear assembly due to fatigue. A factor was the lack of suitable terrain for the forced landing.NTSB MIA93LA136Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Laurel, MSA ruptured center bellows seal in the fuel servo and/or a plugged fuel injector due to contamination (rust) from the fuel servo. Factors related to the accident were: improper servicing of the aircraft, and people and trees in the emergency landing area.NTSB MIA93LA134Accident · No injuriesLimited investigationFinal reportCessna 182P · Corinth, MSFailure of the engine over terrain unsuitable for a forced landing. Contributing to the accident was the failure of the no. 5 piston for undetermined causes.NTSB LAX93LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hesperia, CAFatigue failure of the exhaust valve due to inadequate maintenance and inspection.NTSB CHI93FA182Accident · 2 fatalField investigationFinal reportAerospatiale AS-350B · Cameron, MOThe loss of engine power due to failure of the second stage turbine labyrinth seal. Factors related to the accident were: the unfavorable wind and tall trees bordering the emergency landing area.NTSB SEA93LA113Accident · Minor injuriesLimited investigationFinal reportMurphy Barracuda · Yoncalla, ORThe engine oil filter vibrating loose resulting in oil starvation, and the pilot in command's misjudgment of winds. A factor contributing to the accident was unfavorable winds.NTSB FTW93LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Belmont, LAThe loss of engine power due to a sheared accessory drive pin. A factor was the unsuitable terrainNTSB CHI93DER02Accident · No injuriesFinal reportMiller Quickie · Glencoe, MNThe disconnection of the ignition switch wiring.NTSB BFO93LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, VAFatigue failure of the engine crankshaft at the number 1 journal. A factor related to the accident was unsuitable terrain in the emergency landing area.NTSB ANC93FA061Accident · Minor injuriesField investigationFinal reportBell 214B1 · Thorne Bay, AKForeign object damage to the compressor assembly, probably due to loose nuts from the compressor case after improper maintenance (installation) by maintenance personnel.NTSB LAX93LA200Accident · 1 fatalLimited investigationFinal reportGrumman 164A · Biggs, CAFailure of the number 2 engine cylinder. A factor related to the accident was the lack of altitude for the pilot to make a successfull forced landing.NTSB CHI93FA158Accident · 1 fatalField investigationFinal reportBeech E-18S · Lone Rock, WIwas a pre-mature extension of the landing gear by the pilot which resulted in the inability of the pilot to maintain the minimum descent altitude. Factors related to the accident were the loose cylinder and loss of oil.NTSB LAX93LA194Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Oakland, CAthe pilot's poor decision to continue flying the airplane with a known deficiency and the poorly performed major overhaul of the engine. The failed crankshaft due to fatigue are factors in this accident.NTSB BFO93LA080Accident · No injuriesLimited investigationFinal reportMcmillin Fisher 404 · Wampum, PAThe overtorque of a safety wire on a plastic fuel line, causing the line to split.NTSB LAX93FA190Accident · No injuriesField investigationFinal reportCessna 172 · Bullhead City, AZa fatigue failure of the crankshaft due to improper assembly of the engine during the major overhaul.NTSB MIA93FA109Accident · 1 fatalField investigationFinal reportCessna TU206D · Culebra, PRFatigue failure of the engine crankshaft that originated from a heat check crack in the journal, adjacent to the #2 main journal forward fillet.NTSB NYC93LA091Accident · No injuriesLimited investigationFinal reportHomer Davis RV4 · Danville, VAThe loss of engine power due to a stuck carburetor needle valve; subsequent forced landing in unsuitable terrain, and impact with a tree.NTSB CHI93LA147Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Middle River, MNThe total failure of the ignition system's magneto.NTSB LAX93LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Needles, CAthe total loss of engine power due to the failure of the magneto in the ignition system. The magneto failure resulted from the operator's lack of voluntary compliance with the manufacturers suggested overhaul cycle.NTSB FTW93LA136Accident · Minor injuriesLimited investigationFinal reportTuttle Star Lite · Conroe, TXA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landingNTSB SEA93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Casper, WYFuel exhaustion, and the pilot in command's poor inflight decision. Factors include an inadequate preflight by the pilot in command.NTSB CHI93LA123Accident · Minor injuriesLimited investigationFinal reportRockwell 100 · Topinabee, MIthe total loss of engine power due to failure of the oil line to the oil pressure gauge. A factor relating to the accident was no suitable terrain on which to make a forced landing.NTSB BFO93LA062Accident · Minor injuriesLimited investigationFinal reportKibiuk Quickie · Durhamville, NYThe loose battery cable to the negative terminal, resulting in total power loss. A factor related to the accident was the lack of suitable terrain for an emergency landing.