# NTSB investigations: Cessna R172K: In flight collision with terrain/water

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 LAX97FA225](https://openairdocs.org/ntsb/LAX97FA225.md): Cessna R172K · Moreno Valley, CA · Accident · 2 fatal · Field investigation · Final report · Jun 28, 1997 · N7373K · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, and his attempt to climb through a low stratus cloud layer while in mountainous/hilly terrain. The pilot's failure to obtain a weather briefing, the weather, and the terrain were…
- [NTSB LAX96LA247](https://openairdocs.org/ntsb/LAX96LA247.md): Cessna R172K · Oroville, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 1996 · N1133V · Substantial damage
  > undetermined.
- [NTSB LAX90LA271](https://openairdocs.org/ntsb/LAX90LA271.md): Cessna R172K · Lone Pine, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 14, 1990 · N758UV · Destroyed
  > The pilot's decision to continue VFR flight into instrument meteorological conditions. Factors to the accident were the adverse weather conditions, mountainous terrain, and the likely effect of hypoxia on the pilot.
- [NTSB MKC88LA100](https://openairdocs.org/ntsb/MKC88LA100.md): Cessna 172K · Bismark, MO · Accident · Serious injuries · Limited investigation · Final report · May 29, 1988 · N8122V · Substantial damage
  > The accident aircraft was observed making several low passes over lake Bismark near Bismark, Missouri. Witnesses stated that, following the last pass, the aircraft contacted the water and sank. The pilot's blood alcohol content was analyzed as.14 percent…
- [NTSB NYC85LA111](https://openairdocs.org/ntsb/NYC85LA111.md): Cessna R172K · Glen Campbell, PA · Accident · No injuries · Limited investigation · Final report · May 10, 1985 · N736FG · Substantial damage
  > During flt, the plt flew over svrl coal strip mines at low alt & at low airspeed. He had the acft trimmed for 60 KTS & had one notch of flaps extended. He reported that as he was flying in straight & level flt, the acft seemed to be drawn down into a valley.…
- [NTSB DEN82DA025](https://openairdocs.org/ntsb/DEN82DA025.md): Cessna 172 · Near Gillete, WY · Accident · No injuries · Final report · Jan 29, 1982 · N758RD · Substantial damage
  > The purpose of the flight was to make an aerial survey for livestock. During flight, the observer noted some cattle in a cove. The pilot then turned and descended to about 100 feet AGL. After leveling, he noted that he would have to climb or turn to avoid…

## 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 ('2072431')
    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" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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