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 ATL97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Raleigh, NCa loose fuel capd and siphoning of fuel, resulting in fuel exhaustion and a loss of engine power. A factor was the rough terrain in the forced landing field that resulted in the nose over during the landing roll.NTSB FTW97LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Rogers, ARthe pilot's improper fuel consumption calculations, which resulted in the loss of engine power, due to fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB LAX97LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · San Pablo Bay, CAtotal loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB LAX97LA102Accident · No injuriesLimited investigationFinal reportGreen Cozy III · San Martin, CAA loss of engine power due to fuel contamination. A factor in the accident is the aircraft design, which routes hydraulic lines through the fuel tank.NTSB ATL97LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLthe student pilot's inadvertent movement of the mixture control to idle cut-off during the approach to land, which resulted in engine shut-down, and the student's failure to follow emergency procedures for restarting the engine.NTSB LAX97LA097Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Los Angeles, CAFuel starvation resulting from the pilot's improper fuel tank selector position and failure to perform correct emergency procedures.NTSB ATL97LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Gulfport, MSthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel.NTSB LAX97LA096Accident · Minor injuriesLimited investigationFinal reportBeech N35 · Payson, AZa loss of engine power for undetermined reasons.NTSB CHI97LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INthe pilot's inadequate fuel management and fuel system exhaustion. A factor involved was the inadequate in-flight planning/decision.NTSB LAX97LA098Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Scottsdale, AZfuel exhaustion due to the pilot's improper fuel management.NTSB FTW97LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Boswell, OKThe student pilot's improper inflight planning and decision, after becoming lost/disoriented, which resulted in fuel exhaustion, before landing in a suitable landing area. Factors relating to the accident were: the pilot of another aircraft did not accurately…NTSB FTW97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Brownsville, TXthe pilot's failure to refuel the airplane which led to fuel exhaustion and subsequent loss of engine power. Factors were the pilot's lack of preflight planning and the lack of suitable terrain for the forced landing.NTSB SEA97LA052Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Chehalis, WAThe failure of the first pilot to conduct an adequate preflight inspection, and his failure to properly manage the aircraft fuel supply. This led to fuel starvation and a subsequent loss of engine power. Factors contributing to the accident are the false…NTSB MIA97LA075Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Whiteville, NCThe pilot's intentional operation of the helicopter with known deficiencies in equipment and a false indication of the fuel gauge, resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was inadequate maintenance of…NTSB FTW97LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Midland, TXThe pilot's failure to periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the lack of suitable terrain for the forced landing.NTSB MIA97LA072Accident · Serious injuriesLimited investigationFinal reportNavion G · Indiantown, FLTotal loss of engine power due to undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing. Findings of the follow-up investigation were 1) The airplane had not been operated and no annual inspections…NTSB FTW97LA088Accident · Minor injuriesLimited investigationFinal reportBeech B90 · Longmont, COFailure of the pilot to refuel the airplane, resulting in fuel exhaustion. Factors were the pilot's reference to similar but different aircraft performance charts, and the operator's failure to provide the pilot with the proper performance charts.NTSB FTW97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sulphur, OKThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.NTSB MIA97LA068Accident · No injuriesLimited investigationFinal reportStinson 108 · Winter Haven, FLFailure of the pilot to use carburetor heat for descent resulting in engine failure due to carburetor induction icing.NTSB MIA97LA064Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLInadequate inspection of the fuel caps by company maintenance personnel resulting in a cap with a deteriorated seal being allowed to continue in service. This allowed water to leak into the fuel tank which resulted in loss of engine power due to water…NTSB CHI97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Franklin, MNThe pilot's inadequate inflight planning and his fuel mismanagement, which resulted in fuel exhaustion and the loss of engine power. A contributing factor with this accident was a frost blocked cockpit windshield.NTSB LAX97FA086Accident · 2 fatalField investigationFinal reportEnstrom F28A · Saipan Island, Sarkloss of engine power due to fuel exhaustion, resulting from improper planning/decision; and the pilot's abrupt handling of the flight controls, while maneuvering to avoid swimmers, which resulted in main rotor blade contact with the tail boom. A related…NTSB FTW97LA080Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Baton Rouge, LAfuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB ANC97LA017Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Nome, AKthe pilot's failure to properly verify the position of a fractured fuel selector handle, which resulted in fuel starvation and subsequent loss of engine power. A factor related to the accident was: the fractured handle that allowed the fuel selector to be…NTSB MIA97LA055Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Florence, SCThe pilot-in-command's improper management of fuel resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA97LA054Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Daytona Beach, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel for continued flight, which resulted in fuel exhaustion and subsequent collision with objects (concrete blocks) during a forced landing. Factors relating to the accident…NTSB LAX97LA080Accident · No injuriesLimited investigationFinal reportCessna 182P · Fullerton, CAFuel system water contamination due to the failure of both pilots to purge all water from the fuel system prior to departure. Contributing factors were: failure of the mechanic conducting the recent annual inspection to identify and replace a deteriorated…NTSB ANC97TA016Accident · No injuriesFinal reportCessna 180 · St Mary'S, AKthe pilot's improper use of carburetor heat, and subsequent loss of engine power. Factors associated with the accident were the presence of ice crystals in the atmosphere, and unsuitable terrain for a forced landing.NTSB MIA97FA049Accident · 1 fatalField investigationFinal reportPiper PA-30 · Goldsboro, NCThe pilot's failure to follow instrument approach procedures during numerous instrument approaches and missed approaches which resuled in a total loss of engine power on both engines due to fuel exhaustion. Factors contributing to the accident were: the…NTSB ATL97FA030Accident · 2 fatalField investigationFinal reportBeech A36 · Pensacola, FLThe pilot's mismanagement of the fuel supply that resulted in fuel starvation and the subsequent loss of engine power. A factor was low ceilings.NTSB CHI97LA046Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Hayes Center, NEinadequate fuel management by the pilot, which resulted in fuel starvation. The factors relating to the accident were: a fuel leak at the engine driven fuel pump, and the engine driven fuel pump pressure was too low.NTSB ATL97LA028Accident · No injuriesLimited investigationFinal reportMooney M20F · Daytona Beach, FLThe pilot's inadequate in-flight fuel consumption calculations, and the excessive flow of the fuel injector servo, that combined to result in fuel exhaustion.NTSB FTW97LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Austin, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel the airplane. Factors were the lack of suitable terrain for the forced landing and the pilot's improper preflight inspection of the fuel system.NTSB FTW97LA071Accident · No injuriesLimited investigationFinal reportCessna 210A · Peyton, COthe pilot's improper fuel management by failing to avoid a prolong uncoordinated turn or slip, which resulted in fuel starvation. Factors relating to the accident were: darkness, and the lack of (activated) runway lights.NTSB NYC97LA032Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Stamford, CTinadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate fuel supply of fuel. Darkness and trees in the emergency landing area were related factors.NTSB FTW97LA066Accident · No injuriesLimited investigationFinal reportCessna 210N · Kerrville, TXthe pilot's inadequate preflight planning/preparation, 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 FTW97LA064Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Muskogee, OKthe pilot's improper planning/decision and inaccurate fuel consumption calculations, which resulted in an inadequate supply of fuel, fuel exhaustion, and a subsequent forced landing at night. Darkness was a related factor.NTSB IAD97LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Charleston, WVimproper planning/decision by the pilot, and his mismanagement of the fuel supply, which resulted in fuel exhaustion, loss of engine power, and a forced landing into wooded terrain.NTSB NYC97LA029Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Charlottesville, VAThe pilot's miscalculation of fuel consumption and his inadequate in-flight decision making, which resulted in fuel exhaustion and the loss of engine power.NTSB CHI97LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Garnett, KSthe pilot's improper in-flight planning/decision, including a delay in proceeding to an alternate airport after encountering fog during a night approach, which resulted in loss of engine power due to fuel exhaustion.NTSB LAX97FA066Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · Riverside, CAfuel starvation due to improper fuel management. Contributing to the accident was the pilot's preoccupation of discussing the legality of the approach with the tower controller, and fatigue.NTSB ANC97LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Nunapitchuk, AKthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing. Factors associated with the accident were: the low fuel condition, which led to a single engine landing, and the crosswind condition.NTSB NYC97FA025Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Felton, PAThe pilot's inadequate preflight planning and preparation, and his failure to refuel which resulted in fuel exhaustion and the subsequent collision with trees during the forced landing.NTSB LAX97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Tusayan, AZFuel exhaustion due to the pilot's inadequate preflight planning and his miscalculation of the fuel required for the flight.NTSB NYC97LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Long Pond, PAThe pilot's inadequate preflight planning/preparation and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related…NTSB FTW97LA050Accident · No injuriesLimited investigationFinal reportCessna 172H · Hammond, LAthe pilot's inadequate preflight, resulting in the total loss of engine power due to fuel exhaustion.NTSB ATL97LA020Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · St. Petersburg, FLFuel exhaustion for undetermined reasons.NTSB MIA97LA027Accident · No injuriesLimited investigationFinal reportCessna A188B · Ocilla, GAthe pilot's inadequate fuel consumption calculations and failure to ensure the aircraft contained an adequate amount of fuel to complete the flight, which resulted in loss of engine power because of fuel exhaustion. Uneven terrain in the emergency landing…NTSB MIA97LA024Accident · No injuriesLimited investigationFinal reportCessna 182C · Anderson, SCthe pilot's improper preflight, resulting in the fuel cap(s) not being secured; and subsequent siphoning and loss of fuel, which resulted in loss of engine power, a forced landing, and subsequent collision with a ditch during the emergency landing.NTSB SEA97LA032Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Forks, WAfuel contamination, which resulted in loss of engine power. Factors relating to the accident included: improper servicing of the helicopter, and a lack of suitable terrain for an emergency landing due to the proximity of trees.