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 CHI96LA333Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Chicago, ILthe pilot's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's improper flare during the forced landing.NTSB ANC96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe fuel starvation caused by the unporting of the right fuel tank, and the pilot's inadequate preflight by not dipping the fuel tank to ensure sufficient fuel quantity to prevent the unporting.NTSB FTW96LA363Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKthe student pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the student's lack of experience in this make and model of aircraft, darkness, and lack…NTSB NYC96LA176Accident · Serious injuriesLimited investigationFinal reportTemco D-16A · Hainesport, NJthe pilot's improper inflight planning/decision and inadequate management of fuel, which resulted in fuel exhaustion and the loss of engine power.NTSB SEA96LA204Accident · No injuriesLimited investigationFinal reportPrice Acro Sport II · Coeur D'Alene, IDthe pilot's improper inflight planning/decision, and his failure to properly monitor (manage) the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing. Soft terrain in the forced landing area was a related factor.NTSB IAD96FA138Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Whitefield, NHthe pilot's failure to adequately preflight the aircraft which led to the loss of engine power due to fuel exhaustion, and the pilot's attempt to return to the airport by executing a steep left turn which led to a stall and subsequent loss of control of the…NTSB CHI96FA316Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hartford, MIinaccurate fuel consumption calculations by the pilot before takeoff, and his improper decision not to land before his airplane ran out of fuel.NTSB CHI96FA309Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Crystal Lake, ILthe pilot's inadequate fuel management and which resulted in fuel system exhaustion. The factors involved were the pilot's failure to refuel, inadequate preflight planning/preparation and the dark night conditions encountered.NTSB CHI96LA296Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB CHI96LA285Accident · No injuriesLimited investigationFinal reportRamesbotham CH701 · N. Sioux City, SDthe pilot's delay in switching fuel tanks which resulted in fuel starvation. Factors associated with the accident were the low altitude at which the loss of engine power occurred and the powerline which was contacted.NTSB LAX96LA303Accident · No injuriesLimited investigationFinal reportCessna 182B · Santa Ana, CAImproper fuel management by the pilot resulting in exhaustion of the aircraft's fuel supply.NTSB IAD96LA131Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Greenfld Twnshp, PAloss of engine power for undetermined reason(s). A high obstruction in the forced landing area was a related factor.NTSB MIA96LA211Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Farmville, NCThe pilot's inadequate fuel consumption calculations which resulted in loss of engine power do to fuel exhaustion and a hard landing during a forced landing in a field.NTSB LAX96LA302Accident · No injuriesLimited investigationFinal reportBeech B23 · Modesto, CAfuel starvation due to the pilot's inadequate fuel management and failure to reposition the fuel selector to a tank containing adequate fuel. The power lines were a factor.NTSB FTW96LA345Accident · No injuriesLimited investigationFinal reportCessna 210-5 · Muskogee, OKloss of engine power due to fuel contamination. The lack of suitable terrain for a forced landing was a related factor.NTSB CHI96LA276Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Flushing, MIfuel exhaustion caused by the failure of the pilot to select a fuel tank with fuel remaining.NTSB MIA96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Live Oak, FLfailure of the pilot to use carburetor heat during the approach to land, which resulted in loss of engine power due to carburetor ice. The weather (carburetor icing condition) was a related factor.NTSB CHI96LA271Accident · No injuriesLimited investigationFinal reportCessna 150 · Wisconsin Rapid, WIfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel management.NTSB CHI96LA267Accident · No injuriesLimited investigationFinal reportYakovlev YAK-3UA · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.NTSB MIA96LA198Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Sarasota, FLthe pilot's inadequate preflight inspection of the fuel tanks resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB NYC96LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Castine, MEthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Factors relating to the accident were: false indication from the fuel quantity gauge, and soft terrain in the emergency…NTSB SEA96LA172Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dubois, IDfailure of the pilot to remain clear of an irrigation spray device, which resulted in inadvertent water ingestion and flameout of the aircraft's turboprop engine. Factors relating to the accident were: the proximity of the irrigation spray device (close to…NTSB FTW96LA323Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Moriarity, NMloss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW96LA326Accident · No injuriesLimited investigationFinal reportRockwell International S2R · Tahlequah, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA316Accident · 2 fatalLimited investigationFinal reportKraft AIR Master · Katy, TXthe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation, loss of engine power, and a forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA315Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Mount Holly, ARFuel exhaustion due to the pilot's failure to refuel the helicopter. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA288Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Weed, CAThe pilot's improper fuel management. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA287Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Lost Hills, CAimproper installation of the carburetor air box.NTSB LAX96LA286Accident · Serious injuriesLimited investigationFinal reportBeech J-35 · Lovelock, NVfuel starvation.NTSB SEA96LA161Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Sunnyside, WAinadequate preflight by the pilot, and subsequent fuel exhaustion. Factors relating to the accident were: darkness, and high vegetation (brush and small trees) in the emergency landing area.NTSB MIA96LA193Accident · No injuriesLimited investigationFinal reportCessna 210L · Fort Myers, FLfailure of the pilot (PIC) to ensure that an adequate preflight inspection was performed; a missing (or loose) fuel cap on the left wing; probable fuel siphoning; and fuel exhaustion, which resulted in a loss of engine power and a subsequent forced landing…NTSB LAX96LA285Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA-20-A1 · Vacaville, CAimproper planning/decision by the instructor pilot, which resulted in subsequent fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.NTSB LAX96LA282Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Page, AZdecision of the pilot to operate the airplane with an inoperative transfer pump and inaccurate fuel consumption calculations.NTSB LAX96LA281Accident · No injuriesLimited investigationFinal reportGraham Falcon XP · Mesa, AZblockage of the fuel system vent in the fuel cap, when the pilot overtorqued the fuel cap during his preflight check, which restricted fuel flow to the engine. The pilot's lack of experience in the make and model of airplane was a related factor.NTSB FTW96LA328Accident · No injuriesLimited investigationFinal reportCessna T210L · Santa Fe, NMthe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in fuel starvation before reaching the airport. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA250Accident · Minor injuriesLimited investigationFinal reportPoppenhagen PUD Knocker Special · Grafton, NDthe inadequate fuel system design by the builder which led to fuel starvation.NTSB LAX96LA276Accident · No injuriesLimited investigationFinal reportCessna A188B · Merced, CAFuel exhaustion due to the pilot's inadequate preflight inspection and his failure to ensure that adequate fuel was onboard to complete the flight.NTSB MIA96LA188Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, ALfuel contamination, which resulted in loss of engine power, a forced landing, and impact with trees. A factor relating to the accident was: inadequate maintenance and/or inspection after the previous loss of engine power and forced landing.NTSB MIA96LA187Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · St Petersburg, FLa loss of engine power due to fuel contamination, which resulted in a forced landing (ditching) in water. Factors relating to the accident were: an inadquate annual inspection by maintenance personnel, and an inadequate preflight inspection by the pilot.NTSB ATL96LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gatesville, NCThe pilot's inadequate preflight inspection which resulted in engine stoppage due to water contamination in the fuel system. A factor was the lack of suitable terrain for a forced landing.NTSB LAX96LA273Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Pacoima, CAa total loss of engine power for undetermined reasons.NTSB FTW96LA305Accident · No injuriesLimited investigationFinal reportStol UC-1 · Princeton, TXimproper adjustment of the left propeller governor which resulted in uncommanded feathering of the left propeller. Factors were: the airplane's inadequate engine out performance and the lack of suitable terrain for the forced landing.NTSB FTW96LA304Accident · No injuriesLimited investigationFinal reportBeech 76 · Falcon, COA loss of engine power due to the pilot's inaccurate fuel consumption calculation, and his failure to properly identify the area of intended landing as an airport. A factor was the misrouting of the fuel line by unknown persons.NTSB SEA96LA154Accident · Minor injuriesLimited investigationFinal reportColonial C-1 · Halls Crossing, UTthe pilot's inadequate preflight of the airplane, and subsequent fuel exhaustion due to an inadequate supply of fuel, which resulted in loss of engine power and an emergency landing. Uneven terrain in the emergency landing area was a related factor.NTSB FTW96LA302Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Rogers, ARfuel exhaustion due to the pilot's failure to refuel. Factors were the below landing minimums weather conditions and the lack of suitable terrain for the forced landing.NTSB NYC96LA147Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Rockaway, NJThe pilot's impairment of judgment and performance due to alcohol which led to his inadequate preflight of the aircraft and his inadequate inflight decision which resulted in fuel exhaustion and loss of engine power.NTSB FTW96LA299Accident · No injuriesLimited investigationFinal reportBell 206B · Matagorda, TXThe loss of engine power due to fuel system contamination. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB IAD96LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Vincent, OHthe instructor's inadequate supervision by allowing the student and himself to become lost, his inadequate inflight planning/decision by failing to ensure the airplane was safely landed before fuel was exhausted, and his selection of unsuitable terrain for a…NTSB LAX96LA266Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Chino, CAFuel starvation due to the pilot's failure to monitor and correctly configure the fuel system for landing prior to entering the traffic pattern, and the pilot's premature lowering of full flaps which led to the runway undershoot. A factor in the accident was…NTSB LAX96LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lanai, HIFuel exhaustion due to the pilot's inadequate fuel planning and failure to refuel the aircraft prior to initiating a 280-mile over water nonstop leg of the flight.