# NTSB investigations: Continental E225 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 ERA09CA117](https://openairdocs.org/ntsb/ERA09CA117.md): Beech G35 · Chattanooga, TN · Accident · No injuries · Data collection · Final report · Dec 30, 2008 · N400SC · Substantial damage
  > The pilot's failure to see and avoid the marked helicopter dolly. Contributing to the accident were the dark night conditions.
- [NTSB NYC08LA306](https://openairdocs.org/ntsb/NYC08LA306.md): Beech G35 · Knoxville, TN · Accident · No injuries · Limited investigation · Final report · Sep 6, 2008 · N4403D · Substantial damage
  > The pilot's improper fuel consumption calculations which resulted in total loss of engine power due to fuel exhaustion.
- [NTSB ATL86LLT09](https://openairdocs.org/ntsb/ATL86LLT09.md): Beech 35A · Nashville, TN · Accident · No injuries · Final report · Sep 27, 1986 · N676B · Substantial damage
  > The student plt was practicing a soft field takeoff when directional control of the acft was lost. The acft traveled aprx 100' left of the rwy centerline where the right wing struck the ground and the acft cartwheeled. The plt reported he was advised by his…
- [NTSB MKC81FA012](https://openairdocs.org/ntsb/MKC81FA012.md): Beech F35 · Paris, TN · Accident · No injuries · Closed · Jan 1, 1981 · N266S · Substantial damage
- [NTSB ATL81FKW04](https://openairdocs.org/ntsb/ATL81FKW04.md): Beech E35 · Chattanooga, TN · Accident · Minor injuries · Closed · Nov 2, 1980 · N3314C · Substantial damage
- [NTSB MIA72DKW18](https://openairdocs.org/ntsb/MIA72DKW18.md): Beech G35 · Sevierville, TN · Accident · No injuries · Closed · Feb 19, 1972 · N4665D · Substantial damage
- [NTSB MIA72DKW15](https://openairdocs.org/ntsb/MIA72DKW15.md): Beech C35 · Copperhill, TN · Accident · No injuries · Closed · Feb 5, 1972 · N5902C · Substantial damage

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

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