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 CHI97FAMS3Accident · 1 fatalMissing aircraftFinal reportGrumman American AA-5 · Lower Brule, SDundetermined due to the accident airplane not being available for examination.NTSB ATL97LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunlap, TNa loss of engine power for undetermined reasons.NTSB LAX97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAa loss of engine power for undetermined reasons.NTSB MIA97LA230Accident · No injuriesLimited investigationFinal reportCessna R172E · Mary Esther, FLThe loss of engine power for undetermined reasons.NTSB NYC97FA159Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Danbury, CTThe pilot's failure to takeoff with the fuel selector in the full on position, which resulted in fuel starvation. Also causal was the pilot's improper in-flight decision to attempt a 180 degree turn back to the runway, which resulted in the inadvertent…NTSB MIA97LA225Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Columbia, SCThe improper rebuild/remanufacture of the fuel line (obstructed at both ends) that runs between the carburetor and sediment bowl by an unknown person. This resulted in a loss of engine power due to fuel starvation, forced landing to non-suitable terrain, and…NTSB FTW97LA296Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Harrison, ARThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA241Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Eagle, MIthe pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.NTSB MIA97LA224Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Coral, FLLoss of engine power for undetermined reasons resulting in a forced landing to unsuitable terrain.NTSB FTW97LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Abernathy, TXThe pilot's failure to use carburetor heat during serious carburetor icing conditions, and the flight instructor's inadequate supervision. Factors were the icing conditions and the lack of suitable terrain for the forced landing.NTSB CHI97LA233Accident · 1 fatalLimited investigationFinal reportAlbrecht SEA REY · Brighton, MILoss of engine power due to a failed exhaust valve oil seal, and fouled spark plugs.NTSB FTW97LA284Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Pine Bluff, ARloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB CHI97LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mapleton, IAthe loss of engine power for undetermined reasons. A factor was the cornfield in which the pilot was forced to land.NTSB MIA97FA219Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Gainesville, GAloss of engine power for undetermined reason(s). Factors relating to the accident were: the lack of suitable terrain for a forced landing, and obstructions (trees and building) that were encountered during the emergency landing.NTSB MIA97LA215Accident · No injuriesLimited investigationFinal reportBeech 65 · Atlantic Ocean (Atlantic Ocean)Failure of the aircraft to maintain altitude for undetermined reasons following loss of power in one engine.NTSB CHI97LA224Accident · Serious injuriesLimited investigationFinal reportBeech B-23 · Watertown, WIa loss of engine power due to undetermined reason(s).NTSB NYC97LA150Accident · No injuriesLimited investigationFinal reportCessna 172E · Fitchburg, MAA loss of engine power for undetermined reasons.NTSB IAD97LA102Accident · 1 fatalLimited investigationFinal reportLardas Renegade Spirit · Boonsboro, MDThe pilot's failure to maintain control of his homebuilt airplane during a low level maneuver after a loss of engine power due to undetermined reasons. A factor in the accident was the pilot's alcohol impairment.NTSB FTW97LA277Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Blackwell, OKpartial loss of engine power for undetermined reasons. Factors relating to the accident were: the high vegetation and ditch in the emergency landing area.NTSB CHI97LA217Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Hill City, KSthe sustained partial loss of engine power due to low compression on one cylinder and the rough, uneven terrain.NTSB SEA97LA171Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Yamhill, ORLoss of engine power for undetermined reasons.NTSB FTW97FA274Accident · 1 fatalField investigationFinal reportHillam Rans S-9 · Mckinney, TXloss 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 a stall and collision with the terrain.NTSB CHI97FA220Accident · 4 fatalField investigationFinal reportBeech B-60 · Springfield, MOThe pilot's fuel mismanagement and his failure to maintain adequate airspeed which resulted in fuel exhaustion followed by the loss of power in one engine and the loss of aircraft control. Contributing was the pilot's failure to refuel the aircraft, the…NTSB CHI97LA222Accident · No injuriesLimited investigationFinal reportMorgan MINI-500 · Ava, MOLoss of engine power due to loss of engine cooling fluid. Related factors were maintenance service bulletin not complied with by the owner/pilot mechanic resulting in low output of the carburetor, and unsuitable terrain.NTSB ANC97LA106Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Alagnak River, AKA partial loss of engine power for an undetermined reason, and the pilot's intentional operation of the airplane with known deficiencies.NTSB NYC97LA147Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Napoleon, OHThe pilot's decision to take off with inadequate fuel.NTSB MIA97FA213Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Avon Park, FLa loss of engine power as a result of the thrust reversers being deployed and subsequent in-flight collision was wires. Factors in this accident were the pilot's disregard for procedures, and the improper use of the thrust reversers.NTSB NYC97LA138Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Paducah, KYThe failure of maintenance personnel to identify and correct the worn holes on the lower fuselage fairing and the failure of the flight instructor to maintain main rotor RPM during the autorotative landing. A contributing factor was the flight instructor's…NTSB CHI97LA210Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNloss of engine power for undetermined reason(s). A factor relating to the accident was: the wet/soft terrain in the emergency landing area.NTSB FTW97LA263Accident · Serious injuriesLimited investigationFinal reportBronner Steen Skybolt · Brazoria, TXa fuel leak at a wobble pump fuel hose clamp, which resulted in loss of fuel and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.NTSB MIA97LA209Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · New Albany, MSa forced landing due to an undetermined complete loss of engine power, and subsequent impact with tress.NTSB CHI97LA209Accident · No injuriesLimited investigationFinal reportPiper PA-25-235A · O'Neil, NEfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel consumption calculations. Factors relating to the accident were: the lack of an operable fuel indication system, and the high winds.NTSB SEA97LA165Accident · No injuriesLimited investigationFinal reportYoung Turbo Cruiser · Milford, UTLoss of engine power due to fuel starvation. Factors include the pilot's fuel consumption calculations based upon insufficient or erroneous information provided by the amateur-built airplane's builder and previous owner, and terrain conditions not suitable…NTSB MIA97LA207Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Clewiston, FLa forced landing as a result of an undetermined loss of engine power and subsequent impact with a railroad switching unit and nose over.NTSB CHI97LA204Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Donnelly, MNundetermined event resulting in the broken connecting rod and cylinder.NTSB ATL97LA099Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Destin, FLa loss of engine power for undetermined reasons.NTSB LAX97LA238Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Prescott, AZThe pilot's improper placement of the unmarked fuel selector valve to off which resulted in fuel starvation. A factor in the accident was the pilot's lack of total experience in this model aircraft.NTSB IAD97LA097Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Culpeper, VAThe pilot's inadequate preflight planning which fail to provide an adequate fuel supplyNTSB MIA97LA203Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Bay St. Louis, MSThe pilot's improper short field landing procedure and use of full flaps prior to being assured of reaching the proper touchdown point, resulting in an in-flight collision with an embankment, and subsequent nose over. Contributing to the accident was a total…NTSB FTW97LA246Accident · No injuriesLimited investigationFinal reportCessna T210M · Kerrville, TXThe disintegration of the #1 cylinder piston resulting from a detonation/pre-ignition condition due to an unknown reason. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Satanta, KSThe pilot did not maintain aircraft control and the reason for the loss of engine power was undetermined.NTSB ATL97FA095Accident · 1 fatalField investigationFinal reportBoeing Stearman B75N1 · Locust Grove, GAThe inadvertent stall encountered by the pilot after experiencing an in-flight cylinder head separation.NTSB NYC97LA133Accident · No injuriesLimited investigationFinal reportBeech C24R · Old Bridge, NJLoss of engine power for undetermined reasons.NTSB ATL97LA093Accident · Minor injuriesLimited investigationFinal reportConvair 240-53 · San Juan, PRa loss of engine power for undetermined reasons, the pilot's improper emergency procedure after the powewr loss, and the overloading of the airplane, resulting in an inability to maintain altitude and terrain clearance.NTSB FTW97LA240Accident · Serious injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Ardmore, OKThe pilot's failure to maintain clearance from the power line. Factors were his improper decision to continue the flight after he noted a loss of engine power during initial takeoff climb and the loss of engine power for an undetermined reason.NTSB CHI97LA190Accident · Serious injuriesLimited investigationFinal reportDietrich Nieuport 12 · Byron, MIThe owner/pilot mechanic's inadequate inspection of the aircraft which led to contamination (other than water) of the fuel filter.NTSB IAD97LA093Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlton, MAThe loss of engine power for undetermined reasons..NTSB CHI97LA185Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Manito, ILloss of engine power for undetermined reason(s).NTSB ANC97LA090Accident · No injuriesLimited investigationFinal reportBeech D18S · Willow, AKThe loss of engine power for an undetermined reason.NTSB MIA97FA188Accident · 1 fatalField investigationFinal reportBeech 77 · Fort Lauderdale, FLloss of engine power for undetermined reason(s), and failure of the student pilot to remain clear of obstructions, while attempting to make a forced landing.