# NTSB investigations: Cessna 182E, 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 MIA87LA037](https://openairdocs.org/ntsb/MIA87LA037.md): Cessna 182E · Chiefland, FL · Accident · No injuries · Limited investigation · Final report · Nov 26, 1986 · N2945Y · Substantial damage
  > The plt stated that he was on final apch & attempted to go around due to gusting winds. He applied power, the eng quit & he collided with the trees at the end of the rwy. No determination could be made as to the malfunction of the eng as described by the plt.
- [NTSB NYC87FA020](https://openairdocs.org/ntsb/NYC87FA020.md): Cessna 182E · Fishers Island, NY · Accident · 2 fatal · Field investigation · Final report · Oct 16, 1986 · N2830Y · 2 aircraft · Destroyed
  > A Cessna 182 taking off on rwy 25 collided with a Piper PA-28-181 which was landing on rwy 12. The collision occured in the intersection of the two runways. The two occupants of the Cessna were seriously injured and the two occupants of the Piper were fatally…
- [NTSB MIA86LA162](https://openairdocs.org/ntsb/MIA86LA162.md): Cessna 182E · Crystal River, FL · Accident · No injuries · Limited investigation · Final report · May 17, 1986 · N9218X · Substantial damage
  > The plt stated that just before descent he pushed the propeller control full forward, experienced a runaway prop and lost oil pressure. Moments later a connecting rod failure was experienced and an emergency landing was executed in amarshy area northwest of…

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

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