# Fatal NTSB investigations, KS: Flight control sys malf/fail

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 CEN15FA425](https://openairdocs.org/ntsb/CEN15FA425.md): Cessna T310Q · Wichita, KS · Accident · 1 fatal · Field investigation · Final report · Sep 25, 2015 · N301JA · Destroyed
  > The separation of the attachment hardware connecting the elevator trim tab pushrod to the elevator trim actuator, which resulted in the elevator trim tab jamming in a position outside the limits of normal travel and a subsequent loss of airplane control.
- [NTSB CEN10LA099](https://openairdocs.org/ntsb/CEN10LA099.md): Buckeye DM · Sublette, KS · Accident · 2 fatal · Limited investigation · Final report · Jan 17, 2010 · N582DW · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other aircraft, which resulted in a midair collision while maneuvering at low altitude.
- [NTSB DEN08FA058](https://openairdocs.org/ntsb/DEN08FA058.md): Piper PA-23-250 · Sterling, KS · Accident · 1 fatal · Field investigation · Final report · Feb 13, 2008 · N62793 · Destroyed
  > The loss of pitch control during cruise flight resulting from the separation of the stabilator trim actuator due to inadequate maintenenace.

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '333' 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/333/sequence?fatal=1&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
