# NTSB investigations: Cessna 172S: 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 DFW07FA019](https://openairdocs.org/ntsb/DFW07FA019.md): Cessna 172S · Hominy, OK · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2006 · N53443 · Destroyed
  > The pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.
- [NTSB LAX06FA059](https://openairdocs.org/ntsb/LAX06FA059.md): Cessna 172S · Hana, HI · Accident · 1 fatal · Field investigation · Final report · Dec 16, 2005 · N542SP · Substantial damage
  > Collision with mountainous terrain for undetermined reasons.
- [NTSB LAX05CA137](https://openairdocs.org/ntsb/LAX05CA137.md): Cessna 172S · Gallup, NM · Accident · No injuries · Data collection · Final report · Apr 12, 2005 · N520ER · Substantial damage
  > the pilot's premature liftoff and inadequate remedial action, which resulted in the airplane inadvertently recontacting the runway.
- [NTSB FTW04CA224](https://openairdocs.org/ntsb/FTW04CA224.md): Cessna 172S · Leakey, TX · Accident · Minor injuries · Data collection · Final report · Aug 28, 2004 · N2477E · Substantial damage
  > The pilot's failure to maintain clearance with terrain. A contributing factor was the high density altitude.
- [NTSB LAX04LA054](https://openairdocs.org/ntsb/LAX04LA054.md): Cessna 172S · Wikieup, AZ · Accident · No injuries · Limited investigation · Final report · Nov 29, 2003 · N518ER · Substantial damage
  > The pilot's selection of an en route altitude that did not provide adequate terrain clearance, and resulted in the in-flight collision with terrain. The rising terrain and the blind/box canyon were contributing factors.
- [NTSB SEA02FA185](https://openairdocs.org/ntsb/SEA02FA185.md): Cessna 172S · Medford, OR · Accident · 2 fatal · Field investigation · Final report · Sep 30, 2002 · N514SP · Substantial damage
  > Terrain clearance was not maintained during cruise flight. Dark night and mountainous terrain were factors.
- [NTSB FTW02LA068](https://openairdocs.org/ntsb/FTW02LA068.md): Cessna 172S · Sugar Land, TX · Accident · No injuries · Limited investigation · Final report · Jan 12, 2002 · N497SJ · Substantial damage
  > the student pilot's failure to maintain directional control during landing.
- [NTSB ANC00FA082](https://openairdocs.org/ntsb/ANC00FA082.md): Cessna 172S · Whittier, AK · Accident · 1 fatal · Field investigation · Final report · Jul 4, 2000 · N862SP · Destroyed
  > Suicide.
- [NTSB CHI00LA113](https://openairdocs.org/ntsb/CHI00LA113.md): Cessna 172S · Near Muskegon, MI · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2000 · N560SP · Substantial damage
  > the pilot failed to maintain altitude after inadvertently flying to instrument meteorological conditions. Factors associated with the accident were the low ceilings and visibility, the pilot became disoriented after inadvertently flying into IMC, and the…

## 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 ('2072439', '2072442')
    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=2072439&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.