Fatal NTSB investigations, 2012, Outside the U.S.
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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
| 1962 | 1 |
|---|---|
| 1964 | 20 |
| 1965 | 18 |
| 1966 | 15 |
| 1967 | 16 |
| 1968 | 16 |
| 1969 | 14 |
| 1970 | 14 |
| 1971 | 11 |
| 1972 | 17 |
| 1973 | 16 |
| 1974 | 11 |
| 1975 | 11 |
| 1976 | 1 |
| 1977 | 6 |
| 1978 | 11 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 9 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 9 |
| 1992 | 11 |
| 1993 | 11 |
| 1994 | 10 |
| 1995 | 24 |
| 1996 | 37 |
| 1997 | 37 |
| 1998 | 43 |
| 1999 | 53 |
| 2000 | 77 |
| 2001 | 66 |
| 2002 | 59 |
| 2003 | 71 |
| 2004 | 75 |
| 2005 | 97 |
| 2006 | 89 |
| 2007 | 87 |
| 2008 | 90 |
| 2009 | 90 |
| 2010 | 98 |
| 2011 | 120 |
| 2012 | 119 |
| 2013 | 124 |
| 2014 | 107 |
| 2015 | 130 |
| 2016 | 131 |
| 2017 | 133 |
| 2018 | 137 |
| 2019 | 140 |
| 2020 | 91 |
| 2021 | 107 |
| 2022 | 125 |
| 2023 | 98 |
| 2024 | 110 |
| 2025 | 109 |
| 2026 | 107 |
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\") = 2012
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.
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") = 2012 AND c."eventCountry" <> 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 CEN13WA123Accident · 2 fatalForeign investigationPiper PA-28-235 · Guatemala City, GuatemalaNTSB ERA13WA103Accident · 2 fatalForeign investigationPiper PA28 · Minas City, BrazilOn December 26, 2012, at 2050 universal coordinated time, a Piper PA-28-181, Brazilian registration PR-NAX, was destroyed when it impacted the ground after the crew lost control during a go around. The instructor pilot and student were fatally injured. The…NTSB DCA13WA034Accident · 1 fatalForeign investigationSwearingen SA227 · Sanikiluaq, CanadaOn 22 December, 2012, at approximately 2313 UTC time, a Swearingen SA227-AC Metroliner, registration C-GFWX, was operated by Perimeter Aviation as chartered flight number PAG993, from Winnipeg, Manitoba (CYWG) to Sanikiluaq, Nunavut (CYSK). During the second…NTSB ERA13WA089Accident · 4 fatalForeign investigationPiper PA34 · Zulia, ColombiaOn December 12, 2012, about 1530 universal coordinated time (1030 local time), a Piper PA-34-200T, Colombian registration HK4477G, was destroyed when it impacted rising mountainous terrain in the vicinity of La Cuchilla, near Zulia, Norte de Santander,…NTSB DCA13RA025Accident · 7 fatalForeign investigationLearjet 25 · Monterrey, MexicoNTSB CEN13WA092Accident · 8 fatalForeign investigationPiper PA-32-301 · Melbach, GermanyOn December 8, 2012, about 1513 coordinated universal time, a Piper PA-32, German registration, D-EUEU, and a Robin Regent DR400, German registration D-EHJP, collided while on cross country flights near Melbach, Germany. Visual meteorological conditions…NTSB ANC13WA013Accident · 1 fatalForeign investigationRobinson R44 · Slave Lake, Alberta, CanadaOn December 5, 2012, about 1200 mountain standard time, a Robinson R-44 Raven II helicopter, Canadian registration C-FRSO, impacted terrain approximately 12 miles southwest of Slave Lake, Alberta, Canada. The pilot, the sole occupant, was fatally injured. The…NTSB ERA13WA080Accident · 1 fatalForeign investigationPiper PA-25-260 · El Viento, ColombiaOn November 22, 2012, at 1705 Universal Coordinated Time (UTC), a Piper PA-25-260, Colombian registration HK588,operated by Fuminorte Ltda. Fumigaciones Aereas Norte, was substantially damaged when it collided with terrain during an agriculture spraying…NTSB ERA13WA066Accident · 1 fatalForeign investigationAerospatiale AS-355F1 · Great Guana Cay, BahamasOn November 22, 2012, about 1310 eastern standard time, an Aerospatiale AS 355F1, Bahamian registration C6-APV, registered to Pioneer Caribbean Logistics Ltd., impacted terrain while attempting to land at Baker's Bay Resort, Great Guana Cay, Bahamas. The…NTSB ERA13WA078Accident · 1 fatalForeign investigationCessna R172K · Cuchilla La Laja, ColombiaOn November 19, 2012, about 1030 hours local, a Cessna R172K, Colombian registration HK4890G, collided with mountainous terrain near Cuchilla La Laja – Municipio de San Francisco, Departmento de Cundinamarca, Colombia. Instrument meteorological conditions…NTSB ANC13WA010Accident · 1 fatalForeign investigationCessna 208 · Snow Lake, CanadaOn November 18, 2012, about 1000 central standard time, a Cessna 208B airplane, (Canadian Registration C-GAGP) was on a VFR flight plan from Snow Lake (CJE4) to Winnipeg (CYWG), Manitoba, Canada. The airplane crashed in a wooded area near the Snow Lake…NTSB ANC13WA011Accident · 1 fatalForeign investigationPiper PA46 · La Crete, CanadaOn November 17, 2012, about 1650 mountain standard time, a Piper PA-46-500TP airplane, (Canadian Registration C-GWEI) was on a VFR flight plan from High Level, Alberta to LaCrete, Alberta, Canada. The airplane crashed during an instrument approach to the La…NTSB ERA13WA431Accident · 3 fatalForeign investigationBeech 95B55 - B · Concepcion, ParaguayOn November 16, 2012, about 0813 local time (1113 coordinated universal time), a Beech BE-55, Paraguayan registration ZP-BLV, was destroyed when it impacted terrain about 500 meters short of the runway at a ranch in Departamento Presidente Hayes, about 50…NTSB CEN13WA065Accident · 1 fatalForeign investigationCessna 172 · Ostermaima, SwedenOn November 16, 2012, about 1600 UTC, a Cessna 172N, Swedish registration SE-KHX, owned by a private individual, was destroyed when it impacted in a forest near a public road at Ostermaima, Gnesta, Stockholm, Sweden, under unknown circumstances. A post impact…NTSB CEN13WA061Accident · 2 fatalForeign investigationReims-Cessna F150 · Birr, Ireland, IrelandOn November 11, 2012, about 1655 Western European time, a Reims-Cessna, model F150H, single engine airplane, EI-AST, was destroyed when it impacted terrain near Birr Airfield (EIBR), Birr, Ireland. The two pilots were fatally injured. The airplane was…NTSB ERA13WA074Accident · 4 fatalForeign investigationPiper PA-31T · Curitiba, BrazilOn November 6, 2012, at 2030 Coordinated Universal Time (UTC), a Piper PA-31T, Brazilian registration PT-MFW, was destroyed when it impacted terrain while approaching Bacacheri Airport (SBBI), Curitiba, Brazil. The flight was operated by Taxi Aereo Hercules,…NTSB ERA13WA068Accident · 4 fatalForeign investigationEmbraer 810D · Chapada dos Guimaraes, BrazilOn November 1, 2012, at 1950 Universal Coordinated Time (UTC), an Embraer Aircraft model EMB-810D (Piper Design PA-34-220T), Brazilian registration PT-VRV, operated by a private owner, was substantially damaged following an encounter with weather and a…NTSB WPR13WA030Accident · 1 fatalForeign investigationCessna 172 · Ballarat, Australia, AustraliaOn October 29, 2012, at 1300 universal coordinated time, a Cessna 172N, VH-TKI, operated by a private individual under the pertinent civil regulations of the government of Australia, collided with a wire while on approach for landing near Ballarat Aerodrome,…NTSB CEN13WA036Accident · 1 fatalForeign investigationBell 206B · Nueva Concepción, GuatemalaOn October 27, 2012, a Bell 206B helicopter, TG-PMR, impacted terrain near Nueva Concepcion, Guatemala. The pilot, the sole occupant, was fatally injured. The accident investigation is under the jurisdiction and control of the government of Guatemala. This…NTSB CEN13WA020Accident · 2 fatalForeign investigationMooney M20E · Speichersdorf, GermanyOn October 21, 2012, about 1520 coordinated universal time, a Mooney M20E, D-EMHE was destroyed following a loss of control during initial climb from Rosenthal Field Ploessen Airport (EDQP), near Speichersdorf, Germany. The pilot and passenger were fatally…NTSB CEN13WA014Accident · 3 fatalForeign investigationLake 250 · Pickle Lake, Ontario, CanadaOn October 16, 2012, about 1930 central daylight time, a Lake model 250, Canadian registration C-GZLC, impacted terrain during approach near Pickle Lake, Ontario, Canada. The pilot and two passengers were fatally injured. A third passenger was seriously…NTSB ERA13WA031Accident · 1 fatalForeign investigationRobinson R-44 · Moscow, RussiaNoneNTSB ERA13WA156Accident · 1 fatalForeign investigationCessna 172S · Izmir, TürkiyeOn October 6, 2012, at 0915 Coordinated Universal Time (UTC), a Cessna 172S, Turkish registration TC-CBI, operated by the Turkish Aeronautical Association, impacted mountainous terrain during an instructional flight, near Izmir, Turkey. The flight instructor…NTSB WPR13WA014Accident · 1 fatalForeign investigationRobinson R22 · Halls Creek, Australia, AustraliaOn October 3, 2012, at about 1100 universal coordinated time, a Robinson Helicopter Company, R-22 Beta, VH-LLF, sustained substantial damage when it collided with the side of a canyon near the Halls Creek Aerodrome, Australia. The pilot was fatally injured.…NTSB ERA13WA030Accident · 1 fatalForeign investigationPiper PA25 · Juquiá Municipality, BrazilOn October 03, 2012, at 1100 universal coordinated time, a Piper PA-25-260, Brazilian registration PT-DOX, was destroyed when it impacted the ground and was consumed by fire after colliding with high-tension electric wires. The pilot was fatally injured. The…NTSB CEN12WA664Accident · 6 fatalForeign investigationCessna 414A · Innsbruck, AustriaNTSB DCA12RA153Accident · 19 fatalForeign investigationKathmandu, NepalOn September 28, 2012, a Sita Air Dornier 228, registration 9N-AHA, with Garrett (Honeywell) TPE 331 engines, reported a bird strike shortly and crash shortly after takeoff from Kathmandu-Tribhuvan Airport (KTM), Kathmandu, Nepal. The three crew members and…NTSB ERA12WA590Accident · 1 fatalForeign investigationPiper PA34 · Ilheus, BrazilOn September 25, 2012, about 0155 universal coordinated time, a Piper PA-34-200T, Brazilian registration PT-RDG, was substantially damaged when it impacted the Atlantic Ocean, shortly after takeoff from the Ilheus Jorge Amado Airport (SBIL), Ilheus, Bahia,…NTSB ERA12WA591Accident · 1 fatalForeign investigationCessna 210 · Roraima, BrazilOn September 24, 2012, about 0400 hours local, or 0800 UTC, a Cessna 210L, Brazilian registration PT-KSB, departed controlled flight and crashed shortly after takeoff from Pouso Da Aguilia Airport (SWPD), Roraima, Brazil. Visual meteorological conditions…NTSB ERA13WA205Accident · 4 fatalForeign investigationCessna 172N · Acreúna Municipality, BrazilNTSB ERA12WA577Accident · 1 fatalForeign investigationCessna 172R · Macapá, BrazilOn September 12, 2012, about 2112 universal coordinated time, a Cessna 172R, Brazilian registration PT-WYK, was destroyed when it collided with terrain under unknown circumstances near Macapa ´, Brazil. The non-certificated pilot was fatally injured. The…NTSB ERA12WA556Accident · 2 fatalForeign investigationCessna 402 · Rome, ItalyOn September 7, 2012, about 1100 Universal Time Coordinate (UTC), a Cessna 402B, Italian registration I-EJRA, operated by Rilievi Aerofotogrammetrici, impacted the ground near Rome, Italy. Visual meteorological conditions prevailed and flight plan information…NTSB CEN12WA677Accident · 2 fatalForeign investigationRobinson R44 · Nyons, FranceOn September 3, 2012, about 0845 UTC, a Robinson R44 helicopter, Spanish registration EC-IVT, was destroyed when while in level cruise it departed controlled flight and impacted in mountainous terrain near Nyons, France. The pilot and a passenger on board the…NTSB ENG12RA034Accident · 3 fatalForeign investigationBritten Norman BN2B · Taipei, Taiwan R.O.C., TaiwanOn August 30, 2012, a Britten-Norman BN-2B-26 Islander plane, registration number B-68801, powered by two Lycoming 0-540-E4C5 reciprocating engines crashed in a high mountain area in northern Taiwan Republic of China while performing an aerial photography…NTSB ERA12WA544Accident · 3 fatalForeign investigationCessna 210N · Agua Clara, BrazilOn August 25, 2012, at 1215 Universal Coordinated Time (UTC), a Cessna 210N, Brazilian registration PT-OKZ, operated by a private individual, was destroyed following a collision with terrain near Agua Clara, Brazil. The flight originated at Tres Lagoas,…NTSB CEN12WA575Accident · 4 fatalForeign investigationCessna 172 · Moorefield, CanadaOn August 24, 2012, about 2030 eastern daylight time, a Cessna 172S, Canadian registration C-FNET, was substantially damaged on impact with terrain near Moorefield, Ontario, Canada. The pilot and three passengers sustained fatal injuries. Visual…NTSB WPR12WA374Accident · 4 fatalForeign investigationPiper PA31 · Bontang, Indonesia, IndonesiaOn August 24, 2012, at 0551 universal coordinated time, a Piper PA-31-350, PK-IWH, operated by PT. Intan Angkasa Air Service under the pertinent civil regulations of Indonesia, collided with Mt. Tundung Mayang, near Bontang, Indonesia, at an elevation of…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 CEN12WA674Accident · 4 fatalForeign investigationPilatus PC12 · Solemont (Doubs), FranceNTSB ERA12WA530Accident · 4 fatalForeign investigationEmbraer EMB711 · Sta Barbara D'Oeste, BrazilOn August 18, 2012, at 1140 UTC an Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NKA, registered to a private owner, and a Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NIR, registered to a private owner, collided in cruise…NTSB CEN12WA560Accident · 2 fatalForeign investigationPaulistinha 56-C1 56-C1 · Braga, PortugalThis report is under the jurisdiction and control of the Portuguese Government.NTSB CEN12WA562Accident · 2 fatalForeign investigationPiper PA-38-112 · Bruera, Cheshire, United KingdomOn August 16, 2012, about 1940 universal coordinated time, a Piper PA-38-112 airplane, United Kingdom registration G-BODP, impacted terrain during an instructional flight near Bruera, Cheshire, United Kingdom. The flight instructor and student pilot were…NTSB ANC12WA087Accident · 1 fatalForeign investigationPiper PA-30 · Kelowna, CanadaOn August 13, 2012, about 1729 Pacific daylight time, a Piper PA-30 airplane, (Canadian Registration C-GLGJ) was on a VFR flight plan from Penticton to Boundary Bay, British Columbia. The Canadian Joint Rescue Coordination Centre received an ELT signal, and a…NTSB ERA12WA512Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Marmara Sea, TürkiyeOn August 12, 2012, at 1115 Universal Coordinated Time (UTC), a Cirrus SR-22, Turkish Registration TC-SAS, was destroyed when it impacted the Marmara Sea during an instructional flight. The two pilots on board were fatally injured. The flight originated from…NTSB ERA12WA497Accident · 1 fatalForeign investigationCessna A188A · Casanare, ColombiaOn August 2, 2012, about 1830 universal coordinated time, a Cessna A188A, Columbian registration HK-1477, was substantially damaged when it impacted wires and terrain during an aerial application flight near Casanare, Columbia. The foreign certificated pilot…NTSB CEN12WA506Accident · 2 fatalForeign investigationCessna 500 · Santiago de Compostela, SpainOn August 2, 2012, at 0440 UTC, a Cessna 500 Citation, Spanish registration EC-IBA, owned and operated by AIRNOR, was destroyed when it impacted terrain 1.2 miles from the Santiago de Compostela Airport, Lavacolla, Galacia, Spain. The two pilots on board the…NTSB ERA12WA488Accident · 8 fatalForeign investigationBeech 200 · Juiz de Fora, BrazilThis investigation is being conducted by the Brazilian Aeronautical Accident Prevention and Investigation Center This report is for information purposes only and contains only information released by the government Brazil. All inquiries should be directed to…NTSB DCA12WA135Accident · 3 fatalForeign investigationAgusta A109 · Jiquipilco, MexicoThe Mexican Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an accident involving a AgustaWestland 109SP helicopter that occurred on July 28, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation…NTSB CEN12WA478Accident · 1 fatalForeign investigationCessna 172 · Portreath, United KingdomOn July 21, 2012, at 1421 UTC, a Cessna F172M, United Kingdom registration G-ROUP, was substantially damaged when it impacted a cliff near Portreath, Cornwall, England. A post impact fire ensued. The pilot, the sole person on board was fatally injured. Visual…NTSB WPR12WA327Accident · 3 fatalForeign investigationEurocopter EC120B · Triso, MalaysiaOn July 20,1012, at 1335 universal coordinated time, a Eurocopter EC120B, N8899, ditched into the Batang Lupar River, near Triso, Malaysia. The helicopter had a United States registration and was operated by the Sebiro Holding Company under the provisions of…