# NTSB investigations: Cessna 182J, IA

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 CEN09LA491](https://openairdocs.org/ntsb/CEN09LA491.md): Cessna 182J · Iowa Falls, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2009 · N989TP · 2 aircraft · Substantial damage
  > Both pilots' failure to execute adequate visual lookout, resulting in the two airplanes colliding over the runway.
- [NTSB CHI96LA080](https://openairdocs.org/ntsb/CHI96LA080.md): Cessna 182J · Waukon, IA · Accident · No injuries · Limited investigation · Final report · Jan 9, 1996 · N2916F · Substantial damage
  > the pilot's inadequate preflight planning/preparation, and his failure to maintain directional control while taxiing. Factors in the accident were the icy runway and the gusty wind conditions.
- [NTSB MKC74DCD02](https://openairdocs.org/ntsb/MKC74DCD02.md): Cessna 182 · Waterloo, IA · Accident · No injuries · Closed · Jul 15, 1973 · N2612F · Substantial damage
- [NTSB MKC73DCD34](https://openairdocs.org/ntsb/MKC73DCD34.md): Cessna 182 · West Union, IA · Accident · No injuries · Closed · Oct 4, 1972 · N3056F · Substantial damage
- [NTSB MKC72DCD60](https://openairdocs.org/ntsb/MKC72DCD60.md): Cessna 182 · Sioux City, IA · Accident · No injuries · Closed · Feb 5, 1972 · N2720F · Substantial damage
- [NTSB MKC71DCD47](https://openairdocs.org/ntsb/MKC71DCD47.md): Cessna 182J · Mason City, IA · Accident · Serious injuries · Closed · Dec 27, 1970 · N2857F · No damage
- [NTSB MKC71FCD41](https://openairdocs.org/ntsb/MKC71FCD41.md): Cessna 182J · Oskaloosa, IA · Accident · Minor injuries · Closed · Dec 18, 1970 · N3136F · Substantial damage
- [NTSB MKC70DCD04](https://openairdocs.org/ntsb/MKC70DCD04.md): Cessna 182J · Traer, IA · Accident · No injuries · Closed · Jan 14, 1970 · N2773F · Substantial damage
- [NTSB MKC69D0252](https://openairdocs.org/ntsb/MKC69D0252.md): Cessna 182 · Amana, IA · Accident · No injuries · Closed · Oct 31, 1968 · N3056F · Substantial damage
- [NTSB MKC69D0140](https://openairdocs.org/ntsb/MKC69D0140.md): Cessna 182 · Iowa City, IA · Accident · No injuries · Closed · Aug 4, 1968 · N3042F · Substantial damage
- [NTSB MKC68F0048](https://openairdocs.org/ntsb/MKC68F0048.md): Cessna 182 · Grimes, IA · Accident · Serious injuries · Closed · Jun 28, 1967 · N3449F · Substantial damage
- [NTSB MKC67F0282](https://openairdocs.org/ntsb/MKC67F0282.md): Cessna 182J · Waterloo, IA · Accident · Serious injuries · Closed · Nov 2, 1966 · N2905F · No 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" = 'IA' 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 ('2072722'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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