NTSB investigations
3,824 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 ERA10LA395Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Blossvale, NYA total loss of engine power for undetermined reasons.NTSB CEN10LA449Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMA total loss of engine power following a loss of oil pressure for undetermined reasons.NTSB CEN10LA455Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · Kountze, TXA loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB ERA10LA383Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Holly Hill, SCMaintenance personnel's improper inspection and cleaning of the fuel nozzle, which resulted in a total loss of engine power.NTSB CEN10LA450Accident · No injuriesLimited investigationFinal reportCessna T188C · Montezuma, INThe total loss of engine power due to an insufficient fastener preload that led to the failure of the No. 2 connecting rod assembly.NTSB WPR10FA371Accident · 3 fatalField investigationFinal reportAmerican Eurocopter AS 350 B3 · Tucson, AZThe repair station technician did not properly install the fuel inlet union during reassembly of the engine; the operator’s maintenance personnel did not adequately inspect the technician's work; and the pilot who performed the post maintenance check flight…NTSB CEN10LA440Accident · No injuriesLimited investigationFinal reportBeech F35 · Enid, OKA loss of engine power for undetermined reasons.NTSB CEN10CA441Accident · Minor injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INA loss of engine power during initial climb due to fuel exhaustion. Contributing to the accident was the pilot's diverted attention while attempting to restart the engine.NTSB CEN10LA437Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Yates City, ILThe loss of engine power for undetermined reasons.NTSB CEN10LA433Accident · No injuriesLimited investigationFinal reportBeech H35 · Green Lake, WIA total loss of engine power during descent due to the overhaul facility’s inadequate maintenance.NTSB CEN10LA431Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Rochester, MNThe total loss of engine power due to a high-cycle fatigue fracture of a first-stage compressor blade. The reason for the fracture could not be determined during postaccident examination.NTSB CEN10LA430Accident · 1 fatalLimited investigationFinal reportPiper PA-28-151 · Spearfish, SDThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB WPR10LA366Accident · 1 fatalLimited investigationFinal reportClark RV-9A · Oregon City, ORThe pilot's decision to depart with known mechanical anomalies and the loss of engine power for undetermined reasons.NTSB CEN10FA465Accident · 4 fatalField investigationFinal reportCessna U206F · Ludington, MIThe total loss of engine power due to fuel starvation as a result of accumulated debris in the fuel system from an undetermined source. Also causal was the inadequate annual maintenance inspection that did not include inspection of the firewall fuel strainer…NTSB CEN10LA425Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar · Cleburne, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident were the critical fuel placards that were difficult to see due to the airplane's paint scheme.NTSB CEN10LA420Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Toulin, ILA partial loss of engine power as a result of a cracked cylinder and the reduced visibility due to the oil-covered windshield.NTSB ERA10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · New Bern, NCInadequate quality control at the fuel servo overhaul facility, which resulted in contamination of the fuel servo and a subsequent loss of engine power due to fuel starvation.NTSB CEN10LA409Accident · 1 fatalLimited investigationFinal reportDavis John TR-4 · Denton, TXA loss of engine power and the pilot’s subsequent loss of control for undetermined reasons.NTSB WPR10LA357Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Phoenix, AZA loss of engine power during descent due to fuel starvation that resulted from the pilot's mismanagement of the fuel system.NTSB ERA10FA364Accident · 2 fatalField investigationFinal reportS.C. Aerostar Yak52 · South Portland, METhe pilot did not maintain adequate airspeed during an emergency return to the airport following a total loss of engine power, which resulted in an inadvertent stall. Contributing to the accident was a total loss of engine power for undetermined reasons and…NTSB CEN10LA416Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Krum, TXA total loss of engine power in flight due to carburetor icing.NTSB CEN10CA400Accident · Serious injuriesData collectionFinal reportCessna 182R · Thayer, INA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually check the fuel supply prior to takeoff.NTSB CEN10FA385Accident · 3 fatalField investigationFinal reportCessna 177B · Owasso, OKThe pilot’s failure to maintain adequate airspeed during an engine-out approach to the runway, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in a loss of engine power due…NTSB WPR10LA345Accident · No injuriesLimited investigationFinal reportCessna 177 · Chino, CAThe pilot’s inadequate fuel planning which resulted in a loss of engine power during cruise flight due to fuel exhaustion.NTSB CEN10FA382Accident · 3 fatalField investigationFinal reportCessna 421 · Tulsa, OKThe pilot’s inadequate preflight fuel planning and management in-flight, which resulted in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s use of performance-impairing medications.NTSB WPR10LA341Accident · Serious injuriesLimited investigationFinal reportRonald V White CH701 · Pima, AZA total loss of engine power while maneuvering due to a spark plug failure.NTSB WPR10LA343Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Whitehall, MTA loss of engine power for undetermined reasons.NTSB CEN10LA404Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Deshler, OHA loss of engine power for undetermined reasons.NTSB WPR10LA339Accident · Minor injuriesLimited investigationFinal reportDouglas A4L · Fallon, NVA loss of engine power during takeoff due to the failure of the engine's stator and turbine. Contributing to the accident was inadequate maintenance.NTSB WPR10CA311Accident · No injuriesData collectionFinal reportCessna 172F · Rancho Murieta, CAA total loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR10CA332Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Garfield, WAA loss of engine power due to fuel exhaustion.NTSB ERA10LA349Accident · No injuriesLimited investigationFinal reportBeech F33A · Mooresville, NCA loss of engine power for undetermined reasons.NTSB WPR10LA331Accident · No injuriesLimited investigationFinal reportCessna 210 · Coeur d'Alene, IDThe loss of engine power during cruise flight for undetermined reasons.NTSB CEN10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Centerville, MOA loss of engine power due to carburetor icing as a result of the pilot not using carburetor heat.NTSB CEN10FA364Accident · 2 fatalField investigationFinal reportBeech F33A · Perry, KSThe failure of the engine driven fuel pump causing a loss of engine power and the pilot's failure to maintain aircraft control resulting in an inadvertent stall. Contributing to the accident was the pilot’s failure to follow the emergency procedures checklist…NTSB CEN10CA398Accident · No injuriesData collectionFinal reportBradshaw Quicksilver MX II · Newark, ILA total loss of engine power during cruise when the ignition switch vibrated into the "off" position, leading to the airplane's impact with a ditch during the off-field landing.NTSB ANC10LA056Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Iliamna, AKThe total loss of engine power during cruise flight due to a fractured crankshaft.NTSB ERA11WA157Incident · No injuriesForeign investigationBeech 300 · Jundiai, BrazilOn June 29, 2010, about 1910 UTC, a Beech 300, Brazilian registration PP-EPD, operated by The Government of the State of Amazonas, Brazil had a blown tire during the landing roll following a forced landing shortly after takeoff from Jundiai Airport (SBJD),…NTSB ERA10CA353Accident · No injuriesData collectionFinal reportLawwill Ted Zodiac 601XL · Waddy, KYA loss of engine power due to fuel starvation for undetermined reasons.NTSB CEN10CA359Accident · Minor injuriesData collectionFinal reportPiper PA28R · McGregor, TXA total loss of engine power for undetermined reasons. Contributing to the severity of injuries was the airplane's lack of shoulder harnesses.NTSB WPR10LA316Accident · No injuriesLimited investigationFinal reportMcGlashan T-51 Mustang · Columbia, CAA loss of engine power during approach due to thermal damage to the engine's electronic ignition module. Contributing to the accident was the builder’s placement of the ignition module near the engine’s exhaust.NTSB WPR10CA348Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Moreno Valley, CAA total loss of engine power due to fuel exhaustion.NTSB ERA10LA335Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Babylon, NYThe loss of engine power due to the failure of the oil filter gasket and the subsequent engine oil depletion.NTSB ERA10CA333Accident · No injuriesData collectionFinal reportQuartz Mountain Aerospace 11E · Inglis, FLA loss of engine power due to fuel exhaustion as a result of the pilot's fuel mismanagement.NTSB CEN10CA362Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Grand Junction, COThe total loss of engine power for undetermined reasons.NTSB WPR10CA314Accident · No injuriesData collectionFinal reportBell 206B · Rickreall, ORA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to ensure that adequate fuel was aboard for the flight.NTSB ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…NTSB CEN10CA330Accident · No injuriesData collectionFinal reportTaylorcraft DCO-65 · Akron, OHThe loss of engine power for undetermined reasons.NTSB CEN10CA326Accident · Minor injuriesData collectionFinal reportRemos G3/600 · Trinidad, COA total loss of engine power in flight due to fuel exhaustion for unknown reasons.NTSB ERA10LA325Accident · Minor injuriesLimited investigationFinal reportSchleicher ASH26 · Shelbyville, TNA complete loss of electrical and engine power over unsuitable terrain due to a cannon plug that became disconnected for undetermined reasons.