# NTSB investigations: Cessna 182C, IL

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 CHI08CA255](https://openairdocs.org/ntsb/CHI08CA255.md): Cessna 182C · Sparta, IL · Accident · No injuries · Data collection · Final report · Aug 16, 2008 · N8643T · Substantial damage
  > The pilot's inadequate preflight/planning which resulted in the failure to assure an adequate fuel supply for the flight and the improper flare during the landing. Contributing to the accident was the ditch that the airplane contacted.
- [NTSB CHI99LA139](https://openairdocs.org/ntsb/CHI99LA139.md): Cessna 182C · Loraine, IL · Accident · No injuries · Limited investigation · Final report · May 2, 1999 · N8563T · Destroyed
  > A fuel system related fire in the engine compartment.
- [NTSB CHI81FEV25](https://openairdocs.org/ntsb/CHI81FEV25.md): Cessna 182C · Beardstown, IL · Accident · No injuries · Closed · Jul 16, 1981 · N9060T · Substantial damage
- [NTSB CHI74FEE72](https://openairdocs.org/ntsb/CHI74FEE72.md): Cessna 182 · Lansing, IL · Accident · Minor injuries · Closed · May 4, 1974 · N8797T · Substantial damage
- [NTSB CHI65F0083](https://openairdocs.org/ntsb/CHI65F0083.md): Cessna 182 · Peoria, IL · Accident · 1 fatal · Closed · Jan 10, 1965 · N8476T · Destroyed

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

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

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