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 SEA94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Sweet Home, ORThe pilot delayed using carburetor heat until the engine had already lost power due to ice forming in the carburetor throat. Factors include carburetor icing conditions, and rough/uneven terrain in the field where the forced landing was made.NTSB BFO94LA090Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA318C · Rassellas, PAThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and the lost of engine power. Factors in the accident were the pilot operating the helicopter with known deficiencies in equipment and no suitable terrain available for landing.NTSB CHI94LA187Accident · No injuriesLimited investigationFinal reportBeech C-23 · Gary, INImproper preflight planning and preparation by the pilot-in-command which resulted in fuel exhaustion. A factor associated with the accident was the delay in emergency procedures by the pilot-in-command.NTSB BFO94LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Montgomery, NYThe pilot's mismanagement of the fuel supply with an improper fuel selector position which resulted in fuel starvation and the loss of engine power. A factor is the instructor's inadequate supervision of the flight.NTSB MIA94LA152Accident · No injuriesLimited investigationFinal reportCessna 210L · Pahokee, FLThe improper positioning of the fuel selector valve by the pilot-in-command which caused an engine failure due to fuel starvation at an altitude too low for restart procedures.NTSB NYC94LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Spring City, PAThe pilot's improper inflight planning and inaccurate fuel consumption calculations, resulting in fuel supply exhaustion, loss of engine power, and the subsequent collision with trees during a forced landing.NTSB LAX94LA226Accident · 1 fatalLimited investigationFinal reportParker Rotorway Exec 90 · Fallbrook, CAThe pilot's improper preflight and miscalculation of remaining fuel, which resulted in fuel exhaustion, and improper autorotation, due to inadequate transition/upgrade training and lack of familiarity with helicopters.NTSB CHI94LA182Accident · No injuriesLimited investigationFinal reportCessna P-210N · Milwaukee, WIImproper in-flight planning and decision making by the pilot which resulted in fuel exhaustion.NTSB CHI94LA180Accident · No injuriesLimited investigationFinal reportMooney M20E · Omaha, NEinaccurate fuel consumption calculations and the inadequate fuel supply for the flight. Factors related to the accident were the ditch and the quantity gage which gave a false indication.NTSB CHI94LA176Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Bancroft, WIthe pilots failure to select carburetor heat during an extended descent, which resulted in loss of engine power. Factors were carburetor icing conditions and the presence of a ditch at the forced landing site.NTSB ATL94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Foley, ALThe pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and collision with the ground. The pilot's inadequate preflight and resultant improper positioning of the fuel selector were factors.NTSB ANC94LA057Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kenai, AKFuel exhaustion as a result of the student pilot-in-command's failure to refuel. The lack of suitable terrain for a forced landing was a factor.NTSB CHI94LA169Accident · No injuriesLimited investigationFinal reportCessna 150K · Jasonville, INthe loss of engine power due to fuel exhaustion as a result of an inadequate aircraft preflight inspection.NTSB NYC94LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Addison, NYThe pilot's improper inflight planning and decision, resulting in fuel exhaustion and the subsequent forced landing and collision with trees.NTSB FTW94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bryan, TXThe pilot's failure to refuel resulting in a total loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB SEA94LA119Accident · 1 fatalLimited investigationFinal reportHallstrom BD-5B · St. George, UTCarburetor contamination and low output, and the pilot's improper decision to attempt to continue the approach. A factor was the pilot's lack of recent flight experience.NTSB CHI94LA163Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Kettle River, MNThe pilot's improper use of carburetor heat and the lack of suitable terrain for a forced landing. The carburetor icing weather condition was a factor.NTSB ATL94FA099Accident · Serious injuriesField investigationFinal reportBeech 58 · Monroe, NCThe pilot's inadequate pre-flight inspection.NTSB FTW94LA161Accident · No injuriesLimited investigationFinal reportCessna 150J · Del Rio, TXFuel exhaustion induced power loss due to the pilot's inaccurate fuel consumption calculations. The lack of suitable terrain for the forced landing was a factor.NTSB CHI94LA160Accident · No injuriesLimited investigationFinal reportCessna 175 · Plainfield, ILfuel contamination (water), and inadequate aircraft preflight inspection.NTSB CHI94LA159Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Burlington, IAfuel exhaustion resulting from the failure of the pilot to refuel en route.NTSB ATL94LA095Accident · Serious injuriesLimited investigationFinal reportSchweizer 300C · Randleman, NCThe pilot's failure to adequately preflight the helicopter which resulted in a complete loss of engine power. A factor was water in the fuel supply.NTSB FTW94LA144Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Osage, ARFuel exhaustion due to the pilot's failure to refuel and the lack of suitable terrain for a forced landing.NTSB CHI94LA144Accident · No injuriesLimited investigationFinal reportHelio H-800 · Foley, MNThe pilot-in-command's failure to perform accurate fuel consumption calculations. A factor was the soft gravel road landing area.NTSB ANC94LA053Accident · No injuriesLimited investigationFinal reportBeech 35 · Gustavus, AKThe pilot-in-command's delay in selecting the main fuel tank position. The lack of suitable terrain for a forced landing was a factor.NTSB MIA94LA129Accident · Serious injuriesLimited investigationFinal reportTaylor Osprey · Sanford, FLThe failure of the pilot in command to use the checklist before takeoff. The engine failed due to the fuel selector being in the off position. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB ATL94LA089Accident · No injuriesLimited investigationFinal reportHesterlee Rutan Vari EZE · Statesville, NCThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation during the initial climb after takeoff. A factor was a ditch adjacent to the runway.NTSB CHI94LA145Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rochelle, ILthe pilot's inadequate use of carburetor heat. Factors associated with the accident were carburetor icing conditions and rough terrain.NTSB MIA94LA128Accident · Minor injuriesLimited investigationFinal reportKeuthan Sabre II / S2A · Merritt Island, FLThe pilot-in-command's inadequate fuel consumption calculations and inadequate in-flight planning when encountering a headwind.NTSB SEA94LA107Accident · No injuriesLimited investigationFinal reportRich RV-4 · Weston, IDThe pilot's failure to use carburetor heat. Factors include carburetor icing conditions, and no suitable site for a forced landing.NTSB LAX94LA202Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Page, AZThe failure of the pilots to assure that ample fuel would be available to reach the airport. The generator failure and an inoperative fuel quantity gage were contributing factors.NTSB FTW94LA134Accident · Serious injuriesLimited investigationFinal reportWeatherly 201C · Sterling, COAn inadvertent stall. Factors were fuel exhaustion and the pilot's failue to refuel the airplane.NTSB BFO94LA075Accident · No injuriesLimited investigationFinal reportCessna 150M · Washington Cros, NJthe pilot-in-command's inadequate in-flight planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB ATL94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Athens, ALThe mechanic's failure to properly install an access plug which resulted in the loss of engine oil pressure.NTSB FTW94LA136Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Laredo, TXThe fuel exhaustion induced power loss due to the pilot's inadequate preflight and his failure to refuel the airplane prior to departure. A factor was the lack of suitable terrain for the forced landing.NTSB LAX94FA198Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Santa Monica, CAfuel starvation resulting from the failure of the pilot to select a tank containing fuel, and his failure to maintain adequate airspeed while maneuvering for a forced landing which resulted in an inadvertent stall.NTSB BFO94LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Butler, PAThe pilot's failure to select the proper fuel tank, which resulted in fuel starvation and the loss of engine power.NTSB MIA94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Margate, FLFailure of the pilot-in-command to position the fuel selectors to the fullest tank before landing resulting in the total loss of engine power from both engines due to fuel starvation.NTSB ATL94LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Raleigh, NCThe pilot's inadequate in-flight fuel planning that resulted in fuel starvation.NTSB SEA94LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Hurricane, UTThe pilot in command's failure to refuel and excessive airspeed during the approach. Factor(s) were: fencepost(s) and the lack of recent experience in type of aircraft.NTSB ATL94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Winston-Salem, NCThe pilot's failure to place the aircraft fuel selector to the tank with fuel remaining.NTSB SEA94LA094Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Rimrock, WAFuel exhaustion, the pilot in command's failure to refuel the aircraft, and the inability to successfully execute an auto- rotation landing because of the low altitude.NTSB CHI94FA116Accident · Serious injuriesField investigationFinal reportCanadair CL=601-3A · Bassett, NEthe pilot in command's inadequate planning/decision making and inadequate preflight inspection after receiving a load of contaminated fuel. Related factors are the contaminated fuel, improper refueling by FBO personnel, and the dark night light conditions.NTSB NYC94FA067Accident · 1 fatalField investigationFinal reportCessna 414 · Defiance, OHThe pilot's inadequate inflight decision and planning, which resulted in fuel exhaustion and the total loss of engine power.NTSB LAX94LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Selma, CAThe pilot's improper use of the fuel supply which allowed the engine to sustain fuel starvation, and his failure to follow the emergency checklist by not using the electrical fuel boost pump. The engine fuel starvation was a factor in this accident.NTSB MIA94LA093Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti F-260-C · Opa-Locka, FLThe failure of the pilot-in-command to assure proper positioning of the fuel selector resulting in fuel starvation.NTSB FTW94LA094Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Duncan, OKThe pilot's selection of the wrong engine for shut down. A factor was the lack of suitable terrain for the forced landing.NTSB CHI94LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Aurora, NEan inadequate fuel supply for the flight and the pilot's failure to refuel while en route. A factor related to the accident was the soft terrain on which the airplane was landed.NTSB CHI94LA103Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Frankfort, MIThe pilot's inadequate preflight and failure to maintain adequate airspeed. A factor was fuel contamination resulting in total loss of engine power on takeoff.NTSB CHI94LA101Accident · No injuriesLimited investigationFinal reportMooney M20C · Richland Center, WIimproper use of carburetor heat. Factors related to the accident were carburetor icing conditions, and the sign and fence poles.