# NTSB investigations: Cessna 172S, 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 DEN05FA044](https://openairdocs.org/ntsb/DEN05FA044.md): Cessna 172S · Roswell, NM · Accident · 1 fatal · Field investigation · Final report · Dec 28, 2004 · N849SP · Destroyed
  > the pilot not maintaining control of the aircraft resulting in an uncontrolled descent and collision on a highway. Factors contributing to the accident were the dark night and the pilot experiencing spatial disorientation.
- [NTSB MIA05LA043](https://openairdocs.org/ntsb/MIA05LA043.md): Cessna 172S · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Dec 17, 2004 · N375LP · Substantial damage
  > The faulure of the pilot to maintain directional control of the aircraft during the landing roll resulting in the on-ground collision with a taxiway sign and subsequent collapse of the nose landing gear.
- [NTSB CHI05CA035](https://openairdocs.org/ntsb/CHI05CA035.md): Cessna 172S · Anderson, IN · Accident · No injuries · Data collection · Final report · Nov 21, 2004 · N967SA · Substantial damage
  > The student pilot's improper flare and his inadequate recovery from a bounced landing.
- [NTSB IAD05CA014](https://openairdocs.org/ntsb/IAD05CA014.md): Cessna 172S · Mansfield, MA · Accident · No injuries · Data collection · Final report · Nov 19, 2004 · N2120M · Substantial damage
  > The pilot's improper decision to taxi on a closed taxiway, and his misjudgment of obstacle clearance.
- [NTSB LAX05CA028](https://openairdocs.org/ntsb/LAX05CA028.md): Cessna 172S · Chandler, AZ · Accident · No injuries · Data collection · Final report · Nov 5, 2004 · N20519 · Substantial damage
  > the pilot's improper flare, which resulted in a hard landing. Contributing factors were his improper recovery from the subsequent bounced landing and pilot-induced oscillations.
- [NTSB ATL05CA015](https://openairdocs.org/ntsb/ATL05CA015.md): Cessna 172SP · West Columbia, SC · Accident · No injuries · Data collection · Final report · Oct 20, 2004 · N37CJ · Substantial damage
  > The student pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control during rollout. A factor was the runway sign.
- [NTSB DEN04LA150](https://openairdocs.org/ntsb/DEN04LA150.md): Cessna 172S · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Sep 30, 2004 · N802SP · Substantial damage
  > the pilot's improper flare, and the flight instructor's inadequate supervision of the pilot.
- [NTSB NYC04CA206](https://openairdocs.org/ntsb/NYC04CA206.md): Cessna 172S · Mount Gilead, OH · Accident · No injuries · Data collection · Final report · Sep 6, 2004 · N809SP · Substantial damage
  > The pilot's inadequate compensation for wind conditions which resulted in a collision with the runway. A factor was the crosswind.
- [NTSB LAX04CA309](https://openairdocs.org/ntsb/LAX04CA309.md): Cessna 172S · Willits, CA · Accident · Minor injuries · Data collection · Final report · Sep 2, 2004 · N897TW · Destroyed
  > the pilot's inadvertent descent and controlled flight into obstacles while maneuvering to land. Contributing factors were the dark, nighttime condition, which impaired the pilot's visual perceptions, and the pilot's failure to obtain a pertinent Notice to…
- [NTSB DEN04CA137](https://openairdocs.org/ntsb/DEN04CA137.md): Cessna 172S · Erie, CO · Accident · No injuries · Data collection · Final report · Aug 29, 2004 · N2099J · Substantial damage
  > the pilot's failure to maintain aircraft control resulting in a hard landing. Factors contributing to the accident were the pilot induced oscillation and the high approach airspeed.
- [NTSB FTW04CA224](https://openairdocs.org/ntsb/FTW04CA224.md): Cessna 172S · Leakey, TX · Accident · Minor injuries · Data collection · Final report · Aug 28, 2004 · N2477E · Substantial damage
  > The pilot's failure to maintain clearance with terrain. A contributing factor was the high density altitude.
- [NTSB DEN04LA127](https://openairdocs.org/ntsb/DEN04LA127.md): Cessna 172S · Carlsbad, NM · Accident · No injuries · Limited investigation · Final report · Aug 19, 2004 · N849SP · Substantial damage
  > the student pilot's inadequate flare resulting in a hard landing. A contributing factor was the tailwind conditions.
- [NTSB LAX04CA290](https://openairdocs.org/ntsb/LAX04CA290.md): Cessna 172S · Honolulu, HI · Accident · No injuries · Data collection · Final report · Aug 13, 2004 · N3554Y · Substantial damage
  > the student pilot's misjudged flare, which resulted in a hard landing. Also causal was the student pilot's improper recovery from a bounced landing and pilot induced porpoise and failure to maintain directional control on the landing roll, which resulted in…
- [NTSB MIA04CA109](https://openairdocs.org/ntsb/MIA04CA109.md): Cessna 172SP · Miami, FL · Accident · No injuries · Data collection · Final report · Aug 12, 2004 · N21063 · Substantial damage
  > The pilot's failure to maintain control while landing with a crosswind and gusting wind conditions, which resulted in the airplane veering off the runway and incurring damage.
- [NTSB LAX04CA288](https://openairdocs.org/ntsb/LAX04CA288.md): Cessna 172S · Chandler, AZ · Accident · No injuries · Data collection · Final report · Aug 8, 2004 · N5327G · Substantial damage
  > the student pilot's failure to abort the takeoff. A contributing factor was the pilot's failure to maintain directional control.
- [NTSB ATL04LA164](https://openairdocs.org/ntsb/ATL04LA164.md): Cessna 172S · Waterloo, AL · Accident · 1 fatal · Limited investigation · Final report · Aug 1, 2004 · N970SP · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in a stall and subsequent uncontrolled descent and collision into water.
- [NTSB NYC04CA164](https://openairdocs.org/ntsb/NYC04CA164.md): Cessna 172S · Stevensville, MD · Accident · No injuries · Data collection · Final report · Jun 30, 2004 · N421RW · Substantial damage
  > The pilot's improper flare during touch down, which resulted in a hard landing.
- [NTSB LAX04CA250](https://openairdocs.org/ntsb/LAX04CA250.md): Cessna 172S · Glendale, AZ · Accident · No injuries · Data collection · Final report · Jun 26, 2004 · N35389 · Substantial damage
  > the pilot's failure to maintain directional control of the airplane, which resulted in a veer off the runway and collision with terrain.
- [NTSB CHI04CA165](https://openairdocs.org/ntsb/CHI04CA165.md): Cessna 172S · Fishers, IN · Accident · No injuries · Data collection · Final report · Jun 26, 2004 · N229ME · Substantial damage
  > The pilot's inadequate remedial actions after an inadequate landing flare and subsequent hard landing. Additional causes were the pilot-induced porpoise and the collapse of the nose landing gear.
- [NTSB ATL04LA140](https://openairdocs.org/ntsb/ATL04LA140.md): Cessna 172S · Asheville, NC · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 2004 · N2116P · Substantial damage
  > The CFII's inadequate visual lookout and failure to maintain clear of objects during flight. Factors were clouds and dark night.
- [NTSB FTW04LA178](https://openairdocs.org/ntsb/FTW04LA178.md): Cessna 172S · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Jun 24, 2004 · N810SA · Substantial damage
  > The student pilot's failure to maintain control of the airplane during landing.
- [NTSB FTW04CA163](https://openairdocs.org/ntsb/FTW04CA163.md): Cessna 172 · McKinney, TX · Accident · No injuries · Data collection · Final report · Jun 16, 2004 · N2101M · Substantial damage
  > The student pilot's improper recovery from a bounced landing.
- [NTSB MIA04CA077](https://openairdocs.org/ntsb/MIA04CA077.md): Cessna 172S · Key West, FL · Accident · No injuries · Data collection · Final report · Apr 17, 2004 · N5280D · Substantial damage
  > The pilot's failure to maintain directional control while landing in gusty wind conditions which resulted in the airplane departing the runway and impacting a sign, incurring damage.
- [NTSB LAX04CA186](https://openairdocs.org/ntsb/LAX04CA186.md): Cessna 172S · Long Beach, CA · Accident · No injuries · Data collection · Final report · Apr 13, 2004 · N669SP · Substantial damage
  > the student pilot's inadequate flare, which resulted in a hard landing and porpoise.
- [NTSB DEN04LA053](https://openairdocs.org/ntsb/DEN04LA053.md): Cessna C172 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Mar 26, 2004 · N5345G · 2 aircraft · Substantial damage
  > the pilot of the Maule's failure to maintain a visual lookout.
- [NTSB LAX04CA130](https://openairdocs.org/ntsb/LAX04CA130.md): Cessna 172S · Riverside, CA · Accident · No injuries · Data collection · Final report · Feb 15, 2004 · N262TA · Substantial damage
  > the pilot's inadequate visual lookout, which resulted in his failure to maintain proper alignment with the taxiway. Factors in the accident were the dusk lighting conditions and pilot not understanding the ground control taxi clearance.
- [NTSB FTW04LA072](https://openairdocs.org/ntsb/FTW04LA072.md): Cessna 172-SP · McKinney, TX · Accident · No injuries · Limited investigation · Final report · Feb 7, 2004 · N2124Z · Destroyed
  > The student pilot's failure to maintain directional control of the aircraft during the take-off roll.

## 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 ('2072439', '2072442'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072439&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.