NTSB investigations
2,826 cases where the defining event was Loss of engine power (total).
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '341') 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 ERA12LA260Accident · Minor injuriesLimited investigationFinal reportHughes 369D · McCormick, SCThe pilot's decision to use automotive fuel instead of the approved alternate fuel, which resulted in a total loss of engine power.NTSB CEN12LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Arcola, TXA total loss of engine power during landing approach for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12FA217Accident · 1 fatalField investigationFinal reportOliver Joseph Zodiac CH 601XL · Belmont, OHThe loss of engine power and the pilot’s diverted attention to the engine power loss, which resulted in a rapid descent and impact with terrain.NTSB ERA12LA258Accident · No injuriesLimited investigationFinal reportRotorcraft Developement OH-58C · McComb, MSA total loss of engine power due to oil starvation at the Nos. 5 and 8 engine bearings, which resulted in a catastrophic engine failure.NTSB WPR12LA146Accident · No injuriesLimited investigationFinal reportJacobs RV-6A · Bow, WAThe total loss of engine power due to fuel starvation as a result of the pilot’s mismanagement of the fuel supply.NTSB ERA12LA253Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Margaret, ALThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power during cruise flight due to fuel starvation.NTSB ERA12LA252Accident · No injuriesLimited investigationFinal reportNew Kolb Mark III Classic · Deland, FLThe pilot's lack of preflight planning for potential carburetor icing conditions, and the subsequent flight in those conditions in an airplane not equipped with carburetor heat.NTSB ERA12LA246Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Beaver Falls, PAThe operator’s maintenance personnel’s improper adjustment of the engine's fuel system, which resulted in a total loss of engine power.NTSB CEN12LA239Accident · Minor injuriesLimited investigationFinal reportGerner Evans WE-1 · Kimball, NEThe loss of engine power for reasons that could not be determined because a postaccident examination of the airplane and engine was not performed.NTSB WPR12LA147Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · St. George, UTThe total loss of engine power due to the loose mixture control arm.NTSB ERA12LA234Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLA total loss of engine power due to the improper installation of the crankshaft gear bolt or lockplate by maintenance personnel. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB ERA12LA229Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Venice, FLA total loss of engine power due to a loss of fuel pressure. The cause for the loss of fuel pressure could not be determined during postaccident testing.NTSB ERA12LA227Accident · 2 fatalLimited investigationFinal reportEmeraude CP-301-A · Niceville, FLThe pilots’ inadequate use of carburetor heat, which resulted in carburetor icing and a subsequent loss of engine power.NTSB WPR12LA128Accident · No injuriesLimited investigationFinal reportBeech 76 · Rio Linda, CAA loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat during descent while operating in an area conducive to carburetor icing.NTSB ERA12LA219Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Homestead, FLThe inadequate servicing and maintenance of the engine and the airplane owner and maintenance personnel's disregard of the manufacturer's recommended engine overhaul schedule and service bulletins, which resulted in an in-flight internal failure and seizure…NTSB ERA12LA206Accident · Serious injuriesLimited investigationFinal reportMooney M20M · Amisville, VAA total loss of engine power during cruise flight for reasons that could not be determined because of the damage due to the postcrash fire.NTSB ERA12CA198Accident · No injuriesData collectionFinal reportLester Robert E KR-2 · Boca Raton, FLThe failure of the airplane’s engine air inlet system resulting in a total loss of engine power.NTSB CEN12LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Rapid City, SDThe loss of engine power during climb due to carburetor icing. Contributing to the accident was the limited travel of the carburetor heat valve which prevented application of maximum carburetor heat.NTSB WPR12LA111Accident · No injuriesLimited investigationFinal reportEnstrom F28 · Kalispell, MTA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA108Accident · No injuriesLimited investigationFinal reportMooney M20J · Lewiston, CAA loss of engine power due to oil starvation as a result of improper maintenance.NTSB CEN12CA165Accident · No injuriesData collectionFinal reportBeech 95-B55 · Lancaster, WIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12FA152Accident · 1 fatalField investigationFinal reportVarga 2150A · Frankston, TXThe loss of engine power due to carburetor ice, which resulted in the pilot ditching the airplane into the lake. Contributing to the accident was the pilot’s decision not to apply carburetor heat.NTSB CEN12LA149Accident · 1 fatalLimited investigationFinal reportPipistrel Virus 912 · Ray, MIA loss of engine power due to fuel starvation for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA165Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Palm Beach, FLThe pilot’s in-flight misjudgment of fuel remaining resulting in fuel exhaustion and a total loss of engine power. Contributing to the accident was an inadequate fuel quantity for the flight for reasons that could not be determined during postaccident…NTSB ERA12LA164Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Clearwater, FLThe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident testing of the engine did not reveal any malfunctions or failures that would preclude normal operation. Contributing to the accident was the…NTSB ERA12LA157Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Port Orange, FLThe total loss of engine power for reasons that could not be conclusively determined during postaccident examination.NTSB ERA12LA148Accident · No injuriesLimited investigationFinal reportCessna 172I · Springfield, TNThe pilot did not apply carburetor heat during approach to landing, which resulted in a total loss of engine power due to carburetor icing.NTSB CEN12LA134Accident · Minor injuriesLimited investigationFinal reportAero Commander 500-B · Bartlesville, OKThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection, which did not correctly identify the airplane’s fuel quantity before departure.NTSB ERA12WA142Accident · No injuriesForeign investigationCirrus Design SR22 · Andros Island, BahamasOn January 7, 2012, about 1324 eastern standard time, a Cirrus Design Corp. SR22, N723EA, registered to and operated by M&W Aviation LLC, descended into water near Andros Island, Bahamas, following deployment of the Cirrus Airframe Parachute System (CAPS).…NTSB CEN12LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · San Angelo, TXA loss of engine power for undetermined reasons.NTSB CEN12LA127Accident · No injuriesLimited investigationFinal reportFleet Fleet 16B · Marion, TXA total loss of engine power due to fuel starvation as a result of a piece of metal in the fuel line, which blocked fuel flow to the engine.NTSB ERA12CA125Accident · Serious injuriesData collectionFinal reportCessna 150H · Knoxville, TNThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR12CA069Accident · Minor injuriesData collectionFinal reportCessna 208 · Mesquite, NVThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN12LA110Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Midland, TXThe pilot’s improper fuel management during the flight, which resulted in a total loss of engine power.NTSB WPR12FA066Accident · Serious injuriesField investigationFinal reportRobinson Helicopter R22 Beta · Tucson, AZA loss of engine power due to the pilot's failure to utilize carburetor heat while maneuvering. .NTSB WPR12LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Friday Harbor, WAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12FA059Accident · 1 fatalField investigationFinal reportVans RV7 - A · Surprise, AZAn electrical or engine electronic problem, which resulted in a loss of engine power, followed by a low-altitude stall.NTSB WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN12LA111Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright P40M · Batavia, OHA loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.NTSB ERA12LA101Accident · No injuriesLimited investigationFinal reportCessna 172D · Belhaven, NCA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12IA158Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Jacksonville, FLThe failure of a crankshaft gear tooth due to fatigue, which resulted in the loss of several additional gear teeth and a subsequent total loss of engine power.NTSB CEN12IA096Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron Canada 407 · Gulf Of MexicoThe failure of the compressor section No. 2 bearing due to false brinnelling and fatigue.NTSB CEN12LA094Accident · No injuriesLimited investigationFinal reportCessna 305A · Fredericksburg, TXThe pilot's inadequate preflight inspection, which resulted in a subsequent loss of engine power due to fuel starvation.NTSB ERA12LA087Accident · No injuriesLimited investigationFinal reportSmith Miniplane DSA-4 · Hernando, FLThe pilot's failure to apply carburetor heat while descending in conditions conducive to carburetor icing, which resulted in carburetor icing and a subsequent total loss of engine power.NTSB ERA12FA084Accident · 3 fatalField investigationFinal reportCessna 177RG · Tallapoosa, GAThe failure of the No. 2 rod end cap bolt, which resulted in a total loss of engine power.NTSB ERA12LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA 46-350P · Caribbean Sea, A1The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…NTSB ERA12WA136Accident · No injuriesForeign investigationPiper PA36 · Machala, EcuadorOn November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…NTSB ERA12WA102Accident · 1 fatalForeign investigationCessna 210 · Alto Alegre, BrazilOn November 22, 2011, at 1740 universal time coordinated, a Cessna Aircraft, Model 210L, Brazilian registration PT-IOT, impacted the ground after reporting an engine failure near Aldeia Hali Katu, in the Alto Alegre Municipality, Roraima, Brazil. The airplane…NTSB CEN12LA076Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · New Orleans, LAA loss of engine power due to detonation of the No.2 cylinder from a clogged fuel injector nozzle.NTSB CEN12CA075Accident · No injuriesData collectionFinal reportGlobe GC-1B · Denver, COA loss of engine power due to fuel starvation as a result of a loose fuel line fitting.