# NTSB investigations: Cessna 172G, 1985

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 MKC85LA203](https://openairdocs.org/ntsb/MKC85LA203.md): Cessna 172G · Deepwater, MO · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N3943L · Substantial damage
  > The acft was crusing at 2,000 ft, 50 min after takeoff when the eng began running rough, lost RPM, and then quit. The plt made a forced landing in a small fld and the collided with trees during the landing roll. The investigation, which included running the…
- [NTSB CHI85FA316](https://openairdocs.org/ntsb/CHI85FA316.md): Cessna 172G · Plain City, OH · Accident · 1 fatal · Field investigation · Final report · Jul 29, 1985 · N4202L · Destroyed
  > The plt had just taken off from his pvt strip for the fourth flt of the day when witnesses heard the eng quit. The acft had been flown 3.4 hrs since the last refueling. The acft was being operated on a mixture of avgas and automotive fuel with no STC. The…
- [NTSB LAX85LA189](https://openairdocs.org/ntsb/LAX85LA189.md): Cessna 172G · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Mar 27, 1985 · N3757L · Substantial damage
  > Instructor plt stated that prior to departure for Show Low he called the fixed base operator at Show Low and learned the winds were currently from 190 to 200 degrees a 20 T0 30 knots. He and his student departed and upon arriving in the Show Low area learned…
- [NTSB LAX85LA149](https://openairdocs.org/ntsb/LAX85LA149.md): Cessna 172G · Mojave, CA · Accident · No injuries · Limited investigation · Final report · Feb 20, 1985 · N1112F · Substantial damage
  > Prior to landing the plt was advised of wind gusts as high as 68 KTS. Plt landed & while taxiing to the ramp a gust of wind was experienced which blew the acft over to an inverted position.

## 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") = 1985
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072420'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072420&year=1985

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