# NTSB investigations: Cessna 172K: Abnormal runway contact

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 CEN23LA073](https://openairdocs.org/ntsb/CEN23LA073.md): Cessna 172K · Conway, AR · Accident · No injuries · Class 4 · Limited · Final report · Jan 1, 2023 · N7003G · Substantial damage
  > The solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing.
- [NTSB WPR21LA241](https://openairdocs.org/ntsb/WPR21LA241.md): Cessna 172 · Moose Creek Ranger Station, ID · Accident · No injuries · Class 4 · Limited · Final report · Jun 20, 2021 · N79523 · Substantial damage
  > The pilot’s improper landing flare which resulted in a bounced hard landing and subsequent nose over.
- [NTSB GAA19CA193](https://openairdocs.org/ntsb/GAA19CA193.md): Cessna 172 · Pella, IA · Accident · No injuries · Data collection · Final report · Mar 26, 2019 · N7127G · Substantial damage
  > The student pilot's failure to maintain the runway heading and the flight instructor's delayed remedial action during landing, which resulted in the instructor landing the airplane in grass left of the runway and a subsequent nose-over.
- [NTSB GAA16CA340](https://openairdocs.org/ntsb/GAA16CA340.md): Cessna 172 · Lumberton, NJ · Accident · No injuries · Data collection · Final report · May 31, 2016 · N7095G · Substantial damage
  > The pilot's hard landing, resulting in a runway excursion and substantial damage to the firewall.
- [NTSB ERA12CA404](https://openairdocs.org/ntsb/ERA12CA404.md): Cessna 172K · Tupelo, MS · Accident · No injuries · Data collection · Final report · Jun 15, 2012 · N78794 · Substantial damage
  > The pilot's improper recovery from a bounced landing.
- [NTSB CEN11CA257](https://openairdocs.org/ntsb/CEN11CA257.md): Cessna 172K · San Antonio, TX · Accident · No injuries · Data collection · Final report · Apr 1, 2011 · N79286 · Substantial damage
  > The student pilot's inadequate compensation for wind while landing in gusty wind conditions.
- [NTSB ERA11CA181](https://openairdocs.org/ntsb/ERA11CA181.md): Cessna 172K · Ocracoke, NC · Accident · Minor injuries · Data collection · Final report · Mar 5, 2011 · N84867 · Substantial damage
  > The pilot’s inadequate flare and failure to regain control of the airplane while attempting to recover from bounced landing.

## 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 ('2072430')
    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" = '090' 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/090/sequence?model=2072430

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