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 LAX91LA371Accident · No injuriesLimited investigationFinal reportCessna 152 · Avalon, CAA loss of engine power for undetermined reasons and subsequent ditching while flying over the ocean.NTSB FTW91FA158Accident · Serious injuriesField investigationFinal reportBeech K35 · Tulsa, OKTotal power loss due to failure of the crankshaft bearings and connecting rod cap bolts resulting from the maintenance facilities' failure to overhaul the engine. A factor was the lack of suitable terrain for the forced landing.NTSB SEA91FA220Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Arlington, WYThe loss of engine power for an undetermined reason. Factors contriubting to the accident were trees and the pilot's failure to maintain adequate clearance above the trees.NTSB LAX91LA367Accident · No injuriesLimited investigationFinal reportCessna R182 · Fredonia, AZFailure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.NTSB CHI91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeburg, ILImproper use of the mixture control by the pic/cfi. A factor related to the accident was inadequate friction on the mixture control lever.NTSB NYC91LA215Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Martinsville, OHA failure of one engine for undetermined reasons. Additionally, the heavy gross weight resulted in inadequate single engine performance, which lead to a forced landing.NTSB LAX91LA361Accident · No injuriesLimited investigationFinal reportCessna 172G · Hilo, HIFuel exhaustion due to the installation of a non standard propeller for which no performance charts were available.NTSB SEA91LA210Accident · 1 fatalLimited investigationFinal reportWeyerts Rans S-10 · Stanwood, WAAn undetermined loss of engine power and the pilot's allowing the airspeed to decelerate below the stall speed during the subsequent forced landing.NTSB NYC91LA213Accident · No injuriesLimited investigationFinal reportCessna 150C · Kemblesville, PAThe instructor pilots' inadequate supervision, the student pilots' overshoot of the simulated landing area, and the power loss for undetermined reasons.NTSB NYC91LA211Accident · No injuriesLimited investigationFinal reportCessna 150 · Sharon, OHThe improper use of carburetor heat by the pilot, which resulted in a loss of engine power and subsequent forced landing on rough terrain. A factor related to the accident was the lack of total flight experience of the student pilot.NTSB FTW91DPG19Accident · No injuriesFinal reportGrumman G-164A · Allport, ARA loss of power for undetermined reason. A factor was the terrain on which the pilot made the forced landing.NTSB MIA91LA197Accident · No injuriesLimited investigationFinal reportCessna A188B · Monticello, FLLoss of engine power due to undetermined reasons and the unsuitable terrain encountered during the forced landing.NTSB MIA91LA195Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Gainesville, FLA loss of engine power for undetermined reasons and a lack of suitable terrain for a forced landing.NTSB CHI91DCJ05Accident · No injuriesFinal reportMcdonnell Douglas 269A · Harvard, NEThe pilot's failure to maintain adequate rotor RPM during aerial application maneuvers. A related factor was the pilot's inattention.NTSB NYC91LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Westerly, RIEngine failure for an undetermined reason. A factor was the pilot misjudging the clearance over a fence during an attempted forced landing.NTSB MIA91LA193Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-698 · Atlantic Ocean (Atlantic Ocean)An inflight loss of power of both engines for undetermined reasons followed by a ditching in the Ocean.NTSB SEA91LA198Accident · Serious injuriesLimited investigationFinal reportChance Vought F4U-4 · Chiloquin, ORThe loss of power due to engine failure, for undetermined reasons.NTSB LAX91LA341Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Riverside, CAThe contamination of fuel in the right tank of the accident airplane with an unknown oil-like substance.NTSB NYC91LA195Accident · Minor injuriesLimited investigationFinal reportBeech C50 · Salem, OHEngine failure as a result of improper maintenance and failure of the propeller feathering system for an undetermined reason. Factors were aircraft poor climb performance as resulted of the unfeathered propeller and obstructions which prevented a return to…NTSB BFO91DLQ01Accident · Serious injuriesFinal reportGordorn Price Ultimate 10-300 · Franklin, KYDelay in switching fuel tanks which resulted in fuel exhaustion and loss of engine power.NTSB NYC91LA191Accident · No injuriesLimited investigationFinal reportBeech C-23 · Williamstown, MAEngine failure as a result of improper engine overhaul performed by other maintenance personnel. A factor was the lack of suitable terrain.NTSB MIA91LA192Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Caribbean SeaImproper placement of the boost pump selector by the pilot in command, and electrical system failure for undetermined reasons. This resulted in the total loss of engine power due to fuel starvation.NTSB LAX91LA331Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Visalia, CAA loss of engine power due to the failure of the master rod to the number one cylinder resulting from a lack of oil.NTSB LAX91LA330Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Minden, NVThe pilot's failure to properly adjust the mixture setting prior to landing to ensure the continued operation of the engine.NTSB ATL91FA142Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Manteo, NCThe loss of left engine power for undetermined reasons, and the failure of the pilot to maintain minimum controllable airspeed, which resulted in the stalling of the airplane.NTSB FTW91LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Nashville, ARFuel starvation induced loss of power due to a blocked finger fuel strainer in the fuel servo unit. A factor was the unsuitable terrain at the pilot's disposal.NTSB BFO91LA069Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ashland, KYLost of engine power for undetermined reasons.NTSB LAX91LA325Accident · No injuriesLimited investigationFinal reportCessna 172N · Napa, CAThe cfi's failure to initiate the go-around maneuver in a timely manner, and his failure to terminate the simulated emergency maneuver at a proper altitude. A contributing factor was the gusty surface wind.NTSB ANC91FA104Accident · Serious injuriesField investigationFinal reportCessna 152 · Anchorage, AKA loss of power due to undetermined causes. Factors include objects in the flight path encountered during the emergency descent.NTSB SEA91LA189Accident · No injuriesLimited investigationFinal reportBeech V35A · Weiser, IDThe pilot did not refuel the airplane resulting in fuel exhaustion.NTSB MIA91LA189Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hilliard, FLLoss of engine power due to undetermined reasons, failure of the pilot to maintain vso, and inadvertent stall mush. Contributing to the accident was lack of total experience in the type of operation.NTSB MIA91LA188Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cleveland, MSInadequate preflight resulting in water contamination causing loss of engine power.NTSB MIA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Meridian, MSLoss of power from the right engine due to undetermined reasons. The failure of the propeller to feather was a factor in the accident.NTSB ANC91LA101Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chataniak Vly, AKPartial loss of engine power for an undetermined reason.NTSB FTW91LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Wilburton, OKThe pilot's decision to abort the take off with insufficient distance remaining. Factors were the fluctuating engine and the trees in his path.NTSB MIA91LA184Accident · No injuriesLimited investigationFinal reportCessna 120 · Pocahontas, MSPartial loss of engine power due to undetermined reasons and in-flight collision with a power line during an emergency descent for a forced landing.NTSB FTW91LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Cresson, TXA loss of engine power for unknown reasons and the failure of the certified flight instructor/pilot-in-command to feather the propeller.NTSB LAX91LA294Accident · No injuriesLimited investigationFinal reportCessna 140 · Montague, CAThe failure of an exhaust valve in the engine.NTSB LAX91LA290Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Trinity Center, CAThe pilot's failure to ensure an adequate supply of fuel was available. Contributing to this accident was soft terrain.NTSB BFO91LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172 · South Boston, VAThe lost of engine power for undetermined reasons and the lack of suitable terrain to make a forced landing.NTSB BFO91DOA01Accident · Minor injuriesFinal reportBell UH-1B · Iaeger, WVThe loss of engine power for undetermined reasons, while operating over unsuitable terrain.NTSB ATL91FA120Accident · 1 fatalField investigationFinal reportHughes 269C · Blakely, GALoss of engine power for an undetermined reason, and failure of the instructor pilot (CFI) to follow procedures and maintain rotor RPM.NTSB ATL91LA119Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Muscle Shoals, ALThe loss of engine power for undetermined reasons.NTSB MIA91FA172Accident · Serious injuriesField investigationFinal reportCessna 411 · North Ft. Myers, FLThe pilot in commands failure to follow emergency procedures and his failure to maintain airspeed following loss of power in one engine resulting in an inadvertent stall and the inflight loss of control with subsequent inflight collision with an object and…NTSB CHI91DER09Accident · No injuriesFinal reportEagle Eagle DW-1 · Windom, MNThe pilot's improper aircraft handling. Related factors are the pilot's inattention and the airplane's deteriorated performance capability.NTSB MIA91LA169Accident · No injuriesLimited investigationFinal reportGrumman G164B · Immokalee, FLLoss of enine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encounteered during the forced landing.NTSB BFO91LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Beckley, WVThe pilot's failure to attain adequate flying speed.NTSB LAX91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rio Vista, CAFuel exhaustion due to the pilots improper fuel consumption calculations and inadequate preflight planning.NTSB LAX91LA269Accident · Serious injuriesLimited investigationFinal reportGreen-Fowler Pazmany PL-1 · Wrightwood, CAFatigue fracture of one of the two propeller blades caused by the propeller modification and the non-approved propeller-engine combination. A factor in this accident was the transmission wires as an obstacle in the glide path during the attempted forced…NTSB LAX91LA275Accident · No injuriesLimited investigationFinal reportCessna C-152 · Las Vegas, NVFuel exhaustion due to the failure of the pilot to ensure that an adequate fuel supply was on board the aircraft prior to departure.