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 NYC89LA179Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Philadelphia, PALoss of engine power for an unknown reason. A factor related to the accident was: water in the emergency landing area.NTSB LAX89LA255Accident · No injuriesLimited investigationFinal reportBeech A35 · Hemet, CALoss of engine power for undetermined reasons.NTSB NYC89LA181Accident · No injuriesLimited investigationFinal reportCessna 185D · Wolfeboro, NHLoss of engine power for an unknown reason. Factors related to the accident were: the obstructions (trees & boats) in the emergency landing area.NTSB FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.NTSB NYC89LA175Accident · No injuriesLimited investigationFinal reportCessna 170B · Bricktown, NJUndetermined. The terrain was a related factor.NTSB LAX89LA244Accident · No injuriesLimited investigationFinal reportBeech BE58 · Sedona, AZThe pilot improperly leaning the fuel mixture of the left engine and the delay in aborting the takeoff. A contributing factor was the high density altitude conditions.NTSB DEN89FA178Accident · Serious injuriesField investigationFinal reportBeech E35 · Kalispell, MTContaminated fuel system that starved the engine of fuel.NTSB LAX89LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Van Nuys, CAA loss of engine power for undetermined reasons.NTSB FTW89DRD11Accident · No injuriesFinal reportSchweizer G-164A · Lake Arthur, LALoss of engine power for undetermined reasons. The high weeds (vegetation) & levee (dirt bank) were considered to be related factors.NTSB NYC89LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Walpole, MEA loss of engine power for undetermined reasons. Contributing to the accident was the powerline which the airplane contacted.NTSB MIA89FA192Accident · No injuriesField investigationFinal reportCessna 152 · Miami Lakes, FLThe failure of the pilot to visually inspect the airplane fuel tanks during the preflight inspection to assure adequate fuel to conduct the flight was available.NTSB MKC89LA158Accident · Minor injuriesLimited investigationFinal reportBristow KR-2 · Perry, IAFuel starvation caused by fuel contamination.NTSB DEN89LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Glenwood Spgs, COInadequate compensation for wind conditions by the dual student, resulting in a loss of control and a forced landing. The pilot-in-command, CFI, failed to adequately supervise the operation.NTSB LAX89LA231Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Sacramento, CAThe partial blockage of the engine induction system which resulted from improper maintenance.NTSB NYC89LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gasport, NYFuel contamination (water) and an inadequate preflight by the pilot, which resulted in the loss of engine power.NTSB MIA89LA182Accident · No injuriesLimited investigationFinal reportCessna T188C · Hollandale, MSThe failure of the turbocharger due to an improperly installed retaining nut. The soft/wet terrain was a contributing factor.NTSB CHI89LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tecumseh, MILoss of engine power for an undetermined reason. The embankment (dirt bank) was a contributing factor.NTSB FTW89LA124Accident · No injuriesLimited investigationFinal reportAero Commander Lark 100-180 · Gonzales, TXFailure of the aircraft engine, for undetermined reasons, during a low altitude maneuver.NTSB BFO89LA054Accident · No injuriesLimited investigationFinal reportHughes 269C · Baltimore, MDThe pilot landed on unsuitable soft terrain which caused the landing skid to sink into the ground. This resulted in a landing skid overload failure and nose over of the helicopter. Contributing to the accident was the soft terrain.NTSB BFO89LA051Accident · No injuriesLimited investigationFinal reportCessna 140 · Bridgeport, WVThe loss of engine power because of fuel starvation. Fuel starvation occurred because of unporting of fuel from the tank outlet when the aircraft was in a slip attitude shortly before the power loss. A contributing factor is inadequate information in the…NTSB MKC89LA146Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Lonoke, ARPartial failure of the power-plant for undetermined reasons.NTSB FTW89LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-601B · Cleveland, TXA loss of engine power, due to fuel starvation because the plt misjudged his fuel supply and distribution of fuel per tanks, and as a result mismanaged the supply remaining.NTSB CHI89DEE04Accident · No injuriesFinal reportRenninger Mustang II · Kirkland, ILFuel starvation (possibly from vapor lock), which resulted in loss of engine power, and the pilot's misjudgement of ground clearance during a final turn to land.NTSB LAX89FA225Accident · 4 fatalField investigationFinal reportAerospatiale TB-21 · Newhall, CAFuel contamination, due to the pilot's lack of familiarity with the aircraft fuel system, and inadequate maintenance. A related factor was: inadequate transition training.NTSB LAX89LA218Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Trinity Center, CAAn interruption of fuel to the engine for undetermined reasons.NTSB MKC89FA135Accident · 1 fatalField investigationFinal reportCessna A185F · Ely, MNLoss of engine power for an undetermined reason. A factor related to the accident was: the presence of trees in the emergency landing area.NTSB FTW89DRD07Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Morse, LALoss of engine power for an undetermined reason. The soft terrain was a contributing factor.NTSB NYC89LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dillsburg, PAThe engine stoppage caused by the lack of engine lubricant.NTSB MIA89FA174Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · St. Augustine, FLThe pilot failed to maintain airspeed during the turn to return to the airport, resulting in the loss of control. Contributing to the accident was his continued takeoff with intermittent engine power.NTSB ANC89LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Naked Island, AKEngine failure for an unknown reason.NTSB NYC89LA144Accident · Minor injuriesLimited investigationFinal reportAlon Aircoupe A-2 · Cattaraugus, NYEngine power loss due to fuel starvation resulting from the installation of an improper fuel pump. A factor related to the accident was: trees in the emergency landing area.NTSB FTW89LA106Accident · No injuriesLimited investigationFinal reportBell 206L · Abbeville, LAPartial loss of engine power for an undetermined reason. Factors related to the accident were: person(s) in the intended emergency landing area and soft terrain where the helicopter touched down.NTSB NYC89LA141Accident · No injuriesLimited investigationFinal reportBell 206-L · Wading River, NYThe pilot's failure to control the rate of descent which resulted in a hard landing. Contributing to the accident was a power loss due to a compressor failure.NTSB DEN89LA126Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Fort Collins, COLoss of engine power for an undetermined reason. The dark night and terrain condition were considered to be contributing factors.NTSB NYC89LA136Accident · No injuriesLimited investigationFinal reportMaule M5 · Kutztown, PAAn off airport landing in unsuitable terrain due to a power loss for undetermined reasons.NTSB MKC89FA116Accident · 2 fatalField investigationFinal reportBeech D55 · Greenwood, INInadequate preflight and improper use of the fuel system, which resulted in fuel starvation, and improper use of emergency procedures. Factors related to the accident were: self induced pressure by the pilot to meet an arrival time, his failure to extend the…NTSB MIA89LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Arcola, MSThe circumferential on the number 2 cylinder which resulted in a loss of engine power.NTSB CHI89DET05Accident · 2 fatalFinal reportBillings/White Avid Flyer · Niles, MILoose carburetor(s) due to improper maintenance/installation, which resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and…NTSB FTW89DRG05Accident · No injuriesFinal reportGrumman-Schweizer G-164 · Edcouch, TXLoss of engine power for an undetermined reason. The corn crop was a contributing factor.NTSB FTW89FA091Accident · 2 fatalField investigationFinal reportAeronca 11AC · Paradise, TXLoss of engine power for an undetermined reason, and failure of the pilot to maintain sufficient airspeed during the forced landing, which resulted in an inadvertent stall.NTSB CHI89DEP03Accident · No injuriesFinal reportTesmer Glassair SH-2 · Watertown, WILack fuel flow to the engine (fuel starvation) due to an undetermined fuel system problem.NTSB MIA89LA140Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Daytona Beach, FLA loss of engine power for undetermined reasons.NTSB NYC89LA126Accident · Minor injuriesLimited investigationFinal reportBell 206A · Bedminster, NJOff airport landing in unsuitable terrain due to an undetermined power loss.NTSB LAX89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Truckee, CAThe improper installation of fuel lines by maintenance personnel who installed the engine.NTSB MKC89LA093Accident · No injuriesLimited investigationFinal reportHuff 1 · Liberty, MOPartial loss of engine power for an unknown reason. The soft terrain (plowed field) was a related factor.NTSB MKC89LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roseau, MNFuel starvation due to fuel ice.NTSB DEN89FA104Accident · 1 fatalField investigationFinal reportCessna T210F · Aspen, COThe engine falure due to undetermined reasons and the pilot's misjudgement of the wind conditions which resulted in the attempt to glide to the runway. The pilot also failed to maintain adequate airspeed during the glide which resulted in a stall.NTSB NYC89DGM01Accident · No injuriesFinal reportSharp FOX Model 1 · Loretto, PAThe loss of engine power for undetermined reasons.NTSB BFO89FA028Accident · 3 fatalField investigationFinal reportPiper PA-32-260B · Richmond, VAEngine lost power because of induction icing. Contributing factors are conditions conduvice to induction icing and unsuitable terrain.NTSB LAX89FA133Accident · 4 fatalField investigationFinal reportMooney M20F · San Andreas, CAInterruption of engine power for an undetermined reason, and failue of the pilot to maintain airspeed, which resulted in a stall/spin. A factor related to the accident was: lack of altitude to recover from the stall/spin.