# NTSB investigations: Mooney M20K, 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 NYC04LA191](https://openairdocs.org/ntsb/NYC04LA191.md): Mooney M20K · Edgartown, MA · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 2004 · N231LK · Substantial damage
  > The pilot's failure to maintain airspeed while performing maneuvers to land, which resulted in an inadvertent stall/mush. A factor was the gusting wind conditions.
- [NTSB DEN04CA117](https://openairdocs.org/ntsb/DEN04CA117.md): Mooney M20K · Jackson Hole, WY · Accident · Minor injuries · Data collection · Final report · Aug 8, 2004 · N11640 · Substantial damage
  > the pilot's failure to maintain aircraft control resulting in a stall/mush. Contributing factors include the windshear, the crosswind and the runway light.
- [NTSB DEN04FA079](https://openairdocs.org/ntsb/DEN04FA079.md): Mooney M20K · Pinedale, WY · Accident · 3 fatal · Field investigation · Final report · May 23, 2004 · N231DL · Destroyed
  > The pilot's inadvertent flight into adverse weather conditions, and his failure to maintain terrain clearance while maneuvering. Contributing factors were the downdraft, the snow shower weather and mountainous terrain.
- [NTSB LAX04FA162](https://openairdocs.org/ntsb/LAX04FA162.md): Mooney M20K · Los Angeles, CA · Accident · 2 fatal · Field investigation · Final report · Mar 17, 2004 · N1148V · Destroyed
  > The pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the low ceiling, reduced visibility (fog), and the pilot's lack of instrument flying currency. An additional factor was the failure of air traffic…
- [NTSB MIA04LA050](https://openairdocs.org/ntsb/MIA04LA050.md): Mooney M20K · Immokalee, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 2004 · N252WF · Substantial damage
  > A loss of engine power due to the airplane mechanic's improper maintenance/installation and failure to ensure that the B-nut on the inlet side of the fuel manifold was properly tightened, which resulted in a fuel leak, and fuel starvation.

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

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