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 SEA93LA069Accident · Minor injuriesLimited investigationFinal reportCessna T-210L · Ogden, UTThe loss on engine power from fuel exhaustion due to the inadequate preflt planning/preparation by the PIC and his failure to maintain proper airspeed during an emergency forced landing.NTSB BFO93FA034Accident · 1 fatalField investigationFinal reportCessna 180F · Brewer, MELoss of engine power due to undetermined reasons, and the failure of the pilot to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB LAX93LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZLoss of engine power for an undetermined reason.NTSB LAX93LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Red Mountain, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the aircraft. Factors in the accident were the pilot's inability to see the terrain due to the dark night conditions and the flight's encounter with instrument…NTSB ANC93LA039Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKThe fuel system selector valve being placed in the off position due to the improper installation of the fuel selector placard by an unqualified person. The snow covered forced landing area was a factor.NTSB CHI93LA093Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Cannonball, NDThe blockage of the inlet air filter from snow.NTSB LAX93LA126Accident · Minor injuriesLimited investigationFinal reportCessna Soloy TU206G · Cochise, AZThe pilot's continued flight into known forecasted icing conditions, in an airplane not certificated for such flight, which resulted in an engine flameout due to engine ice/water injestion, and the pilot's inability to restart the engine due to inadequate…NTSB MIA93LA069Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Sun City, FLThe pilot-in-command's failure to verify fuel load after refueling, which resulted in loss of engine power due to fuel exhaustion.NTSB FTW93LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Magdalena, NMFuel exhaustion power loss due to the pilot's failure to refuel. Factors were the unsuitable terrain and the dark nightNTSB FTW93LA085Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19-3A · Graham, TXThe loss of engine power due to fuel starvation due to the improper position 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 FTW93LA083Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Ardmore, OKPilot's failure to refuel and fuel exhaustion. Factors were a fuel leak in the wing and unsuitable terrainNTSB FTW93LA082Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Hillsboro, TXThe power loss due to fuel exhaustion for undetermined reasons. Factors were the dark night conditions and the lack of suitable terrain for the ensuing forced landing.NTSB ATL93FA060Accident · Serious injuriesField investigationFinal reportCessna 337D · Nashville, TNThe pilot's failure to ensure an adequate fuel supply for the flight, which resulted in fuel exhaustion.NTSB MIA93FA065Accident · 2 fatalField investigationFinal reportForney Ercoupe F-1 · Aguadilla, PRExcessive elevator control input by an unknown occupant at an airspeed above maneuvering speed which caused both forward wing spars to fail. Contributing to the accident was fuel exhaustion due to poor in flight planning/decision by the pilot-in-command and…NTSB MIA93LA064Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot-in-command's overconfidence in his own abilities and the subsequent failure of both engines due to fuel exhaustion. Contributing factors were the failure of the pilot to perform in-flight fuel consumption calculations, and the unsuitable terrain for…NTSB LAX93LA191Accident · No injuriesLimited investigationFinal reportBeech F35 · Sandy Valley, NVThe pilot's failure to perform a preflight inspection of the airplane, and to assure that an adequate supply of fuel was on board the aircraft. This subsequently led to an inadequate fuel supply in the left tank, and fuel starvation. A factor related to the…NTSB MIA93LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Ruskin, FLThe failure of the pilot-in-command to monitor fuel quantity resulting in an engine failure due to fuel exhaustion.NTSB MIA93LA061Accident · No injuriesLimited investigationFinal reportHughes 269A · Jacksonville, FLThe failure of the pilot-in-command to monitor fuel quantity due to inattentiveness. Contributing to the accident was the improper use of the collective flight control during the soft field autorotation.NTSB ATL93LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe poor preflight planning by the pilot.NTSB BFO93LA024Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Lanham, MDThe blockage of the right and left fuel vent line which prevented the flow of fuel to the engine causing total power loss.NTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.NTSB LAX93LA107Accident · Serious injuriesLimited investigationFinal reportBell 206B · Parks, AZ1) The pilot not obtaining forecast weather for his route of flight nor his destination 2) the pilot's inflight decision to fly into snow with the helicopter's engine air induction particle separator kit not installed, as required by the Bell 206B pilot's…NTSB DEN93LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Durango, COPower loss due to water contaminated fuel. A factor was: unsuitable terrain for a forced landing.NTSB CHI93LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo, MOThe pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB CHI93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Lineville, IACarburetor ice as a result of the pilot-in-command's improper use of carburetor heat.NTSB ATL93LA052Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Mebane, NCThe pilot's mismanagement of the fuel supply which resulted in fuel starvation to the engine.NTSB FTW93LA071Accident · Minor injuriesLimited investigationFinal reportKeller Varieze · Portland, TXA loss of engine power due to carburetor icing and the lack of suitable terrain for a forced landing.NTSB SEA93LA051Accident · No injuriesLimited investigationFinal reportBeech 58P · Hanksville, UTAn improper fuel selector valve position, fuel starvation, and inadequate remedial action. Factors include soft, rough terrain.NTSB ATL93LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe pilot became lost and exhausted the airplane fuel supply.NTSB BFO93FA018Accident · 1 fatalField investigationFinal reportCessna 182P · Stow, MAAn inadequate preflight by the pilot, which allowed water contamination in the fuel and subsequent loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall.NTSB MIA93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Tampa, FLPoor in-flight planning/decision by the CFI resulting in the total loss of engine power from both engines due to fuel exhaustion.NTSB MIA93LA046Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Holly Springs, MSThe pilot-in-command's failure to maintain airspeed while maneuvering during a forced landing, resulting in an in-flight loss of control (stall), and subsequent collision with terrain. Contributing to the accident was a total loss of engine power in flight…NTSB ANC93LA025Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Nome, AKFuel starvation due to improper refueling procedures by the FBO personnel, inadequate preflight by the pilot, and resultant ice in the fuel, which blocked fuel flow to the engines. A factor was the lack of suitable terrain for a forced landing.NTSB ATL93LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Roanoke Rapids, NCThe pilot-at-control's failure to use carburetor heat resulting in a loss of engine power due to carburetor ice. A factor which contributed to the accident was weather conducive to carburetor ice.NTSB LAX93LA089Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Gorman, CA1) The carburetor inlet fuel line being improperly installed by maintenance personnel which allowed the carburetor to become contaminated with metal particles, and 2) the carburetor float valve being jammed by metal particles which allowed excessive fuel to…NTSB LAX93LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Concord, CAThe engine manufacturer failing to properly install tab washers during overhaul which resulted in one bolt becoming loose and being ingested through various engine gear drives. The ingestion and loose oil pump cover resulted in the engine running rough and a…NTSB ATL93LA044Accident · No injuriesLimited investigationFinal reportCessna 182A · New Ellenton, SCInadequate preflight planning and preparation by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Factors were trees in the emergency landing area.NTSB ATL93LA043Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Smithville, TNThe failure of the pilot to follow pilot manual procedures by slipping the aircraft with inadequate fuel available, which resulted in fuel starvation. Factors were the inadequate fuel supply on the aircraft and the failure of the pilot to refuel.NTSB NYC93LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Bowling Green, KYThe pilot's inadequate inflight planning and decision which resulted in fuel exhaustion and the loss of engine power.NTSB FTW93LA057Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Weatherford, TXAn engine failure for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB FTW93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Slaton, TXThe total loss of engine power due to fuel starvation as a result of improper fuel tank selection. A factor the unsuitable terrain.NTSB LAX93LA072Accident · No injuriesLimited investigationFinal reportCessna 180K · Fullerton, CAThe airplane's owners (including the pilot) poor maintenance and the pilot's inadequate preflight inspection. Contributing to this accident was the deteriorated overwing fuel caps seals and the tailwind.NTSB NYC93LA050Accident · Serious injuriesLimited investigationFinal reportBeech F-35 · Collegeville, PAThe pilot's failure to follow the before landing check list in the pilot operators handbook in not selecting the fullest fuel tank for landing, which resulted in fuel starvation and subsequent engine failure.NTSB FTW93LA053Accident · No injuriesLimited investigationFinal reportCessna 210L · Allen, TXThe pilot's improper fuel tank selection and the subsequent loss of engine power due to fuel starvation. A factor was the lack of suitable terrain.NTSB CHI93LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Bend, WITotal loss of engine power due to the failure of the pilot to select the fuel tank with the most fuel.NTSB SEA93LA044Accident · No injuriesLimited investigationFinal reportCessna 414A · Rexburg, IDThe pilot did not select the remaining fuel supply. Factors include a deteriorated fuel selector valve.NTSB NYC93LA048Accident · No injuriesLimited investigationFinal reportCessna 182 · Readington, NJThe pilot's improper use of carburetor heat which resulted in the formation of carburetor ice.NTSB MIA93FA031Accident · 5 fatalField investigationFinal reportBeech 65 · Orlando, FLThe pilot's failure to feather the propeller to maintain altitude following a loss of power of the left engine. The power loss was due to an improperly maintained fuel system. In addition, the right engine lost power for an undetermined reason(s).NTSB LAX93LA070Accident · No injuriesLimited investigationFinal reportBeech C24R · Oakland, CAFuel starvation due to improper fuel system management by both pilots and the failure of the flight instructor to adequately supervise the conduct of the flight.NTSB LAX93LA069Accident · 1 fatalLimited investigationFinal reportLydick LONG-EZ · Tucson, AZThe pilot's failure to maintain an airspeed or power setting sufficient to maintain engine rotation during the low speed demonstration. A factor in the accident was the insufficient altitude to affect an engine restart once the propeller stopped turning.