# NTSB investigations: Cessna 172H: 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 NYC00FA112](https://openairdocs.org/ntsb/NYC00FA112.md): Cessna 172H · Grottoes, VA · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2000 · N1404F · Destroyed
  > The pilot's loss of control of the airplane in instrument meteorological conditions, which resulted in an inadvertent stall/spin. Factors included the pilot's lack of instrument time under actual conditions, and his lack of recent instrument flight experience.
- [NTSB FTW95LA214](https://openairdocs.org/ntsb/FTW95LA214.md): Cessna 172H · San Ignacio, NM · Accident · Serious injuries · Limited investigation · Final report · May 22, 1995 · N2840L · Substantial damage
  > The pilot flying at an inadequate altitude to clear surrounding terrain. Factors were: high mountainous terrain and high density altitude.
- [NTSB CHI92LA212](https://openairdocs.org/ntsb/CHI92LA212.md): Cessna 172H · Chenoa, IL · Accident · No injuries · Limited investigation · Final report · Jul 26, 1992 · N8262L · Substantial damage
  > Inadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…
- [NTSB DEN89LA168](https://openairdocs.org/ntsb/DEN89LA168.md): Cessna 172H · Hatton, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1989 · N3269L · Destroyed
  > Improper in-flight planning/decision by the pilot and his failure to maintain sufficient clearance above the ground. The tailwind, high obstruction (shelter belt), and downdraft were contributing factors.
- [NTSB NYC88LA003](https://openairdocs.org/ntsb/NYC88LA003.md): Cessna 172H · Oneonta, NY · Accident · No injuries · Limited investigation · Final report · Oct 6, 1987 · N1677F · Destroyed
  > The plt rprtd he started to depart from rwy 13 with the wind from the south at 15 gusting 25 KTS. He stated the acft was not climbing as expected so he elected to land on the remaining rwy. He stated the wind gusts were strong from the right rear. He said he…
- [NTSB FTW83LA348](https://openairdocs.org/ntsb/FTW83LA348.md): Cessna 172 · Marshall, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1983 · N8095L · Substantial damage
  > The aircraft collided with an unmarked pile of dirt off the appraoch end of the runway at the harrison county airport. The runway was being extended and 5 1/2 to 6 foot tall mounds of fill dirt were left in the approach path of the runway. The pilot stated he…
- [NTSB NYC83FA091](https://openairdocs.org/ntsb/NYC83FA091.md): Cessna 172H · Liberty Corner, NJ · Accident · Serious injuries · Field investigation · Final report · Apr 4, 1983 · N2574L · Destroyed
  > Investigation revealed that the plt and passenger arrived at the airport at approximately 1820 EST, requested a special VFR clearance and when that clearance could not be approved requested an IFR flight plan. Attempts to activate the IFR flight plan were…

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