# NTSB investigations: Cessna 172K, 2013

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 CEN14CA096](https://openairdocs.org/ntsb/CEN14CA096.md): Cessna 172K · Concordia, KS · Accident · Minor injuries · Data collection · Final report · Dec 30, 2013 · N1176M · Substantial damage
  > The pilot's failure to maintain a proper glidepath during approach which resulted in the airplane landing long, and his decision to turn off of the runway during the landing roll which resulted in a collision with an earth berm.
- [NTSB WPR14FA078](https://openairdocs.org/ntsb/WPR14FA078.md): Cessna 172K · Fresno, CA · Accident · 2 fatal · Field investigation · Final report · Dec 27, 2013 · N251JM · Destroyed
  > The pilot’s failure to maintain adequate clearance from trees while on approach, which subsequently led to a loss of airplane control. Also causal was the pilot’s continued operation of the airplane at night with a diagnosed medical condition that degraded…
- [NTSB ERA13LA281](https://openairdocs.org/ntsb/ERA13LA281.md): Cessna 172K · Newton, MS · Accident · 1 fatal · Limited investigation · Final report · Jun 12, 2013 · N7045G · Substantial damage
  > The student pilot's failure to increase engine power during the descent for landing when instructed to do so by the flight instructor and the flight instructor's delayed remedial action, which resulted in collision with a static wire. Contributing to the…
- [NTSB CEN13CA222](https://openairdocs.org/ntsb/CEN13CA222.md): Cessna 172 · Manvel, TX · Accident · Minor injuries · Data collection · Final report · Apr 8, 2013 · N7825T · Substantial damage
  > The pilot’s failure to maintain airplane control while taking off in gusting wind conditions.
- [NTSB ERA13CA181](https://openairdocs.org/ntsb/ERA13CA181.md): Cessna 172 · Tistusville, FL · Accident · No injuries · Data collection · Final report · Mar 24, 2013 · N7113G · Substantial damage
  > The pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.

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

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

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