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 NYC94LA094Accident · 1 fatalLimited investigationFinal reportBradford Seahawk · Richmond, KYwas the loss of engine power for undetermined reasons, and the collision with an object during the subsequent forced landing.NTSB CHI94DTK01Accident · No injuriesFinal reportWeatherly 620 · Ridgeview, SDfuel starvation due to the pilot's improper fuel tank selection.NTSB FTW94LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Page, AZThe total loss of engine power for undetermined reason. A factor was the lack of suitable terrain at the pilot's disposal.NTSB CHI94DCG01Accident · 1 fatalFinal reportDavis TRI-Q 200 · Joplin, MOLoss of engine power for undetermined reasons, and the pilot's failure to maintain control of the airplane. Factors which contributed to the accident were: the pilot intentionally operating an airplane with known deficiencies, his lack of experience in the…NTSB FTW94LA162Accident · No injuriesLimited investigationFinal reportRockwell 112A · Henderson, NVThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA94FA141Accident · 1 fatalField investigationFinal reportBeech 95-55 · New Port Richey, FLThe pilot's feathering of the wrong propeller after an engine failure for undetermined reason(s).NTSB FTW94LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · High Island 334A total loss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB SEA94LA112Accident · No injuriesLimited investigationFinal reportBeech A24R · Everett, WAFuel system pump contamination and procedures/directives were not followed.NTSB BFO94LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Hollis, NHThe pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.NTSB MIA94LA126Accident · Minor injuriesLimited investigationFinal reportParsons BP Gyro · Bunnell, FLThe pilot-in-command's improper use of the flight controls during landing flare touchdown, resulting in the gyroplane touching down on the nose gear, and subsequent nose over. The loss of engine power was also a cause.NTSB LAX94LA204Accident · No injuriesLimited investigationFinal reportBeech UC-45J · Acampo, CAThe pilot's failure to use carburetor heat during the extended power-off descent. The existing carburetor icing conditions, the pilot's diverted attention, and the power lines were factors in this accident.NTSB FTW94LA131Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Delaplaine, ARThe loss of engine power for undetermined reasons. A factor was the low altitude at which the power loss occurred.NTSB ATL94LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ozark, ALA loss of engine power for undetermined reasons. A factor was the soft terrain.NTSB CHI94DEE01Accident · 2 fatalFinal reportRemote Sensing Cirrus VK-30 · Lk In The Hills, ILfuel starvation resulting from the modification of the fuel system. A factor was the modification to the fuel system.NTSB FTW94LA128Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of power for undetermined reasons and the inadvertant stall during the forced landing. A factor was the lack of suitable terrain.NTSB SEA94LA160Accident · No injuriesLimited investigationFinal reportNewgard Kitfox III · Yelm, WAFuel starvation due to an inadequately installed fuel line.NTSB FTW94LA125Accident · Minor injuriesLimited investigationFinal reportHiller UH-12 · Alvin, TXThe pilot's failure to maintain rotor speed, delay of the flare, and the improper touchdown. A factor was the loss of engine power for undetermined reasons.NTSB FTW94LA124Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Englewood, COThe pilot's failure to maintain rotor RPM, his delayed flare, and improper touchdown. A factor was a failure of the fuel control/governor to the high side which required the pilot to perform a full autorotation.NTSB MIA94LA116Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mayaguez, PRLoss of engine power for undetermined reasons which resulted in a descent and ditching.NTSB LAX94LA201Accident · No injuriesLimited investigationFinal reportSchweizer 300C · Pacific Ocean (Pacific Ocean)The low altitude of the aircraft when the engine lost power and the pilot's misjudgement of the flare point during the autorotation. Factors in the accident were the loss of engine power and the sunglare.NTSB BFO94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Gloucester, VAThe pilot-in-command's failure to perform adequate pre-flight inspections and planning for the flight, and his failure to refuel the airplane. This led to fuel exhaustion of the engine and a forced landing.NTSB ANC94LA045Accident · No injuriesLimited investigationFinal reportHiller UH12E · Valdez, AKThe inadvertent closure of the fuel supply shutoff valve.NTSB FTW94LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Englewood, COA loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ANC94LA046Accident · No injuriesLimited investigationFinal reportHelio 295 · Manley Hot Sprg, AKFuel starvation caused by a blocked fuel vent line. A factor in the accident was the improper aircraft preflight.NTSB LAX94LA182Accident · 1 fatalLimited investigationFinal reportCessna 152 · Avalon, CAthe failure of the pilot to apply carburetor heat as appropriate while conducting flight in conditions conducive for carburetor icing. A factor in the accident was the unsuitable steep mountainous terrain for a forced landing.NTSB SEA94FA096Accident · 4 fatalField investigationFinal reportBell 206B3 · Lamoille, NVThe ingestion of foreign material (snow) in the engine, which resulted in a flameout (loss of engine power). Factors related to the accident were: the adverse weather conditions (snow falling & high density altitude), the lack of snow covers to protect the…NTSB LAX94LA180Accident · Serious injuriesLimited investigationFinal reportCurry FLY-BABY · Bisbee, AZa loss of engine power due a blockage in the fuel tank outlet which caused fuel starvation.NTSB FTW94LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe loss of engine power for undetermined reasons. Factors were the wire strike and lack of suitable terrain.NTSB NYC94LA072Accident · Serious injuriesLimited investigationFinal reportRandolph Flagg Boredom Fighter · Norridgewock, METhe loss of engine power for undetermined reasons.NTSB LAX94LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Santa Maria, CAAn engine failure due to the improper installation and service of an incorrect model magneto by maintenance personnel, and the failure of the pilot-in-command to follow published airplane emergency procedures.NTSB FTW94LA109Accident · No injuriesLimited investigationFinal reportCessna 175 · Leesville, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Romeo, MIthe pilot's improper use of carburetor heat. A factor in the accident is weather conducive to the formation of carburetor ice.NTSB NYC94GA066Accident · 1 fatalFinal reportHughes 369A · Northford, CTThe loss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM during the forced landing autorotation, resulting in a loss of aircraft control and collision with trees. Also causal to the accident was the pilot's lack of…NTSB LAX94LA168Accident · Serious injuriesLimited investigationFinal reportFighter Rebuilders F-2G · Mesa, AZthe airplane sustained a total loss of power and an in-flight fire for undetermined reasons.NTSB FTW94LA107Accident · No injuriesLimited investigationFinal reportCessna 210L · Haskell, OKWas the loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB BFO94LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hagerstown, MDThe loss of partial engine power for undetermined reasons.NTSB ATL94GA065Accident · Serious injuriesFinal reportConsolidated Aeronautics Lake LA-4-200 · Williamson, GALoss of engine power for an undetermined reason. A factor related to the accident was: improper planning/decision by the flight instructor (CFI).NTSB ATL94LA063Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Nashville, TNA loss of engine power for undetermined reasons.NTSB FTW94LA097Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Hamburg, ARThe loss of engine power due to fouled spark plugs. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Olla, LAThe loss of engine power due to a blocked fuel line. A factor was the lack of suitable terrain for the forced landing.NTSB ATL94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · St. Matthews, SCA loss of engine power for undetermined reasons. A factor was the electric transmission wire located at the forced landing site.NTSB ATL94LA058Accident · Minor injuriesLimited investigationFinal reportRutan Rutan Long EZ · Kill Devil Hill, NCWas the pilot's failure to adequately sump the fuel system during the preflight inspection.NTSB MIA94LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Miami, FLLoss of engine power for undetermined reasons.NTSB LAX94LA196Accident · No injuriesLimited investigationFinal reportSchweizer 300C · Pacific Ocean (Pacific Ocean)The loss of engine power for undetermined reasons.NTSB LAX94LA170Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Santa Paula, CAthe existing meteorological conditions that were conducive to carburetor icing.NTSB SEA94LA065Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Gold Hill, ORSeparation of the crossover fuel line, and the inability of the pilot in command to maintain a proper rate of descent during the autorotation.NTSB ATL94LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kinston, NCA loss of engine power due to a partial blockage of the induction air system by a foreign object (silicon baffling material).NTSB BFO94LA048Accident · No injuriesLimited investigationFinal reportJenks Skybolt · Brockport, NYA loss of engine power due to undetermined reason (s). A factor in this accident was the snow covered, rough/uneven terrain which caused the airplane to nose over during landing roll.NTSB MIA94LA075Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Fort Lauderdale, FLThe pilot-in-command's improper approach planning and premature extension of the landing gear, resulting in the flight being unable to maintain sufficient altitude and airspeed to reach the runway. The loss of engine power on one engine was a factor.NTSB LAX94LA143Accident · No injuriesLimited investigationFinal reportAyres S2R · Winterhaven, CAA loss of engine power for an undetermined reason.