# NTSB investigations: Cessna 172RG: In flight collision with object

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 FTW99LA216](https://openairdocs.org/ntsb/FTW99LA216.md): Cessna 172RG · Celina, TX · Accident · No injuries · Limited investigation · Final report · Aug 7, 1999 · N9620B · Substantial damage
  > The failure of the pilot in command to use all of the available runway for takeoff.
- [NTSB FTW96LA238](https://openairdocs.org/ntsb/FTW96LA238.md): Cessna 172RG · Leadville, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 6, 1996 · N9431D · Substantial damage
  > Inadequate preflight planning and preparation and failure to follow aircraft operating procedures and directives. Factors were high density altitude, inadequate training of the flight instructor and insufficient standards and requirements for flight…
- [NTSB FTW96FA012](https://openairdocs.org/ntsb/FTW96FA012.md): Cessna 172RG · Bayfield, CO · Accident · 3 fatal · Field investigation · Final report · Oct 10, 1995 · N4834V · Destroyed
  > The pilot's failure to maintain adequate terrain clearance. A factor was the pilot diverting attention while looking for game.
- [NTSB FTW95LA281](https://openairdocs.org/ntsb/FTW95LA281.md): Cessna 172RG · Weston, TX · Accident · No injuries · Limited investigation · Final report · Jun 29, 1995 · N9502D · Substantial damage
  > The pilot receiving instruction's failure to maintain clearance with power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. A factor was the instructor's decision to allow the simulation to continue to such a low…
- [NTSB FTW93LA231](https://openairdocs.org/ntsb/FTW93LA231.md): Cessna 172RG · Salida, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 1993 · N9633B · Destroyed
  > The climb capability of the airplane being exceeded and the pilot's decision to turn into the rising terrain. A factor was the high density altitude.
- [NTSB DEN92FA077](https://openairdocs.org/ntsb/DEN92FA077.md): Cessna 172RG · Fairplay, CO · Accident · 1 fatal · Field investigation · Final report · Jul 24, 1992 · N4963R · Destroyed
  > The flight instructor's operation at an altitude insufficient to clear obstacles in rising mountainous terrain. Factors were: high density altitude, diversion of the instructor's attention, and the rising terrain.
- [NTSB LAX90LA236](https://openairdocs.org/ntsb/LAX90LA236.md): Cessna 172RG · Concord, CA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1990 · N5388R · Substantial damage
  > The student pilot's initiating an excessive descent and the cfi's inadequate remedial action.
- [NTSB SEA82DA033](https://openairdocs.org/ntsb/SEA82DA033.md): Cessna 172RG · Plush, OR · Accident · No injuries · Final report · Mar 7, 1982 · N6247R · Substantial damage
  > The pilot departed lakeview, Oregon on a local flight with two passengers on board. After a stopover at a private airstrip, he began a short field takeoff from a grass/gravel/dirt runway that was 2500 ft in length. The density altitude was approximately 4600…

## 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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