# NTSB investigations: Cessna 182H: 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 CHI96LA115](https://openairdocs.org/ntsb/CHI96LA115.md): Cessna 182H · East Jordan, MI · Accident · 1 fatal · Limited investigation · Final report · Mar 23, 1996 · N8427S · Destroyed
  > the pilot's failure to maintain clearance with the terrain during the landing. Factors related to the accident were the snow covered ice pile at the end of the runway and the pilot's perception of the height of the pile.
- [NTSB LAX94LA003](https://openairdocs.org/ntsb/LAX94LA003.md): Cessna 182H · Clear Lake Res, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 1, 1993 · N8397S · Substantial damage
  > Failure of the pilot to maintain altitude, while performing a low-altitude maneuver (turn) over water. Factors related to the accident were: sun glare, haze, glassy condition of the water, and the lack of visual cues (visual perception) for the pilot to judge…
- [NTSB SEA91FA120](https://openairdocs.org/ntsb/SEA91FA120.md): Cessna 182H · Thompson, UT · Accident · 1 fatal · Field investigation · Final report · Dec 19, 1990 · N2466X · Destroyed
  > The pilot's misjudged descent. Contributing to the accident was the dark night conditions.
- [NTSB LAX88LA026](https://openairdocs.org/ntsb/LAX88LA026.md): Cessna 182H · Willcox, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1987 · N8411S · Substantial damage
  > The plt reported that the takeoff ground roll was unusually long. After liftoff the acft stayed in ground effect until just before the end of the rwy then climbed to aprx 100 ft. the plt landed in a soft field. During the landing roll the acft nosed over.…

## 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 ('2072718')
    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=2072718&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.