NTSB investigations: Cessna 170B, IN
13 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 | 2 |
| 1969 | 1 |
| 1970 | 2 |
| 1973 | 1 |
| 1975 | 1 |
| 1982 | 1 |
| 1987 | 2 |
| 2013 | 1 |
| 2020 | 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\" = 'IN' 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" = 'IN' 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 CEN20CA296Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170B · Bloomington, INThe pilot's failure to attain/maintain directional control during landing that resulted in a ground loop and impact with terrain.NTSB CEN13CA306Accident · No injuriesData collectionFinal reportCessna 170B · Danville, INThe pilot not maintaining directional control of the airplane during the landing roll resulting in the ground loop.NTSB CHI87LA216Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Washington, INThe pilot was landing the aircraft, after returning from a personal cross-country flight, when he encountered a crosswind gust and 'veered strongly to the right.' The pilot then decided to abort the landing and proceeded to add full power for a go-around.…NTSB CHI87DET02Accident · No injuriesFinal reportCessna 170B · Angola, INPilot performed full stall landing in moderate right crosswind. Attempts to control weathercocking with full left rudder and aileron were ineffective. Left brake was ineffective. Aircraft received substantial damage in resultant ground loop.NTSB CHI82DA239Accident · No injuriesFinal reportCessna 170B · Plymouth, INPilot practicing touch and go landings. During roll aircraft swerved off runway and in jumping a ditch dug a wing into ground and nosed over.NTSB CHI7LDEA05Accident · No injuriesClosedCessna 170B · New Castle, INNTSB CHI73FET24Accident · No injuriesClosedCessna 170B · New Paris, INNTSB CHI71FBA18Accident · No injuriesClosedCessna 170B · Columbus, INNTSB CHI70FBA24Accident · Minor injuriesClosedCessna 170B · Greenwood, INNTSB CHI69D0478Accident · No injuriesClosedMooney M20E · Franklin, INNTSB CHI66D0176Accident · No injuriesClosedCessna 170B · Valpariso, INNTSB CHI66D0087Accident · No injuriesClosedCessna 170B · Greenfield, INNTSB UNK64X1337Accident · No injuriesClosedCessna 170B · North Judson, IN