# NTSB investigations: Cessna 172RG, 1986

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 CHI87LA051](https://openairdocs.org/ntsb/CHI87LA051.md): Cessna 172RG · Bloominton, IN · Accident · Serious injuries · Limited investigation · Final report · Dec 18, 1986 · N9603B · Destroyed
  > According to the pilot he was cleared for the ILS approach and followed his glideslope and localizer indications in a normal manner. He eventually saw the ground prior to reaching his decision height of approx 200 feet AGL. This sighting of the ground was the…
- [NTSB ANC86LA131](https://openairdocs.org/ntsb/ANC86LA131.md): Cessna 172RGII · Kotlik, AK · Accident · No injuries · Limited investigation · Final report · Aug 19, 1986 · N4856V · Substantial damage
  > The pilot stated on approach he spotted what appeared to be the airport from several miles off. Instead of landing at the airport, he landed at a gravel bar. After touchdown the pilot lost control of the aircraft and the aircraft nosed over on its back.
- [NTSB MIA86LA169](https://openairdocs.org/ntsb/MIA86LA169.md): Cessna 172RG · Jackson, MS · Accident · No injuries · Limited investigation · Final report · May 24, 1986 · N4596V · Substantial damage
  > The plt stated that she intentionally landed gear up because the nose wheel well doors were jammed closed and would not allow the gear to completely lock down. Examination of the nose landing gear revealed that the nose gear up stop bumper plate assembly fell…

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

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