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 DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.NTSB LAX00LA265Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Las Vegas, NVThe pilot's failure to refuel the airplane and his improper fuel consumption calculations.NTSB ANC00LA090Accident · No injuriesLimited investigationFinal reportMaule ML-5 · Wasilla, AKThe pilot's improper use of the fuel tank selector, resulting in fuel starvation.NTSB LAX00LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Maria, CAThe pilot's failure to ensure that an adequate fuel supply was on board at last departure, which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane at the en route stop was also causal.NTSB LAX00LA257Accident · Minor injuriesLimited investigationFinal reportInteravia E-3 · Watsonville, CAthe total loss of engine power due to the pilot's inaccurate fuel consumption calculations, which resulted in fuel exhaustion.NTSB ANC00LA084Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was rough/uneven terrain.NTSB IAD00LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dansville, NYthe loss of engine power during take-off for undetermined reasons.NTSB IAD00LA057Accident · Serious injuriesLimited investigationFinal reportCessna 172G · North Elba, NYthe pilot's inaccurate fuel consumption calculations and exhaustion of his fuel supply.NTSB FTW00LA204Accident · No injuriesLimited investigationFinal reportCessna 402A · Del City, TXthe total loss of engine power on both engines during cruise due to fuel starvation as a result of the pilot's improper use of the fuel selectors. Contributing factors were the pilot's lack of familiarity with the aircraft, and the lack of suitable terrain…NTSB FTW00LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Leonard, TXThe inadvertent stall. A factor was the improperly positioned fuel selector.NTSB SEA00LA122Accident · No injuriesLimited investigationFinal reportCessna 150L · Nampa, IDThe pilot's improper use of the mixture control.NTSB CHI00FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Brownton, MNIn flight collision with the terrain for undetermined reason.NTSB MIA00LA204Accident · No injuriesLimited investigationFinal reportSpurgeon Avid Bandit · Columbus, MSthe owner/builder's improper installation that resulted in the fuel line being snagged, resulting in fuel starvation and an inflight loss of engine power and subsequent damage to the airplane during the forced landing.NTSB MIA00LA197Accident · No injuriesLimited investigationFinal reportCessna A188B · Belzoni, MSThe pilot's failure to refuel prior to departure resulting in loss of engine power due to fuel exhaustion.NTSB FTW00LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · San Antonio, TXThe flight instructor's failure to refuel the airplane, which resulted in fuel exhaustion. Contributing factors were the flight instructor's fatigued condition and diverted attention.NTSB CHI00LA176Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Joliet, ILthe failure of the pilot to obtain fuel and the inadequate preflight planning and preparation by the pilot. Factors to the accident were the fuel exhaustion and the ravine at the end of the runway.NTSB SEA00LA117Accident · No injuriesLimited investigationFinal reportHughes 369D · Heyburn, IDFuel exhaustion and inaccurate fuel management. A false indication on the fuel quantity gage, and an erratic low level fuel warning system were factors.NTSB FTW00LA186Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hondo, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for the forced landing.NTSB NYC00LA174Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Springdale, OHThe pilot's inadequate preflight of the helicopter, and his subsequent failure to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, over unsuitable terrain.NTSB LAX00LA238Accident · No injuriesLimited investigationFinal reportWard Sidewinder · Madera, CAThe pilot's inadequate short field landing procedure and his delayed decision to proceed to an alternate destination, which resulted in fuel exhaustion and a subsequent hard landing during the emergency descent.NTSB ATL00LA065Accident · No injuriesLimited investigationFinal reportBeech 19B · Tampa, FLThe loss of engine power for undetermined reasons. A factor was the weather conditions were favorable for the formation of carburetor ice. Contributing to the severity of the accident was the pilots lack of experience in the airplane which led to an…NTSB LAX00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Selma, CAThe pilot's inadequate preflight planning that resulted in fuel exhaustion and subsequent collision with grapevines during an off airport forced landing.NTSB SEA00LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Vancouver, WAThe pilot's failure to determine the aircraft's airworthiness before flight, resulting in operation of the aircraft in an unairworthy condition and consequent fuel starvation, and his subsequent failure to maintain adequate airspeed in an emergency turn back…NTSB DEN00LA113Accident · Minor injuriesLimited investigationFinal reportEnstrom 280CB · Ruidoso, NMthe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight planning. A contributing factor was the pilot's lack of experience in the model of helicopter.NTSB NYC00LA164Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Louisville, KYThe pilot's improper operation of the fuel selector.NTSB IAD00LA052Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Mansfield, NJThe pilot's failure to comply with published emergency procedures. A factor in the accident was the pilot's inadequate preflight planning which resulted in a take-off with the inadequate amount of fuel for the flight.NTSB LAX00LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Lodi, CAThe pilot's inaccurate fuel consumption calculations, his misjudged in-flight planning, and his failure to flare during the landing attempt. A factor was the pilot's improper preflight inspection when he refueled the airplane.NTSB CHI00LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Bethalto, ILthe improper in-flight decision of the pilot to fly past the Vandalia airport onto Saint Louis Regional and the fuel exhaustion. A factor was the ditch.NTSB NYC00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172R · West Milford, NJA loss of engine power for undetermined reasons.NTSB IAD00LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE-55 · Erie, PAthe pilot's improper fuel management which resulted in fuel starvation and a loss of power to both engines. A factor was the pilot's inadequate pre-flight planning and takeoff with inadequate fuel for the flight.NTSB CHI00LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Indianapolis, INThe improper in-flight decision of the pilot not to land at the nearest airport at the first loss of engine power. Factors to the accident were fuel exhaustion, the excessive fuel flow, and the airport perimeter fence.NTSB ATL00LA062Accident · Serious injuriesLimited investigationFinal reportDaniel J. Zoerb Kitfox · Spruce Pine, NCA total loss of engine power due to carburetor icing conditions. A factor was the mountainous, unsuitable terrain on which to make a forced landing.NTSB ANC00LA066Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's improper positioning of the fuel tank selector, and fuel starvation. A factor in the accident was the improper service of the airplane's hydraulic brake system.NTSB LAX00LA222Accident · No injuriesLimited investigationFinal reportMooney M20D · Baker, CAThe fuel flow became restricted by remnants of fuel tank sealant that had accumulated in the fuel selector screen. Contributing to the pilot's inability to restart the engine in flight was the empty fuel tank in the left wing and the fuel gauge indication.…NTSB FTW00LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sugar Land, TXThe pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA105Accident · Minor injuriesLimited investigationFinal reportFroelich Lancair IV · Bountiful, UTThe loss of power for undetermined reasons and the pilot's unsuccessful remedial action (dive to avoid the power line). Contributing factors were the power line, the tires and the fence.NTSB FTW00LA170Accident · No injuriesLimited investigationFinal reportAero Commander 700 · Breckenridge, TXFuel exhaustion as a result of an inaccurate fuel quantity indicating system. A factor was the lack of suitable terrain for the forced landing.NTSB CHI00LA153Accident · Minor injuriesLimited investigationFinal reportEaton Acro Sport I · Malden, MOthe water contamination of the fuel system and the inadequate preflight of the airplane by the pilot. The inoperative fuel system drain was a contributing factor. The wheat was a contributing factor.NTSB DEN00LA101Accident · Minor injuriesLimited investigationFinal reportSchumacher Swearingen SX-300 · Richfield, UTFuel starvation due to the unavailability of fuel to the engine for undetermined reasons and the pilot's misjudgment of distance/altitude on final approach. Contributing factors were the pilot's premature gear extension and the berm.NTSB FTW00LA263Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKThe pilot's improper setting of the cockpit fuel selector, which resulted in a total loss of engine power and forced landing.NTSB MIA00FA177Accident · 2 fatalField investigationFinal reportBeech C23 · Smyrna, TNThe failure of the dual student to maintain airspeed following total loss of engine power resulting in an inadvertent stall and subsequent uncontrolled descent. Also, inadequate supervision by the CFI for her failure to note the position of the fuel selector…NTSB IAD00LA045Accident · No injuriesLimited investigationFinal reportBeech A-36 · Bedford, MAthe pilot's improper fuel management which resulted in fuel starvation.NTSB DCA00MA052Accident · 19 fatalClass 1 · MajorFinal reportBritish Aerospace J-3101 · Bear Creek Town, PAThe flight crew’s failure to ensure an adequate fuel supply for the flight, which led to the stoppage of the right engine due to fuel exhaustion and the intermittent stoppage of the left engine due to fuel starvation. Contributing to the accident were the…NTSB MIA00LA162Accident · No injuriesLimited investigationFinal reportCessna A150M · Gainesville, GAThe pilot's failure to use proper soft field landing technique while attempting a forced landing to an open field following a loss of engine power which resulted in a hard landing. Factors in the accident were weather conditions conducive to formation of…NTSB DEN00LA090Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Boulder, UTThe pilot's failure to take timely remedial action when he realized a low fuel state. Factors were fuel exhaustion and low airspeed.NTSB NYC00LA137Accident · No injuriesLimited investigationFinal reportAnderson MA-18 · Pittsburgh, PAThe pilot's improper fuel management which resulted in the loss of power, and his improper flare during the forced landing, which resulted in a hard landing. Factors included a restricted fuel supply due to a design flaw in the header tank/fuel valve/supply…NTSB LAX00LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Casa Grande, AZThe student pilot's inadvertant movement of the fuel selector to the "off" positon when selecting the alternate tank, and the flight instructor's lack of verification that the fuel selector was in the proper position during the emergency procedure checklist.…NTSB LAX00LA193Accident · Minor injuriesLimited investigationFinal reportSikorsky S61A · Eureka, CAthe loss of power in all engines due to the pilot's inadequate in-flight decision to continue flight with fuel level below the landing minimums specified in the flight manual, which resulted in the unporting of the fuel supply line and fuel starvation. A…NTSB LAX00LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Marana, AZthe pilot's failure to refuel the airplane as required by the airplane's published flight manual resulting in a loss of engine power due to fuel starvation.NTSB DEN00LA083Accident · No injuriesLimited investigationFinal reportHughes 269C · Loveland, COThe pilot misjudged the run on landing during a full autorotation. Factors were a total loss of power for unknown reasons and soft terrain.