# NTSB investigations: Cessna 172D: Collision with terr/obj (non-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 ERA18LA169](https://openairdocs.org/ntsb/ERA18LA169.md): Cessna 172D · Quinton, VA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 16, 2018 · N2777U · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR18LA047](https://openairdocs.org/ntsb/WPR18LA047.md): Cessna 172D · Auburn, WA · Accident · No injuries · Class 3 · Limited · Final report · Dec 7, 2017 · N2351U · Substantial damage
  > The pilot's loss of airplane control for reasons that could not be determined based on the available information.
- [NTSB ERA17LA234](https://openairdocs.org/ntsb/ERA17LA234.md): Cessna 172 · Cape Coral, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2017 · N2492U · Substantial damage
  > A total loss of engine power due to fuel contamination with water and the pilot's inadequate preflight inspection that detected, but did not fully resolve, the water contamination of the fuel system.
- [NTSB GAA16CA150](https://openairdocs.org/ntsb/GAA16CA150.md): Cessna 172 · La Junta, CO · Accident · No injuries · Data collection · Final report · Jan 31, 2016 · N2567U · Substantial damage
  > The pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.
- [NTSB CEN15LA292](https://openairdocs.org/ntsb/CEN15LA292.md): Cessna 172D · Shenandoah, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2015 · N2320U · Substantial damage
  > The pilot's delayed application of carburetor heat, which resulted in the total loss of engine power due to carburetor icing during cruise flight.
- [NTSB WPR15LA077](https://openairdocs.org/ntsb/WPR15LA077.md): Cessna 172D · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Jan 4, 2015 · N2948U · Substantial damage
  > The pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA14LA147](https://openairdocs.org/ntsb/ERA14LA147.md): Cessna 172D · Fairhope, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 8, 2014 · N2755U · Destroyed
  > The pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.
- [NTSB ERA13LA037](https://openairdocs.org/ntsb/ERA13LA037.md): Cessna 172D · Indian Trail, NC · Accident · No injuries · Limited investigation · Final report · Oct 20, 2012 · N2879U · Substantial damage
  > The pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.
- [NTSB ANC13CA003](https://openairdocs.org/ntsb/ANC13CA003.md): Cessna 172D · Buckland, AK · Accident · No injuries · Data collection · Final report · Oct 8, 2012 · N8808 · Substantial damage
  > The pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.
- [NTSB WPR12LA189](https://openairdocs.org/ntsb/WPR12LA189.md): Cessna 172D · Beckwourth, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 2012 · N2559U · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed during initial climb, which resulted in a loss of airplane control.
- [NTSB ERA12LA101](https://openairdocs.org/ntsb/ERA12LA101.md): Cessna 172D · Belhaven, NC · Accident · No injuries · Limited investigation · Final report · Dec 4, 2011 · N2344U · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.

## 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 ('2072410')
    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" = '470' 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/470/sequence?model=2072410

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