# NTSB investigations, 2011, 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 5 · 238 cases

## Latest cases

- [NTSB ERA12WA133](https://openairdocs.org/ntsb/ERA12WA133.md): Piper PA28 · Andres Bello,Tachira, Venezuela · Accident · 2 fatal · Foreign investigation · Dec 29, 2011 · HK3934 · Substantial damage
  > On December 29, 2011, about 1415 universal coordinated time, a Piper PA28-161, Columbian registration HK3934, was substantially damaged when it impacted terrain while in cruise flight near Andres Bello, Tachira, Venezuela. The two pilots were fatally injured.…
- [NTSB DCA12WA022](https://openairdocs.org/ntsb/DCA12WA022.md): Boeing 737 · Yogyakarta, Indonesia · Accident · No injuries · Foreign investigation · Dec 20, 2011 · PK-CKM · Substantial damage
  > The Komite Nasional Keselamatan Transportasi of Indonesia (KNKT) has notified the NTSB of an incident involving a Boeing 737 that occurred on December 20, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…
- [NTSB DCA12CA023](https://openairdocs.org/ntsb/DCA12CA023.md): University Of Kansas Meridian · McMurdo, AY · Accident · No injuries · Data collection · Final report · Dec 19, 2011 · UNREG · Substantial damage
  > an aerodynamic stall induced by an inadvertent autopilot Home command. The Home command was entered following a loss of the direct radio link due to improperly set failsafe settings, and an unintentional latching of Home mode from an earlier functionality…
- [NTSB CEN12WA105](https://openairdocs.org/ntsb/CEN12WA105.md): Cessna 177A · Ottawa, Canada · Accident · 2 fatal · Foreign investigation · Dec 15, 2011 · C-FEFQ · Substantial damage
  > On December 14, 2011, at 1920 eastern standard time, a Cessna model 177A, Canadian registration C-FEFQ, collided with terrain 2 nautical miles west of Ottawa Macdonald-Cartier International Airport (CYOW), Ottawa, Canada. The flight had been cleared for the…
- [NTSB DCA13WA052](https://openairdocs.org/ntsb/DCA13WA052.md): Beech 1900 · Goose Bay, Canada · Incident · No injuries · Foreign investigation · Dec 10, 2011 · C-GLHO · No damage
  > On 10 December 2011, at 1028 Newfoundland Standard Time, an Exploits Valley Air Services Hawker Beechcraft 1900D aircraft (registration C-GLHO, serial number UE-266), operating as Air Canada Express flight EV7645, was conducting a scheduled passenger flight…
- [NTSB ERA12WA113](https://openairdocs.org/ntsb/ERA12WA113.md): Robinson R44 · Sao Bento do Sul, Brazil · Accident · 1 fatal · Foreign investigation · Dec 9, 2011 · PR-KLA · Substantial damage
  > On December 9, 2011 at 1630 universal coordinated time, a Robinson R44, Brazilian registration PR-KLA, operated by SASH Locacao de Veiculos LTDA, as a personal flight, impacted terrain in the vicinity of Fazenda Coqueiros, Sao Bento do Sul, Santa Catarina,…
- [NTSB WPR12WA063](https://openairdocs.org/ntsb/WPR12WA063.md): Cessna 210 · Roma, Australia, Australia · Accident · 1 fatal · Foreign investigation · Dec 7, 2011 · VH-WBZ · Substantial damage
  > On December 7, 2011, at 0530 universal coordinated time, a Cessna 210M, VH-WBZ, collided with terrain near Roma, Australia. The airplane was substantially damaged and the pilot, the sole occupant, was fatally injured. The flight was operated under the…
- [NTSB ERA12WA104](https://openairdocs.org/ntsb/ERA12WA104.md): Piper PA28 · Bogota, Colombia · Accident · No injuries · Foreign investigation · Dec 6, 2011 · HK2308 · Substantial damage
  > On December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…
- [NTSB DCA12WA018](https://openairdocs.org/ntsb/DCA12WA018.md): Boeing 737 · Seoul, South Korea · Incident · No injuries · Foreign investigation · Dec 4, 2011 · HL-7796 · Minor damage
  > The Korean Aviationand Railway Accident Investigation Board (ARAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on December 4, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB investigation under…
- [NTSB DCA12WA030](https://openairdocs.org/ntsb/DCA12WA030.md): Boeing 777 · Maldives, Maldives · Incident · No injuries · Foreign investigation · Dec 2, 2011 · A6-EMR · Minor damage
  > The UAE General Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Boeing 777 that occurred on December 2, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of…
- [NTSB ERA12WA103](https://openairdocs.org/ntsb/ERA12WA103.md): Cessna TU206 · Cerro Escalera, Peru · Accident · 4 fatal · Foreign investigation · Dec 1, 2011 · OB-1299 · Substantial damage
  > On December 1, 2011, about 2048 UTC, a Cessna TU206G, Peruvian registration OB-1299, registered to and operated by Palmas del Espino S.A., collided with mountainous terrain near Cerro Escalera, Peru. Weather conditions at the altitude, location, and time of…
- [NTSB ERA12WA105](https://openairdocs.org/ntsb/ERA12WA105.md): Cirrus SR20 · Minas Gerias, Brazil · Accident · 2 fatal · Foreign investigation · Nov 26, 2011 · PR-LJL · Substantial damage
  > On November 26, 2011, about 1300 universal coordinated time, a Cirrus SR20, Brazilian registration PR-LJL, operated by a private individual, was substantially damaged when it impacted terrain in Carmo do Cajuri Municipality, Minas Gerais, Brazil. The pilot…
- [NTSB DCA12WA019](https://openairdocs.org/ntsb/DCA12WA019.md): Gulfstream American G 1159 · Huambo, Angola · Accident · No injuries · Foreign investigation · Nov 26, 2011 · N811DE · Substantial damage
  > On November 26, 2011, about 1300 UTC, N811DE, a Grumman G-1159 Gulfstream G-II, a private flight operated by Wings Over Africa, was involved in a runway excursion following a rejected takeoff. None of the 10 persons aboard were injured. The aircraft was…
- [NTSB ERA12WA086](https://openairdocs.org/ntsb/ERA12WA086.md): Bell 212 · Quito, Ecuador · Accident · Serious injuries · Foreign investigation · Nov 25, 2011 · HC-CLH · Substantial damage
  > On November 25, 2011, about 1640 coordinated universal time (1140 local time), a Bell 212, Ecuadorian registration HC-CLH, operated by Aeromaster Airways, S.A., was substantially damaged when it impacted steep terrain next to the company's helipad in Quito,…
- [NTSB ERA12LA085](https://openairdocs.org/ntsb/ERA12LA085.md): Piper PA 46-350P · Caribbean Sea, A1 · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 2011 · N534P · Substantial damage
  > The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…
- [NTSB ERA12WA136](https://openairdocs.org/ntsb/ERA12WA136.md): Piper PA36 · Machala, Ecuador · Accident · No injuries · Foreign investigation · Nov 23, 2011 · HCBHJ · Substantial damage
  > On November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…
- [NTSB ERA12WA091](https://openairdocs.org/ntsb/ERA12WA091.md): Piper PA23 · Quibdo, Colombia · Incident · No injuries · Foreign investigation · Nov 23, 2011 · HK1263 · Minor damage
  > On November 23, 2011, about 1717 UTC, a Piper PA-23-250, Colombian registration HK1263, operated by Aerolineas Alas de Colombia LTDA, experienced collapse of the left main landing gear during the landing roll at the El Carano Airport (SKUI), Quibdo, Colombia.…
- [NTSB ERA12WA102](https://openairdocs.org/ntsb/ERA12WA102.md): Cessna 210 · Alto Alegre, Brazil · Accident · 1 fatal · Foreign investigation · Nov 22, 2011 · PT-IOT · Substantial damage
  > On November 22, 2011, at 1740 universal time coordinated, a Cessna Aircraft, Model 210L, Brazilian registration PT-IOT, impacted the ground after reporting an engine failure near Aldeia Hali Katu, in the Alto Alegre Municipality, Roraima, Brazil. The airplane…
- [NTSB ERA12WA089](https://openairdocs.org/ntsb/ERA12WA089.md): Piper PA-28-236 · Mercedes, Argentina · Accident · 2 fatal · Foreign investigation · Nov 21, 2011 · PG-449 · 2 aircraft · Minor damage
  > On November 21, 2011, about 1320 coordinated universal time, a Piper PA-28-236, Argentine Air Force designation PF-449, and a Cessna 152, Argentine registration LV-OOF, collided while on approach to Mercedes Airfield (MRD), Mercedes, Buenos Aires Province,…
- [NTSB OPS12WA150](https://openairdocs.org/ntsb/OPS12WA150.md): Embraer EMB-145LR · Toronto, Canada · Incident · No injuries · Foreign investigation · Nov 18, 2011 · N620AE · No damage
  > On November 18, 2011, American Eagle (EGF) flight 4125, an EMB-145, landed on runway 24L at Toronto Lester B. Pearson International Airport (CYYZ) and exited the runway at taxiway D4 with instructions to hold short of runway 24R. EGF4125 subsequently crossed…
- [NTSB ERA12WA073](https://openairdocs.org/ntsb/ERA12WA073.md): Cessna 150 · Santa Rosa, Ecuador · Accident · 2 fatal · Foreign investigation · Nov 14, 2011 · HC-BJA · Substantial damage
  > On November 14, 2011, about 2020 coordinated universal time (1520 local time), a Cessna 150M, Ecuadorian registration HC-BJA, was substantially damaged when it impacted rising terrain in the Girón Alto mountains near Santa Rosa, Ecuador. The Ecuadorian pilot…
- [NTSB ERA12WA072](https://openairdocs.org/ntsb/ERA12WA072.md): Cessna 210 · Cayman Brac, Cayman Islands · Accident · 2 fatal · Foreign investigation · Nov 14, 2011 · XB-LLD · Substantial damage
  > On November 14, 2011, at 0525 universal coordinated time, a Cessna 210, registered in Mexico as XB-LLD, was substantially damaged when it struck wires and trees under unknown circumstances at Cayman Brac, Cayman Islands. The pilot and his passenger were…
- [NTSB CEN12WA069](https://openairdocs.org/ntsb/CEN12WA069.md): Cirrus Design SR22 · Gleisweiler, Germany · Accident · 2 fatal · Foreign investigation · Nov 14, 2011 · N956CD · Substantial damage
- [NTSB CEN12WA068](https://openairdocs.org/ntsb/CEN12WA068.md): Cirrus SR22 · Katowice, Poland · Accident · 4 fatal · Foreign investigation · Nov 13, 2011 · SP-IKP · Substantial damage
  > On November 13, 2011, about 1821 UTC, SP-IKP, a Polish registered Cirrus SR22 airplane, operated by a private pilot, sustained substantial damage when the airplane impacted trees and terrain near the Katowice-Pyrzowice airport, near Katowice, Poland. The…
- [NTSB ERA12WA099](https://openairdocs.org/ntsb/ERA12WA099.md): Cessna 210 · Cuiaba, Brazil · Accident · 4 fatal · Foreign investigation · Nov 12, 2011 · PT-VMG · Substantial damage
  > On November 12, 2011, about 2000 universal coordinated time, a Cessna 210N, Brazilian registration PT-VMG, was substantially damaged when it impacted terrain shortly after takeoff in Cuiaba Municipality, State of Mato Grosso, Brazil. The Brazilian…
- [NTSB CEN12WA067](https://openairdocs.org/ntsb/CEN12WA067.md): Piper PA28 · Alderney, United Kingdom · Accident · 1 fatal · Foreign investigation · Nov 12, 2011 · G-BXRG · Substantial damage
  > On November 12, 2011, about 1540 universal coordinated time (UTC), G-BXRG, a United Kingdom registered Piper PA-28-181, owned by Alderney Flying Training LTD, sustained presumed substantial damage when the airplane ditched and sunk in the English Channel…
- [NTSB CEN12WA063](https://openairdocs.org/ntsb/CEN12WA063.md): Hughes 500 · Andratx, Spain · Accident · 2 fatal · Foreign investigation · Nov 12, 2011 · G-WOOW · Substantial damage
  > On November 12, 2011, approximately 1020 coordinated universal time, a Hughes 500E, British registration G-WOOW, impacted terrain under unknown circumstances near Andratx, Mallorca, Spain. The pilot and passenger were both fatally injured. A post crash fire…
- [NTSB ERA12WA092](https://openairdocs.org/ntsb/ERA12WA092.md): Piper PA-25 · Meteropolitana, Chile · Accident · No injuries · Foreign investigation · Nov 11, 2011 · CC-ABM · Substantial damage
  > On November 11, 2011, at 1345 UTC, a Piper PA-25-260, Chilean registration CC-ABM, registered to and operated by Sociedad De Ttrabajos Aeros Aeropacifico LTDA as a personal flight experienced a partial loss of engine power on initial takeoff climb, in the…
- [NTSB DCA12RA012](https://openairdocs.org/ntsb/DCA12RA012.md): Eurocopter AS332L · Mexico City, Mexico · Accident · 8 fatal · Foreign investigation · Nov 11, 2011 · XC-UHM · Substantial damage
  > On November 11, 2011, a Eurocopter AS 332L Super Puma, registration XC-UHM, operated by Fuerza Aerea Mexicana (Presidential Use), crashed in a rural area south of Mexico City, enroute from Camp Marte, Mexico to Cuernavaca, Mexico. The eight passengers and…
- [NTSB CEN12WA223](https://openairdocs.org/ntsb/CEN12WA223.md): Piper PA-31 · Cottens, Switzerland · Accident · 1 fatal · Foreign investigation · Nov 10, 2011 · HB-LOT · Destroyed
  > The accident investigation is under the jurisdiction and control of the Swiss government. This report is for informational purposes only and contains only information released by or obtained from the Swiss government or the Swiss Accident Investigation Board.…
- [NTSB CEN12WA092](https://openairdocs.org/ntsb/CEN12WA092.md): Socata TBM 700 · Lyon, France · Accident · 1 fatal · Foreign investigation · Nov 9, 2011 · N228CX · Substantial damage
- [NTSB ERA12WA067](https://openairdocs.org/ntsb/ERA12WA067.md): Cessna 402 · Quibdo, Colombia · Incident · No injuries · Foreign investigation · Nov 4, 2011 · HK4417 · Minor damage
  > On November 4, 2011, about 1640 UTC, a Cessna 402C, Colombian registration HK4417, registered to and operated by AeroEjecutivos De Antioquia S.A. experienced collapse of the left main landing gear during the takeoff roll from El Carano Airport (SKUI), Quibdo,…
- [NTSB DCA12WA011](https://openairdocs.org/ntsb/DCA12WA011.md): Boeing 777 · Munich, Germany · Incident · No injuries · Foreign investigation · Nov 3, 2011 · 9V-SWQ · Minor damage
  > On November 3, 2011, at about 1210 local time (1110 UTC), a Boeing 777-300, 9V-SWQ, experienced a runway excursion upon landing on runway 08R at Franz Joseph Strauss Munich Airport (EDDM), Munich, Germany. None of the 143 passengers or 15 crewmembers were…
- [NTSB CEN12RA052](https://openairdocs.org/ntsb/CEN12RA052.md): Bell 206L · Kapuskasing, Canada · Accident · 3 fatal · Class 5 · Foreign · Nov 2, 2011 · C-GDQH · Substantial damage
  > On November 2, 2011, about 0958 eastern daylight time (EDT), a Bell 206L helicopter, Canadian registration C-GDQH, was substantially damaged during an in-flight collision with terrain in Kapuskasing, Ontario, Canada. The pilot and 2 passengers sustained fatal…
- [NTSB DCA12WA009](https://openairdocs.org/ntsb/DCA12WA009.md): Boeing 767 · Warsaw, Poland · Accident · No injuries · Foreign investigation · Nov 1, 2011 · SP-LPC · Substantial damage
  > On November 1, 2011, LOT Polskie Linie Lotnicze flight 16, a Boeing 767, registration SP-LPC, conducted an emergency gear up landing on runway 33 at Warszawa-Frédéric Chopin Airport (EPWA), Warsaw, Poland. There were no injuries to the passengers and…
- [NTSB DCA12WA010](https://openairdocs.org/ntsb/DCA12WA010.md): Boeing 777 - 200 · Nani, Kenya · Accident · No injuries · Foreign investigation · Oct 28, 2011 · A7-BBD · No damage
  > On October 28, 2011 about 1544 hours UTC, a Boeing 777-200LR, registration number A7-BBD, operated by Qatar Airways, encountered inflight turbulence, during cruise flight near Nani, Kenya. A cabin crew member received serious injuries. The flight originated…
- [NTSB CEN12WA046](https://openairdocs.org/ntsb/CEN12WA046.md): Piper PA-31T · Toulouse, France · Accident · 3 fatal · Foreign investigation · Oct 28, 2011 · OE-FKG · Substantial damage
  > Under the jurisdiction and control of the French government.
- [NTSB ANC12WA007](https://openairdocs.org/ntsb/ANC12WA007.md): Vancouver, Canada · Accident · No injuries · Foreign investigation · Oct 27, 2011 · Substantial damage
  > On October 27, 2011, about 1600 pacific daylight time, a Beechcraft King Air 100, C-GXRX, operated by Northern Thunderbird Air, Inc. as a non-scheduled passenger flight, collided with terrain while attempting to land at the Vancouver International Airport,…
- [NTSB DCA12WA007](https://openairdocs.org/ntsb/DCA12WA007.md): Boeing 737 - 800 · Faro, Portugal · Accident · No injuries · Foreign investigation · Oct 24, 2011 · EI-DPA · Substantial damage
  > TheAir AccidentInvestigation Unit (AAIU) ofIrelandhas notified the NTSB of an accidentinvolving a B737-8AS that occurred on October 20, 2011. The NTSBhas appointed a U.S. Accredited Representative to assist the AAIU investigationunder the provisions of ICAO…
- [NTSB CEN12WA040](https://openairdocs.org/ntsb/CEN12WA040.md): Cessna 210G · Veracruz, Mexico · Accident · 2 fatal · Foreign investigation · Oct 23, 2011 · N5894F · Substantial damage
- [NTSB WPR12WA186](https://openairdocs.org/ntsb/WPR12WA186.md): Piper PA-34-220T · Karachi, Pakistan · Accident · No injuries · Foreign investigation · Oct 20, 2011 · AP_BDK · Substantial damage
  > On October 20, 2011, at 1138 local time, a Piper PA-34-220T, Pakistan registry AP-BDK, was substantially damaged during a forced landing following a dual engine failure while in cruise flight. The aircraft was operated by M/S Schon Air Limited of Karachi,…
- [NTSB DCA12WA005](https://openairdocs.org/ntsb/DCA12WA005.md): Boeing 777 · Putong, China · Accident · Serious injuries · Foreign investigation · Oct 17, 2011 · 9V-SYH · No damage
  > On October 17, 2011, a Singapore Airlines B777-300, Singapore registration 9V-SYH, operating as a passenger flight between Shanghai, China and Singapore, encountered turbulence while in cruise flight about 10nm east of waypoint KARAN. One passenger was…
- [NTSB DCA12WA006](https://openairdocs.org/ntsb/DCA12WA006.md): Bangkok, Thailand · Incident · No injuries · Foreign investigation · Oct 16, 2011 · No damage
  > On October 16, 2011, a Qantas Airlines B747-400, Australian registration VH-OJS, experienced abnormal exhaust temperatures and vibrations in the number 3 engine while climbing. The engine was shutdown and the flight returned to Bangkok. There were no…
- [NTSB ERA12WA041](https://openairdocs.org/ntsb/ERA12WA041.md): Bell 412 · Santa Rosa, Venezuela · Accident · Serious injuries · Foreign investigation · Oct 15, 2011 · YVO126 · Substantial damage
  > On October 15, 2011, at 1933 UTC, a Bell 412SP, YV0126, registered to and operated by Electrificacion del Caroni (EDELCA), as a business flight, collided with trees while on approach to Macagua Airport, Santa Rosa, Venezuela. The Venezuelan Government…
- [NTSB ENG12WA002](https://openairdocs.org/ntsb/ENG12WA002.md): De Havilland DHC8 · Madang, Papua New Guinea, Papua New Guinea · Accident · 28 fatal · Foreign investigation · Oct 14, 2011 · P2-MCJ · Destroyed
  > On 13 Oct 2011, at about 1715, at about 10,000 feet during the descent for landing, the overspeed warning horn of a PNG Airlines DHC-8-102 aircraft, Papua New Guinea registration P2-MCJ sounded. At 1717, the crew made a MAYDAY call to ATC, indicating that…
- [NTSB DCA12RA003](https://openairdocs.org/ntsb/DCA12RA003.md): Cessna 208B · Xakanaka, Botswana · Accident · 9 fatal · Foreign investigation · Oct 14, 2011 · A2-AKD · Substantial damage
  > On October 14, 2011, about 1350 local time, A2-AKD, a Cessna 208B chartered flight, crashed shortly after takeoff from an airstrip near Xakanaka, Botswana. Visual meteorological conditions prevailed. Of the 12 persons on board, the pilot and 8 passengers were…
- [NTSB CEN12WA686](https://openairdocs.org/ntsb/CEN12WA686.md): Piper PA-28-140 · Petit-Beauregard, Switzerland · Accident · 2 fatal · Foreign investigation · Oct 14, 2011 · G-BBEF · Destroyed
  > On October 14, 2011, at 0857 universal coordinated time, a Piper PA-28-140 airplane, G-BBEF, impacted terrain near Petit-Beauregard, Fontaines-sur-Grandson, Switzerland. The pilot and passenger were both fatally injured. The airplane was destroyed. The…
- [NTSB CEN12WA033](https://openairdocs.org/ntsb/CEN12WA033.md): Diamond DA20 · Amurrio, Spain · Accident · 2 fatal · Foreign investigation · Oct 14, 2011 · EC-KDS · Substantial damage
  > On October 14, 2011, at 1040 universal coordinated time, a Diamond DA20-C1 airplane, EC-KDS, sustained substantial damage when it impacted terrain near Amurrio, Spain. The two crewmembers sustained fatal injuries. The accident investigation is under the…
- [NTSB DCA12WA002](https://openairdocs.org/ntsb/DCA12WA002.md): Boeing 767 · Kansai, Japan · Incident · No injuries · Foreign investigation · Oct 12, 2011 · N588HA · 2 aircraft · No damage
  > On October 12, 2011, at Kansai International Airport, a Boeing 767-300, registered N588HA, operated by Hawaiian Airlines Inc. (HAL450), received ATC instruction to hold short of runway A. The Hawaiian Airlines airplane entered into the runway at about 21:37.…
- [NTSB ENG12RA028](https://openairdocs.org/ntsb/ENG12RA028.md): Boeing 737 · Antalya, Türkiye · Incident · No injuries · Foreign investigation · Oct 10, 2011 · TC-SKF · Minor damage
  > On October 10, 2011, a Sky Airlines B737-400 (TC-SKF), S/N 26291 flight ZY 8756 from BADEN (EDSB) to Antalya (LTAI) experience a right landing gear collapse during the landing sequence at Runway 18C. The landing gear tire deflated and A/C collapsed on the…

Next page: https://openairdocs.org/ntsb.md?year=2011&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") = 2011
  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=2011

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