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 LAX91LA193Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Yuma, AZThe failure of the pilot-in-command to perform fuel consumption calculations which resulted in a total loss of engine power due to fuel exhaustion.NTSB CHI91LA146Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Ann Arbor, MILoss of engine power due to carburetor ice, and the pilot's failure to use carburetor heat. Factors related to the accident were: carburetor icing conditions, and a false indication from the carburetor air temperature gage.NTSB ANC91LA054Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Beluga, AKThe engine failure due to undetermined causes. Contributing to the accident was the unsuitability of the available landing area.NTSB FTW91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Longview, TXFuel exhaustion resulting in a complete power loss due to the pic/cfi's failure to refuel at intermediate destinations.NTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.NTSB DEN91LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Steamboat Sprin, COThe CFI used poor judgement in giving a simulated engine failure by turning off the fuel selector valve.NTSB CHI91FA135Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Wadsworth, ILThe pilot in command's failure to select the proper fuel tank and not performing emergency procedures when the engine ceased to run. A factor related to this accident was power transmissions wires located on the pilot's approach path to landing.NTSB SEA91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Auburn, WAAn improper fuel selector valve handle, improper selection of the fuel selector position, and the pilot's lack of understanding of the fuel selector position.NTSB CHI91DCJ02Accident · No injuriesFinal reportFagerberg Longeze · Wahoo, NEThe improper installation/maintenance of the carburetor heat control. A factor was the pilot's restricted visual outlook.NTSB ATL91LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Elberta, ALThe pilot's failure to apply carburetor heat. Factors were weather conditions for the formation of induction ice, and the soft terrain.NTSB CHI91DER03Accident · 1 fatalFinal reportVarieze 001 · Superior, WIThe pilot's poor planning and decision making which resulted in a loss of engine power due to fuel exhaustion.NTSB LAX91LA175Accident · Serious injuriesLimited investigationFinal reportSnider RV6 · Paulden, AZThe pilot's poor preflight preparation and his failure to ensure that the fuel selector was properly positioned for flight.NTSB LAX91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA22-150 · Las Vegas, NVThat the pilot improperly selected the fuel tank that did not contain any fuel and his subsequent failure to maintain airspeed.NTSB LAX91LA176Accident · Serious injuriesLimited investigationFinal reportGrumman AA-LC · Inyokern, CAPoor flight planning by the pilot-in-command which resulted in a total loss of engine power due to fuel exhaustion.NTSB ATL91LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Whiteville, NCCarburetor ice due to the pilot's failure to use carburetor heat.NTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.NTSB LAX91LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Madera, CAThat the pilot's fuel consumption calculation were inaccurate. Contributing to this accident was fuel exhaustion.NTSB CHI91DEP04Accident · Minor injuriesFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot in command's failure to refuel the aircraft prior to departure. A factor contributing to the accident was the unporting of the fuel pick up line in fuel tank during abrupt or negative 'g' maneuvers.NTSB LAX91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA 46 · North Hollywood, CAThe pilot-in-command's poor preflight planning, inadequate fuel consumption calculations which resulted in a loss of engine power due to fuel exhaustion, and the pilot-in-command's failure to follow air traffic control verbal instructions which would have…NTSB NYC91LA109Accident · No injuriesLimited investigationFinal reportCessna 150E · Walkill, NYAn inflight collision with terrain during an uncontrolled descent after the pilot parachuted from the airplane. Contributing to the accident were fuel exhaustion and the pilot's disregard for emergency procedures.NTSB LAX91LA161Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · Burbank, CAThat the pilot failed to properly preflight the airplane and miscalculated the airplane's fuel consumption. Contributing to this accident was fuel exhaustion.NTSB CHI91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Oskosh, WIRefueling not performed resulting in loss of engine power due to fuel exhaustion. Factors related to the accident were misjudged fuel consumption calculations and non suitable terrain.NTSB LAX91LA158Accident · Minor injuriesLimited investigationFinal reportGlasair III SH-3R · Mesa, AZThe mismanagement of the airplane's fuel supply by the pilot and his failure to select a fuel tank containing sufficient fuel for flight which resulted in fuel starvation.NTSB LAX91FA156Accident · 2 fatalField investigationFinal reportHerbert W. Ross RV-4 · Santa Paula, CAThat the pilot inadvertently selected the wrong fuel tank and the passenger interfered with the flight controls when the seat back failed.NTSB ANC91LA044Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kotzebue, AKFuel contamination (water) in both fuel tanks and fuel lines.NTSB ANC91LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Alexander Creek, AKThe engine failure resulting from fuel screen contamination . A factor was the lack of suitable terrain for the forced landing.NTSB LAX91LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lake Elsinore, CAUndetermined engine power loss. A factor ws the soft terrain.NTSB LAX91LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Jean, NVFuel starvation due to the improper fuel management (positioning of the fuel selector) by the pilot, and his improper emergency procedures. The pilot's lack of experience in this make and model of aircraft was a related factor.NTSB SEA91FA073Accident · 1 fatalField investigationFinal reportPiper PA-30 · Butte, MTInadequate inflight decisions, fuel starvation, and failure to perform alternative IFR approach procedures. Factors include operation with known deficiencies in equipment, disorientation, and lack of familiarity with the geographic area.NTSB SEA91FA069Accident · 2 fatalField investigationFinal reportCessna 150G · Kennewick, WAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to maintain adequate airspeed, while maneuvering to make a forced landing, which resulted in a stall.NTSB BFO91LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Martinsburg, WVFuel exhaustion which resulted in the loss of engine power.NTSB ATL91LA072Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Greer, SCThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB CHI91FA116Accident · 1 fatalField investigationFinal reportMooney M-20C · Prior Lake, MNFailure to maintain airspeed while executing a forced landing. Factors related to the accident were the pilot's improper inflight planning/decision, and fuel exhaustion.NTSB NYC91LA093Accident · No injuriesLimited investigationFinal reportCessna 150L · Chambersburg, PACarburetor ice and the pilot's improper use of carburetor heat. A factor related to the accident was: carburetor icing (weather conditions).NTSB LAX91LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Phoenix, AZThe decision of the flight instructor to conduct a simulated power failure emergency in a manner which was inappropriate.NTSB FTW91FA055Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Pasadena, TXPower loss due to fuel exhaustion resultant from the pilot's failure to refuel at an alternate destination and the inadvertent stall. Factors were the dark night and weather conditions.NTSB MIA91LA103Accident · No injuriesLimited investigationFinal reportCessna 150L · Miami, FLTotal loss of engine power due to inadvertent use of the mixture control by the student, inadequate supervision by the CFI, and delayed remedial action by the CFI resulting in the off airport landing.NTSB LAX91LA136Accident · No injuriesLimited investigationFinal reportCessna T207A · Las Vegas, NVFuel exhaustion due to fuel siphoning in flight from an unsecured filler cap. The inaccurate preflight inspection of the aircraft by the pilot was also causal in this accident.NTSB ATL91FA064Accident · Serious injuriesField investigationFinal reportPiper PA-34-220T · Lawrenceville, GAThe poor inflight planning by the pilot which resulted in fuel exhaustion. Factors related to this accident were the unfavorable winds, the dark night, and the inoperable airport runway lights.NTSB LAX91LA127Accident · No injuriesLimited investigationFinal reportBell 206B · Honolulu, HIInaccurate fuel consumption calculation by the pilot. A factor was the partial deflation of the emergency flotation equipment.NTSB ANC91IA039Incident · No injuriesIncident investigationFinal reportCessna U206G · Sparrevohn Afs, AKThe loss of engine power due to the ice in the fuel strainer/gascalator. Contributing was: the inadequate preflight preparation by the pilot, and unsuitable terrain on which to make the forced landing.NTSB NYC91LA084Accident · Minor injuriesLimited investigationFinal reportCessna 210 · East Swanzey, NHThe pilot's lack of familiarity with this airplane and his inadequate preflight, which resulted in miscalculations of fuel consumption and subsequent fuel exhaustion. Factors related to this accident were: the leaking of fuel caps, the inaccurate fuel…NTSB NYC91LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PADue to failure of the induction air control/air filter/screen, which blocked airflow through the carburetor throat.NTSB MIA91LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Jensen Beach, FLImproper in-flight planning decision by the pilot resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident were the unreliable fuel quantity indicators.NTSB CHI91LA101Accident · No injuriesLimited investigationFinal reportCessna T210N · Elwood, INThe pilot's improper use of the fuel selector which resulted in fuel starvation. A related factor was: soft terrain in the emergency landing area.NTSB LAX91LA114Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coalinga, CAFuel starvation and the improper use of the fuel selector by the pilot. The rough terrain on which the aircraft landed was a factor in the accident.NTSB SEA91LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Glasgow, MTThe loss of engine power due to carburetor icing. Factors relating to the accident were the strong winds, high obstructions in the area and tailwind conditions for landing at the only available area.NTSB FTW91FA043Accident · 3 fatalField investigationFinal reportMitsubishi MU-2B-60 · Tulsa, OKThe shutdown of one engine for undetermined reasons, and the pilot's failure to maintain vmca during a critical phase of flight. A factor in the accident was the pilot's improper emergency procedure.NTSB LAX91LA107Accident · No injuriesLimited investigationFinal reportQuestaire Venture · San Luis Obispo, CAThe failure of the fuel system vent check valve, which resulted in fuel starvation to the aircraft's engine.NTSB FTW91LA037Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Brownsville, TXThe pilot's failure to refuel the airplane prior to his departure on the last leg of the flight, which resulted in fuel exhaustion.