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

## Cases, newest first

- [NTSB DCA16WA213](https://openairdocs.org/ntsb/DCA16WA213.md): Boeing 737 · Makassar, Indonesia · Incident · No injuries · Foreign investigation · Jul 31, 2016 · PK-GMK · No damage
  > The National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 31, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation…
- [NTSB DCA16CA205](https://openairdocs.org/ntsb/DCA16CA205.md): Airbus A321 231 · Bermuda, Bermuda · Accident · Serious injuries · Data collection · Final report · Jul 28, 2016 · N913JB · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB CEN16WA298](https://openairdocs.org/ntsb/CEN16WA298.md): Hughes 369 · Senheim, Germany · Accident · Minor injuries · Foreign investigation · Jul 27, 2016 · D-HMIC · Substantial damage
  > On July 26, 2016, about 1407 hours coordinated universal time, a Hughes model 500E helicopter, German registration D-HMIC, sustained substantial damage during a hard landing following a loss of engine power near Senheim, Germany. The pilot received minor…
- [NTSB ERA16WA275](https://openairdocs.org/ntsb/ERA16WA275.md): Cessna TU206 · San Martin, Colombia · Accident · Serious injuries · Foreign investigation · Jul 23, 2016 · HK2787 · Substantial damage
  > On July 23, 2016, at 1910 coordinated universal time, a Cessna TU206G, Columbian registration HK2787, was substantially damaged following an in-flight loss of engine power and subsequent forced landing in the Municipality of San Martin, Colombia. The pilot…
- [NTSB WPR16RA151](https://openairdocs.org/ntsb/WPR16RA151.md): Cessna 208 · Shanghai, China · Accident · 5 fatal · Foreign investigation · Jul 20, 2016 · B-10FW · Substantial damage
  > On July 20, 2016 about 0422 Coordinated Universal Time, a float equipped Cessna 208, B10-FW, collided with a bridge shortly after takeoff from Jinshan City Beach, Shanghai, P.R. China. The airplane was operated by Avic Joy General Aviation under the pertinent…
- [NTSB ANC16WA044](https://openairdocs.org/ntsb/ANC16WA044.md): North American T28 · Cold Lake, Canada · Accident · 1 fatal · Foreign investigation · Jul 17, 2016 · C-GKKD · Destroyed
  > On July 17, 2016, about 1951 Coordinated Universal Time, a Canadian registered North American Aviation T-28B airplane, C-GKKD, owned and operated by a private individual, impacted terrain near Cold Lake, Alberta, Canada, while performing aerobatic maneuvers…
- [NTSB ERA16WA340](https://openairdocs.org/ntsb/ERA16WA340.md): Cessna 172 · Valday-avia, Russia · Accident · Minor injuries · Foreign investigation · Jul 16, 2016 · RA-67480 · Substantial damage
  > On July 16, 2016, about 1024 universal coordinated time, a Cessna 172K, Russian registration RA-67480, was substantially damaged when it experienced a runway excursion during takeoff from Valday-Avia Airfield, Valday, Novgorod, Russia. The pilot and two…
- [NTSB CEN16WA272](https://openairdocs.org/ntsb/CEN16WA272.md): Robinson R22 · Madrid, Spain · Accident · 2 fatal · Foreign investigation · Jul 16, 2016 · EC-IGG · Substantial damage
  > On July 16, 2016, about 1240 hours universal coordinated time, a Robinson R-22 Beta helicopter, Spain registration EC-IGG, was substantially damaged when it impacted the Valmayor Reservoir near Valdemorillo, Madrid, Spain. Witnesses reported that the…
- [NTSB ANC16WA045](https://openairdocs.org/ntsb/ANC16WA045.md): Dehavilland DHC-2 MK. I · Telegraph Creek, Canada · Accident · 1 fatal · Foreign investigation · Jul 16, 2016 · C-GWDW · Substantial damage
  > On July 15, 2016, about 0520 Coordinated Universal Time, a Canadian registered De Havilland DHC-2 Mk I airplane on floats, C-GWDW, owned and operated by Tsayta Aviation Ltd, impacted terrain approximately 15 nm east south east of Telegraph Creek, British…
- [NTSB CEN16WA279](https://openairdocs.org/ntsb/CEN16WA279.md): Rans S6 · Murcia, Spain · Accident · 1 fatal · Foreign investigation · Jul 15, 2016 · EC-YDQ · Substantial damage
  > On July 15, 2016, about 1910 coordinated universal time (UTC), a Rans S-6, EC-YDQ, sustained substantial damage when it impacted terrain after a loss of control while landing at the Los Garranchos Airport, Murcia, Spain. The pilot received fatal injuries. The…
- [NTSB CEN16WA268](https://openairdocs.org/ntsb/CEN16WA268.md): Piper PA-32R-301 · Ajdovscina, Slovenia · Accident · 4 fatal · Foreign investigation · Jul 14, 2016 · N710CC · Destroyed
  > The accident investigation is under the jurisdiction and control of the Republic of Slovenia. This report is for information purposes only and contains only information released by or obtained from the Republic of Slovenia. Further information pertaining to…
- [NTSB ANC16WA042](https://openairdocs.org/ntsb/ANC16WA042.md): Aero Commander B1A · Hoey, Canada · Accident · 1 fatal · Foreign investigation · Jul 14, 2016 · C-GSQY · Destroyed
  > On July 14, 2016, about 0230 Coordinated Universal Time, an Aero Commander B1A airplane, C-GSQY, lost engine power and impacted terrain after takeoff near Hoey, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…
- [NTSB WPR16WA143](https://openairdocs.org/ntsb/WPR16WA143.md): Cessna 150 · New Crown Station, Australia · Accident · 1 fatal · Foreign investigation · Jul 12, 2016 · VH-RXU · Substantial damage
  > On July 12, 2016 about 1130 local time, a Cessna 150G airplane, Australian registration VH-RXU, collided with terrain near New Crown Station, South Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was…
- [NTSB ENG16WA035](https://openairdocs.org/ntsb/ENG16WA035.md): Boeing 737 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Jul 12, 2016 · XA-UNY · Substantial damage
  > The DIRECCIÓN GENERAL DE AERONAUTICA CIVIL (DGCA) of Mexico has notified the NTSB of an incident involving a Magnicharter Boeing 737, which occurred on July 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA investigation…
- [NTSB ERA16WA262](https://openairdocs.org/ntsb/ERA16WA262.md): Cessna TU206 · Charrasquera, Colombia · Accident · 5 fatal · Foreign investigation · Jul 11, 2016 · HK2940 · Destroyed
  > On July 11, 2016, about 1507 coordinated universal time, a Cessna TU206G airplane, Colombian registration HK2940, was destroyed when it impacted dense jungle near Charrasquera-San Jose del Guaviare, Colombia. The Colombian certificated pilot and four…
- [NTSB ENG16RA030](https://openairdocs.org/ntsb/ENG16RA030.md): Airbus A320 · Narita, Japan · Incident · No injuries · Foreign investigation · Jul 9, 2016 · JA04JJ · No damage
  > The Japan Transport Safety Board has notified the NTSB of an incident involving an Airbus A320, which occurred on July 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Japan Transport Safety Board investigation under the…
- [NTSB ANC16WA043](https://openairdocs.org/ntsb/ANC16WA043.md): Air Tractor AT301 · Rocanville, Canada · Accident · 1 fatal · Foreign investigation · Jul 8, 2016 · C-GCYV · Substantial damage
  > On July 8, 2016, about 2359 Coordinated Universal Time, an Air Tractor AT-301 airplane, C-GCYV, impacted terrain while low-level maneuvering near Rocanville, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…
- [NTSB CEN16WA257](https://openairdocs.org/ntsb/CEN16WA257.md): Cirrus SR22 · Madrid, Spain, Spain · Accident · 2 fatal · Foreign investigation · Jul 5, 2016 · EC-KJO · Destroyed
  > On July 5, 2016, about 1940 coordinated universal time, a Cirrus SR22 single engine airplane, serial number 2558, registry EC-KJO, was destroyed after impacting terrain and obstructions while landing at Cuatro Vientos Airport at Madrid, Spain. The two…
- [NTSB ERA16WA256](https://openairdocs.org/ntsb/ERA16WA256.md): Cessna 182 · Belem, Brazil · Accident · 4 fatal · Foreign investigation · Jul 2, 2016 · PT-DJH · Destroyed
  > On July 2, 2016, about 1625 coordinated universal time (1325 local time), a Cessna 182E, Brazilian registration PT-DJH, operated by Aerotur Taxi Aereo LTDA, was destroyed after it impacted the ground shortly after takeoff from Julio Cesar Airport (SBJC),…
- [NTSB ERA16WA243](https://openairdocs.org/ntsb/ERA16WA243.md): Cessna A188 · Puerto Lopez, Colombia · Accident · 1 fatal · Foreign investigation · Jul 2, 2016 · HK1398 · Destroyed
  > On July 2, 2016, about 1810 coordinated universal time, a Cessna A188, Colombian registration HK1398, operated by Comercializadora de Aviacion Agricola - ECO, was destroyed when it collided with a utility tower near Puerto Lopez, Colombia. The certificated…
- [NTSB DCA16WA198](https://openairdocs.org/ntsb/DCA16WA198.md): Boeing Boeing 737-8AS · Charleroi, Belgium · Accident · Serious injuries · Foreign investigation · Jul 1, 2016 · EI-ENH · No damage
  > The Air Accident Investigation Unit of Belgium has notified the NTSB of an accident involving a Boeing 737 that occurred on July 01, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under the provisions of ICAO…
- [NTSB ANC16WA039](https://openairdocs.org/ntsb/ANC16WA039.md): Piper PA28 · Winnipeg, Canada · Accident · 2 fatal · Foreign investigation · Jul 1, 2016 · C-GNUC · Substantial damage
  > On July 1, 2016, at approximately 1445 Coordinated Universal Time, a Canadian registered Piper PA-28-140 airplane, C-GNUC, owned and operated by a private pilot, was destroyed when it collided with terrain shortly after takeoff from Winnipeg Lyncrest Airport…
- [NTSB ERA16WA240](https://openairdocs.org/ntsb/ERA16WA240.md): Bell Helicopter 407 · Jundiaí, Brazil · Accident · 5 fatal · Foreign investigation · Jun 26, 2016 · PR-CBB · Destroyed
  > On June 26, 2016, about 1110 coordinated universal time, a Bell 407, Brazilian registration PR-CBB, was destroyed during a collision with terrain and post-crash fire in Jundiaí, Brazil. The pilot and four passengers were fatally injured.The flight had…
- [NTSB DCA16WA191](https://openairdocs.org/ntsb/DCA16WA191.md): Airbus Industrie A330 323 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jun 26, 2016 · N276AY · No damage
  > Air Accident Investigation Branch (AAIB) notified the NTSB of a serious incident involving a AIRBUS INDUSTRIE A330 323 airplane that occurred on June 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…
- [NTSB DCA16RA190](https://openairdocs.org/ntsb/DCA16RA190.md): Boeing 777 · Singapore, Singapore · Accident · No injuries · Foreign investigation · Jun 26, 2016 · 9V-SWB · Substantial damage
  > The Air Accident Investigations Bureau (AAIB) of Singapore has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on June 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under…
- [NTSB CEN16RA233](https://openairdocs.org/ntsb/CEN16RA233.md): Bell 407 · Kassel, Hesse, Germany, Germany · Accident · No injuries · Foreign investigation · Jun 26, 2016 · D-HEAB · Substantial damage
  > On June 26, 2016, about 1420 hours universal coordinated time, a Bell model 407 helicopter, German registration D-HEAB, sustained substantial damage during a hard landing following a loss of engine power near Kassel, Hesse, Germany. The pilot was not injured.…
- [NTSB ERA16WA245](https://openairdocs.org/ntsb/ERA16WA245.md): Lake LA4 · Región de Los Lagos, Chile · Accident · 2 fatal · Foreign investigation · Jun 25, 2016 · CC-POK · Substantial damage
  > On June 25, 2016, about 2045 coordinated universal time (1645 local time), a Lake L-4-200, amphibious airplane, Chilean registration CC-POK, was substantially damaged when it collided with a powerline during a local flight over the Región de Los Lagos, Chile.…
- [NTSB ERA16WA232](https://openairdocs.org/ntsb/ERA16WA232.md): Cessna U206 · Fresh Creek, Bahamas · Accident · No injuries · Foreign investigation · Jun 25, 2016 · N9662G · Substantial damage
  > On June 25, 2016, about 2106 Universal Coordinated Time (UTC), a Cessna U206F, N9662G, operated by Chrimat Inc., was substantially damaged following a loss of engine power and forced landing at Fresh Creek, Bahamas. The pilot was not injured. The airplane…
- [NTSB CEN16WA262](https://openairdocs.org/ntsb/CEN16WA262.md): Liberty XL · La Lima, Honduras · Accident · 2 fatal · Foreign investigation · Jun 23, 2016 · HR-HZT · Destroyed
  > On June 23, 2016, about 2259 UTC, a Discovery Aviation, Incorporated, Liberty XL-2, Honduran registration HR-HZT, owned and operated by Horizontes Flight School was destroyed when it impacted the roof of a house in a residential neighborhood near La Lima,…
- [NTSB CEN16WA232](https://openairdocs.org/ntsb/CEN16WA232.md): Beech 65A90 · Hannover, Germany · Incident · No injuries · Foreign investigation · Jun 23, 2016 · OO-SAD · Minor damage
  > The Bundesstelle für Flugunfalluntersuchung (BFU) of Germany has notified the NTSB of an incident involving a Beech 65-A90-1 airplane, OO-SAD, that occurred on June 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU…
- [NTSB ERA16WA249](https://openairdocs.org/ntsb/ERA16WA249.md): Beech B200 · Lima, Peru · Incident · No injuries · Foreign investigation · Jun 21, 2016 · OB-2104-P · Minor damage
  > On June 21, 2016, about 1939 coordinated universal time (UTC), a Beech 200C, Peruvian registration OB-2104-P, operated by Aerolinea Del Caribe Peru, sustained minor damage during a runway excursion, after landing on Runway 15 with a malfunctioning landing…
- [NTSB ERA16WA219](https://openairdocs.org/ntsb/ERA16WA219.md): Piper PA 23-250 · South Bimini, Bahamas · Accident · 2 fatal · Foreign investigation · Jun 19, 2016 · N63ZZ · Destroyed
  > On June 19, 2016, about 2120 UTC, a Piper PA-23, N63ZZ was destroyed when it impacted terrain during a forced landing following a loss of engine power near South Bimini International Airport, South Bimini, Bahamas. Two occupants were fatally injured during…
- [NTSB DCA16WA189](https://openairdocs.org/ntsb/DCA16WA189.md): Boeing 737 · Launceston, Australia · Incident · No injuries · Foreign investigation · Jun 17, 2016 · VH-XMO · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 that occurred on June 17, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…
- [NTSB ANC16RA037](https://openairdocs.org/ntsb/ANC16RA037.md): Cirrus SR20 · Muan, South Korea · Accident · 3 fatal · Foreign investigation · Jun 17, 2016 · HL1210 · Destroyed
  > On June 17, 2016, about 1515 local time, a Cirrus SR20 airplane, Republic of Korea registration number HL1210, operated by the pilot, was destroyed following a loss of control while on approach to Muan International Airport, Republic of Korea. The flight…
- [NTSB ERA16WA221](https://openairdocs.org/ntsb/ERA16WA221.md): Gulfstream GULFSTREAM150 · Rionegro, Colombia · Incident · No injuries · Foreign investigation · Jun 16, 2016 · N963CH · Minor damage
  > On June 16, 2016, about 1603 Coordinated Universal Time (UTC), a Gulfstream Aerospace LP Gulfstream G150, N963CH, registered to Bank of Utah, and operated by a private individual, experienced a runway excursion during landing at the Jose Maria Cordova…
- [NTSB ENG16WA025](https://openairdocs.org/ntsb/ENG16WA025.md): BAE JETSTREAM3100 · Buenos Aires, Argentina, Argentina · Incident · No injuries · Foreign investigation · Jun 16, 2016 · LV-ZST
  > On June 16, 2016, a Jetstream BA-32, registration number LV-ZST, powered by Honeywell TPE331 turbo propeller engines experienced an engine fire during an engine test. The incident is being investigated by the Argentinian Junta de Investigacion de Accidentes…
- [NTSB CEN16WA226](https://openairdocs.org/ntsb/CEN16WA226.md): Zivko Aeronautics Edge 540 · Kyviškes, Lithuania · Accident · 1 fatal · Foreign investigation · Jun 16, 2016 · N13VU · Destroyed
- [NTSB ANC16WA033](https://openairdocs.org/ntsb/ANC16WA033.md): Piper PA28R · Green Lake, Canada · Accident · 1 fatal · Foreign investigation · Jun 16, 2016 · C-FYGG · Substantial damage
  > On June 16, 2016, about 1900 Coordinated Universal Time, a Piper PA28R-180 airplane, C-FYGG, struck trees and impacted terrain while attempting a go-around near Green Lake, British Columbia, Canada. The pilot sustained serious injuries and the passenger…
- [NTSB DCA16WA185](https://openairdocs.org/ntsb/DCA16WA185.md): Embraer ERJ190 · Madrid, Spain · Accident · Serious injuries · Foreign investigation · Jun 15, 2016 · EC-LKX · No damage
  > The Comision de Investigacion de Accidentes e Incidentes de Aviacion Civil (CIAIAC) Spain has notified the NTSB of an accident involving a EMBRAER ERJ190 airplane that occurred on June 15, 2016. The NTSB has appointed a U.S. Accredited Representative to…
- [NTSB CEN16WA327](https://openairdocs.org/ntsb/CEN16WA327.md): Robinson R44 · Manchester, United Kingdom · Incident · No injuries · Foreign investigation · Jun 13, 2016 · G-BZGO · Minor damage
  > On June 13, 2016, at 1547 coordinated universal time, a Robinson R44, G-BZGO, sustained a bird strike to the lower left windscreen about eight miles north of Manchester Barton Airport (EGCB), Manchester, England. The helicopter sustained minor damage. No…
- [NTSB ENG16WA038](https://openairdocs.org/ntsb/ENG16WA038.md): Boeing 737 · Toulouse, France, France · Incident · No injuries · Foreign investigation · Jun 8, 2016 · EI-CSG
  > The Accident Investigation Bureau of Mongolia (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on June 8, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…
- [NTSB WPR16WA162](https://openairdocs.org/ntsb/WPR16WA162.md): Hawker Beech 900 · Chennai, India, India · Accident · No injuries · Foreign investigation · Jun 7, 2016 · VT-LTA · Substantial damage
  > On June 7, 2016, at 2006 local time, a Hawker 900 XP, VT-LTA, was substantially damaged after a nose gear sheared off during the landing near Chennai, India. The aircraft was operated under the pertinent regulations of the Government of India. The 2…
- [NTSB DCA16RA175](https://openairdocs.org/ntsb/DCA16RA175.md): Mcdonnell Douglas MD11 · Incheon, South Korea · Accident · Minor injuries · Foreign investigation · Jun 6, 2016 · N277UP · Substantial damage
  > import
- [NTSB ERA16WA273](https://openairdocs.org/ntsb/ERA16WA273.md): BAE BAE125 · Yakutia, Russia · Accident · No injuries · Foreign investigation · Jun 5, 2016 · RA-02773 · Substantial damage
  > On June 5, 2016, about 1425 coordinated universal time (2325 local time), a British Aerospace (BAE) Hawker 125-800, Russian registration RA-02773, was substantially damaged when it impacted terrain while on approach to Neryungri Airport, Yakutia, Russia, and…
- [NTSB DCA16WA176](https://openairdocs.org/ntsb/DCA16WA176.md): Boeing 777 24Q · Paris, France · Incident · No injuries · Foreign investigation · Jun 5, 2016 · N777AS · Minor damage
  > The Bureau d'Enquetes et d'Analyses (BEA) has notified the NTSB of an accident involving a BOEING 777 24Q airplane that occurred on June 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under…
- [NTSB WPR16WA123](https://openairdocs.org/ntsb/WPR16WA123.md): Bell 206 · Siriwo, Indonesia · Accident · 1 fatal · Foreign investigation · Jun 4, 2016 · PK-UAF · Substantial damage
  > On June 4, 2016, about 0815 local time, a Bell 206 helicopter, registration PK-UAF, sustained substantial damage following collision with terrain near Siriwo, Indonesia. Reports indicate that there were 4 soles onboard the helicopter; 1 fatal, 3 serious. The…
- [NTSB ERA16WA335](https://openairdocs.org/ntsb/ERA16WA335.md): Piper PA34 · Yurimaguas, Peru · Incident · No injuries · Foreign investigation · Jun 4, 2016 · OB-1564 · Substantial damage
  > On June 4, 2016, at 1712 universal coordinated time, a Piper PA-34-200T, Peruvian registration OB-1564, was substantially damaged when the nose landing gear collapsed during landing at Moises Benzaquen Rengifo Airport (SPMS), Yurimaguas, Peru. The pilot and…
- [NTSB DCA16WA188](https://openairdocs.org/ntsb/DCA16WA188.md): Boeing 737 · Sofia, Bulgaria · Incident · No injuries · Foreign investigation · Jun 4, 2016 · TC-JGE · No damage
  > The Aircraft Accident Investigation Unit (AAIU) of Bulgaria has notified the NTSB of an incident involving a Boeing 737 that occurred on June 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…
- [NTSB ANC16WA030](https://openairdocs.org/ntsb/ANC16WA030.md): Wag-Aero Super Tri-Pacer · Williston Lake, Canada · Accident · 1 fatal · Foreign investigation · Jun 4, 2016 · CGSMJ · Substantial damage
  > On June 04, 2016, about 1500 Coordinated Universal Time, a Wag-Aero Super Tri-Pacer airplane, CGSMJ, impacted terrain near Williston Lake, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The…
- [NTSB CEN16WA237](https://openairdocs.org/ntsb/CEN16WA237.md): Vans RV6 · St-Mathieu-De-Beloeil, Canada · Accident · 1 fatal · Foreign investigation · Jun 2, 2016 · C-FTUO · Destroyed
  > On June 28, 2016, about 1350 Universal Coordinated Time (UTC), a Vans RV6, C-TFUO, impacted terrain at St-Mathieu-De-Beloeil (CSB3), Quebec, Canada. The pilot, the sole occupant on board, was fatally injured. The airplane was substantially destroyed. The…

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

## 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=82&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.