# NTSB investigations, 2012, Outside the U.S.

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 6 · 259 cases

## Latest cases

- [NTSB ENG13WA010](https://openairdocs.org/ntsb/ENG13WA010.md): Boeing 777-222 · Seoul, South Korea, South Korea · Incident · No injuries · Foreign investigation · Dec 31, 2012 · N206UA · No damage
  > On 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 DCA13WA051](https://openairdocs.org/ntsb/DCA13WA051.md): San Pedro Sula, Honduras · Accident · No injuries · Foreign investigation · Dec 31, 2012 · HR-AWG · Substantial damage
  > On 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 WPR13WA187](https://openairdocs.org/ntsb/WPR13WA187.md): Bell 407 · Katra, India, India · Accident · Serious injuries · Foreign investigation · Dec 30, 2012 · VT-PHH · Substantial damage
  > On 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 CEN13WA123](https://openairdocs.org/ntsb/CEN13WA123.md): Piper PA-28-235 · Guatemala City, Guatemala · Accident · 2 fatal · Foreign investigation · Dec 29, 2012 · N64KW · Substantial damage
- [NTSB ERA13WA103](https://openairdocs.org/ntsb/ERA13WA103.md): Piper PA28 · Minas City, Brazil · Accident · 2 fatal · Foreign investigation · Dec 26, 2012 · PR-NAX · Destroyed
  > On 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 CEN13WA178](https://openairdocs.org/ntsb/CEN13WA178.md): Cessna · Cozumel, Mexico · Accident · No injuries · Foreign investigation · Dec 26, 2012 · XB-JJE · Substantial damage
  > On 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 DCA13WA041](https://openairdocs.org/ntsb/DCA13WA041.md): Fokker 100 · Heho, Myanmar (Burma) · Accident · Serious injuries · Foreign investigation · Dec 25, 2012 · XY-AGC · Substantial damage
  > 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 DCA13WA034](https://openairdocs.org/ntsb/DCA13WA034.md): Swearingen SA227 · Sanikiluaq, Canada · Accident · 1 fatal · Foreign investigation · Dec 22, 2012 · C-GFWX · Substantial damage
  > On 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 ENG13RA009](https://openairdocs.org/ntsb/ENG13RA009.md): Airbus A330 · Phuket, Thailand · Incident · No injuries · Foreign investigation · Dec 20, 2012 · D-ABXA · Minor damage
  > On 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 CEN13WA146](https://openairdocs.org/ntsb/CEN13WA146.md): Bell UH1H · Ruthi, Switzerland · Accident · Minor injuries · Foreign investigation · Dec 20, 2012 · HB-RXC · Destroyed
  > On 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 ERA13WA089](https://openairdocs.org/ntsb/ERA13WA089.md): Piper PA34 · Zulia, Colombia · Accident · 4 fatal · Foreign investigation · Dec 12, 2012 · HK4477G · Destroyed
  > On 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 DCA13RA025](https://openairdocs.org/ntsb/DCA13RA025.md): Learjet 25 · Monterrey, Mexico · Accident · 7 fatal · Foreign investigation · Dec 9, 2012 · N345MC · Destroyed
- [NTSB DCA13WA033](https://openairdocs.org/ntsb/DCA13WA033.md): Boeing 737 · Shonai, Japan · Incident · No injuries · Foreign investigation · Dec 8, 2012 · JA57AN · No damage
  > On 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 CEN13WA092](https://openairdocs.org/ntsb/CEN13WA092.md): Piper PA-32-301 · Melbach, Germany · Accident · 8 fatal · Foreign investigation · Dec 8, 2012 · D-EUEU · 2 aircraft · Substantial damage
  > On 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 ANC13WA013](https://openairdocs.org/ntsb/ANC13WA013.md): Robinson R44 · Slave Lake, Alberta, Canada · Accident · 1 fatal · Foreign investigation · Dec 5, 2012 · C-FRSO · Substantial damage
  > On 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 DCA13WA032](https://openairdocs.org/ntsb/DCA13WA032.md): Boeing 737 · Perth, Australia · Incident · No injuries · Foreign investigation · Dec 4, 2012 · VH-VZL · No damage
  > On 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 DCA13WA160](https://openairdocs.org/ntsb/DCA13WA160.md): Boeing Boeing 777-236 · Shannon, Ireland · Incident · No injuries · Foreign investigation · Dec 2, 2012 · G-VIIK · Minor damage
  > The 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 DCA13WA031](https://openairdocs.org/ntsb/DCA13WA031.md): Boeing 737 · Bogota, Colombia · Incident · No injuries · Foreign investigation · Nov 24, 2012 · HP1371CM · No damage
  > On 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 ERA13WA080](https://openairdocs.org/ntsb/ERA13WA080.md): Piper PA-25-260 · El Viento, Colombia · Accident · 1 fatal · Foreign investigation · Nov 22, 2012 · HK588 · Substantial damage
  > On 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 ERA13WA066](https://openairdocs.org/ntsb/ERA13WA066.md): Aerospatiale AS-355F1 · Great Guana Cay, Bahamas · Accident · 1 fatal · Foreign investigation · Nov 22, 2012 · C6-APV · Substantial damage
  > On 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 ERA13WA078](https://openairdocs.org/ntsb/ERA13WA078.md): Cessna R172K · Cuchilla La Laja, Colombia · Accident · 1 fatal · Foreign investigation · Nov 19, 2012 · HK4890G · Substantial damage
  > On 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 ENG13WA038](https://openairdocs.org/ntsb/ENG13WA038.md): Airbus A310 - 308 · Karachi, Pakistan · Incident · No injuries · Foreign investigation · Nov 18, 2012 · AP-BEB · No damage
  > The 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 ANC13WA010](https://openairdocs.org/ntsb/ANC13WA010.md): Cessna 208 · Snow Lake, Canada · Accident · 1 fatal · Foreign investigation · Nov 18, 2012 · C-GAGP · Substantial damage
  > On 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 ANC13WA011](https://openairdocs.org/ntsb/ANC13WA011.md): Piper PA46 · La Crete, Canada · Accident · 1 fatal · Foreign investigation · Nov 17, 2012 · C-GWEI · Substantial damage
  > On 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 ERA13WA431](https://openairdocs.org/ntsb/ERA13WA431.md): Beech 95B55 - B · Concepcion, Paraguay · Accident · 3 fatal · Foreign investigation · Nov 16, 2012 · ZP-BLV · Destroyed
  > On 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 CEN13WA065](https://openairdocs.org/ntsb/CEN13WA065.md): Cessna 172 · Ostermaima, Sweden · Accident · 1 fatal · Foreign investigation · Nov 16, 2012 · SE-KHX · Destroyed
  > On 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 DCA13WA020](https://openairdocs.org/ntsb/DCA13WA020.md): Boeing MD-82 · Johannesburg, South Africa · Incident · No injuries · Foreign investigation · Nov 13, 2012 · ZS-TOG · Minor damage
  > On 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 CEN13WA173](https://openairdocs.org/ntsb/CEN13WA173.md): Swearingen SA226 · Murcia, Spain · Accident · No injuries · Foreign investigation · Nov 13, 2012 · EC-JYC · Minor damage
  > On 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 ERA13WA063](https://openairdocs.org/ntsb/ERA13WA063.md): Cessna 525B · Sao Paulo, Brazil · Accident · Serious injuries · Foreign investigation · Nov 11, 2012 · PR-MRG · Substantial damage
  > On 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 ENG13WA007](https://openairdocs.org/ntsb/ENG13WA007.md): Airbus A380-861 · Richmond NSW, Australia · Incident · No injuries · Foreign investigation · Nov 11, 2012 · A6-EDA · No damage
  > On 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 DCA13WA019](https://openairdocs.org/ntsb/DCA13WA019.md): Boeing 757 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Nov 11, 2012 · D-ABOE · No damage
  > On 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 CEN13WA061](https://openairdocs.org/ntsb/CEN13WA061.md): Reims-Cessna F150 · Birr, Ireland, Ireland · Accident · 2 fatal · Foreign investigation · Nov 11, 2012 · EI-AST · Destroyed
  > On 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 ENG13RA006](https://openairdocs.org/ntsb/ENG13RA006.md): Boeing 777 · Mumbai, India, India · Incident · No injuries · Foreign investigation · Nov 7, 2012 · A6-EBO · Minor damage
  > On 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 ERA13WA074](https://openairdocs.org/ntsb/ERA13WA074.md): Piper PA-31T · Curitiba, Brazil · Accident · 4 fatal · Foreign investigation · Nov 6, 2012 · PT-MFW · Destroyed
  > On 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 ERA13WA068](https://openairdocs.org/ntsb/ERA13WA068.md): Embraer 810D · Chapada dos Guimaraes, Brazil · Accident · 4 fatal · Foreign investigation · Nov 1, 2012 · PT-VRV · Substantial damage
  > On 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 DCA13WA029](https://openairdocs.org/ntsb/DCA13WA029.md): Boeing 737 · Pontianak, Indonesia · Incident · No injuries · Foreign investigation · Nov 1, 2012 · PK-LIF · Minor damage
  > The 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 ERA13WA050](https://openairdocs.org/ntsb/ERA13WA050.md): Cessna 206 · Kiim, Ecuador · Accident · Serious injuries · Foreign investigation · Oct 31, 2012 · HC-CBG · Substantial damage
  > On 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 WPR13WA030](https://openairdocs.org/ntsb/WPR13WA030.md): Cessna 172 · Ballarat, Australia, Australia · Accident · 1 fatal · Foreign investigation · Oct 29, 2012 · VH-TKI · Substantial damage
  > On 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 DCA13WA016](https://openairdocs.org/ntsb/DCA13WA016.md): ATR ATR42 · Ipatinga, Brazil · Incident · No injuries · Foreign investigation · Oct 28, 2012 · PR-TTK · No damage
  > On 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 CEN13WA036](https://openairdocs.org/ntsb/CEN13WA036.md): Bell 206B · Nueva Concepción, Guatemala · Accident · 1 fatal · Foreign investigation · Oct 27, 2012 · TG-PMR · Substantial damage
  > On 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 DCA13WA023](https://openairdocs.org/ntsb/DCA13WA023.md): Boeing 737 · Casablanca, Morocco · Incident · No injuries · Foreign investigation · Oct 24, 2012 · CN-ROA · Minor damage
  > On 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 DCA13WA015](https://openairdocs.org/ntsb/DCA13WA015.md): Boeing 737 · Brasilia, Brazil · Incident · No injuries · Foreign investigation · Oct 24, 2012 · PR-WJD · No damage
  > The 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 CEN13WA020](https://openairdocs.org/ntsb/CEN13WA020.md): Mooney M20E · Speichersdorf, Germany · Accident · 2 fatal · Foreign investigation · Oct 21, 2012 · D-EMHE · Destroyed
  > On 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 ENG13WA003](https://openairdocs.org/ntsb/ENG13WA003.md): Boeing 737-846 · Tokyo, Japan, Japan · Incident · No injuries · Foreign investigation · Oct 20, 2012 · JA342J · No damage
  > On 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 DCA13WA011](https://openairdocs.org/ntsb/DCA13WA011.md): Boeing 737 · Riga, Latvia · Incident · No injuries · Foreign investigation · Oct 20, 2012 · 2 aircraft · No damage
  > On 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 DCA13WA007](https://openairdocs.org/ntsb/DCA13WA007.md): Boeing 737 · Pontianak, Indonesia · Accident · No injuries · Foreign investigation · Oct 19, 2012 · PK-CKN · Minor damage
  > On 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 DCA13WA005](https://openairdocs.org/ntsb/DCA13WA005.md): Boeing 737 · Glasgow, United Kingdom · Incident · No injuries · Foreign investigation · Oct 19, 2012 · G-GDFJ · Minor damage
  > On 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 DCA13WA012](https://openairdocs.org/ntsb/DCA13WA012.md): Boeing 737 · Canberra, Australia · Incident · No injuries · Foreign investigation · Oct 17, 2012 · VH-VXB · No damage
  > On 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 DCA13CA008](https://openairdocs.org/ntsb/DCA13CA008.md): Bombardier DHC-8-315 · Kabul, Afghanistan · Accident · No injuries · Data collection · Final report · Oct 17, 2012 · N800AW · Substantial damage
  > the 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 CEN13WA014](https://openairdocs.org/ntsb/CEN13WA014.md): Lake 250 · Pickle Lake, Ontario, Canada · Accident · 3 fatal · Foreign investigation · Oct 17, 2012 · C-GZLC · Substantial damage
  > On 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…

Next page: https://openairdocs.org/ntsb.md?year=2012&state=OF&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb?state=OF&year=2012

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.