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 IAD01LA091Accident · Serious injuriesLimited investigationFinal reportDelbridge Rotorway Exec 162F · Carrollton, VApilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion.NTSB DEN01LA138Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Pueblo, COthe loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector position. A factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA276Accident · Serious injuriesLimited investigationFinal reportEfaw Casutt Sport Racer · Shell Lake, WIThe pilot's inadequate preflight planning/preparation and the misjudged flare that resulted in a hard landing. A factor to the accident was the loss of engine power due to fuel exhaustion.NTSB LAX01LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Hesperia, CAthe loss of engine power due to fuel exhaustion while maneuvering in an attempt to locate the runway. Contributing factors were the inadequate runway maintenance that resulted in inoperative runway edge lights, and the night light conditions.NTSB LAX01LA263Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and loss of engine power while on approach for landing.NTSB MIA01LA197Accident · No injuriesLimited investigationFinal reportCessna 182B · Headland, ALThe pilot's improper decision to perform a go-around while on short final to an available runway following loss of engine power for undetermined reasons when engine power was regained momentarily, which resulted in an impact with terrain while maneuvering at…NTSB SEA01LA144Accident · No injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA total loss of power for undetermined reasons and the pilot's misjudgment of distance and speed while maneuvering to a forced landing at a nearby airport. Contributing factors were the 8 knot tailwind and the fence which the aircraft impacted when it over…NTSB CHI01FA231Accident · 2 fatalField investigationFinal reportWorld Helicopters 47D1 · Ballard, MOThe pilot's improper preflight planning which resulted in fuel exhaustion, and the pilot's subsequent improper autorotation.NTSB FTW01LA166Accident · Serious injuriesLimited investigationFinal reportEurocopter BK117-C1 · Decatur, TXthe pilot's failure to follow the checklist and turn on the fuel transfer pumps, which resulted in fuel starvation and a dual loss of engine power while in cruise flight.NTSB NYC01LA176Accident · No injuriesLimited investigationFinal reportCessna 182 · Warren, OHThe pilot's failure to adequately manage the available fuel, which resulted in fuel starvation.NTSB FTW01LA162Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Caldwell, TXthe solo student pilot's intentional engine shutdown, while practicing emergency landing prodecures. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX01TA233Accident · No injuriesFinal reportCessna 150 · Delano, CAA bent mixture control valve stem shaft in the carburetor which made pilot control of the mixture inoperative resulting in excessive fuel consumption, and subsequent loss of engine power..NTSB ATL01LA070Accident · No injuriesLimited investigationFinal reportHughes 369A · Wadesboro, NCThe pilot's inadequate pre-flight planning which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was rough and uneven terrain.NTSB NYC01LA156Accident · No injuriesLimited investigationFinal reportPiper J3F-65 · Findlay, OHTwo chafed ignition switch leads, which resulted in a failure of the ignition system and subsequent total loss of engine power.NTSB NYC01LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rochester, NYFuel exhaustion, due to the student pilot's failure to monitor his fuel supply.NTSB ANC01LA074Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Soldotna, AKThe loss of engine power due to fuel exhaustion and the pilot's failure to refuel the airplane.NTSB FTW01LA150Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Winnsboro, TXthe loss of engine power during takeoff climb for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB CHI01LA179Accident · Serious injuriesLimited investigationFinal reportCessna T310P · St. Cloud, MNthe fuel starvation. Fuel management by the pilot was an additional cause. The muddy terrain was a contributing factor.NTSB LAX01LA213Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Burbank, CAFuel exhaustion while maneuvering during a banner tow flight due to an inadequate fuel supply. A factor was the pilot's improper preflight preparation.NTSB ATL01LA067Accident · No injuriesLimited investigationFinal reportCessna 172N · Colquitt, GAThe student pilot's failure to use the fuel selector valve properly which resulted in fuel starvation and the subsequent loss of engine power, and the pilot's improper flare during landing.NTSB LAX01FA212Accident · 1 fatalField investigationFinal reportSchultz Lancair IV-P · Flagstaff, AZthe builder's failure to install a fuel compartment vent in the right wing, affecting the total available fuel capacity, and resulting in the loss of engine power due to fuel starvation. A contributing factor was the pilot's intentional flight with a known…NTSB MIA01FA162Accident · 1 fatalField investigationFinal reportBeech C90 · Fort Lauderdale, FLthe pilot's failure to properly plan fuel consumption and to perform an en route refueling, resulting in a total loss of engine power due to fuel exhaustion while on downwind leg for landing at eventual destination, causing an emergency descent and collision…NTSB FTW01LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Oil Trough, ARthe pilot's failure to refuel the airplane which resulted in the loss of engine power due to fuel exhaustion. A contributory factor was the lack of suitable terrain for the forced landing.NTSB ANC01LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to refuel the airplane, his inadequate preflight planning/decision making, and subsequent fuel exhaustion during cruise flight.NTSB SEA01LA110Accident · No injuriesLimited investigationFinal reportCessna 172M · Pingree, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power.NTSB DEN01LA102Accident · No injuriesLimited investigationFinal reportCessna T207A · Kanab, UTthe pilot's inadequate fuel consumption planning, and the subsequent fuel starvation, which resulted in a loss of engine power.NTSB LAX01LA192Accident · No injuriesLimited investigationFinal reportCessna 150H · Mariposa, CAThe pilot's failure to properly refuel the aircraft which resulted in departure with an inadequate quantity of fuel onboard. A factor in the accident was the pilot's inadequate preflight preparation and planning, which failed to provide an adequate fuel…NTSB IAD01LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-310 · Uniontown, OHFuel exhaustion due to the pilot's failure to perform fuel calculations. A factor was the inboard fuel tank probes not being within the manufacturer's resistance limits, which resulted in inaccurate fuel gauges.NTSB NYC01FA127Accident · Serious injuriesField investigationFinal reportBeech C90 · Islip, NYThe pilot’s failure to activate the fuel transfer pumps in accordance with the check list, which resulted in fuel exhaustion.NTSB LAX01LA184Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Apple Valley, CAThe pilot's fuel mismanagement, which led to fuel exhaustion, a loss of engine power, and subsequent landing on unsuitable terrain.NTSB LAX01LA180Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Tucson, AZThe pilot's inadequate preflight inspection, which included verifying the position of the fuel selector handle, which subsequently led to fuel starvation and a forced landing.NTSB NYC01LA119Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Monson, METhe pilot's inadequate aircraft preflight inspection, which resulted in a total loss of engine power during climb due to fuel contamination.NTSB DEN01TA095Accident · No injuriesFinal reportHiller UH-12E · Conchas, NMthe pilot's misjudgment of the flare, which resulted in a hard landing. Contributing factors were weather conditions conducive to carburetor icing, the pilot's delay in applying carburetor heat, and his inattention to the carburetor air temperature gauge.NTSB NYC01LA118Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Brewer, METhe pilot's inadequate preflight preparation, which resulted in insufficient fuel in the forward tank and loss of engine power during the climb. Also causal, was the pilot's failure to maintain airspeed after the engine failure, which resulted in an…NTSB MIA01LA139Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Pierce, FLa loss of engine power due to fuel exhaustion which resulted in a forced landing, and subsequent impact with a sign and a ditch.NTSB ANC01LA054Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's failure to refuel the airplane, and subsequent fuel exhaustion. A factor in the accident was an inadvertent stall during an emergency descent/landing.NTSB NYC01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Paintsville, KYThe pilot's inadequate preflight inspection of the aircraft, which resulted in fuel exhaustion during cruise flight.NTSB FTW01LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Marfa, TXfuel exhaustion resulting in a total loss of engine power in cruise flight due to the pilot's failure to refuel the aircraft. Contributing factors were the lack of suitable terrain for the forced landing, and the dark night condition.NTSB MIA01LA136Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Wilmington, NCA total loss of engine power due to the failure of maintenance to properly secure the fuel selector cover, resulting in the pilot inadvertently selecting "off" instead of "left" tank, and the subsequent forced landing to uneven terrain.NTSB MIA01LA128Accident · No injuriesLimited investigationFinal reportSteen Aero Lab Skybolt I · Germantown, TNThe pilot's failure to conduct proper preflight planning and preparation, resulting in fuel exhaustion during cruise flight, and the subsequent emergency descent and forced landing to a residential street colliding with a vehicle, utility pole, mail box, and…NTSB LAX01LA157Accident · No injuriesLimited investigationFinal reportBell 206-L3 · Willcox, AZA loss of engine power due to the likely unporting of the fuel tank pickups as the helicopter was maneuvered to look at animals on the ground. Also causal was the pilot's misjudged touchdown point during an autorotational approach, which resulted in the…NTSB NYC01LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate fuel management, which resulted in fuel starvation.NTSB LAX01LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Flagstaff, AZThe loss of engine power during cruise flight for undetermined reasons that resulted in a forced landing in rough terrain.NTSB CHI01LA115Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180AC · Buffalo, MNthe water contamination of the aircraft's fuel system and the inadequate preflight performed by the pilot. The muddy terrain was a contributing factor.NTSB FTW01LA099Accident · No injuriesLimited investigationFinal reportCessna 150L · Iowa Park, TXfuel exhaustion during takeoff due to the pilot's failure to refuel.NTSB CHI01LA114Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Gary, INThe inadequate preflight performed by the pilot which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. Factors associated with the accident were the inaccurate fuel quantity indicator, the rock which resulted in the overload failure…NTSB FTW01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Pearland, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion while in the traffic pattern.NTSB FTW01LA096Accident · No injuriesLimited investigationFinal reportCessna T210M · Abilene, TXthe loss of engine power while on final approach due to fuel starvation as a result of the pilot's improper use of the fuel selector. A contributing factor was the elevated runway edge.NTSB FTW01LA093Accident · No injuriesLimited investigationFinal reportEmpson F4UCorsair · Baton Rouge, LAthe pilot's inadequate preflight planning resulting in fuel exhaustion during approach. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL01LA045Accident · Serious injuriesLimited investigationFinal reportCessna 182 P · Kennesaw, GAThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.