Fatal NTSB investigations, Outside the U.S.
43 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 6 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 7 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 2 |
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\" = '900' 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" = '900' 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 GAA25WA155Accident · 1 fatalClass 5 · ForeignCessna 182 · Allen, ArgentinaNTSB GAA25WA077Accident · 1 fatalClass 5 · ForeignRobinson R44 · Pacific Ocean, EcuadorNTSB GAA25WA044Accident · 2 fatalClass 5 · ForeignBombardier BD100 · San Fernando, ArgentinaNTSB GAA24WA247Accident · 5 fatalClass 5 · ForeignAirbus Helicopters AS350 · NepalNTSB GAA24WA167Accident · 8 fatalClass 5 · ForeignBeech 200 · Zapara Island, VenezuelaNTSB GAA23WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Holstead Hall, Essex, United KingdomNTSB GAA23WA184Accident · 2 fatalClass 4 · ForeignAmerican Champion 8KCAB · Charata, ArgentinaNTSB GAA22WA153Accident · 1 fatalClass 5 · ForeignAgusta AW139 · Iwaizumi, JapanNTSB WPR20WA021Accident · 1 fatalForeign investigationRobinson R44 · Tunis, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on November 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the…NTSB WPR19WA210Accident · 1 fatalForeign investigationLiberty Aerospace XL-2 · Braidwood, AustraliaOn August 6, 2019, at 0138 coordinated universal time, a Liberty Aerospace XL-2, registration VH-XLK, collided with terrain during a landing attempt near Braidwood, New South Wales, Australia. The pilot and sole occupant was fatally injured, and the airplane…NTSB WPR19WA206Accident · 1 fatalForeign investigationBell 47G · Limpopo Province, South AfricaOn July 30, 2019, about 0900 coordinated universal time, a Bell 47G-3B-1 helicopter, ZS-HGY, impacted terrain following a total loss of engine power near Alldays, Limpopo Province, South Africa. The pilot was fatally injured, and the passenger was seriously…NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB CEN19WA288Accident · 2 fatalForeign investigationZenair CH601 · Pont-A-Celles, BelgiumThe government of Belgium has notified the National Transportation Safety Board (NTSB) of an accident involving a Zenair CH 601XL airplane that occurred on June 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB WPR19WA151Accident · 1 fatalClass 5 · ForeignRobinson R44 II · Tai Po, ChinaNTSB CEN19WA096Accident · 2 fatalForeign investigationNorth American T28 · Escuintla, GuatemalaNTSB WPR18WA225Accident · 1 fatalForeign investigationRobinson R22 · Queenstown, South AfricaOn August 15, 2018, at 0830 Universal Coordinated Time, a Robinson R22 Beta helicopter, ZS-HBP, impacted power lines while conducting a game capturing flight near Queenstown, South Africa. The pilot sustained serious injuries and the passenger was fatally…NTSB WPR18WA235Accident · 1 fatalForeign investigationAyres S2R · Diatar, MauritaniaOn August 8, 2018, at an unknown time, an Ayres S2R T34 airplane, F-GOKZ, impacted terrain during an agricultural operation near Diatar, Mauritania. The pilot was fatally injured. The airplane was being operated under the pertinent civil regulations of the…NTSB WPR18WA138Accident · 2 fatalForeign investigationTaylorcraft BC12 · Vryheid, South AfricaOn April 29, 2018, at 1110 coordinated universal time, a Taylorcraft BC 12-D airplane, registration ZS-BLD, sustained substantial damage under unknown circumstances following a departure from Vryheid Aerodrome (FAVY), Kwa-Zulu Natal, South Africa. Both…NTSB ERA18WA066Accident · 2 fatalForeign investigationRobinson R44 · Recife, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on January 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA17WA342Accident · 1 fatalForeign investigationRobinson R44 · Cape Town, South AfricaOn September 28, 2017, about 1000 coordinated universal time, a Robinson R44 II helicopter, South African registration ZS-OSL, was destroyed when it impacted terrain during an emergency autorotation near Cape Town, South Africa. The pilot was fatally injured.…NTSB ERA17WA323Accident · 1 fatalForeign investigationBritten Norman BN2A · San Salvador de Paul, VenezuelaOn September 11, 2017 about 1400 coordinated universal time, a Britten Norman BN2-A, Venezuelan registration YV1441, was landing at San Salvador de Paul, Ciudad Bolivar, Venezuela, when it struck and fatally injured a child who was on the runway. The pilot…NTSB ERA17WA259Accident · 2 fatalForeign investigationCirrus Design SR20 · Santo Antonio do Leverger, BrazilOn July 20, 2017, at 1109 coordinated universal time, a Cirrus SR-20, Brazilian registration PR-PRF, was substantially damaged when it collided with terrain shortly after takeoff from Santa Edwiges farm, near the municipality of Santo Antônio do Leveger, Mato…NTSB WPR16WA192Accident · 3 fatalForeign investigationCessna 182 · Mpumalanga Province, South AfricaOn August 27, 2016, about 1025 coordinated universal time, a Cessna 182Q, South African registration ZS-PHB, was destroyed when it impacted terrain shortly after takeoff from Komati Gorge Lodge private airstrip, Mpumalanga Province, South Africa. The pilot…NTSB WPR16WA143Accident · 1 fatalForeign investigationCessna 150 · New Crown Station, AustraliaOn July 12, 2016 about 1130 local time, a Cessna 150G airplane, Australian registration VH-RXU, collided with terrain near New Crown Station, South Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was…NTSB CEN16WA140Accident · 2 fatalForeign investigationCessna Skyhawk II 172N · Vulcan de Fuego, Guatemala, GuatemalaOn March 27, 2016, about 2242 universal coordinated time (UTC), a Guatemalan-registered Cessna 172N, TG-KAM, impacted terrain near the Vulcan de Fuego while en route from Tiquisate, Escuintla, to the La Aurora International Airport (MGGT), Guatemala City,…NTSB CEN16WA072Accident · 1 fatalForeign investigationMooney M20K · Mascouche, CanadaOn December 28, 2015, about 2227 universal coordinated time, a Canadian registered Mooney M20K, C-GUXC, impacted terrain while attempting to land at Mascouche (CSK3), Quebec, Canada. The pilot was fatally injured and the passenger was seriously injured. The…NTSB DCA16WA031Accident · 1 fatalForeign investigationEclipse 500 · Swellendam, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Eclipse Aviation 500 airplane that occurred on December 07, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation…NTSB WPR15WA188Accident · 1 fatalForeign investigationRobinson R44 - Undesignat · Timber Creek, Australia, AustraliaOn June 14, 2015, at 1100 local time, a Robinson R44, VH-KJJ, collided with terrain under unknown circumstances near Timber Creek, Australia. The helicopter was operated under the pertinent civil regulation of the government of Australia. The helicopter was…NTSB CEN15WA178Accident · 3 fatalForeign investigationPiper PA32RT - 300T · Sudbury, CanadaNTSB ERA15WA082Accident · 7 fatalForeign investigationCessna T207 - A · Piedecuesta, ColombiaOn December 24, 2014, about 1950 UTC, a Cessna T207A, HK4892, collided with mountainous terrain near Vereda Cabreras, Punto el Guanabanazo, Pescadero Piedecuesta, Santander, Colombia. The commercial pilot and six passengers were fatally injured. The airplane…NTSB ERA14WA241Accident · 2 fatalForeign investigationCessna T210N · Para, BrazilOn April 30, 2014, about 2215 UTC, a Cessna T210N, Brazilian Registration PR-WCO, registered to and operated by Mineradora Bom Jesus Ltda, collided with trees during a go-around from landing at an airstrip located in Para, Brazil. Visual meteorological…NTSB WPR14WA085Accident · 1 fatalForeign investigationBell 206 · Berastagi, IndonesiaOn December 30, 2013, at about 1030 local time, a Bell 206 helicopter, registration PK-DAL, crashed shortly after takeoff from a hospital near Berastagi, North Sumatera, Indonesia. Reports indicate that there was one fatality and two serious injuries…NTSB CEN13WA492Accident · 1 fatalForeign investigationAerostar International S-55A · Mont-St-Grégoire, CanadaOn August 11, 2013, at 0730 eastern daylight time, an Aerostar International Inc. model S-55A, United States registration N25QL, serial number S55A1-1017, was not damaged when a member of the balloon ground-support team was fatally injured after falling to…NTSB ERA13WA306Accident · 1 fatalForeign investigationPiper PA34 · Envira, BrazilOn June 7, 2013, at 1400 coordinated universal time (UTC), a Piper PA-34-200T, Brazilian registration PT-MMX, was substantially damaged during a ditching into the Tarauacá River following an unspecified malfunction of the airplane’s right engine after…NTSB ERA13WA226Accident · 2 fatalForeign investigationCessna 210L · Belem, BrazilOn April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…NTSB DCA13WA089Accident · 1 fatalForeign investigationBeech 1900 · Unkown, São Tomé & PríncipeThe Sao Tome and Principe Civil Aviation Authority (STPCAA) has notified the NTSB of an accident involving a Beech 1900 that occurred on April 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist STPCAA investigation under the…NTSB ERA13WA282Accident · 2 fatalForeign investigationRobinson R66 · Caraguatatuba, BrazilOn January 3, 2013, about 1600 coordinated universal time (UTC), a Robinson R-66 Helicopter, Brazilian registration PR-DUB, was destroyed when it impacted a dense forest and the side of a hill in the Caraguatatuba Municipality, in the State of São Paulo,…NTSB ERA12WA534Accident · 1 fatalForeign investigationGulfstream G-164B · Calabozo, VenezuelaOn August 24, 2012, about 2000 universal coordinated time, a Gulfstream G-164B, Venezuelan registration YV264A, registered to Fumiwan C.A, was substantially damaged when it impacted terrain during an aerial application. The pilot was fatally injured. The…NTSB DCA12WA089Accident · 14 fatalForeign investigationSikorsky S58 · Cusco, PeruThe Comisión de Investigación de Accidentes de Aviación of Peru (CIAA) has notified the NTSB of an accident involving a Sikorsky S58 helicopter that occurred on June 06, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB ERA12WA354Accident · 2 fatalForeign investigationCessna T210M · Manabi Province, EcuadorOn May 13, 2012, about 2030 local time (May 14, 2012, about 0030 coordinated universal time), a Cessna T210M, Mexican registration XB-MPL, was substantially damaged when it impacted terrain in Manabí Province, Ecuador. The pilot and passenger, both of unknown…NTSB CEN12WA105Accident · 2 fatalForeign investigationCessna 177A · Ottawa, CanadaOn December 14, 2011, at 1920 eastern standard time, a Cessna model 177A, Canadian registration C-FEFQ, collided with terrain 2 nautical miles west of Ottawa Macdonald-Cartier International Airport (CYOW), Ottawa, Canada. The flight had been cleared for the…NTSB ERA11RA398Accident · 2 fatalForeign investigationRobinson R66 · Girardot, ColombiaOn July 12, 2011, about 2041 UTC, or 1541 local, a Robinson Helicopter Company R66, N810AG, registered to Aircraft Guaranty Corporation Trustee, operated by a private individual, collided with terrain near Girardot, Colombia. Visual meteorological conditions…NTSB ERA10WA510Accident · 1 fatalForeign investigationRobinson R44 · Davinopolis, BrazilOn September 30, 2010, about 0844 local/1144 UTC, a Robinson R44 II, Brazilian registration PR-CCO, registered to and operated by a private individual, was landed in rugged terrain near Davinopolis, State of Maranhao, Brazil. Weather conditions and flight…