# NTSB investigations, 2013, AR: Part(s) separation from AC

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 CEN13LA402](https://openairdocs.org/ntsb/CEN13LA402.md): Air Tractor AT-502B · Tillar, AR · Accident · No injuries · Limited investigation · Final report · Jul 3, 2013 · N5182C · Substantial damage
  > The loss of engine throttle control during takeoff due to an unsecured cockpit throttle control pin, which resulted in a runway overrun.
- [NTSB CEN13LA384](https://openairdocs.org/ntsb/CEN13LA384.md): Ayres S2R-T34 · Heth, AR · Accident · No injuries · Limited investigation · Final report · Jun 28, 2013 · N455JM · Substantial damage
  > The partial collapse of the right main landing gear during landing due to an improper previous weld repair to the right main landing gear and subsequent corrosion, which resulted in a loss of directional control and impact with terrain.
- [NTSB CEN13IA387](https://openairdocs.org/ntsb/CEN13IA387.md): Martin Charles A Zenith Stol CH 750 · Paragould, AR · Incident · No injuries · Incident investigation · Final report · Jun 28, 2013 · N699TX · Minor damage
  > The improper installation of the propeller flange, which resulted in an in-flight separation of the propeller assembly.

## 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") = 2013
  AND c."eventStateOrRegion" = 'AR' 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" = '338' 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/338/sequence?state=AR&year=2013

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