# NTSB investigations: Cessna 172P: 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 ANC22LA025](https://openairdocs.org/ntsb/ANC22LA025.md): Cessna 172P · Kekaha, HI · Accident · 2 fatal · Class 3 · Limited · Final report · Mar 21, 2022 · N98763 · Destroyed
  > The pilot’s improper decision to continue the visual-flight-rules flight into low visibility conditions, which resulted in controlled flight into terrain.
- [NTSB ANC21FA065](https://openairdocs.org/ntsb/ANC21FA065.md): Cessna 172P · Eagle River, AK · Accident · 2 fatal · Class 3 · Field · Final report · Jul 26, 2021 · N65698 · Substantial damage
  > An inflight collision with terrain under unknown circumstances. Contributing to the delayed rescue response was the failure of the emergency locator transmitter (ELT) to activate as designed, and the mechanic’s failure to ensure the correct ELT was installed…
- [NTSB WPR20LA330](https://openairdocs.org/ntsb/WPR20LA330.md): Cessna 172 · Stanley, ID · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 13, 2020 · N52700 · Substantial damage
  > The pilot's failure to maintain terrain clearance after flying into the wrong canyon in mountainous terrain which resulted in a collision with trees and terrain.
- [NTSB ERA13CA218](https://openairdocs.org/ntsb/ERA13CA218.md): Cessna 172P · Davis, WV · Accident · Serious injuries · Data collection · Final report · Apr 26, 2013 · N96178 · Substantial damage
  > The pilot’s improper glidepath as he approached the runway and his subsequent delayed decision to abort the landing.
- [NTSB ERA12FA483](https://openairdocs.org/ntsb/ERA12FA483.md): Cessna 172P · Plainville, CT · Accident · 1 fatal · Field investigation · Final report · Jul 26, 2012 · N64182 · Substantial damage
  > The pilot's failure to maintain the proper glidepath during final approach in visual meteorological conditions, resulting in collision with a berm.
- [NTSB ERA10FA029](https://openairdocs.org/ntsb/ERA10FA029.md): Cessna 172P · Bennington, VT · Accident · 1 fatal · Field investigation · Final report · Oct 25, 2009 · N55479 · Substantial damage
  > The pilot’s failure to maintain clearance from terrain during a night approach. Contributing to the accident was the pilot’s non-standard traffic pattern over higher 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 ('2072436')
    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=2072436

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