# NTSB investigations: Cessna TR182, 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 LAX86LA332](https://openairdocs.org/ntsb/LAX86LA332.md): Cessna TR182RG · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Aug 26, 1986 · N738WQ · Substantial damage
  > The plt was unable to fully extend the landing gear and the acft collided with the surface of rwy 30R during landing. Post accident inspection revealed the gear down hose assembly was ruptured thus allowing for a loss of hydraulic fluid.
- [NTSB DEN86FA208](https://openairdocs.org/ntsb/DEN86FA208.md): Piper PA-46-310P · Boulder, CO · Accident · 1 fatal · Field investigation · Final report · Jul 26, 1986 · N4346L · 2 aircraft · Destroyed
  > The purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a…
- [NTSB SEA86FA047](https://openairdocs.org/ntsb/SEA86FA047.md): Cessna TR182RG · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Jan 27, 1986 · N2341S · Destroyed
  > The pilot was flying his Cessna TR182RG back to Reno cannon airport, a facility with a frequent mixture of light general aviation aircraft and heavy turbine air carrier operations. The pilot had acquired the majority of his terminal experience in and around…

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

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