# NTSB investigations: Cessna 182N, NE

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 CHI93FA165](https://openairdocs.org/ntsb/CHI93FA165.md): Cessna 182N · Genoa, NE · Accident · 3 fatal · Field investigation · Final report · May 10, 1993 · N9222G · Destroyed
  > The private pilot's failure to maintain clearance from terrain while attempting aerobatic maneuvers. The pilot's disregard for procedures/directives, and attempted aerobatics, are factors.
- [NTSB MKC84LA191](https://openairdocs.org/ntsb/MKC84LA191.md): Cessna 182N · Beaver City, NE · Accident · No injuries · Limited investigation · Final report · Jun 30, 1984 · N92522 · Destroyed
  > The acft was landed on an uncontrolled arpt toward the nnw, & after touchdown, it did not slow down adequetely. According to the plt, he elected to ground loop the acft rather than to continue off the end of the rwy. During the attempted ground loop, the acft…
- [NTSB MKC78DCJ41](https://openairdocs.org/ntsb/MKC78DCJ41.md): Cessna 182 · Aurora, NE · Accident · No injuries · Closed · Aug 15, 1978 · N8964G · Substantial damage
- [NTSB MKC74DCJ43](https://openairdocs.org/ntsb/MKC74DCJ43.md): Cessna 182N · Bassett, NE · Accident · No injuries · Closed · May 28, 1974 · N9026G · 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" = 'NE' 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 ('2072730'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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