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 ERA17LA314Accident · No injuriesClass 3 · LimitedFinal reportRudder Dwight K Kitfox IV 1200 Spdst · Raymond, MSA total loss of engine power during initial climb for undetermined reasons.NTSB ENG17RA037Incident · No injuriesForeign investigationBoeing 777 · Tokyo, JapanThe Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a B777-300ER that occurred September 5, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…NTSB CEN17LA338Accident · No injuriesLimited investigationFinal reportGolden Eagle Chief · Mt. Zion, ILA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA17LA307Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206 · Harpswell, MEA total loss of engine power due to maintenance personnel's failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1, 2, and 3 main bearings, loss of lubrication, and failure of the crankshaft.NTSB DCA17WA190Incident · No injuriesForeign investigationEmbraer EMB145 · Medellin, ColombiaThe government of Colombia has notified the NTSB of an incident involving a EMBRAER EMB145 airplane that occurred on August 31, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB ERA17FA299Accident · 2 fatalField investigationFinal reportGrumman AA1 · Portland, TNThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR17LA190Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Lake Havasu City, AZThe pilot's incorrect positioning of the fuel tank selector valve during a tank switch, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the worn condition of the fuel selector valve handle position detents and…NTSB CEN17WA384Accident · No injuriesForeign investigationDiamond DA20 · Sankt Veit, AustriaThe government of Austria has notified the NTSB of an accident involving a DIAMOND DA20 airplane that occurred on August 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions…NTSB ERA17LA302Accident · No injuriesLimited investigationFinal reportPacific Aerospace 750XL · Harvest, ALThe pilot's improper decision to not stop and refuel the airplane as planned and his improper in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17FA332Accident · Serious injuriesField investigationFinal reportCessna 180J · Gaylord, MIThe pilot's failure to use carburetor heat while operating in weather conditions that were conducive to carburetor ice formation, which resulted in a total loss of engine power due to carburetor ice accumulation.NTSB CEN17FA331Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Ellabell, GAThe total loss of engine power due to oil starvation to the No. 1 connecting rod, which resulted from the improper torque of the No. 1 cylinder hold-down bolts and through-studs at the time of the cylinder's installation, which resulted in the failure of the…NTSB WPR17LA191Accident · No injuriesLimited investigationFinal reportNorth American Navion A · Fortuna, CAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have that would have precluded normal operation.NTSB ERA17WA351Incident · No injuriesForeign investigationCessna 207 · Recanati, ItalyThe government of Italy has notified the NTSB of an accident involving a CESSNA 207 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB ERA17WA296Accident · 1 fatalForeign investigationCessna T210 · Ciudad Bolivar, VenezuelaOn August 27, 2017 about 2052 coordinated universal time (UTC), a Cessna T210M, Venezuelan registration YV2594, was substantially damaged during a forced landing, after a loss of engine power near Ciudad Bolivar, Venezuela. The pilot and three passengers were…NTSB WPR17LA194Accident · No injuriesClass 3 · LimitedFinal reportPaul Gaywood E CH 601 HD · Goldendale, WAA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA511Accident · No injuriesData collectionFinal reportPiper PA 12 · Gulkana, AKThe pilot’s inadequate in-flight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA17CA295Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Palatka, FLThe student pilot's overpriming of the engine and the flight instructor's delayed remedial action, which resulted in an engine fire.NTSB WPR17LA187Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 310I · Salt Lake City, UTA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17LA329Accident · No injuriesLimited investigationFinal reportJames M Raulerson CH 750 · Manila, ARA loss of engine power for reasons that could not be determined because the airplane was not available for examination.NTSB GAA17CA505Accident · No injuriesData collectionFinal reportCessna 177RG · Byron, CAThe pilot’s improper preflight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA17LA284Accident · No injuriesLimited investigationFinal reportMooney M20C · Palm Coast, FLA crack in the No. 4 cylinder head, which resulted in engine roughness, a fuel leak, a loss of engine power, and the subsequent in-flight fire.NTSB ERA17LA300Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-200 · St. Augustine, FLA total loss of engine power for reasons that could not be determined because examination of the airplane and engine did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation and because the amount…NTSB ERA17LA281Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Green Creek, NJThe pilot's exhaustion of the fuel supply in the selected tank.NTSB ERA17LA282Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · Fairhope, ALA total loss of engine power for reasons that could not be determined because postaccident examination and a test run of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17LA280Accident · 1 fatalLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VAThe flight instructor and commercial pilot's inadequate preflight inspection, which resulted in water contamination of the fuel supply, and a total loss of engine power.NTSB ERA17LA276Accident · Minor injuriesLimited investigationFinal reportBradley Roderick W Murphy Renegade · Guilford, CTA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ANC17LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna T207 · Juneau, AKThe total loss of engine power due to fuel starvation.NTSB ERA17LA275Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Salisbury, CTAn improper replacement of the crankshaft by maintenance personnel, which resulted in a failure of the crankshaft gear and total loss of engine power.NTSB CEN17LA311Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Wellston, OHThe failure of a connecting rod small end bushing, which resulted in a loss of engine power.NTSB CEN17LA309Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Galesburg, ILA total loss of engine power due to the fracture of a single 1st stage compressor rotor airfoil in high-cycle fatigue as a result of the erosion and thinning of the airfoil's leading edge. Contributing to the fractured airfoil and loss of engine power was the…NTSB ERA17RA315Accident · Serious injuriesForeign investigationCessna U206 · Eteringbang, GuyanaOn August 8, 2017, about 1513 coordinated universal time (UTC), a Cessna U206G, 8R-GPR, was substantially damaged during a forced landing in trees shortly after takeoff from Eteringbang Airstrip (SYET), Eteringbang, Cuyuni-Mazaruni Region, Guyana. Visual…NTSB ERA17LA268Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Mount Sterling, KYA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR17FA179Accident · 1 fatalField investigationFinal reportMichaelian Lancair IV-TP · Rio Linda, CAA loss of engine power for reasons that could not be determined based on available evidence.NTSB GAA17CA472Accident · No injuriesData collectionFinal reportMooney M20 · Skiatook, OKThe pilot's improper decision to conduct the flight despite the fuel gauges indicating that there was insufficient fuel for the flight, which resulted in the low amount of fuel in the right tank becoming unported during the multiple turns, and his subsequent…NTSB CEN17WA321Accident · 1 fatalForeign investigationRobinson R44 · Puerto Chiapas, MexicoOn August 2, 2017, about 2115 universal coordinated time, a Robinson R44 helicopter, XB-MWZ, had a loss of engine power and subsequently impacted the Pacific Ocean near Puerto Chiapas, Mexico. Two persons were on board the helicopter. One person was reported…NTSB WPR17LA172Accident · No injuriesLimited investigationFinal reportCessna T210F · Llano, CAA failure of the turbocharger that resulted in complete depletion of the engine oil and catastrophic internal failure of the engine. Contributing to the accident was improper and/or incomplete maintenance and inspection of the turbocharger.NTSB WPR17IA173Incident · No injuriesClass 3 · IncidentFinal reportColumbia Aircraft Mfg LC41 550FG · Chandler, AZThe over-tensioning of the accessory belt, which resulted in damage to the starter adapter and subsequent loss of oil that led to oil starvation and catastrophic engine failure.NTSB WPR17LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Seattle, WAThe total loss of engine power due to oil starvation as a result of the loose right magneto, which allowed oil to escape and the engine to seize. Contributing to the accident was inadequate maintenance, which failed to identify the loose magneto bolt.NTSB CEN17LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA 46 350P · Tahlequah, OKThe total loss of engine power, which resulted from fatigue failure of two engine through bolts and the No. 2 cylinder attachment studs due to the lack of sufficient clamping force.NTSB WPR17LA168Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Lake Sutherlin, MTThe pilot’s transition into an out-of-ground-effect hover in high-density altitude conditions that exceeded the helicopter’s performance capabilities, which resulted in loss of rotor rpm.NTSB CEN17LA285Accident · Serious injuriesLimited investigationFinal reportHillard Charlie R Hawker FB60 · Breckenridge, TXA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB CEN17LA313Accident · No injuriesLimited investigationFinal reportCanion Michael W Zodiac 601XL · Grady, ARThe loss of engine power due to a lack of ignition resulting from a broken alternator wire.NTSB ERA17LA247Accident · No injuriesLimited investigationFinal reportAeroprakt A 20 Vista Cruiser · Shirley, NYThe pilot's inadvertent activation of the engine's choke control during a downdraft encounter, which resulted in a total loss of engine power.NTSB ERA17WA271Accident · Serious injuriesForeign investigationCessna 172 · Khuzhir, RussiaOn July 16, 2017, at 1300 coordinated universal time, a Cessna 172M, Russian registration RA-2842G, ditched into Lake Baikal, near Khuzhir, Irkutskaya Oblast, Russia, after a total loss of engine power. The airplane incurred substantial damage during the…NTSB ANC17LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Wasilla, AKThe pilot’s failure to manage fuel quantity in flight, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow manufacturer guidance for restoring engine power after emptying a fuel…NTSB WPR17LA156Accident · No injuriesClass 3 · LimitedFinal reportSimmons Gary F Stol CH 701 · Kenwood, CAFailure of the flywheel drive assembly, which resulted in a loss of engine power and subsequent forced landing to uneven terrain.NTSB ERA17LA246Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB CEN17WA276Accident · 2 fatalForeign investigationCessna T210 · Cerro Viejo, MexicoOn July 15, 2017, at 1616 coordinated universal time, a Cessna T210N, Mexican registration XB-LJK, collided with the terrain in Cerro Viejo, Mexico, following a loss of engine power. The pilot and passenger were fatally injured. The airplane was substantially…NTSB WPR17LA153Accident · Minor injuriesClass 3 · LimitedFinal reportClark James T Vans RV8 · Spokane, WAAn inflight engine fire for reasons that could not be determined based on the available information, which melted the air filter element and obstructed the engine's air intakes, resulting in a total loss of engine power.NTSB WPR17FA152Accident · 1 fatalField investigationFinal reportJansen Pazmany PL 2 · El Monte, CAA total loss of engine power due to fuel starvation for reasons that could not be determined based on the available evidence. Also causal was the pilot's decision to return to the runway following the loss of engine power, and his failure to maintain airspeed…