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 MIA92LA170Accident · No injuriesLimited investigationFinal reportHughes 269B · Long Beach, MSImproper collective and cyclic control input by the pilot-in-command during the forced landing following total loss of engine power due to undetermined reasons.NTSB MIA92FA173Accident · 2 fatalField investigationFinal reportBeech BE-A23-19 · Picayune, MSThe failure of the pilot in command to place the fuel selector on the fullest tank, resulting in an engine failure due to fuel starvation over unsuitable terrain.NTSB ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.NTSB NYC92LA184Accident · Minor injuriesLimited investigationFinal reportWilliam C. Keiling Prober Pixie · Cumberland, MDAn inadvertent stall/spin, following a power loss due to fuel contamination. Factors related to the accident were the failure of the pilot to detect the rust particles and water in the fuel system prior to takeoff and his lack of total experience in the…NTSB NYC92LA181Accident · Minor injuriesLimited investigationFinal reportBeech A24 · Simsbury, CTA power loss due to a fuel line blocked with dirt and sludge, while operating over unsuitable terrain. A factor related to the accident was the failure of the owner/pilot to detect the dirt and sludge in the fuel system prior to takeoff.NTSB CHI92LA258Accident · Minor injuriesLimited investigationFinal reportChristen Industries S2B · Alton, ILThe pilot's failure to accomplish refueling.NTSB LAX92LA366Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Fresno, CAThe loss of engine power due to carburetor icing and the failure of the pilot to use carburetor heat.NTSB DEN92LA087Accident · No injuriesLimited investigationFinal reportCessna 172F · Folsom, NMCarburetor heat not used and improper use of throttle and mixture control. A factor was: the lack of suitable terrain for a forced landing.NTSB SEA92LA189Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Concrete, WAThe loss of engine power due to fuel exhaustion, resulting from the IMPR0PER in-flight planning by the pilot in command and his failure to select a proper touchdown point for an emergency forced landing. A factor relating to the accident was the uneven…NTSB LAX92LA361Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Morgan Hill, CAA loss of engine power due to carburetor ice and the failure of the pilot to use carburetor heat.NTSB FTW92LA217Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Farmington, NMTotal loss of engine power due to carburetor ice and the pilot's delayed use of carburetor heat. A factor was unsuitable terrain.NTSB FTW92LA216Accident · No injuriesLimited investigationFinal reportCessna 172C · Weatherford, TXFuel starvation as result of a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.NTSB SEA92LA184Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Mattawa, WALoss of engine power due to fuel contamination as a result of inadequate maintenance by the operator. A factor contributing to the accident was soft terrain.NTSB NYC92LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Salem, CTThe pilot's inaccurate fuel calculations and his improper decision to takeoff with a known limited fuel supply resulting in fuel exhaustion and subsequent forced landing. Factors related to the accident were the pilot's lack of total flight experience and his…NTSB FTW92DPG15Accident · No injuriesFinal reportBell-Transworld 47G-2 · Birdeye, ARFuel contamination. A factor was the high density altitude.NTSB ANC92LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Alsworth, AKThe loss of engine power due to fuel starvation associated with fuel contamination due to an inadequate aircraft preflight by the pilot. The unsuitable terrain encountered during the landing was a factor.NTSB LAX92LA355Accident · No injuriesLimited investigationFinal reportCessna T210L · Fallbrook, CAFuel exhaustion due to the failure of the pilot to refuel the aircraft prior to departure.NTSB SEA92LA180Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Pocatello, IDAn undetermined loss of engine power. A factor to the accident was: an in flight planning/decision delay.NTSB FTW92LA212Accident · No injuriesLimited investigationFinal reportMBB BO 105CBS-4 · Ship Shoal 90Loss of power to both engines from fuel starvation due to the pilot's failure to switch on the main fuel boost pumps.NTSB CHI92LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Owosso, MIFuel starvation which resulted from the pilot having selected the wrong fuel tank. Factors related to the accident were poor aircraft preflight and the unreliable fuel quantity gauges.NTSB ATL92LA160Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Slocomb, ALA hard landing due to a power loss from fuel exhaustion. A factor in the accident was the lack of sustable terrain for the landing.NTSB NYC92FA164Accident · Serious injuriesField investigationFinal reportBeech D55 · Oxford, METhe pilot's improper preflight and fuel tank selection for takeoff, which resulted in fuel starvation and loss of power in both engines during takeoff.NTSB LAX92LA354Accident · No injuriesLimited investigationFinal reportHughes 269C · Corona, CAThe flight instructor's improper supervision of the flight; the dual student pilot's failure to use carburetor heat; and the flight instructor's improper use of the tail rotor pedals. Contributing to this accident was the engine failure due to carburetor…NTSB NYC92LA178Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Nantucket, MAThe pilot's failure to use carburetor heat, resulting in carburetor ice and loss of engine power and subsequent forced landing in the ocean.NTSB CHI92LA238Accident · No injuriesLimited investigationFinal reportBeech A36 · Ann Arbor, MIFuel starvation for undetermined reasons. Factors related to the accident were in blown fuse which rendered the boost pump inoperative and the rough terrain in which the emergency landing was made.NTSB LAX92LA345Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H · Merced, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. Contributing to this accident was fuel exhaustion and the cultivated soft field.NTSB FTW92LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Nevada, TXThe PIL0T'S inadvertent stall of the airplane during the forced landing and his failure to refuel the airplane en route.NTSB CHI92LA237Accident · No injuriesLimited investigationFinal reportBeech C90 · Pontiac, MIThe pilot's not understanding the fuel system, and his subsequent inadvertent discontinuance of fuel to both engines.NTSB CHI92LA226Accident · Serious injuriesLimited investigationFinal reportCessna 175A · East Lansing, MIThe pilot's inadequate preflight inspection of the aircraft which resulted in a loss of engine power during cruise flight. Related factors are the loose oil filler cap, and the short, wet grass strip used for the emergency landing.NTSB ANC92LA118Accident · No injuriesLimited investigationFinal reportCessna 207A · Pilot Station, AKThe total loss of engine power for undetermined causes, and the unsuitable terrain.NTSB LAX92LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gila Bend, AZFuel exhaustion due to the pilots inadequate preflight and inflight planning, and, his failure to refuel the aircraft.NTSB LAX92LA324Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Porterville, CAFuel exhaustion due to the student pilot's inadequate preflight and inflight planning, and the failure to refuel the aircraft.NTSB SEA92LA170Accident · No injuriesLimited investigationFinal reportCessna 411 · Lehi, UTThe failure by the pilot to maintain airspeed above VMC, resulting in loss of control in flight, and his failure to lower the flaps and landing gear for the forced landing. A factor relating to the accident was the pilot's decision to perform fuel system…NTSB ANC92LA114Accident · Minor injuriesLimited investigationFinal reportBeech 55-95B55B · Delta Junction, AKFuel starvation of both engines and the pilot's improper inflight planning/decision by not getting more fuel or cancelling the flight. Contributing factors to the accident was the pilot not following procedures/directives (the airplane flight manual) when he…NTSB MIA92LA155Accident · No injuriesLimited investigationFinal reportDewitt, Richard A. Kitfox · Vero Beach, FLFailure of the engine due to fuel contamination resulting in a forced landing in a grove at which time the aircraft struck trees.NTSB SEA92LA162Accident · No injuriesLimited investigationFinal reportKaman HH-43F · Headquarters, IDFuel exhaustion and the pilot in command's delay in refueling.NTSB BFO92LA110Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Belmont, NHInadequate in-flight planning/decision by the pilot.NTSB SEA92LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Provo, UTFuel exhaustion due to inadequate fuel supply. Factors include a ditch encountered while landing.NTSB SEA92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Burley, IDFuel exhaustion when anticipated fuel consumption was not adequately calculated.NTSB SEA92LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Twin Falls, IDThe pilot's failure to refuel resulting in fuel exhaustion and the unsuitable terrain encountered during the forced landing.NTSB LAX92LA309Accident · No injuriesLimited investigationFinal reportPiper PA32-301T · Van Nuys, CAAn on ground collision with terrain subsequent to an engine failure for undetermined reasons.NTSB LAX92LA308Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tucson, AZThe pilot's poorly planned approach and failure to attain the proper descent rate. The loss of engine power for undetermined reasons and the rough terrain conditions in the area of the forced landing were factors in the accident.NTSB LAX92LA298Accident · No injuriesLimited investigationFinal reportCessna 150L · Pittsburg, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. The rough/uneven terrain is a factor in this accident.NTSB SEA92LA152Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH12D · Loman, IDFuel exhaustion. Factors include a short in the fuel quantity sensor/transmitter, an inadequate preflight, and a tree covered landing area.NTSB MIA92LA149Accident · No injuriesLimited investigationFinal reportMooney M20C · Pass-A-Grille, FLTotal loss of engine power due to fuel starvation.NTSB CHI92LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Ortonville, MIImproper use of the fuel tank selector switch and inadequate emergency procedures by the pilot in command.NTSB CHI92DEX02Accident · No injuriesFinal reportTownsend-Snyder Rultan Varieze · Indianapolis, INFuel starvation due to improper fuel tank selection.NTSB BFO92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chestertown, MDCarburetor ice, due to the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and obstructions (houses and utility pole) in the emergency landing area.NTSB FTW92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Port Isabel, TXThe loss of power to the right engine due to a fractured crankshaft while the left engine was secured. Factors were the dual students failure to use carburetor heat while performing maneuvers and the unsuitable terrain.NTSB ATL92LA135Accident · No injuriesLimited investigationFinal reportCessna 182 · Kennesaw, GAThe inadequate preflight planning by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.