# NTSB investigations: Cessna 172K, 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 ATL05LA031](https://openairdocs.org/ntsb/ATL05LA031.md): Cessna 172K · Smyrna, TN · Accident · No injuries · Limited investigation · Final report · Nov 29, 2004 · N78402 · Substantial damage
  > The pilot's inadequate preflight planning of fuel required for the flight, and his inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.
- [NTSB ATL05CA002](https://openairdocs.org/ntsb/ATL05CA002.md): Cessna 172K · Knoxville, TN · Accident · Serious injuries · Data collection · Final report · Oct 9, 2004 · N78211 · No damage
  > The pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.
- [NTSB ANC04LA074](https://openairdocs.org/ntsb/ANC04LA074.md): Cessna 172 · Yakutat, AK · Accident · No injuries · Limited investigation · Final report · Jul 8, 2004 · N172JL · Substantial damage
  > The pilot's selection of an unsuitable landing area, which resulted in the collapse of the landing gear, and subsequent nose over during the landing roll. A factor associated with the accident was soft terrain.
- [NTSB CHI04CA113](https://openairdocs.org/ntsb/CHI04CA113.md): Cessna 172K · Harrisonville, MO · Accident · Minor injuries · Data collection · Final report · May 1, 2004 · N7448G · Substantial damage
  > The dual student's failure to maintain directional control of the aircraft during the landing flare. Contributing factors were the dual student's failure to relinquish the controls to the flight instructor, the resulting inability of the flight instructor to…
- [NTSB FTW04CA106](https://openairdocs.org/ntsb/FTW04CA106.md): Cessna 172K · Bogalusa, LA · Accident · No injuries · Data collection · Final report · Apr 10, 2004 · N84623 · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW04LA085](https://openairdocs.org/ntsb/FTW04LA085.md): Cessna 172K · Angleton, TX · Accident · No injuries · Limited investigation · Final report · Feb 29, 2004 · N79502 · Destroyed
  > The unqualified person's failure to maintain clearance with the power lines. A contributing factor was the night light conditions.
- [NTSB LAX04FA096](https://openairdocs.org/ntsb/LAX04FA096.md): Cessna 172K · Grass Valley, CA · Accident · 2 fatal · Field investigation · Final report · Jan 20, 2004 · N99LR · Destroyed
  > the pilot's continued visual flight into instrument meteorological conditions and failure to maintain an adequate terrain/object clearance altitude. Also causal was the pilot's improper in-flight decision to return to the origin airport in the face of…

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

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