# NTSB investigations: Cessna 172, 2008

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 WPR09LA056](https://openairdocs.org/ntsb/WPR09LA056.md): Cessna 172 · Lompoc, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 10, 2008 · N6461E · Substantial damage
  > The pilot's failure to maintain clearance from the power line. Contributing to the accident was the pilot's lack of recent experience.
- [NTSB NYC08CA303](https://openairdocs.org/ntsb/NYC08CA303.md): Cessna 172 · Newton, MS · Accident · No injuries · Data collection · Final report · Aug 30, 2008 · N6478E · Substantial damage
  > The pilot's failure to maintain aircraft control while landing.
- [NTSB MIA08CA157](https://openairdocs.org/ntsb/MIA08CA157.md): Cessna 172 · Wingate, NC · Accident · No injuries · Data collection · Final report · Aug 2, 2008 · N6026A · Substantial damage
  > The student pilot's failure to maintain control of the airplane during a go-around.
- [NTSB DEN08LA129](https://openairdocs.org/ntsb/DEN08LA129.md): Cessna 172 · Athens, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 2008 · N6257E · Substantial damage
  > A partial loss of engine power during initial climb due to undetermined reasons, which led to an uncontrolled descent and subsequent aerodynamic stall. Contributing to the accident was the pilot's improper preflight decision to attempt the flight with a…
- [NTSB LAX08CA164](https://openairdocs.org/ntsb/LAX08CA164.md): Cessna 172 · Santa Rosa, CA · Accident · Minor injuries · Data collection · Final report · Jun 6, 2008 · N6494E · Substantial damage
  > The pilot's improper in-flight decision making and inadequate fuel consumption calculations that resulted in fuel exhaustion.
- [NTSB SEA08CA132](https://openairdocs.org/ntsb/SEA08CA132.md): Cessna 172 · Big Timber, MT · Accident · No injuries · Data collection · Final report · May 10, 2008 · N8103E · Substantial damage
  > The student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.
- [NTSB SEA08FA116](https://openairdocs.org/ntsb/SEA08FA116.md): Cessna 172N · McCall, ID · Accident · 3 fatal · Field investigation · Final report · May 3, 2008 · N75856 · 2 aircraft · Destroyed
  > The failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.
- [NTSB CHI08CA090](https://openairdocs.org/ntsb/CHI08CA090.md): Cessna 172 · Apple River, IL · Accident · No injuries · Data collection · Final report · Mar 1, 2008 · N8366B · Substantial damage
  > The pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. Contributing factors were a crosswind and a 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") = 2008
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072402'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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