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 LAX00LA336Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Phoenix, AZLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain available for a straight ahead landing during the takeoff initial climb.NTSB SEA00LA176Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ontario, ORThe pilot-in-command/flight instructor's failure to adequately refuel the aircraft, resulting in fuel exhaustion, and his subsequent high flare in a forced landing attempt, resulting in a stall and touchdown/impact on the nose gear.NTSB NYC00LA263Accident · No injuriesLimited investigationFinal reportBell 206B · North Arlington, NJThe pilot's improper decision to fly with an insufficient fuel quantity. A factor in the accident was the failure of the fuel boost pump.NTSB CHI00LA298Accident · No injuriesLimited investigationFinal reportMorrison E-RACER · Sugar Grove, ILthe owner/builder's inadequate modification to the engine air intake system and the inadvertent engine shutdown. Factors included the low air pressure of the air intake system and the excessive fuel flow to the manifold.NTSB FTW00LA255Accident · No injuriesLimited investigationFinal reportMooney M20 · Owasso, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL00LA088Accident · No injuriesLimited investigationFinal reportCessna 188 · Tampa, FLThe failure of the number six-piston connecting rod that resulted in the total loss of engine power.NTSB NYC00LA261Accident · Minor injuriesLimited investigationFinal reportCarlson CA-8 · East Palestine, OHFuel starvation as a result of the pilot's inadequate pre-flight inspection. A factor in this accident was the inadequate marking of the fuel selector valve to clearly indicate a fully open position.NTSB FTW00LA253Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Erick, OKthe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA252Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Eugene Is 296bThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW00LA248Accident · No injuriesLimited investigationFinal reportCessna 150F · Guthrie, OKThe partial loss of engine power due to undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI00LA285Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Cape Girardeau, MOthe pilot's improper decision to continue the flight when the fuel sight gauge indicated empty and the exhausted fuel supply. A factor was the corn crop.NTSB CHI00LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Mason City, IAthe unsuitable terrain for landing encountered by the pilot and the failure of the oil filter converter plate gasket. Factors to the accident were the total loss of oil and the soft terrain condition.NTSB SEA00LA173Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Council, IDthe fatigue failure of the crankshaft due to improper overhaul procedures. Factors include a soft area in the field where the forced landing took place.NTSB MIA00LA253Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Chatom, ALthe pilot's improper preflight planning/decision and failure to ensure an adequate supply of fuel to safely complete the flight to his destination with adequate fuel reserves, which resulted in fuel exhaustion, subsequent engine failure, and a forced landing…NTSB LAX00LA321Accident · No injuriesLimited investigationFinal reportFogerson Richard D RV-6A · El Monte, CAThe loss of engine power for undetermined reasons.NTSB MIA00LA251Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Daytona Bch Sh, FLa loss of engine power due to undetermined reasons, that resulted in the aircraft being ditched.NTSB LAX00LA317Accident · No injuriesLimited investigationFinal reportSteinke Early Bird -JENNY · Chino, CAThe engine lost power for undetermined reasons and nosed over in a soft field during the resulting forced landing.NTSB SEA00LA170Accident · No injuriesLimited investigationFinal reportHughes 369E · Coolin, IDThe turbine outlet temperature indicating system was out of calibration. Factors included improper maintenance calibration, which resulted in the over temperature of the turbine assembly.NTSB NYC00LA233Accident · Serious injuriesLimited investigationFinal reportGrooms Titan Tornado · Libertytown, MDAn engine seizure due to improper reconditioning of piston/cylinder after a previous seizure. A factor was the unsuitable terrain, to which, the forced landing was made.NTSB FTW00FA235Accident · 4 fatalField investigationFinal reportGulfstream American AA-5B · Barrett, TXthe pilot's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent stall. A contributing factor was the loss of engine power for undetermined reasons.NTSB SEA00LA166Accident · No injuriesLimited investigationFinal reportFairchild 24G · Cascade Locks, ORThe pilot's failure to apply carburetor heat after experiencing a partial power loss while flying under conditions conducive to the formation of carburetor ice. Factors include the presence of carburetor icing conditions and an expanse of water (Columbia…NTSB ATL00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Vero Beach, FLThe pilot's inability to control the aircraft after landing due to a loss of engine power and landing gear failure for undetermined reasons. A factor in the severity of the accident was the impact with the airport marker lights.NTSB CHI00LA261Accident · No injuriesLimited investigationFinal reportCessna 152 · New London, MOthe fuel exhaustion and inadequate preflight planning/preparation by the pilot.NTSB CHI00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chapin, ILthe pilot's failure to refuel the aircraft prior to the flight and exhaustion of the fuel supply. A factor to the accident was the embankment.NTSB MIA00LA238Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe flight instructor's failure to identify a partial loss of engine power during takeoff roll, and his failure to maintain airspeed while attempting to return to the airport after takeoff resulting in the airplane stalling and descending uncontrolled until…NTSB CHI00MA256Accident · 2 fatalMajor investigationFinal reportNorth American NA-265-80 · Ironwood, MIthe pilot's improper in-flight decision, the pilot's continued flight into known adverse weather, the pilot's failure to turn on the continuous ignition in turbulence, and the pilot's failure to follow the procedures for an airstart. Factors included the…NTSB LAX00LA295Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newell, CAA hidden depression in the ground that resulted in the collapse of the landing gear during the forced landing roll.NTSB LAX00LA293Accident · 2 fatalLimited investigationFinal reportBarclay/Vincent Murphy SR 2500 · Bakersfield, CAAdjustment by other maintenance personnel of the idle speed stop screw. The idle speed stop screw was backed off from the throttle shaft arm, not allowing the butterfly valve to operate properly, which resulted in the butterfly valve remaining closed during a…NTSB SEA00LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802F · Salmon River, IDCompressor turbine blade failure due to high-cycle fatigue initiating in the surface of the fir-tree root. Factors include unsuitable terrain for an emergency landing.NTSB SEA00LA157Accident · No injuriesLimited investigationFinal reportHamer Lancair 235 · Chiloquin, ORLoss of engine power due to a fracture and separation of the engine's crankshaft. A factor was a vehicle on the roadway.NTSB CHI00LA252Accident · No injuriesLimited investigationFinal reportCessna 182Q · Warsaw, MOInadequate maintenance and the pilot's failure to maintain airspeed which resulted in failure of the carburetor and an inadvertent stall.NTSB MIA00LA233Accident · No injuriesLimited investigationFinal reportCessna 188B · Washington, NCa loss of engine power for undetermined reason, resulting in a forced landing, and subsequent impact with a ditch.NTSB NYC00LA219Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Post Mills, VTwas the pilot's improper fuel management which resulted in power loss due to fuel starvation.NTSB CHI00LA245Accident · No injuriesLimited investigationFinal reportCessna 152 · Arthur, NDthe water contamination found in the fuel and the pilot misjudging his altitude during the emergency procedure. A factor was the terrain condition of the corn crop.NTSB SEA00LA150Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oregon City, ORA loss of engine power for undetermined reason(s). A factor was the rough/uneven terrain.NTSB SEA00LA146Accident · No injuriesLimited investigationFinal reportJonas Falcon XP · Pendleton, ORA loss of engine power for undetermined reasons. A factor was rough/uneven terrain in the forced landing area.NTSB NYC00FA210Accident · 1 fatalField investigationFinal reportMooney M20E · Lunenburg, MAThe pilot's inadequate preflight planning which resulted in exhaustion of the fuel supply.NTSB LAX00LA278Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons.NTSB CHI00LA224Accident · Minor injuriesLimited investigationFinal reportBohner Pitts Model 12 · Neosho, MOThe unsuitable terrain the pilot selected during his emergency landing. Factors were the hay rolls and the loss of engine power for undetermined reasons.NTSB SEA00LA143Accident · Serious injuriesLimited investigationFinal reportJim Weseman Challenger II · Chiloquin, ORLoss of engine power for undetermined reasons. Unsuitable terrain and the pilot's failure to maintain aircraft control were factors.NTSB NYC00LA205Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Logan, WVFuel exhaustion of the engine due to improper fuel consumption calculations performed by the pilot.NTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.NTSB NYC00MA201Accident · 2 fatalMajor investigationFinal reportGrumman G-159 · Linneus, METhe pilot-in-command's failure to maintain minimum control airspeed, which resulted in a loss of control. Factors in this accident were clouds, and a loss of engine power for undetermined reasons, while in cruise flight above the airplane's single engine…NTSB CHI00LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, WIthe blocked lubricating system and unsuitable terrain.NTSB FTW00FA208Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Houston, TXthe loss of engine power for an undetermined reason during maneuvering. Contributing factors were the dark night light conditions and the lack of suitable terrain for the forced landing.NTSB FTW00LA209Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB MIA00LA220Accident · No injuriesLimited investigationFinal reportAeronca 65-TC · Harris, NCThe unsuitable terrain encountered by the pilot while descending for a forced landing. Contributing to the accident was the partial loss of engine power due a blocked fuel line resulting in fuel starvation.NTSB FTW00LA205Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Rio Grande City, TXthe loss of engine power for undetermined reasons. Contributing factors were the pilot flying the airplane with known deficiencies, and the lack of suitable terrain for the forced landing.NTSB CHI00LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Washington, KSthe failure of the number-two connecting rod bearing and the unsuitable terrain for landing encountered by the pilot during the forced landing. A factor to the accident was the rough/uneven field.NTSB CHI00LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Topeka, KSthe restricted fuel line, and the pilot not attaining proper runway alignment during the forced landing. Factors were the low altitude at which the engine failure occurred, and the landing gear overload.