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 LAX92LA113Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZFuel exhaustion due to the instructor pilot's failure to refuel the aircraft.NTSB CHI92LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe pilot's improper use of carburetor heat. An associated factor is weather conducive to carburetor icing.NTSB FTW92LA063Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Canyon Lake, TXThe pilot's failure to properly monitor his fuel consumption and his failure to divert to an alternate airport prior to running out of gas.NTSB BFO92LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · East Taunton, MAInadequate preflight by the dual student and inadequate supervision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB LAX92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Tonopah, NVThe pilot's failure to assure that there was an adequate supply of fuel in the airplane to complete the flight due to alcoholic impairment of efficiency and judgement resulting in a total loss of power of both engines.NTSB FTW92LA060Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe pilot in command failed to properly monitor the fuel consumption rate of the airplane when he perceived that it might be higher than normal. The engine failure was a result of fuel exhaustion, aggravated by possible fuel siphoning from the tanks.NTSB MIA92IA065Incident · No injuriesIncident investigationFinal reportBoeing 757-23APF · Miami, FLThe pilot-in-command's improper supervision of the co-pilot/first officer. This resulted in a total loss of engine power on both engines while at low power settings in known icing conditions for failure to follow checklist procedures.NTSB LAX92LA097Accident · No injuriesLimited investigationFinal reportCessna 120 · Sonoma, CAEngine failure due to a binding mixture control shaft. The binding mixture control shaft was the result of inadequate maintenance which allowed the accumulation of moisture and water in the carburetor to remain for an extended period of time causing rust and…NTSB ATL92FA040Accident · 2 fatalField investigationFinal reportCessna 140 · Columbia, SCThe pilot-in-command's failure to assure that an adequate supply of fuel was on board the airplane for the intended flight, and his failure to maintain adequate airspeed during the forced landing resulting in a stall/spin. A factor contributing to the…NTSB SEA92LA037Accident · No injuriesLimited investigationFinal reportCessna 150L · Tacoma, WAThe pilot's improper use of remedial action when he encountered carburetor icing. Factors include carburetor ice and carburetor icing conditions.NTSB LAX92LA084Accident · No injuriesLimited investigationFinal reportCessna 172H · Arcata, CACarburetor icing and the failure of the pilot to use carburetor heat.NTSB MIA92LA056Accident · Minor injuriesLimited investigationFinal reportAero Commander 560E · Boca Raton, FLImproper fuel tank selector position of both engines resulting in total loss of engine power due to fuel starvation. Also, failure of the pilot to perform the emergency procedures following the loss of power from both engines.NTSB LAX92LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Altadena, CAThe pilot's improper use of the fuel selector by selecting an empty tank. Contributing to the accident was the pilot's decision to operate the airplane with a known deficiency without having maintenance performed to determine the cause of a previous loss of…NTSB MIA92LA054Accident · 1 fatalLimited investigationFinal reportSmith/Davis DA-2A · Holly Springs, MSThe pilot-in-command's improper management of fuel. This resulted in the airplane experiencing fuel exhaustion, forced landing, and in flight collision with terrain.NTSB DEN92LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Falcon, COEngine failure over unsuitable terrain due to fuel exhaustion. Factors were: pilot inexperience and becoming lost and disoriented.NTSB NYC92LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Stratford, CTWater/ice in the fuel system, which resulted in fuel starvation and a loss of engine power. Factors related to the accident were: freezing temperatures and inadequate pre-flight preparation by the pilot.NTSB MIA92LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Fayetteville, NCThe pilot-in-command's failure to perform an adequate preflight in that he failed to assure adequate fuel for the flight was available. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA92LA050Accident · No injuriesLimited investigationFinal reportMooney M-20C · Plant City, FLTotal loss of engine power (nonmechanical) for undetermined reasons. This resulted in a forced landing to an unsuitable landing area and collision with terrain.NTSB LAX92LA068Accident · No injuriesLimited investigationFinal reportCessna 210K · Watsonville, CAThe pilot's inadequate fuel calculation and failure to service the airplane's fuel tanks with adequate quantities of fuel to compete the fights. The loss of engine power resulting from fuel exhaustion was a factor in the accident.NTSB ANC92LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kenai, AKEngine failure due to fuel contamination. Contributing to the accident was unsuitable terrain.NTSB MIA92LA048Accident · Serious injuriesLimited investigationFinal reportPiper J-4E · Timmonsville, SCTotal loss of engine power (nonmechanical) due to inadequate fuel consumption calculation by the pilot-in-command, resulting in an engine failure due to fuel exhaustion, a forced landing, and in-flight collision with terrain.NTSB FTW92LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXThe pilot's selection of unsuitable terrain. Factors were the fuel starvation and the tough terrain.NTSB MIA92LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Hollywood, FLTotal loss of engine power during the initial climb due to fuel starvation as a result of the pilot's failure to perform an adequate preflight to determine the quantity of fuel on board.NTSB CHI92LA058Accident · No injuriesLimited investigationFinal reportCessna 150 · Charlestown, INFuel exhaustion. Factors related to the accident were inadequate maintenance of the airplane and the pilot's decision to fly an airplane with known mechanical deficiencies.NTSB NYC92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Orford, NHThe student pilot became lost and disoriented.NTSB CHI92FA053Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Berrien Springs, MIThe pilot-in-command's (cfi's) poor in-flight planning/decision-making and misjudged fuel supply/consumption. A related factor is overconfidence in personal ability.NTSB FTW92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Houston, TXThe pilot's failure to correctly calculate fuel consumption and the loss of engine power. A factor was the unsuitable terrain.NTSB FTW92FA035Accident · Serious injuriesField investigationFinal reportCessna U206G · Pasadena, TXFuel starvation due to the pilots' improper boost pump procedure. Factors were pilots' failure to follow checklist, dark night, and unsuitable terrain.NTSB CHI92LA047Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mt Pleasant, MIWater in the fuel, and an inadequate preflight by the pilot.NTSB NYC92LA039Accident · No injuriesLimited investigationFinal reportCessna 182 · Westerly, RIThe failure of the pilot to remove all the water from the fuel system prior to takeoff which resulted in a power loss.NTSB FTW92LA031Accident · No injuriesLimited investigationFinal reportCessna 210 · Groves, TXFuel exhaustion which precipitated the forced landing due to the pilot's inadequate fuel consumption calculations. A factor in the accident was the pilot's failure to divert to an alternate destination when he recognized that fuel exhaustion was a possibility.NTSB BFO92FA011Accident · Serious injuriesField investigationFinal reportPiper PA-24-180 · Sandston, VAThe loss of engine power due to fuel exhaustion and the pilots selection of unsuitable terrain for the force landing. A factor was the pilot's improper inflight decision.NTSB SEA92FA024Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Everett, WAFuel starvation due to improper procedures by the pilot-in-command. Factors include lack of familiarity with the aircraft, non-functioning flight compartment lights, and non-suitable terrain.NTSB MIA92LA036Accident · No injuriesLimited investigationFinal reportCessna 210M · Zephyrhills, FLImproper placement of the fuel selector by the pilot-in-command resulting in the total loss of engine power due to fuel starvation. Contributing to the accident was an incorrect fuel quantity gage, the dark night condition, and unsuitable terrain encountered.NTSB NYC92LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's improper preflight and planning which resulted in fuel system exhaustion and a forced landing on unsuitable terrain. A factor related to the accident was the pilot's lack of total experience.NTSB LAX92LA059Accident · No injuriesLimited investigationFinal reportCessna 182H · Tucson, AZFuel exhaustion due to the pilot's inadequate preflight inspection, her failure to ensure that an adequate fuel supply was onboard and her decision not to refuel the aircraft prior to departure. Factors in the accident were: 1) the inoperative left fuel gage;…NTSB LAX92LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Saipan, SarkA loss of engine power due to carburetor icing and the failure of the pilot to correctly use carburetor heat.NTSB ATL92FA026Accident · Minor injuriesField investigationFinal reportCessna 210H · Carrollton, GAThe contamination of the aircraft fuel system with ice and water, which was undetectable by the pilot.NTSB SEA92LA023Accident · No injuriesLimited investigationFinal reportKitfox Ten Model 2 · West Jordan, UTThe loss of engine power when it overheated due to low coolant level, which resulted from the inadequate preflight inspection by the pilot. A factor relating to the accident was the obstruction in the landing area.NTSB NYC92LA034Accident · Minor injuriesLimited investigationFinal reportRyan 260-B · Barre, MAA total loss of engine power in cruise flight due to fuel starvation resulting in a forced landing and collapse of the landing gear during the landing roll. A factor related to the accident was a leaking fuel selector valve.NTSB SEA92LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ontario, ORCarburetor icing and the pilot's failure to use carburetor heat. A factor contributing to the accident was the transmission wires.NTSB NYC92LA032Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenskill, NYThe pilot's improper use of carburator heat, resulting in carburator ice and a loss of engine power and subsequent forced landing on unsuitable terrain.NTSB NYC92FA029Accident · 5 fatalField investigationFinal reportCessna 340 · Columbus, OHThe pilot's improper execution of an emergency procedure, after an engine failure, which resulted in the loss of airplane control. Factors related to the accident were: the pilot's improper management of the fuel system; the pilot's lack of proficiency in…NTSB CHI92LA024Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Burlington, IAThe pilot having an improper fuel tank selector position.NTSB CHI92FA023Accident · 1 fatalField investigationFinal reportCessna 150K · Kiowa, KSThe pilot-in-command's failure to properly utilize the carburetor heat to avoid loss of engine power due to carburetor icing. Factors contributing to the accident were the pilot-in-command's inattention and the encounter of unsuitable terrain during an…NTSB ATL92LA021Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Wilson, NCThe intentional operation of the aircraft with a known deficiency and inadequate preflight inspection by the pilot.NTSB NYC92LA024Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Jim Thorpe, PAThe pilot's improper use of carburetor heat, resulting in carburetor ice and a loss of engine power and subsequent forced landing in trees. A factor related to the accident was the pilot's lack of experience in this make and model airplane.NTSB LAX92LA028Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pauma, CAFuel starvation due to a restricted fuel tank vent line. Contributing to the accident was inadequate maintenance.NTSB FTW92LA019Accident · No injuriesLimited investigationFinal reportCessna 150J · Hatch, NMFuel exhaustion as a result of the pilot's failure to refuel and his poor preflight and inflight planning. Factors were the unsuitable mountainous terrain at the pilot's disposal and the unfavorable winds aloft.NTSB BFO92LA004Accident · No injuriesLimited investigationFinal reportCessna T210N · Wheeling, WVThe engine failure caused by fuel starvation and the pilot's improper fuel management.