# NTSB investigations: Cessna 172G: Loss of control on ground

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 WPR25LA098](https://openairdocs.org/ntsb/WPR25LA098.md): Cessna 172 · Oxnard, CA · Accident · No injuries · Class 4 · Limited · Final report · Feb 18, 2025 · N3901L · Substantial damage
  > The student pilot’s failure to maintain directional control during landing roll.
- [NTSB CEN24LA266](https://openairdocs.org/ntsb/CEN24LA266.md): Cessna 172G · West Bend, WI · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 13, 2024 · N129GW · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll.
- [NTSB WPR21LA100](https://openairdocs.org/ntsb/WPR21LA100.md): Cessna 172G · Kelso, WA · Accident · No injuries · Class 4 · Limited · Final report · Jan 14, 2021 · N5930R · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose over.
- [NTSB GAA19CA267](https://openairdocs.org/ntsb/GAA19CA267.md): Cessna 172 · Manvel, TX · Accident · Minor injuries · Data collection · Final report · May 15, 2019 · N5788R · Substantial damage
  > The pilot's failure to maintain directional control during landing with a crosswind, which resulted in impact with a ditch.
- [NTSB GAA18CA170](https://openairdocs.org/ntsb/GAA18CA170.md): Cessna 172 · Vernon, TX · Accident · No injuries · Data collection · Final report · Mar 19, 2018 · N1103F · Substantial damage
  > The pilot's failure to maintain directional control while landing in gusty crosswind conditions.
- [NTSB GAA17CA380](https://openairdocs.org/ntsb/GAA17CA380.md): Cessna 172 · Tucson, AZ · Accident · No injuries · Data collection · Final report · Jul 2, 2017 · N4482L · Substantial damage
  > The pilot’s failure to maintain pitch and yaw control during the landing roll in crosswind conditions.
- [NTSB GAA16CA111](https://openairdocs.org/ntsb/GAA16CA111.md): Cessna 172 · Covington, TN · Accident · No injuries · Data collection · Final report · Nov 22, 2015 · N5786R · Substantial damage
  > The pilot's loss of directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, ground loop, and impact with the ground.

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

This list as a web page: https://openairdocs.org/ntsb-events/230/cases?model=2072420

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