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 CHI00LA028Accident · Serious injuriesLimited investigationFinal reportShaffer Evans Volksplane · Stanley, NDrefueling not performed by the non-rated pilot and the lack of total experience of the non-rated pilot. Factors to the accident were fuel exhaustion, the unsuitable terrain for landing encountered by the non-rated pilot, and the rough/uneven terrain condition.NTSB NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…NTSB LAX00TA030Accident · Minor injuriesFinal reportBell OH-58A · La Puente, CAA loss of engine power for undetermined reasons.NTSB MIA00LA022Accident · No injuriesLimited investigationFinal reportCessna 150M · Jacksonville, NCThe flight instructor's improper supervision of the student pilot during preflight and improper fuel management ensuring there was sufficient fuel for the planned flight. This resulted in a total loss of engine power due to fuel exhaustion.NTSB MIA00LA015Accident · No injuriesLimited investigationFinal reportCessna 172G · Itta Bena, MSa loss of engine power for undetermined reasons resulting in a forced landing that was short of the intended touchdown point, and the subsequent impact with the ground.NTSB FTW00LA016Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · No. Little Rock, ARThe pilot's delay in aborting the takeoff. A factor was the partial loss of engine power for an undetermined reason.NTSB SEA00LA005Accident · No injuriesLimited investigationFinal reportBeech S35 · Melstone, MTLoss of engine power for undetermined reasons.NTSB SEA00LA004Accident · No injuriesLimited investigationFinal reportThomson Vans RV-6 · Emmett, IDThe pilot's improper fuel management, resulting in fuel starvation. A factor was the aircraft's low altitude at the time engine power was lost.NTSB CHI00LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Sprague, NEEngine failure due to fouled and rusted spark plugs, and a clogged fuel filter. Factors relating to this accident were the inadequate annual inspection performed on the airplane, the trees and the ditch.NTSB MIA00LA005Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Sunny Isles, FLA loss of engine power while maneuvering due to improper ignition timing by unknown person(s) resulting in an emergency descent and collision with the water.NTSB NYC00LA024Accident · No injuriesLimited investigationFinal reportCessna 177 · Frankfort, KYA total loss of engine power for undetermined reasonsNTSB CHI00LA004Accident · 2 fatalLimited investigationFinal reportDraper Rans S-10 · Benton, KSthe pilot inadvertently stalled the airplane. Factors relating to the accident was the undetermined loss of power and the pilot's lack of recent experience in the airplane.NTSB CHI00LA002Accident · Minor injuriesLimited investigationFinal reportEnstrom EN-28 · Indianapolis, INThe pilot's attempted operation of the helicopter with known deficiencies, and his improper autorotation to landing. Factors were one fouled spark plug and another partially failed spark plug in the same cylinder, and the construction area.NTSB DEN00LA001Accident · Serious injuriesLimited investigationFinal reportGray Rotorway Exec · Gallup, NMThe pilot inadvertently allowing main rotor rpm to decay while avoiding obstacles during an emergency autorotation following a loss of power for reasons undetermined. Factors were houses and powerlines.NTSB DEN99LA173Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Longmont, COAn inaccurate touchdown during a full autorotation, which resulted in main rotor flex which cut off the tail boom. Factors were the pilot's lack of total experience in helicopters and high density altitude.NTSB CHI99LA357Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Greenfield, INthe FBO employee improperly refueled the airplane with Jet A fuel instead of 100LL and the inadequate preflight by the pilot-in-command in that he failed to drain the fuel tanks during the preflight. Factors related to the accident were the low altitude at…NTSB NYC99FA236Accident · 2 fatalField investigationFinal reportPiper PA 22-150 · Goshen, KYA loss of engine power for undetermined reasons which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the down-sloping terrain.NTSB MIA99LA268Accident · No injuriesLimited investigationFinal reportBanting Glasair II · River Ranch, FLA total loss of engine power for undetermined reasons, which resulted in a forced landing to non-suitable terrain.NTSB MIA99LA271Accident · No injuriesLimited investigationFinal reportCessna 177 · St Petersburg, FLA loose throttle control cable clamp which resulted in a lose of power.NTSB CHI99LA358Accident · No injuriesLimited investigationFinal reportBosick Pulsar · Belleville, ILA loss of engine power for undetermined reasons.NTSB ATL99LA133Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Enterprise, ALThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was the in-flight collision with a tree during the forced landing.NTSB FTW99FA261Accident · 5 fatalField investigationFinal reportCessna 182A · Bryan, TXthe pilot's failure to maintain aircraft control resulting in an inadvertent stall. A factor was the loss of engine power as a result of fatigue cracking and separation of the #6 cylinder head.NTSB MIA99LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Anguilla, MSThe P3 air line disconnected at the P3 air filter housing , and a 'B' nut not being safetied by maintenance personnel, which resulted in a total loss of engine power.NTSB ANC99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKA loss of engine power for an undetermined reason. A factor in the accident was unsuitable terrain for a forced landing.NTSB MIA99LA251Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30 · Athens, GAThe pilot's improper fuel management resulting in loss of engine power on approach due to fuel starvation and damage to the aircraft during the subsequent forced landing.NTSB CHI99LA336Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Daleville, INA loss of engine power for undetermined reasons.NTSB SEA99LA161Accident · No injuriesLimited investigationFinal reportWild Goose A1 · Keizer, ORA loose fuel line fitting resulted in a loss of engine power. An intentional wheels down landing was a factor.NTSB CHI99LA337Accident · 1 fatalLimited investigationFinal reportReichert MJ-77 · Owosso, MIthe pilot's improper preflight which resulted in a takeoff with the oil cap not secured and the subsequent loss of engine power.NTSB CHI99LA333Accident · No injuriesLimited investigationFinal reportCessna 172K · Pickrell, NEthe loose oil dipstick guide tube resulting in loss of oil and the engine failure. The night condition was a contributing factor.NTSB CHI99LA352Accident · No injuriesLimited investigationFinal reportCessna 150M · Lebanon, MOA loss of engine power due to a fractured shaft supporting the number three cylinder rocker arm. A factor relating to this accident was the trees.NTSB CHI99LA320Accident · Serious injuriesLimited investigationFinal reportCessna 172D · South Wayne, WIthe pilot's improper selection of an emergency field and failure to maintain clearance from the trees. The cause of the loss of engine power was not determined.NTSB ANC99LA126Accident · No injuriesLimited investigationFinal reportCessna A185E · Anchorage, AKThe total loss of engine power for an undetermined reason.NTSB MIA99LA243Accident · No injuriesLimited investigationFinal reportPowers Rotorway Exec 162 · Lutz, FLa loss of power due to undetermined reasons, resulting in a forced landing and subsequent impact with the ground. A factor in this accident was the pilot was not qualified or certified in helicopters.NTSB CHI99LA317Accident · No injuriesLimited investigationFinal reportAyres S-2R · Brooten, MNthe compressor impeller failure and the unsuitable terrain for landing encountered by the pilot.NTSB CHI99IA350Incident · No injuriesIncident investigationFinal reportBritish Aerospace Jetstream 3101 · South Bend, INthe right engine accessory section's splined gear spur gear failure during cruise flight.NTSB ATL99LA119Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mountain City, TNA blocked fuel system vent that resulted in fuel starvation and the complete loss of engine power.NTSB SEA99LA149Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Benton City, WAA loss of power for undetermined reasons and the failure of the pilot to maintain adequate rotor RPM following the power loss. Contributing factors were the pilot's lack of certification and total experience.NTSB FTW99LA231Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Cabot, ARThe missing engine oil filler cap which resulted in the loss of engine power as a result of oil starvation. Factors were the pilot's improper aircraft preflight inspection and the lack of suitable terrain for the forced landing.NTSB FTW99LA230Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Weatherford, TXThe loss of engine power during the initial takeoff climb for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA308Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Granite City, ILLoss of power for undetermined reason(s) and the rough/uneven.NTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.NTSB FTW99LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Snyder, TXThe loss of engine power due to fuel starvation as result of a leak in the engine fuel control. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Harsens Island, MIthe loss of engine power for undetermined reasons. Factors were the berm and the pond.NTSB ANC99LA120Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fairbanks, AKA loss of engine power for an undetermined reason. A factor was unsuitable terrain for a forced landing.NTSB NYC99LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, NJA loss of engine power for undetermined reason(s).NTSB FTW99LA225Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Dermott, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99FA222Accident · 1 fatalField investigationFinal reportPiper PA30 · Holdenville, OKthe pilot's failure to maintain aircraft control during takeoff initial climb. Factors were the loss of right engine power for undetermined reasons, and the pilot's lack of total experience in the make and model of aircraft.NTSB ATL99LA118Accident · No injuriesLimited investigationFinal reportBeech G35 · Columbus, MSThe loss of engine power for undetermined reasons and unsuitable terrain to make a forced landing.NTSB ATL99LA116Accident · Minor injuriesLimited investigationFinal reportCessna R172-E · Chiefland, FLPremature fuel exhaustion due to a cracked fuel line. Contributing to the severity of the accident was the electrical service drop line, which crossed the roadway.NTSB MIA99FA224Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pembroke Pines, FLThe failure of the pilot to maintain airspeed and inadvertent stall of the airplane by the pilot-in-command resulting in the uncontrolled descent and in-flight collision with a house. Contributing factors in the accident were the loss of engine power due to…