NTSB investigations: Cessna 170, MN
12 cases on aircraft the registry lists as Cessna 170. 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 | 2 |
|---|---|
| 1965 | 2 |
| 1968 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1994 | 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\" = 'MN' 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 ('2072302'))
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" = 'MN' 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 ('2072302'))
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 CHI94LA336Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNAn 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 CHI87LA172Accident · No injuriesLimited investigationFinal reportCessna 170 · Lakeville, MNThe plt rprtd the wind was varying plus or minus 30 deg from 200 deg at 10 gusting 25 KTS. Drg the takeoff roll on rwy 29, the acft enctrd a gust of wind. The acft swerved & the plt recovered, but the acft enctrd another gust which raised the left wing.…NTSB CHI86LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · Grygla, MNThe aircraft had been fitted with owner installd skis. During landing the left ski separates from its mount allowing the left ski mount to dig into the snow covered runway. The right wingtip struck a snowbank and the aircraft came to rest on its nose. The…NTSB MKC76DER08Accident · No injuriesClosedCessna 170 · Preston, MNNTSB MKC74DER18Accident · No injuriesClosedCessna 170 · Anoka, MNNTSB MKC73FER11Accident · No injuriesClosedCessna 170 · Rosemount, MNNTSB MKC69D0246Accident · No injuriesClosedCessna 170 · Almelund, MNNTSB MKC69A0009Accident · 2 fatalClosedCessna 170 · Howard Lake, MNNTSB MKC66F0238Accident · No injuriesClosedCessna 170 · Cottonwood, MNNTSB MKC65F0009Accident · No injuriesClosedCessna 170 · Isle, MNNTSB UNK64X2140Accident · No injuriesClosedCessna 170 · Montevideo, MNNTSB UNK64X1433Accident · No injuriesClosedCessna 170 · Tracy, MN