# NTSB investigations, IN: 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 CEN24LA128](https://openairdocs.org/ntsb/CEN24LA128.md): Eurocopter Deutschland MBB-BK 117 C-2 · West Lafayette, IN · Accident · No injuries · Class 3 · Limited · Final report · Mar 7, 2024 · N191LL · Substantial damage
  > The failure of maintenance personnel to properly install the tail rotor pitch change slider attachment hardware (T-bolt), which led to the disconnection of the pitch change slider, a loss of tail rotor control, and subsequent hard landing. Contributing to the…
- [NTSB GAA19CA246](https://openairdocs.org/ntsb/GAA19CA246.md): Cessna 182 · Marion, IN · Accident · Minor injuries · Data collection · Final report · May 5, 2019 · N96974 · Destroyed
  > The pilot's improper trim setting and his exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall.
- [NTSB CEN19FA135](https://openairdocs.org/ntsb/CEN19FA135.md): Piper PA34 · Anderson, IN · Accident · Serious injuries · Class 2 · Field · Final report · May 5, 2019 · N999CR · Substantial damage
  > The loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.
- [NTSB CEN13LA231](https://openairdocs.org/ntsb/CEN13LA231.md): Needham Stoddard-Hamilton TD · Bloomington, IN · Accident · No injuries · Limited investigation · Final report · Apr 14, 2013 · N95RL · Substantial damage
  > The improper installation of a rudder control cable connector and its subsequent separation from the bellcrank, which resulted in the loss of directional control during takeoff.

## 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" = 'IN' 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=IN

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