NTSB investigations
3,823 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '341' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR12CA172Accident · No injuriesData collectionFinal reportRockwell International S-2R · Palouse, WAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s distraction and subsequent failure to have the airplane refueled.NTSB CEN12FA249Accident · Minor injuriesField investigationFinal reportHeiser Robert C JR Pulsar XP · San Angelo, TXThe loss of engine power due to fuel starvation as a result of a blocked fuel vent line.NTSB ERA12LA293Accident · No injuriesLimited investigationFinal reportPrendergast John/Vans RV-7A · Gerrardstown, WVThe pilot/builder's misjudgment of the required spacer width needed after engine housing lap grinding, which resulted in bearing oil hole misalignment and insufficient internal engine lubrication.NTSB WPR12CA166Accident · Minor injuriesData collectionFinal reportMooney M20B · Rosamond, CAA loss of engine power during takeoff due to fuel starvation as a result of the pilot’s selection of an empty fuel tank prior to departure.NTSB ERA12LA285Accident · Serious injuriesLimited investigationFinal reportWilloughby Pete A Streak Shadow · Salem, WVA total loss of engine power due to a piston seizure that resulted from a fuel system restriction and poorly secured fuel lines. Contributing to the accident were the pilot/builder’s failure to follow the engine manufacturer procedures and his use of…NTSB ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.NTSB CEN12LA244Accident · Serious injuriesLimited investigationFinal reportT Bird Golden Circle Air II · Clara City, MNThe airplane's loss of engine power for reasons that could not be determined because postaccident examination did not reveal any malfunctions or anomalies that would have precluded normal operation.NTSB CEN12LA245Accident · Minor injuriesLimited investigationFinal reportNelson Sydney/Nelson Diann Zodiac XL · Medina, OHA cracked fuel line, which resulted in a loss of fuel pressure and subsequent loss of engine power.NTSB ERA12CA276Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Iuka, MSThe pilot's improper preflight planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Daytona Beach, FLA total loss of engine power due to a catastrophic engine failure, the origin of which could not be determined during postaccident examination.NTSB ERA12CA275Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Ruleville, MSThe pilot's inadequate preflight planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR12LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Casper, WYA total loss of engine power during cruise flight due to a failed piston pin plug, which resulted in engine oil contamination and subsequent oil starvation. Contributing to the loss of power was the failure of maintenance personnel to identify contaminants…NTSB ERA12LA268Accident · No injuriesLimited investigationFinal reportHawker Beechcraft C90GTX · Caribbean Sea, A1A complete loss of engine power due to fuel exhaustion as a result of the pilot's failure to verify that sufficient fuel was onboard prior to flight. Contributing to the accident was the pilot's misreading of the fuel ticket and his improper operation of the…NTSB ERA12FA265Accident · Serious injuriesField investigationFinal reportSapp Larry E Seawind 3000 · Deland, FLA total loss of engine power for reasons that could not be determined because the damage and postimpact fire precluded thorough examination of the engine and its systems.NTSB CEN12LA224Accident · No injuriesLimited investigationFinal reportCessna U206B · Winterset, IAThe loss of oil pressure to the No. 4 connecting rod journal and the subsequent loss of engine power.NTSB ERA12LA261Accident · No injuriesLimited investigationFinal reportCessna 210-5 · Lake Wales, FLThe pilot's inadequate preflight preparation and fuel management, which resulted in a total loss of engine power due to fuel starvation.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 CEN12FA210Accident · 1 fatalField investigationFinal reportBeech E-55 · Broken Bow, NEThe pilot’s failure to maintain airspeed and subsequent loss of airplane control during a single-engine landing approach. Contributing to the accident was the pilot's improper fuel management during cruise flight, which resulted in an initial loss of power in…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 ERA12LA241Accident · No injuriesLimited investigationFinal reportCessna 172K · Belfast, METhe flight instructor’s failure to ensure the radio was set correctly to activate the pilot-controlled lighting, which resulted in poor positioning for a proper landing and a subsequent off-runway forced landing during an attempted go-around. Contributing to…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 CEN12LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · East Troy, WIThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.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 CEN12LA169Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Cypress, TXThe pilot's improper preflight planning/preparation and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion during the approach to the destination airport.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 CEN12LA141Accident · No injuriesLimited investigationFinal reportBell 206B · Irving, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.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).…