# NTSB investigations: Cessna 172RG, 2004

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 LAX05LA027](https://openairdocs.org/ntsb/LAX05LA027.md): Cessna 172RG · Kingman, AZ · Accident · No injuries · Limited investigation · Final report · Nov 1, 2004 · N6140R · Substantial damage
  > Landing gear extension system component failure resulting in a gear up landing.
- [NTSB ATL04CA186](https://openairdocs.org/ntsb/ATL04CA186.md): Cessna 172RG · Montgomery, AL · Accident · No injuries · Data collection · Final report · Sep 15, 2004 · N948SM · Substantial damage
  > The separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.
- [NTSB LAX04LA277](https://openairdocs.org/ntsb/LAX04LA277.md): Cessna 172RG · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2004 · N5167R · Substantial damage
  > The pilot's failure to ensure that the landing gear was fully extended, by use of the emergency gear extension system, which resulted in its partial collapse during landing rollout. Also causal was the pilot's failure to follow POH procedures relating to…
- [NTSB ATL04CA145](https://openairdocs.org/ntsb/ATL04CA145.md): Cessna 172 RG · Fernandina, FL · Accident · No injuries · Data collection · Final report · Jul 8, 2004 · N6321R · Substantial damage
  > The pilot's failure to follow the checklist and lower the landing gear prior to landing.
- [NTSB ATL04IA138](https://openairdocs.org/ntsb/ATL04IA138.md): Cessna 172RG · Chamblee, GA · Incident · No injuries · Incident investigation · Final report · May 11, 2004 · N6562V · No damage
  > The fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.
- [NTSB SEA04LA033](https://openairdocs.org/ntsb/SEA04LA033.md): Cessna 172RG · Enumclaw, WA · Accident · No injuries · Limited investigation · Final report · Jan 13, 2004 · N64ML · Substantial damage
  > A loss of engine power while maneuvering due to the failure of the heads of six of the eight cam followers. Factors include the pilot's decision to keep the gear retracted during the forced landing, and the rough/uneven terrain.

## 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") = 2004
  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=2004

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