# NTSB investigations: Cessna 172E, 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 CHI06CA123](https://openairdocs.org/ntsb/CHI06CA123.md): Cessna 172E · Richmond, IN · Accident · No injuries · Data collection · Final report · Apr 22, 2006 · N2985U · Substantial damage
  > The pilot's inadequate compensation for wind conditions during the landing. Factors were the crosswind and gusts.
- [NTSB CHI98LA195](https://openairdocs.org/ntsb/CHI98LA195.md): Cessna 172E · Demotte, IN · Accident · No injuries · Limited investigation · Final report · Jun 10, 1998 · N3933S · Substantial damage
  > The pilot's inadequate preflight planning that failed to ensure takeoff could be attained. Other related factors were the aborted takeoff, grass, and a dirt bank.
- [NTSB CHI87DEX06](https://openairdocs.org/ntsb/CHI87DEX06.md): Cessna 172E · Huntingburg, IN · Accident · Minor injuries · Final report · May 31, 1987 · N5514T · Substantial damage
  > While on a x-country flt, the acft's nav equip was not working properly & the plt became lost/disoriented. He requested a df steer, but had difficulty receiving transmissions on his receiver. He subsequently received assistance & vectors toward the…
- [NTSB CHI87LA096](https://openairdocs.org/ntsb/CHI87LA096.md): Cessna 172E · Muncie, IN · Accident · No injuries · Limited investigation · Final report · Mar 16, 1987 · N7757U · Substantial damage
  > According to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…
- [NTSB CHI82DA189](https://openairdocs.org/ntsb/CHI82DA189.md): Cessna 172 · Evansville, IN · Accident · No injuries · Final report · May 28, 1982 · N2986U · 2 aircraft · Substantial damage
  > The pilots of two Cessna 172 aircraft, N73616 and N2986U, were flying in formation while on a cross-country flight. N73616 contacted Evansville approach and was cleared to intercept the 030 degree radial, outbound from Evansville, IN. As a turn was made to…
- [NTSB CHI82DA038](https://openairdocs.org/ntsb/CHI82DA038.md): Cessna 172 · Greencastle, IN · Accident · No injuries · Final report · Feb 7, 1982 · N7804U · Substantial damage
  > The student arrived at the airport on a cross-country flight and requested landing advisories on the UNICOM frequency. The student stated that somebody replied that runway 18 was in use. Before landing, the pilot overflew the airport 4 times. Two of these…
- [NTSB CHI81FET13](https://openairdocs.org/ntsb/CHI81FET13.md): Cessna 172E · Laporte, IN · Accident · Minor injuries · Closed · Sep 8, 1981 · N5508T · Substantial damage
- [NTSB CHI68F0150](https://openairdocs.org/ntsb/CHI68F0150.md): Cessna 172E · Hobart, IN · Accident · No injuries · Closed · Jul 20, 1967 · N7727U · Substantial damage
- [NTSB UNK64X3624](https://openairdocs.org/ntsb/UNK64X3624.md): Cessna 172 · Lafayette, IN · Accident · No injuries · Closed · Aug 27, 1964 · N3020U · Substantial damage
- [NTSB UNK64X1763](https://openairdocs.org/ntsb/UNK64X1763.md): Cessna 172 · Mt Vernon, IN · Accident · No injuries · Closed · May 14, 1964 · N5328T · 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 ('2072412'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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