# NTSB investigations: Mooney M20A, WY

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 SEA95LA180](https://openairdocs.org/ntsb/SEA95LA180.md): Mooney M20A · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Aug 11, 1995 · N8378E · Substantial damage
  > The pilot's failure to maintain control of the aircraft. Factors include the uneven runway condition, the information regarding the crowned condition not being disseminated by airport personnel, and the inadequate review/inspection of the condition by FAA…
- [NTSB DEN75AD037](https://openairdocs.org/ntsb/DEN75AD037.md): Mooney M20A · Rock Springs, WY · Accident · 1 fatal · Closed · Jan 5, 1975 · N8124E · Destroyed
- [NTSB DEN72AD044](https://openairdocs.org/ntsb/DEN72AD044.md): Mooney M20A · Lander, WY · Accident · 1 fatal · Closed · Apr 1, 1972 · N6041X · Destroyed
- [NTSB DEN67D0249](https://openairdocs.org/ntsb/DEN67D0249.md): Mooney M20A · Wheatland, WY · Accident · No injuries · Closed · Apr 1, 1967 · N6064X · Substantial damage
- [NTSB DEN67F0095](https://openairdocs.org/ntsb/DEN67F0095.md): Mooney M20 · Rawlins, WY · Accident · Minor injuries · Closed · Sep 5, 1966 · N1064B · Substantial damage
- [NTSB DEN65F0079](https://openairdocs.org/ntsb/DEN65F0079.md): Mooney M20A · Cheyenne, WY · Accident · No injuries · Closed · May 24, 1965 · N1063C · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=5870204&state=WY

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