# NTSB investigations: Cessna 172P, 2009

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 CEN10CA077](https://openairdocs.org/ntsb/CEN10CA077.md): Cessna 172P · Ames, IA · Accident · No injuries · Data collection · Final report · Dec 18, 2009 · N99930 · Substantial damage
  > The pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.
- [NTSB ERA10FA029](https://openairdocs.org/ntsb/ERA10FA029.md): Cessna 172P · Bennington, VT · Accident · 1 fatal · Field investigation · Final report · Oct 25, 2009 · N55479 · Substantial damage
  > The pilot’s failure to maintain clearance from terrain during a night approach. Contributing to the accident was the pilot’s non-standard traffic pattern over higher terrain.
- [NTSB WPR10CA008](https://openairdocs.org/ntsb/WPR10CA008.md): Cessna 172P · Renton, WA · Accident · No injuries · Data collection · Final report · Oct 7, 2009 · N54088 · Substantial damage
  > The failure of the student pilot to maintain directional control during the takeoff portion of a touch-and-go landing resulting in a collision with a sign.
- [NTSB ERA09CA541](https://openairdocs.org/ntsb/ERA09CA541.md): Cessna 172P · Pensacola, FL · Accident · No injuries · Data collection · Final report · Sep 27, 2009 · N55437 · Substantial damage
  > The pilot's inability to maintain control during landing due to the separation of the nose landing gear upper scissor from the nose gear assembly. Contributing to the accident was the inadequate visual examination performed during the annual inspection.
- [NTSB WPR09CA447](https://openairdocs.org/ntsb/WPR09CA447.md): Cessna 172P · Long Beach, CA · Accident · No injuries · Data collection · Final report · Sep 8, 2009 · N51594 · Substantial damage
  > The pilot’s failure to maintain clearance from a parked vehicle during taxi.
- [NTSB ERA09LA549](https://openairdocs.org/ntsb/ERA09LA549.md): Cessna 172P · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Aug 20, 2009 · N64344 · Substantial damage
  > The student pilot's improper flare, which resulted in a hard landing.
- [NTSB CEN09CA459](https://openairdocs.org/ntsb/CEN09CA459.md): Cessna 172P · Usafa, CO · Accident · Minor injuries · Data collection · Final report · Jun 27, 2009 · N52298 · Substantial damage
  > The pilot's failure to maintain a safe flying airspeed resulting in an inadvertent stall during the go-around.
- [NTSB WPR09CA209](https://openairdocs.org/ntsb/WPR09CA209.md): Cessna 172P · Livermore, CA · Accident · No injuries · Data collection · Final report · Apr 20, 2009 · N64204 · Substantial damage
  > The student pilot’s improper recovery from a bounced landing.
- [NTSB ERA09CA195](https://openairdocs.org/ntsb/ERA09CA195.md): Cessna 172P · Cleveland, MS · Accident · No injuries · Data collection · Final report · Mar 6, 2009 · N6089K · Substantial damage
  > The inadvertent encounter with a bird in flight.

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

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

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