NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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\" = 350) 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" = 350) 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 MIA91LA101Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Avon, MSLoss of engine power for undetermined reasons during a turn while on an aerial application flight. Contributing to the accident was failure of the left magneto due to failure of a phenolic gear which drives the rotating magnet.NTSB SEA91LA066Accident · No injuriesLimited investigationFinal reportHughes 369D · Roseburg, ORA loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for an emergency landing.NTSB NYC91LA083Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Rancocas, NJThe pilot-in-command failed to maintain airspeed on initial take off climb resulting in a stall and in flight collision with terrain. Contributing to the accident was a loss of engine power for undetermined reason and a gusty crosswind condition.NTSB LAX91LA115Accident · No injuriesLimited investigationFinal reportCessna 182P · Pacoima, CAFailure of the PIC to ensure that the fuel system was free of water prior to flight. Contributing to the accident was the inadequate compliance with airworthiness directives by maintenance personnel to preclude water from entering the fuel system.NTSB LAX91LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fullerton, CAThe pilot's improper preflight inspection. Contributing to this accident was water in the fuel tank.NTSB FTW91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Davant, LAThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA91LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, FLFailure of the pilot to plan the flight and failure to obtain proper assistance from ATC after becoming lost, which resulted in total loss of engine power due to fuel exhaustion.NTSB LAX91LA104Accident · No injuriesLimited investigationFinal reportCessna 340A · Truckee, CAThat the pilot failed to follow the correct emergency procedures when he began to experience engine problems and improperly used the fuel boost pumps contrary to the pilot's operating handbook. The initial cause of the engine surging could not be determined.NTSB DEN91LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Guymon, OKFuel starvation for undetermined reasons, and the pilot's delay in flaring the airplane. A factor was: the pilot's total lack of experience.NTSB NYC91LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Mount Gilead, OHThe pilot's improper use of carburetor heat resulting in an engine failure due to carburetor ice and a subsequent off airport landing in unsuitable terrain.NTSB MIA91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 150G · La Belle, FLTotal loss of engine power due to undetermined reasons.NTSB SEA91LA048Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Draper, UTAn undetermined loss of engine power.NTSB SEA91LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Salt Lake City, UTAn undetermined loss of engine power.NTSB NYC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper J-3-C · Hamilton, OHThe failure of the pilot-in-command to touchdown in a suitable area after he experienced a power loss. A factor related to the accident was the improperly maintained carburetor.NTSB NYC91LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHFuel system contamination by other personnel which resulted in an inflight engine failure and a subsequent forced landing in unsuitable terrain.NTSB MIA91FA076Accident · Serious injuriesField investigationFinal reportAerospatiale SA-341G · Miami, FLThe pilot in command's failure to initiate an autorotation in timely manner following loss of engine power for undetermined reasons resulting in loss of rotor RPM and an uncontrolled descent and impact with the terrain.NTSB LAX91FA086Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Dunsmuir, CAThe pilot's delayed go-around attempt and improper use of carburetor heat. Contributing to the accident was a degradation of engine power due to fuel contamination from sand and rust.NTSB MIA91LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Titusville, FLPartial loss of engine power after takeoff due to undetermined reasons resulting in the emergency descent and in-flight collision with the power line then the ground.NTSB CHI91DCQ03Accident · Serious injuriesFinal reportRans S-11 Pursuit · Hays, KSAn engine failure caused by a seized piston. A factor associated with the accident is the failure of the pilot to maintain a proper descent rate during his forced landing.NTSB ATL91FA041Accident · 2 fatalField investigationFinal reportBeech K35 · Lafayette, TNPartial loss of engine for an undetermined reason. The adverse weather conditions, darkness, and radio tower were related factors.NTSB ATL91FA039Accident · 1 fatalField investigationFinal reportBeech 35 · Arden, NCFor undetermined reasons, the engine lost power.NTSB MIA91LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLInadequate maintenance record keeping by the operation, and failure of the CFI to follow procedures and directives.NTSB DEN91LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Crowley, TXA power loss due to carburetor ice resulting from the flight instructors failure to use correct engine management procedures. A factor was the rough terrain in which the forced landing was performed.NTSB LAX91LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Arcadia, CAImproper installation of the recently overhauled powerplant by maintenance personnel and inadequate inspection by maintenance personnel which failed to detect that the engine fuel pressure gauge line was not properly secured to the fuel system manifold valve.NTSB DEN91LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Houston, TXThe flight instructor's delay in taking remedial action, his inadvertently allowing the airplane to stall, and exceeding the aircraft's climb performance. Factors were: the flight instructor's lack of experience in aircraft type, his lack of experience as a…NTSB ATL91LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Bolivar, TNThe interruption of fuel to the left engine due to contamination of the left fuel tank, resulting in engine stoppage.NTSB CHI91LA068Accident · No injuriesLimited investigationFinal reportCessna 182A · Chadron, NEAn engine power loss for undetermined reasons.NTSB CHI91LA055Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Jerseyville, ILLoss of engine power for undetermined reasons and the icy runway conditions.NTSB NYC91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Princeton, NJPilot factor in that the pilot failed to use carburetor heat resulting in engine power loss due to carburetor ice. Factors were unsuitable terrain and obstructions.NTSB CHI91FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Gardner, KSA loss of engine power for undetermined reasons. Darkness was a related factor.NTSB NYC91LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Columbus, OHThe pilot's improper recovery from a bounced landing. Factors in the accident were: a downwind landing, and loss of engine power for undetermined reasons.NTSB CHI91FA035Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Des Moines, IAThe pilot's improper emergency procedures by not feathering the left engine after it lost power and/or was shut down, and his failure to keep the aircraft at or above the minimum control airspeed (VMC), which resulted in a loss of aircraft control. A factor…NTSB BFO91LA018Accident · No injuriesLimited investigationFinal reportBell 47J2A · Matoaca, VAThe failure of four propeller retention and the pilot's misjudgement of the forced landing approach.NTSB NYC91LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-32-301R · Alton, NHThe total loss of engine power for undetermined reasons. Contributing to the severity of the accident was the unsuitable terrain in which the forced landing was made.NTSB CHI91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Lindstrom, MNLeft engine failure for an undetermined reason. A factor related to the accident was: unsuitable terrain.NTSB LAX91LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Pacoima, CAAn engine failure for undetermined reasons.NTSB DEN91DQA01Accident · 1 fatalFinal reportYoung 2/3 Scale · Alamogordo, NMPartial loss of engine power for an undetermined reason, improper planning/decision by the pilot, and the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB BFO91DID01Accident · 2 fatalFinal reportAeronca Champion 7BCM · Suffolk, VAA loss of engine power due to low cylinder compression. The low compression was a result of exhaust valve leakage and inadequate maintenance and inspection. In addition, the pilot failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB NYC91LA023Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Elyria, OHThe loss of engine power for an undetermined reason(s).NTSB BFO91LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Elkton, VAThe pilot's failure to use carburetor heat which resulted in a reduction in engine power. A factor was the rough terrain.NTSB BFO91FA008Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Elkton, MDLoss of engine power for an undetermined reason, and the pilot's failure to maintain adequate airspeed, which resulted in a stall and an inflight collision with the terrain.NTSB BFO91LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Ridgely, MDThe loss of engine power for undetermined reasons.NTSB BFO91LA006Accident · No injuriesLimited investigationFinal reportCessna 150L · Lexington, KYThe pilot's inadequate inflight decision causing fuel exhaustion.NTSB MIA91FA014Accident · 1 fatalField investigationFinal reportDaniel S. Taylor Sonerai II LS · Prattville, ALThe pilot's failure to maintain airspeed. Factors were undetermined loss of engine power and lack of experience in type.NTSB FTW91DRD01Accident · No injuriesFinal reportMonnett Soneria · Lake Charles, LAA total loss of power for unknown reasons. A factor was the proximity of the crowd and other airplanes in the race during the forced landing.NTSB LAX91DUM02Accident · Serious injuriesFinal reportAyres S2RT-T34 · El Centro, CACollision with a ground object after the pilot successfully made a night time emergency landing after experiencing an engine power interruption for undetermined reasons.NTSB LAX91LA008Accident · Serious injuriesLimited investigationFinal reportBell 47G4 · Merced, CALoss of engine power for an undetermined reason.NTSB LAX91DUM01Accident · 1 fatalFinal reportPiper PA28-140 · El Cajon, CAThe pilot's failure to maintain flying speed. Contributing to the accident was an engine power loss for undetermined reasons.NTSB NYC90DHM26Accident · No injuriesFinal reportPalen Sopwith Dolphin · Reinbeck, NYUndetermined engine failure during low altitude operations.NTSB ATL90LA185Accident · No injuriesLimited investigationFinal reportCessna 210 · White Plains, GAThe fuel starvation to the engine for undertermined reasons.