# NTSB investigations: Cessna 182C: Loss of control - on ground/water

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 LAX04CA183](https://openairdocs.org/ntsb/LAX04CA183.md): Cessna 182C · Garberville, CA · Accident · No injuries · Data collection · Final report · Apr 12, 2004 · N8872T · Substantial damage
  > the pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane. Factors in the accident were the terrain induced turbulent conditions, wind shear, a sudden wind shift, and a tailwind.
- [NTSB LAX93LA192](https://openairdocs.org/ntsb/LAX93LA192.md): Cessna 182C · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 25, 1993 · N8813T · Substantial damage
  > The excessive approach speed and failure of the first pilot to flare the airplane properly. A factor was the failure of the second pilot to properly supervise the flight.
- [NTSB DEN87LA108](https://openairdocs.org/ntsb/DEN87LA108.md): Cessna 182C · Conde, SD · Accident · No injuries · Limited investigation · Final report · Apr 21, 1987 · N9069T · Substantial damage
  > The private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072708')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072708&occurrence=260

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