# NTSB investigations: Cessna 172K: 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 DEN02FA017](https://openairdocs.org/ntsb/DEN02FA017.md): Cessna 172K · Boulder, CO · Accident · 1 fatal · Field investigation · Final report · Jan 5, 2002 · N78035 · Destroyed
  > the pilot's intentional suicidal flight into terrain. Contributing factors were the pilot's psychological depressive state, and his use of inappropriate medication.
- [NTSB SEA94FA225](https://openairdocs.org/ntsb/SEA94FA225.md): Cessna 172K · Laramie, WY · Accident · 2 fatal · Field investigation · Final report · Aug 26, 1994 · N79444 · Destroyed
  > The pilot's failure to maintain clearance from terrain. Downdraft wind on the lee side of the ridgeline was a factor.
- [NTSB CHI94LA139](https://openairdocs.org/ntsb/CHI94LA139.md): Cessna 172K · Howes, SD · Accident · No injuries · Limited investigation · Final report · Apr 20, 1994 · N46474 · Substantial damage
  > The diverted attention of the pilot-in-command and his failure to maintain proper altitude.
- [NTSB LAX93FA110](https://openairdocs.org/ntsb/LAX93FA110.md): Cessna 172K · Gorman, CA · Accident · 4 fatal · Field investigation · Final report · Feb 7, 1993 · N79411 · Destroyed
  > The pilot's continued flight into known adverse weather conditions and continued visual flight into instrument meteorological conditions
- [NTSB ANC92LA182](https://openairdocs.org/ntsb/ANC92LA182.md): Cessna 172 · Taylor Road, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1992 · N79046 · Substantial damage
  > The pilot's inadequate compensation for wind conditions. Factors contributing to the accident were the gusting crosswinds and the pilot's lack of total experience in this type operation.
- [NTSB FTW91LA157](https://openairdocs.org/ntsb/FTW91LA157.md): Cessna 172K · Fisher, AR · Accident · No injuries · Limited investigation · Final report · Aug 26, 1991 · N7043G · Substantial damage
  > The pilot's failure to use the aircraft performance data to compute the takeoff distance. A factor was the high density altitude.
- [NTSB NYC88FA218](https://openairdocs.org/ntsb/NYC88FA218.md): Cessna 172K · Island Falls, ME · Accident · 1 fatal · Field investigation · Final report · Aug 15, 1988 · N1183M · Destroyed
  > Pilot's poor in-inflight decisions and planning and failed to follow ATC directives to maintain VFR. The pilot continued VFR into IFR conditions and collided with hilly terrain.
- [NTSB MKC85LA092](https://openairdocs.org/ntsb/MKC85LA092.md): Cessna 172K · Kingman, KS · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1985 · N79011 · Destroyed
  > During a landing attempt, the acft was high and fast and subsequently touched down long. The plt attempted a go around with 40 degrees of flaps. The acft stalled and contacted the terrain one fourth mile past the end of the rwy, right wing first.
- [NTSB DEN83LA061](https://openairdocs.org/ntsb/DEN83LA061.md): Cessna 172K · Dove Creek, CO · Accident · No injuries · Limited investigation · Final report · Feb 15, 1983 · N84631 · Substantial damage
  > The acft crashed during a low pass over the snow covered runway. The pilot stated that he made two low passes over the rwy during the 2nd pass 'the acft was in ground, effect with mild up and down drafts using minimal power setting.' The left wing was down…

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