NTSB investigations: Cessna 170B, WI
16 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1968 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 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\" = 'WI' 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" = 'WI' 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 CHI96LA016Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Oconomowoc, WIa loss of engine power for undetermined reasons. A factor associated with the accident was the unsuitable terrain on which to make the forced landing.NTSB CHI94LA092Accident · No injuriesLimited investigationFinal reportCessna 170B · Waupaca, WIThe failure of the pilot to maintain directional control. A factor related to the accident was the gusty crosswind.NTSB CHI93LA202Accident · No injuriesLimited investigationFinal reportCessna 170B · Janesville, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI89LA066Accident · No injuriesLimited investigationFinal reportCessna 170B · Freedom, WIThe pilot's failure to maintain directional control during the attempted takeoff on unsuitable terrain. The pilot's lack of recent flight experience was a contributing factor.NTSB CHI84LA285Accident · No injuriesLimited investigationFinal reportCessna 170B · Edgerton, WIThe plt stated he made a faster than normal approach & upon touchdown, the acft bounced back into the air. He added a little power to smooth out the landing, but when the acft touched down, the second time, it veered off the rwy, encountered a muddy corn…NTSB CHI77DER01Accident · No injuriesClosedCessna 170B · Rice Lake, WINTSB CHI76AC008Accident · 1 fatalClosedCessna 170B · Iron Ridge, WINTSB CHI75FEP70Accident · No injuriesClosedCessna 170B · Medford, WINTSB CHI75FEP36Accident · No injuriesClosedCessna 170B · Waukesha, WINTSB CHI74FEP11Accident · Minor injuriesClosedCessna 170B · Kenosha, WINTSB CHI68A0090Accident · 1 fatalClosedCessna 170B · Waukesha, WINTSB CHI67F0354Accident · No injuriesClosedCessna 170B · Pewaukee, WINTSB CHI67F0122Accident · No injuriesClosedCessna 170B · Brookfield, WINTSB CHI66D0577Accident · No injuriesClosedCessna 170B · Depere, WINTSB CHI65F0032Accident · No injuriesClosedCessna 170B · Wausau, WINTSB UNK64X0106Accident · No injuriesClosedCessna 170B · Superior, WI