# NTSB investigations, 2010, 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 · 227 cases

## Latest cases

- [NTSB ENG11WA017](https://openairdocs.org/ntsb/ENG11WA017.md): Airbus A320 · Changchun, China, China · Incident · No injuries · Foreign investigation · Dec 29, 2010 · B-2221 · No damage
  > On December 29, 2010, a China Eastern Airlines Airbus A320-214, powered by two CFM56-5B4/P turbofan engines experienced a No. 2 engine (right) engine failure during the initial takeoff roll from Changchum Airport, Changchum, China. During initial take-off run…
- [NTSB CEN11RA149](https://openairdocs.org/ntsb/CEN11RA149.md): Mcdonnell Douglas 600 · Jena-Isserstedt, Germany · Accident · Serious injuries · Foreign investigation · Dec 28, 2010 · D-HHWR · Destroyed
  > On December 28, 2010, at 1420 UTC, a MD-Helicopters MD600N, German registration D-HHWR, lost engine power and subsequently impacted terrain near Jena-Isserstedt, Thuringen, German. The pilot and second pilot on board the helicopter sustained serious injuries.…
- [NTSB ERA11WA098](https://openairdocs.org/ntsb/ERA11WA098.md): Bell 206 · Aracuju, Brazil · Accident · 1 fatal · Foreign investigation · Dec 21, 2010 · PR-HQB · Substantial damage
  > On December 21, 2010, about 1300 universal coordinated time, a Bell 206B, Brazilian registration PR-HQB, during an approach for landing; encountered a strong wind gust, impacted the terrain, and was substantially damaged in Aracaju, Segripe, Brazil. The pilot…
- [NTSB CEN11WA145](https://openairdocs.org/ntsb/CEN11WA145.md): Bell UH1B · Bataan, Costa Rica · Accident · No injuries · Foreign investigation · Dec 21, 2010 · TI-AZM · Substantial damage
  > On December 21, 2010, about 0350 coordinated universal time (UTC), a Bell UH-1B helicopter, TI-AZM, impacted terrain following a loss of engine power, in a remote area, near Bataan, Costa Rica. The accident investigation is under the jurisdiction and control…
- [NTSB CEN11WA119](https://openairdocs.org/ntsb/CEN11WA119.md): Raytheon 390 · Bever, Switzerland · Accident · 2 fatal · Foreign investigation · Dec 19, 2010 · D-IAYL · Destroyed
  > On December 19, 2010, 1402 coordinated universal time, a German registered Raytheon 390 Premier I, D-IAYL, was destroyed upon impact with terrain while maneuvering near Bever, Switzerland. The two pilots were fatally injured. The airplane departed Zagreb…
- [NTSB ERA11WA090](https://openairdocs.org/ntsb/ERA11WA090.md): Hawker Beechcraft TC-45J · Nassau, Bahamas · Accident · 2 fatal · Foreign investigation · Dec 14, 2010 · N38L · Destroyed
  > On December 14, 2010, about 1442 eastern standard time, a Hawker Beechcraft TC-45J, N38L, registered to and operated by Monarch Air Group, impacted ocean waters about 7 miles southwest of Lynden Pindling International Airport (MYNN), Nassau, Bahamas. The…
- [NTSB DCA11WA018](https://openairdocs.org/ntsb/DCA11WA018.md): Boeing 737 · Rio De Janiero, Brazil · Incident · No injuries · Foreign investigation · Dec 13, 2010 · PR-WJO · No damage
  > The aircraft stopped to climb to cruising level at level 330, because the pilots realized that the pressurization system was not working properly. The "CABIN RATE OF CLIMB" was indicating +500ft/min, the "ALT CABIN INDEX" 8.0, and the differential pressure…
- [NTSB DCA11WA067](https://openairdocs.org/ntsb/DCA11WA067.md): Boeing 747 · Medina, Saudi Arabia · Incident · No injuries · Foreign investigation · Dec 12, 2010 · HZ-AWA1 · Minor damage
  > On December 12, 2010, a Boeing 747-400, Saudi registration HZ-AWA1, serial number 27672, operated by Alwafeer Air as flight 1336, exited the left side of the runway after landing at Prince Mohammed Airport, Medina, Saudi Arabia. Two of the right hand main…
- [NTSB CEN11WA269](https://openairdocs.org/ntsb/CEN11WA269.md): Eurocopter AS-350-B2 · Pickle Lake, Ontario, Canada · Accident · No injuries · Foreign investigation · Dec 10, 2010 · C-FORS · Substantial damage
  > On December 10, 2010, about 0900 eastern standard time, a Canadian registered Eurocopter AS-350-B2, C-FORS, operated by Forest Helicopters, sustained substantial damage during an autorotation landing after a loss of engine power during takeoff near Pickle…
- [NTSB ERA11WA089](https://openairdocs.org/ntsb/ERA11WA089.md): Beech 95-B55 · Bom Jesus do Galho City, Brazil · Accident · 4 fatal · Foreign investigation · Dec 9, 2010 · PT-LEU · Destroyed
  > On December 9, 2010, about 2135 universal coordinated time, a Hawker Beech Aircraft 95-B55, Brazilian registration PT-LEU, experienced an engine failure, impacted the terrain, and was destroyed by a post crash fire in Bom Jesus do Galho City, Minas Gerais,…
- [NTSB CEN11WA107](https://openairdocs.org/ntsb/CEN11WA107.md): Cessna 750 · Finningley, United Kingdom · Accident · No injuries · Foreign investigation · Dec 9, 2010 · G-CDCX · Substantial damage
  > On December 9, 2010, at 1022 hours universal coordinated time, a Cessna 750, G-CDCX, sustained substantial damage when the right main landing gear collapsed during landing at Robin Hood Doncaster Sheffield Airport (EGCN), Finningley, South Yorkshire, United…
- [NTSB CEN11WA105](https://openairdocs.org/ntsb/CEN11WA105.md): Robinson R22 · Tourrettes-sur-Loup, France · Accident · 2 fatal · Foreign investigation · Dec 9, 2010 · G-CBVL · Destroyed
  > On December 9, 2010, at 0755 coordinated universal time, a Robinson R22, United Kingdom registered G-CBVL, operated by Spiral Wing, Ltd., was destroyed when it impacted mountainous terrain under unknown circumstances near Tourrettes-sur-Loup, France. Visual…
- [NTSB ERA11WA088](https://openairdocs.org/ntsb/ERA11WA088.md): Piper PA-32R-301T · Roma, Italy · Accident · 1 fatal · Foreign investigation · Dec 8, 2010 · N58SE · Destroyed
  > On December 8, 2010, at 1443 UTC, a Piper PA-32R-301T, N58SE, registered to Aircraft Guaranty Title Corporation Trustee,collided with a bus depot after departing runway 34 from Roma Urbe Airport (LIRU), Roma, Italy. The airplane had been recently purchased by…
- [NTSB DCA11WA017](https://openairdocs.org/ntsb/DCA11WA017.md): Boeing B737 · Brasilia, Brazil · Incident · No injuries · Foreign investigation · Dec 8, 2010 · PR-WJU · No damage
  > The Brazilian Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 737 that occurred on December 8, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU…
- [NTSB ENG11WA006](https://openairdocs.org/ntsb/ENG11WA006.md): Boeing 777 · Lisbon, Portugal, Portugal · Incident · No injuries · Foreign investigation · Dec 6, 2010 · D2-TEF · No damage
  > On December 6, 2010, at 11:15 local time, an Angola Airlines (TAAG)Boeing 777-2M2ER, powered by two General Electric GE90-94B Turbofan engines experienced a No. 2 (right) engine low pressure turbine failure after takeoff from the Lisbon International Airport…
- [NTSB WPR11LA071](https://openairdocs.org/ntsb/WPR11LA071.md): Boeing 767 · Pago Pago, Antarctica · Accident · Serious injuries · Limited investigation · Final report · Dec 3, 2010 · N584HA · No damage
  > The airplane’s encounter with convectively-induced turbulence, which resulted in serious injury to one flight attendant.
- [NTSB DCA11WA013](https://openairdocs.org/ntsb/DCA11WA013.md): Beech 1900 · Maputo, Mozambique · Accident · No injuries · Foreign investigation · Dec 3, 2010 · Destroyed
  > On December 3, 2010, about 2040 UTC, a Beech 1900C, C9-AUO, operated by Kaya Airlines, crashed into terrain during landing approach at Maputo International Airport, Maputo, Mozambique. Instrument meteorological conditions prevailed at the time. Of the 17…
- [NTSB DCA11WA010](https://openairdocs.org/ntsb/DCA11WA010.md): Boeing 737-823 · Montreal, Canada · Incident · No injuries · Foreign investigation · Dec 1, 2010 · N901AN · Minor damage
  > On November 30, 2010, American Airlines flight AAL802, a Boeing 737-800, N901AN, departed the left side of runway 24R and stopped in the grass approximately 6600 feet down the runway while completing its landing roll at Montreal Pierre Elliott Trudeau…
- [NTSB CEN11WA094](https://openairdocs.org/ntsb/CEN11WA094.md): Cessna F150 · Linköping, Sweden · Accident · 1 fatal · Foreign investigation · Dec 1, 2010 · SE-IGU · Substantial damage
  > On December 1, 2010, at 1711 coordinate universal time, a Cessna F150H, SE-IGU, was substantially damaged upon impact with terrain after initial takeoff from the Linköping Airport (ESSL), Linköping, Sweden. The pilot was fatally injured. The airplane was…
- [NTSB ENG11WA005](https://openairdocs.org/ntsb/ENG11WA005.md): Boeing 747 · Chubu, Japan, Japan · Incident · No injuries · Foreign investigation · Nov 28, 2010 · N482EV · No damage
  > On November 28, 2010, at about 06:00 Japan Standard Time (JST), after taking off from Chubu Centrair International Airport, operating as flight EIA238, the crew of an Evergreen International Airlines Boeing 747-200F airplane, registration number N482EV,…
- [NTSB ENG11WA004](https://openairdocs.org/ntsb/ENG11WA004.md): Boeing 747 · Frankfurt Main (FRA), Germany · Incident · No injuries · Foreign investigation · Nov 26, 2010 · D-ABVM · Minor damage
  > On November 26, 2010, 2250 Coordinated Universal Time (UTC), a Lufthansa German Airlines Boeing B-747-430,registered as D-ABVM, was taxiing at Frankfurt Main International Airport, when the right hand main landing gear failed. The aircraft was disabled on the…
- [NTSB CEN11WA091](https://openairdocs.org/ntsb/CEN11WA091.md): Cessna 501 · Birmingham, United Kingdom · Accident · Serious injuries · Foreign investigation · Nov 19, 2010 · G-VUEM · Substantial damage
  > On November 19, 2010, at 1535 universal coordinated time (UTC), a Cessna 501, G-VUEM, collided with the instrument landing system (ILS) glide path antenna and the ground during approach to the runway at the Birmingham Airport, Birmingham, United Kingdom.…
- [NTSB ERA11WA075](https://openairdocs.org/ntsb/ERA11WA075.md): Piper PA-25 · Tapurah City, Brazil · Accident · 1 fatal · Foreign investigation · Nov 18, 2010 · PT-WOP · Destroyed
  > On November 18, 2010, about 1700 Universal Coordinated Time (UTC), a Piper PA-25-235, Brazilian registration PT-WOP, operated by Aeroagricola Boa Safra Ltda, lost control and crashed into trees during an agricultural flight at the Marape Farm, Tapurah City,…
- [NTSB CEN11WA088](https://openairdocs.org/ntsb/CEN11WA088.md): Hawker Beechcraft F33A · Buttonville, Canada · Accident · 3 fatal · Foreign investigation · Nov 18, 2010 · C-GSCZ · Substantial damage
  > On November 18, 2010, at 1842 eastern standard time, a Hawker Beechcraft model F33A (Bonanza), s/n CE-1709, Canadian registration C-GSCZ, departed controlled flight and crashed 15 nautical miles east of Buttonville, Ontario, Canada. The airplane was…
- [NTSB ERA11WA073](https://openairdocs.org/ntsb/ERA11WA073.md): Swearingen SA227 · Andahuaylas, Peru · Accident · Minor injuries · Foreign investigation · Nov 13, 2010 · N781C · Substantial damage
- [NTSB ERA11WA064](https://openairdocs.org/ntsb/ERA11WA064.md): Bell 412EP · Trujillo, Colombia · Accident · 3 fatal · Foreign investigation · Nov 13, 2010 · XA-UNI · Destroyed
  > On November 13, 2010, about 2115 universal coordinated time, a Bell 412, Mexican registration XA-UNI, owned and operated by Aeroservicios Especializados S.A. de C.V. (ASESA), crashed in mountainous terrain near Trujillo, Colombia. Instrument meteorological…
- [NTSB ERA11WA060](https://openairdocs.org/ntsb/ERA11WA060.md): Cirrus Design SR22 · Luzzara, Italy · Accident · No injuries · Foreign investigation · Nov 12, 2010 · N918SR · Substantial damage
  > On November 12, 2010, at 1000 universal coordinated time, a Cirrus Design Corp SR22, N918SR, experienced a total loss of engine power while in cruise flight, and was substantially damaged during a forced landing to field in Luzzara, Italy. The pilot was not…
- [NTSB ENG11WA003](https://openairdocs.org/ntsb/ENG11WA003.md): Boeing 767 · Perth, Australia, Australia · Incident · No injuries · Foreign investigation · Nov 12, 2010 · VH-OGO · No damage
  > On 12 November 2010, a Qantas Airways Boeing 767-338 airplane, registered VH-OGO, departed from Perth, Western Australia as flight QF768, a scheduled passenger service to Melbourne, New South Wales. Shortly after departure, the crew felt an engine vibration…
- [NTSB WPR11WA043](https://openairdocs.org/ntsb/WPR11WA043.md): Robinson R22 · Rolleston, Australia, Australia · Accident · 1 fatal · Foreign investigation · Nov 9, 2010 · VH-TCG · Substantial damage
  > On November 9, 2010, at 0330 universal coordinated time, a Robinson R22, VH-TCG, operated by a private individual, collided with terrain during a mustering operation near Rolleston, Australia. The helicopter was substantially damaged and the pilot was killed.…
- [NTSB DCA11WA031](https://openairdocs.org/ntsb/DCA11WA031.md): Boeing 747 · Frankfurt, Germany · Incident · No injuries · Foreign investigation · Nov 9, 2010 · D-ABVT · Minor damage
  > On November 9, 2010, a Boeing 747-400, German registration D-ABVT, operated by Lufthansa, experienced a fire in the APU compartment. There were no injuries, and minor damage to the airplane. This incident is being investigated by the BFU of Germany.…
- [NTSB ERA11WA086](https://openairdocs.org/ntsb/ERA11WA086.md): Eurocopter AS 350 B2 · Taltal, Chile · Accident · 1 fatal · Foreign investigation · Nov 6, 2010 · CC-AAN · Destroyed
  > On November 6, 2010, at 2330 universal coordinated time, a Eurocopter, AS 350 B2 helicopter, Chilean registration CC-AAN, collided with terrain while in low level cruise flight near Taltal, Chile. The flight was operated by Servicios y Transporte Aereos…
- [NTSB ERA11WA068](https://openairdocs.org/ntsb/ERA11WA068.md): Fairchild SA227-AC · Huanuco, Peru · Accident · No injuries · Foreign investigation · Nov 6, 2010 · N115GS · Substantial damage
  > On November 6, 2010, about 1925 Universal Coordinated Time (UTC), a Fairchild SA-227AC, N115GS, operated by LC Busre S.A.C., on a commercial flight, incurred substantial damage when the landing gear collapsed during landing at the Alferez FAP David Figueroa…
- [NTSB DCA11WA008](https://openairdocs.org/ntsb/DCA11WA008.md): Beech 1900 · Karachi, Pakistan · Accident · 21 fatal · Foreign investigation · Nov 5, 2010 · AP-BJD · Destroyed
  > On November 5, 2010, a JS Air Pakistan, a Hawker Beechcraft B-1900, registration AP-BJD, crashed shortly after takeoff from Karachi-Jinnah International Airport (KHI), Karachi, Pakistan. All 17 passengers and 4 crewmembers onboard were fatally injured, and…
- [NTSB DCA11WA007](https://openairdocs.org/ntsb/DCA11WA007.md): Boeing 737 · Puerto Vallerta, Mexico · Incident · No injuries · Foreign investigation · Nov 4, 2010 · XA-UHY · Minor damage
  > On November 4, 2010, a Global Airlines chartered Boeing 727-200, registered as XA-UHY, landed with its nose gear retracted at Licenciado Gustavo Díaz Ordaz International Airport (PVR), Puerto Vallerta, Mexico. The event is being investigated by the Government…
- [NTSB CEN11WA058](https://openairdocs.org/ntsb/CEN11WA058.md): Beech C90 · St Anonin sur Bayon, France · Accident · 2 fatal · Foreign investigation · Nov 4, 2010 · F-BVTB · Substantial damage
  > On November 4, 2011, approximately 1520 coordination universal time, a French registered Beech C90A, F-BTVB, was substantially damaged upon impact with terrain following a loss of control near St Antonin sur Bayon, France. The two pilots were both fatally…
- [NTSB CEN11WA080](https://openairdocs.org/ntsb/CEN11WA080.md): Piper PA46 · Sekowice, Poland · Accident · 2 fatal · Foreign investigation · Nov 3, 2010 · D-EXTA · Destroyed
  > On November 3, 2010, at 1009 coordinated universal time, a German registered Piper PA-46-350P, D-ETXA, was destroyed upon impact with terrain following a loss of control near Sekowice, Poland. The pilot and one additional occupant were both fatally injured.…
- [NTSB ENG11RA018](https://openairdocs.org/ntsb/ENG11RA018.md): Boeing 777 · Dusseldorf, Germany · Incident · No injuries · Foreign investigation · Nov 2, 2010 · A6EMR · Minor damage
  > On November 2, 2010, at about 1441 UTC, an Emirates B777-300 (Registration #: A6EMR) traveling from, Düsseldorf, Germany to Dubai, United Arab Emirates experienced a partial failure of the L/H inboard side thrust reverser of the L/H Engine during takeoff.…
- [NTSB WPR11WA164](https://openairdocs.org/ntsb/WPR11WA164.md): De Havilland DHC8 · Blenheim, New Zealand · Incident · No injuries · Foreign investigation · Oct 30, 2010 · ZK-NEB. · Minor damage
  > On September 20, 2010, at 0400 universal coordinated time, a de Havilland Canada, DHC-8-300, ZK-NEB, experienced a nose gear collapse after landing at Blenheim Airport, New Zealand. The airplane was operated by Air Nelson Ltd, as a commercial passenger…
- [NTSB CEN11WA081](https://openairdocs.org/ntsb/CEN11WA081.md): Gulfstream Aerospace G-IV · Gander, Canada · Incident · No injuries · Foreign investigation · Oct 30, 2010 · N45AC · No damage
  > On October 30, 2010, about 1934 coordinated universal time (UTC), a Gulfstream Aerospace G-IV, N45AC, owned by Ashton Aviation LLC and operated by Crystal Air Aviation, incurred no damage during a downwind landing overrun on runway 3 (10,200 feet by 200 feet…
- [NTSB DCA11WA114](https://openairdocs.org/ntsb/DCA11WA114.md): Piper PA32 - 301 · Vipingo Ridge, Kenya · Accident · 1 fatal · Foreign investigation · Oct 23, 2010 · 5Y-NAM · Substantial damage
  > On October 23, 2010, about 0653 UTC, 5Y-NAM, a Piper PA-32R-301, a personal flight, had an inflight breakup during cruise flight and crashed in an open field at Vipingo Ridge, Kenya. The pilot, the sole occupant, was fatally injured. The aircraft was…
- [NTSB CEN11WA042](https://openairdocs.org/ntsb/CEN11WA042.md): Agusta A109 · New Castle, United Kingdom · Accident · 3 fatal · Foreign investigation · Oct 23, 2010 · N2NR · Destroyed
- [NTSB ERA11WA031](https://openairdocs.org/ntsb/ERA11WA031.md): Cessna TU206G · Medellin, Colombia · Accident · 5 fatal · Foreign investigation · Oct 20, 2010 · HK2933 · Destroyed
  > On October 20, 2010, about 1300 Universal Coordinated Time (UTC), a Cessna TU206G, Columbian registration HK2933, was destroyed by fire after crashing in Path Shipyards, Medellin, Columbia. The flight was en route from Medellin, (SKMD), to Fort Vigia,…
- [NTSB WPR11WA020](https://openairdocs.org/ntsb/WPR11WA020.md): Cessna 172 · Durham Downs, Australia, Australia · Accident · 2 fatal · Foreign investigation · Oct 18, 2010 · VH-VSK · Substantial damage
  > On October 18, 2010, at 1230 universal coordinated time, a Cessna 172S, VH-VSK, collided with the terrain near Durham Downs, Australia. The airplane was operated by S. Kidman & Co LTD. The pilot and passenger were killed and the airplane was substantially…
- [NTSB ERA11WA032](https://openairdocs.org/ntsb/ERA11WA032.md): Cessna 172N · Malaga, Colombia · Accident · 4 fatal · Foreign investigation · Oct 15, 2010 · HK4631 · Destroyed
  > On October 15, 2010, about 1300 Universal Coordinated Time (UTC), a Cessna 172N, Columbian registration HK4631, operated by Aerolineas Alas de Columbia, impacted terrain near the town of Malaga, Santander, Columbia. The flight was en route from Lebrija,…
- [NTSB CEN11WA070](https://openairdocs.org/ntsb/CEN11WA070.md): Bell 212 · Minatitlan Veracruz, Mexico · Accident · 8 fatal · Foreign investigation · Oct 15, 2010 · XA-IUR · Substantial damage
  > The government of Mexico has notified the NTSB of an accident involving a BELL 212 helicopter that occurred on October 15, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB CEN11RA024](https://openairdocs.org/ntsb/CEN11RA024.md): Beech A36 · Ensenada, Mexico · Accident · 4 fatal · Foreign investigation · Oct 15, 2010 · N212DB · Destroyed
  > On October 15, 2010, at 2200 coordinated universal time (1400 local), a Beech A36, US registered N212DB, owned by Lyon Roger C Trustee and piloted by an instrument rated private pilot, was destroyed when it impacted terrain under unknown circumstances near…
- [NTSB CEN11WA096](https://openairdocs.org/ntsb/CEN11WA096.md): Piper PA36 · Alcora, Spain · Accident · No injuries · Foreign investigation · Oct 14, 2010 · EC-EJR · Substantial damage
  > On October 14, 2010, about 0945 coordinated universal time (UTC), a Piper PA-36 agricultural airplane, EC-EJR, lost engine power and conducted a forced landing near Alcora, Spain. The airplane was substantially damaged and the pilot was not injured. This…
- [NTSB DCA11WA003](https://openairdocs.org/ntsb/DCA11WA003.md): Lockheed L-100 · Kabul, Afghanistan · Accident · 8 fatal · Foreign investigation · Oct 12, 2010 · 5X-TUC · Destroyed
  > On October 12, 2010, about 1505 UTC, a Trans Afrique Airlines (under contract to National Air Cargo) Lockheed L-100, registration 5X-TUC, impacted terrain while maneuvering to land at Kabul International Airport (OAKB), Kabul Afghanistan. The two flight crew…
- [NTSB ENG11RA001](https://openairdocs.org/ntsb/ENG11RA001.md): Boeing 747 · Seoul, South Korea · Incident · No injuries · Foreign investigation · Oct 10, 2010 · HL7489 · Minor damage
  > On October 10, 2010, Korean Air Boeing 747-400 registered in Korea as HL7489, experienced an uncontained release of turbine material from the No. 3 engine, a Pratt & Whitney PW4056 engine. About 40 minutes after takeoff, the crew observed engine vibrations…
- [NTSB CEN11WA013](https://openairdocs.org/ntsb/CEN11WA013.md): Cessna 501 · Veracruz, Mexico · Accident · No injuries · Foreign investigation · Oct 6, 2010 · XA-TKY
  > On October 6, 2010, at an unknown time, a Cessna Citation 501 airplane, XA-TKY disappeared shortly after takeoff near Veracruz, Mexico. There were eight passengers and crew aboard the airplane when it went missing. The airplane was over water at the time of…

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

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