# NTSB investigations: Mooney M20A, KS

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 MKC83FCQ01](https://openairdocs.org/ntsb/MKC83FCQ01.md): Mooney M20A · Halstead, KS · Accident · Serious injuries · Final report · Oct 12, 1982 · N8311E · Substantial damage
  > During arrival, the pilot noted that the wind was from the northwest. He estimate it was from 330 deg at 20, gusting 35 KTS. On final approach, the aircraft was reportedly unstable due to gusty winds and turbulence. The pilot observed and was aware of the…
- [NTSB MKC79FCG51](https://openairdocs.org/ntsb/MKC79FCG51.md): Mooney M20A · Hillsdale, KS · Accident · No injuries · Closed · Jun 26, 1979 · N6072X · Substantial damage
- [NTSB MKC66F0377](https://openairdocs.org/ntsb/MKC66F0377.md): Mooney M20A · Goodland, KS · Accident · No injuries · Closed · Jan 2, 1966 · N8139E · Substantial damage
- [NTSB MKC66D0371](https://openairdocs.org/ntsb/MKC66D0371.md): Mooney M20A · Kansas City, KS · Accident · No injuries · Closed · Dec 31, 1965 · N6562B · Substantial damage
- [NTSB UNK64X2251](https://openairdocs.org/ntsb/UNK64X2251.md): Mooney M20 · Bucklin, KS · Accident · No injuries · Closed · Jun 12, 1964 · N6020X · Substantial damage
- [NTSB UNK64X1080](https://openairdocs.org/ntsb/UNK64X1080.md): Mooney M21 · Kansas City, KS · Accident · No injuries · Closed · Mar 28, 1964 · N8370E · 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" = 'KS' 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=KS

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