# NTSB investigations: Cessna 172M, 2017

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 GAA18CA097](https://openairdocs.org/ntsb/GAA18CA097.md): Cessna 172 · Monroe, MI · Accident · No injuries · Data collection · Final report · Dec 21, 2017 · N4491R · Substantial damage
  > The student pilot’s improper yaw control during the landing flare and the flight instructor’s failure to take remedial action, which resulted in a hard landing.
- [NTSB GAA18CA048](https://openairdocs.org/ntsb/GAA18CA048.md): Cessna 172M · Chico, CA · Accident · Minor injuries · Data collection · Final report · Nov 19, 2017 · N9678Q · Substantial damage
  > An in-flight collision with a bird.
- [NTSB CEN18FA011](https://openairdocs.org/ntsb/CEN18FA011.md): Cessna 172M · Ramsey, MN · Accident · 2 fatal · Field investigation · Final report · Oct 13, 2017 · N7CF · Destroyed
  > The pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…
- [NTSB GAA18CA005](https://openairdocs.org/ntsb/GAA18CA005.md): Cessna 172 · Black River Falls, WI · Accident · No injuries · Data collection · Final report · Oct 8, 2017 · N9664Q · Substantial damage
  > The pilot’s failure to maintain directional control during landing in gusting crosswind conditions.
- [NTSB GAA17CA556](https://openairdocs.org/ntsb/GAA17CA556.md): Cessna 172 · Gallatin, TN · Accident · No injuries · Data collection · Final report · Sep 16, 2017 · N5146R · Substantial damage
  > The student pilot’s improper landing flare, which resulted in a bounced landing.
- [NTSB ERA17FA272](https://openairdocs.org/ntsb/ERA17FA272.md): Cessna 172 · New Milford, CT · Accident · 1 fatal · Field investigation · Final report · Aug 11, 2017 · N1727V · Substantial damage
  > The flight instructor's failure to ensure that the wing flaps were properly configured for takeoff, which resulted in an aerodynamic stall and loss of control during the initial climb.
- [NTSB ERA17LA242](https://openairdocs.org/ntsb/ERA17LA242.md): Cessna 172 · Key Biscayne, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 2017 · N80457 · Substantial damage
  > The nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…
- [NTSB GAA17CA448](https://openairdocs.org/ntsb/GAA17CA448.md): Cessna 172 · Manassas, VA · Accident · No injuries · Data collection · Final report · Jul 9, 2017 · N80399 · Substantial damage
  > The student pilot’s improper landing flare, which resulted in a porpoised landing.
- [NTSB GAA17CA394](https://openairdocs.org/ntsb/GAA17CA394.md): Cessna 172 · Tamuning · Accident · No injuries · Data collection · Final report · Jul 2, 2017 · N80328 · Substantial damage
  > The pilot's improper landing flare, which resulted in a porpoised landing.
- [NTSB GAA17CA341](https://openairdocs.org/ntsb/GAA17CA341.md): Cessna 172 · Galena, ID · Accident · No injuries · Data collection · Final report · Jun 14, 2017 · N9912Q · Substantial damage
  > The pilot's exceedance of the airplane’s critical angle of attack, which resulted in a power-on stall and subsequent loss of airplane control.
- [NTSB ERA17LA203](https://openairdocs.org/ntsb/ERA17LA203.md): Cessna 172 · Suffolk, NY · Accident · No injuries · Limited investigation · Final report · Jun 12, 2017 · N13306 · Substantial damage
  > A loss of preload to the crankshaft gear attachment bolt due to improper installation, which resulted in the fatigue failure of the crankshaft gear alignment dowel and led to the rotation of the crankshaft gear and a subsequent total loss of engine power.
- [NTSB GAA17CA318](https://openairdocs.org/ntsb/GAA17CA318.md): Cessna 172 · Payson, AZ · Accident · Minor injuries · Data collection · Final report · Jun 4, 2017 · N50526 · Destroyed
  > The pilot’s inadequate preflight planning that did not account for high-density altitude conditions and his subsequent attempted go-around in conditions that prevented the airplane from attaining a positive climb rate and resulted in its subsequent descent…
- [NTSB GAA17CA254](https://openairdocs.org/ntsb/GAA17CA254.md): Cessna 172 · Columbia, KY · Accident · No injuries · Data collection · Final report · Apr 28, 2017 · N64144 · Substantial damage
  > The pilot’s failure to maintain a flare during landing in variable, gusting wind conditions.
- [NTSB GAA17CA232](https://openairdocs.org/ntsb/GAA17CA232.md): Cessna 172 · Houston, TX · Accident · No injuries · Data collection · Final report · Apr 11, 2017 · N92873 · Substantial damage
  > The pilot’s delayed attempt to abort the takeoff with a tailwind, which resulted in a runway overrun.
- [NTSB GAA17CA205](https://openairdocs.org/ntsb/GAA17CA205.md): Cessna 172 · Baltimore, MD · Accident · No injuries · Data collection · Final report · Mar 24, 2017 · N13499 · Substantial damage
  > The student pilot’s failure to maintain clearance from other airplanes in the run-up area.
- [NTSB GAA17CA186](https://openairdocs.org/ntsb/GAA17CA186.md): Cessna 172 · Hillsboro, OR · Accident · No injuries · Data collection · Final report · Mar 12, 2017 · N5440H · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll in quartering tailwind conditions.
- [NTSB GAA17CA140](https://openairdocs.org/ntsb/GAA17CA140.md): Cessna 172 · Burlington, NC · Accident · No injuries · Data collection · Final report · Feb 16, 2017 · N381MG · Substantial damage
  > The pilot's failure to maintain the runway heading during an attempted go-around in gusting crosswind conditions, which resulted in a runway excursion.
- [NTSB CEN17LA082](https://openairdocs.org/ntsb/CEN17LA082.md): Cessna 172M · Hobart, IN · Accident · Serious injuries · Limited investigation · Final report · Jan 6, 2017 · N80374 · Substantial damage
  > The pilot's failure to abort the landing when he recognized the airplane was traveling too fast, which resulted in impact with trees off the end of the runway.

## 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 year(c."eventDate") = 2017
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072418&year=2017

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