# NTSB investigations: Cessna R172K, 2016

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 WPR17CA001](https://openairdocs.org/ntsb/WPR17CA001.md): Cessna R172K · Rosamond, CA · Accident · No injuries · Data collection · Final report · Oct 2, 2016 · N736LZ · Substantial damage
  > The pilot's improper use of the control lock, combined with his incomplete execution of two pre-departure procedures, which resulted in a takeoff with the control lock installed.
- [NTSB GAA16CA327](https://openairdocs.org/ntsb/GAA16CA327.md): Cessna R172 · Craig, CO · Accident · No injuries · Data collection · Final report · Jun 17, 2016 · N998M · Substantial damage
  > The student pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the runway and the nose wheel impacting the runway edge and substantial damage to the firewall.
- [NTSB OPS16IA010](https://openairdocs.org/ntsb/OPS16IA010.md): Mooney M20R · Jacksonville, FL · Incident · Class 3 · Incident · Final report · Apr 3, 2016 · N57GX · 2 aircraft · No damage
  > The air traffic controller's decision to issue climb instruction to one aircraft without ensuring the required separation with another could be maintained. Contributing to the incident was the air traffic controller's failure to issue a safety alert in a…

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

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

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