# NTSB investigations: AiResearch TPE331-5&6SER, TX

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 CEN16FA146](https://openairdocs.org/ntsb/CEN16FA146.md): Rockwell 690B · Taylor, TX · Accident · 2 fatal · Field investigation · Final report · Apr 9, 2016 · N690TH · Destroyed
  > A loss of control while maneuvering for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or anomalies with the airplane.
- [NTSB CEN15LA239](https://openairdocs.org/ntsb/CEN15LA239.md): Ayres S2R G6 · Tivoli, TX · Accident · Minor injuries · Limited investigation · Final report · May 20, 2015 · N3300U · Substantial damage
  > The failure of the fuel control unit due to the worn stub shaft spline, which resulted in an engine overspeed. Contributing to the accident was maintenance personnel's inadequate inspection of the fuel control unit.
- [NTSB DFW07CA189](https://openairdocs.org/ntsb/DFW07CA189.md): Mitsubishi MU-2B-36 · Hobby Airport, TX · Accident · Serious injuries · Data collection · Final report · Aug 22, 2007 · N6KF · No damage
  > The failure of the ramp employee to maintain clearance from the rotating propeller. A contributing factor was the prevailing night conditions.
- [NTSB FTW00LA242](https://openairdocs.org/ntsb/FTW00LA242.md): Mitsubishi MU-2B-35 · Corsicana, TX · Accident · No injuries · Limited investigation · Final report · Aug 24, 2000 · N770MA · Substantial damage
  > the in-flight separation of the propeller blade, which resulted from intergranular corrosion and fatigue cracking.

## 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" = 'TX' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01515'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=01515&state=TX

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