# NTSB investigations: Cessna 195A, 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 ANC86LA164](https://openairdocs.org/ntsb/ANC86LA164.md): Cessna 195A · Willow, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1986 · N9342A · Substantial damage
  > The pilot reported that while demonstrating high speed taxi, the airplane veered to the left, entered an open trench, and was damaged. An exam of the flight control and brake systems revealed no pre-accident mechanical malfunction or failure.
- [NTSB MIA86LA206](https://openairdocs.org/ntsb/MIA86LA206.md): Cessna 195A · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N2187C · Substantial damage
  > The plt stated that the left main gear collapsed while he was trying to recover from a 45 degree swerve to the right during lanidng.
- [NTSB LAX86LA189](https://openairdocs.org/ntsb/LAX86LA189.md): Cessna 195A · San Rafael, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 1986 · N4496C · 2 aircraft · Substantial damage
  > The two aircraft collided on the runway during landing approach. The Cessna pilot had washed his aircraft and had made a local flight to dry it off. The beeck pilot was returning from a nearby airport where an annual inspection had been performed. Witnesses…
- [NTSB SEA86FA052](https://openairdocs.org/ntsb/SEA86FA052.md): Cessna 195 · Black Diamond, WA · Accident · 1 fatal · Field investigation · Final report · Feb 1, 1986 · N4339N · Destroyed
  > Radar track shows C195 plt was descending into congested airspace at about 192 mph, above max structural cruise speed of 178 mph, less than 1 min from traffic pattern entry. Radar data and witness confirm a second acft in proximity, engaged in aerobatics.…

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

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