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 ATL90FA179Accident · 3 fatalField investigationFinal reportCessna 421B · Jefferson, GAFailure of the pilot to perform the correct emergency procedures, when confronted with a loss of engine power, and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control.NTSB BFO90LA075Accident · Serious injuriesLimited investigationFinal reportHughes 369E · Prestonburg, KYThe lost of engine power for undetermined reasons.NTSB FTW90DPG16Accident · Serious injuriesFinal reportEipper Quick Silver MX II · Tontitown, ARA partial power loss for undetermined reasons and the pilot's poor flare during the forced landing.NTSB ATL90FA163Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · Nashville, TNThe company/operator management's decision to operate the aircraft with a known deficiency without further maintenance, the pilot's improper planning/decision and the pilot's failure to abort the takeoff (while there was sufficient runway remaining). Factors…NTSB NYC90LA212Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Elliotville, MEA power loss for unknown reasons over unsuitable terrain.NTSB ANC90FA161Accident · 3 fatalField investigationFinal reportPiper PA-31-325 · Kaltag, AKFailure of the pilot to maintain adequate altitude after becoming distracted with an engine problem. Factors related to the accident were: loss of power in the #2 engine for an unknown reason and the low overcast condition.NTSB NYC90LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Reading, PAA loss of engine power for unknown reasons and an off airport landing on unsuitable terrain.NTSB FTW90FA167Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bulverde, TXMismanagement of the fuel supply resulting in fuel starvation. Factors were the pilot's lack of experience in the airplane, the dark night condition, and the trees.NTSB FTW90DPG12Accident · No injuriesFinal reportAir Tractor AT-401 · Jacksonville, ARA loss of engine power due to unknown causes. A factor was the unsuitable terrain.NTSB NYC90DEG02Accident · 1 fatalFinal reportTrice Pitts Special S-1S · Hamilton, OHThe loss of engine power for undetermined reasons.NTSB LAX90DVA09Accident · No injuriesFinal reportRockwell S2R · Mendota, CALoss of engine power for an unknown reason. Darkness was a related factor.NTSB SEA90LA162Accident · 1 fatalLimited investigationFinal reportVaden SA102 Cavalier · Tumwater, WAThe pilot's failure to maintain airspeed during takeoff following an engine loss of power. The reason for the loss of power was not determined.NTSB MIA90LA169Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenville, MSThe partial loss of engine power for an unknown reason.NTSB ANC90LA138Accident · No injuriesLimited investigationFinal reportHelio HE-3/H-295 · Arctic Village, AKThe pilot in commands improper flare during a forced landing resulting in a hard landing.NTSB FTW90LA154Accident · No injuriesLimited investigationFinal reportCessna 421B · El Paso, TXThe pilot's improper single engine emergency procedures.NTSB SEA90FA158Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · Cougar, WALoss of power due to contamination in the engine speed governor.NTSB CHI90LA218Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Brighton, MIA loss of engine power due to inadequate maintenance and inspection.NTSB FTW90DRD15Accident · No injuriesFinal reportCessna 188 · Archibald, LAThe power loss for undetermined reasons. A factor was the rough uneven terrain in which the forced landing was performed.NTSB FTW90LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roades, LAUnknown mechanical malfunction resulting in engine oil starvation. A contributing factor was rough terrain in which the forced landing was made.NTSB FTW90LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Alvord, TXThe failure of the engine to develop full rated power for unknown reasons.NTSB CHI90LA209Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WILoss of engine power for an undetermined reason.NTSB MIA90LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Delray Beach, FLThe loss of directional control during the initial climb following the reported loss of power from the left engine for undetermined reasons.NTSB ANC90LA124Accident · No injuriesLimited investigationFinal reportCessna 206G · Holy Cross, AKLoss of engine power for undetermined reasons.NTSB MIA90LA157Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Plant City, FLEngine failure for undetermined reasons resulting in the forced landing.NTSB LAX90DVG12Accident · Serious injuriesFinal reportE.J. Novotny Steen Skybolt · Fall River Mill, CALoss of power for undetermined reasons.NTSB ANC90LA121Accident · No injuriesLimited investigationFinal reportCessna 150M · Goose Bay, AKA loss of engine power for undetermined reasons. The wet tundra was a contributing factor.NTSB NYC90LA165Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Highland, NYOff airport landing in unsuitable terrain due to a power loss for unknown reasons.NTSB NYC90LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Radnow Township, PAWire strike during an off airport forced landing in unsuitable terrain. Contributing factors were a power loss, caused by an engine oil leak.NTSB NYC90LA161Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Doylestown, PAA loss of engine power due to an inoperable carburetor heat control. Lack of suitable terrain for the forced landing was a factor.NTSB CHI90LA186Accident · Minor injuriesLimited investigationFinal reportCessna 152 II · Grand Marais, MNUndetermined partial loss of engine power during the initial climbout. A factor was the lack of suitable terrain for a forced landing.NTSB DEN90LA153Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Miles City, MTThe failure of the pilot to use carburetor heat during descent for landing, resulting in a loss of power.NTSB SEA90LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Walla Walla, WAA loss of engine power for undetermined reasons.NTSB CHI90LA167Accident · No injuriesLimited investigationFinal reportCessna 150G · Manchester, MILoss of engine power due to a stuck exhaust valve.NTSB DEN90LA146Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edgeley, NDA momentary power interruption during initial climb for unknown reasons.NTSB CHI90LA163Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Savoy, ILThe loss of engine power for undetermined reasons and the inadvertent stall during the forced landing.NTSB MKC90LA141Accident · No injuriesLimited investigationFinal reportBeech B-60 · Hutchinson, KSEngine failure for undetermined reasons. A factor in the accident was that there was no suitable terrain in which to make a forced landing.NTSB FTW90LA123Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mc Allen, TXLoss of engine power for undetermined reasons. The concrete canal that he impacted was a factor.NTSB SEA90LA108Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dayton, WALoss of engine power for an undetermined reason.NTSB ANC90LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Big Lake, AKLoss of engine power for undetermined reasons resulting in an off airport landing in a ditch.NTSB FTW90LA118Accident · No injuriesLimited investigationFinal reportBell TH13T · Paradise, LAThe failure of the pilot to properly execute the autorotation landing.NTSB FTW90FA119Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bossier City, LALoss of engine power for an unknown reason.NTSB LAX90LA220Accident · No injuriesLimited investigationFinal reportAerostar S-66A · Davis, CAThe failure of the pilot to properly manage the fuel valves to provide adequate fuel pressure to the burner.NTSB LAX90DVA06Accident · No injuriesFinal reportRay Edmistonn Z-200 · Selma, CAA loss of engine power for undetermined reasons.NTSB FTW90LA116Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Pasendena, TXEngine failure due to an undetermined reason.NTSB SEA90LA097Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Cottonwood, IDThe loss of engine power due to undetermined reasons. The berm, which the airplane struck during landing, was a factor in the accident.NTSB DEN90LA121Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Las Cruces, NMA loss of power for an unknown cause. A factor in the accident was the unsuitable terrain.NTSB SEA90LA088Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 · Chatham, AKThe total loss of engine power for undetermined reasons.NTSB LAX90LA204Accident · No injuriesLimited investigationFinal reportRobinson R22A · Torrance, CAThis accident was a dynamic roll over due to the right skid encountering soft soil during the forced landing.NTSB NYC90DNA03Accident · No injuriesFinal reportBataller Kitfox · Marlboro, MAThe undetermined loss of engine power.NTSB MIA90LA133Accident · No injuriesLimited investigationFinal reportCessna 210A · Palm Harbor, FLThe improper leaning of the fuel/air mixture resulting in the loss of engine power due to excessive internal engine temperature.