NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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\" = 350) 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" = 350) 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 FTW96LA291Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Castle Rock, COTotal failure of the magneto. A factor was the pilot operating the helicopter with a known deficiency.NTSB IAD96LA103Accident · Serious injuriesLimited investigationFinal reportAero Commander Calair A-9B · Cloverdale, OHPowerplant failure due to undetermined reasons. Contributing to the severity of the crash was the unsuitable terrain in which the aircraft landed and post-crash fire.NTSB FTW96LA285Accident · No injuriesLimited investigationFinal reportHiller UH12 · Franklin, LAloss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM. A factor was the unsuitable terrain available for the precautionary landing.NTSB FTW96LA281Accident · No injuriesLimited investigationFinal reportCessna 172H · Pierce, COa loss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB LAX96LA254Accident · Minor injuriesLimited investigationFinal reportGray Berkut · Santa Paula, CALoss of engine power during final approach for undetermined reasons. A factor in the accident was the nature of the terrain for the forced landing.NTSB ATL96LA097Accident · No injuriesLimited investigationFinal reportCessna 140 · Jacksboro, TNloss of engine power for undetermined reason(s), which resutled in a forced landing and subsequent in-flight collision with trees and the terrain.NTSB MIA96LA167Accident · Minor injuriesLimited investigationFinal reportBeech B55B · Clinton, NCa loss of right engine power for undetermined reasons, resulting in the pilot loosing control of the airplane and impact with tress.NTSB SEA96LA160Accident · No injuriesLimited investigationFinal reportCessna 182A · Toledo, WAloss of engine power for undetermined reason(s). Factors relating to the accident were: the pilot's need to maneuvering to avoid obstructions near the approach end of the runway, and a ditch in the emergency landing area.NTSB CHI96FA209Accident · 2 fatalField investigationFinal reportBeech 23 · Fulton, MOthe inadequate intake valve springs on the #1 cylinder.NTSB FTW96LA266Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Abilene, TXfuel mismanagement by the pilot, which resulted in fuel starvation; and the pilot's failure to reposition the fuel selector (follow emergency procedure) while attempting to restart the engine. A factor relating to aircraft damage was: concrete debris (rocks)…NTSB SEA96LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Hazleton, IDpartial loss of engine power for undetermined reason(s). Factors relating to the accident were: high density altitude; the pilot's delay in dumping the entire chemical load, when he first perceived a power loss; and rough/uneven terrain in the emergency…NTSB FTW96FA262Accident · Minor injuriesField investigationFinal reportDouglas DC3A · Cut And Shoot, TXThe flight instructor's failure to use the single engine best angle of climb airspeed resulting in a loss of control of the aircraft. Factors were the loss of power to the left engine for undetermined reasons, the flight instructor not being qualified to be…NTSB LAX96FA236Accident · 3 fatalField investigationFinal reportBeech C23 · Los Angeles, CAcompany maintenance personnel's inadequate service of the magneto system, and their failure of to replace the electric fuel boost pump, which led to a malfunctioning right magneto and an inoperative fuel boost pump. The inoperative fuel boost pump made it…NTSB FTW96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301A · Hunter, ARThe loss of engine power for undetermined reasons.NTSB IAD96LA099Accident · No injuriesLimited investigationFinal reportAeronca L-3B · Morgantown, WVAn inadequate maintenance/annual inspection and failure of the muffler which resulted in melted insulation on the magneto 'P' leads and subsequent loss of engine power. A related factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA254Accident · No injuriesLimited investigationFinal reportCessna 172H · Crockett, TXLoss of engine power for undetermined reason(s).NTSB CHI96IA200Incident · No injuriesIncident investigationFinal reportBoeing 727-30C · Chicago, ILlow pressure in the fuel lines caused when the crossfeed valve was closed and the boost pumps to the effected fuel tank were turned off, a fuel pressure surge (spike) accompanied by a rapid drop in high pressure pump output and burner line pressures, when…NTSB CHI96LA198Accident · No injuriesLimited investigationFinal reportPiper J-3 · Princeton, MNLoss of engine power for an undetermined reason.NTSB ATL96LA091Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Gulfport, MSimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel.NTSB SEA96LA117Accident · Minor injuriesLimited investigationFinal reportHead Pitts S-1C · Everett, WAthe pilot's inadequate fuel management, which resulted in fuel starvation. The aircraft's lack of a fuel quantity gauge and trees in the forced landing area were related factors.NTSB CHI96LA197Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Custer, SDthe pilot did not maintain aircraft control or abort the takeoff. The factors involved were the pilot encountered a stall/mush condition, exhaust valves were leaking, low compression on all cylinders, and all pistons were scored.NTSB IAD96LA092Accident · No injuriesLimited investigationFinal reportBeech V35B · Westminster, MDThe fracture of the engine crankshaft which had a subsurface origin and progressed in fatigue until overload and separation occurred.NTSB ANC96FA081Accident · 1 fatalField investigationFinal reportRobinson R-22 Mariner · Mekoryuk, AKA loss of engine power due to fuel contamination found in the fuel supply and helicopter fuel system. Factors in the accident were the pilot's inadequate filtration (servicing of the helicopter) of the fuel supply, and the pilot's inadequate performance of…NTSB LAX96LA217Accident · No injuriesLimited investigationFinal reportHughes 269B · Georgetown, CAloss of engine power for undetermined reason(s), while practicing an autorotation, which resulted in a forced landing; and the flight instructor's misjudged landing flare during the emergency autorotation/landing.NTSB SEA96LA102Accident · No injuriesLimited investigationFinal reportCessna T188C · Hooper, UTloss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of obstructions, which limited the pilot's ability to reach a suitable emergency landing area.NTSB CHI96FA179Accident · 1 fatalField investigationFinal reportDotson Seabird · Geneseo, ILa loos of power due to a blocked fuel line and the pilot's failure to maintain airspeed.NTSB ATL96LA087Accident · Serious injuriesLimited investigationFinal reportSky Star Kitfox #1 · Bridgeport, ALloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB CHI96LA178Accident · Minor injuriesLimited investigationFinal reportDickinson Fisher Classic · Mooresville, INthe pilot failed to maintain adequate altitude and clearance from the trees, and had made an improper in-flight decision when he got to far from a suitable landing area. The reason for the loss of power failure was undetermined.NTSB CHI96LA174Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Osage Beach, MOa partial loss of power for undetermined reasons.NTSB MIA96LA149Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Orlando, FLloss of power in both engines for undetermined reason(s).NTSB FTW96LA226Accident · Serious injuriesLimited investigationFinal reportNavion NA1 · Los Lunas, NMThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA224Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Lunas, NMloss of total engine power due to fuel exhaustion for undetermined reason(s). The lack of suitable terrain for the forced landing was a related factor. The worn and leaking fuel system components and inadequate maintenance by unknown personnel were possible…NTSB IAD96LA081Accident · No injuriesLimited investigationFinal reportCessna 205A · Sommerville, VAthe loss of engine power for undetermined reasons during banner towing operations.NTSB FTW96LA215Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Houston, TXfailure of the pilot to obtain/maintain proper airspeed and flap setting for single engine flight. A factor relating to the accident was: Loss of power in the left engine for an undetermined reason.NTSB MIA96LA139Accident · Serious injuriesLimited investigationFinal reportEzekiel Velocity 173 · Pembroke Pines, FLloss of engine power for undetermined reason(s), resulting in a forced landing, and impact with a private residence and the ground.NTSB FTW96LA204Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Okmulgee, OKThe pilot's continued operation with known deficiencies in the airplane and the pilot's and maintenance personnel's failure to comply with an airworthiness directive resulting in the malfunctioning of a worn ignition switch. A factor was trees.NTSB MIA96LA137Accident · No injuriesLimited investigationFinal reportCessna U206G · Gulf Of MexicoLoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB ANC96LA069Accident · No injuriesLimited investigationFinal reportGillespie Challenger 2 · Talkeetna, AKThe pilot's failure to properly use the mixture control to enrich the fuel mixture, and the seizure of the piston in the cylinder.NTSB FTW96LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Mountain Home, ARthe pilot's failure to visually check the fuel quantity during the preflight inspection. A factor was the unsuitable terrain for the forced landing.NTSB ANC96LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKfuel starvation due to a kinked fuel supply line from the left main tank, and the pilot's improper rebuild/remanufacture of the airplane. A smaller than standard fuel line from the fuel strainer to the carburetor, a smaller than standard fuel cap vent, and a…NTSB FTW96LA189Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Malvern, ARfailure of the pilot to apply carburetor heat during the approach to land, which resulted in a loss of engine power due to carburetor ice. A factor relating to the accident was: the carburetor icing (weather) condition.NTSB ATL96LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Knoxville, TNThe pilot's failure to heed known operating information by not correcting the flight attitude to prevent fuel unporting during a prolonged slipped descent.NTSB NYC96LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Toms River, NJThe loss of engine power for undetermined reasons.NTSB IAD96LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Clinton, MDa loss of engine power for undetermined reasons.NTSB CHI96FA135Accident · 2 fatalField investigationFinal reportPiper J-3 · Raymond, NEfailure of the pilot to ensure that the fuel selector was properly positioned to the full 'on' position before takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff; and the pilot's failure to maintain…NTSB FTW96LA169Accident · No injuriesLimited investigationFinal reportBeech E35 · Albuquerque, NMa partial loss of engine power for undetermined reasons, and the pilot's failure to abort the takeoff.NTSB ANC96LA047Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Wasilla, AKA loss of engine power for an undetermined reason.NTSB IAD96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Akron, OHa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB ANC96LA046Accident · No injuriesLimited investigationFinal reportStinson ST-75 · Anchorage, AKThe pilot's failure to select the proper fuel tank prior to takeoff resulting in fuel starvation. A factor in the accident was the pilot's failure to follow the checklist.NTSB FTW96LA166Accident · No injuriesLimited investigationFinal reportCessna 182RG · Welsh, LAa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.