# NTSB investigations: Cessna R182, 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 CEN21LA218](https://openairdocs.org/ntsb/CEN21LA218.md): Cessna R182 · Tulsa, OK · Accident · No injuries · Class 4 · Limited · Final report · May 13, 2021 · N8051B · Substantial damage
  > The pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…
- [NTSB DFW06LA191](https://openairdocs.org/ntsb/DFW06LA191.md): Cessna R182 · McAlester, OK · Accident · No injuries · Limited investigation · Final report · Jul 25, 2006 · N7364T · Destroyed
  > The in-flight fuel leak and fire as result of electrical arcing of a fuel line connecting the engine driven fuel pump and the electric fuel pump.
- [NTSB FTW87LA118](https://openairdocs.org/ntsb/FTW87LA118.md): Cessna 182 · Nowatta, OK · Accident · Minor injuries · Limited investigation · Final report · May 12, 1987 · N9845C · Substantial damage
  > During takeoff, the pilot reduced power and attempted to climb. When the aircraft would not respond, the pilot applied full power and raised the flaps. The aircraft settled back down nose high, contacting a fence and subsequently the ground, substantially…

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

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