# NTSB investigations: Cessna 182N, 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 LAX86FA326](https://openairdocs.org/ntsb/LAX86FA326.md): Cessna 182N · Wilmington, CA · Accident · Serious injuries · Field investigation · Final report · Aug 20, 1986 · N92252 · Destroyed
  > During a local night instructional flt the plts reported that the eng began to run very rough and eventually quit when power was reduced slightly to begin the descent for the destination arpt. The acft struck power lines, two small buildings and a brick wall…
- [NTSB BFO86FA016](https://openairdocs.org/ntsb/BFO86FA016.md): Cessna 182R · Manassas, VA · Accident · Minor injuries · Field investigation · Final report · Mar 1, 1986 · N9962H · Destroyed
  > Witnesses observed black smoke trailing from the aircraft shortly after liftoff and continue until ground impact. The pilot indicated that he first noticed an engine roughness about 100-200 feet in the air and thought it was similar to an engine that was…

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

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