# NTSB investigations: AiResearch TPE331 series, 2018

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 CEN19FA030](https://openairdocs.org/ntsb/CEN19FA030.md): Cessna 441 · Harmon, ND · Accident · 3 fatal · Class 2 · Field · Final report · Nov 18, 2018 · N441CX · Destroyed
  > The pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.
- [NTSB WPR18LA129](https://openairdocs.org/ntsb/WPR18LA129.md): Gulfstream AM Corp Comm Div 695A · Bishop, CA · Accident · No injuries · Class 3 · Limited · Final report · Apr 26, 2018 · N79PH · Substantial damage
  > The failure of the left main landing gear upper arm forging due to fatigue cracking and subsequent overstress, which resulted in the collapse of the landing gear during the landing roll.
- [NTSB CEN18LA086](https://openairdocs.org/ntsb/CEN18LA086.md): Swearingen SA227 TT · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jan 19, 2018 · N6UP · Substantial damage
  > The failure of the left starter relay during engine start, which resulted in a loss of electrical and battery power during the flight and led to a forced landing with the nose landing gear not fully extended, causing substantial damage to the engines.
- [NTSB GAA18CA098](https://openairdocs.org/ntsb/GAA18CA098.md): Swearingen SA227 · Rock Springs, WY · Accident · No injuries · Data collection · Final report · Jan 11, 2018 · N561UP · Substantial damage
  > The pilot's failure to maintain directional control while taxiing in gusting tailwind conditions.

## 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") = 2018
  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&year=2018

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