# NTSB investigations: Cessna 170A, AZ

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 WPR25LA129](https://openairdocs.org/ntsb/WPR25LA129.md): Cessna 170A · Maricopa, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 10, 2025 · N1371D · Substantial damage
  > On April 10, 2025, at 1207 mountain standard time, a Cessna 170A, N1371D, sustained substantial damage when it was involved in an accident near Maricopa, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR23LA096](https://openairdocs.org/ntsb/WPR23LA096.md): Cessna 170 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Final report · Jan 23, 2023 · N9534A · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll out and the preexisting fatigue cracks in the left main landing gear leg, which resulted in the leg’s premature overstress fracture during the ground loop.
- [NTSB LAX85LA085](https://openairdocs.org/ntsb/LAX85LA085.md): Cessna 170A · Cottonwood, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 1984 · N9164A · Substantial damage
  > Witnesses reported that the acft was in level flight at treetop altitude along a river and that the engine was operatingnormally until the acft struck & severed three power lines before impacting the riverbank about 200 ft west of the wires
- [NTSB LAX81DUK05](https://openairdocs.org/ntsb/LAX81DUK05.md): Cessna 170A · Cottonwood, AZ · Accident · No injuries · Closed · Sep 13, 1981 · N9164A · Substantial damage
- [NTSB LAX74DUJ01](https://openairdocs.org/ntsb/LAX74DUJ01.md): Cessna 170A · Douglas, AZ · Accident · No injuries · Closed · Jul 1, 1973 · N9922A · Destroyed
- [NTSB LAX72FUJ32](https://openairdocs.org/ntsb/LAX72FUJ32.md): Cessna 170A · Mesa, AZ · Accident · No injuries · Closed · Aug 18, 1971 · N1756D · Substantial damage
- [NTSB LAX71DUJ76](https://openairdocs.org/ntsb/LAX71DUJ76.md): Cessna 170 · Casa Grande, AZ · Accident · No injuries · Closed · Mar 10, 1971 · N9268A · Substantial damage
- [NTSB LAX70D0052](https://openairdocs.org/ntsb/LAX70D0052.md): Cessna 170A · Clifton, AZ · Accident · No injuries · Closed · Jul 18, 1969 · N1441D · Substantial damage
- [NTSB LAX69F0080](https://openairdocs.org/ntsb/LAX69F0080.md): Cessna 170 · Winslow, AZ · Accident · Serious injuries · Closed · Aug 3, 1968 · N9013A · Destroyed
- [NTSB UNK64X3861](https://openairdocs.org/ntsb/UNK64X3861.md): Cessna 170 · Tucson, AZ · Accident · Minor injuries · Closed · Sep 7, 1964 · N3866V · Destroyed

## 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" = 'AZ' 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=AZ

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