# NTSB investigations: Cessna 182J, OK

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 FTW88LA094](https://openairdocs.org/ntsb/FTW88LA094.md): Cessna 182J · Lamont, OK · Accident · No injuries · Limited investigation · Final report · Apr 28, 1988 · N2645F · Substantial damage
  > The pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was…
- [NTSB FTW72DPJ17](https://openairdocs.org/ntsb/FTW72DPJ17.md): Cessna 182 · Walters, OK · Accident · No injuries · Closed · Oct 6, 1971 · N3528F · Substantial damage
- [NTSB FTW70D0294](https://openairdocs.org/ntsb/FTW70D0294.md): Cessna 182 · Stillwater, OK · Accident · No injuries · Closed · Nov 9, 1969 · N3328F · Substantial damage
- [NTSB FTW69D0496](https://openairdocs.org/ntsb/FTW69D0496.md): Cessna 182 · Guymon, OK · Accident · No injuries · Closed · May 2, 1969 · N3383F · Substantial damage
- [NTSB FTW69D0338](https://openairdocs.org/ntsb/FTW69D0338.md): Cessna 182 · Perry, OK · Accident · No injuries · Closed · Dec 20, 1968 · N3328F · Substantial damage
- [NTSB FTW68A0022](https://openairdocs.org/ntsb/FTW68A0022.md): Cessna 182J · Hennessey, OK · Accident · No injuries · Closed · Aug 2, 1967 · N2411Q · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=2072722&state=OK

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