# NTSB investigations: Cessna 182C: 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 NYC04CA009](https://openairdocs.org/ntsb/NYC04CA009.md): Cessna 182C · Clarence Center, NY · Accident · No injuries · Data collection · Final report · Oct 10, 2003 · N8511T · Substantial damage
  > The pilot's delayed go-around decision. A factor in this accident was the night light condition.
- [NTSB SEA97LA131](https://openairdocs.org/ntsb/SEA97LA131.md): Cessna 182C · Hardin, MT · Accident · No injuries · Limited investigation · Final report · Jun 7, 1997 · N8522T · Substantial damage
  > the student's delay in initiating a go-around. A factor relating to the accident was: the sunglare.
- [NTSB LAX95LA111](https://openairdocs.org/ntsb/LAX95LA111.md): Cessna 182C · Novato, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1995 · N9036T · Substantial damage
  > The pilot's failure to maintain a proper base leg alignment while flying in the traffic pattern and his misjudged distance and altitude during the approach. A factor which contributed to the accident was the dark nighttime lighting condition which reduced the…
- [NTSB LAX91FA059](https://openairdocs.org/ntsb/LAX91FA059.md): Cessna 182C · Globe, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1990 · N8922T · Destroyed
  > The pilot's failure to conduct a weather evaluation prior to flight and his attempt to conduct his flight under visual flight rules into instrument meteorological conditions. Low ceilings along his flight route and self induced pressure to reach his…

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