# NTSB investigations: AiResearch TPE331 series, IN

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 CHI05LA071](https://openairdocs.org/ntsb/CHI05LA071.md): Twin Commander Acft. 680V · Fort Wayne, IN · Accident · No injuries · Limited investigation · Final report · Feb 11, 2005 · N688TM · Substantial damage
  > The malfunction of the landing gear extension assembly during approach for undetermined reasons.
- [NTSB CHI01FA032](https://openairdocs.org/ntsb/CHI01FA032.md): Swearingen SA226TC · Fort Wayne, IN · Accident · 1 fatal · Field investigation · Final report · Nov 9, 2000 · N731AC · Destroyed
  > The indicated failure of the right hand AC bus during takeoff with low ceiling. The factors were the low ceiling, night, and the execssive workload the pilot experienced on takeoff with an electrical failure without a second in command.
- [NTSB DCA84AA015](https://openairdocs.org/ntsb/DCA84AA015.md): Swearingen SA226TC · Terre Haute, IN · Accident · 3 fatal · Final report · Jan 30, 1984 · N63Z · Destroyed
  > After taking off from rwy 23, the acft crashed ssw of the arpt about 6300 ft from the departure end of the rwy & about 1800 ft to the left of the rwy centerline. Impact occurred while the acft was in a steep descent. The wreckage path was scattered along a…
- [NTSB CHI81IA025](https://openairdocs.org/ntsb/CHI81IA025.md): Swearingen SA226 · Indianapolis, IN · Case · Closed · Feb 13, 1981 · N325BA

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01514', '01517'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=01514&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.