Fatal NTSB investigations, 2017, Outside the U.S.

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
Fatal NTSB investigations, 2017, Outside the U.S. per year, 1962–2026: 3,270 cases
19621
196420
196518
196615
196716
196816
196914
197014
197111
197217
197316
197411
197511
19761
19776
197811
19792
19811
19821
19831
19843
19853
19862
19879
198811
19898
19908
19919
199211
199311
199410
199524
199637
199737
199843
199953
200077
200166
200259
200371
200475
200597
200689
200787
200890
200990
201098
2011120
2012119
2013124
2014107
2015130
2016131
2017133
2018137
2019140
202091
2021107
2022125
202398
2024110
2025109
2026108

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.\"highestInjuryLevel\" = 'Fatal'
  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.

NTSB WPR18WA060Accident · 6 fatalForeign investigationDe Havilland DHC2 · Cottage Point, AustraliaOn December 31, 2017, at 1515 local time, a De Havilland DHC-2, VH-NOO, collided with water during takeoff initial climb near Cottage Point, Australia. The airplane was destroyed and the pilot and five passengers were fatally injured. The flight was operated…Dec 31, 2017 · VH-NOO · DestroyedNTSB CEN18FA063Accident · 12 fatalField investigationFinal reportCessna 208 · Punta Islita, Costa RicaThe flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…Dec 31, 2017 · TI-BEI · DestroyedNTSB ERA18WA061Accident · 1 fatalForeign investigationCessna A188 · Dom Pedrito, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Dec 30, 2017 · PR-MLY · Substantial damageNTSB CEN18WA067Accident · 1 fatalForeign investigationConstrucciones Aeronauticas C.A.S.A. 1.131 · Alicante, SpainOn December 30, 2017, at 1642 universal time coordinated, a Construcciones Aeronauticas SA C.A.S.A. 1.131 (Bucker BU-131), N1950M (NX-1950M), and a Bell 412SP, EC-MMC, experienced a mid-air collision during final approach for landing to runway 20 at Muchamiel…Dec 30, 2017 · N1950M · 2 aircraft · Substantial damageNTSB 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…Dec 24, 2017 · PR-RTS · DestroyedNTSB ERA18WA051Accident · 1 fatalForeign investigationBeech A36 · Itapua, ParaguayDec 17, 2017 · ZP-BHU · DestroyedNTSB ANC18WA015Accident · 1 fatalForeign investigationPiper PA23 · Baldur, CanadaOn December 16, 2017, about 0037 Coordinated Universal Time, a Piper PA-23 airplane, CFIPK, impacted terrain near Baldur, Manitoba, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries.The Transportation Safety Board (TSB) of…Dec 16, 2017 · CFIPK · Substantial damageNTSB WPR18WA078Accident · 3 fatalForeign investigationBeech 58 · Qaroun Lake, EgyptOn December 15, 2017, about 0930 Coordinated Universal time, a Textron/Beech Model 58 Baron twin engine airplane, SU-BLD, was substantially damaged when it impacted desert terrain about 18 kilometers north of Qaroun Lake, Egypt. The training pilot and the two…Dec 15, 2017 · SU-BLD · Substantial damageNTSB ERA18WA047Accident · 1 fatalClass 5 · ForeignCessna T210 · West End, BahamasDec 14, 2017 · N727TJ · Substantial damageNTSB CEN18WA055Accident · 3 fatalForeign investigationCessna 510 · Waldburg, GermanyOn December 14, 2017, about 1620 coordinated universal time, a Cessna 510 airplane, OE-FWD, impacted terrain near Waldburg, Germany. The pilots and passenger were all fatally injured and the airplane was destroyed.The accident investigation is under the…Dec 14, 2017 · OE-FWD · DestroyedNTSB ERA18WA060Accident · 1 fatalForeign investigationAir Tractor AT502 · Rivadavia, ArgentinaThe government of Argentina has notified the NTSB of an accident involving an Air Tractor AT-502B airplane that occurred on December 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under…Dec 13, 2017 · LV-ZZX · Substantial damageNTSB ERA18WA042Accident · 2 fatalForeign investigationRobinson R44 · Dubovaya Balka, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…Dec 5, 2017 · RA-04308 · Substantial damageNTSB ERA18RA045Accident · 2 fatalForeign investigationPiper PA28 · Vereda El Mortillo, ColombiaimportNov 30, 2017 · HK1573G · DestroyedNTSB CEN18WA046Accident · 2 fatalForeign investigationMD Helicopter 369HS · La Morita, MexicoOn November 22, 2017, about 1437 pacific standard time, a MD Helicopters 369HS single-engine helicopter, serial number 920414S, Mexican registration XC-TIJ, crashed while providing aerial support for police activity near La Morita, Mexico. The pilot and his…Nov 22, 2017 · XC-TIJ · DestroyedNTSB ERA18WA028Accident · 11 fatalForeign investigationCessna 208 · Ngorongoro, TanzaniaOn November 15, 2017, about 0805 coordinated universal time, Cessna 208B, Tanzanian registration 5H-EGG, operated by Coastal Aviation LTD., was substantially damaged when it impacted terrain near Ngorongoro, Tanzania. The pilot and 10 passengers were fatally…Nov 15, 2017 · 5H-EGG · Substantial damageNTSB ERA18WA160Accident · 1 fatalForeign investigationPiper PA-25-235 · Itapolis, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER AIRCRAFT PA-25-235 airplane that occurred on November 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…Nov 14, 2017 · PR-AAV · DestroyedNTSB WPR18WA019Accident · 2 fatalForeign investigationCessna T310 · Kew, New South Wales, AustraliaOn October 28, 2017, at 1600 local time, a Cessna T310R, VH-JMW, was destroyed when it collided with terrain near Kew, New South Wales, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The pilot and…Oct 28, 2017 · VH-JMW · DestroyedNTSB ANC18WA076Accident · 2 fatalForeign investigationPiper PA34 · Calgary Springbank, CanadaOn October 26, 2017, about 0952 mountain daylight time, a Piper PA-34-200T airplane, C-GCCM, departed controlled flight and impacted terrain shortly after takeoff from Calgary Springbank Airport (CYBW), Alberta, Canada. The flight instructor and pilot…Oct 26, 2017 · C-GCCM · Substantial damageNTSB WPR18WA017Accident · 1 fatalForeign investigationCessna 210 · Albany, AustraliaOn October 24, 2017, at 1115 local time, a Cessna 210B, VH-DBU, was destroyed when it impacted the ground following a collision with terrain near Albany, Western Australia. The airplane was operated under the pertinent regulations of the Australian…Oct 24, 2017 · VH-DBU · DestroyedNTSB ERA18WA029Accident · 1 fatalForeign investigationCessna A188 · Sao Felix do Xingu, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on October 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Oct 24, 2017 · PR-RBA · DestroyedNTSB WPR18WA024Accident · 2 fatalForeign investigationCessna 210L · Darwin Aerodrome, AustraliaOn October 23, 2017, at 1332 local time, a Cessna 210L, VH-HWY, collided with terrain near Darwin Aerodrome, Australia. The airplane was operated under the pertinent civil regulations of the government of Australia. The two occupants were fatally injured. The…Oct 23, 2017 · VH-HWY · DestroyedNTSB ERA18WA017Accident · 5 fatalForeign investigationCessna 210 · Itaituba, BrazilOn October 22, 2017, about 2105 universal coordinated time, a Cessna 210N, Brazilian registration PT-ORU, operated by a private individual, was destroyed when it collided with terrain following a low altitude maneuver near Itaituba, Brazil. The two foreign…Oct 22, 2017 · PT-ORU · DestroyedNTSB ERA18WA013Accident · 1 fatalForeign investigationCessna 208 · Novo Airao, BrazilOn October 17, 2017, about 1540 universal coordinated time, an amphibious Cessna 208, Brazilian registration PR-MPE, was substantially damaged after it came to rest inverted while attempting to land on a river in Novo Airao county, State of Amazonas, Brazil.…Oct 17, 2017 · PR-MPE · Substantial damageNTSB CEN18WA016Accident · 1 fatalForeign investigationAvid Mark IV · Jüterborg, GermanyOn October 16, 2017, about 1123 UTC, an amateur-built Avid Mark IV airplane, French registration F-JAGB, owned and operated by a private individual, crashed during a test flight near Jüterborg, Germany. The pilot on board was fatally injured and the airplane…Oct 16, 2017 · F-JAGBNTSB 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…Oct 14, 2017 · 9M-EAC · DestroyedNTSB ERA18WA015Accident · 1 fatalForeign investigationCessna U206 · Itaituba, BrazilOn October 11, 2017, about 1600 universal coordinated time, a Cessna U206G, Brazilian registration PT-LSC, was destroyed when it collided with a tree during takeoff near Itaituba, State of Para, Brazil. The pilot was fatally injured, and one passenger…Oct 11, 2017 · PT-LSC · DestroyedNTSB ERA18WA014Accident · 3 fatalForeign investigationBeech E33A · São José do Rio Preto, BrazilOn September 10, 2017, about 1525 coordinated universal time, a Beechcraft E33-A, Brazilian registration PT-DDB, struck a residence while conducting a go around near São José do Rio Preto State Airport (SBSR), Brazil. The airplane was substantially damaged,…Oct 9, 2017 · PT-DDB · Substantial damageNTSB CEN18WA007Accident · 1 fatalForeign investigationRobinson R44 · Gramzda, LatviaOn October 8, 2017, about 1014 Coordinated Universal Time (UTC), a Robinson R44 helicopter, YL-HBH, impacted a powerline after takeoff near Gramzda, Latvia. One passenger was fatally injured and the pilot and two other passengers on board were seriously…Oct 8, 2017 · YL-HBHNTSB ERA18WA009Accident · 1 fatalForeign investigationZlin Z50 · Gauteng Province, South AfricaOn October 6, 2017, about 1530 coordinated universal time, a Zlin Z-50L, South African registration ZS-VAR, was destroyed when it impacted terrain shortly after takeoff from Kitty Hawk Airport (FAKT), Gauteng Province, South Africa. The pilot was fatally…Oct 6, 2017 · ZS-VAR · DestroyedNTSB CEN18WA005Accident · 1 fatalForeign investigationPiper PA25 · Cerro de Ortega, MexicoOct 5, 2017 · XB-DLL · Substantial damageNTSB ANC18RA001Accident · 1 fatalForeign investigationRobinson R44 · Campbell River, CanadaOct 1, 2017 · C-FMBO · Substantial damageNTSB 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.…Sep 28, 2017 · ZS-OSL · DestroyedNTSB ERA17WA344Accident · 2 fatalForeign investigationCessna 150 · BahamasOn September 26, 2017, a Cessna 150G, N3214X, went missing and was presumed to be substantially damaged. The private pilot and passenger were also missing, and presumed to be fatally injured. As of October 30, 2017, the airplane had not been found. A visual…Sep 26, 2017 · N3214X · Substantial damageNTSB CEN17WA369Accident · 1 fatalForeign investigationMD Helicopter 369 · Norrbotten, Sweden, SwedenOn September 26, 2017, about 1154 hours universal coordinated time, an MD Helicopters 369D, Swedish registration SE-JVI, impacted terrain about one-third mile from the Alvsbyn Airport (ESUV), Norrbotten, Sweden. One pilot was fatally injured and the second…Sep 26, 2017 · SE-JVI · DestroyedNTSB CEN17WA370Accident · 2 fatalForeign investigationCessna 150J · Goderich, CanadaOn September 20, 2017, about 2036 eastern daylight time, a Cessna 150J single-engine airplane, Canadian registration C-FHPU, serial number 15070602, crashed in Lake Huron about 1.1 nautical miles west of Goderich Municipal Airport (CYGD), Goderich, Ontario,…Sep 21, 2017 · C-FHPU · Substantial damageNTSB CEN17WA360Accident · 2 fatalForeign investigationVans RV4 · Stafsberg, NorwayOn September 19, 2017, at 1450 UTC, a Vans Aircraft RV-4, experimental, amateur-built airplane, Norwegian registration LN-ABF, impacted terrain near the Hamar Airport (ENHA), Stafsberg, Norway. The pilot and passenger on board were fatally injured and the…Sep 19, 2017 · LN-ABF · DestroyedNTSB CEN17WA383Accident · 1 fatalForeign investigationBell 47G · Llano Bonito de Pococí, Costa RicaOn September 18, 2017, at 0720 central daylight time, a Bell 47G2 helicopter, Costa Rican registration TI-BGH, serial number 1459, impacted terrain during an aerial application flight, near Llano Bonito de Pococí, Costa Rica. The pilot was fatally injured,…Sep 18, 2017 · TI-BGH · Substantial damageNTSB 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…Sep 15, 2017 · PT-JPW · Substantial damageNTSB CEN17WA353Accident · 2 fatalForeign investigationMooney M 20K · Braunwald, SwitzerlandSep 12, 2017 · D-EPPW · DestroyedNTSB 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…Sep 11, 2017 · YV-1441 · No damageNTSB CEN17WA343Accident · 2 fatalForeign investigationPiper Piper PA-28RT-201 · Wolferton, United KingdomOn September 11, 2017, at 0956 universal coordinated time (UTC), a Piper PA-28RT-201 single-engine airplane, United Kingdom registration G-BHAY, serial number 28R-7918213, was substantially damaged during a forced landing following a loss of engine power and…Sep 11, 2017 · G-BHAY · Substantial damageNTSB ERA17WA321Accident · 1 fatalForeign investigationPiper Piper PA-34-200T · Cerrione, ItalySep 9, 2017 · G-STZA · DestroyedNTSB CEN17RA337Accident · 2 fatalForeign investigationCessna U206 · San Jose, Costa RicaimportSep 5, 2017 · TI-AGM · DestroyedNTSB ERA17WA320Accident · 2 fatalForeign investigationCessna 182 · Pontinia, ItalyOn September 3, 2017 about 1030 universal coordinated time, a Cessna 182P, I-SCAP, impacted terrain during initial climb after takeoff, from Pegaso Club 2000 Airfield, Pontinia, Italy. The airplane was destroyed by impact forces and a post crash fire. Five…Sep 3, 2017 · I-SCAP · Substantial damageNTSB ERA17WA318Accident · 2 fatalForeign investigationCessna 172 · Hekpoort, South AfricaOn September 3, 2017, about 0930 coordinated universal time, a Cessna 172M, South African registration ZS-JDN, was destroyed when it impacted a valley in the Magaliesberg Mountain range, near Hekpoort, South Africa. The two commercial pilots were fatally…Sep 3, 2017 · ZS-JDN · DestroyedNTSB CEN17WA378Accident · 1 fatalForeign investigationPiper PA25 · Sueco, Chihuahua, Mexico, MexicoOn September 2, 2017, about 1700 hours universal coordinated time, a Piper PA25-235, Mexican registration XB-EXZ, was substantially damaged when it impacted powerlines near Sueco, Chihuahua, Mexico. The pilot was seriously injured. The local flight departed…Sep 2, 2017 · XB-EXZ · Substantial damageNTSB 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…Aug 27, 2017 · YV2594 · Substantial damageNTSB ERA17WA308Accident · 1 fatalForeign investigationMaule M7 · Zhideli, KazakhstanOn August 25, 2017, about 0450 coordinated universal time, a Maule M7-260C airplane, Kazakhstan registration UP-ML003, impacted terrain during a forced landing near Zhideli, Kazakhstan. The pilot was fatally injured and the passenger sustained serious…Aug 25, 2017 · UP-ML003 · Substantial damageNTSB CEN17WA325Accident · 2 fatalForeign investigationAviat Pitts S-2B · Holmestrand, NorwayOn August 22, 2017, at 1025 hours universal coordinated time, an Aviat Pitts S-2B, Norwegian registration LN-PTS, impacted the terrain following a loss of control while performing aerobatic maneuvers near Holmestrand, Norway. The pilot and passenger were…Aug 22, 2017 · LN-PTS · DestroyedNTSB ERA17WA283Accident · 1 fatalForeign investigationRobinson R66 · Maly Utrish, RussiaOn July 21, 2017, about 1832 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-05750, was substantially damaged when it impacted mountainous terrain near Maly Utrish township, while on a night flight from Anapa, Russia, to…Aug 21, 2017 · RA-05750 · Substantial damage