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 LAX91LA027Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Dana Point, CAThe pilot's improper fuel consumption calculations.NTSB DEN91LA016Accident · No injuriesLimited investigationFinal reportFogarty Pitts S1SEW · Bennett, COThe pilot's failure to refuel the airplane and the resultant fuel exhaustion induced power loss. A factor was the soft terrain in which the forced landing was performed.NTSB CHI91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oswego, KSFuel starvation due to improper placement of the fuel tank selector by the pilot.NTSB NYC91LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Zanesville, OHImproper use of carburetor heat by the pilot, which resulted in a loss of power due to carburetor ice. Factors related to the accident were: carburetor icing (weather) conditions and soft terrain in the emergency landing area.NTSB ANC91LA012Accident · No injuriesLimited investigationFinal reportCessna 170A · Healy, AKThe loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB SEA91LA012Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Afton, WYAn improper maintenance modification to disable the carburetor heat control by unknown personnel.NTSB LAX91LA023Accident · No injuriesLimited investigationFinal reportCessna 150G · Columbia, CAPoor planning which resulted in fuel exhaustion.NTSB CHI91LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Scott, KSThe mixture control was set incorrectly resulting in fuel starvation, and the check list was not followed by the cfi/pic.NTSB FTW91DPD01Accident · No injuriesFinal reportRans S-9 · Iowa Park, TXThe total loss of engine power due to fuel starvation as the result of a blocked fuel filter in the fuel system.NTSB MIA91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Osteen, FLTotal loss of engine power, for an undetermined reason.NTSB DEN91LA015Accident · No injuriesLimited investigationFinal reportCessna 182C · Silver City, NMThe pilot's improper planning which resulted in fuel starvation.NTSB CHI91FA022Accident · 2 fatalField investigationFinal reportCessna 195 · Flint, MIThe pilot-in-command's inadequate preflight inspection of the fuel tank system. Factor(s) were: water contamination in the fuel.NTSB DEN91LA014Accident · Minor injuriesLimited investigationFinal reportCessna T-210-M · Buena Vista, COThe pilot misjudged the fuel supply resulting in fuel exhaustion.NTSB SEA91LA009Accident · No injuriesLimited investigationFinal reportCessna T210N · Laramie, WYThe pilot did not properly set the mixture control.NTSB ATL91LA010Accident · No injuriesLimited investigationFinal reportCessna A150K · Dublin, GAThe pilot's inadequate preflight planning and preparation, in that he did not ensure that enough fuel was on board to complete the flight.NTSB MIA91LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Orlando, FLInadequate planning by the pilot.NTSB LAX91DUJ02Accident · No injuriesFinal reportJoe L. Harr SE-5A · Camp Verde, AZThe pilot's inadvertent shut-off of the fuel supply to the engine shortly after takeoff.NTSB MIA91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLInadequate preflight of the airplane by the pilot-in-command.NTSB LAX91DUJ01Accident · Serious injuriesFinal reportJoseph W. Hillbrand Sonerai IIL · Maricopa, AZAn engine failure due to improper fuel.NTSB ATL91LA004Accident · Serious injuriesLimited investigationFinal reportE TN Plts Starduster Starduster II · Knoxville, TNPilot's inadvertent closing of the fuel shutoff valve, which totally or partially restricted fuel flow to the engine.NTSB FTW91LA006Accident · No injuriesLimited investigationFinal reportBeech 77 · Arkadelphia, ARFuel starvation to the engine due to a blocked fuel system vent. Factors contributing to the accident were the pilot's inadequate preflight, and contacting high vegetation and low trees during the landing roll.NTSB MIA91LA009Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · De Funiak Spgs, FLThe loose fuel cap and failure of the pilot to assure the aircraft was properly preflighted, which resulted in fuel siphoning and subsequent fuel exhaustion. Factors related to the accident were: faulty fuel quantity gages, the pilot's decision to fly with…NTSB NYC91LA010Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Monongahela, PAThe pilot's inadequate monitoring of the fuel burn which resulted in total fuel exhaustion. Factors which contributed to the accident were: the pilot's limited experience in the make and model of airplane, an erroneous fuel quantity indication, and the…NTSB FTW91LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Claremore, OKFailure of pilot in command to insure the aircraft contained enough fuel for the flight resulting in engine failure due to fuel exhaustion.NTSB BFO91LA013Accident · No injuriesLimited investigationFinal reportCessna 421B · Morganfield, KYLost of power of both engines due to the pilot's mismanagement of the fuel system.NTSB CHI91LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Troy, MIThe pilot failed to refuel the aircraft prior to flight.NTSB LAX91DVW01Accident · Serious injuriesFinal reportMelton MMI · Death Valley, CAThe pilot's inaccurate calculation of fuel consumption and his decision to continue the flight with a malfunctioning fuel quantity indicator.NTSB CHI91LA003Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Midland, MIThe pilot did not refuel resulting in loss of engine power due to fuel exhaustion. The inadvertent stall encountered during the forced landing was also a cause.NTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.NTSB CHI90DEE10Accident · 1 fatalFinal reportJeff Pierson Pierson Pusher · Kankakee, ILA loss of engine power due to activation of carburetor choke and an inadvertent stall during the forced landing.NTSB ANC90LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Anchorage, AKThe pilot's poor judgement due to consumption of alcohol, and his improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB FTW90LA188Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Albany, TXFuel starvation power loss due to the inadvertent movement of the fuel selector valve by the passenger.NTSB LAX90LA339Accident · No injuriesLimited investigationFinal reportWaco YMS · Kailua, HIImproper use of carburetor heat resulting in engine failure due to carburetor icing.NTSB NYC90DNC01Accident · Serious injuriesFinal reportCessna 180E · Kingston, NHAn inflight collision with water while maneuvering for a forced landing. A factor to the accident was a power loss due to the pilot's improper use of the mixture control.NTSB CHI90LA272Accident · Minor injuriesLimited investigationFinal reportCessna A150L · Terre Haute, INAn undetermined loss of engine power.NTSB ATL90LA178Accident · No injuriesLimited investigationFinal reportCessna 150J · Albemarle, NCThe pilot's not obtaining an adequate fuel supply for his planned flight, resulting in fuel exhaustion.NTSB NYC90LA224Accident · Minor injuriesLimited investigationFinal reportRockwell 690B · North Castle, NYThe pilot's improper aircraft preflight (fuel cap not properly secured) which resulted in fuel siphoning and fuel exhaustion.NTSB CHI90DEP11Accident · Minor injuriesFinal reportVarga Kachina 2150A · Neenah, WIThe pilot's misjudgement of the fuel supply, and his failure to refuel the aircraft. Contributing to the accident was the unsuitable, soft terrain encountered.NTSB ATL90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Brookley, GAFuel exhaustion. Factors include improper planning/decision by the pilot-in-command.NTSB LAX90LA327Accident · No injuriesLimited investigationFinal reportCessna 150L · Palm Springs, CAFuel exhaustion. Contributing factors related to the pilot's improper preflight preparation, and his lack of total experience.NTSB FTW90GA185Accident · No injuriesFinal reportHughes 369HS · New Orleans, LAThe pilot's failure to maintain rotor RPM. A factor in the accident was the lose of engine power due to fuel starvation.NTSB CHI90LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Huntington, INThe student pilot's improper preflight planning ensuring sufficient fuel for the intended flight.NTSB MIA90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Orlando, FLFailure of the pilot to follow proper procedures.NTSB ANC90LA177Accident · No injuriesLimited investigationFinal reportHelio H-295 · Mcgrath, AKFuel contamination. A contributing factor was the inadequate aircraft preflight by the pilot.NTSB ANC90LA175Accident · No injuriesLimited investigationFinal reportCessna 206 · Puntilla Lake, AKAn inadequate preflight.NTSB CHI90LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFuel exhaustion. Contributing factor was the unsuitable terrain.NTSB LAX90LA322Accident · Serious injuriesLimited investigationFinal reportCessna 152 · San Fernando, CAFuel exhaustion. Contributing factors related to the pilot's improper preflight preparation and improper in-flight planning.NTSB ANC90LA168Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot-in-command's improper in-flight planning and ultimate fuel exhaustion.NTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.NTSB DEN90LA183Accident · 1 fatalLimited investigationFinal reportBeech E 33 · Tulsa, OKThe pilot's failure to select the right tank prior to the approach resulting in fuel starvation.