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 LAX96LA173Accident · No injuriesLimited investigationFinal reportCessna 150K · Mojave, CAthe pilot's failure to clear the engine during an idle power descent, as required by the engine manual.NTSB MIA96FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Kissimmee, FLthe pilot's improper planning/decision, which resulted in fuel starvation and a forced landing in a residential area. A factor relating to the accident was: the inaccuracy of the expected fuel consumption.NTSB LAX96LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Santa Paula, CAfuel starvation due to the pilot's failure to monitor fuel tank quantities and to assure that the fuel tank selector was positioned to a tank containing adequate fuel.NTSB CHI96LA129Accident · Minor injuriesLimited investigationFinal reportCessna T310Q · Minneapolis, MNthe inadequate fuel supply for the intended flight which resulted in fuel exhaustion. Factors related to the accident were the pilot operating the airplane with an inoperative fuel gauge and the embankment which the airplane traveled down during the forced…NTSB CHI96LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sikeston, MOThe pilot's delay in applying carburetor heat, which resulted in carburetor icing and subsequent loss of engine power. Factors relating to the accident were: carburetor icing (weather) conditions, and the pilot's lack of recent experience in the make and…NTSB NYC96FA084Accident · 1 fatalField investigationFinal reportPitts S-2B · Freehold Twsp, NJthe pilot's improper fuel management which resulted in a power loss due to fuel exhaustion, and his failure to maintain airspeed during a forced landing which resulted in an inadvertent stall.NTSB ANC96LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKfuel starvation due to unporting of the fuel tank inlet, and the pilot's use of a steep, nose-low attitude during descent on the approach to land. The low level of fuel remaining was a related factor.NTSB IAD96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Roanoke, VAthe pilot's misjudged estimation of the airplane's fuel supply for the flight. Related factors are the inadequate preflight inspection, the pilot's expectation that the airplane had been topped off, and the soft terrain encountered during the forced landing.NTSB NYC96LA080Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Old Bridge, NJfuel contamination, due to improper servicing of the aircraft, which resulted in fuel starvation, loss of engine power, a forced landing, and collision with a tree. The strong surface wind was a related factor.NTSB ATL96LA075Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Bunnell, FLThe pilot's failure to obtain a preflight weather briefing and his failure to apply carburetor heat that resulted in a loss of engine power. A factor was weather conditions were favorable for the formation of carburetor icing at cruise flight.NTSB LAX96LA151Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sacramento, CAA loss of engine power due to carburetor ice and the student's failure to use carburetor heat. The carburetor icing (weather) condition was a related factor.NTSB NYC96LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Groton, NYthe pilot's inadequate fuel management, and his improper use of the fuel selector valve, which resulted in fuel starvation and the subsequent collision with bails of hay during the forced landing.NTSB LAX96LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAinadequate preflight by the pilot, and subsequent fuel exhaustion, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related factors.NTSB NYC96FA078Accident · 1 fatalField investigationFinal reportCessna 150J · Warwick, NYthe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion. A related factor was the pilot's lack of recent experience.NTSB LAX96LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Upland, CAfuel system contamination and the pilot's intentional operation of a known unairworthy aircraft.NTSB ATL96LA067Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Kingston, TNThe pilot's inadequate pre-flight inspection, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW96LA149Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Killeen, TXThe pilot's improper planning/decision, which resulted in fuel exhaustion and a loss of engine power, due to an inadequate supply of fuel. A factor relating to the accident was: lack of suitable terrain for an emergency landing (autorotation).NTSB CHI96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Paul, MNthe pilot's failure to assure an adequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the signs contacted by the airplane during the forced landing.NTSB LAX96LA133Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Grass Valley, CAfuel starvation for an undetermined reason.NTSB NYC96LA074Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Shirley, MEthe pilot's fuel mismanagement and improper use of the fuel selector valve which resulted in fuel starvation.NTSB FTW96LA144Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Clinton, LAthe pilot's improper positioning of the fuel selector which resulted in fuel starvation. Factors were the dark night light condition and the worn spark plugs.NTSB ATL96LA062Accident · No injuriesLimited investigationFinal reportCessna 152U · Rincon, GAInaccurate fuel consumption calculations by the pilot, and an inadequate supply of fuel, which resulted in fuel exhaustion and subsequent nose over of the airplane, during a forced landing on uneven terrain with high vegetation (small trees).NTSB FTW96LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Gladewater, TXfuel starvation due to the pilot inadvertently turning the fuel selector to the OFF position. A factor was the lack of suitable terrain for the forced landing.NTSB ATL96LA060Accident · No injuriesLimited investigationFinal reportCessna 172D · Macon, GAThe pilot's improper planning/decision, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB CHI96FA099Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas 369E · Manhattan, KSImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: pressure to meet a work schedule.NTSB NYC96LA066Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Linden, NJthe pilot's inadequate preflight and failure to follow the checklist to ensure that the fuel selector valve was in the ON position, which resulted in fuel starvation and subsequent loss of engine power. In addition, the pilot failed to maintain airspeed…NTSB CHI96LA096Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Bourbon, INWater contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.NTSB LAX96FA119Accident · 1 fatalField investigationFinal reportBeech C35 · Lee Vining, CAFuel starvation due to the pilot's failure to adequate monitor the aircraft's fuel system and select a tank containing fuel in a timely manner. The pilot's failure to monitor the fuel system was due to the effects of hypoxia. Factors in the accident were the…NTSB LAX96LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Raymond, CAThe pilot's failure to verify the quantity of fuel onboard the aircraft prior to departure, which resulted in fuel exhaustion.NTSB IAD96LA043Accident · No injuriesLimited investigationFinal reportCessna 177A · Sidney, OHfuel contamination, and the pilot's inadequate preflight inspection, which resulted in subsequent loss of engine power during cruise flight. A factor relating to the accident was: rough terrain in the emergency landing area.NTSB FTW96LA122Accident · No injuriesLimited investigationFinal reportCessna 182P · New Orleans, LAThe pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.NTSB ATL96FA049Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Johns Island, SCthe pilot's inadequate evaluation of the weather conditions and the continued flight into icing conditions which resulted in the loss of engine power. A factor was conditions favorable for the formation of carburetor icing.NTSB FTW96LA139Accident · No injuriesLimited investigationFinal reportRockwell 500U · Hampton, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB LAX96LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Oroville, CAthe failure of the pilot to use carburetor heat, which resulted in loss of engine power due to carburetor ice. The carburetor icing (weather) condition was a related factor.NTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96FA073Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Hallam, NEimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Darkness was a related factor.NTSB MIA96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lake City, FLFailure of the pilot to select a fuel tank with adequate fuel for takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb, and improper flare by the pilot during the subsequent forced land.NTSB ATL96LA034Accident · No injuriesLimited investigationFinal reportCessna 150L · Sun City, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion. Darkness was a related factor.NTSB BFO96LA036Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Louisville, KYthe pilot's misjudgment of the fuel supply, which resulted in a loss of engine power due to fuel exhaustion during final approach to the destination airport. Factors relating to the accident were: terrain conditions and vehicles in the emergency landing area.NTSB FTW96FA085Accident · 1 fatalField investigationFinal reportSemple Smyth Sidewinder · Oklahoma City, OKThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power, and his failure to maintain sufficient airspeed while coping with the emergency, which resulted in and inadvertent stall and subsequent spin.…NTSB ATL96LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Gulfport, MSinadequate preflight planning/preparation by the pilot, and inadequate supply of fuel in the airplane, which resulted in fuel exhaustion and subsequent ditching at sea.NTSB SEA96FA039Accident · Minor injuriesField investigationFinal reportConvair 340 · Spokane, WAthe pilot's improper management of the fuel/system, which resulted in loss of power in both engines, due to fuel starvation. Factors relating to the accident were: false indications of the cockpit fuel gauges, darkness, and the presence of a berm in the…NTSB NYC96LA048Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Silver Spring, PAA loss of engine power as a result of fuel exhaustion.NTSB BFO96LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, OHthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and a loss of engine power due to an inadequate supply of fuel. Factors relating to the accident were: false fuel quantity indication from the left fuel quantity gauge,…NTSB FTW96LA079Accident · No injuriesLimited investigationFinal reportMeyers MY-200A · Madill, OKthe deterioration of the fuel supply line resulting in line blockage, fuel starvation, and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96IA059Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Saint Louis, MOloss of induction air into the engine inlets resulting in simultaneous loss of power on both engines. Factors relating to this incident were: disconnection of the airplane's hydraulic pumps and generators, slush on the runway and the hydroplaning condition.NTSB FTW96FA072Accident · 2 fatalField investigationFinal reportBeech 35 · Kremmling, COa loss of engine power due to fuel starvation as a result of the student pilot's improper positioning of the fuel selector and the the CFI's inadequate fuel management. Factors in the accident were: the unmarked fuel selector and the CFI's excessive descent…NTSB MIA96LA040Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe pilot-in-command's failure to assure an adequate amount of fuel was available for the flight.NTSB ATL96FA022Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Greenwood, SCthe loss of engine power for undetermined reason.NTSB SEA96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chimacum, WAthe pilot-in-command's delayed application of carburetor heat which resulted in a power loss due to carburetor ice. Carburetor icing conditions, a short takeoff area, and a ditch at the end of the airstrip were factors.