# NTSB investigations: Cessna R182, 2009

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 ERA09FA411](https://openairdocs.org/ntsb/ERA09FA411.md): Cessna R182 · Hayesville, NC · Accident · 1 fatal · Field investigation · Final report · Jul 17, 2009 · N778RK · Destroyed
  > Flight into terrain for undetermined reasons.
- [NTSB CEN09FA369](https://openairdocs.org/ntsb/CEN09FA369.md): Cessna R182 · Dougherty, TX · Accident · 2 fatal · Field investigation · Final report · Jun 19, 2009 · N182GT · Destroyed
  > The pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…
- [NTSB CEN09CA245](https://openairdocs.org/ntsb/CEN09CA245.md): Cessna R182 · Granger, TX · Accident · No injuries · Data collection · Final report · Apr 11, 2009 · N756BZ · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight.

## 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") = 2009
  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&year=2009

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