# NTSB investigations: Cessna 172E, 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 DEN87FA039](https://openairdocs.org/ntsb/DEN87FA039.md): Cessna 172E · Crossroads, NM · Accident · 1 fatal · Field investigation · Final report · Dec 21, 1986 · N7821U · Destroyed
  > The student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…
- [NTSB FTW87FA022](https://openairdocs.org/ntsb/FTW87FA022.md): Cessna 172C · Amarillo, TX · Accident · Minor injuries · Field investigation · Final report · Nov 27, 1986 · N7709U · 2 aircraft · Destroyed
  > The certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of…
- [NTSB LAX86LA336](https://openairdocs.org/ntsb/LAX86LA336.md): Cessna 172E · Lower Lake, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1986 · N3651S · Substantial damage
  > The airplane departed on a local sight-seeing flight at Lower Lake, California. A noncurrent commercial pilot was flying the airplane; the PIC, a current commercial pilot, was occupying the right front seat. The airplane collided with some 12-foot high…
- [NTSB ATL86LA122](https://openairdocs.org/ntsb/ATL86LA122.md): Cessna 172E · Clyde, OH · Accident · Minor injuries · Limited investigation · Final report · May 3, 1986 · N3960S · Substantial damage
  > The acft was approaching a grass airstrip when the eng quit.a landing short of the rwy in a wheat field resulted in a collapsed nose gear. Exam of the acft revealed a birds nest inside the eng cowling, a dead magneto, reversed 'p' leads, and one shorted…
- [NTSB SEA86LA103](https://openairdocs.org/ntsb/SEA86LA103.md): Cessna 172 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Apr 12, 1986 · N5786T · Substantial damage
  > The student plt lost control of the acft during high gusty wind conditions. The acft then veered to the right of the rwy. The wind at the time of the accident was from 280 degrees at 28 knots gusting to 31 knots.
- [NTSB NYC86LA062](https://openairdocs.org/ntsb/NYC86LA062.md): Cessna 172 · Durhamville, NY · Accident · No injuries · Limited investigation · Final report · Jan 16, 1986 · N5456T · Substantial damage
  > The flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…

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

This list as a web page: https://openairdocs.org/ntsb?model=2072412&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.