# NTSB investigations: Cessna 172R, 2004

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 NYC05LA034](https://openairdocs.org/ntsb/NYC05LA034.md): Cessna 172R · Smoketown, PA · Accident · Minor injuries · Limited investigation · Final report · Dec 30, 2004 · N9962F · Substantial damage
  > The pilot's failure to maintain directional control during takeoff, which resulted in a collision with a parked airplane.
- [NTSB NYC05LA024](https://openairdocs.org/ntsb/NYC05LA024.md): Cessna 172R · Martinsburg, WV · Accident · No injuries · Limited investigation · Final report · Nov 21, 2004 · N5294W · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ATL04CA170](https://openairdocs.org/ntsb/ATL04CA170.md): Cessna 172R · Atlanta, GA · Accident · Minor injuries · Data collection · Final report · Aug 28, 2004 · N26486 · Substantial damage
  > The intentional interuption of the flight controls in flight that resulted in a uncontrolled descent and collision with a fence.
- [NTSB CHI04CA241](https://openairdocs.org/ntsb/CHI04CA241.md): Cessna 172R · Olathe, KS · Accident · No injuries · Data collection · Final report · Aug 5, 2004 · N458CM · Substantial damage
  > The student pilot flared too high and failed to recover from a bounced landing.
- [NTSB NYC04CA145](https://openairdocs.org/ntsb/NYC04CA145.md): Cessna 172R · Hartford, CT · Accident · No injuries · Data collection · Final report · Jun 21, 2004 · N356ES · Substantial damage
  > The student pilot's improper flare and inadequate compensation for wind conditions. A factor was the gusty winds.
- [NTSB CHI04LA097](https://openairdocs.org/ntsb/CHI04LA097.md): Cessna 172R · Kalamazoo, MI · Accident · No injuries · Limited investigation · Final report · Apr 2, 2004 · N986AV · Substantial damage
  > The air traffic control procedures/directives not followed by tower air traffic controller, the inadequate compensation for wind conditions by the student pilot during landing, the lack of total experience by the student pilot, and the recommended crosswind…
- [NTSB CHI04LA085](https://openairdocs.org/ntsb/CHI04LA085.md): Cessna 172R · Dubuque, IA · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 2004 · N105FS · Substantial damage
  > The flight instructor's inadequate in-flight planning/decision which resulted in ice accretion on the airframe, and his failure to maintain adequate airspeed resulting in a stall. Contributing factors were the ice contamination, the aircraft's low altitude…
- [NTSB NYC04CA070](https://openairdocs.org/ntsb/NYC04CA070.md): Cessna 172R · Batavia, OH · Accident · No injuries · Data collection · Final report · Feb 16, 2004 · N121UC · Substantial damage
  > The student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing.
- [NTSB IAD04CA009](https://openairdocs.org/ntsb/IAD04CA009.md): Cessna 172R · Fredrick, MD · Accident · No injuries · Data collection · Final report · Feb 5, 2004 · N5165M · Substantial damage
  > The student pilot's failure to maintain directional control during the landing. A factor was the snow bank.

## 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") = 2004
  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=2004

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