NTSB investigations
3,825 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 CEN18LA356Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Partridge, KSThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR18LA250Accident · No injuriesLimited investigationFinal reportStoddard Hamilton Glasair Super IIS · Yuma, AZA total loss of engine power as a result of the detachment of the throttle linkage from the throttle arm of the fuel injector servo due to an insufficiently tightened and secured bolt and the subsequent inadequate maintenance inspection.NTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rushville, INLoss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.NTSB CEN18LA354Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bowman, NDThe loss of engine power due to fuel starvation.NTSB ERA18FA231Accident · 4 fatalField investigationFinal reportCessna 182 · Swainsboro, GAThe total loss of engine power for reasons that could not be determined based on available information.NTSB ERA18FA230Accident · 1 fatalField investigationFinal reportAeronca 7AC · Hanson, MAA loss of engine power due to carburetor icing, the pilot's decision to turn back to the runway shortly after takeoff, and his failure to maintain airspeed during the turn, which resulted in an exceedance of the airplane's critical angle of attack, and…NTSB ERA18LA228Accident · Serious injuriesLimited investigationFinal reportCessna T206 · Pittsfield, MEWear of the No. 4 cylinder exhaust camshaft lobe and roller tappet, which resulted in the failure of the tappet and the subsequent total loss of engine power.NTSB CEN18LA348Accident · No injuriesLimited investigationFinal reportPiper PA32R · Falcon, COThe pilot's decision to depart with an inoperative left magneto, which resulted in degraded climb performance in high-density altitude conditions and a subsequent emergency landing.NTSB CEN18LA347Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Little Rock, ARThe total loss of engine power for reasons that could not be determined based on the available evidence, which resulted in a forced landing on unsuitable terrain.NTSB WPR18LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 400 · Grand Forks, NDThe loss of engine power while maneuvering due to the failure of the power turbine blade assembly for reasons that could not be determined based on available evidence.NTSB WPR18LA233Accident · No injuriesLimited investigationFinal reportBlue Oak CCK-1865 · Deadwood, CAA loss of engine power due to fuel exhaustion and the pilot's failure to ensure that the left-wing fuel cap was secure before flight. Contributing to the accident was the pilot's failure to monitor fuel levels while in flight.NTSB CEN18LA340Accident · No injuriesLimited investigationFinal reportBeech B36TC · LaPorte, TXThe loss of engine power due to a torn intercooler hose that resulted in an overly rich fuel mixture, which, when combined with the pilot's activation of the auxiliary fuel pump, flooded the engine.NTSB ERA18LA224Accident · No injuriesClass 3 · LimitedFinal reportGlasair SHA · Greenville, NCA total loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s misjudgment of the airplane’s glidepath during the forced landing, which resulted in the airplane touching…NTSB ERA18LA227Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Mayport, FLThe failure of a fuel line due to improper installation of a fuel flow sensor, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…NTSB WPR18LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Marsing, IDThe loss of engine power during a low pass as a result of a blockage of the carburetor idle chambers which led to a forced landing in a river.NTSB WPR18LA222Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Northport, WAA total loss of engine power during a climb due to an accumulation of molten environmental particles, the source of which could not be determined based on the available evidence, which resulted in a forced landing.NTSB WPR18FA219Accident · 1 fatalField investigationFinal reportBeech A36TC · Sylmar, CAThe pilot's failure to maintain airplane control following a total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18TA223Accident · No injuriesFinal reportZenair Zenith Stol CH750 · Napa, CAThe pilot's use of fuel below the required octane rating, which caused engine detonation and damage and subsequently led to oil exhaustion and a total loss of engine power in flight. Contributing to the accident was the pilot's inadequate service/maintenance…NTSB DCA18WA284Incident · No injuriesForeign investigationBoeing 777 · Lahore, PakistanThe Safety Investigation Board (SIB) Pakistan has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on August 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation…NTSB ANC18LA064Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Iliamna, AKA total loss of engine power due to detonation/preignition damage of the No. 2 cylinder and piston for reasons that could not be determined.NTSB CEN18LA321Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Sedalia, MOA total loss of engine power during low-altitude maneuvering for reasons that could not be determined due to postimpact fire damage.NTSB CEN18LA317Accident · No injuriesLimited investigationFinal reportCessna 120 · Pomona, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a forced landing.NTSB GAA18CA468Accident · No injuriesData collectionFinal reportCessna 185 · Lovelock, NVThe pilot's improper in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CEN18LA319Accident · No injuriesLimited investigationFinal reportBeech 35 · Knox, INThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18LA302Accident · No injuriesLimited investigationFinal reportBeech A36 · Brainerd, MNTotal loss of engine power due to a fuel supply interruption from the left tank for reasons that could not be determined, which resulted in the subsequent forced landing into trees.NTSB ANC18LA058Accident · No injuriesLimited investigationFinal reportRobinson R44 · Bettles, AKMaintenance personnel's application of insufficient preload on the attachment hardware for the idler gear shaft during engine overhaul, which resulted in the dismounting of the idler gear shaft assembly due to wear and deformation and the subsequent total…NTSB GAA18CA465Accident · No injuriesData collectionFinal reportBellanca 8GCBC · El Dorado, ARThe pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ERA18WA219Accident · 3 fatalForeign investigationCessna 210 · Sao Felix do Xingu, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on July 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN18LA300Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Le Sueur, MNThe pilot's inadequate preflight and in-flight fuel planning, during which he did not visually check the fuel quantity in the fuel tanks and instead relied on the fuel gauges that were showing erroneous fuel quantity indications, which resulted in fuel…NTSB ERA18TA203Accident · No injuriesFinal reportBeech C90 · Lecanto, FLThe pilot's failure to turn on the fuel transfer pumps in accordance with the published checklists, which resulted in a dual loss of engine power due to fuel starvation.NTSB GAA18CA454Accident · No injuriesData collectionFinal reportCessna 172 · Meadow Lakes, AKThe pilot’s selection of the wrong fuel tank for departure, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB GAA18CA519Accident · No injuriesData collectionFinal reportCessna 150 · Everett, WAA total loss of engine power due to carburetor icing during final approach, which resulted in a hard landing short of the runway and the nose landing gear collapsing.NTSB CEN18LA285Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Baton Rouge, LAThe loss of right engine power due to fuel starvation, which resulted from corrosion debris in the fuel lines. Contributing to the accident was the mechanic’s and pilot’s inadequate maintenance of the airplane before the flight.NTSB WPR18LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMicrolites Ptyltd Dragonfly B · Buckley, WAA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18LA199Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC19 · Hyrum, UTThe pilot’s improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent loss of engine power. Contributing to the accident was the pilot’s distraction due to a malfunctioning hangar door and a…NTSB ERA18LA195Accident · No injuriesLimited investigationFinal reportEagle DW1 · Ider, ALFatigue failure of the No. 2 cylinder studs/through bolts and the fracture of the crankcase, which resulted in a total loss of engine power.NTSB CEN18WA375Accident · No injuriesForeign investigationCessna Cessna R182 · Les Rabassieres, FranceOn July 17, 2018, at 1300 UTC, a Cessna 182, G-BHYA, S/N R182-00532, experienced an engine failure on a local flight from a private airfield in Les Rabassières, France. The pilot declared an emergency landing and the airplane experienced a runway excursion…NTSB CEN18LA276Accident · No injuriesLimited investigationFinal reportBeech V35 · Katy, TXMaintenance personnel’s failure to remove a paper towel from the engine during recent maintenance, which resulted in oil starvation, the failure of a connecting rod, and a catastrophic engine failure and subsequent total loss of engine power.NTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…NTSB CEN18LA269Accident · Serious injuriesLimited investigationFinal reportBell 47J · Franklin, INA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA18TA193Accident · Serious injuriesFinal reportQuicksilver MXL II · Arecibo, PRThe noncertificated pilot's improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR18LA193Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Ontario, ORA total loss of engine power during final approach for reasons that could not be determined based on the available information.NTSB CEN18IA273Incident · No injuriesIncident investigationFinal reportCessna A188B · Rockford, OHThe total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.NTSB GAA18CA421Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, ILThe pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ERA18LA190Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Passadumkeag, MEA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB WPR18LA189Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164B · Colusa, CATotal loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA431Accident · Minor injuriesData collectionFinal reportCessna 172 · King and Queen, VAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA18CA397Accident · Minor injuriesData collectionFinal reportRobert Miles Smith Trike · Lewiston, ILA total loss of engine power due to the pilot's failure to apply carburetor heat in conditions conducive to carburetor icing and his subsequent failure to maintain directional control during a forced landing.