# NTSB investigations, 2004: On ground/water encounter with weather

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 DEN05MA029](https://openairdocs.org/ntsb/DEN05MA029.md): Canadair CL-600-2A12 · Montrose, CO · Accident · 3 fatal · Class 1 · Major · Final report · Nov 28, 2004 · N873G · Destroyed
  > the flight crew's failure to ensure that the airplane’s wings were free of ice or snow contamination that accumulated while the airplane was on the ground, which resulted in an attempted takeoff with upper wing contamination that induced the subsequent stall…
- [NTSB DEN05CA001](https://openairdocs.org/ntsb/DEN05CA001.md): Cessna 185F · Santa Fe, NM · Accident · No injuries · Data collection · Final report · Oct 1, 2004 · N714MX · Substantial damage
  > the pilot's failure to maintain aircraft control during the landing roll resulting in a ground loop. Contributing to the accident was the crosswind.
- [NTSB DEN04LA146](https://openairdocs.org/ntsb/DEN04LA146.md): Smith Aerostar 601P · Lordsberg, NM · Accident · No injuries · Limited investigation · Final report · Sep 21, 2004 · N11BE · Substantial damage
  > aircraft control not maintained by the pilot. Contributing to the accident was the dirt devil/whirlwind.
- [NTSB DEN04LA135](https://openairdocs.org/ntsb/DEN04LA135.md): Cessna 180 · Buena Vista, CO · Accident · No injuries · Limited investigation · Final report · Sep 6, 2004 · N727DG · Substantial damage
  > The pilot's failure to maintain directional control. Contributing to the accident was the gusty winds and the dirt devil encountered by the aircraft.
- [NTSB ANC04LA054](https://openairdocs.org/ntsb/ANC04LA054.md): Cessna 208B · Egegik, AK · Accident · No injuries · Limited investigation · Final report · May 16, 2004 · N9820F · Substantial damage
  > The captain's improper evaluation of the weather conditions and improper decision to taxi the airplane in high gusting wind conditions which resulted in the airplane's right wing striking the ground. A contributing factor was the high gusting wind.
- [NTSB MIA04CA040](https://openairdocs.org/ntsb/MIA04CA040.md): Cessna 210L · Fort Meade, FL · Accident · No injuries · Data collection · Final report · Jan 14, 2004 · N453MC · Substantial damage
  > The failure of the pilot to abort the takeoff after encountering fog during the preflight and engine run-up, and also his failure to maintain proper alignment with the runway during the takeoff roll due to a fogged windshield resulting in the collision with a…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 330)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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