NTSB investigations: Cessna 170A, AZ
10 cases on aircraft the registry lists as Cessna 170A. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 2 |
| 1973 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 2023 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR25LA129Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 170A · Maricopa, AZOn 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 WPR23LA096Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Mesa, AZThe 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 LAX85LA085Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Cottonwood, AZWitnesses 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 wiresNTSB LAX81DUK05Accident · No injuriesClosedCessna 170A · Cottonwood, AZNTSB LAX74DUJ01Accident · No injuriesClosedCessna 170A · Douglas, AZNTSB LAX72FUJ32Accident · No injuriesClosedCessna 170A · Mesa, AZNTSB LAX71DUJ76Accident · No injuriesClosedCessna 170 · Casa Grande, AZNTSB LAX70D0052Accident · No injuriesClosedCessna 170A · Clifton, AZNTSB LAX69F0080Accident · Serious injuriesClosedCessna 170 · Winslow, AZNTSB UNK64X3861Accident · Minor injuriesClosedCessna 170 · Tucson, AZ