# NTSB investigations: Cessna 182M: In flight collision with terrain/water

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 LAX05FA175](https://openairdocs.org/ntsb/LAX05FA175.md): Cessna 182M · Palm Springs, CA · Accident · 2 fatal · Field investigation · Final report · May 15, 2005 · N333LP · Destroyed
  > The pilot's inadequate in-flight planning/decision, and his failure to maintain clearance while maneuvering in rising terrain, resulting in an in-flight collision with terrain.
- [NTSB DEN99LA032](https://openairdocs.org/ntsb/DEN99LA032.md): Cessna 182M · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Jan 16, 1999 · N555NP · Destroyed
  > The pilot's poor judgment by intentionally buzzing. A factor was an unfavorable wind that caused inadequate altitude/clearance to maneuver and avoid nearby houses.
- [NTSB ATL87FA248](https://openairdocs.org/ntsb/ATL87FA248.md): Cessna 182 · Lima, OH · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1987 · N71536 · Destroyed
  > During a night flt from toledo to cincinnati, OH, the acft crashed along the route at Lima, OH, after svrl local residents heard an acft circling. Initial impact was with the top of a dike after the acft crossed over a reservoir. Wreckage was scattered over a…
- [NTSB CHI87LA073](https://openairdocs.org/ntsb/CHI87LA073.md): Cessna 182M · East Troy, WI · Accident · No injuries · Limited investigation · Final report · Feb 2, 1987 · N71383 · Substantial damage
  > The aircraft was cruising at approximately 2000 feet AGL when the engine began running rough. The plt stated that he added carburetor heat and leaned the mixture, but the engine continued to run rough. The plt elected to make a precautionary landing in an…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072728')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072728&occurrence=230

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