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 BFO93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Manassas, VAThe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion, due to an inadequate supply of fuel.May 16, 1993 · N5416T · Substantial damage NTSB BFO93LA089Accident · Serious injuriesLimited investigationFinal reportMeador Dragonfly SP · Hamilton, OHThe pilot's inadequate inspection of the fuel filter, which resulted in subsequent loss on engine power due to fuel contamination, and his failure to maintian adequate airspeed while maneuvering to land in an open field, which resulted on an inadvertent stall.May 16, 1993 · N32T · Destroyed NTSB BFO93LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Fairmont, WVFailure of the pilots to properly clear the engine during the approach.May 15, 1993 · N16224 · Substantial damage NTSB BFO93LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Norfolk, VAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was the unsuitable terrain.May 15, 1993 · N68910 · Substantial damage NTSB FTW93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dougherty, TXFuel exhaustion power loss due to refueling not performed by the pilot. A factor was lack of suitable terrainMay 14, 1993 · N39663 · Substantial damage NTSB FTW93LA154Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Roseland, LAThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. The lack of suitable terrain for the forced landing was a factor in the accident.May 14, 1993 · N407CS · Substantial damage NTSB LAX93LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ynez, CAThe pilot's poor procedures and failure to fly to an alternate airport. Factors relating to this accident were: the pilot's lack of total experience, encounter with unfavorable winds, and the dark night.May 11, 1993 · N76284 · Substantial damage NTSB BFO93LA078Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Frederick, MDInadequate preflight by the pilot and fuel contamination, which resulted in loss of engine power.May 9, 1993 · N28681 · Substantial damage NTSB ATL93LA090Accident · No injuriesLimited investigationFinal reportRapp VAN'S RV-4 · Greenwood, SCThe loss of engine power which resulted from the formation of carburetor ice. The lack of a carburetor heat source and the carburetor icing conditions were factorsMay 9, 1993 · N743DR · Destroyed NTSB MIA93LA118Accident · No injuriesLimited investigationFinal reportCessna 172P · Mims, FLTotal loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the pilot to lean the fuel/air mixture during cruise flight which increased the fuel consumption for the flight.May 8, 1993 · N63012 · Substantial damage NTSB CHI93FA161Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paoli, INThe pilot-in-command's inadequate preflight preparations and his failure to maintain airspeed. Factors were the instructor's inadequate training of the pilot-in-command, unqualified maintenance personnel's inadequate inspection of the aircraft and the…May 5, 1993 · N2487T · Destroyed NTSB MIA93LA116Accident · No injuriesLimited investigationFinal reportBeech A23A · Fort Myers, FLTotal loss of engine power due to fuel exhaustion and poor preflight planning/preparation by the pilot in command. Contributing to the accident was the pilot's failure to request winds aloft during the weather briefing.May 4, 1993 · N2312W · Substantial damage NTSB ATL93LA087Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Apex, NCThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.May 4, 1993 · N761CQ · Substantial damage NTSB LAX93FA202Accident · 1 fatalField investigationFinal reportCessna 175 · Jackson, CAA failure of the pilot to adequately calculate the required fuel for the flight and the pilot's continued visual flight into instrument meteorological conditions. The failure of the non-instrument rated pilot to obtain a weather briefing, and adequately…May 3, 1993 · N9494B · Destroyed NTSB MIA93LA114Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Fort Lauderdale, FLThe pilot-in-command's failure to insure the aircraft contained adequate fuel to complete the flight, which resulted in loss of power in both engines due to fuel exhaustion.May 2, 1993 · N7656Q · Destroyed NTSB LAX93LA196Accident · No injuriesLimited investigationFinal reportDornier DO-28 · Paradise, CAThe poor in flight fuel consumption calculations by the pilot and the pilot's in flight decision not to switch fuel tanks which caused the total failure of both of the airplane's engines. Factors relating to this accident were fuel starvation and the high…May 2, 1993 · N12828 · Destroyed NTSB CHI93LA156Accident · No injuriesLimited investigationFinal reportBrantly-Hynes B2B · Greencastle, INContamination of the fuel system by particulate matter of an unknown origin.May 1, 1993 · N2257U · Substantial damage NTSB BFO93LA064Accident · No injuriesLimited investigationFinal reportBeech E18S · Xenia, OHInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.May 1, 1993 · N665M · Substantial damage NTSB CHI93FA149Accident · 2 fatalField investigationFinal reportCessna 421B · Valley Park, MOImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and the pilot's failure to maintain control of the airplane during approach to an emergency landing. A related factor was: failure of the pilot to…Apr 29, 1993 · N4939M · Destroyed NTSB ATL93LA084Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamilton, ALThe pilot's failure to properly calculate fuel consumption at an increased power setting, which resulted in fuel exhaustion and loss of engine power. Trees at the forced landing area were a factor in the accident.Apr 29, 1993 · N9696 · Destroyed NTSB SEA93FA102Accident · 1 fatalField investigationFinal reportCessna 172C · Darrington, WAFuel exhaustion and the pilot in command's inadequate refueling of the aircraft.Apr 25, 1993 · N1406Y · Destroyed NTSB CHI93LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Lake Village, INThe pilot in command's inadequate preflight planning.Apr 25, 1993 · N4559U · Substantial damage NTSB NYC93LA089Accident · No injuriesLimited investigationFinal reportBoeing E75 · Zanesville, OHImproper use of the throttle by the pilot.Apr 23, 1993 · N181RF · Substantial damage NTSB SEA93LA100Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pendleton, ORFuel exhaustion due to the pilot's failure to refuel. Factors contributing to the accident were the pilot's becoming lost/disoriented and soft terrain.Apr 22, 1993 · N3163X · Substantial damage NTSB MIA93LA107Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Starkville, MSThe pilot-in-command's failure to refuel the airplane, resulting in a total loss of engine power due to fuel exhaustion, resulting in a forced landing and in-flight collision with trees and terrain.Apr 21, 1993 · N7985Q · Substantial damage NTSB NYC93LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Melville, NYThe pilot's improper inflight planning and decision, which resulted in fuel exhaustion and the subsequent forced landing.Apr 19, 1993 · N601MS · Substantial damage NTSB FTW93LA134Accident · No injuriesLimited investigationFinal reportCessna 150F · Garrison, TXThe student pilot's failure to refuel the airplane. A factor was his becoming lostApr 18, 1993 · N8979S · Substantial damage NTSB LAX93LA180Accident · No injuriesLimited investigationFinal reportBeech B24R · Aguila, AZThe loss of engine power due to fuel starvation. The fuel starvation was caused by the pilot's failure to select a tank containing fuel and the intermittent operation of the electric boost pump due to a faulty cockpit switch. A factor in the accident was the…Apr 17, 1993 · N9203S · Substantial damage NTSB SEA93LA096Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Laurel, MTThe loss of engine power from fuel exhaustion due to the pilot's failure to ensure an adequate supply of fuel for the flt.Apr 15, 1993 · N9605Y · Substantial damage NTSB FTW93LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Houston, TXFuel exhaustion induced power loss and the pilot's failure to refuel. A factor was the existing night conditionsApr 13, 1993 · N6099G · Substantial damage NTSB CHI93IA140Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-ATP · Oshkosh, WIan inoperative engine nacelle anti-ice system, and ice ingestion.Apr 11, 1993 · N855AW · No damage NTSB NYC93LA078Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Durham, NHImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power. Factors related to the accident were flight into adverse weather conditions, failure to obtain inflight weather information, and pilot fatigue.Apr 10, 1993 · N8228G · Substantial damage NTSB LAX93LA169Accident · Serious injuriesLimited investigationFinal reportAero Commander 112 · Camarillo, CAThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion. Factors related to the accident were: improper preflight planning/preparation, inadequate fuel supply, refueling stop not performed, and no suitable terrain found in the…Apr 9, 1993 · N1024J · Destroyed NTSB ATL93LA070Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Augusta, GAThe pilot's improper fuel management, which resulted in fuel starvation and engine stoppage.Apr 7, 1993 · N29AP · Destroyed NTSB CHI93LA136Accident · No injuriesLimited investigationFinal reportCessna T210 · Philadelphia, ILThe pilot's failure to ensure an adequate fuel supply to complete the flight.Apr 6, 1993 · N6471N · Substantial damage NTSB NYC93LA069Accident · Minor injuriesLimited investigationFinal reportBeech E-55 · Leesburg, VAImproper use of the fuel selectors, which resulted in fuel starvation and loss of power in both engines. Darkness was a related factor.Apr 5, 1993 · N777EV · Substantial damage NTSB LAX93LA164Accident · No injuriesLimited investigationFinal reportRoy Rey Avid Flyer · Wasco, CACarburetor icing. Factors relating to the accident were the lack of a carburetor heat control system and the freshly plowed field.Apr 5, 1993 · N827H · Substantial damage NTSB FTW93LA112Accident · No injuriesLimited investigationFinal reportCessna 150C · El Paso, TXThe fuel exhaustion induced power loss and the failure of the pilot to refuel. A factor was the lack of suitable terrain.Mar 27, 1993 · N2015Z · Substantial damage NTSB CHI93LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Marysville, INThe pilot's failure to use carburetor heat while flying in carburetor icing conditions.Mar 27, 1993 · N3439Z · Substantial damage NTSB LAX93LA158Accident · Serious injuriesLimited investigationFinal reportBoeing A75L3 · Carlsbad, CAThe pilot's inadequate preflight preparation in that he failed to refuel the aircraft prior to departure.Mar 22, 1993 · N58969 · Substantial damage NTSB FTW93LA109Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Plainview, TXThe pilot's the improper flare prior to touchdown. Factors were the fuel starvation power loss and improper positioning of the fuel selector.Mar 20, 1993 · N4045B · Substantial damage NTSB LAX93LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Vacaville, CAa loss of engine power for undetermined reason(s).Mar 16, 1993 · N8120H · Destroyed NTSB MIA93LA085Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Pierce, FLInaccurate fuel consumption calculations, resulting in fuel exhaustion.Mar 15, 1993 · N6168K · Substantial damage NTSB DEN93FA032Accident · 2 fatalField investigationFinal reportBeech A36 · Englewood, COPower loss due to fuel exhaustion as a result of failing to refuel en route. Factors were: inaccurate fuel consumption calculations, lack of suitable terrain for a forced landing, lack of total experience in the type of aircraft being flown, and becoming lost…Mar 13, 1993 · N4495W · Substantial damage NTSB CHI93LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Hastings, NEThe pilot's failure to refuel the airplane en route which resulted in an inadequate fuel supply for the flight.Mar 13, 1993 · N50467 · Substantial damage NTSB CHI93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bismarck, NDThe pilot's failure to refuel the airplane en route to ensure adequate fuel to complete the flight.Mar 11, 1993 · N88384 · Substantial damage NTSB FTW93LA097Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Plano, TXFuel starvation induced power loss resultant from failure of the pilot to switch the fuel selector to the proper fuel tank. Factors were the dark night conditions and lack of suitable terrain for a forced landingMar 7, 1993 · N6088S · Substantial damage NTSB BFO93LA044Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Putnam, CTInadequate compliance with applicable air worthiness directives, leaky fuel cap seal, water contamination of the fuel, and wrinkles in the fuel tank bladders that interfered with the ability to drain water from the tanks.Mar 7, 1993 · N3035F · Substantial damage NTSB MIA93LA080Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Marco, FLThe pilot-in-command's failure to ensure the aircraft contained adequate fuel for the flight, resulting in loss of engine power due to fuel exhaustion.Mar 5, 1993 · N29WW · Substantial damage NTSB FTW93LA095Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Midlothian, TXThe loss of engine power and the pilot's failure to refuel. A factor was the inadvertent stall during the flare touchdownMar 5, 1993 · N800VT · Substantial damage