# NTSB investigations: Cessna 172A, 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 NYC87LA037](https://openairdocs.org/ntsb/NYC87LA037.md): Piper J3 · Montgomery, NY · Accident · No injuries · Limited investigation · Final report · Nov 23, 1986 · N58380 · 2 aircraft · Substantial damage
  > While taxiing in the middle of the taxiway the propeller of N58380 contacted the wing of N7416T. N58380 then rotated and it's wing contacted the wing of N7416T. N7416T was stopped alongside the taxiway when the accident occurred.
- [NTSB SEA86LA221](https://openairdocs.org/ntsb/SEA86LA221.md): Cessna 172A · San Juan Island, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1986 · N7405T · Destroyed
  > The pilot was flying the aircraft at a low altitude in order to spot fish. He ran the right fuel tank dry causing the engine to quit. He was unable to switch fuel tanks and attempt a restart due to his low altitude. A forced landing was made close to the…
- [NTSB FTW86LA155](https://openairdocs.org/ntsb/FTW86LA155.md): Cessna 172A · Gainesville, TX · Accident · No injuries · Limited investigation · Final report · Aug 25, 1986 · N7261T · Substantial damage
  > The pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…
- [NTSB LAX86LA230](https://openairdocs.org/ntsb/LAX86LA230.md): Cessna 172B · Tracy, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1986 · N7176T · Substantial damage
  > The acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…

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

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