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 NYC91LA185Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Templeton, MAFuel starvation induced power loss on first the left engine due to a failed fuel fitting and then the right engine due to a worn fuel fitting. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91DPG15Accident · No injuriesFinal reportGrumman 164B · Brinkley, ARA blocked fuel screen which resulted in a fuel starvation induced loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB MIA91LA202Accident · No injuriesLimited investigationFinal reportCessna A188B · Hollandale, MSOverload failure of the no. 5 cylinder connecting rod bolt due to being loose for undetermined reasons. This resulted in the damage during the forced landing following total loss of engine power.NTSB FTW91FA124Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Whitharral, TXPower loss due to fuel exhaustion. Factors were the pilot's operation with the known inoperative landing light and the dark night.NTSB NYC91LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Springwater, NYThe on ground collision with trees during a forced landing after the pilot experienced an engine failure due to a broken exhaust valve.NTSB LAX91LA315Accident · 2 fatalLimited investigationFinal reportPiper PA32-300 · Corona, CAThe pilot's failure to maintain an airspeed above the aircraft's stall speed after the engine failed. Factors contributing to the accident were: the failure of the engine, magneto and accessory drive gear, the rough terrain conditions over which the engine…NTSB CHI91MA220Accident · No injuriesMajor investigationFinal reportAerospace ATR-42-300 · Peoria, ILInadequate aircraft equipment component (failed bolt), and insufficient inspection standards pertaining to the failed bolt. A factor related to the accident is inaccurate maintenance record keeping relating to oil consumption.NTSB LAX91LA314Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · So. Lake Tahoe, CAEngine failue due to the failure of the crankshaft resulting from failure induced by a non-metallic inclusion in the shaft.NTSB SEA91LA167Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Burley, IDPowerplant failure for undetermined reasons. Factors include in-flight collision with a tree.NTSB NYC91FA178Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Yarmouth, MAThe failure of the number one cylinder fuel injector line due to fatigue cracking induced by corrosion and propagated by cyclic loading which resulted in a total loss of engine power. The corrosion was due to the manufacturer's process of brazing the metal…NTSB CHI91FA208Accident · 1 fatalField investigationFinal reportTemco D-16A · Eau Claire, MIThe improper replacement of the fuel selector lever which resulted in loss of engine power due to fuel staration.NTSB CHI91DEX04Accident · Minor injuriesFinal reportWilbur D. Batman Challenger II · Lebanon, INFailure to maintain stall airspeed while executing a forced landing. A factor related to the accident is failure of the engine starter clutch.NTSB NYC91LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · Lancaster, NYThe failure of an engine exhaust valve, which resulted in a loss of engine power and a forced landing on unsuitable terrain.NTSB CHI91DCQ08Accident · No injuriesFinal reportSebly Amateur Built ACRO-SPORT II · Columbus, KSA loss of engine power for undetermined reasons. A factor associated with the accident is soft terrain in the forced landing area.NTSB MIA91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Culebra, PROil exhaustion for undetermined reasons.NTSB LAX91LA276Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Dana Point, CAThe seizure of the no. 1 cylinder's exhaust valve in its guide and the related fracturing of the rocker arm; and the pilot's operation of the aircraft with known deficiencies.NTSB DEN91LA089Accident · No injuriesLimited investigationFinal reportCessna A188B · Delta, COA total power loss due to a ruptured fuel line, and the installation of an incorrect fuel line.NTSB FTW91LA105Accident · No injuriesLimited investigationFinal reportSikorsky 58H · Corsicana, TXFailure of the magneto. Factors were the helicopter's position over water, the tailwind, and the inadequate main rotor RPM prior to touchdown.NTSB CHI91DTG02Accident · No injuriesFinal reportSikorsky H-19-UH19D · Mcclusky, NDFailure of the engine blower/supercharger assembly. A factor related to the accident was: no suitable terrain in which to make an immediate emergency landing.NTSB ATL91LA113Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Camilla, GARestricted exhaust valve movement, low cylinder compression, and fouling of the engine spark plugs, which resulted in the loss of engine power. Factors were the improper servicing of the aircraft, and the use of an improper fuel grade.NTSB ATL91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Conway, SCFailure of the number two exhaust valve, which resulted in loss of engine power.NTSB ATL91LA111Accident · 1 fatalLimited investigationFinal reportRider-Charles Aerosport Scamp · Raeford, NCThe pilot's improper adjustment of the engine carburetor, and his operation of the aircraft with a known powerplant deficiency. Factors in this accident were: the lack of spring tension for the fuel mixture, and the fouled condition of the engine spark plugs.NTSB BFO91LA054Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Union Hall, VAThe loss of engine power brought on by a failure of the number three clyinder exhaust valve. Contributing to the accident was a hidden object on the emergency landing field.NTSB ANC91LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Pilot Point, AKFuel exhaustion, due to the Pilot's inadequate preflight. Contributing to the accident was the soft and rough terrain.NTSB MIA91LA161Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, FLTotal loss of engine power due to fatigue failure of the oil cooler resulting in oil exhaustion. Contributing to the accident was lack of suitable terrain.NTSB CHI91DER04Accident · No injuriesFinal reportBellanca Eagle DW-1 · Hector, MNThe loss of engine power due to the total failure of a connecting rod. Related factors are the low maneuvering altitude and the unsuitable (muddy) terrain encountered during the forced landing.NTSB LAX91FA232Accident · 2 fatalField investigationFinal reportPiper PA-23 · Maricopa, AZThe pilot's poor judgement in the operation of the airplane with known deficiencies and the inadvertent stall during a forced landing. The pilot/owners lack of maintenance on the airplane and the pilot's impairment by alcohol were factors in the accident.NTSB CHI91LA173Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA1A · Evansville, INThe failure by maintenance personnel to identify the proper replacement cylinder.NTSB SEA91LA136Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wilson Creek, WAThe loss of engine power in flight due to improper overhaul of the carburetor float assembly fulcrum screw, shutting off fuel flow to the engine.NTSB SEA91LA117Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Klamath Falls, ORThe loss of engine power due to failure of the number 5 cylinder rod bearing which resulted from lack of lubrication of the main bearing.NTSB SEA91LA116Accident · Serious injuriesLimited investigationFinal reportGreg Smith KR-2 · Twisp, WAThe loss of engine power in flight due to shorted magneto wires, resulting from inadequate maintenance inspection by the pilot.NTSB MIA91LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Flamingo, FLPartial loss of engine power due to failure of the no. 3 cylinder exhaust valve for undetermined reasons. Contributing to the accident was lack of suitable terrain during the forced landing.NTSB MIA91LA149Accident · 1 fatalLimited investigationFinal reportCessna 172M · Missing (Atlantic Ocean)The lose of engine power for undetermined reasons which resulted in a forced landing and ditching in the atlantic ocean.NTSB ANC91LA059Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Smith Cove, AKA complete lose of engine power due to a total disintegration of the turbine wheel.NTSB FTW91DPG09Accident · No injuriesFinal reportGrumman G-164A · Goodwin, ARPower loss due to failure of the number five cylinder assembly. A factor was the soft terrain.NTSB CHI91FA160Accident · 1 fatalField investigationFinal reportCessna 210 · Belleville, MIFailure of the engine driven fuel pump, the failure of the pilot to activate the electric auxiliary fuel pump, poor inflight decision, and poor execution of emergency procedures. A factor relating to the accident is the pilot's lack of experience in this…NTSB SEA91LA109Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Malott, WAAn undetermined failure of the fuel pump casing resulting in an in flight fire and loss of engine power.NTSB ATL91LA097Accident · No injuriesLimited investigationFinal reportBeech 23 · Dothan, ALThe failure of the cylinder head because of previous overheated operations. Factors in the accident were the pilot's inaccurate approach which resulted in the loss of directional control and subsequent swerve into the fence.NTSB FTW91LA082Accident · No injuriesLimited investigationFinal reportCessna 210L · Marked Tree, ARThe failure of the engine piston and connecting rod. A factor was the wet landing area.NTSB LAX91FA213Accident · 7 fatalField investigationFinal reportCessna 207A · Grand Canyon, AZDetonation (or pre-ignition) in the number 1 cylinder, which resulted in erosion (burning) of the number 1 piston and subsequent loss of engine power. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB SEA91LA103Accident · No injuriesLimited investigationFinal reportCessna 182N · Shelton, WAThe total loss of power due to mechanical failure when the pilot was over unsuitable terrain for a forced landing. Factors include a hard landing after an inadvertent stall prior to touchdown on a highway.NTSB NYC91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Lumberton, NJThe pilot's failure to maintain airspeed and the resultant inadvertent stall. A factor in the accident was the loose oil filter.NTSB FTW91LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Raymondsville, TXOil exhaustion for undetermined reason. A factor was the soft terrain.NTSB MIA91LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Clearwater, FLInadequate annual inspection of the airplane by maintenance personnel who failed to detect a deteriorated oil line. This resulted in oil exhaustion causing the total loss of engine power due to failure of one of the connecting rods. Also inadvertent…NTSB LAX91LA199Accident · No injuriesLimited investigationFinal reportCessna 182 · Phoenix, AZThat the pilot failed to properly preflight the airplane to assure the engine contained an adequate oil supply. Contributing to this accident was total failure of the connecting rod due to lack of lubrication.NTSB NYC91DGT02Accident · Minor injuriesFinal reportKolb Twinstar · Williamsport, PAAn engine seizure as the result of overheating.NTSB LAX91LA200Accident · No injuriesLimited investigationFinal reportCessna T-337-D · Fullerton, CAThe loss of power in the front engine due to the improper and incomplete installation of the engine in the aircraft by a mechanic.NTSB NYC91LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Jessup, PAA power loss due to oil starvation for unknown reasons, over unsuitable terrain.NTSB MIA91LA126Accident · 1 fatalLimited investigationFinal reportRudolph Zeller Lancair · Titusville, FLThe use of improper materials for construction of the alternate air door by the aircraft owner/builder resulting in failure and separation of the door which resulted in blockage of air flow to the carburetor and loss of all engine power.NTSB SEA91LA092Accident · Minor injuriesLimited investigationFinal reportSmelser KR-2 · Spokane, WAA failure of the fuel drain valve which resulted in fuel exhaustion and a loss of engine power.