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 ATL94GA148Accident · Minor injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for undetermined reasons.NTSB CHI94LA255Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marshalltown, IAA partial loss of engine power for undetermined reasons.NTSB CHI94LA249Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Waterford, MIundetermined.NTSB CHI94FA248Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Racine, WILoss of power for undetermined reason(s). The dark night was a related factor.NTSB SEA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Nampa, IDA cracked cylinder.NTSB CHI94LA245Accident · No injuriesLimited investigationFinal reportMooney M20C · Macon, MOthe student pilot's decision to land on a closed runway under construction. A factor associated with the accident is the partial loss of engine power for an undetermined reason.NTSB ANC94LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe partial loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB FTW94LA246Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pollard, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.NTSB CHI94LA240Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Wymore, NEfailure of the fuel injector pump due to improper assembly.NTSB SEA94LA187Accident · No injuriesLimited investigationFinal reportBeech P-35 · Laramie, WYLoss of engine power for undetermined reasons. Factors include fence posts struck during rollout at the emergency landing site.NTSB CHI94DCA02Accident · Minor injuriesFinal reportSchweizer G-164B · Harviell, MOthe separation of the oil supply line to the propeller governor, which resulted in the propeller inadvertently going into feather. Factors were the pilots intentional ground loop of the airplane to avoid impacting obstructions at the end of the runway.NTSB LAX94LA286Accident · 2 fatalLimited investigationFinal reportCessna 150D · Carrville, CAa loss of engine power for undetermined reasons. The mountainous terrain and lack of a suitable forced landing area within gliding distance was a factor in the accident.NTSB FTW94LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Tulsa, OKThe loss of engine power for undetermined reasons. The lack of terrain suitable for a forced landing was a factor.NTSB NYC94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Lancaster, OHThe loss of engine power for undetermined reasons.NTSB LAX94LA284Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Tucson, AZa loss of engine power for undetermined reasons.NTSB ATL94LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAInadequate maintenance by the operator, worn piston rings, and failure to overhaul the engine when due.NTSB MIA94FA175Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Gulf Of MexicoLoss of engine power due to an undetermined reason. A factor related to the accident was: inadequate passenger briefing by the pilot.NTSB LAX94LA277Accident · No injuriesLimited investigationFinal reportCessna 172 · Hanford, CAThe failure of the pilot to stop the aircraft in a timely manner after landing back on the runway following a loss of engine power for undetermined reasons.NTSB FTW94LA222Accident · No injuriesLimited investigationFinal reportCessna 206E · Cleveland, TXLoss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB MIA94LA172Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Rolling Fork, MSThe loss of engine power for undetermined causes. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB LAX94LA273Accident · Minor injuriesLimited investigationFinal reportAdams Thorpe T-18 · Stockton, CAA vapor lock induced engine failure due to inadequate thermal shielding of the fuel pump and lines. Soft terrain in the landing area was a factor.NTSB NYC94LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Tinton Falls, NJThe loss of engine power for undetermined reasons.NTSB NYC94LA103Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Monmouth Beach, NJA power loss due to fuel starvation, for undetermined reasons. A factor was the night conditions.NTSB FTW94LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Marked Tree, ARThe power loss for undetermined reasons. Factors were the pilot's inadvertent entry into a stall and the lack of suitable terrain onto which to execute the landing.NTSB ANC94FA074Accident · 3 fatalField investigationFinal reportPiper PA-22 · Delta Junction, AKThe loss of engine power for undetermined reasons. A factor was the pilot did not maintain airspeed resulting in a stall/spin.NTSB BFO94LA124Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sandy Hook, NJThe loss of engine power for reasons undetermined and the inability of the pilot to feather the propeller.NTSB LAX94LA267Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Wickenburg, AZLoss of engine power for an unknown reason, and failure of the pilot to maintain airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB MIA94LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Walls, MSThe partial loss of engine power for undetermined reasons. The sandy terrain was a factor.NTSB ATL94LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Finley, TNThe loss of engine power for undetermined reasons. Factors were wet and soft terrain.NTSB SEA94LA157Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORFuel exhaustion due to a false indication on the fuel quantity sensor.NTSB LAX94LA263Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cloverdale, CALoss of engine power for an unknown reason.NTSB FTW94LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARTotal power loss for undetermined reasons. A factor was unsuitable terrain for a forced landing.NTSB BFO94LA111Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF5 · Put-In-Bay, OHThe total loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB ATL94LA123Accident · 1 fatalLimited investigationFinal reportMarvin E. Eubanks VP-1 · New Bern, NCThe loss of engine power for unknown reasons, and the failure of the pilot to maintain control of the aircraft during the emergency landing.NTSB BFO94LA107Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Forest Hill, MDThe loss of engine power during for undetermined reasons.NTSB CHI94LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Tomahawk, WIThe loss of engine power due to an undetermined reason. Factors in the accident were the lack of suitable terrain in preventing the pilot from making a safe forced landing.NTSB CHI94LA201Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Napoleon, MIa loss of engine power for unknown reasons. A factor related tot he accident were the trees encountered.NTSB FTW94LA199Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMA power loss due to engine driven fuel pump failure. A factor was the lack of suitable terrain for a forced landing.NTSB LAX94FA257Accident · 2 fatalField investigationFinal reportCessna 421C · Carlsbad, CAA loss of engine power for undetermined reasons. The pilot's failure to raise the flaps and maintain altitude were factors in the accident.NTSB LAX94LA252Accident · Minor injuriesLimited investigationFinal reportTwibell Richard Dale Tiny TWO · Hesperia, CAA loss of engine power for undetermined reasons.NTSB LAX94LA246Accident · 1 fatalLimited investigationFinal reportMcCulloch J-2 · Willits, CAa loss of engine power for undetermined reasons.NTSB FTW94LA192Accident · Minor injuriesLimited investigationFinal reportCallair A-5T · Fabens, TXLoss of engine power for undetermined reason(s).NTSB BFO94LA095Accident · Minor injuriesLimited investigationFinal reportCessna 172 · York, PAthe loss of total engine power for undetermined reasons.NTSB ATL94LA117Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Bainbridge, GAThe loss of engine power for undetermined reasons.NTSB FTW94LA187Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Carlisle, ARThe loss of engine power for undetermined reason. A factor ws the lack of suitable terrain at the pilot's disposal for the forced landing.NTSB BFO94FA112Accident · 2 fatalField investigationFinal reportBeech 24R · Nantucket, MAthe total loss of engine power over unsuitable terrain, for undetermined reasons. The pilot's failure to ensure that proper survival equipment was onboard the airplane was a related factor.NTSB ATL94LA113Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Laurens, SCThe loss of engine power on one engine followed by failure of the propeller to feather or be feathered.NTSB NYC94LA097Accident · Serious injuriesLimited investigationFinal reportBell 47G3 Soloy · Friendsville, MDThe partial failure of the turbine engine for undetermined reasons, during an agriculture maneuver at low altitude, over terrain unsuitable for an autorotation.NTSB LAX94LA229Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Calexico, CA1) the pilot's failure to correctly position the fuel selectors prior to takeoff, 2) the resultant fuel starvation failure of the left engine in the takeoff initial climb, and 3) the failure of the pilot to maintain directional control of the aircraft.NTSB BFO94FA082Accident · No injuriesField investigationFinal reportCessna A150L · Leonardtown, MDImproper use of carburetor heat by the pilot, which resulted in loss of engine power due to carburetor ice. A contributing factor was the presence of carburetor icing conditions.