# NTSB investigations: Cessna 172S, OH

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 WPR18LA207](https://openairdocs.org/ntsb/WPR18LA207.md): Cessna 172 · Mount Vernon, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 28, 2018 · N785SP · Destroyed
  > An in-flight fuel-fed fire from an unknown source for reasons that could not be determined due to the extensive fire damage to the airplane.
- [NTSB GAA18CA425](https://openairdocs.org/ntsb/GAA18CA425.md): Cessna 172 · Batavia, OH · Accident · No injuries · Data collection · Final report · Jul 13, 2018 · N12064 · Substantial damage
  > The student pilot’s improper landing flare, which resulted in a hard landing.
- [NTSB GAA18CA150](https://openairdocs.org/ntsb/GAA18CA150.md): Cessna 172 · Kent, OH · Accident · No injuries · Data collection · Final report · Mar 7, 2018 · N103KS · Substantial damage
  > A deer collided with aircraft during landing at night.
- [NTSB CEN17LA311](https://openairdocs.org/ntsb/CEN17LA311.md): Cessna 172S · Wellston, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 2017 · N5274Q · Substantial damage
  > The failure of a connecting rod small end bushing, which resulted in a loss of engine power.
- [NTSB GAA17CA337](https://openairdocs.org/ntsb/GAA17CA337.md): Cessna 172 · Ravenna, OH · Accident · No injuries · Data collection · Final report · Jun 11, 2017 · N33FM · Substantial damage
  > The flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…
- [NTSB GAA15CA237](https://openairdocs.org/ntsb/GAA15CA237.md): Cessna 172 · Springfield, OH · Accident · No injuries · Data collection · Final report · Aug 23, 2015 · N691SP · Substantial damage
  > The pilot's improper pitch control during landing, which resulted in a hard landing.
- [NTSB CEN09CA509](https://openairdocs.org/ntsb/CEN09CA509.md): Cessna 172S · Bluffton, OH · Accident · No injuries · Data collection · Final report · Aug 6, 2009 · N6186T · Substantial damage
  > The student pilot's failure to compensate for wind conditions and maintain aircraft control during the landing.
- [NTSB CHI07CA308](https://openairdocs.org/ntsb/CHI07CA308.md): Cessna 172 SP · Heath, OH · Accident · No injuries · Data collection · Final report · Sep 29, 2007 · N2327J · Substantial damage
  > The improper flare and inadequate recovery from a bounced landing by the student pilot. A factor was the student pilot's lack of experience.
- [NTSB CHI06CA183](https://openairdocs.org/ntsb/CHI06CA183.md): Cessna 172S · Baltimore, OH · Accident · No injuries · Data collection · Final report · Jul 9, 2006 · N335SP · Substantial damage
  > The pilot's failure to attain sufficient airspeed during the takeoff which resulted in the inadvertent stall and collision with the ground.
- [NTSB NYC04CA206](https://openairdocs.org/ntsb/NYC04CA206.md): Cessna 172S · Mount Gilead, OH · Accident · No injuries · Data collection · Final report · Sep 6, 2004 · N809SP · Substantial damage
  > The pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.
- [NTSB IAD03CA071](https://openairdocs.org/ntsb/IAD03CA071.md): Cessna 172 · Cleveland, OH · Accident · No injuries · Data collection · Final report · Aug 19, 2003 · N229ME · Substantial damage
  > The pilot's improper flare, which resulted in a hard landing.
- [NTSB IAD03CA044](https://openairdocs.org/ntsb/IAD03CA044.md): Cessna 172S · Cleveland, OH · Accident · No injuries · Data collection · Final report · Mar 27, 2003 · N613SP · Substantial damage
  > The student pilot's improper flare, which resulted in a hard landing.
- [NTSB NYC03LA032](https://openairdocs.org/ntsb/NYC03LA032.md): Cessna 172S · Akron, OH · Accident · No injuries · Limited investigation · Final report · Dec 26, 2002 · N782SP · Substantial damage
  > The pilot's improper flare which resulted in a hard landing.
- [NTSB CHI79FEI22](https://openairdocs.org/ntsb/CHI79FEI22.md): N American SNJ-4 · Painesville, OH · Accident · No injuries · Closed · May 6, 1979 · N5278N · 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" = 'OH' 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 ('2072439', '2072442'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.