# NTSB investigations: Continental C145 series, MS

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 ERA15CA256](https://openairdocs.org/ntsb/ERA15CA256.md): Cessna 170 · Raymond, MS · Accident · No injuries · Data collection · Final report · Jun 30, 2015 · N4027V · Substantial damage
  > The flight instructor's inadequate preflight inspection of the fuel system resulting in a total loss of engine power due to fuel contamination.
- [NTSB MIA94LA108](https://openairdocs.org/ntsb/MIA94LA108.md): Cessna 170 · Olive Branch, MS · Accident · No injuries · Limited investigation · Final report · Mar 29, 1994 · N2509V · Substantial damage
  > Failure of the pilot-in-command to apply carburetor heat before reducing engine power to descend resulting in the partial loss of engine power due to carburetor ice. Contributing to the accident was the unsuitable terrain encountered during the forced landing…
- [NTSB MIA79FKQ06](https://openairdocs.org/ntsb/MIA79FKQ06.md): Cessna 170A · Tupelo, MS · Accident · No injuries · Closed · Apr 7, 1979 · N1256D · Substantial damage
- [NTSB MIA67F0577](https://openairdocs.org/ntsb/MIA67F0577.md): Cessna 170 · Columbus, MS · Accident · No injuries · Closed · Jun 18, 1967 · N2773C · Substantial damage
- [NTSB MIA67F0213](https://openairdocs.org/ntsb/MIA67F0213.md): Cessna 170B · Shelby, MS · Accident · No injuries · Closed · Oct 13, 1966 · N8387A · 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" = 'MS' 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 ('17012'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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