# NTSB investigations: Cessna 182G, 2004

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 LAX04LA299](https://openairdocs.org/ntsb/LAX04LA299.md): Cessna 182G · Big Bear City, CA · Accident · No injuries · Limited investigation · Final report · Aug 21, 2004 · N2059R · Substantial damage
  > the pilot's mistaken selection of an airport road as the landing runway. Factors in the accident were the nonstandard markings on the temporary landing surface and the glare from the setting sun.
- [NTSB ATL04LA063](https://openairdocs.org/ntsb/ATL04LA063.md): Cessna 182G · Taylorsville, NC · Accident · Minor injuries · Limited investigation · Final report · Jan 3, 2004 · N3102S · Substantial damage
  > The pilot's failure to follow the checklist, resulting in a loss of directional control on the takeoff roll when the seat moved rearward, and on ground collision with an embankment.
- [NTSB SEA04FA032](https://openairdocs.org/ntsb/SEA04FA032.md): Cessna 182G · Glasgow, MT · Accident · 4 fatal · Field investigation · Final report · Jan 2, 2004 · N3171S · Destroyed
  > Loss of aircraft control resulting in an in-flight collision with terrain. Factors include marginal weather and dark night conditions.

## 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") = 2004
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072716'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072716&year=2004

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