# NTSB investigations: Cessna 172RG, 1997

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 LAX98LA036](https://openairdocs.org/ntsb/LAX98LA036.md): Cessna 172RG · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1997 · N9451D · Substantial damage
  > Overload of the main gear actuator piston and the subsequent collapse of the landing gear.
- [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 LAX97LA297](https://openairdocs.org/ntsb/LAX97LA297.md): Cessna 172RG · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · Aug 21, 1997 · N9710B · Substantial damage
  > Improper flare.
- [NTSB NYC97LA158](https://openairdocs.org/ntsb/NYC97LA158.md): Cessna 172 RG · Quinton, VA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1997 · N9647B · Substantial damage
  > The pilot's failure to identify an unsafe landing gear condition. A factor in the accident was the loss of electrical power.
- [NTSB CHI97LA180](https://openairdocs.org/ntsb/CHI97LA180.md): Cessna 172RG · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Jun 22, 1997 · N6280R · Substantial damage
  > the pilot inadvertently executed a wheels up landing.
- [NTSB FTW97LA197](https://openairdocs.org/ntsb/FTW97LA197.md): Cessna 172RG · Rio Hondo, TX · Accident · Minor injuries · Limited investigation · Final report · May 22, 1997 · N9492D · Destroyed
  > failure of the pilot to use all of the available runway during landing, and his resultant failure to attain a proper touchdown point for a safe rollout. Factors relating to the accident were: the wet runway with hydroplaning conditions, the uneven terrain…
- [NTSB FTW97FA181](https://openairdocs.org/ntsb/FTW97FA181.md): Cessna 172RG · Intracoastal, LA · Accident · 1 fatal · Field investigation · Final report · May 8, 1997 · N6505V · Destroyed
  > the pilot's decision to fly, when he was not in good physical condition; and his subsequent loss of aircraft control due to incapacitation. A related factor was: the pilot's perception of an urgency (pressure) to fly, induced by conditions/events.
- [NTSB LAX97LA095](https://openairdocs.org/ntsb/LAX97LA095.md): Cessna 172RG · Corona, CA · Accident · No injuries · Limited investigation · Final report · Jan 28, 1997 · N80138 · Substantial damage
  > Failure of the pilot in command to follow the airplane's before landing checklist and verify the landing gear was fully extended before landing. Factors in the accident were anxiety and diversion of the pilot's attention due to fuel gauge readings.

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

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