# NTSB investigations: Cessna 172RG: Landing gear collapse

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 GAA22WA304](https://openairdocs.org/ntsb/GAA22WA304.md): Cessna 172RG · Paderborn, Germany · Accident · No injuries · Class 5 · Foreign · Feb 12, 2022 · N16ED · Substantial damage
- [NTSB ERA21LA219](https://openairdocs.org/ntsb/ERA21LA219.md): Cessna 172RG · Miami, FL · Accident · No injuries · Class 4 · Limited · Final report · May 8, 2021 · N9795B · Substantial damage
  > The collapse of the left main landing gear for reasons that could not be determined.
- [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.
- [NTSB ERA11LA231](https://openairdocs.org/ntsb/ERA11LA231.md): Cessna 172RG · Okeechobee, FL · Accident · No injuries · Limited investigation · Final report · Apr 6, 2011 · N5284V · Substantial damage
  > The failure of the main landing gear to lock in the extended position for undetermined reasons and both pilots’ failure to ensure that the landing gear was down and locked prior to 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 ('2072438')
    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" = '094'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/094/cases?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.