NTSB investigations
5,891 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
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\" = 353) 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" = 353) 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 LAX89LA270Accident · Serious injuriesLimited investigationFinal reportBell 206B · Bakersfield, CAThe loss of engine power due to the helicopter being flown in exhaust gases emanating from a cogeneration plant chimney stack that exceeded the certification standards of the powerplant. Contributing to the accident was invisible nature of the exhaust gases…NTSB ATL89DLT05Accident · 1 fatalFinal reportBratton RB-1 · Springfield, TNImproper planning/decision by the pilot, which resulted in fuel exhaustion at a low altitude, due to an inadequate supply of fuel; and his failure to maintain airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: the…NTSB MIA89LA213Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Sarasota, FLThe student pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the student pilot's lack of total experience & tree(s) in the emergency landing area.NTSB ANC89LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Canyon Creek, AKThe pilot's improper planning/decision concerning fuel management, which resulted in fuel starvation. Contributing factors were: probable water in the fuel, inadequate altitude for an engine restart, and the terrain conditions.NTSB CHI89LA156Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILFailure of the student pilot to use carburetor heat, which resulted in loss of engine power, due to carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB MKC89LA173Accident · No injuriesLimited investigationFinal reportMooney M20C · Fouke, ARThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion, at night. The ensuing forced landing resulted in a collision with a fencepost, ground swerve, and collapse of the right main landing gear.NTSB ATL89LA186Accident · No injuriesLimited investigationFinal reportCessna 172L · N Myrtle Beach, SCWater contamination of the airplane fuel supply, and the pilot's failure to adequately preflight the aircraft. A factor related to the accident was: swampy terrain at the emergency landing site.NTSB MKC89LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft Smith, ARInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A contributing factor was the road sign.NTSB NYC89LA218Accident · No injuriesLimited investigationFinal reportCessna 305A · Chalfont, PAThe pilot's improper use of carburetor heat, which resulted in a power loss due to carburetor ice. Factors related to the accident were: carburetor icing conditions and rough/uneven terain in the emergency landing area.NTSB LAX89LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Corona, CAContinued buildup of carburetor ice due to the pilot's improper use of carburetor heat, and his improper use of emergency procedures. Factors related to the accident were: carburetor icing conditions, the pilot's lack of recent flight experience, and trees in…NTSB CHI89FA150Accident · No injuriesField investigationFinal reportProspector FK-1 · Chilton, WIThe pilot's poor in flight planning in that he diverted his attention and continued the flight beyond the original period planned. Before takeoff the pilot was aware of his fuel endurance.NTSB BFO89FA064Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Bradshaw, MDAn engine power loss due to fuel starvation for unknown reasons.NTSB ANC89FA130Accident · Serious injuriesField investigationFinal reportCessna 180A · Wasilla, AKInadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel and his failure to maintain adequate airspeed while maneuvering back toward the lake which resulted in an inadvertent stall. The house & trees were…NTSB LAX89LA256Accident · No injuriesLimited investigationFinal reportCessna 172M · Marana, AZInadequate preflight by the student pilot, inadequate supervision by the flight instructor (CFI), and fuel exhaustion due to lack of fuel. Related factors were: inoperative left fuel quantity gage, the cfi's decision to make the flight with a known deficiency…NTSB DEN89LA181Accident · No injuriesLimited investigationFinal reportCallair A-9 · Cartwright, NDA total loss of power due to an improperly adjusted carburetor which resulted in an excessive rich fuel-air mixture. This required a forced landing in an area where no suitable terrain existed.NTSB DEN89LA180Accident · No injuriesLimited investigationFinal reportCessna 150G · West Jordan, UTInadequate preflight by the pilot, which resulted in fuel exhaustion, due to his misjudgement of the fuel supply. Factors related to the accident were: a false fuel gage indication, and the ditch in the emergency landing area.NTSB CHI89DEP09Accident · No injuriesFinal reportCabrinha/Free Spirit 412 · Waukesha, WIThe plt became lost/disoriented and allowed fuel exhaustion to occur before accomplishing remedial action. Factors related to the accident were: the adverse environmental conditions and the road sign and vehicles in the emergency landing area.NTSB BFO89FA063Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · True, WVThe pilots failure to properly monitor the fuel supply which resulted in fuel starvation. The aircraft stalled as the pilot performed an evasive maneuver to avoid the mountain top.NTSB MIA89LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Homestead, FLImproper repair of the fuel cap (seal) by the pilot, which resulted in a blocked fuel system (cap) vent and subsequent fuel starvation, and his failure to see-and-avoid the telephone line. The telephone (transmission) line was a contributing factor.NTSB CHI89LA149Accident · No injuriesLimited investigationFinal reportCessna 172M · Wixom, MICarburetor ice due to the pilot's improper use of carburetor heat. Factors related to the accident were: weather conditions conducive to carburetor ice, dark night, and tree(s) in the emergency landing area.NTSB CHI89DEE05Accident · No injuriesFinal reportCessna 152 · Romeoville, ILThe pilot's misjudgement of the fuel supply.NTSB DEN89FA177Accident · 1 fatalField investigationFinal reportCessna 152 · Logan, UTInadequate preflight and improper inflight planning/decision by the student, which resulted in fuel exhaustion from an inadequate supply of fuel, and the student's failure to maintain airspeed, while maneuvering, which resulted in an inadvertent stall/spin. A…NTSB MKC89LA166Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Hannibal, MOFuel starvation for undetermined reasons which resulted in a forced landing and subsequent collision with trees.NTSB BFO89FA062Accident · 1 fatalField investigationFinal reportBeech 77 · Cluster Springs, VAThe pilot's failure to perform an adequate preflight which resulted in an unlatched fuel filler cap. Contributing to the accident was the pilot's failure to monitor the fuel supply during the flight.NTSB SEA89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Meridian, IDThe pilot's failure to properly position the fuel selector, which resulted in fuel starvation, his failure to follow the emergency procedure, and his inadequate visual lookout (failure to see & avoid obstructions). The power line was a related factor.NTSB DEN89LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Weston, COWater in the fuel and inadequate preflight by the pilot. A contributing factor was the ditch.NTSB SEA89LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Albion, IDThe pilot's improper use of the mixture control during takeoff. The fence was a related factor.NTSB ATL89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Somerset, OHThe pilot's failure to adequately perform an airplane pre-flight inspection and drain water present in the airplane fuel supply. The airplane engine subsequently lost power due to the water contamination.NTSB LAX89LA240Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Chandler, AZInadequat preflight planning/preparation and the improper flight planning/decisions, ie. Improper fuel consumption calculations, by the PIC.NTSB ATL89LA179Accident · No injuriesLimited investigationFinal reportCessna P210N · Jackson, SCThe pilot's mismanagement of the available fuel supply which resulted in a total loss of engine power. The fuel selector was not positioned to the tank which contained fuel. Contributing factor(s) was: the rough terrain encountered during the forced landing.NTSB LAX89DUJ07Accident · No injuriesFinal reportGrumman G-164A · Eloy, AZInaequate preflight by the pilot, which resulted in fuel starvation during the climb after takeoff, due to very little fuel remaining in the tanks. The rough/uneven desert terrain was considered to be a contributing factor.NTSB FTW89LA139Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Llano, TXThe pilot's inadvertent closing of the mixture control while his attention was diverted to the landing gear cycling. The engine subsequently quit followed by a forced landing and collision with trees.NTSB FTW89LA141Accident · Minor injuriesLimited investigationFinal reportBeech 35-C33A · Fort Worth, TXFuel exhaustion due to pilot mismanagement.NTSB CHI89DEX05Accident · No injuriesFinal reportTexas Helicopter OH-13H/M74A · New Richmond, INThe pilot's misjudgement of the fuel supply which resulted in fuel exhaustion.NTSB CHI89LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Iola, WIThe improper preflight planning by the pilot in command resulting in the airplane fuel quantity being near the unusable quantity which resulted in total loss of engine power due to fuel starvation while maneuvering. Contributing to the accident was the pilots…NTSB ANC89FA119Accident · No injuriesField investigationFinal reportCessna 207 · 44 Nw Fairbanks, AKImproper planning/decision by the pilot, which resulted in fuel starvation. Factors related to the accident were: inaccurate fuel consumption calculations, inadequate fuel supply, turbulence, tailwind, terrain conditions, and trees (willows) in the emergency…NTSB NYC89LA159Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Akron, NYImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: soft terrain in the emergency landing area.NTSB MIA89LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Vero Beach, FLInadequate preflight by the pilot which resulted in fuel starvation due to an inadequate supply of fuel. The soft terrain in the emergency landing area was considered to be a contributing factor.NTSB LAX89LA232Accident · No injuriesLimited investigationFinal reportRyan SCW-145 · Santa Paula, CATotal loss of engine power for undetermined reasons.NTSB LAX89LA237Accident · No injuriesLimited investigationFinal reportCessna 150K · Woodland, CAThe pilot's poor judgement in not assuring an adequate fuel supply was on board for the flight.NTSB ANC89LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKLoss of engine power for an unknown reason. A factor related to the accident was: rough terrain in the emergency landing area.NTSB SEA89LA128Accident · No injuriesLimited investigationFinal reportBell 206B · Longview, WAThe pilot inadvertently turning off the engine fuel supply instead of the external load fuel supply. Contributing to the accident was the pilot's failure to jettison the external load during the autorotation.NTSB CHI89FA128Accident · 3 fatalField investigationFinal reportBeech 58 · Battle Creek, MIThe flight crew inadvertently shut down the left engine after the right engine lost power, and the copilot failed to maintain control of the aircraft while maneuvering the aircraft back toward the runway. Factors related to the accident were: improper…NTSB MIA89LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hilliard, FLThe inadequate pre-flight examination by the pilot, after refueling, which failed to detect water in the fuel.NTSB LAX89LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-30B-160 · Merced, CAThe pilot's inadequate preflight planning/preparation, resulting in fuel exhaustion.NTSB MKC89LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tunas, MOEngine failure due to fuel exhaustion because of improper flight planning by the pilot.NTSB MIA89FA184Accident · 1 fatalField investigationFinal reportCessna 177 · Stuart, FLInadequate maintenance/servicing of the aircraft, which resulted in water and rust contamination of the fuel and a subsequent loss of engine power, and failure of the pilot to maintain flying speed, while maneuvering back toward the runway, which resulted in…NTSB CHI89DEP06Accident · Minor injuriesFinal reportAeronca 15AC · Fort Atkinson, WIWater contamination of the fuel and the pilot's inadequate preflight. Factors related to the accident were: lack of suitable terrain for a forced landing & trees.NTSB LAX89LA228Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelseyville, CAInadequate preflight planning/preparations and the improper fuel consumption calculations by the pilot.NTSB FTW89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Elmendorf, TXPilot's decision to discontinue the use of carburetor heat, in carburetor icing conditions, that led to a complete loss of power at an altitude insufficient for a safe landing on the airport.