NTSB investigations: Cessna 170A, MN
17 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 | 4 |
|---|---|
| 1965 | 3 |
| 1968 | 1 |
| 1972 | 2 |
| 1975 | 3 |
| 1983 | 1 |
| 1987 | 1 |
| 1998 | 1 |
| 2016 | 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 ('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" = '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 ('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 CEN16LA343Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Hibbing, MNThe pilot's failure to maintain aircraft control, which resulted in impact with terrain near the runway.NTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).NTSB CHI87LA192Accident · No injuriesLimited investigationFinal reportCessna 170A · Monticello, MNDrg the takeoff roll, the plt lost directional control of the tailwheel equipped acft. It then swerved to the left & went into a soybean field. Drg the occurrence, the rgt main gear collapsed & the rgt wing, rgt horizontal stabilizer, prop & eng cowling were…NTSB CHI83LER04Accident · No injuriesFinal reportCessna 170A · Crystal, MNAs the plt applied brakes the acft veered off to the right. He applied left rudder & left brake to no avail, & the acft ground-looped off the right side of the rwy. The left brake outer lining was missing. There were two rivets missing & one rivet had broken.…NTSB MKC76AER24Accident · No injuriesClosedCessna 170A · Carlos, MNNTSB MKC76AK015Accident · 3 fatalClosedCessna 170 · Mahtowa, MNNTSB MKC7KDER79Accident · No injuriesClosedCessna 170A · Duluth, MNNTSB MKC72DER58Accident · No injuriesClosedCessna 170A · Anoka, MNNTSB MKC72DER48Accident · No injuriesClosedCessna 170A · Anoka, MNNTSB MKC68D0566Accident · No injuriesClosedCessna 170 · Watertown, MNNTSB MKC66D0376Accident · No injuriesClosedCessna 170A · New Ulm, MNNTSB MKC66F0254Accident · No injuriesClosedCessna 170A · So St Paul, MNNTSB MKC65F0091Accident · No injuriesClosedCessna 170 · Minneapolis, MNNTSB UNK65X0995Accident · No injuriesClosedCessna 170A · Rosemount, MNNTSB UNK64X3422Accident · No injuriesClosedCessna 170 · East Bethel, MNNTSB UNK64X2167Accident · Minor injuriesClosedCessna 170A · Roseau, MNNTSB UNK64X0233Accident · No injuriesClosedCessna 170A · Rushford, MN