NTSB investigations: Cessna 170B, MI
21 cases on aircraft the registry lists as Cessna 170B. 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
| 1965 | 1 |
|---|---|
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 3 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 1999 | 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\" = 'MI' 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"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" = 'MI' 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" 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 CHI99LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Grand Ledge, MIthe flight instructor's failure to successfully take remedial action to maintain directional control of the airplane during the landing roll out. Factors were the crosswinds and snowbank.NTSB CHI97LA194Accident · 2 fatalLimited investigationFinal reportCessna 170B · Karlin, MIthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.NTSB CHI92LA087Accident · No injuriesLimited investigationFinal reportCessna 170 · Howell, MIDirectional control was not maintained by the pilot. A factor related to the accident was: a cross wind.NTSB CHI82DA224Accident · No injuriesFinal reportCessna 170B · Fowlerville, MIThe student pilot bounced on landing, veered to the left, and nosed over after encountering a soft spot in the corn field that the aircraft had entered.NTSB CHI81FEM18Accident · No injuriesClosedCessna 170B · Lowell, MINTSB CHI78FA046Accident · 1 fatalClosedCessna 170B · Ann Arbor, MINTSB CHI78FEM01Accident · Minor injuriesClosedCessna 170B · Bath, MINTSB CHI74DEM48Accident · No injuriesClosedCessna 170B · Allegan, MINTSB CHI73AC096Accident · 1 fatalClosedCessna 170B · Waterford, MINTSB CHI72FEC34Accident · Minor injuriesClosedCessna 170B · Troy, MINTSB CHI71FBJ42Accident · No injuriesClosedCessna 170B · Menominee, MINTSB CHI70F0360Accident · No injuriesClosedCessna 170B · Carleton, MINTSB CHI69A0046Accident · Minor injuriesClosedCessna 170 · New Hudson, MINTSB CHI69D0313Accident · No injuriesClosedCessna 170B · Eureka, MINTSB CHI68F0759Accident · No injuriesClosedCessna 170B · Niles, MINTSB CHI68F0252Accident · No injuriesClosedCessna 170B · Reading, MINTSB CHI68A0023Accident · 2 fatalClosedCessna 170B · Ludington, MINTSB CHI67F0060Accident · No injuriesClosedCessna 170B · Grand Rapids, MINTSB CHI67F0081Accident · No injuriesClosedCessna 170B · Kingsley, MINTSB CHI66F0711Accident · No injuriesClosedCessna 170B · Monroe, MINTSB CHI66F 174Accident · Minor injuriesClosedCessna 170B · New Hudson, MI