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 NYC01LA175Accident · Minor injuriesLimited investigationFinal reportYakovlev 52 · Moultonboro, NHA clogged fuel vent line due to a mud dauber nest, and rough terrain, including a large hole, in the forced landing field.NTSB MIA01LA186Accident · Serious injuriesLimited investigationFinal reportPitenpol Aircamper 1933 · Hernando, FLThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI01LA216Accident · No injuriesLimited investigationFinal reportStemme S10-VT · Antigo, WIThe cause of the loss of engine power and in-flight fire was undetermined.NTSB LAX01LA245Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blythe, CAThe selection by the pilot of an unsuitable precautionary landing site on soft, uneven terrain, which resulted in a rollover.NTSB CHI01FA206Accident · 6 fatalField investigationFinal reportBeech E-55 · Carterville, MOThe pilot's failure to maintain aircraft control and the pilot's improper in-flight planning and decisions. Factors relating to the accident were the pilot's lack of experience in the airplane, the inadvertent spiral, and the residence.NTSB MIA01LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Boca Raton, FLA loss of engine power, and the pilot unable to feather the propeller for undetermined reasons, which resulted in a forced landing on a highway, subsequent impact with a pole and vehicles.NTSB FTW01LA164Accident · Minor injuriesLimited investigationFinal reportYoung RV-6 · Spring, TXthe loss of engine power for undetermined reasons during the landing approach. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01FA204Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Lafayette, INThe fuel exhaustion due to the pilot's alcohol impaired decision making. Additional factors were the trees and night.NTSB ATL01LA075Accident · No injuriesLimited investigationFinal reportBell 47 · Indianola, MSThe pilot's improper use of flight controls during an autorotation that resulted inn the collapse of the skids and cross tube assembly. A factor was the loss of engine power due to the failure of # 1 connecting rod and the overload failure of the skids and…NTSB ATL01TA081Accident · No injuriesFinal reportHughes TH-55 · Midway, GAThe loss of engine power for undetermined reasons. A factoe was the lack of suitable terrain upon which an emergency landing could be made, which resulted in a rollover upon touchdown in a marshy area.NTSB CHI01LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Stillwater, MNThe loss of engine power for undermined reasons and the unsuitable terrain encountered during the forced landing. Additional factors included the power line and the trees.NTSB LAX01FA236Accident · No injuriesField investigationFinal reportBell 47D-1 · Riverside, CAThe engine crankshaft's failure as the result of fatigue cracking initiated by surface damage and localized overheating due to the installation at overhaul of incorrectly sized bearings.NTSB ATL01LA074Accident · No injuriesLimited investigationFinal reportCessna 208B · Ft. Lauderdale, FLThe undetermined malfunction of the propeller system.NTSB ATL01LA072Accident · No injuriesLimited investigationFinal reportRyan Navion B · Palm Beach, FLLoss of engine power for undetermined reasons.NTSB LAX01FA234Accident · No injuriesField investigationFinal reportBeech 35A · Linden, CAThe engine lost power for undetermined reasons.NTSB CHI01LA193Accident · No injuriesLimited investigationFinal reportCessna 182 · Taylorville, ILThe pilot's improper procedure and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing and the corn crop.NTSB ATL01LA071Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Mulberry, FLThe loss of engine power for undetermined reasons. A factor was rough and uneven terrain.NTSB CHI01LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Mecosta, MIthe inadequate preflight planning/preparation by the pilot and fuel starvation. Additional causes were the aircraft control not maintained, and the inadvertent stall by the pilot.NTSB CHI01LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Albion, ILthe maintenance performed on the airplane by the unqualified pilot The unsuitable takeoff area selected by the pilot was an additional cause. The ditch was a contributing factor.NTSB CHI01LA194Accident · 1 fatalLimited investigationFinal reportHouston Challenger II · Sedalia, MOthe unsuitable terrain encountered during the forced landing. Additional factors were the pilot's lack of experience in the type of airplane, the loss of engine power for undetermined reasons, and the trees.NTSB ANC01LA079Accident · No injuriesLimited investigationFinal reportCessna 180 · Willow, AKA fire of undetermined origin, following a precautionary landing.NTSB CHI01LA192Accident · Minor injuriesLimited investigationFinal reportMelenyk Genesis · Howell, MIthe in-flight planning/decision by the pilot. Contributing factors were the undetermined loss of engine power, the quartering tailwind and the unsuitable terrain encountered by the pilot.NTSB ANC01LA077Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Willow, AKA loss of engine power for an undetermined reason.NTSB CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.NTSB CHI01LA189Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Hudson, MIUnsuitable terrain for landing encountered by the pilot during the forced landing attempt. Factors relating to this accident were fuel starvation caused by foreign material blocking the fuel tank lines which led to the engine failure, annual inspection…NTSB NYC01LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Watch Hill, RILoss of engine power for undetermined reason.NTSB ANC01GA075Accident · 1 fatalFinal reportPiper PA-18-150 · King Salmon, AKThe pilot's selection of the incorrect fuel tank, subsequent fuel starvation, and inadvertent stall during initial climb. Factors associated with the accident were inadequate transition training, and insufficient training standards of the operator/management.NTSB LAX01LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Napa, CALoss of engine power due to the restricted movement of the number 1 exhaust valve that subsequently bent the exhaust push rod and push rod housing.NTSB FTW01LA152Accident · 1 fatalLimited investigationFinal reportMottier RV-6 · Hammond, LAthe pilot's failure to maintain aircraft control following a loss of engine power. A factor was the loss of engine power during takeoff initial climb for undetermined reasons.NTSB CHI01LA203Accident · No injuriesLimited investigationFinal reportBellanca 14-13-3 · Pierce, NEThe improper management of the fuel system by the pilot. Factors were the fuel starvation, the pilot's lack of familiarity with the airplane, the berm, and the unsuitable terrain for landing encountered by the pilot.NTSB FTW01LA153Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Houston, TXthe loss of engine power for an undetermined reason, which resulted in a collision with terrain.NTSB LAX01LA216Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Mesa, AZa loss of power for unexplained reasons. Also causal was the CFI's operation of the helicopter in a region of the height/velocity curve where a successful autorotation could not be accomplished. A factor in the accident was the high density altitude.NTSB CHI01LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Plattsmouth, NEthe loss of engine power for undetermined reasons during the approach and the inadvertent stall that occurred during the forced landing. Factors relating to this accident were the low airspeed, the uphill terrain, and the fence.NTSB ANC01LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eek, AKA malfunction of the engine fuel control due to an improper overhaul by other maintenance personnel, and subsequent loss of engine power during cruise flight. A factor in the accident was unsuitable terrain for a forced landing.NTSB FTW01LA149Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Paris, TXthe loss of engine power for an undertermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA178Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28A · Eldridge, IAThe inadequate autorotation and disregarded wind information by the pilot. Factors were the gusting tailwind and the loss of engine power for undetermined reasons.NTSB CHI01LA170Accident · No injuriesLimited investigationFinal reportCessna 150L · Munster, INEngine failure during takeoff due to water contaminating the fuel, the pilot's inadequate preflight planning/preparation, and the low altitude. Factors relating to this accident were the attempted emergency landing after takeoff and the fence.NTSB NYC01LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, MEA loss of engine power for an undetermined reason.NTSB LAX01FA207Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Stockton, CAa loss of engine power for undetermined reasons. Also causal was the inadequate supervision of the flight by the CFI for allowing a simulated emergency maneuver to continue below an altitude which would not allow for recovery contingencies.NTSB FTW01LA142Accident · No injuriesLimited investigationFinal reportCessna 340A · Lancaster, TXA loss of engine power for undetermined reasons. Contributing to the accident was the collapse of the landing gear for undetermined reasons.NTSB SEA01LA118Accident · No injuriesLimited investigationFinal reportHughes 369D · Canby, ORFuel starvation as a result of a collapsed fuel nozzle filter screen. Contamination that blocked the fuel nozzle screen and water contamination were factors.NTSB SEA01LA115Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Eastsound, WAFailure of the engine driven fuel pump due to a worn snap ring which resulted in a loss of engine power during initial climb. Failure to comply with Service Bulletin inspection instructions, and collision with trees were factors.NTSB FTW01LA140Accident · Serious injuriesLimited investigationFinal reportBeech BE-35 · Springdale, ARthe loss of engine power due to an undetermined reason.NTSB CHI01LA158Accident · No injuriesLimited investigationFinal reportPackwood Packwood 1 · Pierce City, MOan engine failure during initial climbout and the fence struck during the runway overrun.NTSB CHI01LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · La Porte, INthe inadequate planned approach by the pilot. Contributing factors were the fuel starvation and tailwind.NTSB NYC01LA139Accident · No injuriesLimited investigationFinal reportCessna 172M · Nashua, NHThe CFI's improper decision to abort the takeoff and his improper flare, which resulted in a hard landing.NTSB MIA01LA155Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kill Devil Hill, NCThe loss of engine power due to fuel starvation for undetermined reasons resulting in the forced landing and subsequent on-ground collision with a sand dune with a resulting nose over. A factor in the accident was the unsuitable terrain encountered during the…NTSB ATL01LA062Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Picayune, MSThe pilot's inflight fuel planning /decision that resulted in fuel starvation and a loss of engine power. A factor was the failure of the fuel transfer pump.NTSB CHI01LA152Accident · No injuriesLimited investigationFinal reportAllen Rotorway 162F · Jerseyville, ILthe improper autorotation by the pilot. Contributing factors were the engine failure for undetermined reason(s) and the muddy terrain.NTSB SEA01LA109Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Salem, ORLoss of engine power during cruise flight for an undetermined reason. A factor in the accident was tall grass in the landing area.