# NTSB investigations: Cessna TR182, OR

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 SEA08LA156](https://openairdocs.org/ntsb/SEA08LA156.md): Cessna TR182 · Bend, OR · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2008 · N7XZ · Substantial damage
  > The failure of the crankshaft during cruise flight due to fatigue.
- [NTSB SEA92LA123](https://openairdocs.org/ntsb/SEA92LA123.md): Cessna TR182 · Baker, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1992 · N6138S · Substantial damage
  > The pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.
- [NTSB SEA87FA185](https://openairdocs.org/ntsb/SEA87FA185.md): Cessna TR182 · Tillamook, OR · Accident · 2 fatal · Field investigation · Final report · Sep 10, 1987 · N9484R · Destroyed
  > Drg arrival, the plt was cleared for an ndb-a apch & received approval to change to the local adzy freq. After that, there was no further radio comm with the acft. Radar data showed the acft crossed over the initial apch fix (iaf) & began a rgt outbound turn…

## 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 c."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA'
  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&state=OR

---
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.