# NTSB investigations: Cessna 172RG, 2017

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 GAA18CA013](https://openairdocs.org/ntsb/GAA18CA013.md): Cessna 172RG · Auburn, WA · Accident · No injuries · Data collection · Final report · Oct 15, 2017 · N5159U · Substantial damage
  > The failure of the right main landing gear for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [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 CEN17IA155](https://openairdocs.org/ntsb/CEN17IA155.md): Cessna 172RG · Greeley, CO · Incident · No injuries · Incident investigation · Final report · Mar 20, 2017 · N6402V · Minor damage
  > Failure of the left main landing gear actuator assembly, which resulted in an inability to extend the left main landing gear.

## 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 year(c."eventDate") = 2017
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072438'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072438&year=2017

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