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 LAX89LA177Accident · No injuriesLimited investigationFinal reportCessna 310C · Jackson, CAThe failure of the instructor pilot (pilot in command) to reject the takeoff after the loss of power on one engine when sufficient runway remained to stop the aircraft. Contributing to the accident was the disregard of the aircraft manual, failure to use the…NTSB CHI89LA082Accident · Minor injuriesLimited investigationFinal reportCessna 320D · Wixom, MIPilot's inattention to the fuel system during preflight and inadequate fuel system monitoring throughout the flight.NTSB SEA89LA076Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Milton-Freewtr, ORImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel.NTSB FTW89LA088Accident · No injuriesLimited investigationFinal reportCessna 182 · Owasso, OKInadequate preflight by the pilot, which resulted in fuel exhaustion from lack of fuel. The presence of trees was was a contributing factor.NTSB FTW89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eufaula, OKThe pilot's improper positioning of the fuel selector, which resulted in a loss of power due to fuel starvation, and his failure to followed the emergency procedure. A factor related to the accident was: rough terrain in the emergency landing area.NTSB LAX89LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAThe pilot did not adequately preflight the airplane to determine fuel quanity nor did he accurately calculate the fuel consumption. In addition, he failed to position the fuel selector to the fullest tank which resulted in fuel starvation to the engine on…NTSB MKC89FA096Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Wellsville, KSThe failure of the pilot to use carburetor heat during the descent for landing which resulted in a loss of engine power at a critical time in flight, a go-around.NTSB LAX89LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Long Beach, CAThe pilot's failure to select the proper fuel tank for an adequate fuel supply for the takoeff.NTSB MIA89LA135Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Olive Branch, MSFuel exhaustion caused by the pilot exceeding the fuel endurance of the airplane.NTSB NYC89LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Gettysburg, PAThe pilot's poor preflight and in-flight planning in electing to continue the flight beyond the planned destination which resulted in fuel exhaustion.NTSB FTW89LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Athens, TXFuel exhaustion due to inadequate preflight by the pilot.NTSB ANC89LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Kenai, AKImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion.NTSB LAX89LA162Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAThe pilots improper use of carburetor heat in conditions that were conducive to the formation of carburetor ice.NTSB LAX89LA161Accident · No injuriesLimited investigationFinal reportCessna 175 · Victorville, CAThe pilot's failure to conduct an adequate preflight and assure the proper quantity of fuel on board for the proposed flight.NTSB LAX89LA169Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Bolinas, CAThe pilot's poor preflight planning in that he did not accurately account for the fuel on board the aircraft as a basis for fuel consumption calculations thereby causing the engine to stop producing power because of a lack of fuel. Contributing to the…NTSB SEA89FA068Accident · 2 fatalField investigationFinal reportLake LA-4-200-EP · Bellevue, WALoss of engine power for an undetermined reason and failure of the instructor pilot (CFI) to maintain control of the aircraft, which resulted in a stall/spin.NTSB MIA89LA129Accident · No injuriesLimited investigationFinal reportLuscombe 8A · St Augustine, FLFuel contamination. A related factor was the tree.NTSB LAX89LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Irwindale, CAImproper procedure used by the certified flight instructor in simulating an engine failure. Contributing to this accident was the lack of total flight instruction experience of the flight instructor.NTSB DEN89LA105Accident · No injuriesLimited investigationFinal reportCessna 172F · Morgan, UTInadequate servicing of the aircraft by the pilot, partial blockage of the fuel line and fuel filter, and fuel starvation. Contributing factors were: the downward sloping runway and a fence.NTSB ATL89LA125Accident · No injuriesLimited investigationFinal reportCessna 150B · Hickory, NCThe pilot's failure to refuel the airplane prior to the flight resulting in fuel exhaustion during takeoff.NTSB LAX89LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilots improper use of carburetor heat in weather conditions which were conducive to the formation of carburetor ice.NTSB MKC89LA088Accident · No injuriesLimited investigationFinal reportMooney M20E · Lake Elmo, MNFuel tank selector improperly positioned, emergency procedure improperly performed by the pilot, and fuel starvation.NTSB MIA89LA126Accident · No injuriesLimited investigationFinal reportBeech F-33A · Reddington Bch., FLLoss of engine power for undetermined reasons.NTSB MIA89LA125Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Lakeland, FLImproper in-flight planning/decision, which resulted in fuel starvation, while the fuel selector was positioned to a tank with the least amount of fuel. A factor related to the accident was: the faulty fuel quantity indication for the right tank.NTSB MIA89FA124Accident · Serious injuriesField investigationFinal reportBeech C-45H · Tampa, FLFuel contamination of the left engine fuel system which resulting in a failure of the left engine.NTSB LAX89LA152Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Long Beach, CAImproper in-flight planning/decision by the pilot, which led to an inadequate supply of fuel to reach the airport and subsequent fuel exhaustion. The pilot's lack of flight time in this make and model of helicopter was considered to be a factor.NTSB ATL89LA128Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Barnwell, SCThe pilot's poor in-flight planning/decision in continuing flight to the destination airport without refueling which resulted in fuel exhaustion. Unfavorable winds and inadequate fuel consumption calculations were contributing factors.NTSB CHI89LA070Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Bunker Hill, ILImproper preflight by the student pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: soft terrain.NTSB ATL89FA122Accident · 1 fatalField investigationFinal reportCessna 182 · Luthersville, GAPilot's failure to take action that would prevent the formation of carburetor ice. Following the engine malfunction, the pilot did not configure the airplane so as to reduce the severity of the impact, I.e. extend the flaps and slow the airplane. Contributing…NTSB DEN89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Los Lunas, NMInadequate preflight by the pilot, which resulted in fuel exaustion from an inadequate supply of fuel. Factors related to the accident were: false fuel quantity indication, hard landing by the pilot, and uneven terrain conditions.NTSB ANC89FA056Accident · No injuriesField investigationFinal reportPiper PA-18 · Chugiak, AKCarburetor ice due to the pilot's improper use of powerplant controls; and failure of the pilot to maintain adequate airspeed, while maneuvering (turning left), which resulted in an inadvertent stall. Factors related to the accident were: failure of the pilot…NTSB ATL89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe pilot's failure to properly plan required fuel for this flight which resulting in fuel exhaustion and a forced landing in a field.NTSB FTW89LA076Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Abilene, TXThe collapse of the nose gear during a forced landing following fuel exhaustion during the descent into the destination airport.NTSB ATL89DKG02Accident · Minor injuriesFinal reportCessna A188B · Statesboro, GAImproper inflight planning which allowed the engine to lose power due to fuel exhaustion.NTSB FTW89FA074Accident · 1 fatalField investigationFinal reportCessna 421 · Brownsville, TXThe pilot's improper emergency procedure after lossing power in the right engine, and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: fuel starvation of the right engine,…NTSB NYC89LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Pittstown, NJImproper inflight planning which led to engine failure due to fuel exhaustion.NTSB FTW89LA069Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Catoosa, OKCarburetor ice and improper use of carburetor heat. Factors related to the occurrence were: carburetor icing conditions and rough/uneven terrain.NTSB LAX89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fullerton, CAEngine failure due to fuel starvation, the selection of the improper fuel tank by the student, and poor supervision by the instructor. Contributing to the cause of the accident was an inadequate preflight of the airplane by the dual student.NTSB LAX89LA129Accident · No injuriesLimited investigationFinal reportHughes 269C · Saipan, SarkFailure of maintenance personnel to assure the helicopter was serviced with the proper grade of fuel. A factor realated to the accident was: the lack of a suitable landing area, which resulted in having to ditch the helicopter in the water.NTSB LAX89LA128Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Jose, CAImproper in-flight planning/decision by the pilot and subsequent fuel exhaustion. Contributing factors were: dark night,trees, and the building.NTSB MIA89LA110Accident · No injuriesLimited investigationFinal reportCessna 195 · Moore Haven, FLInadequate preflight by the pilot which resulted in fuel exhaustion due to inadequate fuel supply. A contributing factor was a ditch which the aircraft hit as the pilot was applying brakes to avoid a fence.NTSB ATL89FA106Accident · 2 fatalField investigationFinal reportBeech H35 · Knoxville, TNThe pilot's continued operation of the airplane with a known mechanical defect in the engine carburetor/fuel supply system as evidenced by the past history of engine stoppage during ground operation. Contributing to the accident was the pilot's performance of…NTSB ANC89LA053Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Fairbanks, AKThe student pilot's inproper use of carburetor heat and the instructors failure to properly supervise the student actions within the airplane.NTSB FTW89LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Henryetta, OKThe loss of engine power from fuel starvation due to inadequate inflight planning/decision.NTSB DEN89LA085Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Roy, UTThe pilot allowed himself to become distracted by a landing gear problem, which resulted in fuel exhaustion, when he had insufficient fuel to delay his landing. Factors related to the accident were: the landing gear problem and trees in the emergency landing…NTSB BFO89LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gingerville, MDThe pilot's improper planning and decision making en route that resulted in his failure to stop and refuel the airplane and fuel exhaustion.NTSB MKC89LA078Accident · No injuriesLimited investigationFinal reportCessna 175 · Murray, NEWater contamination of the fuel and the pilot's inadequate preflight of the aircraft. A factor related to the accident was: the ditch in the emergency landing area.NTSB MIA89LA103Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLFailure of the pilot to use the carburetor heat, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstructions (power lines & vehicles) in the emergency landing area.NTSB ATL89LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCCarburetor ice due to the failure of the pilot to properly use the carburetor heat control during descent and flight in the traffic patterns at reduced power. Underlying this is inadequate training in the proper understanding of carburetor icing and the…NTSB ATL89LA102Accident · No injuriesLimited investigationFinal reportCessna 172G · Coolidge, GAFuel contamination of an unknown origin, failure of company maintenance personnel to locate and remove all contamination, continued operation of the aircraft by the pilot after the cause of a known engine problem was not determined, and subsequent fuel…