# NTSB investigations: Cessna 172K, 2002

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 NYC03LA023](https://openairdocs.org/ntsb/NYC03LA023.md): Cessna 172K · Prestonsburg, KY · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N7192G · Substantial damage
  > The loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.
- [NTSB CHI03LA017](https://openairdocs.org/ntsb/CHI03LA017.md): Cessna 172 · Neenah, WI · Accident · No injuries · Limited investigation · Final report · Oct 17, 2002 · N46459 · Substantial damage
  > The pilot failed to maintain clearance from the post. Factors included the post and the sun glare.
- [NTSB IAD02LA080](https://openairdocs.org/ntsb/IAD02LA080.md): Cessna 172K · Patuxent River, MD · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2002 · N1177M · Substantial damage
  > The pilot's inadequate fuel calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.
- [NTSB DEN02FA084](https://openairdocs.org/ntsb/DEN02FA084.md): Cessna 172K · Greeley, CO · Accident · 1 fatal · Field investigation · Final report · Jul 31, 2002 · N7383G · Destroyed
  > the student pilot's improper handling of the airplane's controls (for reason undetermined), and the inadequate supervision of the flight instructor. A contributing factor was the high density altitude weather condition.
- [NTSB SEA02LA099](https://openairdocs.org/ntsb/SEA02LA099.md): Cessna 172K · Clarkston, WA · Accident · No injuries · Limited investigation · Final report · Jun 13, 2002 · N84840 · Substantial damage
  > The pilot's failure to maintain control of the aircraft during taxi along the gravel landing site after having landed off the designated runway. A contributing factor was the embankment which the aircraft's left wing impacted during taxi.
- [NTSB LAX02LA172](https://openairdocs.org/ntsb/LAX02LA172.md): Cessna 172K · Lake Thomas A., CA · Accident · Serious injuries · Limited investigation · Final report · May 24, 2002 · N79944 · Substantial damage
  > a partial loss of engine power due to the partial malfunction of the left magneto and leakage of the ignition leads for that magneto, due to inadequate maintenance inspections. Factors in the accident include the high density altitude, the maintenance…
- [NTSB DEN02LA045](https://openairdocs.org/ntsb/DEN02LA045.md): Cessna 172K · Cedar City, UT · Accident · No injuries · Limited investigation · Final report · May 22, 2002 · N78760 · Substantial damage
  > the pilot's inadvertent stall/mush during the landing flare/touchdown. A contributing factor was the gusty crosswind weather conditions.
- [NTSB DEN02FA017](https://openairdocs.org/ntsb/DEN02FA017.md): Cessna 172K · Boulder, CO · Accident · 1 fatal · Field investigation · Final report · Jan 5, 2002 · N78035 · Destroyed
  > the pilot's intentional suicidal flight into terrain. Contributing factors were the pilot's psychological depressive state, and his use of inappropriate medication.

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

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