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 ATL96LA078Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Batesville, MSan anomaly in the fuel system that allowed a pressure differential to occur between the center and outer portions of the main integral fuel tank, which in turn resulted in fuel starvation of both engines. A factor relating to the accident was: failure of…NTSB SEA96LA078Accident · Minor injuriesLimited investigationFinal reportSport Flight Talon · Salem, ORloss of engine power for undetermined reason(s), and failure of the pilot to properly flare the aircraft during the emergency landing.NTSB NYC96LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmingdale, NYloss of engine power for undetermined reasons.NTSB ANC96LA045Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas H-369 · Delta Junction, AKloss of engine power for an undetermined reason.NTSB LAX96LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Chandler, AZThe failure of both the engine driven and hand wobble fuel pumps, which resulted in fuel starvation to the engine.NTSB ATL96LA076Accident · Serious injuriesLimited investigationFinal reportHiller UH12-E · Huger, SCThe blocked fuel vent line that resulted in engine stoppage. A factor was tall trees that intervened the helicopter's flight path.NTSB FTW96LA158Accident · Minor injuriesLimited investigationFinal reportStafford RV-4 · Longmont, COthe pilot's inadequate preflight planning and preparation in that he failed to ensure the aircraft had sufficient fuel to complete the flight. A factor was the soft terrain.NTSB LAX96LA147Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Torrance, CAinadequate maintenance and inspection of the airplane; rust and water contamination in the aircraft fuel system; a worn shaft and cracked coupling in the left engine's left magneto, a malfunctioning left magneto on the right engine, and contamination (oil and…NTSB SEA96LA075Accident · No injuriesLimited investigationFinal reportRyan Navion · Kent, WAthe pilot's attempted operation with known deficiencies in the equipment, and a loose fuel system fitting. The pilot's failure to maintain maintenance service on the airplane was a factor.NTSB SEA96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Lynnwood, WAa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB IAD96LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Roanoke, VAloss of engine power for undetermined reason(s). Darkness and the pilot's improper emergency procedures were related factors.NTSB ANC96LA037Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cantwell, AKThe undetermined loss of engine power and lack of suitable terrain to make a forced landing.NTSB FTW96LA148Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Texarkana, ARa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Sulphur Springs, TXthe pilot's failure to maintain terrain clearance. A factor was his diverted attention to the performance of the manual gear extension procedure.NTSB ANC96LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ketchikan, AKloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of a suitable area for an emergency landing.NTSB ANC96LA031Accident · No injuriesLimited investigationFinal reportCessna 150H · Anchorage, AKloss of engine power for an undetermined reason.NTSB FTW96LA137Accident · Minor injuriesLimited investigationFinal reportBell B206-BIII · Chandler, OKthe reported loss of engine power during a go-around for undetermined reason(s).NTSB MIA96LA088Accident · No injuriesLimited investigationFinal reportBell 206L4 · Chiefland, FLImproper cyclic and collective input by the pilot-in-command resulting in the hard landing during the autorotative landing. Contributing to the accident was the total loss of engine power due to undetermined reasons.NTSB FTW96LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Andrews, TXthe mechanic's improper overhaul of the engine. Factors were: the pilot in command's inability to maintain visual lookout due to oil on the windscreen and unsuitable terrain for the forced landing.NTSB FTW96LA127Accident · No injuriesLimited investigationFinal reportCessna 175A · San Angelo, TXa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the forced landing.NTSB ATL96LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Jackson, MSloss of engine power during takeoff for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW96LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Carrizo Springs, TXa loss of engine power for undetermined reasons, and the pilot's improper touchdown.NTSB FTW96LA115Accident · No injuriesLimited investigationFinal reportCessna 172G · Gunnison, COLoss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB NYC96LA059Accident · No injuriesLimited investigationFinal reportCessna 180D · Islesboro, MEa loss of engine power for an undetermined reason.NTSB FTW96LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Grand Prairie, TXa loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96FA108Accident · Serious injuriesField investigationFinal reportCessna 152 · Conway, ARloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall at low altitude. The gusty wind condition was a related factor.NTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA101Accident · No injuriesLimited investigationFinal reportBoeing A75 · Barstow, CAa loss of engine power for an undetermined reason(s).NTSB BFO96LA040Accident · Serious injuriesLimited investigationFinal reportAerostar 601 · Mount Storm, WVloss of power in the right engine for undetermined reason(s), and the accumulation of structural ice on the airplane, which resulted in an increased rate of descent and a subsequent forced landing before the pilot could reach an alternate airport. Factors…NTSB MIA96LA071Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Fort Pierce, FLfailure of the pilot to follow emergency procedure(s) and/or feather the respective propeller after loss of power in the left engine for an undetermined reason. The undetermined loss of power (left engine) was a related factor.NTSB MIA96FA067Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-60 · West Columbia, SCa total loss of power on one engine for undetermined reasons, and the pilot-in-command's failure to maintain airspeed (VMC) resulting in an in-flight loss of control. Contributing to the accident was the wind gusts encountered while on final approach to land.NTSB FTW96LA093Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Houston, TXa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB BFO96LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Coshocton, OHloss of engine power for an undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.NTSB MIA96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lantana, FLLoss of engine power for an undetermined reason, while over water, which resulted in a forced landing/ditching at sea.NTSB FTW96LA076Accident · No injuriesLimited investigationFinal reportCessna 150M · Round Rock, TXThe pilot's improper planning/decision, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB LAX96LA071Accident · No injuriesLimited investigationFinal reportCessna 172M · Palm Springs, CAthe pilot's inadequate bounced landing recovery technique, which resulted in porpoising during a downwind emergency landing. The loss of engine power for undetermined reasons was a factor.NTSB FTW96LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Erie, COinadequate preflight by the pilot, by failing to properly remove water and other contamination from the fuel system before the flight. Factors relating to the accident were: deteriorated seals at the fuel filler neck/caps, and the annual inspection was…NTSB ATL96LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA 315 · Manning, SCThe loss of engine power during takeoff for undetermined reason(s).NTSB CHI96LA044Accident · Minor injuriesLimited investigationFinal reportHerring Sport FAN · Newton, KSa loss of engine power for undetermined reasons. A factor related to the accident was the presence of traffic requiring the pilot to perform an evasive maneuver.NTSB FTW96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Santa Fe, NMLoss of engine power for undetermined reasons. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB LAX96LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAloss of engine power for an undetermined reason.NTSB ATL96LA015Accident · No injuriesLimited investigationFinal reportCessna 172E · Lajas, PRthe student pilot's inadequate preflight inspection which resulted in a loss of power due to water in the fuel.NTSB SEA96LA023Accident · 1 fatalLimited investigationFinal reportHardesty/Hays Quickie Q2 · Puyallup, WAa loss of engine power for undetermined reasons, the pilot's failure to maintain adequate airspeed, and his improper decision to attempt a 180-degree turn back toward the runway during the forced landing.NTSB FTW96LA053Accident · No injuriesLimited investigationFinal reportCessna 182H · Eagle Lake, TXa loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the dark night.NTSB MIA96LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Saltillo, MSThe failure of the pilot-in-command to perform fuel comsumption calculations before and during the flight.NTSB MIA96LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marco Island, FLA loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB BFO96LA016Accident · Serious injuriesLimited investigationFinal reportRyan Navion A3 · Mccomb, OHthe pilot's improper use of carburetor heat, and carburetor Ice, which resulted in loss of engine power and a subsequent forced landing. The carburetor icing (weather) condition was a related factor.NTSB NYC96LA038Accident · No injuriesLimited investigationFinal reportCessna 177 · South Brunswick, NJloss of engine power for an undetermined reason.NTSB LAX96LA039Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Redwood City, CAthe simultaneous total loss of engine power for undetermined reasons.NTSB CHI96LA027Accident · Minor injuriesLimited investigationFinal reportBeech 33 · Lone Rock, WIa partial loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during his attempt to land the airplane back on the runway. A factor in the accident was the pilot's decision not to land in the suitable fields…