# NTSB investigations: Cessna 172R: Miscellaneous/other

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 CEN24LA349](https://openairdocs.org/ntsb/CEN24LA349.md): Cessna 172R · Hooper, NE · Accident · No injuries · Class 4 · Limited · Final report · Jun 23, 2024 · N988CP · Substantial damage
  > The solo student pilot’s unstable approach to the runway, which resulted in a hard, bounced landing
- [NTSB GAA19CA472](https://openairdocs.org/ntsb/GAA19CA472.md): Cessna 172 · Mt. Sterling, KY · Accident · No injuries · Data collection · Final report · Jul 28, 2019 · N9548W · Substantial damage
  > The pilot's loss of directional control during the takeoff roll due to distraction by the passenger window being unsecured, which resulted in a runway excursion and impact with a runway distance marker. Contributing to the accident was pilot’s failure to…
- [NTSB GAA19CA130](https://openairdocs.org/ntsb/GAA19CA130.md): Cessna 172 · Hanover, VA · Accident · No injuries · Data collection · Final report · Feb 4, 2019 · N9525V · Substantial damage
  > The student pilot's improper decision to release the seat latch to adjust the seat position during taxi, which resulted in his inability to reach the rudder or brake pedals and a subsequent loss of directional control and impact with a ditch and fence.
- [NTSB CEN18CA323](https://openairdocs.org/ntsb/CEN18CA323.md): Cessna 172 · Greeley, CO · Accident · No injuries · Data collection · Final report · Aug 9, 2018 · N20JA · Substantial damage
  > The pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…
- [NTSB GAA18CA464](https://openairdocs.org/ntsb/GAA18CA464.md): Cessna 172 · Spring, TX · Accident · No injuries · Data collection · Final report · Jul 26, 2018 · N865CP · Substantial damage
  > The student pilot’s improper landing flare in a crosswind, which resulted in a hard landing.
- [NTSB GAA18CA276](https://openairdocs.org/ntsb/GAA18CA276.md): Cessna 172 · Batavia, OH · Accident · No injuries · Data collection · Final report · May 8, 2018 · N377ES · Substantial damage
  > The pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…
- [NTSB CEN14FA506](https://openairdocs.org/ntsb/CEN14FA506.md): Cessna 172R · Okmulgee, OK · Accident · 1 fatal · Field investigation · Final report · Sep 19, 2014 · N2435R · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.
- [NTSB CEN12CA526](https://openairdocs.org/ntsb/CEN12CA526.md): Cessna 172R · Leesville, LA · Accident · Minor injuries · Data collection · Final report · Aug 3, 2012 · N989BT · Substantial damage
  > The student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.
- [NTSB ERA12LA061](https://openairdocs.org/ntsb/ERA12LA061.md): Cessna 172R · Frederick, MD · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2011 · N212CF · Substantial damage
  > The student pilot’s inadequate directional control during the landing roll.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072401')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/900/sequence?model=2072401

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