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 ANC93LA125Accident · No injuriesLimited investigationFinal reportHughes 369D · Cordova, AKA loss of engine power for undetermined reasons. A factor was the rough/uneven terrain.NTSB CHI93LA264Accident · No injuriesLimited investigationFinal reportBellanca DW-1 · Grinnell, IAthe loss of engine power due to undetermined reason(s). A factor in the accident is the soft field landing site.NTSB SEA93LA156Accident · 1 fatalLimited investigationFinal reportStark Rand KR-2 · Townsend, MTThe loss of engine power due to the failure of the improperly modified magneto and loss of control in flight by the PIC while maneuvering to return to the airport.NTSB CHI93LA260Accident · 2 fatalLimited investigationFinal reportChampion 7KCAB · Hill City, KSthe loss of engine power for an undetermined reason and the pilot's decision to continue flying the airplane with known deficiencies. Factors in the accident are the lack of suitable terrain available for a forced landing, the airplane's low altitude, and the…NTSB MIA93FA156Accident · 1 fatalField investigationFinal reportMooney M20-J · Jackson, MSA power loss for undetermined reasons during takeoff, the failure of the pilot-in-command to abort the takeoff, and his improper decision to turn back to the airport when there was suitable terrain ahead for the forced landing.NTSB LAX93LA285Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Rialto, CALoss of engine power for undetermined reasons, and the flight instructor's improper flare during the autorotation which resulted in a tail boom strike.NTSB SEA93LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Friday Harbor, WAFuel starvation and poor in-flight planning/decision.NTSB LAX93LA278Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia, CAa loss of engine power for undetermined reasons.NTSB FTW93LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lancaster, TXFuel exhaustion engine power loss due to the inadequate fuel supply for the flight. A factor was the lack of suitable terrain for the forced landingNTSB FTW93LA204Accident · No injuriesLimited investigationFinal reportCessna 177B · Shawnee, OKFuel system exhaustion induced power loss for undetermined reasons. A factor was a lack of suitable terrain.NTSB FTW93LA198Accident · No injuriesLimited investigationFinal reportCessna 172G · Fort Worth, TXThe power loss for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the inadvertent stall.NTSB NYC93LA128Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ironton, OHThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB MIA93LA147Accident · Serious injuriesLimited investigationFinal reportPiper PA-38 · St. Petersburg, FLThe loss of engine power for undetermined reasons, which resulted in the aircraft being ditched.NTSB LAX93LA267Accident · No injuriesLimited investigationFinal reportRyan ST-A · Fresno, CAThe pilot's failure to maintain directional control. Contributing to this accident was the partial loss of power for undetermined reasons, the high runway vegetation, and the left quartering tailwind.NTSB ANC93LA101Accident · No injuriesLimited investigationFinal reportGrumman American AA5A · Comet Mine, AKLoss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain on which an emergency landing could be made successfully.NTSB SEA93LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Ephrata, WAUndetermined loss of power and the lack of suitable terrain. A factor contributing to the accident was dark night conditions.NTSB NYC93LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Louisville, KYA partial power loss of undetermined origin while operating over unsuitable terrain.NTSB NYC93LA120Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Palmer, MAThe loss of engine power for undetermined reasons. A factor was lack of suitable terrain for the forced landing.NTSB NYC93LA111Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Woodstock, CTA complete loss of engine power for undetermined reasons.NTSB LAX93LA247Accident · 2 fatalLimited investigationFinal reportTucker Thorp T18C · So. Lake Tahoe, CAA total loss of engine power for undetermined reasons, and the failure of the pilot to maintain control of the aircraft while maneuvering at a low altitude.NTSB FTW93LA188Accident · No injuriesLimited investigationFinal reportReims Cessna FA 150K · Willis, TXLoss of partial engine power due to stuck exhaust valve and exhaust and intake valve binding with carbon buildup. A factor was the lack of suitable terrainNTSB MIA93LA140Accident · No injuriesLimited investigationFinal reportMooney M20E · Miami, FLThe pilot-in-command's improper flare during a forced landing which resulted in a hard landing. Contributing to the accident was the total loss of engine power for undetermined reasons.NTSB NYC93LA099Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31 · Leesport, PAThe loss of engine power for undetermined reasons, which resulted in forced landing and collision with trees.NTSB MIA93LA131Accident · No injuriesLimited investigationFinal reportCessna 210K · Myakka, FLThe failure of the No. 2 piston connecting rod for undetermined reasons. Contributing to the accident was a forced landing to unsuitable terrain.NTSB FTW93LA170Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Searcy, ARTotal power loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB SEA93LA121Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Afton, WYA loss of engine power for an undetermined reason(s).NTSB MIA93FA129Accident · Serious injuriesField investigationFinal reportBeech F33A · Oxford, MSLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB CHI93LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Mexico, MOa loss of engine power for undetermined reasons. A factor in the accident was the soft field landing site.NTSB ANC93FA064Accident · Serious injuriesField investigationFinal reportFairchild FH-1100 · Malina Bay, AKThe installation of a bogus transmission to engine driveshaft. The failure of the company maintenance personnel to comply with the service bulletins and letters was a factor.NTSB FTW93LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Arnaudville, LAThe loss of engine power for undetermined reasons. A factor was the unsuitable terrainNTSB SEA93LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Kapowsin, WAAn undetermined loss of engine power.NTSB BFO93LA077Accident · Serious injuriesLimited investigationFinal reportForest Ripley Z MAX · Delaware, OHThe loss of engine power for undetermined reasons.NTSB ATL93LA089Accident · No injuriesLimited investigationFinal reportFairchild 24G · Athens, TNThe pilot's failure to use carburetor heat in weather conditions which were conducive to the formation of carburetor iceNTSB LAX93LA207Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Corona, CAthe pilot improper maintenance modification and total failure of the magneto.NTSB FTW93LA148Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lookeba, OKThe loss of engine power for undetermined reasons. Factors were the smoke in the cockpit and loss of outside visual reference.NTSB CHI93LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Oshkosh, WILoss of engine power for an undetermined reason.NTSB ATL93LA085Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Arden, NCThe loss of engine power, and the pilot's premature flare during landing, which resulted in a landing stall. Factors were the high obstructions (trees) trees near the landing site, and the uphill terrain conditionsNTSB NYC93LA094Accident · Minor injuriesLimited investigationFinal reportSteven Kurtis Rand S 12 · E Stroudsburg, PAA forced landing in trees as a result of a complete loss of engine power for unknown reasons.NTSB LAX93LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe loss of engine power for undetermined reasons.NTSB MIA93LA105Accident · Minor injuriesLimited investigationFinal reportSiegel Glasair III · Zephyrhills, FLContamination (fiberglass dust) in the fuel system and/or a piece of plastic (foreign) material in the fuel injector, which resulted in restricted flow of fuel to the engine, loss of engine power, and subsequent collision with trees and terrain during a…NTSB MIA93LA103Accident · Minor injuriesLimited investigationFinal reportIseman Fokker VII · Tampa, FLLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB LAX93LA178Accident · Serious injuriesLimited investigationFinal reportMcreynolds Cassutt III · Napa, CAThe loss of engine power for undetermined reasons.NTSB NYC93LA086Accident · No injuriesLimited investigationFinal reportPitts S1T · Halifax, MADetachment of the throttle cable at the fuel injector arm. Soft terrain in the emergency landing area was a related factor.NTSB ATL93LA077Accident · No injuriesLimited investigationFinal reportMyers Avid Aircraft Flyer · Winnsboro, SCThe pilot's failure to maintain the airspeed above the stall speed, during the forced landing. A factor was the undetermined engine malfunction.NTSB ATL93LA075Accident · Minor injuriesLimited investigationFinal reportBell UH1F · Gatlinburg, TNThe loss of engine power for unknown reasons.NTSB ATL93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Elizabethton, TNA loss of engine power on one engine for undetermined reasons.NTSB NYC93LA077Accident · No injuriesLimited investigationFinal reportFawcett Titan Tornado · East Moriches, NYThe loss of engine power for undetermined reasons.NTSB NYC93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Dowingtown, PAThe loss of engine power for undetermined reasons.NTSB FTW93FA117Accident · 1 fatalField investigationFinal reportBeech C-45H · Mooringsport, LAA total loss of right engine power, and a partial loss of left engine power, for undetermined reasons.NTSB FTW93FA115Accident · Minor injuriesField investigationFinal reportChance Vought F4U-4 · Breckenridge, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing