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 NYC90LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Franklin Center, PALoss of engine power for an undetermined reason and the failure of the pilot to maintain airspeed during a forced landing which restuled in an inadvertent stall.NTSB CHI90DEK06Accident · No injuriesFinal reportCessna 175 · Zanesville, OHThe pilot's failure to properly prelfight the airplane which resulted in an inadequate fuel supply and subsequent fuel exhaustion.NTSB MKC90LA134Accident · No injuriesLimited investigationFinal reportWeatherly 201-B · Stuttgart, ARFuel exhaustion induced power loss caused by the pilot's failure to refuel the airplane.NTSB ATL90LA130Accident · No injuriesLimited investigationFinal reportCessna 150 · Kinston, NCFlight crew's failure to properly preflight and plan for the intended flight by not ensuring that adequate fuel was on board prior to takeoff. The engine quit due to fuel exhaustion.NTSB FTW90DPA07Accident · No injuriesFinal reportAyres S2R · Mcgregor, TXThe fuel exhaustion induced power loss, which resulted from the pilot's inaccurate fuel consumption calculations.NTSB ATL90LA129Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Hartford, KYImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB SEA90LA095Accident · 1 fatalLimited investigationFinal reportGrace Long EZ · La Grande, ORLoss of engine power due to fuel contamination which resulted from the pilot's inadequate preflight inspection of the aircraft.NTSB CHI90DEV06Accident · Minor injuriesFinal reportCessna 210 · Salem, ILImproper positioning of the fuel selector by the pilot, which resulted in fuel starvation, and the pilot's improper emergency procedure.NTSB ANC90FA086Accident · 1 fatalField investigationFinal reportPiper PA-32 · Bethel, AKThe pilot's failure to maintain airspeed during an emergency landing following an engine power loss. The loss of engine power was due to an improper fuel selector position which resulted in fuel starvation. A contributing factor was the pilot's decision to…NTSB DEN90LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Las Cruces, NMThe fuel exhaustion induced power loss. Factors were the failure of the pilot to refuel and the high vegetation in which the forced landing was performed.NTSB MKC90LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Milford, IAFuel exhaustion due to misjudged fuel consumption calculations by the pilot in command, and a forced landing to a field with a hidden obstruction.NTSB MKC90LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSPoor pre-flight and in-flight planning and refueling not performed by the pilot in command.NTSB DEN90LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Belgrade, MTThe inadvertent stall experienced during the attempted forced landing.NTSB SEA90LA092Accident · No injuriesLimited investigationFinal reportCessna 182A · Tekoa, WAThe pilot turned off the carburetor heat while descending for landing in conditions conducive to carburetor icing.NTSB LAX90DVG09Accident · No injuriesFinal reportCullen/Roth Falcon XP · Yountville, CAThe pilot's misjudgement of fuel supply.NTSB CHI90LA147Accident · No injuriesLimited investigationFinal reportCessna C205 · Anderson, INThe pilot's encounter with unsuitable terrain during the landing roll after a forced landing. Contributing factors in this accident were the total powerplant failure and the IFR weather conditions which limited the landing site selection.NTSB CHI90LA143Accident · No injuriesLimited investigationFinal reportCessna 172N · Northwood, OHThe pilot's improper in-flight planning/decision, which resulted in an off-airport landing, when the engine lost power due to fuel exhaustion. The fact that the engine lost power over a populated area was a factor in this accident.NTSB ANC90LA081Accident · No injuriesLimited investigationFinal reportMaule M4 · L. Susitna Riv, AKThe pilot's fuel mismanagement in not having sufficient fuel to reach his destination.NTSB CHI90LA139Accident · No injuriesLimited investigationFinal reportBeech B-55 · Detroit, MIThe pilot in command's execution of a turn shortly after takeoff resulting in loss of engine power due to fuel starvation and the pilot in command's execution of a turn back to the airport resulting in fuel starvation of the second engine which resulted in a…NTSB LAX90LA197Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Apache Junction, AZFailure of the pilot in command to properly manage the aircraft fuel quantity gauge indication and failure to complete the proper emergency procedure by switching fuel tanks. Contributing to the accident was improper maintenance performed by the pilot which…NTSB MKC90LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Ashland, KSA power plant failure for undetermined causes.NTSB LAX90LA196Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Brentwood, CAThe pilot improperly calculated the fuel consumption causing the airplane to sustain a total loss of power due to fuel exhaustion.NTSB LAX90LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Fullerton, CAFuel starvation due to the pilot's improper fuel management technique. A factor was the improperly modified fuel selector valve.NTSB CHI90DEK05Accident · Minor injuriesFinal reportCessna 172 · Urbana, OHWater contamination of the fuel, and the pilot's inadequate preflight, which resulted in loss of engine power.NTSB MKC90LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Creve Coeur, MOFuel contamination and inadequate preflight.NTSB NYC90LA119Accident · Minor injuriesLimited investigationFinal reportGrumman American AA5-A · Plainfield, MAThe pilot's failure to switch the fuel selector to the proper tank. A factor to the accident was the high obstructions near the field.NTSB LAX90LA183Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Santa Ynez, CAThe pilot's failure to properly preflight the aircraft and secure the fuel system caps which resulted in fuel siphoning and loss of engine power.NTSB DEN90DTG01Accident · No injuriesFinal reportAdams Boredom Fighter · Finley, NDA power loss due to fuel exahustion and the pilot's inadequate fuel planning. A factor was the ditch in which touchdown occurred.NTSB LAX90LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fresno, CAFuel exhaustion due to the pilot's inadequate pre-flight planning.NTSB ATL90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Woodstock, GAAn inadequate preflight.NTSB MKC90LA109Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Searcy, ARPilot impairment from consumption of alcohol, inadequate preflight by the pilot, and fuel contamination with water and dirt (mud) in the system.NTSB LAX90LA178Accident · Serious injuriesLimited investigationFinal reportBeech H35 · San Marcos, CAThe pilot's improper fuel management.NTSB LAX90LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mesa, AZThe pilot-in-command's failure to maintain safe airspeed and inadvertent stall. Contributing to the accident was the pilot's misjudging fuel supply.NTSB CHI90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Anderson, INThe pilot-in-command failed to select the fuel valve to a tank containing usable fuel resulting in fuel starvation.NTSB MIA90LA119Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Shelby, MSThe pilot's inadequate preflight planning and attempted flight with insufficient fuel on board to complete the flight.NTSB ATL90FA110Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Hilton Head, SCThe pilot's mismanagement of the fuel system through inadvertant selection of the 'off' position of the fuel selector valve handle.NTSB SEA90LA075Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Pomeroy, WAA malfunctioning fuel injection system and the pilot's attempted operation above certificated maximum gross weight with a known deficiency in this equipment.NTSB FTW90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jacksonville, TXA fuel exhaustion induced power loss during the initial climb after takeoff.NTSB ATL90LA106Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cartersville, GAThe pilot's improper use of the engine fuel mixture control which resulted in fuel exhaustion.NTSB LAX90LA160Accident · No injuriesLimited investigationFinal reportPiper PA30 · Sedona, AZThe pilot's mismanagement of the fuel system.NTSB BFO90LA041Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Brookneal, VAThe pilot's improper preflight and improper in-flight planning/decision. Pilot fatigue was a related factor.NTSB LAX90LA159Accident · No injuriesLimited investigationFinal reportCessna 182L · Bullhead City, AZThe pilot's preflight planning/preparation and fuel calculations were poor.NTSB FTW90DPA02Accident · No injuriesFinal reportCessna A188B · Perry, TXThe total loss of engine power as a result of water contamination of the fuel supply. A factor was the unsuitable terrain in which the pilot had to make the forced landing.NTSB NYC90LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Tinton Falls, NJThe failure of the student pilot to ensure there was sufficient fuel on board for the planned flight. A factor related to the accident was the failure of the flight instructor to properly prepare his student for the flight.NTSB MKC90LA097Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Little Rock, ARPilot in command's failure to refuel the airplane, which resulted in fuel exhaustion. Related to the accident was: unsuitable terrain in the emergency landing area.NTSB MIA90LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Isla Grande, PRImproper use of carburetor heat by the pilot, which resulted in carburetor ice. The weather (carburetor icing condition) was a related factor.NTSB LAX90LA156Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Apple Valley, CAFuel contamination and the pilot's failure to maintain airspeed while maneuvering.NTSB FTW90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA28-235 · Granbury, TXFuel starvation due to the pilot's disregard for the position of the fuel tank selector.NTSB NYC90DNA02Accident · No injuriesFinal reportBell 47G5 · Marion, MAImproper use of carburetor heat by the pilot resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.NTSB MKC90LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Allport, ARImproper use of carburetor heat by the pilot. Contributing factors were carburetor icing conditions, power lines and visual outlook inadequate by the pilot.