NTSB investigations, 2012, Outside the U.S.
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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 | 9 |
|---|---|
| 1963 | 3 |
| 1964 | 108 |
| 1965 | 99 |
| 1966 | 106 |
| 1967 | 101 |
| 1968 | 64 |
| 1969 | 63 |
| 1970 | 70 |
| 1971 | 56 |
| 1972 | 79 |
| 1973 | 66 |
| 1974 | 65 |
| 1975 | 58 |
| 1976 | 16 |
| 1977 | 24 |
| 1978 | 36 |
| 1979 | 14 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 8 |
| 1987 | 22 |
| 1988 | 41 |
| 1989 | 25 |
| 1990 | 30 |
| 1991 | 29 |
| 1992 | 36 |
| 1993 | 41 |
| 1994 | 42 |
| 1995 | 66 |
| 1996 | 61 |
| 1997 | 93 |
| 1998 | 134 |
| 1999 | 110 |
| 2000 | 159 |
| 2001 | 152 |
| 2002 | 134 |
| 2003 | 136 |
| 2004 | 154 |
| 2005 | 174 |
| 2006 | 181 |
| 2007 | 174 |
| 2008 | 174 |
| 2009 | 181 |
| 2010 | 227 |
| 2011 | 238 |
| 2012 | 259 |
| 2013 | 248 |
| 2014 | 219 |
| 2015 | 268 |
| 2016 | 319 |
| 2017 | 304 |
| 2018 | 337 |
| 2019 | 323 |
| 2020 | 257 |
| 2021 | 428 |
| 2022 | 429 |
| 2023 | 460 |
| 2024 | 492 |
| 2025 | 475 |
| 2026 | 390 |
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'
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' 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 ENG13WA010Incident · No injuriesForeign investigationBoeing 777-222 · Seoul, South Korea, South KoreaOn December 31, 2012, a United Airlines Boeing 777, registration number N206UA, experienced a No.1 (left)engine failure while passing through flight level (FL)250. The crew received an “ENG FAIL” Engine Indicating and Crew Alerting (EICAS) message. The Flight…NTSB DCA13WA051Accident · No injuriesForeign investigationSan Pedro Sula, HondurasOn December 31, 2012, at 1014 local time, a British Aerospace Jetstream 3101, registration HR-AWG operated by EasySky as flight EKY-734 veered off the runway and came to rest in a ditch upon landing at San Pedro Sula Airport (SAP), Honduras .The flight was a…NTSB WPR13WA187Accident · Serious injuriesForeign investigationBell 407 · Katra, India, IndiaOn December 30, 2012, at 0645 universal coordinated time, a Bell 407, VT-PHH, registered to and operated by Pawan Hans Helicopter Ltd., experienced a loss of engine power and subsequent hard landing to the Katra Helipad, Katra, India. The helicopter was…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 CEN13WA178Accident · No injuriesForeign investigationCessna · Cozumel, MexicoOn December 26, 2012, at 1020 central standard time, a Cessna 401-A airplane, Mexico registration XB-JJE, sustained substantial damage when it lost engine power and impacted terrain near Cozumel, Mexico. The pilot and 4 passengers on board were not injured.…NTSB DCA13WA041Accident · Serious injuriesForeign investigationFokker 100 · Heho, Myanmar (Burma)On December 25, 2102, at 08:50 local time, a Fokker 100, registration XY-AGC operated by Air Bagan as flight W9-11 crashed short of the runway at Heho Myanmar (Burma). The flight was a scheduled passenger flight from Mandalay. There was one fatality and…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 ENG13RA009Incident · No injuriesForeign investigationAirbus A330 · Phuket, ThailandOn December 20, 2012, at about 1341 UTC, an Air Berlin Airbus Industrie A330-200 airplane, registered in Germany as D-ABXA, experienced a failure of the left engine, a Pratt & Whitney PW4168, shortly after takeoff from Phuket, Thailand. After the engine…NTSB CEN13WA146Accident · Minor injuriesForeign investigationBell UH1H · Ruthi, SwitzerlandOn December 20, 2012, at 1523 UTC, a Bell UH-1H, Swiss registration HB-RXC, owned and operated by a private individual, was destroyed when it impacted terrain near Ruthi, Switzerland, following an engine malfunction. The pilot and two passengers on board were…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 DCA13WA033Incident · No injuriesForeign investigationBoeing 737 · Shonai, JapanOn 8 December 2012, at approximately 1326 UTC (2236 local time), a Boeing 737-800, registration JA57AN, operated by All Nippon Airways, overran the runway after landing at Shonai Airport (RJSY), Yamagata, Japan, and came to rest in the grass area past the end…NTSB 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 DCA13WA032Incident · No injuriesForeign investigationBoeing 737 · Perth, AustraliaOn 4 December 2012, at approximately 1618 local time, a Boeing 737-800, registration VH-VZL, experienced a significant wind shift which degraded the aircraft's takeoff performance during the takeoff run. The crew applied full power and continued the takeoff.…NTSB DCA13WA160Incident · No injuriesForeign investigationBoeing Boeing 777-236 · Shannon, IrelandThe Air Accident Investigations Unit of Ireland has notified the NTSB of an incident involving a Boeing 777 that occurred on December 02, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU-I investigation under the provisions of…NTSB DCA13WA031Incident · No injuriesForeign investigationBoeing 737 · Bogota, ColombiaOn 24 November, 2012, at approxiumately 1636 UTC time, a Boeing B737-7V3, registration HP1371CM, operated by Copa Airlines Columbia between Bogota and Cartegna, Coulmbia, experienced a depressurization while climbing through FL240 and the oxygen masks…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 ENG13WA038Incident · No injuriesForeign investigationAirbus A310 - 308 · Karachi, PakistanThe Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Airbus A-310-308, registration number AP-BEB, powered by General Electric CF6-80C2A8…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 DCA13WA020Incident · No injuriesForeign investigationBoeing MD-82 · Johannesburg, South AfricaOn November 13, 2012, a McDonnell Douglas MD-80, registration ZS-TOG, experienced a wheel failure on the left hand main gear during takeoff from O.R.Tambo International Airport (FAJS), , South Africa. The chartered flight was enroute to Kamuzu International…NTSB CEN13WA173Accident · No injuriesForeign investigationSwearingen SA226 · Murcia, SpainOn November 13, 2012, at 1205 coordinated universal time, a Swearingen Fairchild SA-226-TC, Spanish registered EC-JYC, operated by Zorex.org, sustained minor damage during the takeoff roll from the Murcia-San Javier Airport (LELC), Murcia, Spain. Visual…NTSB ERA13WA063Accident · Serious injuriesForeign investigationCessna 525B · Sao Paulo, BrazilOn November 11, 2012, at 1921 universal coordinated time, a Cessna Citation 525B, Brazilian registration PR-MRG, sustained substantial damage when it overran the runway during landing. One of the 2 crewmembers received serious injuries and the other received…NTSB ENG13WA007Incident · No injuriesForeign investigationAirbus A380-861 · Richmond NSW, AustraliaOn November 11, 2012, an Airbus A380-861, Reg. No. A6-EDA, performed an air turnback following an engine shutdown during climb after takeoff from Sydney NSW airport (SYD). The crew reported abnormal No. 3 engine indications and subsequent automatic engine…NTSB DCA13WA019Incident · No injuriesForeign investigationBoeing 757 · Frankfurt, GermanyOn November 11, 2013, a Boeing B757-300, registration D-ABOE, operated by Condor Flugdienst, experienced a smell in cockpit and cabin during take off roll and climb. The airplane returned to Frankfurt and landed uneventfully. There was no damage to the…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 ENG13RA006Incident · No injuriesForeign investigationBoeing 777 · Mumbai, India, IndiaOn November 7, 2012, a Boeing 777-300, registration number A6-EBO, operated by Emirates declared an emergency for a No. 2 engine failure after takeoff from the Bangkok International Airport, Thailand. The crew confirmed they had a No. 2 engine fire warning…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 DCA13WA029Incident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaThe National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an accident involving a Boeing 737-400 that occurred on November 01, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…NTSB ERA13WA050Accident · Serious injuriesForeign investigationCessna 206 · Kiim, EcuadorOn October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…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 DCA13WA016Incident · No injuriesForeign investigationATR ATR42 · Ipatinga, BrazilOn 28 October 2013, at approximately 1650 UTC time, an ATR-42-500, registration PR-TTK, operated by Trip Linhas Aeras Brasil, exeprienced an engine failure after takeoff. The flight was being operated as a ferry flight between SBIP and SBBH, with only the…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 DCA13WA023Incident · No injuriesForeign investigationBoeing 737 · Casablanca, MoroccoOn October 24, 2012 a Boeing 737-800, registration CN-ROA experienced a nosewheel failure during taxiing after landing at the Casablanca / Mohammed V Airport. The airplane was operated by Royal Air Maroc as flight 471 from Tunis, Tunisia. There were no…NTSB DCA13WA015Incident · No injuriesForeign investigationBoeing 737 · Brasilia, BrazilThe Aeronautical Accident Prevention and Investigation Center of Brazil (CENIPA), has notified the NTSB of an incident involving a Boeing 737 that occurred on October 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…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 ENG13WA003Incident · No injuriesForeign investigationBoeing 737-846 · Tokyo, Japan, JapanOn October 20, 2012, a Boeing 737-800, registered JA342J, operated by JAL Express, departed from Tokyo International Airport and declared an emergency No. 1 engine failure during climb. The pilot reported low engine RPM and high exhaust gas temperature…NTSB DCA13WA011Incident · No injuriesForeign investigationBoeing 737 · Riga, LatviaOn October 20, 2012 about 1150 Coordinated Universal Time (UTC), a loss of separation occurred when a Boeing operated by KLM Royal Dutch Airlines and an Embraer operated by Finnair came within 4.2 nautical miles laterally and 700 feet vertically of each other…NTSB DCA13WA007Accident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaOn October 19, 2012, Sriwijaya Air flight SJ182, a Boeing 737-4Q8, registration PK-CKN (msn 26281 built 1992), sustained damage after it overran the runway on landing at Supadio Airport, Pontianak, Indonesia, and reportedly suffered a nose undercarriage…NTSB DCA13WA005Incident · No injuriesForeign investigationBoeing 737 · Glasgow, United KingdomOn October 19, 2012, at 0655 UTC time, a Boeing 737-800, registration G-GDFJ, operated by Jet2.com as a scheduled passenger flight LS177 between Glasgow, Scotland and Alicante, Spain, rejected the takeoff due to smoke in the cabin. The aircraft stopped on the…NTSB DCA13WA012Incident · No injuriesForeign investigationBoeing 737 · Canberra, AustraliaOn October 17, 2012, about 2045 local time, a Boeing 737-838, registration VH-VXB, descended below the assigned altitude and below the minimum safe altitude for the area of operation. Air traffic control received a minimum safe altitude warning. The incident…NTSB DCA13CA008Accident · No injuriesData collectionFinal reportBombardier DHC-8-315 · Kabul, Afghanistanthe captains ineffective management of the airplanes energy state during final approach and flare that resulted in a hard landing and tail strike at touchdown.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…