# NTSB investigations: Cessna 170A, IL

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 CEN09CA508](https://openairdocs.org/ntsb/CEN09CA508.md): Cessna 170A · Aurora, IL · Accident · No injuries · Data collection · Final report · Aug 6, 2009 · N9793A · Substantial damage
  > The pilot's failure to maintain directional control during the landing.
- [NTSB CHI06CA167](https://openairdocs.org/ntsb/CHI06CA167.md): Cessna 170A · Atwood, IL · Accident · Minor injuries · Data collection · Final report · Jun 24, 2006 · N9204A · Substantial damage
  > The loss of engine power during approach due to carburetor ice and the uneven terrain encountered during the forced landing which caused the airplane to nose over. Weather conducive to carburetor icing was a contributing factor.
- [NTSB CHI89LA021](https://openairdocs.org/ntsb/CHI89LA021.md): Cessna 170A · Springfield, IL · Accident · No injuries · Limited investigation · Final report · Nov 2, 1988 · N5596C · Substantial damage
  > The conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…
- [NTSB CHI86FA013](https://openairdocs.org/ntsb/CHI86FA013.md): Cessna 170A · Murphysboro, IL · Accident · 1 fatal · Field investigation · Final report · Oct 19, 1985 · N9271A · Destroyed
  > The plt took off in marginal VMC in an acft placarded for 'day VFR only'. Aprx 32 minutes after takeoff the acft collided with trees and descended to ground impact. A hunter in the local area at the time of the accident reported hearing the acft eng sound…
- [NTSB CHI85FA292](https://openairdocs.org/ntsb/CHI85FA292.md): Cessna 170A · Olney, IL · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1985 · N1223D · Substantial damage
  > The aircraft departed new baden and began flying erratically down an interstate highway. It caused one automobile accident by flying low head-on passes at cars. It flew underan overpass, damaging a wingtip in the process. It flew intoan electrical cable and…
- [NTSB CHI76FEV15](https://openairdocs.org/ntsb/CHI76FEV15.md): Cessna 170 · Enfield, IL · Accident · Serious injuries · Closed · Oct 12, 1975 · N1218D · Substantial damage
- [NTSB CHI74FEE15](https://openairdocs.org/ntsb/CHI74FEE15.md): Cessna 170A · Streator, IL · Accident · No injuries · Closed · Aug 20, 1973 · N1390D · Substantial damage
- [NTSB CHI72AC007](https://openairdocs.org/ntsb/CHI72AC007.md): Cessna 170A · Pittsfield, IL · Accident · 2 fatal · Closed · Jul 16, 1971 · N1499D · Destroyed
- [NTSB CHI70F0022](https://openairdocs.org/ntsb/CHI70F0022.md): Cessna 170A · Carbondale, IL · Accident · Minor injuries · Closed · May 29, 1969 · N5486C · Substantial damage
- [NTSB CHI68F0633](https://openairdocs.org/ntsb/CHI68F0633.md): Cessna 170 · Chicago, IL · Accident · No injuries · Closed · Feb 25, 1968 · N9024A · Substantial damage
- [NTSB CHI68D0206](https://openairdocs.org/ntsb/CHI68D0206.md): Cessna 170 · Sycamore, IL · Accident · No injuries · Closed · Jun 24, 1967 · N1337D · Substantial damage
- [NTSB CHI66A0018](https://openairdocs.org/ntsb/CHI66A0018.md): Cessna 170A · Metropolis, IL · Accident · 1 fatal · Closed · Aug 19, 1965 · N9501A · Destroyed

## 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" = 'IL' 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
```

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

---
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.