# NTSB investigations: Cessna 182S, NC

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 ERA19FA113](https://openairdocs.org/ntsb/ERA19FA113.md): Cessna 182 · Louisburg, NC · Accident · 3 fatal · Field investigation · Final report · Mar 2, 2019 · N26617 · Destroyed
  > The pilot's spatial disorientation and loss of airplane control following takeoff in night instrument meteorological conditions.
- [NTSB ERA11FA412](https://openairdocs.org/ntsb/ERA11FA412.md): Cessna 182S · Erwin, NC · Accident · 2 fatal · Field investigation · Final report · Jul 21, 2011 · N23739 · Substantial damage
  > The pilot’s loss of control due to spatial disorientation while maneuvering in dark night conditions.
- [NTSB MIA01LA160](https://openairdocs.org/ntsb/MIA01LA160.md): Cessna 182S · Corolla, NC · Accident · No injuries · Limited investigation · Final report · Jun 12, 2001 · N314FR · Substantial damage
  > The pilots failure to maintain directional control during landing flare and touchdown resulting in the airplane touching down on the left side of the runway and the left wing contacting trees.

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

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

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