# NTSB investigations: Cessna 170B, 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 ERA26LA152](https://openairdocs.org/ntsb/ERA26LA152.md): Cessna 170B · Bessemer, AL · Accident · No injuries · Class 4 · Limited · Final report · Mar 27, 2026 · N3184B · Substantial damage
  > The pilot’s loss of directional control during the landing roll.
- [NTSB ATL00LA020](https://openairdocs.org/ntsb/ATL00LA020.md): Cessna 170B · Oakland, AL · Accident · No injuries · Limited investigation · Final report · Dec 29, 1999 · N3276A · Substantial damage
  > The pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…
- [NTSB MIA79DKJ03](https://openairdocs.org/ntsb/MIA79DKJ03.md): Cessna 170B · Huntsville, AL · Accident · No injuries · Closed · Oct 15, 1978 · N3101A · Substantial damage
- [NTSB MIA73DKJ47](https://openairdocs.org/ntsb/MIA73DKJ47.md): Cessna 170 · Mobile, AL · Accident · No injuries · Closed · Feb 19, 1973 · N2395D · Substantial damage
- [NTSB MIA71DKJ15](https://openairdocs.org/ntsb/MIA71DKJ15.md): Cessna 170B · Athens, AL · Accident · No injuries · Closed · Sep 6, 1970 · N2272D · Substantial damage
- [NTSB MIA70D0130](https://openairdocs.org/ntsb/MIA70D0130.md): Cessna 170B · Andalusia, AL · Accident · No injuries · Closed · Aug 30, 1969 · N2385D · Substantial damage
- [NTSB UNK65X0339](https://openairdocs.org/ntsb/UNK65X0339.md): Cessna 170B · Jasper, AL · Accident · No injuries · Closed · Oct 19, 1964 · N3032A · 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 ('2072306', '2072307'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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