NTSB investigations, 2017, Outside the U.S.
28 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 14 |
| 2010 | 8 |
| 2011 | 12 |
| 2012 | 8 |
| 2013 | 19 |
| 2014 | 16 |
| 2015 | 27 |
| 2016 | 31 |
| 2017 | 28 |
| 2018 | 26 |
| 2019 | 24 |
| 2020 | 20 |
| 2021 | 85 |
| 2022 | 49 |
| 2023 | 62 |
| 2024 | 59 |
| 2025 | 61 |
| 2026 | 24 |
Latest cases
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 year(c.\"eventDate\") = 2017
AND c.\"eventCountry\" <> 'USA'
AND 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 year(c."eventDate") = 2017 AND c."eventCountry" <> 'USA' AND 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 ERA18WA057Accident · 2 fatalForeign investigationCessna 172 · Providenciales, Turks & Caicos IslandsThe government of the United Kingdom has notified the NTSB of an accident involving a Cessna 172S airplane that occurred on December 24, 2017, in Turks and Caicos Islands. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accidents…NTSB ERA18WA069Incident · No injuriesForeign investigationCessna A188 · Montecristi, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…NTSB ERA18WA025Accident · Serious injuriesForeign investigationQuest Kodiac 100 · Goias, BrazilThe government of Brazil has notified the NTSB of an accident involving a QUEST AIRCRAFT COMPANY LLC KODIAC 100 airplane that occurred on November 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's…NTSB CEN18WA028Incident · No injuriesForeign investigationCessna 152 · Namur, BelgiumOn October 31, 2017, at 1305 coordinated universal time, a Cessna 152, Belgium registration OO-TMC, registered to Aero Motion, was involved in an off airport landing following a loss of engine power while preparing to land at the Namur-Suarlee Airport (EBNM),…NTSB WPR18WA025Accident · 1 fatalForeign investigationQuicksilver GT500 · Melaka, MalaysiaOn October 14, 2017, about 1130 local time, a Quicksilver Aircraft GT-500, registration 9M-EAC, was destroyed after colliding with a river shortly after takeoff from Sungai Rambai Aerodrome, Melaka, Malaysia. The airplane was operated under the pertinent…NTSB ERA17WA345Accident · 1 fatalForeign investigationCessna U206F · Caracarai, BrazilOn September 15, 2017, about 1300 coordinated universal time, a Cessna U206F, Brazilian registration PT-JPW, was substantially damaged after ditching in the Rio Branco river, near Caracaraí, Brazil. The pilot was fatally injured. The flight was conducted…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 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 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 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 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 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 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 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 CEN17WA339Accident · No injuriesForeign investigationSchweizer Schweizer 269C · Bonvilliers, FranceOn July 5, 2017, a Schweizer 269C helicopter, French registration F-GHAF, experienced a dynamic rollover near Boinvilliers, France. During a simulated engine failure, the engine lost power. The instructor attempted to restart the engine unsuccessfully three…NTSB ERA17WA238Accident · 4 fatalForeign investigationCessna 210M · Cantá Municipality, State, BrazilOn July 3, 2017, about 1500 universal time coordinated, a Cessna 210M, Brazilian registration PR-MFR, was destroyed when it impacted terrain near Canta Municipality, State of Roraima, Brazil. The pilot and three passengers were fatally injured and one…NTSB CEN17WA245Accident · No injuriesForeign investigationBell 204 · Alpbach, AustriaNTSB ERA17WA207Accident · No injuriesForeign investigationMD Helicopter 369 · Bultfontein, South AfricaOn June 14, 2017, about 1045 coordinated universal time, an MD Helicopter 369E, South African registration ZT-RAC, was substantially damaged during a forced landing near Bulfontein, South Africa. The pilot and two passengers were not injured. The personal…NTSB ENG17IA026Incident · No injuriesIncident investigationFinal reportBoeing 747 451 · Tokyo, JapanThe PW4056 engine lost power due to the fatigue fracture of a 5th stage compressor blade. The cause of the fatigue fracture could not be determined.NTSB DCA17WA136Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…NTSB CEN17WA240Incident · No injuriesForeign investigationReims F150 M · Charleroi, BelgiumOn May 30, 2017, about 1730 hours universal coordinated time, a Reims Aviation F150M, Belgium registration OO-PRG, sustained minor damage during a forced landing at Brussels South - Charleroi Airport (EBCI), Charleroi, Belgium. The flight instructor and…NTSB ERA17WA206Incident · No injuriesForeign investigationCessna 182 · Poesoegroenoe, SurinameOn May 18, 2017, at 1840 coordinated universal time, a Cessna 182P, registered as PZ-VAC, experienced an uncontained engine failure, and sustained minor damage during a subsequent forced landing in Poespegroenoe, Suriname. The pilot and two passengers were…NTSB CEN17WA215Accident · No injuriesForeign investigationAyres S2R · Candillargues, France, FranceOn May 16, 2017, about 0530 hours universal coordinated time, an Ayres S2R airplane, French registration F-GIEN, was substantially damaged during a forced landing following a loss of engine power near Candillargues, France. The pilot was not injured. The…NTSB CEN17WA142Accident · 1 fatalForeign investigationRutan Longez · Cloncoskoran, IrelandOn March 27, 2017, at 1514 coordinated universal time, a Rutan Long-Ez, Irish registration EI-CPI, collided with terrain in Cloncoskoran, Waterford, Ireland, following a loss of engine power. The pilot was fatally injured and the airplane was destroyed. The…NTSB WPR17WA073Accident · No injuriesForeign investigationCessna 152 · Hong Kong, ChinaOn February 26, 2017, about 0314 Coordinated Universal Time, a Cessna 152, B-HHN, collided with trees and came to rest in the trees while attempting a forced landing as a result of a reported loss of engine power. The airplane was operated by Hong Kong…NTSB ANC17RA055Incident · No injuriesForeign investigationCessna 172 · Giseong-ri, South KoreaOn February 10, 2017, about 0952 local time, a Cessna 172 airplane, Republic of Korea registration number HL1171, operated by a flight school, sustained minor damage following a forced landing in a shallow river near Giseong-ri, Republic of Korea. The pilot…NTSB ENG17WA012Incident · No injuriesForeign investigationAirbus A320 · Dehli, IndiaOn February 8, 2017, about 1932 local (1402 UTC), a Go Air (Indian air carrier) A320 equipped with Pratt & Whitney PW1127G engines experienced a loss of power in the No. 1 engine. The airplane had to return to Delhi immediately after takeoff because of a low…