# NTSB investigations: Cessna 172R, 2018

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 GAA19CA106](https://openairdocs.org/ntsb/GAA19CA106.md): Cessna 172 · Caldwell, NJ · Accident · No injuries · Data collection · Final report · Dec 30, 2018 · N2651R · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff roll.
- [NTSB CEN18CA323](https://openairdocs.org/ntsb/CEN18CA323.md): Cessna 172 · Greeley, CO · Accident · No injuries · Data collection · Final report · Aug 9, 2018 · N20JA · Substantial damage
  > The pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…
- [NTSB GAA18CA464](https://openairdocs.org/ntsb/GAA18CA464.md): Cessna 172 · Spring, TX · Accident · No injuries · Data collection · Final report · Jul 26, 2018 · N865CP · Substantial damage
  > The student pilot’s improper landing flare in a crosswind, which resulted in a hard landing.
- [NTSB WPR18FA195](https://openairdocs.org/ntsb/WPR18FA195.md): Cessna 172 · Deer Park, WA · Accident · 3 fatal · Class 3 · Field · Final report · Jul 13, 2018 · N24442 · Substantial damage
  > An in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.
- [NTSB GAA18CA498](https://openairdocs.org/ntsb/GAA18CA498.md): Cessna 172 · Beaver Falls, PA · Accident · No injuries · Data collection · Final report · Jul 8, 2018 · N984BT · Substantial damage
  > The student pilot's improper landing flare, which resulted in a bounced landing.
- [NTSB GAA18CA276](https://openairdocs.org/ntsb/GAA18CA276.md): Cessna 172 · Batavia, OH · Accident · No injuries · Data collection · Final report · May 8, 2018 · N377ES · Substantial damage
  > The pilot’s decision to take off with the airplane over its maximum gross weight due to his failure to perform preflight weight and balance calculations, which affected the airplane’s takeoff performance, and his subsequent decision to abort the takeoff with…
- [NTSB GAA18CA199](https://openairdocs.org/ntsb/GAA18CA199.md): Cessna 172 · New Bedford, MA · Accident · No injuries · Data collection · Final report · Mar 29, 2018 · N803BW · Substantial damage
  > The student pilot’s failure to maintain a proper landing flare, which resulted in a porpoised landing.
- [NTSB GAA18CA175](https://openairdocs.org/ntsb/GAA18CA175.md): Cessna 172 · Beaver Falls, PA · Accident · Minor injuries · Data collection · Final report · Mar 23, 2018 · N987AV · Substantial damage
  > The student pilot’s failure to maintain directional control during the landing roll.
- [NTSB GAA18CA163](https://openairdocs.org/ntsb/GAA18CA163.md): Cessna 172 · Bedford, MA · Accident · No injuries · Data collection · Final report · Mar 11, 2018 · N249FS · Substantial damage
  > The pilot’s improper landing flare, which resulted in substantial damage.
- [NTSB GAA18CA151](https://openairdocs.org/ntsb/GAA18CA151.md): Cessna 172 · Lakeland, FL · Accident · No injuries · Data collection · Final report · Mar 7, 2018 · N2221R · Substantial damage
  > The student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.

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

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

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