Skip to content

NTSB investigations

5,891 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 NYC95LA016Accident · No injuriesLimited investigationFinal reportAngel Avid/Heavy Hauler · Sutton, MAThe pilot's failure to maintain the fuel selector on the proper position.Oct 23, 1994 · N740FA · Substantial damage NTSB CHI95LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Houghton, MIinaccurate planning by the pilot which resulted in the failure to assure an adequate fuel supply to complete the flight. A factor associated with the accident was the lack of a suitable landing site for the forced landing.Oct 23, 1994 · N6464J · Substantial damage NTSB NYC95LA015Accident · No injuriesLimited investigationFinal reportCessna 172B · Honesdale, PAthe fuel selector was in the improper position, which resulted in a total loss of engine power, due to fuel starvation, a forced landing, and subsequent impact with a stone wall.Oct 21, 1994 · N7491E · Substantial damage NTSB FTW95IA022Incident · No injuriesIncident investigationFinal reportCanadair CL 600 · Nacogdoches, TXThe flight crew's improper use of the anti-ice system, which resulted in engine ice, subsequent ice ingestion, and engine flameout. Factors related to the accident were: failure of the flight crew to follow the checklist procedures after flight into adverse…Oct 17, 1994 · N600RE · Minor damage NTSB LAX95LA007Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Atherton, CAthe pilot's inadequate fuel consumption calculations and failure to refuel the aircraft while en route.Oct 15, 1994 · N67358 · Substantial damage NTSB LAX95LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAthe pilot's mismanagement of the fuel system and his failure to select a tank containing fuel.Oct 11, 1994 · N8413P · Substantial damage NTSB SEA95LA008Accident · Minor injuriesLimited investigationFinal reportCessna R172K · St. George, UTInadequate fuel consumption calculations. Factors to the accident were: fuel exhaustion and a parked aircraft in the landing path.Oct 10, 1994 · N7327K · Substantial damage NTSB NYC95LA002Accident · No injuriesLimited investigationFinal reportCessna 185F · Rochester, MAThe pilot's inadeqaute calculation of fuel and inadeqaute inflight decision which resulted in fuel exhaustion and the loss of engine power.Oct 9, 1994 · N53074 · Substantial damage NTSB FTW94LA317Accident · No injuriesLimited investigationFinal reportCessna 172B · Poteau, OKThe loss of engine power due to the pilot's delayed use of carburetor heat and the resultant carburetor icing. Factors were the weather condition and the lack of suitable terrain for the forced landing.Sep 28, 1994 · N7617X · Substantial damage NTSB LAX94LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Fullerton, CAFuel starvation due to improper fuel management.Sep 27, 1994 · N8707P · Destroyed NTSB LAX94LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · San Mateo, CAA deteriorated magneto grounding ('P' lead) and failure of maintenance personnel to detect this condition when the engine was reinstalled in the airframe after overhaul. The lack of suitable terrain for the forced landing was a factor.Sep 25, 1994 · N39658 · Destroyed NTSB FTW94LA309Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Denton, TXThe fuel starvation induced power loss due to the pilot's failure to maintain an adequate amount of fuel. Factors which contributed were: the lack of suitable terrain for the forced landing, and the pilot's evasive maneuver.Sep 25, 1994 · N9425C · Substantial damage NTSB CHI94DEV02Accident · Serious injuriesFinal reportThomas E. Georges Z-MAX · Palmyra, ILThe pilots's inadvertently stalled the airplane while maneuvering to land. Factors were the loss of engine power due to carburetor ice, carburetor icing conditions, and the unavailability of carburetor heat.Sep 25, 1994 · N4592M · Destroyed NTSB CHI94LA348Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dale, INthe pilot's failure to assure an adequate fuel supply for the flight. Factors associated with the accident were poor preflight planning, inattentiveness to the fuel supply during the flight, the ditch, and the utility pole which was contacted during the…Sep 23, 1994 · N6244W · Substantial damage NTSB CHI94LA336Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNAn inadequate pre-flight inspection by the pilot when he did not insure that all the water was drained from the airplane's fuel tanks. Factors associated with this accident were contaminated fuel and powerlines.Sep 18, 1994 · N4271V · Substantial damage NTSB CHI94LA333Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Elkhart, INthe pilot's improper use of the fuel selector position which resulted in fuel starvation.Sep 17, 1994 · N732HS · Substantial damage NTSB ANC94LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to assure that an adequate supply of fuel was available to complete the flight. A factor in the accident was the siphoning of fuel from the fuel cap.Sep 17, 1994 · N9359D · Substantial damage NTSB LAX94LA364Accident · No injuriesLimited investigationFinal reportRockwell 114 · Poway, CAfuel exhaustion due to the pilot's inadequate preflight planning and failure to refuel the aircraft prior to departure.Sep 16, 1994 · N114FF · Substantial damage NTSB MIA94LA211Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe failure of the pilot-in-command to calculate fuel consumption correctly resulting in loss of engine power due to fuel exhaustion.Sep 14, 1994 · N6517M · Substantial damage NTSB CHI94LA327Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Port Huron, MIInadequate preflight by the pilot resulting in fuel exhaustion. Inadequate maintenance and inspection was a factor contributing to the accident.Sep 14, 1994 · CFSMO · Destroyed NTSB LAX94LA380Accident · No injuriesLimited investigationFinal reportSinger Kitfox IV · Apple Valley, CAfuel exhaustion due to the pilot's failure to refuel prior to departure, and his inaccurate en route fuel consumption calculations.Sep 12, 1994 · N93CM · Substantial damage NTSB LAX94LA363Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Borrego Springs, CAThe pilot's inadvertent allowance of a fuel starvation loss of power event and his failure to select a tank containing fuel due to his lack of knowledge about the fuel pump/selector unit operating limitations. Factors in the accident were his limited…Sep 12, 1994 · N622D · Destroyed NTSB LAX94LA359Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Corona, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. Fuel exhaustion and the rough terrain were factors in this accident.Sep 11, 1994 · N4328L · Substantial damage NTSB CHI94LA323Accident · No injuriesLimited investigationFinal reportBeech D18S · Mt Pleasant, MIthe improper fuel selector position by the pilot-in-command which resulted in fuel starvation. A factor was rough/uneven terrain.Sep 9, 1994 · N666S · Substantial damage NTSB SEA94LA236Accident · No injuriesLimited investigationFinal reportCessna 182 · Circle, MTThe failure of the pilot-in-command (CFI) to perform an adequate preflight inspection of the airplane, including the proper securing of the fuel cap. The pilot's failure to divert to the nearest airport after recognizing excessive fuel consumption was a…Sep 8, 1994 · N2889R · Substantial damage NTSB CHI94DER03Accident · Serious injuriesFinal reportSmart CP 301 · Remer, MNthe failure of the alternator/electrical system, and subsequent total loss of engine power during cruise flight over wooded terrain.Sep 8, 1994 · N60AG · Substantial damage NTSB ATL94LA169Accident · No injuriesLimited investigationFinal reportCessna T210M · Willacooche, GAThe pilot's excessive fuel leaning during improper use of the mixture control, which resulted in pre-ignition/detonation and a total loss of engine power. Factors were the electrical wires and vehicles.Sep 8, 1994 · N761GQ · Substantial damage NTSB SEA94LA233Accident · No injuriesLimited investigationFinal reportCessna 150 · Cheyenne, WYFuel deterioration and/or contamination, and the pilot's decision to operate the airplane with a known problem.Sep 6, 1994 · N1396Q · Substantial damage NTSB LAX94FA354Accident · 4 fatalField investigationFinal reportStinson 108-3 · Shelter Cove, CAInadequate preflight by the pilot, which resulted in fuel starvation and loss of engine power, improper (or delayed) positioning of the fuel selector to the fullest tank, and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced…Sep 5, 1994 · N6446M · Destroyed NTSB FTW94LA290Accident · Minor injuriesLimited investigationFinal reportBeech J35 · Crockett, TXThe fuel starvation induced loss of engine power due to the pilot's improper fuel tank selection.Sep 5, 1994 · N5526D · Substantial damage NTSB CHI94LA313Accident · Serious injuriesLimited investigationFinal reportWilliam P. Bouda Varieze · Millard, NEthe loss of engine power due to fuel starvation from vapor lock. A factor associated with the accident is the soft terrain the pilot was forced to land upon.Sep 5, 1994 · N54WB · Substantial damage NTSB NYC94LA168Accident · No injuriesLimited investigationFinal reportBeech C35 · Rhinebeck, NYThe pilot's inadequate preflight planning and inaccurate fuel consumption calculations, resulting in fuel starvation and engine failure, and the subsequent collision with trees during a forced landing. A factor related to the accident was the turbulent air…Sep 4, 1994 · N5291C · Substantial damage NTSB CHI94FA310Accident · 1 fatalField investigationFinal reportCessna 182H · Plymouth, MICarburetor ice, and improper use of (or failure to use) the carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and the lack of suitable terrain for a forced landing.Sep 3, 1994 · N8470S · Destroyed NTSB NYC94FA165Accident · 1 fatalField investigationFinal reportBellanca 8-KCAB · Chatsworth, NJThe pilot's inadequate preflight that failed to detect water- contaminated fuel which resulted in the loss of engine power and the pilot's decision to conduct flight at an altitude too low to initiate emergency procedures.Sep 2, 1994 · N8670V · Destroyed NTSB CHI94LA308Accident · No injuriesLimited investigationFinal reportThalman Thorp T-18 · Kenosha, WIthe pilot's failure to use carburetor heat in carburetor icing conditions. A factor associated with the accident is the prevailing carburetor icing conditions.Sep 2, 1994 · N2911 · Substantial damage NTSB LAX94LA342Accident · No injuriesLimited investigationFinal reportTexas Helicopter M74 · Salinas, CAfuel exhaustion due to the pilot's inadequate preflight planning and in-flight fuel consumption monitoring.Aug 31, 1994 · N51852 · Substantial damage NTSB ANC94LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Anchorage, AKThe binding in the mechanical fuel selector valve, and lack of suitable terrain for a forced landing.Aug 31, 1994 · N9130K · Substantial damage NTSB CHI94LA306Accident · No injuriesLimited investigationFinal reportCessna 182 · Indianapolis, INthe pilot's improper use of the mixture control, the poorly planned approach and the inadvertent stall.Aug 30, 1994 · N2452M · Substantial damage NTSB FTW94LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · Arkadelphia, ARLoss of engine power due to fuel exhaustion and the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Aug 29, 1994 · N44687 · Substantial damage NTSB CHI94LA301Accident · No injuriesLimited investigationFinal reportCessna 172 · Whitehall, MIThe pilot in command's inadequate preflight planning. Factors related to the accident were the fuel exhaustion and the soft crop field.Aug 27, 1994 · N1106F · Substantial damage NTSB CHI94LA298Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Centralia, ILfuel exhaustion as a result of the pilots improper fuel calculation and improper use of fuel mixture.Aug 26, 1994 · N6307S · Substantial damage NTSB BFO94LA149Accident · Serious injuriesLimited investigationFinal reportMooney M20G · Bowling Green, OHfuel exhaustion for undetermined reason(s), which resulted in loss of engine power and a subsequent forced landing. A factor relating to the accident was: faulty fuel quantity gauge/system.Aug 24, 1994 · N3916N · Substantial damage NTSB BFO94LA147Accident · 1 fatalLimited investigationFinal reportRans S-14 Airaile · Phoenixville, PAthe pilot's failure to perform a preflight inspection, which resulted in a loss of engine power due to fuel contamination.Aug 24, 1994 · UNREG · Destroyed NTSB FTW94LA276Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Tulsa, OKLoss of engine power following fuel starvation caused by improper tank selection by the pilot. A factor was the lack of suitable terrain for the forced landing.Aug 23, 1994 · N94AA · Substantial damage NTSB MIA94LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aguadilla, PRThe failure of the pilot-in-command to divert and refuel resulting in loss of engine power due to fuel exhaustion.Aug 22, 1994 · N6332P · Substantial damage NTSB ATL94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Washington, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion. A factor was the unsuitable terrain, a plowed field, available for landing.Aug 22, 1994 · N7726Z · Substantial damage NTSB SEA94LA217Accident · Minor injuriesLimited investigationFinal reportAllen D. Potts WAG-A-BOND · Benton City, WAFuel starvation and inadequate compensation for wind conditions. A factor to the accident was soft terrain.Aug 21, 1994 · N47AT · Substantial damage NTSB LAX94LA335Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Simi Valley, CAFuel exhaustion after the student pilot became lost/disoriented. Factors related to the accident were: failure of the supervising flight instructor (CFI) to follow the FAA approved syllabus, inadequate supervision by the company/operator management, darkness,…Aug 21, 1994 · N739VY · Substantial damage NTSB FTW94LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Russellville, ARVFR flight into IMC.Aug 20, 1994 · N41472 · Substantial damage NTSB MIA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-23 · San Juan, PRThe failure of the pilot-in-command to maintain directional control following loss of engine power during takeoff. Contributing to the accident was the pilot-in-commands improper aircraft preflight inspection and draining of fuel tanks and his lack of…Aug 18, 1994 · N556PR · Substantial damage