# NTSB investigations: Cessna 182A, 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 CHI04LA001](https://openairdocs.org/ntsb/CHI04LA001.md): Cessna 182A · Shenandoah, IA · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 2003 · N3772D · Substantial damage
  > Loss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.
- [NTSB CHI94LA057](https://openairdocs.org/ntsb/CHI94LA057.md): Cessna 182 · Centerville, IA · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 1993 · N4791D · Substantial damage
  > the pilot's failure to refuel the airplane during the flight. Factors related to the accident were the inaccurate fuel consumption calculations for the airplane and the fence.
- [NTSB MKC86LA145](https://openairdocs.org/ntsb/MKC86LA145.md): Cessna 182A · Davis City, IA · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N4773D · Substantial damage
  > Statements from FAA flight service station personnel indicate that the pilot received a weather briefing prior to departure but that a flight plan was not filed for the 600 mile trip. Records show that the flt lasted 05:28 hours before the engine sputtered…
- [NTSB MKC86FA048](https://openairdocs.org/ntsb/MKC86FA048.md): Cessna 182A · Clinton, IA · Accident · 1 fatal · Field investigation · Final report · Jan 10, 1986 · N3948D · Destroyed
  > The pilot normally made several touch and go landings before departing the local area. He was known to not fly near clouds or at night. For this flight, the ceiling was at least 1000 feet at takeoff and was at least 700 feet in the accident area. Airplane was…
- [NTSB MKC71DCD48](https://openairdocs.org/ntsb/MKC71DCD48.md): Cessna 182A · Fairfield, IA · Accident · No injuries · Closed · Jan 1, 1971 · N4749D · Substantial damage
- [NTSB MKC67D0601](https://openairdocs.org/ntsb/MKC67D0601-116054.md): Cessna 182A · Ottumwa, IA · Accident · No injuries · Closed · May 31, 1967 · N2187G · Substantial damage
- [NTSB MKC67F0146](https://openairdocs.org/ntsb/MKC67F0146.md): Cessna 182A · Mason City, IA · Accident · Minor injuries · Closed · Aug 2, 1966 · N5183D · Substantial damage
- [NTSB UNK64X3917](https://openairdocs.org/ntsb/UNK64X3917.md): Cessna 182 · Lemars, IA · Accident · No injuries · Closed · Sep 11, 1964 · N5113D · Substantial damage
- [NTSB UNK64X0863](https://openairdocs.org/ntsb/UNK64X0863.md): Cessna 182A · Martinsdale, IA · Accident · No injuries · Closed · Mar 9, 1964 · N5905B · 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" = '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 ('2072704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072704&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.