# NTSB investigations: Cessna 172F, 2003

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 CHI04LA012](https://openairdocs.org/ntsb/CHI04LA012.md): Cessna 172F · Columbus, NE · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 2003 · N5204F · Substantial damage
  > The student pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during an aborted takeoff. Factors associated with the accident were the crosswind condition, the delayed aborted takeoff, and the…
- [NTSB MIA03LA176](https://openairdocs.org/ntsb/MIA03LA176.md): Cessna 172F · Fajardo, PR · Accident · No injuries · Limited investigation · Final report · Sep 1, 2003 · N8578U · Destroyed
  > The pilot's inadequate aircraft preflight resulting in the airplane being operated with water contamination in the fuel system, and the loss of engine power.
- [NTSB CHI03LA065](https://openairdocs.org/ntsb/CHI03LA065.md): Cessna 172F · Waskish, MN · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 2003 · N8112U · Substantial damage
  > The inadequate preflight planning/preparation by the pilot. Contributing factors were the snow covered takeoff area and the tailwind.
- [NTSB MIA03LA048](https://openairdocs.org/ntsb/MIA03LA048.md): Cessna 172F · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Jan 28, 2003 · N5602R · Substantial damage
  > a total loss of engine power due to the failure the oil filter because of over-pressurization, resulting in damage to the airplane during the subsequent forced landing.

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

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

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