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 ATL94LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Coolidge, GAThe pilot's inadequate preflight preparation. A factor was the wet runway.Aug 18, 1994 · N9928J · Substantial damage NTSB FTW94LA267Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Pampa, TXThe pilot's decision to takeoff from unsuitable terrain following the forced landing. A factor was fuel starvation induced power loss resultant from the pilot's failure to select the proper fuel tank.Aug 11, 1994 · N9075W · Substantial damage NTSB SEA94LA207Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDFuel starvation due to the pilot-in-command's failure to verify the fuel tank selector position during the approach, and his failure to perform the published emergency procedures for an engine-out situation. A factor in the accident was a transmission wire.Aug 9, 1994 · N20818 · Substantial damage NTSB FTW94LA265Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Texarkana, TXFuel contamination and the improper adjustments made to the carburetor by unidentified maintenance personnel. A factor was the lack of suitable terrain to which a forced landing could be executed.Aug 9, 1994 · N1478S · Substantial damage NTSB CHI94LA273Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Romeoville, ILthe pilot's inadequate preflight planning/preparation and improper emergency procedure. Factors associated with the accident are the pilot's improper positioning of the fuel tank selector, and the rough, uneven terrain.Aug 9, 1994 · N3634R · Substantial damage NTSB FTW94LA264Accident · No injuriesLimited investigationFinal reportCessna A188B · Sherman, TXThe pilot's failure to refuel the airplane. A factor was the leaking fuel caps.Aug 8, 1994 · N4826R · Substantial damage NTSB CHI94LA269Accident · Serious injuriesLimited investigationFinal reportCessna 150F · East Tawas, MIinadequate prelight planning/preparation by the pilot and the subsequent inadequate fuel supply.Aug 6, 1994 · N7760F · Substantial damage NTSB ANC94LA098Accident · No injuriesLimited investigationFinal reportCessna 206 · Juneau, AKThe total loss of power for undetermined reasons. The pilot's failure to follow the prescribed procedure for the use of the auxiliary fuel boost pump switch, operating the airplane with a improperly operating switch, and the lack of suitable terrain in the…Aug 5, 1994 · N9120M · Substantial damage NTSB CHI94LA254Accident · Serious injuriesLimited investigationFinal reportBeech 33 · Wichita, KSthe pilot's inadequate management of the fuel which resulted in fuel starvation.Aug 1, 1994 · N7960M · Substantial damage NTSB CHI94FA253Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wellington, KSthe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall-spin. Factors were fuel exhaustion resulting from improper fuel calculations by the pilot.Aug 1, 1994 · N3693M · Destroyed NTSB NYC94LA142Accident · Minor injuriesLimited investigationFinal reportArthur Chase EAA Biplane · North Canaan, CTThe pilot's inadequate preflight inspection that failed to detect water contaminated fuel and which resulted in a loss of engine power. The inadequately designed fuel drain system was also a cause.Jul 31, 1994 · N35AE · Substantial damage NTSB FTW94LA255Accident · No injuriesLimited investigationFinal reportCessna 150J · Silver City, NMThe pilot's failure to refuel and the resultant loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Jul 31, 1994 · N5580G · Substantial damage NTSB LAX94LA303Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Scottsdale, AZThe pilot's failure to refuel appropriately, the altitude and airspeed at the time the engine stoppage occurred were factors in the accident.Jul 30, 1994 · N6749D · Substantial damage NTSB CHI94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Rockford, MIthe student pilot's failure to refuel the airplane prior to fuel exhaustion.Jul 30, 1994 · N84514 · Substantial damage NTSB CHI94LA257Accident · Minor injuriesLimited investigationFinal reportLattimore-Dwyer Breezy · Goshen, INfuel exhaustion which resulted from the pilot's failure to assure an adequate fuel supply for the flight.Jul 29, 1994 · N4029 · Substantial damage NTSB LAX94LA299Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAthe improper adjustment of the fuel control unit by contract maintenance personnel.Jul 27, 1994 · N3627Q · Substantial damage NTSB CHI94LA244Accident · No injuriesLimited investigationFinal reportMontana Coyote · Blaine, MNthe loss of engine power due to the blocked vent line.Jul 26, 1994 · N218LW · Substantial damage NTSB NYC94LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, METhe improper positioning of the fuel selector because of inadequate inflight decision/planning which resulted in fuel exhaustion and the loss of engine power.Jul 25, 1994 · N32925 · Substantial damage NTSB FTW94LA247Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Tyler, TXThe pilot's failure to refuel.Jul 25, 1994 · N823RH · Substantial damage NTSB NYC94LA140Accident · Serious injuriesLimited investigationFinal reportAces High Cuby B · Waterbury, CTA loss of engine power for undetermined reasons.Jul 24, 1994 · N2282Z · Substantial damage NTSB NYC94FA135Accident · 2 fatalField investigationFinal reportMooney M20C · Wallingford, CTthe pilot's decision to exhaust the fuel supply in the selected tank in-flight, and his failure to maintain the minimum stall speed during engine out conditions. This resulted in a complete loss of engine power and the inadvertent stall and impact with the…Jul 24, 1994 · N6842N · Destroyed NTSB ATL94LA144Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hephzibah, GAThe pilot's inadequate preflight of the aircraft, resulting in fuel exhaustion, and his improper flare of the helicopter during the autorotation, resulting in a hard landing.Jul 24, 1994 · N4030S · Substantial damage NTSB CHI94LA236Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Cottage Hill, ILthe pilot inadequate preflight planning/preparation and his inaccurate fuel consumption calculations.Jul 22, 1994 · N7101M · Substantial damage NTSB FTW94LA249Accident · No injuriesLimited investigationFinal reportCessna 140 · Archer City, TXFuel contamination induced power loss. Factors were the improper refueling techniques used by the pilot and the lack of suitable terrain onto which a forced landing could be executed.Jul 21, 1994 · N2260V · Substantial damage NTSB ANC94LA091Accident · No injuriesLimited investigationFinal reportCessna T207A · Haines, AKFuel starvation as a result of the pilot's improper in-flight planning/decision and his failure to follow the procedures contained in the airplane checklist for engine failure.Jul 21, 1994 · CFHOI · Substantial damage NTSB ATL94LA143Accident · No injuriesLimited investigationFinal reportCessna 182F · Raeford, NCAn engine power loss due to water in the fuel system, and the pilot's inadequate preflight of the aircraft. A factor was the presence of trees at the forced landing area.Jul 19, 1994 · N3513U · Substantial damage NTSB ATL94LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Vidalia, GAThe pilot's inadequate preflight planning, and his failure to refuel the aircraft, resulting in fuel exhaustion and engine stoppage. A factor were the trees at the forced landing area.Jul 16, 1994 · N6074G · Substantial damage NTSB CHI94LA232Accident · No injuriesLimited investigationFinal reportCessna 180 · Battle Lake, MNloss of engine power due to fuel exhaustion which resulted from inaccurate fuel consumption calculations. A factor related to the accident was the inaccurately placarded fuel tanks.Jul 15, 1994 · N333QB · Substantial damage NTSB ATL94LA138Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greenville, SCThe pilot's improper positioning of the fuel selector valve which resulted in fuel starvation.Jul 14, 1994 · N21380 · Substantial damage NTSB SEA94LA176Accident · No injuriesLimited investigationFinal reportBambrick Corben ACE · Arlington, WAFuel starvation due to the builders' inadequate design of the fuel system. Factors include high ambient temperatures during the climb, and a fence in the field where the forced landing took place.Jul 11, 1994 · CFKEZ · Substantial damage NTSB LAX94LA281Accident · Minor injuriesLimited investigationFinal reportSam Hale LONG-EZ · Camarillo, CAfuel starvation due to improper fuel management by the pilot.Jul 11, 1994 · N353H · Substantial damage NTSB LAX94LA280Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Tucson, AZAn engine power loss from fuel exhaustion due to the pilot's inaccurate fuel consumption calculations.Jul 11, 1994 · N3003S · Substantial damage NTSB ATL94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, GAThe pilot's inadequate aircraft pre-flight inspection, his failure to abort the takeoff, and his failure to maintain airspeed that resulted in a stall. A factor was the inadequate aircraft inspection that did not identify the worn fuel cell caps.Jul 11, 1994 · N3381P · Substantial damage NTSB CHI94LA225Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Grand Rapids, MIthe pilot's improper fuel tank selection resulting in fuel starvation.Jul 8, 1994 · N153C · Substantial damage NTSB CHI94LA224Accident · No injuriesLimited investigationFinal reportCessna 150 · Andover, MNthe flight instructor's improper procedures and directives by electing to pull the mixture control to the 'off' position during simulated emergency procedures. A factor associated with the accident is the existence of weather conditions conducive to…Jul 8, 1994 · N9284U · Substantial damage NTSB CHI94LA219Accident · No injuriesLimited investigationFinal reportCessna 150M · Waseca, MNinadequate preflight planning/preparation and the pilot's failure to refuel the airplane. Factors related to the accident were a poorly planned forced landing approach and high vegetation.Jul 3, 1994 · N63277 · Substantial damage NTSB NYC94LA110Accident · Minor injuriesLimited investigationFinal reportBell 47-G5 · Wareham, MAThe pilot's inadequate inflight planning which resulted in fuel exhaustion and the loss of engine power.Jul 2, 1994 · N59400 · Substantial damage NTSB CHI94LA220Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Garden City, KSfuel exhaustion for reason or reasons undetermined. A factor was the rough/uneven terrain.Jul 2, 1994 · N901JM · Substantial damage NTSB FTW94LA216Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Searcy, ARThe total loss of engine power due to water contamination of the fuel system. A factor was the lack of suitable terrain available to the pilot for the forced landing and his inadequate preflight inspection.Jun 30, 1994 · N526Y · Substantial damage NTSB FTW94LA215Accident · No injuriesLimited investigationFinal reportPiper J4A · Granite Shoals, TXFuel system starvation due to the pilot's failure to secure the engine fuel primer. A factor was the lack of suitable terrain for the forced landing.Jun 30, 1994 · N30342 · Substantial damage NTSB CHI94DTG02Accident · No injuriesFinal reportAir Tractor AT301 · Lawton, NDThe pilot's improper use of carburetor heat. The carburetor icing weather condition was a factor.Jun 29, 1994 · N4349S · Substantial damage NTSB MIA94LA163Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Bartow, FLThe pilot-in-command's failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with wires. Contributing to the accident was the total loss of engine power due to the pilot's improper fuel consumption calculations, and…Jun 21, 1994 · N9992Y · Substantial damage NTSB CHI94LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Station, INthe pilot-in-command's inattention to the fuel supply. A factor was rough and uneven terrain.Jun 21, 1994 · N4572X · Substantial damage NTSB CHI94LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lambertville, MIThe inadequate maintenance of the airplane resulting in a foreign object in the induction system.Jun 17, 1994 · N737YW · Substantial damage NTSB FTW94LA200Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Pioneer, LAFuel exhaustion due to the pilot's failure to refuel. A factor was a lack of suitable terrain for the forced landing.Jun 16, 1994 · N10112 · Substantial damage NTSB LAX94FA256Accident · 2 fatalField investigationFinal reportFouga CM 170 · Long Beach, CAA loss of power to both engines due to fuel contamination and, the pilot-in-command's failure to maintain an adequate airspeed during the subsequent emergency, which resulted in an inadvertent stall. Factors in the accident were: 1) the manufacturer's…Jun 15, 1994 · N344FM · Destroyed NTSB CHI94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Springfield, MOThe pilot's failure to refuel prior to fuel exhaustion. The lack of suitable terrain available for the forced landing is a related factor.Jun 15, 1994 · N69227 · Substantial damage NTSB CHI94FA202Accident · 2 fatalField investigationFinal reportBell 47G2 · Baldwin, ILThe inadequate maintenance (inspection of aircraft) by maintenance personnel, which resulted in a loss of engine power due to fuel exhaustion. Related factors are the unsafetied fuel filter, and low altitude at which the helicopter operated.Jun 15, 1994 · N4992G · Destroyed NTSB CHI94LA197Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Millstadt, ILthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion. Related factors are the loose fuel cap (siphoning) and the uneven terrain encountered during the forced landing.Jun 12, 1994 · N94752 · Substantial damage NTSB CHI94DET01Accident · Minor injuriesFinal reportArthur Alan Blind FOX III Speedster · Watervliet, MIa total loss of engine power due to carburetor icing.Jun 12, 1994 · N61AB · Substantial damage