# NTSB investigations: Cessna 172P, 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 LAX07CA007](https://openairdocs.org/ntsb/LAX07CA007.md): Cessna 172P · Glendale, AZ · Accident · No injuries · Data collection · Final report · Oct 6, 2006 · N97811 · Substantial damage
  > the student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.
- [NTSB NYC06CA221](https://openairdocs.org/ntsb/NYC06CA221.md): Cessna 172P · Baltimore, MD · Accident · No injuries · Data collection · Final report · Sep 4, 2006 · N65659 · Substantial damage
  > The pilot's improper flare, which resulted in a hard landing.
- [NTSB LAX06CA281](https://openairdocs.org/ntsb/LAX06CA281.md): Cessna 172P · Spanish Springs, NV · Accident · No injuries · Data collection · Final report · Sep 1, 2006 · N97306 · Substantial damage
  > the pilot's failure to initiate a timely go-around and to attain an adequate climb rate. Factors in the accident were the high density altitude and the likely quartering tail wind that may have affected the aircraft's climb gradient.
- [NTSB ATL06CA123](https://openairdocs.org/ntsb/ATL06CA123.md): Cessna 172P · Chester, SC · Accident · No injuries · Data collection · Final report · Aug 19, 2006 · N51887 · Substantial damage
  > The CFI's failure to initiate a go-around when he noticed the flight was high and fast during the approach resulting in the flight landing long, overrunning the runway, and colliding with trees. Factors in the accident were a tail wind and a wet runway.
- [NTSB NYC06CA189](https://openairdocs.org/ntsb/NYC06CA189.md): Cessna 172P · Poughkeepsie, NY · Accident · No injuries · Data collection · Final report · Jul 29, 2006 · N97650 · Substantial damage
  > The student pilot's improper flare and failure to recover from a bounced landing, which resulted in a hard landing.
- [NTSB NYC06CA088](https://openairdocs.org/ntsb/NYC06CA088.md): Cessna 172-P · Cambridge, MD · Accident · No injuries · Data collection · Final report · Apr 6, 2006 · N54928 · Substantial damage
  > The student pilot's improper recovery from a bounced landing.
- [NTSB LAX06CA122](https://openairdocs.org/ntsb/LAX06CA122.md): Cessna 172P · Sedona, AZ · Accident · No injuries · Data collection · Final report · Feb 25, 2006 · N64423 · Substantial damage
  > The pilot's failure to maintain an adequate clearance from obstructions and diverted attention while taxiing.
- [NTSB LAX06LA108](https://openairdocs.org/ntsb/LAX06LA108.md): Cessna 172N · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Feb 11, 2006 · N739GY · 2 aircraft · Minor damage
  > the failure of the pilot of the other airplane to maintain an adequate clearance from obstacles while taxiing.
- [NTSB ATL06CA043](https://openairdocs.org/ntsb/ATL06CA043.md): Cessna 172P · Birmingham, AL · Accident · No injuries · Data collection · Final report · Feb 2, 2006 · N902NS · Substantial damage
  > An in-flight collision with a deer during a go around, which resulted in damage to the left main landing gear and subsequent collapse of the left main landing gear.

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

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