# NTSB investigations: Cessna 172E, 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 IAD05LA013](https://openairdocs.org/ntsb/IAD05LA013.md): Cessna 172E · Rupert, WV · Accident · No injuries · Limited investigation · Final report · Nov 21, 2004 · N3750S · Substantial damage
  > The pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.
- [NTSB SEA04LA182](https://openairdocs.org/ntsb/SEA04LA182.md): Cessna 172E · Port Angeles, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 2004 · N5788T · Substantial damage
  > The pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors contributing to the accident included the fence and the ditch.
- [NTSB CHI04FA234](https://openairdocs.org/ntsb/CHI04FA234.md): Cessna 172E · Decorah, IA · Accident · 2 fatal · Field investigation · Final report · Aug 22, 2004 · N5410T · Destroyed
  > The pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…
- [NTSB DEN04CA097](https://openairdocs.org/ntsb/DEN04CA097.md): Cessna 172E · La Junta, CO · Accident · No injuries · Data collection · Final report · Jul 4, 2004 · N3581S · Destroyed
  > the student pilot's failure to maintain aircraft control and adequate airspeed during the go-around resulting in an inadvertent stall. Contributing to the accident was the low airspeed and altitude.
- [NTSB SEA04LA053](https://openairdocs.org/ntsb/SEA04LA053.md): Cessna 172E · Raymond, WA · Accident · No injuries · Limited investigation · Final report · Mar 21, 2004 · N3950S · Substantial damage
  > The pilot's failure to maintain directional control during the landing roll resulting in the aircraft nosing over. Incorrect remedial action and soft terrain were factors.
- [NTSB NYC04CA068](https://openairdocs.org/ntsb/NYC04CA068.md): Cessna 172E · Batavia, NY · Accident · No injuries · Data collection · Final report · Feb 15, 2004 · N369WP · Substantial damage
  > The pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.

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

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