# NTSB investigations, 2012: Clear air turbulence

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 WPR12LA396](https://openairdocs.org/ntsb/WPR12LA396.md): Beech G35 · Oceano, CA · Accident · No injuries · Limited investigation · Final report · Aug 31, 2012 · N4454D · Substantial damage
  > The pilot’s exceedance of the design maneuvering speed during descent in turbulence, which resulted in structural damage to the aft fuselage.
- [NTSB CEN12IA385](https://openairdocs.org/ntsb/CEN12IA385.md): Cessna 182 · Fowlerville, MI · Incident · No injuries · Incident investigation · Final report · May 27, 2012 · N287TC · Minor damage
  > The airplane’s encounter with clear air turbulence, which caused a momentary loss of control and minor damage to the airplane.
- [NTSB WPR12LA144](https://openairdocs.org/ntsb/WPR12LA144.md): Boeing 737-7H4 · Laverne, OK · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 2012 · N247WN · No damage
  > The airplane’s encounter with severe turbulence during cruise flight, which resulted in a serious injury to a flight attendant.
- [NTSB DCA12CA059](https://openairdocs.org/ntsb/DCA12CA059.md): Bombardier CL-600-2B19 · Harrisburg, PA · Accident · Serious injuries · Data collection · Final report · Mar 3, 2012 · N453AW · No damage
  > an inadvertent encounter with clear air turbulence during descent.
- [NTSB WPR12LA119](https://openairdocs.org/ntsb/WPR12LA119.md): Boeing 737-7H4 · Pawnee, NE · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 2012 · N915WN · No damage
  > The airplane's encounter with moderate turbulence during cruise flight, which resulted in a serious injury to a flight attendant.
- [NTSB CEN12LA166](https://openairdocs.org/ntsb/CEN12LA166.md): Boeing 737-832 · Detroit, MI · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 2012 · N374DA · No damage
  > An in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.
- [NTSB DCA12CA033](https://openairdocs.org/ntsb/DCA12CA033.md): Antonov AN124 · Anchorage, AK · Accident · Serious injuries · Data collection · Final report · Feb 2, 2012 · RA82046 · No damage
  > an inadvertent encounter with Clear Air Turbulence that resulted in serious injuries to two crewmembers.

## 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03032015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03032015/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
