# NTSB investigations, OK: Flight control system

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 CEN22LA066](https://openairdocs.org/ntsb/CEN22LA066.md): Piper PA-22-135 · Tahlequah, OK · Accident · No injuries · Class 4 · Limited · Final report · Dec 3, 2021 · N3372A · Substantial damage
  > A loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.
- [NTSB CEN16LA184](https://openairdocs.org/ntsb/CEN16LA184.md): Cessna 150F · Ponca City, OK · Accident · Serious injuries · Limited investigation · Final report · May 1, 2016 · N8619G · Substantial damage
  > Maintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.
- [NTSB CEN15CA166](https://openairdocs.org/ntsb/CEN15CA166.md): Funk B85C · Leonard, OK · Accident · No injuries · Data collection · Final report · Mar 6, 2015 · N81194 · Substantial damage
  > The improper installation of the UP elevator cable turnbuckle which became disconnected during the flight.
- [NTSB CEN11LA275](https://openairdocs.org/ntsb/CEN11LA275.md): Piper PA-32-300 · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Apr 7, 2011 · N31407 · Substantial damage
  > The loss of aircraft control due to the failure of the stabilator control cable turnbuckle.

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

This list as a web page: https://openairdocs.org/ntsb-findings/010227/cases?state=OK

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