# NTSB investigations: Cessna 172P, 2012

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 ERA13CA086](https://openairdocs.org/ntsb/ERA13CA086.md): Cessna 172P · Murfreesboro, TN · Accident · Serious injuries · Data collection · Final report · Dec 13, 2012 · N54500 · Substantial damage
  > The student pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.
- [NTSB WPR13LA038](https://openairdocs.org/ntsb/WPR13LA038.md): Cessna 172P · Maricopa, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 2012 · N65835 · Substantial damage
  > The pilot’s failure to maintain proper pitch control during the initial climb, which resulted in a stall, loss of airplane control, and collision with terrain.
- [NTSB ERA12CA579](https://openairdocs.org/ntsb/ERA12CA579.md): Cessna 172P · Richmond, KY · Accident · No injuries · Data collection · Final report · Sep 25, 2012 · N53720 · Substantial damage
  > The student pilot's improper flare, which resulted in a hard landing, and the flight instructor's inadequate supervision of the student.
- [NTSB ERA12CA531](https://openairdocs.org/ntsb/ERA12CA531.md): Cessna 172P · Lyman, MS · Accident · No injuries · Data collection · Final report · Aug 23, 2012 · N65747 · Substantial damage
  > The pilot's loss of directional control during takeoff as a result of his attempt to close an unsecured cockpit window.
- [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 ERA12CA466](https://openairdocs.org/ntsb/ERA12CA466.md): Cessna 172P · St. Augustine, FL · Accident · No injuries · Data collection · Final report · Jul 18, 2012 · N127EP · Substantial damage
  > Undetermined due to a lack of information about when the damage to the airplane occurred.
- [NTSB WPR12CA260](https://openairdocs.org/ntsb/WPR12CA260.md): Cessna 172P · Hemet, CA · Accident · No injuries · Data collection · Final report · May 28, 2012 · N216AF · Substantial damage
  > The student pilot's failure to monitor and maintain clearance from an obstacle during taxi.
- [NTSB WPR12CA204](https://openairdocs.org/ntsb/WPR12CA204.md): Cessna 172P · Spokane, WA · Accident · No injuries · Data collection · Final report · May 7, 2012 · N54036 · Substantial damage
  > The student pilot's improper landing flare and inadequate recovery from a bounced landing.
- [NTSB ERA12LA259](https://openairdocs.org/ntsb/ERA12LA259.md): Cessna 172P · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Mar 24, 2012 · N99087 · Substantial damage
  > The pilot's improper landing flare, which resulted in a hard landing.
- [NTSB CEN12CA200](https://openairdocs.org/ntsb/CEN12CA200.md): Cessna 172P · Colorado Springs, CO · Accident · Minor injuries · Data collection · Final report · Mar 24, 2012 · N97LP · Substantial damage
  > The pilot did not maintain control of the airplane during takeoff, which resulted in a hard landing and subsequent nose over.
- [NTSB WPR12CA082](https://openairdocs.org/ntsb/WPR12CA082.md): Cessna 172P · Honolulu, HI · Accident · No injuries · Data collection · Final report · Jan 26, 2012 · N66540 · Substantial damage
  > The student pilot’s improper landing flare and inadequate directional control while performing an aborted landing.
- [NTSB CEN12TA122](https://openairdocs.org/ntsb/CEN12TA122.md): Cessna 172P · Conroe, TX · Accident · No injuries · Final report · Jan 4, 2012 · N54872 · Substantial damage
  > Failure of the rear crankshaft gear dowel pin due to improper installation, which resulted in a total loss of engine power.

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

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

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