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 BFO95LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Blooming Grove, PAThe malfunction of the carburetor heat control which resulted in loss of engine power. The carburetor icing weather condition was a factor.NTSB ATL95LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Johns Island, SCA loss of engine power due to a partially blocked fuel line to the gascolator.NTSB MIA95LA019Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Venice, FLThe loss of engine power for undetermined cause. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB ATL95FA012Accident · Serious injuriesField investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate management of the fuel supply which resulted in fuel exhaustion and a complete loss of engine power.NTSB MIA95LA014Accident · No injuriesLimited investigationFinal reportCessna 150L · Crystal River, FLA partial loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.NTSB FTW95LA029Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Tomball, TXA partial power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI95LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILthe pilot's failure to maintain airspeed during the landing which resulted in a stall. A factor related to the accident was the loss of engine power for undetermined reasons.NTSB CHI95LA023Accident · No injuriesLimited investigationFinal reportCessna 172F · Cross Plains, WIthe pilot's failure to use carburetor heat. Factors were carburetor icing conditions and rough/uneven terrain.NTSB ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.NTSB NYC95LA008Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Amityville, NYThe loss of engine power for undetermined reasons. Also causal was the inspector's improper inflight decision to simulate an emergency beyong the gliding distance to a suitable landing area.NTSB NYC95LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Farmington, MELoss of engine power for undetermined reasons.NTSB SEA95LA005Accident · Minor injuriesLimited investigationFinal reportLarsen Avid Heavy Hauler · Nampa, IDLoss of engine power for undetermined reasons and the lack of suitable terrain for the forced landing.NTSB CHI95LA006Accident · Serious injuriesLimited investigationFinal reportJohnson A-4 · Laporte, INthe pilot's inadvertant stall of the airplane while conducting a forced landing. A factor was the engine failure which occurred for an undetermined reason.NTSB ANC95LA001Accident · No injuriesLimited investigationFinal reportPiper J5C · Anchorage, AKThe loss of engine power for undetermined reasons and the lack of a suitable forced landing area.NTSB CHI95LA004Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cloverdale, INthe total loss of engine power due to a blocked orifice in the fuel pump. A related factor is the rough/uneven terrain encountered during the forced landing.NTSB CHI94DET02Accident · Minor injuriesFinal reportSimcox Sport Trainer · Laporte, INThe pilot's continued operation with a known power deficiency. The loss of engine power was a factor in the accident.NTSB ATL94LA177Accident · No injuriesLimited investigationFinal reportCessna 172D · Alabaster, ALThe pilot's failure to properly sump the fuel system during the preflight inspection that resulted in loss of power.NTSB FTW94LA306Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARThe loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB MIA94LA213Accident · 1 fatalLimited investigationFinal reportRans S-12 Airaile · Clearwater, FLThe loss of engine power for undetermined reasons.NTSB FTW94LA303Accident · Serious injuriesLimited investigationFinal reportHarris Dragonfly · Woodville, TXWas fuel starvation. Factors were the jammed float in the fuel sight gage and the lack of suitable terrain.NTSB FTW94FA300Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Tennesse Colony, TXThe pilot's failure to maintain airspeed and the resultant inadvertent stall/spin. A factor was the loss of engine power for undetermined reasons.NTSB FTW94FA299Accident · 1 fatalField investigationFinal reportBellanca 7ACA · Lakeside, TXThe pilot's failure to maintain minimum required airspeed for flight. A factor was the loss of engine power for undetermined reasons.NTSB CHI94LA331Accident · No injuriesLimited investigationFinal reportCessna 150 · Winnetka, ILThe loss of engine power due to an undetermined reason. The lack of suitable terrain for the forced landing was a factor.NTSB FTW94FA293Accident · Minor injuriesField investigationFinal reportEurocopter AS-350-B2 · Cascade, COA power loss due to contaminated fuel from an unknown source that clogged the fuel filter and internally damaged the fuel control unit. A factor was unsuitable terrain for a forced landing.NTSB LAX94LA351Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Twentynine Palm, CAthe cause of the loss of engine power could not be determined. The dirt berm was a factor in this accident.NTSB MIA94LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Englewood, FLThe failure of the number four connecting rod and rod bolts due to oil starvation (extreme heat) for undetermined reasons, resulting in a total loss of engine power, forced landing, and subsequent in-flight collision with trees and terrain.NTSB LAX94LA348Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Orland, CAThe pilot's failure to follow checklist procedures to assure that the fuel selector was in the both fuel tanks position. Fuel starvation and the dark night were factors in this accident.NTSB MIA94LA204Accident · No injuriesLimited investigationFinal reportCessna 188B · Indian River, FLThe total loss of engine power for undetermined reasons over terrain unsuitable for a forced landing.NTSB BFO94LA158Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Ravenswood, WVThe poorly planned approach which resulted in unporting of fuel from the left fuel tank and loss of engine power due to fuel starvation.NTSB CHI94LA304Accident · No injuriesLimited investigationFinal reportCessna 210L · Orr, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the false indication from the fuel quantity gauges, and terrain condition in the emergency landing area.NTSB BFO94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Montpelier, VTThe loss of engine power for reasons undetermined.NTSB CHI94LA303Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gardner, KSundetermined. A factor associated with the accident is a fence at the off-airport landing site.NTSB BFO94LA152Accident · Minor injuriesLimited investigationFinal reportA. Le Francois Rans S-7 · Palmer, MAThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed.NTSB BFO94LA146Accident · Serious injuriesLimited investigationFinal reportAdvanced Acft Waco 10 GXE · Rochester, NHthe partial loss of engine power for undetermined reasons. Related factors were unsuitable terrain (trees) and the inadvertent stall.NTSB MIA94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Osteen, FLEngine power loss due to blockage of the carburetor fuel discharge nozzle pickup by an insect that inadvertently entered the carburetor during overhaul resulting in fuel starvation.NTSB BFO94LA141Accident · 1 fatalLimited investigationFinal reportLafrance V-Witt W2 · Wilmington, OHLoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed while attempting a maneuver for an emergency landing, which resulted in a stall and collision with terrain. A factor related to the accident was: the lack…NTSB LAX94LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Riverside, CAa total loss of engine power for undetermined reasons.NTSB NYC94FA160Accident · 4 fatalField investigationFinal reportCessna 320C · Waynesboro, PAThe pilot's failure to maintain adequate airspeed which resulted in a stall/spin and his lack of qualification to conduct flight in type aircraft. A factor is the loss of engine power for undetermined reasons.NTSB LAX94LA324Accident · No injuriesLimited investigationFinal reportCessna 150M · Mettler, CAa loss of engine power due to inadequate and improper maintenance procedures and practices. A factor in the accident was the dark night lighting conditions which inhibited the pilot's ability to select a suitable forced landing area.NTSB BFO94LA137Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Stewartsville, NJThe loss of engine power for undetermined reason.NTSB FTW94LA269Accident · Minor injuriesLimited investigationFinal reportRockwell 112A · Eagle Lake, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94LA155Accident · No injuriesLimited investigationFinal reportCessna 210A · Varnville, SCWater contamination in the fuel that resulted from inadequate maintenance inspection of the airplane. A factor was the rough terrain at the landing site.NTSB NYC94FA148Accident · 1 fatalField investigationFinal reportBeech A100 · Williamstown, MAthe pilot's failure to maintain minimum control speed after an undetermined loss of engine power, which resulted in an inadvertent stall at too low of an altitude to allow recovery.NTSB FTW94LA271Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Clint, TXThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Richmond, MOa loss of engine power due to fuel starvation, reason undetermined.NTSB CHI94LA264Accident · No injuriesLimited investigationFinal reportBeech D17R · Sandwich, ILthe failure of the pilot to lower the landing gear. Factors related to the accident were the loss of engine rpm, for undetermined reasons, and the diverted attention of the pilot.NTSB CHI94FA263Accident · 2 fatalField investigationFinal reportPiper PA-25 · Decatur, NELoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB NYC94LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, CTThe loss of engine power for undetermined reasons.NTSB LAX94LA301Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Livermore, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering and his subsequent entry into an inadvertent stall/mush. A factor was fuel starvation due to the pilot's failure to select the proper fuel tank.