# NTSB investigations: Cessna 170A, AL

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 ERA17CA087](https://openairdocs.org/ntsb/ERA17CA087.md): Cessna 170 · Hayden, AL · Accident · Serious injuries · Data collection · Final report · Jan 12, 2017 · N1387D · Substantial damage
  > The pilot’s failure to maintain clearance from trees during the approach.
- [NTSB ATL98LA106](https://openairdocs.org/ntsb/ATL98LA106.md): Cessna 170 · Pell City, AL · Accident · No injuries · Limited investigation · Final report · Aug 7, 1998 · N9968A · Substantial damage
  > The pilot's improper use of the flight controls during a crosswind landing and the improper recovery from a bounce resulted in the collapse of the right main landing gear. A factor was the right crosswind.
- [NTSB MIA96LA161](https://openairdocs.org/ntsb/MIA96LA161.md): Cessna 170A · Southside, AL · Accident · No injuries · Limited investigation · Final report · Jun 22, 1996 · N9230A · Substantial damage
  > failure of an oil line between the engine and the oil cooler, which resulted in loss of oil, oil starvation, and subsequent seizure of the engine. Factors relating to the accident were: the effects of a tailwind during the forced landing, and failure of the…
- [NTSB MIA77DKJ15](https://openairdocs.org/ntsb/MIA77DKJ15.md): Cessna 170 · Gadsden, AL · Accident · No injuries · Closed · Feb 5, 1977 · N1619D · Substantial damage
- [NTSB MIA74DKJ15](https://openairdocs.org/ntsb/MIA74DKJ15.md): Cessna 170A · Gadsden, AL · Accident · No injuries · Closed · Aug 19, 1973 · N1619D · Substantial damage
- [NTSB MIA70D0279](https://openairdocs.org/ntsb/MIA70D0279.md): Cessna 170A · Bessemer, AL · Accident · No injuries · Closed · Dec 20, 1969 · N5407C · Substantial damage
- [NTSB MIA67O0070](https://openairdocs.org/ntsb/MIA67O0070.md): Cessna 170 · Evergreen, AL · Accident · No injuries · Closed · Jul 15, 1966 · N5407C · 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" = 'AL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072304&state=AL

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