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 LAX93LA346Accident · No injuriesLimited investigationFinal reportCessna 150L · Chemehuevi Valy, CAA loss of engine power for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for the forced landing attempt.NTSB LAX93LA343Accident · No injuriesLimited investigationFinal reportCessna TU206G · Marble Canyon, AZfuel starvation due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft either prior to departure or enroute.NTSB BFO93LA159Accident · No injuriesLimited investigationFinal reportCessna 206 · Inlet, NYthe blocked header tank fuel port which resulted in fuel starvation. A factor to the accident were the high obstructions in the emergency landing area.NTSB BFO93LA157Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Oak Grove, KYThe pilot's innacurate preflight fuel consuption calculations and inadequate in-flight planning/decisions, which resulted in fuel exhaustion and subsequent loss of engine power. A factor related to the accident was: high obstructions in the emergency landing…NTSB FTW93LA253Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Weatherford, TXFuel exhaustion. Factors were: the pilot's failure to have the airplane serviced to capacity prior to departure, and his erroneous fuel consumption calculations.NTSB SEA93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Missoula, MTThe loss of engine power from fuel exhaustion due to inadequate preflt planning/preparation by the PIC. A factor related to the accident was the rough/uneven terrain at the accident site.NTSB MIA93LA187Accident · No injuriesLimited investigationFinal reportMooney M20J · Daytona Beach, FLContamination/blockage of the fuel injection control system.NTSB FTW93LA247Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Prairie, TXThe fuel exhaustion induced power loss, the pilot's miscalculation of the amount of fuel required for the flight, and his failure to refuel. Factors were the dark night conditions and the lack of suitable terrain onto which a forced landing could be executed.NTSB CHI93LA339Accident · No injuriesLimited investigationFinal reportCessna 172L · Curryville, MOImproper preflight planning and procedures by the pilot-in-command which resulted in fuel exhaustion.NTSB FTW93LA246Accident · No injuriesLimited investigationFinal reportCessna T210N · Springdale, ARThe loss of engine power due to fuel starvation and the improper use of the fuel selector. Factors were the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.NTSB ATL93LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108/U · Mccaysville, GAThe loss of engine power for undetermined reasons.NTSB NYC93LA171Accident · No injuriesLimited investigationFinal reportCessna 172 · Phillips, METhe pilot's inadequate preflight and inflight decision which resulted in fuel exhaustion and the loss of engine power.NTSB NYC93FA169Accident · 2 fatalField investigationFinal reportBeech F35 · Medford, NJThe pilot's failure to select a fuel tank that contained fuel, and perform the emergency procedure to restart the engine, which resulted in fuel starvation and the loss of engine power. Factors are the pilot's lack of total experience and his inadequate…NTSB CHI93LA335Accident · No injuriesLimited investigationFinal reportCessna 150J · Rochester, INthe commercial pilot's inadequate preflight planning/preparation.NTSB ATL93LA146Accident · No injuriesLimited investigationFinal reportCessna 150H · Monroe, NCWas the pilot's failure to determine actual fuel consumption enroute. A factor was inadequate supervision by the instructor pilot.NTSB ANC93FA152Accident · Minor injuriesField investigationFinal reportDe Havilland DHC-3 · Nikabuna Lake, AKFluid, fuel starvation as a result of the pilot-in-command's improper in-flight planning/decision. A factor in the accident was the operator's inadequate flight time and fuel upload record keeping.NTSB ANC93LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Goose Bay, AKThe loss of engine power due to fuel starvation. A factor in the accident was the inadequate installation information supplied with the STC for the engine upgrade.NTSB FTW93LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Houston, TXEngine power loss due to fuel exhaustion for undetermined reasons. Factors were the pilot's failure to monitor and recalculate fuel consumption en route and the lack of suitable terrain onto which the forced landing could have been executed.NTSB ANC93LA147Accident · No injuriesLimited investigationFinal reportCessna 185 · Point Barrow, AKFuel exhaustion as a result of the pilot in command's not refueling. A factor in the accident was the operator/management inadequate flight following and operational control over the flight.NTSB ANC93LA146Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKFuel exhaustion due to the pilot in commands improper preflight planning/preparation.NTSB SEA93LA175Accident · No injuriesLimited investigationFinal reportEkins Protech PT2C Prostar · Nephi, UTThe pilot's inadequate preflight inspection which resulted in loss of engine power due to fuel contamination. Factors contributing to the accident was the wet landing surface and terrain condition - ditch.NTSB MIA93LA174Accident · No injuriesLimited investigationFinal reportCessna 150F · Pembroke Pines, FLTotal loss of engine power caused by fuel exhaustion and inadequate preflight planning/preparation by the pilot-in-command. Contributing to the accident was the inaccurate fuel quantity gauges and the lack of suitable terrain for the forced landing.NTSB LAX93LA320Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Delano, CAthe pilot's inadequate preflight inspection and his failure to refuel the aircraft.NTSB CHI93LA315Accident · No injuriesLimited investigationFinal reportCessna 152 · Montgomery, ILThe pilot became disoriented resulting in loss of engine power due to fuel exhaustion. The dark night light condition was a factor.NTSB SEA93LA174Accident · 2 fatalLimited investigationFinal reportBrauch Glasair · Blanding, UTThe loss of engine power resulting from inadequate maintenance inspection by the pilot, a leak from loose fuel system line fittings, and fuel exhaustion. A factor relating to the accident was the rough/uneven terrain.NTSB LAX93FA315Accident · 2 fatalField investigationFinal reportBeech E35 · Big Bear, CAA loss of engine power due to unporting of the selected main fuel tank at a critical time, which was caused by the pilot's failure to follow the directives in the flight manual regarding prolonged turns or slips with less than 10 gallons in the selected tank.NTSB LAX93LA313Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC-12D · Tehachapi, CAFuel starvation due to the pilot's failure to correctly position the fuel selector prior to departure, and his failure to maintain an adequate airspeed margin above stall while attempting to return to the runway. Factors in the accident were: the pilot's…NTSB CHI93DEP03Accident · No injuriesFinal reportKit Fox IV · Green Bay, WIthe improper modification of the fuel system by the pilot-in-command. A factor was bockage of the fuel system screen.NTSB DEN93LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Timpson, TXThe pilot in command's failure to refuel resulting in fuel exhustion. Factors were: the lack of suitable terrain for the forced landing, and dark night light conditions.NTSB CHI93LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, IAthe failure of the pilot to refuel prior to fuel exhaustion.NTSB FTW93LA224Accident · No injuriesLimited investigationFinal reportCessna 150M · Bald Knob, ARFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93FA222Accident · Serious injuriesField investigationFinal reportHarral Glasair 1 · Rusk, TXThe pilot's failure to select the proper fuel tank which resulted in a fuel starvation engine power loss and his inadvertant entry into a stall during the ensuing forced landing.NTSB FTW93LA220Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Elaine, ARThe pilot's failure to maintain clearance of water spraying and the resultant power loss. A factor was unsuitable terrain for the forced landing.NTSB CHI93LA300Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Ortonville, MNthe pilot's failure to refuel prior to fuel exhaustion.NTSB ATL93LA137Accident · 1 fatalLimited investigationFinal reportWard Long EZE · Murfreesboro, TNThe pilot's failure to properly use the carburetor heat control which resulted in the formation of carburetor ice.NTSB CHI93LA288Accident · No injuriesLimited investigationFinal reportMurphy Rebel · Pickett, WIThe pilot's inadequate preflight planning which resulted in fuel exhaustion. The lack of suitable terrain for a forced landing was a factor in the accident.NTSB CHI93LA287Accident · No injuriesLimited investigationFinal reportCessna T210M · Neosho, MOIs the pilot in command's failure to maintain proper clearance. Factors relating to this accident are the pilot in command's inadequate preflight preparation and the loss of total engine power as a result of fuel exhaustion.NTSB LAX93FA300Accident · 6 fatalField investigationFinal reportCessna 310H · Lancaster, CAthe pilot's improper in-flight planning/decision and his failure to maintain the minimum control airspeed which progressed to an inadverent stall/spin. Factors relating to this accident were fuel exhaustion and the pilot's lack of experience in the accident…NTSB SEA93LA160Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Jerome, IDThe pilot's improper fuel management procedures which resulted in fuel starvation. Factors include the pilot's lack of familiarity with this type aircraft, and rough/uneven terrain in the landing area.NTSB SEA93LA158Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Troutdale, ORThe pilot's poor inflight decision, and fuel exhaustion. Factors include unfavorable winds, a dark night, and trees in the attempted landing area.NTSB CHI93IA280Incident · No injuriesIncident investigationFinal reportCanadair CL600-2B19 · Danville, ILa lightning strike and associated engine flameout.NTSB CHI93FA272Accident · Serious injuriesField investigationFinal reportCessna 172N · Long Grove, ILThe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. Related factors to the accident were: inadequate certification/approval of the STC by the FAA, inadequate performance data, and unavailable fuel consumption information.NTSB LAX93LA295Accident · Minor injuriesLimited investigationFinal reportCurry Varieze · Bisbee, AZThe pilot's improper use of the carburetor heat. The carburetor icing conditions were a factor.NTSB CHI93LA268Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Elderon, WIThe pilot's failure to refuel the helicopter.NTSB BFO93LA133Accident · Serious injuriesLimited investigationFinal reportBeatty Glasair SH-2 · Cape May, NJInadequate preflight by the pilot by not assuring the fuel selector was in the proper position for takeoff, which resulted in fuel starvation and subsequent loss of engine power; and failure of the pilot to maintain sufficient airspeed, which resulted in a…NTSB ATL93LA131Accident · Minor injuriesLimited investigationFinal reportAero Commander 112 · Broadway, NCWater and contaminants in the aircraft fuel system, and the pilot's inadequate preflight of the aircraft. A factor was the rough terrain at the forced landing site.NTSB ANC93LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKFuel contamination and the pilot in command's improper preflight planning/decision. A factor was the pilot's inadequate airspeed with which to make a normal landing following the engine power loss.NTSB ANC93FA123Accident · Serious injuriesField investigationFinal reportCessna A185F · Denali Nat'L Pk, AKFuel exaustion due to the the pilot-in-command's failure to refuel. Factors in the accident were: pressure by management personnel and lack of suitable terrain during the forced landing.NTSB MIA93LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)Total loss of engine power due to fuel exhaustion. Contributing to the accident was inaccurate fuel comsumption calculations by the pilot-in-command.NTSB BFO93LA126Accident · Serious injuriesLimited investigationFinal reportCessna 172D · New Milford, PALoss of engine engine power due to water contamination of the fuel. Factors related to the accident were the mice, which partially blocked fuel and air flow to the carburetor, and the lack of suitable terrain in the emergency landing area.