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 LAX98LA277Accident · Serious injuriesLimited investigationFinal reportSilvaire Luscombe 8E · Mojave, CAFuel exhaustion due to the pilot's inadequate preflight.NTSB LAX98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oroville, CAthe pilot's inaccurate preflight and in-flight fuel consumption calculations, which resulted in fuel exhaustion. The pilot's failure to obtain the proper engine power setting charts to use in fuel consumption calculations was also causal.NTSB LAX98LA281Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Phoenix, AZFuel starvation due to the pilot's inadequate in-flight fuel management and his failure to select a tank containing fuel prior to the loss of power.NTSB CHI98LA331Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit Lakes, MNAn inadequate preflight inspection by the pilot which resulted in fuel exhaustion and subsequent loss of engine power.NTSB MIA98LA231Accident · Minor injuriesLimited investigationFinal reportBibb RV-4 · Chapel Hill, NCThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion.NTSB NYC98LA173Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Duncannon, PAThe pilot's disregard of the fuel condition during the preflight which resulted in a takeoff with contaminated fuel and a loss of power. A factor was the pilot's lack of recent experience.NTSB LAX98LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZFuel exhaustion due to the pilot's inadequate preflight planning and in-flight monitoring of the aircraft's fuel consumption.NTSB LAX98FA267Accident · Serious injuriesField investigationFinal reportCessna 177 · Los Angeles, CAThe failure of the pilot to accurately determine that an adequate quantity of fuel was aboard the aircraft for the intended flight, and the failure to monitor fuel quantity remaining while en route to ensure an adequate quantity of reserve fuel prior to…NTSB FTW98LA362Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Houston, TXThe pilot's failure to refuel the helicopter which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB IAD98FA095Accident · 3 fatalField investigationFinal reportCessna 152 · Blue Ash, OHthe pilot's inaccurate calculation of the fuel which resulted in exhaustion of fuel and subsequent loss of engine power.NTSB FTW98LA359Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grand Prairie, TXFuel exhaustion due to the pilot's failure to refuel which resulted in the loss of engine power. Factors were the lack of suitable terrain for the forced landing, and the dark night light conditions.NTSB CHI98LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Beecher, ILFuel exhaustion due to fuel mismanagement by the pilot-in-command. The rough terrain was a contributing factor.NTSB ATL98LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Lantana, FLThe pilot's inadequate preflight inspection of the fuel system that resulted in the loss of engine power due to water contamination. A factor was the rough terrain on the departure end of the runway.NTSB IAD98LA091Accident · Serious injuriesLimited investigationFinal reportCessna T337G · Windsor Twnship, PAThe pilot's mismanagement of the fuel which led to fuel exhaustion and subsequent loss of engine power.NTSB ATL98LA105Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Marathon, FLThe inadequate inspection of the fuel pump during the last engine overhaul, that subsequently resulted in a worn diaphragm, fuel venting overboard, and loss of engine power from fuel exhaustion during a critical phase of flight.NTSB ANC98FA116Accident · 1 fatalField investigationFinal reportCessna A185F · Ketchikan, AKFuel starvation and the pilot's improper fuel tank selection. Factors associated with the accident were the pilot's failure to follow the pre-takeoff checklist and trees.NTSB CHI98LA304Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Trenton, NEthe pilot misjudged the forced landing approach and stalled the airplane while attempting to lengthen his glide on final approach and inadequate preflight planning that led to the loss of engine power due to fuel exhaustion.NTSB CHI98LA291Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Plainview, MNThe pilot's not achieving the proper descent rate prior to touchdown. A factor related to the accident was fuel starvation due to a low fuel level.NTSB LAX98LA247Accident · No injuriesLimited investigationFinal reportCessna 150K · Yorba Linda, CAAn oil starvation failure of the engine due to the mechanic's inadequate maintenance installation and quality control procedures, which resulted in a shop rag being inadvertently left inside the accessory case when the starter was changed 7 hours prior to the…NTSB CHI98LA283Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Middleton, WIThe fuel starvation of the aircraft in addition to the improper aircraft preflight and premature gear extension by the pilot-in-command. The blocked fuel vent system is a contributing factor.NTSB LAX98LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · California City, CAThe pilot's failure to assure that an adequate supply of fuel was available for the flight and his inadequate preflight planning/preparation.NTSB MIA98LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Panama City Bch, FLThe pilot's inadequate inflight planning, which resulted in fuel exhaustion and the loss of engine power.NTSB IAD98LA084Accident · Minor injuriesLimited investigationFinal reportBeech BE24 · Beckley, WVThe pilot's mismanagement of the fuel supply in that the fuel selector was selected to the improper fuel tank, which resulted in fuel starvation and the loss of engine power.NTSB FTW98LA331Accident · No injuriesLimited investigationFinal reportCessna TU206G · Midvale, UTThe pilot's inadequate fuel management which resulted in fuel exhaustion and subsequent loss of engine power.NTSB FTW98LA329Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Rockwall, TXThe pilot's improper use of the fuel tank selector resulting in the loss of engine power due to fuel starvation. A factor was the pilot's failure to follow the check list.NTSB CHI98LA270Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Sheboygan, WIThe pilot's inadequate fuel management which led to fuel exhaustion.NTSB SEA98LA169Accident · No injuriesLimited investigationFinal reportWiles S1-C · Yelm, WAFuel exhaustion due to overflying an intermediate fuel stop. Factors include high grass in the forced landing area.NTSB FTW98LA322Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fairview, OKLoss 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 for the forced landing.NTSB LAX98LA237Accident · 1 fatalLimited investigationFinal reportDe Malignon Varieze · Globe, AZfuel starvation due to the pilot's failure to properly plan his flight with regard to his estimated flight time, planned descent(s), and the amount of usable fuel available and required in the fuselage tank. The pilot/builder's deviation from the aircraft…NTSB SEA98LA142Accident · No injuriesLimited investigationFinal reportSocata Rallye 235E · Kalispell, MTThe pilot-in-command's improper fuel management, resulting in fuel starvation. Related factors were insufficient altitude available for effective remedial action, and lack of suitable terrain for a forced landing.NTSB CHI98LA303Accident · Minor injuriesLimited investigationFinal reportCook Teenie TWO · Stevensville, MIThe pilot's inadequate preflight planning and preparation which resulted in fuel exhaustion and subsequent loss of engine power.NTSB ANC98LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKThe loss of engine power due to carburetor icing and the pilot's improper use of the carburetor heat control. A factor associated with the accident is the rough and uneven terrain at the forced landing area.NTSB CHI98LA258Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Springfield, MOthe pilot in command's inadequate preflight planning/preparation and inaccurate fuel consumption calculations that caused the aircraft's fuel supply to be exceeded. Factors to the accident were the dark light condition and the rough/uneven terrain condition.NTSB CHI98LA251Accident · No injuriesLimited investigationFinal reportGrumman G-164B · New Haven, ILWater contamination of the fuel system. A related factor was the swampy terrain.NTSB SEA98LA130Accident · No injuriesLimited investigationFinal reportPerson Vari EZE · Arlington, WAA lack of adequate carburetor heat available and overload of the main landing gear. Contributing factors were carburetor icing conditions and soft terrain.NTSB FTW98LA305Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · San Angelo, TXThe loss of engine power as a result of fuel 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 MIA98LA188Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Okeechobee, FLthe pilot's improper planning/decision, by failing to ensure the aircraft contained adequate fuel to complete the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Obstructions (trees and guardrail) in the emergency landing…NTSB FTW98LA300Accident · No injuriesLimited investigationFinal reportBeech H35 · Marshall, TXThe loss of engine power due to fuel starvation as a result of the improper position of the fuel selector. A factor was the pilot's lack of experience in this make and model of airplane.NTSB LAX98LA222Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Chico, CALoss of engine power for undetermined reasons.NTSB ATL98LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Jacksonville, FLThe pilot's failure to manage his fuel properly leading to fuel starvation, a loss of engine power, and the collision with trees and the ground. A factor was his lack of total experience.NTSB LAX98FA208Accident · 1 fatalField investigationFinal reportFrandsen Midget Mustang MM-1 · Tracy, CAinadequate maintenance/inspection by the owner/pilot that resulted in an obstructed fuel vent system and a subsequent loss of engine power during takeoff.NTSB CHI98LA226Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Osceola, WIthe student pilot's incomplete preflight, and the instructor pilot's inadequate supervision of the student's preflight. Factors were the fuel contaminated with water, and the roadway encountered during the forced landing rollout.NTSB LAX98LA212Accident · No injuriesLimited investigationFinal reportNorth American Navion · San Andreas, CAThe pilot's improper reinstallation of the fuel selector valve handle, which led to the selection of the wrong fuel tank and fuel starvation.NTSB FTW98LA288Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casper, WYThe pilot's improper in-flight planning and decision making by selecting an inadequate landing area for an emergency landing when a suitable landing area was available. Factors were fuel exhaustion, inaccurate preflight planning, and lack of recent experience.NTSB IAD98LA071Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edgemere, MDThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB NYC98FA129Accident · 1 fatalField investigationFinal reportHawker Hunter T MK 8 · Manchester, NHFuel exhaustion, resulting from the pilot's reliance on an inaccurate fuel quantity indicating system. A factor in the pilot's death was his intentional delay of the ejection sequence in order to avoid people and property on the ground.NTSB MIA98LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Holly Springs, MSThe pilot's inadequate in-flight decision with the miscalculation of the fuel consumption. Operating with an unreliable fuel gage was a contributing factor.NTSB FTW98LA268Accident · No injuriesLimited investigationFinal reportCessna 150L · Taft, TXThe pilot's failure to ensure that there was adequate fuel for the planned flight on board the airplane during the preflight inspection which resulted in a loss of engine power due to fuel exhaustion. A factor was the pilot's misjudgment of the glide distance…NTSB CHI98LA200Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Albion, MIthe pilot's improper preflight planning/preparation and his not refueling the airplane to avoid fuel exhaustion. Factors were the pilot's lack of certification, his not feathering the engine, and the trees.NTSB ATL98LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boynton Beach, FLThe pilot's inadequate preflight planning that resulted in a loss of engine power due to fuel exhaustion.