# NTSB investigations: Cessna 172S, 2006

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 DFW07CA048](https://openairdocs.org/ntsb/DFW07CA048.md): Cessna 172S · Spicewood, TX · Accident · No injuries · Data collection · Final report · Dec 31, 2006 · N988SP · Substantial damage
  > The pilot's failure to compensate for the existing wind conditions resulting in a loss of directional control. Factors were the gusty crosswind and the muddy terrain.
- [NTSB DFW07LA056](https://openairdocs.org/ntsb/DFW07LA056.md): Cessna 172S · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Dec 27, 2006 · N159RA · Destroyed
  > The pilot's failure to maintain clearance from a hangar and parked airplane during the unauthorized use of an airplane.
- [NTSB CHI07CA027](https://openairdocs.org/ntsb/CHI07CA027.md): Cessna 172S · Warroad, MN · Accident · Serious injuries · Data collection · Final report · Nov 26, 2006 · N380SP · No damage
  > The propeller striking the individual who was positioning the propeller in anticipation of hand-propping the engine.
- [NTSB MIA07CA019](https://openairdocs.org/ntsb/MIA07CA019.md): Cessna 172S · New Smyrna, FL · Accident · No injuries · Data collection · Final report · Nov 19, 2006 · N53095 · Substantial damage
  > The student pilot's improper recovery from a bounced landing.
- [NTSB DFW07FA019](https://openairdocs.org/ntsb/DFW07FA019.md): Cessna 172S · Hominy, OK · Accident · 2 fatal · Field investigation · Final report · Nov 5, 2006 · N53443 · Destroyed
  > The pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.
- [NTSB SEA07LA013](https://openairdocs.org/ntsb/SEA07LA013.md): Cessna 172S · Richfield, UT · Accident · No injuries · Limited investigation · Final report · Oct 31, 2006 · N2097G · Substantial damage
  > The student pilot's inability to compensate for the gusty crosswinds during the initial part of the landing roll, which resulted in a loss of control and a noseover. Factors associated with the accident are gusty crosswinds, and a mound/berm of dirt alongside…
- [NTSB MIA07CA008](https://openairdocs.org/ntsb/MIA07CA008.md): Cessna 172S · Ormond Beach, FL · Accident · No injuries · Data collection · Final report · Oct 21, 2006 · N401ER · Substantial damage
  > The failure of the student pilot to initiate a recovery from the bounced landing resulting in a hard landing.
- [NTSB NYC06CA232](https://openairdocs.org/ntsb/NYC06CA232.md): Cessna 172S · Cambridge, MD · Accident · No injuries · Data collection · Final report · Sep 30, 2006 · N61WT · Substantial damage
  > The pilot's failure to maintain directional control while landing.
- [NTSB SEA06CA187](https://openairdocs.org/ntsb/SEA06CA187.md): Cessna 172S · Naples, FL · Accident · No injuries · Data collection · Final report · Sep 22, 2006 · N320CP · Substantial damage
  > The student pilot's failure to adequately compensate for wind conditions during the landing roll. A drainage ditch and wind were contributing factors.
- [NTSB ANC06CA114](https://openairdocs.org/ntsb/ANC06CA114.md): Cessna 172 · Palatka, FL · Accident · No injuries · Data collection · Final report · Aug 12, 2006 · N2469U · Substantial damage
  > The student's failure to maintain adequate airspeed to preclude a stall while maneuvering over the runway, and the instructor's inadequate supervision of the student pilot, which resulted in a collision with the runway. A factor in the accident was an…
- [NTSB ATL06CA117](https://openairdocs.org/ntsb/ATL06CA117.md): Cessna 172S · Thomson, GA · Accident · No injuries · Data collection · Final report · Aug 3, 2006 · N124CK · Substantial damage
  > The student pilot's failure to maintain directional control during the landing roll resulting in an on-ground collision with an embankment.
- [NTSB CHI06CA183](https://openairdocs.org/ntsb/CHI06CA183.md): Cessna 172S · Baltimore, OH · Accident · No injuries · Data collection · Final report · Jul 9, 2006 · N335SP · Substantial damage
  > The pilot's failure to attain sufficient airspeed during the takeoff which resulted in the inadvertent stall and collision with the ground.
- [NTSB NYC06CA159](https://openairdocs.org/ntsb/NYC06CA159.md): Cessna 172S · White Plains, NY · Accident · No injuries · Data collection · Final report · Jun 21, 2006 · N968SP · Substantial damage
  > The pilot's misjudged speed/distance which resulted in an overrun.
- [NTSB NYC06IA143](https://openairdocs.org/ntsb/NYC06IA143.md): Cessna 172S · Lawrence, MA · Incident · No injuries · Incident investigation · Final report · Jun 6, 2006 · N2138W · Minor damage
  > Foreign object damage to the leading edge of the propeller blade, which resulted in fatigue cracking and subsequent blade failure.
- [NTSB MIA06IA110](https://openairdocs.org/ntsb/MIA06IA110.md): Cessna 172S · St. Augustine, FL · Incident · No injuries · Incident investigation · Final report · May 23, 2006 · N1130T · Minor damage
  > The loss of engine power due to separation of the crankshaft as a result of lack of adequate oil lubrication to the #2 main bearing. The lack of oil lubrication was most likely the result of improper assembly (fitting) of the bearing shells to the crankshaft.
- [NTSB LAX06CA174](https://openairdocs.org/ntsb/LAX06CA174.md): Cessna 172S · Madera, CA · Accident · No injuries · Data collection · Final report · May 18, 2006 · N3544Z · Substantial damage
  > the pilot's failure to maintain directional control during the landing rollout.
- [NTSB NYC06CA116](https://openairdocs.org/ntsb/NYC06CA116.md): Cessna 172S · Louisville, KY · Accident · No injuries · Data collection · Final report · May 14, 2006 · N642KM · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff roll.
- [NTSB ATL06CA075](https://openairdocs.org/ntsb/ATL06CA075.md): Cessna C172S · Muscle Shoals, AL · Accident · No injuries · Data collection · Final report · May 6, 2006 · N613SP · Substantial damage
  > The student pilot's failure to maintain directional control of the airplane during takeoff roll.
- [NTSB LAX06CA150](https://openairdocs.org/ntsb/LAX06CA150.md): Cessna 172S · Honolulu, HI · Accident · No injuries · Data collection · Final report · Apr 28, 2006 · N790SP · Substantial damage
  > the pilot's misjudged flare resulting in a hard landing and a porpoise pilot induced oscillation.
- [NTSB SEA06CA081](https://openairdocs.org/ntsb/SEA06CA081.md): Cessna 172 S · Malad City, ID · Accident · No injuries · Data collection · Final report · Apr 23, 2006 · N679SP · Substantial damage
  > The private pilot's improper touchdown point during landing and the certified flight instructors delayed remedial action. Ditches and fences were factors in the accident.
- [NTSB ATL06CA068](https://openairdocs.org/ntsb/ATL06CA068.md): Cessna 172S · Gainsville, GA · Accident · No injuries · Data collection · Final report · Apr 16, 2006 · N21527 · Substantial damage
  > The pilot's improper landing flare which resulted in a hard landing.
- [NTSB ATL06CA062](https://openairdocs.org/ntsb/ATL06CA062.md): Cessna C-172S · Sanford, NC · Accident · No injuries · Data collection · Final report · Apr 10, 2006 · N72675 · Substantial damage
  > The pilot's improper landing flare which resulted in a hard landing.
- [NTSB DFW06CA098](https://openairdocs.org/ntsb/DFW06CA098.md): Cessna 172S · Denton, TX · Accident · No injuries · Data collection · Final report · Apr 9, 2006 · N358TW · Substantial damage
  > The student pilot's failure to maintain directional control during the takeoff roll.
- [NTSB ANC06CA036](https://openairdocs.org/ntsb/ANC06CA036.md): Cessna 172S · Prescott, AZ · Accident · No injuries · Data collection · Final report · Mar 24, 2006 · N514ER · Substantial damage
  > The pilot's improper recovery from a bounced landing, which resulted in structural damage to the firewall and fuselage.
- [NTSB NYC06CA077](https://openairdocs.org/ntsb/NYC06CA077.md): Cessna 172S · Atlantic City, NJ · Accident · No injuries · Data collection · Final report · Mar 6, 2006 · N680SP · Substantial damage
  > The pilot's failure to obtain a proper touchdown point, which resulted in an overrun of the runway.

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

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