# NTSB investigations: Cessna 172M: Controlled flight into terr/obj (CFIT)

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 WPR18FA063](https://openairdocs.org/ntsb/WPR18FA063.md): Cessna 172M · Ogden, UT · Accident · 2 fatal · Field investigation · Final report · Dec 29, 2017 · N4395R · Substantial damage
  > The pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.
- [NTSB ERA14CA430](https://openairdocs.org/ntsb/ERA14CA430.md): Cessna 172M · Watertown, CT · Accident · Minor injuries · Data collection · Final report · Sep 9, 2014 · N20469 · Substantial damage
  > The pilot's decision to takeoff from a field which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's failure to correctly identify the destination airport and runway, which resulted in an off-airport landing in…
- [NTSB ERA13FA330](https://openairdocs.org/ntsb/ERA13FA330.md): Cessna 172M · Fredericksburg, VA · Accident · 1 fatal · Field investigation · Final report · Jul 22, 2013 · N61954 · Substantial damage
  > The pilot's intentional descent into the ground to commit suicide.
- [NTSB CEN13CA272](https://openairdocs.org/ntsb/CEN13CA272.md): Cessna 172M · Thief River Falls, MN · Accident · No injuries · Data collection · Final report · May 9, 2013 · N1820V · Substantial damage
  > The pilot’s failure to maintain clearance from the power line while on approach to landing.
- [NTSB CEN13LA088](https://openairdocs.org/ntsb/CEN13LA088.md): Cessna 172M · Rochester, MN · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 2012 · N9853Q · Substantial damage
  > The pilot’s spatial disorientation during the instrument approach in night, instrument meteorological conditions, which resulted in the airplane descending below decision height and impacting terrain outside the lateral limits of the localizer. Contributing…
- [NTSB ERA11FA467](https://openairdocs.org/ntsb/ERA11FA467.md): Cessna 172M · Titusville, PA · Accident · 2 fatal · Field investigation · Final report · Aug 20, 2011 · N13126 · Substantial damage
  > The flight instructor's improper decision to attempt a visual descent into instrument meteorological conditions while approaching the destination airport, which resulted in an in-flight collision with trees and terrain.
- [NTSB ERA11CA450](https://openairdocs.org/ntsb/ERA11CA450.md): Cessna 172M · Elkins, WV · Accident · No injuries · Data collection · Final report · Aug 13, 2011 · N5399Q · Substantial damage
  > The flight instructor's unfamiliarity with the geographic area, resulting in controlled flight into terrain.
- [NTSB ERA11CA205](https://openairdocs.org/ntsb/ERA11CA205.md): Cessna 172M · Statesville, NC · Accident · Minor injuries · Data collection · Final report · Mar 23, 2011 · N32SF · Substantial damage
  > The certified flight instructor's inadequate remedial action during the go-around, which resulted in a collision with trees.
- [NTSB WPR10LA115](https://openairdocs.org/ntsb/WPR10LA115.md): Cessna 172M · Joshua Tree, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 18, 2010 · N13073 · Substantial damage
  > The certified flight instructor's decision to continue visual flight into deteriorating weather, which resulted in his inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain clearance with terrain.
- [NTSB WPR09CA348](https://openairdocs.org/ntsb/WPR09CA348.md): Cessna 172M · Thermopolis, WY · Accident · Serious injuries · Data collection · Final report · Jul 16, 2009 · N5461Q · Substantial damage
  > The instructor pilot's failure to ensure that his dual student maintained clearance from the terrain during a dark night visual flight rules descent.
- [NTSB ERA09LA310](https://openairdocs.org/ntsb/ERA09LA310.md): Cessna 172M · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · May 30, 2009 · N12151 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB LAX08FA190](https://openairdocs.org/ntsb/LAX08FA190.md): Cessna 172M · Pahala, HI · Accident · 3 fatal · Field investigation · Final report · Jun 17, 2008 · N13713 · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions and his failure to remain clear of rising terrain while deviating from his planned route of flight. Contributing to the accident were clouds and mountainous terrain.

## 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 ('2072418')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/120/sequence?model=2072418

---
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.