# NTSB investigations: GE CT7-SER series, TN

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 MIA99LA026](https://openairdocs.org/ntsb/MIA99LA026.md): Saab-Scania 340A · Memphis, TN · Accident · 1 fatal · Limited investigation · Final report · Nov 4, 1998 · N325PX · Minor damage
  > The ground crewmembers inadvertent walking into the path of a rotating propeller resulting in her being struck and fatally injured.
- [NTSB ATL94IA092](https://openairdocs.org/ntsb/ATL94IA092.md): Saab-Scania S340B · Nashville, TN · Incident · No injuries · Incident investigation · Final report · May 3, 1994 · N245AE · No damage
  > Engine ice/slush ingestion that resulted in power interruptions and failure of the air data computer coupled with moisture ingestion of the static system. Factors were the failure of the manufacturer to correct a previously identified design deficiency that…
- [NTSB ATL92IA169](https://openairdocs.org/ntsb/ATL92IA169.md): Saab-Scania 340B · Chattanooga, TN · Incident · No injuries · Incident investigation · Final report · Aug 31, 1992 · N245AE · No damage
  > The failure and subsequent seizure of the reduction gear box, and the failure of the propeller control unit as a result of contaminated oil supply which is shared with the gear box.

## 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" = 'TN' 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 ('30031'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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