Fatal NTSB investigations, Outside the U.S.
81 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 6 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 6 |
| 2014 | 4 |
| 2015 | 7 |
| 2016 | 9 |
| 2017 | 8 |
| 2018 | 6 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 7 |
| 2025 | 6 |
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 c.\"eventCountry\" <> 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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 c."eventCountry" <> 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 GAA25WA221Accident · 1 fatalClass 5 · ForeignGrumman AA5 · Ottawa, Ontario, CanadaNTSB GAA25WA223Accident · 3 fatalClass 5 · ForeignRobin DR400 · Voglans, FranceNTSB GAA25WA210Accident · 1 fatalClass 5 · ForeignJodel DR1050 · Châteauroux-Villers, FranceNTSB GAA25WA172Accident · 2 fatalClass 5 · ForeignBeech B36 · Korschenbroich, GermanyNTSB GAA25WA157Accident · 1 fatalClass 5 · ForeignCessna 182 · Oriximina, BrazilNTSB GAA25WA058Accident · 3 fatalClass 5 · ForeignCessna 172 · Nairobi, KenyaNTSB ENG24WA023Accident · 1 fatalClass 5 · ForeignCessna 208B · Spa, Belgium, BelgiumNTSB GAA24WA186Accident · 2 fatalClass 5 · ForeignPiper PA46 · Sorriso, BrazilNTSB GAA24WA176Accident · 1 fatalClass 5 · ForeignZenair Unknown · Caceres, SpainNTSB GAA24WA121Accident · 1 fatalClass 5 · ForeignRans S12 · Tabacundo, EcuadorNTSB GAA24WA113Accident · 2 fatalClass 5 · ForeignCessna 208B · Belo Horizonte, BrazilNTSB GAA24WA089Accident · 1 fatalClass 5 · ForeignCessna 208 · Puerto Escondido, MexicoNTSB GAA24WA066Accident · 4 fatalClass 3 · ForeignBellanca 17-30A · Bequia, St. Vincent & GrenadinesNTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionNTSB ENG23WA044Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Raufoss, NorwayNTSB GAA23WA140Accident · 7 fatalClass 3 · ForeignCessna 206 · Chiribiquete National Park, ColombiaNTSB GAA23WA024Accident · 2 fatalClass 5 · ForeignPiper PA32 · Jersey, United KingdomNTSB GAA22WA176Accident · 5 fatalClass 5 · ForeignCessna 207 · Carrefour, HaitiNTSB GAA22WA119Accident · 1 fatalClass 5 · ForeignPiper PA25 · Eldorado, BrazilNTSB GAA22WA067Accident · 2 fatalClass 5 · ForeignPiper PA-32-260 · Chame, PanamaNTSB GAA21WA142Accident · 4 fatalClass 4 · ForeignCessna 310 · RondonóPolis, BrazilNTSB GAA21WA001Accident · 3 fatalClass 3 · ForeignPiper PA28RT · Ubate-Cundinamarca, ColombiaNTSB CEN20WA408Accident · 2 fatalForeign investigationRaven Aircraft Corppration Raven · Moosburg an der Isar, GermanyNTSB GAA20WA121Accident · 1 fatalForeign investigationBeech 58 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB GAA20WA143Accident · 1 fatalClass 5 · ForeignPiper PA28 · Paquera, Province of Puntarenas, Costa RicaNTSB CEN20WA441Accident · 2 fatalClass 5 · ForeignRyan Aeronautical ST3KR · Les Chariots, FranceNTSB GAA19WA274Accident · 1 fatalForeign investigationCessna T210 · Atizapán de Zaragoza, Mexico (jjc airport), MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ERA19WA128Accident · 2 fatalForeign investigationCessna T182 · Jacareacanga County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna T182 airplane that occurred on February 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA19WA127Accident · 1 fatalForeign investigationCessna 210 · Belém City, State of Pará, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on February 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA19WA088Accident · 1 fatalForeign investigationRobinson R44 · Ubatuba, BrazilThe government of Brazil has notified the NTSB of an accident involving a Robinson R44 II that occurred on January 1, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB CEN19WA040Accident · 4 fatalForeign investigationCessna U206 · Culiacan, Sinaloa, MexicoNTSB CEN19WA041Accident · 2 fatalForeign investigationCessna T206H · Tampico, MexicoOn November 12, 2018, about 2016 UTC, a Mexican registered Cessna T206H airplane, XB-ILM, sustained substantial damage during a forced landing to a highway due to a loss of engine power near Tampico, Tamaulipas, Mexico. The pilot and passenger were not…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 CEN18WA214Accident · 1 fatalForeign investigationBell 47 · Ciudad Valles, MexicoOn May 25, 2018, at 0030 hours universal coordinated time, a Scotts Bell 47 helicopter, Mexican registration XB-OSS, impacted terrain following a loss of engine power during an aerial application flight in San Luis Potosi, Mexico. The pilot was fatally…NTSB ERA18WA274Accident · 2 fatalForeign investigationPiper PA28 · Nafpaktos, GreeceThe government of Greece has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on April 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's investigation under the provisions of…NTSB WPR18WA097Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Ogies, South AfricaOn February 28, 2018, at 0945 Universal Coordinated Time (UTC), a South African registered Robinson Helicopter Company R44 Raven II, ZS-HKZ, lost engine power while maneuvering near Truter Boerdery Farm, Ogies, Mpumalana Province, South Africa. The helicopter…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 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 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 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 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 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 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 ERA17WA061Accident · 1 fatalForeign investigationCessna TU206 · Villavicencio, ColombiaOn November 23, 2016, about 2000 coordinated universal time, a Cessna TU206G, Colombian registration HK2659, was substantially damaged during a forced landing near Vanguardia Airport (SKVV), Colombia. The Colombian certificated pilot and two of the passengers…NTSB ANC16WA064Accident · 1 fatalForeign investigationBell 206B · Fox Creek, CanadaOn September 5, 2016, about 1520 mountain daylight time, a Bell 206B helicopter, Canadian registration C-GHHU, impacted terrain during an aerial survey flight subsequent to a power loss about 12 miles southwest of Fox Creek, Alberta, Canada. The helicopter…NTSB ERA16WA298Accident · 2 fatalClass 3 · ForeignCessna 550 · Charallave, VenezuelaNTSB CEN16WA325Accident · 1 fatalForeign investigationPiper PA38 · Peterborough, CanadaOn August 11, 2016, at 0520 coordinated universal time, a Piper PA-38-112, Canadian-registered C-FSYH, was damaged when it struck several metal poles during a forced landing near Peterborough, Ontario, Canada. Visual meteorological conditions prevailed at the…NTSB ERA16WA306Accident · 8 fatalForeign investigationEmbraer EMB820 · Londrina City, BrazilOn July 31, 2016, at 2357 universal coordinated time, an Embraer EMB820C (Piper PA-31-350), Brazilian registration PT-EFQ, was destroyed when it impacted a power line and terrain following a loss of power in the left engine, while on approach to Londrina…NTSB CEN16WA262Accident · 2 fatalForeign investigationLiberty XL · La Lima, HondurasOn June 23, 2016, about 2259 UTC, a Discovery Aviation, Incorporated, Liberty XL-2, Honduran registration HR-HZT, owned and operated by Horizontes Flight School was destroyed when it impacted the roof of a house in a residential neighborhood near La Lima,…