# NTSB investigations: Cessna 182F, ID

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 WPR23LA237](https://openairdocs.org/ntsb/WPR23LA237.md): Cessna 182F · Idaho Falls, ID · Accident · No injuries · Class 4 · Limited · Final report · Jun 21, 2023 · N3531Y · Substantial damage
  > The pilot’s failure to maintain directional control while landing with a gusting crosswind.
- [NTSB SEA92LA192](https://openairdocs.org/ntsb/SEA92LA192.md): Cessna 182F · Blackfoot, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 30, 1992 · N3545Y · Substantial damage
  > The pilot's failure to use proper airspeed for takeoff, resulting in loss of control during initial climb. Factors relating to the accident were the high da weather conditions, power line obstructions and a highway with a dirt bank at the end of the runway.
- [NTSB SEA75DYG14](https://openairdocs.org/ntsb/SEA75DYG14.md): Cessna 182 · Lewiston, ID · Accident · No injuries · Closed · Nov 28, 1974 · N3589Y · Substantial damage
- [NTSB SEA74AS007](https://openairdocs.org/ntsb/SEA74AS007.md): Cessna 182 · Salmon, ID · Accident · 4 fatal · Closed · Aug 19, 1973 · N3280U · Destroyed
- [NTSB SEA68D0023](https://openairdocs.org/ntsb/SEA68D0023.md): Cessna 182 · Elk River, ID · Accident · No injuries · Closed · Jun 24, 1967 · N3200U · Substantial damage
- [NTSB UNK64X2836](https://openairdocs.org/ntsb/UNK64X2836.md): Cessna 182 · Cascade, ID · Accident · Serious injuries · Closed · Jul 14, 1964 · N3443U · Substantial damage

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

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

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