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 MIA94GA072Accident · Minor injuriesFinal reportRobinson R-22B · Pompano Beach, FLFailure of the pilot-in-command to use carburetor heat during a poweroff autorotation, resulting in the engine not responding to throttle input during recovery due to carburetor ice buildup.NTSB FTW94FA082Accident · 2 fatalField investigationFinal reportCessna 421C · San Antonio, TXImproper servicing of the airplane with jet fuel, which resulted in preignition and/or detonation and subsequent failure of pistons in both engines. A factor related to the accident was: the lack of a restrictive mating nozzle on the refueling truck.NTSB SEA94LA059Accident · No injuriesLimited investigationFinal reportCessna T210N · Havre, MTAn undetermined loss of engine power.NTSB CHI94LA079Accident · Serious injuriesLimited investigationFinal reportRoberts RV-6A · Richland, MOLoss of engine power (during flight) for an undetermined reason, after the pilot experienced loss of engine power before takeoff for an unknown reason.NTSB BFO94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Taunton, MAA total loss of engine power for undetermined reasons. A factor in this accident was the lack of suitable terrain to enable the successful completion of the forced landing.NTSB MIA94LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tamarac, FLThe loss of engine power for undetermined causes.NTSB FTW94LA080Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Paris, ARFailure by the pilot in command to have annual maintenance inspections performed on the aircraft.NTSB CHI94LA075Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Chesterfield, MOThe pilot-in-command's poorly planned approach. A factor in the accident was the loss of engine power for an undetermined reason.NTSB BFO94LA027Accident · Serious injuriesLimited investigationFinal reportCessna 425 · London, KYLoss of engine power due to fuel contamination.NTSB MIA94LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Boynton Beach, FLPartial loss of engine power for undetermined reasons.NTSB ANC94FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-160 · Palmer, AKLoss of engine power for undetermined reasons. A factor in the severity of the accident was the failure of the pilot-in-command to maintain control of the airplane when the engine ceased producing power.NTSB BFO94LA026Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Middletown, OHA frozen oil line resulting in the starvation of oil to the engine and subsequent loss of engine power. A related factor was the unsuitable terrain for a forced landing.NTSB LAX94LA094Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Warner Springs, CAa loss of engine power for undetermined reasons.NTSB FTW94LA069Accident · Serious injuriesLimited investigationFinal reportNelson Ford V-6 Stol 262 · San Benito, TXA partial loss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Jasper, ALLoss of engine power for undetermined reasons.NTSB LAX94FA089Accident · 1 fatalField investigationFinal reportGrumman AA-1C · Santa Paula, CAA failure of the pilot to maintain adequate airspeed, and subsequent inadvertent stall during an undetermined loss of engine power following takeoff.NTSB NYC94LA043Accident · No injuriesLimited investigationFinal reportBeech A-36-TC · Hillsboro, NHLoss of engine power for undetermined reasons.NTSB FTW94LA053Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Giddings, TXThe pilot's failure to maintain main rotor RPM. The weather conditions and delayed application of carburetor were factors in the accident.NTSB MIA94IA040Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124 · Melbourne, FLWas inadequate quality control by the engine manufacturer which resulted in failure of the second stage low pressure turbine disk due to a machining anomaly and reduced fatigue strength due to sub standard heat treat processing.NTSB FTW94LA051Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Dalhart, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB NYC94LA039Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Wilkes-Barre, PAwas the loss of engine oil for undetermined reasons and the subsequent engine failure, resulting in a forced landing and collision with trees.NTSB NYC94FA038Accident · 2 fatalField investigationFinal reportBeech B36TC · Lost Creek, KYThe loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the lack of suitable terrain for a forced landing.NTSB FTW94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94FA030Accident · 3 fatalField investigationFinal reportBeech M35 · Chapel Hill, NCThe improper engine overhaul by maintenance personnel. A factor in the accident was the failure of the engine crankshaft.NTSB MIA94LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Punta Gorda, FLThe pilot-in-command's improper use of carburetor heat during a VFR approach for landing. This resulted in a loss of engine power due to fuel system carburetor icing.NTSB FTW94LA042Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB MIA94LA029Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Moore Haven, FLFailure of the pilot-in-command to maintain aircraft control following loss of engine power for undetermined reasons.NTSB BFO94LA018Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Stowe, VTThe pilot did not follow the emergency procedure after loss of power in the right engine, by failing to feather the right engine and failing to maintain minimum single-engine control speed. A factor related to the accident was: failure of the pilot to adhere…NTSB MIA94LA027Accident · 1 fatalLimited investigationFinal reportThompson Bushby Mustang II · Madison, MSAn engine failure for undetermined reasons.NTSB LAX94LA066Accident · No injuriesLimited investigationFinal reportYakovlev YAK-55M · Greenfield, CAUndetermined.NTSB LAX94LA051Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-1B-2 · Las Vegas, NVWere the fuel injection line contamination resulting in fuel starvation; the pilot's inadequate 100-hour inspection; the pilot's improper decision to return to the airport at a low altitude; and his failure to maintain the proper airspeed which resulted in a…NTSB NYC94FA027Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Kinnelon, NJThe loss of engine power for undetermined reasons.NTSB BFO94LA012Accident · No injuriesLimited investigationFinal reportAngel Elbert S JR Quickie 200 · North Kingston, RILoss of engine power due to undetermined reasons.NTSB BFO94LA011Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Elmira, NYA loss of engine power at a critical point on a practice autorotation, and failure of the pilot to attain a flare for the landing. Factors related to the accident were: the adverse wind and downdraft.NTSB ATL94LA015Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Griffin, GAThe pilot's failure to maintain airspeed while maneuvering following a loss of engine power for unknown reasons.NTSB BFO94LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150M · West Milford, NJThe loss of engine power due to an undetermined reason. A factor in this accident was the lack of suitable terrain to complete a forced landing.NTSB BFO94LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Manassas, VAThe loss of total engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain to enable the completion of a power-off forced landing.NTSB FTW94LA027Accident · No injuriesLimited investigationFinal reportCessna 150G · Salem, ARPartial loss of engine power for undetermined reasons. A factor was unsuitable terrain for the forced landing.NTSB SEA94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Mckenzie Bridge, ORA partial loss of engine power for undetermined reasons.NTSB MIA94LA014Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Fort Lauderdale, FLAn engine failure for undetermined causes over terrain unsuitable for a forced landing.NTSB LAX94LA026Accident · No injuriesLimited investigationFinal reportCessna 177B · Pleasant Grove, CAThe failure of the starter to turn the engine over due to inadequate maintenance and inspection.NTSB SEA94LA021Accident · Serious injuriesLimited investigationFinal reportHannah Avid Amphibian · Scappoose, ORThe pilot's poor inflight decision, and failure to maintain sufficient airspeed. Factors include contaminated fuel.NTSB LAX94LA025Accident · 2 fatalLimited investigationFinal reportWittman Tailwind W8L · San Jose, CAThe loss of engine power for an undetermined reason(s). A factor in the accident was the unsuitable nature of the terrain encountered during the forced landing.NTSB CHI94LA026Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Saint Paul, MNother maintenance personnel's improper maintenance installation and fuel system line fitting undertorqued. Factors related to the accident were the dark night, along with the fence and posts which were contacted.NTSB NYC94LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Centreville, MDThe loss of engine power for undetermined reasons.NTSB MIA94LA011Accident · Minor injuriesLimited investigationFinal reportCessna AT188B · Zellwood, FLPartial loss of engine power for undetermined reasons.NTSB CHI94LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Frankenmuth, MIImproper use of the mixture control by the pilot. Factors related to the accident were: the similarity of shape, size, and color of the mixture and carburetor heat controls and the terrain condition (with crop) in the emergency landing area.NTSB FTW94LA015Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Pueblo, COA complete, non mechanical failure of the power plant for unknown reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA022Accident · No injuriesLimited investigationFinal reportHiller UH12E · Sioux Rapids, IAthe Pilot in Command failed to maintain clearance with the terrain while proceeding up an upslope.NTSB CHI94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kansas City, MOLoss of power for an undetermined reason, and the pilot initiating the flight with a rough running engine. Factors related to the accident were: the building and the lack of suitable terrain for a forced landing.