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 CEN18WA403Accident · No injuriesForeign investigationRobin DR400 · Benodet, FranceOn September 3, 2018, about 1005 UTC, a Robin DR400 airplane, French registration F-GSBK, sustained a loss of engine power while in cruise flight near Benodet, France. The three occupants onboard sustained no injury. The airplane was destroyed. The accident…NTSB ANC18LA069Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Wrangell, AKThe total loss of engine power due to oil starvation after an interruption of oil circulation for reasons that could not be determined based on the available evidence.NTSB ERA18LA243Accident · No injuriesClass 3 · LimitedFinal reportPiper PA12 · Cochranton, PAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA241Accident · Minor injuriesLimited investigationFinal reportDiamond DA40 · Mount Pleasant, TNA total loss of engine power for reasons that could not be determined because postaccident examination of the airplane did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18LA362Accident · Serious injuriesClass 3 · LimitedFinal reportLuscombe 8 · New Carlisle, OHA total loss of engine power shortly after takeoff due to carburetor ice.NTSB ERA18LA239Accident · No injuriesClass 3 · LimitedFinal reportAvid MK-4 · Harnett, NCA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18LA357Accident · No injuriesLimited investigationFinal reportGrumman G164 · Opelousas, LAThe loss of two securing bolts that allowed the left magneto to move around, which disrupted the spark timing and resulted in the engine losing total power.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 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 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 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 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 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 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 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 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 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 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 ERA18LA183Accident · 1 fatalLimited investigationFinal reportBell 206 · Rio Grande, PRA total loss of engine power due to oil exhaustion, which resulted in an uncontrolled descent and hard landing.NTSB CEN18WA254Accident · No injuriesForeign investigationBritten Norman BN2A · Ambergris Caye, BelizeNTSB ERA18LA181Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35B33 · Berlin, MDThe failure of the No. 3 cylinder exhaust valve, which resulted in the total loss of engine power during takeoff.NTSB WPR18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Phoenix, AZA total loss of engine power due to crankshaft failure as the result of a subsurface fatigue crack.NTSB CEN18LA239Accident · Serious injuriesLimited investigationFinal reportSibila MH-1 · Beach City, OHThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA18LA177Accident · No injuriesLimited investigationFinal reportCrawford RV-7 · Alexander City, ALA total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18FA235Accident · 2 fatalField investigationFinal reportErcoupe 415 D · Monmouth, ILA loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLA total loss of engine power for reasons that could not be determined due to insufficient evidence.NTSB CEN18LA237Accident · No injuriesLimited investigationFinal reportZenith Stol CH701 · Maple Lake, MNThe total loss of engine power for reasons that could not be determined based on the available evidence.