# NTSB investigations: Cessna 172RG, WA

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 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 WPR13CA369](https://openairdocs.org/ntsb/WPR13CA369.md): Cessna 172RG · Kent, WA · Accident · No injuries · Data collection · Final report · Aug 8, 2013 · N4886V · Substantial damage
  > Failure of the certified flight instructor and student pilot to complete the landing checklist resulting in a gear-up landing.
- [NTSB LAX07LA215](https://openairdocs.org/ntsb/LAX07LA215.md): Cessna 172RG · Roche Harbor, WA · Accident · No injuries · Limited investigation · Final report · Jul 12, 2007 · N9551B · Substantial damage
  > The pilot's failure to perform the emergency landing gear extension procedure prior to landing. A contributing factor in the accident was the failure of the electrical system.
- [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.
- [NTSB SEA01LA168](https://openairdocs.org/ntsb/SEA01LA168.md): Cessna 172RG · Carbonado, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 2001 · N44EF · Substantial damage
  > The pilot-in-command's failure to utilize carburetor heat resulting in a loss of power and consequent descent into trees and terrain. Contributing factors were carburetor icing conditions and mountainous/hilly terrain.
- [NTSB SEA01LA071](https://openairdocs.org/ntsb/SEA01LA071.md): Cessna 172 RG · Gig Harbor, WA · Accident · No injuries · Limited investigation · Final report · Apr 14, 2001 · N9551B · Substantial damage
  > The pilot's failure to extend the airplane's landing gear while landing.
- [NTSB SEA97LA214](https://openairdocs.org/ntsb/SEA97LA214.md): Cessna 172RG · Monroe, WA · Accident · No injuries · Limited investigation · Final report · Sep 23, 1997 · N64ML · Substantial damage
  > The failure of the flight instructor to adequately perform remedial action, and her failure to abort the takeoff. Factors contributing to the accident include the premature rotation of the airplane by the dual student, the failure of the dual student to…
- [NTSB SEA87FA166](https://openairdocs.org/ntsb/SEA87FA166.md): Cessna 172RG · Kettle Falls, WA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 1987 · N9747B · Destroyed
  > While on a local personal flight, plt entered a canyon into rising terrain, colliding first with a tree and then ground near crest. Investigation revealed that acft probably had performance to clear crest had tree not been struck. Circumstances indicate plt…
- [NTSB SEA84LA051](https://openairdocs.org/ntsb/SEA84LA051.md): Cessna 172 Rgii · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N9557B · Substantial damage
  > During a takeoff after a touch and go landing the nose gear retracted at about the time of rotation. Power was reduced to idle and the acft slid to a stop. This acft is equipped with squat switches which prevent gear retraction when the weight of the acft…

## 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."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
  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&state=WA

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