# NTSB investigations: Cessna 172RG: Runway excursion

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 ANC18LA009](https://openairdocs.org/ntsb/ANC18LA009.md): Cessna 172RG · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Nov 16, 2017 · N6102R · Substantial damage
  > A failure of the airplane 's electrical system, which led to the failure of the landing gear system, for reasons that could not be determined because postaccident examination and testing revealed no mechanical anomalies that would have precluded normal…
- [NTSB GAA17CA372](https://openairdocs.org/ntsb/GAA17CA372.md): Cessna 172RG · El Cajon, CA · Accident · No injuries · Data collection · Final report · Jun 20, 2017 · N5424V · Substantial damage
  > The pilot's failure to extend the landing gear with sufficient time to allow the landing gear to fully extend and the flight instructor's failure to visually check to see if the right main landing gear were extended.
- [NTSB WPR16LA109](https://openairdocs.org/ntsb/WPR16LA109.md): Cessna 172RG · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · May 13, 2016 · N6281V · Substantial damage
  > The pilot's loss of directional control during the landing roll, which resulted in a runway excursion.
- [NTSB WPR14LA250](https://openairdocs.org/ntsb/WPR14LA250.md): Cessna 172RG · Alturas, CA · Accident · No injuries · Limited investigation · Final report · Jun 19, 2014 · N6091R · Substantial damage
  > The airplane’s failure to attain rotation speed during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…
- [NTSB DFW08CA227](https://openairdocs.org/ntsb/DFW08CA227.md): Cessna 172RG · Almogordo, NM · Accident · No injuries · Data collection · Final report · Sep 4, 2008 · N9783B · Substantial damage
  > The pilot's failure to extend the airplane's landing gear before landing.
- [NTSB ANC08CA071](https://openairdocs.org/ntsb/ANC08CA071.md): Cessna 172RG · Anchorage, AK · Accident · No injuries · Data collection · Final report · Jun 5, 2008 · N9752B · Substantial damage
  > The pilot's inadequate recovery from a bounced landing. Contributing to the accident was a crosswind.

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

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