# NTSB investigations: Cessna 172, 2015

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 ANC16CA009](https://openairdocs.org/ntsb/ANC16CA009.md): Cessna 172 · Manley Hot Springs, AK · Accident · No injuries · Data collection · Final report · Nov 27, 2015 · N7176A · Substantial damage
  > The pilot's decision to depart from an unsuitable, off-airport site, which resulted in a collision with a tree.
- [NTSB ERA16LA018](https://openairdocs.org/ntsb/ERA16LA018.md): Cessna 172 · Campobello, SC · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2015 · N6636A · Substantial damage
  > The pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.
- [NTSB ERA15CA327](https://openairdocs.org/ntsb/ERA15CA327.md): Cessna 172 · Riviera Beach, FL · Accident · No injuries · Data collection · Final report · Aug 22, 2015 · N8952B · Substantial damage
  > The pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to icing, which resulted in a total loss of power.
- [NTSB CEN15FA378](https://openairdocs.org/ntsb/CEN15FA378.md): Cessna 172 · Martinville, IL · Accident · 1 fatal · Field investigation · Final report · Aug 21, 2015 · N8265B · Substantial damage
  > The non-certificated pilot's failure to maintain clearance from terrain.
- [NTSB CEN15FA278](https://openairdocs.org/ntsb/CEN15FA278.md): Cessna 172 · Shreveport, LA · Accident · 1 fatal · Field investigation · Final report · Jun 19, 2015 · N5743A · Substantial damage
  > The pilot's loss of airplane control during initial climb after takeoff for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact anomalies.

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

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

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