# NTSB investigations: Cessna 182S, 2001

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 LAX02LA021](https://openairdocs.org/ntsb/LAX02LA021.md): Cessna 182S · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Nov 6, 2001 · N2453A · Substantial damage
  > The failure of the pilot-in-command to maintain directional control of the airplane after encountering a dust devil during landing roll.
- [NTSB LAX02FA019](https://openairdocs.org/ntsb/LAX02FA019.md): Cessna 182S · Little River, CA · Accident · 1 fatal · Field investigation · Final report · Nov 1, 2001 · N7270E · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with trees and terrain.
- [NTSB IAD01LA074](https://openairdocs.org/ntsb/IAD01LA074.md): Cessna 182S · Montgomery, NY · Accident · No injuries · Limited investigation · Final report · Jul 2, 2001 · N2437P · Substantial damage
  > The pilot's improper flare, and improper recovery from a bounced landing.
- [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 year(c."eventDate") = 2001
  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&year=2001

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