# NTSB investigations: Cessna 170, 1994

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 CHI94LA336](https://openairdocs.org/ntsb/CHI94LA336.md): Cessna 170 · Lakeville, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 1994 · N4271V · Substantial damage
  > An inadequate pre-flight inspection by the pilot when he did not insure that all the water was drained from the airplane's fuel tanks. Factors associated with this accident were contaminated fuel and powerlines.
- [NTSB CHI94LA332](https://openairdocs.org/ntsb/CHI94LA332.md): Cessna 170 · St. Anne, IL · Accident · No injuries · Limited investigation · Final report · Sep 18, 1994 · N4216V · Substantial damage
  > Engine failure due to an inadequately reconditioned cylinder.
- [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…

## 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") = 1994
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072302'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072302&year=1994

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