# NTSB investigations: Cessna 170B, IN

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN20CA296](https://openairdocs.org/ntsb/CEN20CA296.md): Cessna 170B · Bloomington, IN · Accident · No injuries · Class 4 · Data collection · Final report · Jul 20, 2020 · N8193A · Substantial damage
  > The pilot's failure to attain/maintain directional control during landing that resulted in a ground loop and impact with terrain.
- [NTSB CEN13CA306](https://openairdocs.org/ntsb/CEN13CA306.md): Cessna 170B · Danville, IN · Accident · No injuries · Data collection · Final report · May 23, 2013 · N3119A · Substantial damage
  > The pilot not maintaining directional control of the airplane during the landing roll resulting in the ground loop.
- [NTSB CHI87LA216](https://openairdocs.org/ntsb/CHI87LA216.md): Cessna 170B · Washington, IN · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1987 · N473CJ · Substantial damage
  > The 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 CHI87DET02](https://openairdocs.org/ntsb/CHI87DET02.md): Cessna 170B · Angola, IN · Accident · No injuries · Final report · Mar 10, 1987 · N3135A · Substantial damage
  > Pilot 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 CHI82DA239](https://openairdocs.org/ntsb/CHI82DA239.md): Cessna 170B · Plymouth, IN · Accident · No injuries · Final report · Jul 6, 1982 · N8220A · Substantial damage
  > Pilot 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 CHI7LDEA05](https://openairdocs.org/ntsb/CHI7LDEA05.md): Cessna 170B · New Castle, IN · Accident · No injuries · Closed · Aug 4, 1975 · N2857C · Substantial damage
- [NTSB CHI73FET24](https://openairdocs.org/ntsb/CHI73FET24.md): Cessna 170B · New Paris, IN · Accident · No injuries · Closed · Jun 8, 1973 · N8292A · Substantial damage
- [NTSB CHI71FBA18](https://openairdocs.org/ntsb/CHI71FBA18.md): Cessna 170B · Columbus, IN · Accident · No injuries · Closed · Nov 1, 1970 · N8346A · Substantial damage
- [NTSB CHI70FBA24](https://openairdocs.org/ntsb/CHI70FBA24.md): Cessna 170B · Greenwood, IN · Accident · Minor injuries · Closed · Jun 19, 1970 · N2903D · Substantial damage
- [NTSB CHI69D0478](https://openairdocs.org/ntsb/CHI69D0478-201700.md): Mooney M20E · Franklin, IN · Accident · No injuries · Closed · Feb 1, 1969 · N7195U · 2 aircraft · Substantial damage
- [NTSB CHI66D0176](https://openairdocs.org/ntsb/CHI66D0176.md): Cessna 170B · Valpariso, IN · Accident · No injuries · Closed · Aug 13, 1965 · N43F · Substantial damage
- [NTSB CHI66D0087](https://openairdocs.org/ntsb/CHI66D0087.md): Cessna 170B · Greenfield, IN · Accident · No injuries · Closed · Jul 11, 1965 · N2738D · Substantial damage
- [NTSB UNK64X1337](https://openairdocs.org/ntsb/UNK64X1337.md): Cessna 170B · North Judson, IN · Accident · No injuries · Closed · Apr 16, 1964 · N1897C · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/ntsb?model=2072306&state=IN

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
