# NTSB investigations: Cessna 172, 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 CHI89DEX02](https://openairdocs.org/ntsb/CHI89DEX02.md): Cessna 172 · Greencastle, IN · Accident · No injuries · Final report · Dec 3, 1988 · N5728A · Substantial damage
  > Inflight collision with a large bird.
- [NTSB CHI88LA176](https://openairdocs.org/ntsb/CHI88LA176.md): Cessna 172 · Carbon, IN · Accident · No injuries · Limited investigation · Final report · Jul 27, 1988 · N6818A · Substantial damage
- [NTSB CHI88LA115](https://openairdocs.org/ntsb/CHI88LA115.md): Cessna 172 · North Liberty, IN · Accident · Minor injuries · Limited investigation · Final report · May 22, 1988 · N5848A · Substantial damage
  > While departing from a grass strip the pilot was unable to maintain a sufficient rate of climb and airspeed during the climbout. In an effort to regain airspeed, the pilot stated that he pushed the nose forward and the aircraft struck the ground in a nose…
- [NTSB CHI83LA363](https://openairdocs.org/ntsb/CHI83LA363.md): Cessna 172 · Grandview, IN · Accident · No injuries · Limited investigation · Final report · Aug 6, 1983 · N8164B · Substantial damage
  > The acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…
- [NTSB CHI82FEX05](https://openairdocs.org/ntsb/CHI82FEX05.md): Cessna 172 · Paoli, IN · Accident · Serious injuries · Closed · Dec 26, 1981 · N5072A · Destroyed
- [NTSB CHI81FEX13](https://openairdocs.org/ntsb/CHI81FEX13.md): Cessna 172 · Marion, IN · Accident · No injuries · Closed · Apr 5, 1981 · N4104F · Substantial damage
- [NTSB CHI80DA037](https://openairdocs.org/ntsb/CHI80DA037.md): Cessna 172 · Nappanee, IN · Accident · 1 fatal · Closed · May 10, 1980 · N3912F · Destroyed
- [NTSB CHI79FET05](https://openairdocs.org/ntsb/CHI79FET05.md): Cessna 172 · South Bend, IN · Accident · No injuries · Closed · Nov 5, 1978 · N7023A · Substantial damage
- [NTSB CHI79FEX05](https://openairdocs.org/ntsb/CHI79FEX05.md): Cessna 172 · Martinsville, IN · Accident · Minor injuries · Closed · Nov 3, 1978 · N6861A · Substantial damage
- [NTSB CHI78FEX31](https://openairdocs.org/ntsb/CHI78FEX31.md): Cessna 172 · Evansville, IN · Accident · 1 fatal · Closed · Aug 14, 1978 · N7071T · Destroyed
- [NTSB CHI77FEX25](https://openairdocs.org/ntsb/CHI77FEX25.md): Cessna 172 · Indianapolis, IN · Accident · Minor injuries · Closed · May 8, 1977 · N8685B · Substantial damage
- [NTSB CHI76FET48](https://openairdocs.org/ntsb/CHI76FET48.md): Cessna 172 · Griffith, IN · Accident · No injuries · Closed · Aug 17, 1976 · N5750A · Substantial damage
- [NTSB CHI76DEA27](https://openairdocs.org/ntsb/CHI76DEA27.md): Cessna 172 · Kokomo, IN · Accident · No injuries · Closed · Feb 9, 1976 · N4104F · Destroyed
- [NTSB CHI75DEA01](https://openairdocs.org/ntsb/CHI75DEA01.md): Cessna 172 · Anderson, IN · Accident · No injuries · Closed · Jul 8, 1974 · N7410A · Substantial damage
- [NTSB CHI74DEA46](https://openairdocs.org/ntsb/CHI74DEA46.md): Cessna 172 · Greentown, IN · Accident · No injuries · Closed · Jun 12, 1974 · N4104F · Substantial damage
- [NTSB CHI72FET18](https://openairdocs.org/ntsb/CHI72FET18.md): Cessna 172 · Elkhart, IN · Accident · Serious injuries · Closed · Mar 12, 1972 · N5632A · Destroyed
- [NTSB CHI71FBA32](https://openairdocs.org/ntsb/CHI71FBA32.md): Cessna 172 · Frankfort, IN · Accident · No injuries · Closed · Mar 10, 1971 · N8895B · Substantial damage
- [NTSB CHI71FBM13](https://openairdocs.org/ntsb/CHI71FBM13.md): Cessna 172 · Claypool, IN · Accident · No injuries · Closed · Jan 17, 1971 · N5898A · Substantial damage
- [NTSB CHI70F0254](https://openairdocs.org/ntsb/CHI70F0254.md): Cessna 172 · Hobart, IN · Accident · Minor injuries · Closed · Aug 3, 1969 · N6654A · Substantial damage
- [NTSB CHI69F0381](https://openairdocs.org/ntsb/CHI69F0381.md): Cessna 172 · Shelbyville, IN · Accident · No injuries · Closed · Nov 25, 1968 · N7238A · Destroyed
- [NTSB CHI69F0067](https://openairdocs.org/ntsb/CHI69F0067.md): Cessna 172 · Fairbanks, IN · Accident · Serious injuries · Closed · Jun 18, 1968 · N6084A · Destroyed
- [NTSB CHI68F0747](https://openairdocs.org/ntsb/CHI68F0747.md): Cessna 172 · Gary, IN · Accident · No injuries · Closed · May 2, 1968 · N7028A · Substantial damage
- [NTSB CHI68A0064](https://openairdocs.org/ntsb/CHI68A0064.md): Cessna 172 · Liberty, IN · Accident · 2 fatal · Closed · Jan 21, 1968 · N4142F · Destroyed
- [NTSB CHI68D0510](https://openairdocs.org/ntsb/CHI68D0510.md): Cessna 172 · Greenwood, IN · Accident · No injuries · Closed · Dec 20, 1967 · N4033F · Substantial damage
- [NTSB CHI67F0673](https://openairdocs.org/ntsb/CHI67F0673.md): Cessna 172 · Franklin, IN · Accident · No injuries · Closed · Jun 6, 1967 · N3920F · Substantial damage
- [NTSB CHI67D0645](https://openairdocs.org/ntsb/CHI67D0645.md): Cessna 172 · Otterbein, IN · Accident · No injuries · Closed · May 1, 1967 · N6335E · Substantial damage
- [NTSB CHI66D0746](https://openairdocs.org/ntsb/CHI66D0746.md): Cessna 172 · Angola, IN · Accident · No injuries · Closed · Apr 29, 1966 · N5999A · Substantial damage
- [NTSB CHI66D0379](https://openairdocs.org/ntsb/CHI66D0379.md): Cessna 172 · Greenwood, IN · Accident · No injuries · Closed · Oct 17, 1965 · N6105E · Substantial damage
- [NTSB CHI65D0167](https://openairdocs.org/ntsb/CHI65D0167.md): Cessna 172 · Lafayette, IN · Accident · No injuries · Closed · May 19, 1965 · N7475A · Substantial damage
- [NTSB UNK64X2447](https://openairdocs.org/ntsb/UNK64X2447.md): Cessna 172A · Farmersburg, IN · Accident · No injuries · Closed · Jun 23, 1964 · N6982A · Destroyed
- [NTSB UNK64X2316](https://openairdocs.org/ntsb/UNK64X2316.md): Cessna 172 · Van Buren, IN · Accident · Minor injuries · Closed · Jun 16, 1964 · N6498E · 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 ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072402&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.
