# NTSB investigations, KS: 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 DCA16CA010](https://openairdocs.org/ntsb/DCA16CA010.md): Boeing 737-924ER · Plevna, KS · Accident · Serious injuries · Data collection · Final report · Oct 24, 2015 · N69838 · No damage
  > An inadvertent encounter with clear air turbulence resulting in a serious injury to a flight attendant.
- [NTSB CEN09CA007](https://openairdocs.org/ntsb/CEN09CA007.md): Let Blanik · Gardner, KS · Accident · No injuries · Data collection · Final report · Oct 4, 2008 · N48026 · Substantial damage
  > The pilot's decision to attempt a takeoff when the climb performance of the tow plane and the glider were inadequate. Contributing to the accident were the high density altitude and the terrain-induced turbulence.
- [NTSB DEN08CA133](https://openairdocs.org/ntsb/DEN08CA133.md): Beech C23 · Augusta, KS · Accident · No injuries · Data collection · Final report · Aug 6, 2008 · N24598 · Substantial damage
  > The student pilot's failure to maintain control of the airplane. Contributing to the accident were the flight instructor's inadequate supervision, turbulence, airspeed was not maintained, and compensation for the wind conditions was inadequate.

## 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."eventStateOrRegion" = 'KS' 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=KS

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