# NTSB investigations, 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 75 of 183 · 9,105 cases

## Cases, newest first

- [NTSB DCA17WA190](https://openairdocs.org/ntsb/DCA17WA190.md): Embraer EMB145 · Medellin, Colombia · Incident · No injuries · Foreign investigation · Aug 31, 2017 · HK4535 · No damage
  > The government of Colombia has notified the NTSB of an incident involving a EMBRAER EMB145 airplane that occurred on August 31, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…
- [NTSB CEN17WA384](https://openairdocs.org/ntsb/CEN17WA384.md): Diamond DA20 · Sankt Veit, Austria · Accident · No injuries · Foreign investigation · Aug 29, 2017 · D-EJFT · Substantial damage
  > The government of Austria has notified the NTSB of an accident involving a DIAMOND DA20 airplane that occurred on August 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions…
- [NTSB ENG17WA035](https://openairdocs.org/ntsb/ENG17WA035.md): Sikorsky 300 · Herzelia, Israel · Accident · Minor injuries · Foreign investigation · Aug 28, 2017 · 4X-BIM · Substantial damage
  > The Ministry of Transport of the State of Israel, has notified the NTSB of an accident involving a Sikorsky S-300C, registration 4X-BIM, that occurred on August 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the investigation…
- [NTSB ERA17WA351](https://openairdocs.org/ntsb/ERA17WA351.md): Cessna 207 · Recanati, Italy · Incident · No injuries · Foreign investigation · Aug 27, 2017 · D-EPJR · Minor damage
  > The government of Italy has notified the NTSB of an accident involving a CESSNA 207 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…
- [NTSB ERA17WA296](https://openairdocs.org/ntsb/ERA17WA296.md): Cessna T210 · Ciudad Bolivar, Venezuela · Accident · 1 fatal · Foreign investigation · Aug 27, 2017 · YV2594 · Substantial damage
  > On 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…
- [NTSB DCA17WA189](https://openairdocs.org/ntsb/DCA17WA189.md): Airbus A320 233 · Lima, Peru · Incident · No injuries · Foreign investigation · Aug 27, 2017 · N491TA · No damage
  > The Comisión de Investigación de Accidentes de Aviación (CIAA) of Peru has notified the NTSB of an incident involving a AIRBUS A320 233 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…
- [NTSB ENG17WA034](https://openairdocs.org/ntsb/ENG17WA034.md): Boeing 747 · Delhi, India · Accident · No injuries · Foreign investigation · Aug 26, 2017 · ER-BAT · Substantial damage
  > The India Aircraft Accident Investigation Bureau (AAIB) has notified the NTSB of an incident involving a Boeing 747-200 which occurred on August 26, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…
- [NTSB ERA17WA308](https://openairdocs.org/ntsb/ERA17WA308.md): Maule M7 · Zhideli, Kazakhstan · Accident · 1 fatal · Foreign investigation · Aug 25, 2017 · UP-ML003 · Substantial damage
  > On 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…
- [NTSB DCA17WA220](https://openairdocs.org/ntsb/DCA17WA220.md): Boeing 767 424ER · Zurich, Switzerland · Incident · No injuries · Foreign investigation · Aug 23, 2017 · N68061 · No damage
  > The Swiss Transportation Safety Investigation Board has notified the NTSB of an incident involving a BOEING 767 424ER airplane that occurred on August 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's…
- [NTSB DCA17WA185](https://openairdocs.org/ntsb/DCA17WA185.md): Boeing 737 · Georgetown, Guyana · Incident · No injuries · Foreign investigation · Aug 23, 2017 · XA-UHZ · No damage
  > The Guyana Civil Aviation Authority (CAA) has notified the NTSB of an incident involving a Boeing 737-200, which occurred on August 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions of ICAO…
- [NTSB CEN17WA325](https://openairdocs.org/ntsb/CEN17WA325.md): Aviat Pitts S-2B · Holmestrand, Norway · Accident · 2 fatal · Foreign investigation · Aug 22, 2017 · LN-PTS · Destroyed
  > On 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…
- [NTSB ERA17WA283](https://openairdocs.org/ntsb/ERA17WA283.md): Robinson R66 · Maly Utrish, Russia · Accident · 1 fatal · Foreign investigation · Aug 21, 2017 · RA-05750 · Substantial damage
  > On 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…
- [NTSB CEN17WA379](https://openairdocs.org/ntsb/CEN17WA379.md): Cessna 172RG · Balchik, Bulgaria · Incident · No injuries · Foreign investigation · Aug 21, 2017 · LZ-SPD · Minor damage
  > On August 21, 2017, at 1150 coordinated universal time, a Cessna 172RG, Bulgarian registration LZ-SPD, operated by Aviootryad Varna Ltd, collided with the runway during a gear-up landing at the Balchik Airfield (LBWB), Balchik, Bulgaria. The pilot and…
- [NTSB ERA17WA289](https://openairdocs.org/ntsb/ERA17WA289.md): Learjet 25 · Naiguata, Venezuela · Accident · 5 fatal · Foreign investigation · Aug 19, 2017 · YV3191 · Substantial damage
  > On August 19, 2017, about 0415 universal coordinated time, a Learjet 25D, Venezuelan registration YV3191, descended and impacted the ocean about 5 nautical miles north of Naiguatá, Vargas, Venezuela. The two pilots and three passengers were fatally injured.…
- [NTSB WPR17WA203](https://openairdocs.org/ntsb/WPR17WA203.md): Robinson Helicopter R44 II · Darwin Aerodrome, Australia · Accident · No injuries · Foreign investigation · Aug 18, 2017 · VH-LGN · Substantial damage
  > On August 18, 2017, at 1400 local time, a Robinson R44 II, VH-LGN, was substantially damaged during a forced landing near Darwin Aerodrome, Australia. The helicopter was operated under the pertinent civil regulations of the government of Australia. The pilot…
- [NTSB CEN17WA320](https://openairdocs.org/ntsb/CEN17WA320.md): Piper PA36 · Vejer de la Frontera, Spain · Accident · 1 fatal · Foreign investigation · Aug 15, 2017 · EC-EHB · Substantial damage
  > On August 15, 2017, a Piper PA-36-375 airplane (EC-EHB, s/n 36-8102001) impacted terrain during fumigation operations in the vicinity of Vejer de la Frontera, Spain. The pilot was fatally injured.This investigation is under the jurisdiction and control of the…
- [NTSB ANC17WA048](https://openairdocs.org/ntsb/ANC17WA048.md): Socata TBM 700 · Zemyo, Japan · Accident · 2 fatal · Foreign investigation · Aug 14, 2017 · N702AV · Destroyed
  > On Aug 14, 2017, at 1215 Japan standard time, a United States registered Socata TBM 700 airplane, N702AV, operated by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Zemyo in Nara Prefecture, Japan.…
- [NTSB DCA17WA176](https://openairdocs.org/ntsb/DCA17WA176.md): Boeing 767 332 · London, United Kingdom · Incident · Minor injuries · Foreign investigation · Aug 13, 2017 · N1608 · No damage
  > The Air Accident Investigation Branch (AAIB) of United Kingdom has notified the NTSB of a serious incident involving a BOEING 767 332 airplane that occurred on August 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…
- [NTSB ERA17WA273](https://openairdocs.org/ntsb/ERA17WA273.md): Bell 206 · Algiers, Algeria · Accident · 4 fatal · Foreign investigation · Aug 10, 2017 · 7T-WUF · Substantial damage
  > On August 10, 2017, about 0930 coordinated universal time, Bell 206L3 helicopter, Algerian registration 7T-WUF, was substantially damaged when it impacted terrain while maneuvering in Algiers, Algeria. The pilot and three passengers were fatally injured. The…
- [NTSB DCA17WA171](https://openairdocs.org/ntsb/DCA17WA171.md): Boeing 737 · Bacau, Romania · Incident · No injuries · Foreign investigation · Aug 10, 2017 · YR-BAJ · No damage
  > The Civil Aviation Safety Investigation and Analysis Center of Romania has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…
- [NTSB ANC17WA045](https://openairdocs.org/ntsb/ANC17WA045.md): Air Tractor AT502 · La Crete, Canada · Accident · 1 fatal · Foreign investigation · Aug 10, 2017 · C-FWAS · Substantial damage
  > On August 10, 2017, about 0320 Coordinated Universal Time, an Air Tractor AT-502B airplane, C-FWAS, impacted terrain while conducting an aerial application repositioning turn near La Crete, Alberta, Canada. The pilot sustained fatal injuries. The…
- [NTSB ERA17RA315](https://openairdocs.org/ntsb/ERA17RA315.md): Cessna U206 · Eteringbang, Guyana · Accident · Serious injuries · Foreign investigation · Aug 8, 2017 · 8R-GPR · Substantial damage
  > On August 8, 2017, about 1513 coordinated universal time (UTC), a Cessna U206G, 8R-GPR, was substantially damaged during a forced landing in trees shortly after takeoff from Eteringbang Airstrip (SYET), Eteringbang, Cuyuni-Mazaruni Region, Guyana. Visual…
- [NTSB DCA17WA225](https://openairdocs.org/ntsb/DCA17WA225.md): Boeing 737 · Dubai, United Arab Emirates · Incident · No injuries · Foreign investigation · Aug 8, 2017 · A6-FDS · Minor damage
  > The GCAA of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO…
- [NTSB DCA17WA175](https://openairdocs.org/ntsb/DCA17WA175.md): Embraer EMB135 · Middlemount, Australia · Incident · No injuries · Foreign investigation · Aug 8, 2017 · VH-JGB · No damage
  > The Australian Transport Safety Board (ATSB) has notified the NTSB of a serious incident involving a EMBRAER EMB135 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…
- [NTSB DCA17WA172](https://openairdocs.org/ntsb/DCA17WA172.md): Boeing 787-9 · Madrid, Spain · Incident · No injuries · Foreign investigation · Aug 8, 2017 · N825AA · No damage
  > The government of Spain has notified the NTSB of an incident involving a BOEING 787-9 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…
- [NTSB CEN17WA310](https://openairdocs.org/ntsb/CEN17WA310.md): Piper PA28 · Berghaus Diavolezza, Switzerland · Accident · 3 fatal · Foreign investigation · Aug 4, 2017 · HB-PER · Substantial damage
  > On August 4, 2017, at 0720 UTC, a Piper PA-28-181, Swiss registration HB-PER, owned and operated by a private individual, impacted mountainous terrain near Berghaus Diavolezza, Switzerland. The pilot and two passengers on board were fatally injured. A third…
- [NTSB CEN17WA308](https://openairdocs.org/ntsb/CEN17WA308.md): American Champion 8GCBC · Dunaujvaros, Hungary · Accident · No injuries · Foreign investigation · Aug 4, 2017 · HA-KYL · Destroyed
  > The government of Hungary has notified the National Transportation Safety Board (NTSB) of an accident involving an American Champion 8GCBC airplane that occurred on August 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB DCA17WA165](https://openairdocs.org/ntsb/DCA17WA165.md): Boeing 737 · Medan, Indonesia · Accident · No injuries · Foreign investigation · Aug 3, 2017 · PK-LJZ · Substantial damage
  > The KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…
- [NTSB WPR17WA178](https://openairdocs.org/ntsb/WPR17WA178.md): Robinson Helicopter R22 Beta · Cloncurry, Australia · Accident · 1 fatal · Foreign investigation · Aug 2, 2017 · VH-HGU · Destroyed
  > On August 2, 2017, at 0740 local time, a Robinson R22, VH-HGU, was destroyed by a post-impact fire following a collision with power lines during cruise flight near Cloncurry Aerodrome, Australia. The helicopter was operated under the pertinent civil…
- [NTSB CEN17WA321](https://openairdocs.org/ntsb/CEN17WA321.md): Robinson R44 · Puerto Chiapas, Mexico · Accident · 1 fatal · Foreign investigation · Aug 2, 2017 · XB-MWZ · Substantial damage
  > On August 2, 2017, about 2115 universal coordinated time, a Robinson R44 helicopter, XB-MWZ, had a loss of engine power and subsequently impacted the Pacific Ocean near Puerto Chiapas, Mexico. Two persons were on board the helicopter. One person was reported…
- [NTSB DCA17WA174](https://openairdocs.org/ntsb/DCA17WA174.md): Boeing 777 · Singapore, Singapore · Accident · Serious injuries · Foreign investigation · Aug 1, 2017 · 9V-SQN · No damage
  > The Transport Safety Investigation Bureau (TSIB) Ministry of Transport of Singapore has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB DCA17WA168](https://openairdocs.org/ntsb/DCA17WA168.md): Boeing 737 · Tijuana, Mexico · Incident · No injuries · Foreign investigation · Aug 1, 2017 · N368AR · No damage
  > The Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation…
- [NTSB DCA17WA164](https://openairdocs.org/ntsb/DCA17WA164.md): Boeing 747 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Aug 1, 2017 · D-ABYS · No damage
  > The BFU of Germany has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB CEN17RA377](https://openairdocs.org/ntsb/CEN17RA377.md): Mcdonnell Douglas MD900 · Heiligenblut, Austria · Accident · Minor injuries · Foreign investigation · Aug 1, 2017 · OE-XWF · Substantial damage
  > On August 1, 2017, at 1815 UTC, a McDonnell Douglas MD 900 Helicopter, Austrian registration OE-XWF, impacted mountainous terrain about 8 miles west-northwest of Heiligenblut, Austria. One medical crewmember sustained minor injuries. The pilot, the other…
- [NTSB DCA17WA163](https://openairdocs.org/ntsb/DCA17WA163.md): Boeing Boeing 737-330 · Frankfurt-Main, Germany · Incident · No injuries · Foreign investigation · Jul 28, 2017 · G-CELI · No damage
  > The BFU of Germany has notified the NTSB of an incident involving a Boeing 737-330 airplane that occurred on July 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB CEN17WA291](https://openairdocs.org/ntsb/CEN17WA291.md): Cessna 402 · British Virgin Islands, British Virgin Islands · Incident · No injuries · Foreign investigation · Jul 27, 2017 · N618CA · No damage
  > On July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…
- [NTSB ERA17WA294](https://openairdocs.org/ntsb/ERA17WA294.md): Raytheon Hawker · Mykonos, Greece · Accident · No injuries · Foreign investigation · Jul 26, 2017 · TC-MAN · Substantial damage
  > On July 26, 2017, at 0727 Universal Coordinated Time (UTC), a Raytheon Aircraft Company Hawker 850XP, Turkish registration TC-MAN, operated by Genel Havacilik AS, received substantial damage following an abnormal runway contact during landing at Mykonos…
- [NTSB ERA17RA260](https://openairdocs.org/ntsb/ERA17RA260.md): Britten Norman BN2A · Eteringbang, Guyana · Accident · 1 fatal · Foreign investigation · Jul 25, 2017 · 8R-GRA · Substantial damage
  > On July 25, 2017, about 2153 coordinated universal time, a Britten Norman BN2A-26, Guyana Registration 8R-GRA, operated by Roraima Airways Ltd., was substantially damaged when it impacted wooded terrain while on approach to Eteringbang Airstrip (SYET),…
- [NTSB DCA17WA156](https://openairdocs.org/ntsb/DCA17WA156.md): Boeing 737 · Bucharest, Romania · Incident · No injuries · Foreign investigation · Jul 25, 2017 · EI-DCR · No damage
  > The Civil Aviation Safety Investigation and Analysis Center (CASIAC) of Romania has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…
- [NTSB ERA17WA291](https://openairdocs.org/ntsb/ERA17WA291.md): Mitsubishi MU2B · San Fernando, Argentina · Accident · 3 fatal · Foreign investigation · Jul 24, 2017 · LV-MCV · Destroyed
  > The government of Argentina has notified the NTSB of an accident involving a MITSUBISHI MU2B airplane that occurred on July 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…
- [NTSB DCA17WA158](https://openairdocs.org/ntsb/DCA17WA158.md): Boeing Boeing 777-236 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jul 23, 2017 · G-YMMC · No damage
  > The United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 777-236 airplane that occurred on July 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation under the…
- [NTSB CEN17WA289](https://openairdocs.org/ntsb/CEN17WA289.md): Cessna U206 · Culiacan, Mexico · Accident · 7 fatal · Foreign investigation · Jul 23, 2017 · XB-MUM · Substantial damage
- [NTSB ERA17WA343](https://openairdocs.org/ntsb/ERA17WA343.md): Cessna 182 · Ivano-Frankivsk, Ukraine · Accident · Serious injuries · Foreign investigation · Jul 22, 2017 · UR-ORV · Substantial damage
  > On July 22, 2017, about 1305 coordinated universal time, a Cessna 182, Ukrainian registration UR-ORV, was substantially damaged during a forced landing near Ivano-Frankiivsk region, Ukraine. There were 5 people on board, of which 3 were seriously injured. The…
- [NTSB DCA17WA161](https://openairdocs.org/ntsb/DCA17WA161.md): Boeing 767 · Newcastle, United Kingdom · Incident · No injuries · Foreign investigation · Jul 22, 2017 · D-ABUK · Minor damage
  > The UK AAIB has notified the NTSB of an incident involving a Boeing767 airplane that occurred on July 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB DCA17WA157](https://openairdocs.org/ntsb/DCA17WA157.md): Boeing 737-86J · Belfast, United Kingdom · Incident · No injuries · Foreign investigation · Jul 21, 2017 · C-FWGH
  > The United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 737-86J airplane that occurred on July 21, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO…
- [NTSB ERA17WA259](https://openairdocs.org/ntsb/ERA17WA259.md): Cirrus Design SR20 · Santo Antonio do Leverger, Brazil · Accident · 2 fatal · Foreign investigation · Jul 20, 2017 · PR-PRF · Substantial damage
  > On 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 CEN17WA279](https://openairdocs.org/ntsb/CEN17WA279.md): Piper Piper J3C-65 · Laukaa, Finland · Accident · 1 fatal · Foreign investigation · Jul 19, 2017 · OH-PAD · Destroyed
  > On July 19, 2017, about 0903 coordinated universal time, a Piper J3C-65 airplane, Finnish registration OH-PAD, was destroyed when it collided with the trees and terrain near Laukaa, Finland. The pilot was fatally injured. The airplane departed a private…
- [NTSB DCA17WA160](https://openairdocs.org/ntsb/DCA17WA160.md): Boeing 737 · Wamena, Indonesia · Accident · No injuries · Foreign investigation · Jul 18, 2017 · PK-YGG · Minor damage
  > The KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 18, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions of…
- [NTSB DCA17WA159](https://openairdocs.org/ntsb/DCA17WA159.md): Boeing 747 422 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Jul 18, 2017 · N121UA · No damage
  > The BFU of Germany has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on July 18, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…
- [NTSB ERA17WA271](https://openairdocs.org/ntsb/ERA17WA271.md): Cessna 172 · Khuzhir, Russia · Accident · Serious injuries · Foreign investigation · Jul 16, 2017 · RA-2842G · Substantial damage
  > On July 16, 2017, at 1300 coordinated universal time, a Cessna 172M, Russian registration RA-2842G, ditched into Lake Baikal, near Khuzhir, Irkutskaya Oblast, Russia, after a total loss of engine power. The airplane incurred substantial damage during the…

Next page: https://openairdocs.org/ntsb.md?state=OF&page=76

## 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 c."eventCountry" <> 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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.