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 DEN04CA099Accident · No injuriesData collectionFinal reportCessna 172N · Laramie, WYfuel exhaustion due to the pilot's improper inflight decision not to stop and refuel. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB SEA04LA121Accident · No injuriesLimited investigationFinal reportExp Acft Assn Wi Chapter 60 Moni · Rochester, WAThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power during descent. Factors contributing to the accident included the pilot's lack of experience in the aircraft and the tree.NTSB NYC04LA151Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Morgantown, WVThe pilot's improper fuel management, which resulted in fuel starvation and a subsequent loss of engine power.NTSB NYC04LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrenceburg, KYThe pilot's decision to perform a negative g maneuver, which resulted in a loss of engine power due to fuel starvation.NTSB CHI04CA143Accident · No injuriesData collectionFinal reportCessna 150F · Forest Lake, MNThe pilot's inaccurate fuel consumption calculations which resultied in fuel exhaustion and loss of engine power. Factors associated with the accident were the dark light conditions and the water on which the forced landing was made.NTSB CHI04CA141Accident · Minor injuriesData collectionFinal reportDoerr Raymond R RV-9A · Fort Scott, KSThe vapor lock of the airplane fuel system and the ditch encountered during the emergency landing..NTSB CHI04CA135Accident · Minor injuriesData collectionFinal reportCessna T210L · Wichita, KSThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB DEN04LA077Accident · No injuriesLimited investigationFinal reportCessna 182E · Santa Teresa, NMthe pilot's inadequate in-flight planning and decision-making, which resulted in the loss of engine power due to fuel exhaustion. Contributing factors to the accident were the fuel exhaustion and the lack of suitable terrain for a forced landing.NTSB DEN04CA073Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Flagler, COthe pilot's improper in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. Factors contributing to the accident were the low altitude, low airspeed, and the inoperative fuel quantity gauge.NTSB CHI04CA122Accident · No injuriesData collectionFinal reportCessna 180J · South St. Paul, MNThe total loss of engine power during takeoff climb due to fuel starvation as a result of the pilot's failure to follow the aircraft's checklist and leaving the fuel selector in the OFF positon.NTSB LAX04LA210Accident · Minor injuriesLimited investigationFinal reportDowner Bellanca 14-19-2 · Lancaster, CAThe pilot's fuel mismanagement by his failure to follow the recommended procedures for operation of the auxiliary fuel tank, which resulted in fuel starvation and loss of engine power during cruise flight.NTSB ANC04LA053Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350B2 · Skagway, AKA loss of engine power during cruise flight for an undetermined reason, which resulted in a ditching and submersion of the helicopter when the emergency float system did not deploy. Factors contributing to the accident were improper rigging of the mechanical…NTSB SEA04LA080Accident · Minor injuriesLimited investigationFinal report2003 Nash Kitfox II · Broadview, MTFuel starvation during cruise flight for undetermined reasons. Unsuitable terrain for a forced landing was a factor.NTSB FTW04LA124Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fort Stockton, TXThe pilot's improper leaning of the fuel/air mixture in-flight, which resulted in a loss of engine power. Factor were the wind gusts and the crosswind.NTSB DEN04LA069Accident · Minor injuriesLimited investigationFinal reportBranham Vans RV-6 · Paragonah, UTThe pilot's inadequate preflight and in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. The berm and the pilot not stopping to refuel the airplane were contributing factors.NTSB NYC04LA111Accident · Serious injuriesLimited investigationFinal reportBlack Kitfox · Mount Sterling, KYThe loss of engine power due to blockage of the fuel filters resulting in fuel starvation. A factor in the accident was the inadequate maintenance inspection.NTSB DEN04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Lyons, COa loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing and the road sign.NTSB ATL04CA091Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Delco, NCThe flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation. A factor was the flight instructor's failure to use the checklist.NTSB ANC04LA045Accident · Serious injuriesLimited investigationFinal reportArctic S-1B2 · Big Lake, AKThe flight instructor's failure to insure that the carburetor heat was activated by the dual student following a simulated loss of engine power, which resulted in carburetor ice and the actual loss of engine power during a descent. A factor associated with…NTSB CHI04CA108Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Minneapolis, MNThe pilot not verifying the position of the fuel selector prior to the takeoff, resulting in the loss of engine power during initial climb due to fuel starvation. Factors to the accident were the power pole and the trees.NTSB SEA04LA071Accident · Serious injuriesLimited investigationFinal reportKeller Prospector FK1 · Gibbonsville, IDThe pilot's failure to apply carburetor heat in icing conditions which resulted in a loss of engine power while in cruise flight. Factors contributing to the accident are unsuitable terrain for an emergency landing , trees and mountainous terrain.NTSB NYC04CA108Accident · Serious injuriesData collectionFinal reportAndrews Zenith Tri-Z · Kennedy, NYThe pilot's improper fuel tank selector position which resulted in a loss of engine power due to fuel starvation.NTSB CHI04CA105Accident · Minor injuriesData collectionFinal reportCessna A185E · Hastings, MNThe pilot not verifying the fuel selector valve's position during the preflight leading to the fuel starvation and subsequent loss of engine power during the flight's initial climb.NTSB MIA04LA071Accident · Serious injuriesLimited investigationFinal reportBeech Be-300 · Daytona Beach, FLThe pilot's inadequate management of the airplane's fuel system, which resulted in fuel starvation, a loss of engine power, a forced landing, and damage to the airplane during the landing.NTSB FTW04LA116Accident · No injuriesLimited investigationFinal reportCessna 150 · Magnolia, ARThe pilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX04CA181Accident · No injuriesData collectionFinal reportPiper PA-38-112 · McKinleyville, CAa loss of engine power due fuel exhaustion, which was caused by the pilot's inadequate in-flight planning/decision, inadequate in-flight fuel consumption calculations, and failure to divert to an alternate airport before the fuel situation became critical.…NTSB IAD04CA014Accident · Minor injuriesData collectionFinal reportCessna 152 · Hamilton, OHThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power. The student pilot becoming lost/disoriented is a contributing factor.NTSB CHI04LA099Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Big Rapids, MIThe total loss of engine power due to the pilot's improper fuel management which led to fuel starvation.NTSB FTW04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Georgetown, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN04LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Orem, UTthe pilot's improper in-flight planning and decision making, resulting in fuel exhaustion and the loss of engine power. Contributing factors include the dark night light conditions, and the trees.NTSB ATL04LA088Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbia, SCThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion. The pilot's preflight planning and uneven terrain were contributing factors.NTSB LAX04CA173Accident · No injuriesData collectionFinal reportPiper PA34-200 · La Verne, CAthe CFI 's failure to correctly reconfigure the right engine fuel selector, resulting in a total loss of power to that engine. Also causal was the CFI's failure to maintain direction control of the airplane and an adequate airspeed, which led to the airplane…NTSB CHI04CA091Accident · No injuriesData collectionFinal reportCessna C-180 · Aberdeen, SDThe pilot's improper fuel management due to his delay in transferring auxiliary fuel which resulted in exhaustion of fuel from the main fuel tanks. The excessive fuel flow for undetermined reasons, the road embankment, the inaccurate fuel level indicators,…NTSB SEA04LA052Accident · No injuriesLimited investigationFinal reportCessna 172N · Creswell, ORThe pilot's attempting takeoff with the fuel selector in the OFF position resulting in fuel starvation. Contributing factors were the change in habit pattern and expectancy of the fuel selector position as well as the fence and tree.NTSB ANC04LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Palm Beach, FLThe incorrect assembly of the fuel selector valve by maintenance personnel, and the pilot's failure to make a precautionary landing to assess the fuel situation and lack of movement of the right fuel tank indicator. which resulted in fuel starvation and the…NTSB ANC04FA042Accident · 2 fatalField investigationFinal reportCessna 150C · DeLand, FLThe pilot's failure to detect water in the fuel system during the preflight inspection, which precipitated a loss of engine power during initial climb, and his failure to maintain adequate airspeed resulting in a stall.NTSB LAX04LA158Accident · No injuriesLimited investigationFinal reportQuinn E L Tom Cat MK-5A · Galt, CAa loss of engine power due to water contamination of the fuel system.NTSB LAX04CA153Accident · No injuriesData collectionFinal reportAyres S2R-600 · Calipatria, CAthe failure of ground personnel to refuel the airplane with the proper fuel grade/octane, resulting in the airplane's loss of engine power. Also causal was the pilot's failure to detect the fuel problem during a preflight inspection.NTSB ATL04LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe CFI's inadequate in-flight planning/decision and his inadequate supervision which resulted in fuel exhaustion. A factor was the inadequate preflight planning/preparation to ensure an adequate fuel supply, and the berm.NTSB NYC04LA082Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Frederick, MDTotal loss of engine power for undetermined reasons.NTSB FTW04CA084Accident · Minor injuriesData collectionFinal reportCessna T210M · Grape Creek, TXThe pilot's improper in-flight planning, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain available for the forced landing.NTSB ANC04LA027Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Bradenton, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's failure to maintain adequate rotor speed, resulting in a hard landing.NTSB DEN04LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Parowan, UTthe pilot's in-flight decision/planning which resulted in fuel exhaustion. The fence and night conditions were contributing factors.NTSB LAX04CA117Accident · No injuriesData collectionFinal reportCessna A185F · Fowler, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply. A factor in the accident was the pilot's lack of familiarity with the airplane.NTSB LAX04LA111Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Goodyear, AZThe pilot's inadequate fuel consumption calculations and in-flight planning/decision, which resulted in fuel exhaustion.NTSB DEN04LA040Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's improper in-flight planning/decision making and his failure to maintain adequate airspeed which resulted in fuel starvation/exhaustion and a stall spin.NTSB CHI04LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Corydon, INThe student pilot become lost during the cross country flight and the instructor's inadequate supervision of both the flight and preflight planning. This led to the in-flight loss of engine power due to fuel exhaustion, a forced landing, and impact with…NTSB ATL04FA069Accident · 1 fatalField investigationFinal reportCessna 182A · Traphill, NCThe loss of engine power due to carburetor ice. Contributing factors were conditions conducive for carburetor icing.NTSB NYC04LA057Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Bradford, PAA total loss of engine power for undetermined reasons during approach.NTSB IAD04LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-44 · Prospect, PAThe flight instructor's improper in-flight decision, which included an inappropriate altitude selection for intentional single engine operation. Factors were the inability of the flight instructor to restart the right engine for undetermined reasons, and the…