# NTSB investigations, 2012, Outside the U.S.: Turbulence encounter

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.

## Latest cases

- [NTSB ERA12WA457](https://openairdocs.org/ntsb/ERA12WA457.md): Beech B36TC · Nassau, Bahamas · Accident · 2 fatal · Foreign investigation · Jul 16, 2012 · N6703K · Destroyed
- [NTSB DCA12WA109](https://openairdocs.org/ntsb/DCA12WA109.md): Boeing 777-222 · Narita, Japan · Accident · Serious injuries · Foreign investigation · Jul 5, 2012 · N224UA · No damage
- [NTSB DCA12WA108](https://openairdocs.org/ntsb/DCA12WA108.md): Boeing 747-400 · Tokyo, Japan · Accident · Serious injuries · Foreign investigation · Jul 5, 2012 · HL7473 · No damage
  > On July 5, 2012, a Boeing 747-400, HL7473, operated by Korean Air Lines Co., Ltd., as flight KAL2711, departed from the Gimpo International Airport (GMP), Seoul, South Korea, en route to the Tokyo International Airport (HND), Tokyo, Japan. Approximately 100…
- [NTSB DCA12WA104](https://openairdocs.org/ntsb/DCA12WA104.md): Boeing 737 · Frankfurt, Germany · Accident · Serious injuries · Foreign investigation · Jul 5, 2012 · D-ASXE · No damage
  > On 5 July, 2012, at approximately 1100 UTC, a SunExpress Deutschland B737-800, registration D-ASXE, encountered turbulence during cruise between Gaziantep, Turkey, and Frankfurt, Germany. Of the 86 passengers and crew onboard, one crew member received serious…
- [NTSB DCA12WA081](https://openairdocs.org/ntsb/DCA12WA081.md): Boeing 737-800 · Dusseldorf, Germany · Accident · No injuries · Foreign investigation · May 17, 2012 · D-ASXH · No damage
  > The German Federal Bureau of Aircraft Accidents (BFU) has notified the NTSB of an accident involving a Boeing 737 that occurred on May 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under the provisions of…

## The whole list in SQL

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

```sql
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE year(c."eventDate") = 2012
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '360' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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