# NTSB investigations: Mooney M20E, 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 GAA17CA260](https://openairdocs.org/ntsb/GAA17CA260.md): Mooney M20 · Olathe, KS · Accident · Minor injuries · Data collection · Final report · May 2, 2017 · N7118U · Substantial damage
  > The separated fuel tank selector knob roll pin, which prevented the fuel selector from moving to the fuel tank position for the tank with usable fuel and resulted in fuel starvation and the subsequent total loss of engine power.
- [NTSB MKC85FA012](https://openairdocs.org/ntsb/MKC85FA012.md): Mooney M20E · Carbondale, KS · Accident · 3 fatal · Field investigation · Final report · Nov 1, 1984 · N79846 · Destroyed
  > The flt was en route from little rock, AR, to topeka, ka. Ten miles south of topeka's frobes field the plt requested wx info and was told that a current observation was being taken & he would be advised. Contact between the tower and the flt could not be…
- [NTSB MKC74AK017](https://openairdocs.org/ntsb/MKC74AK017-201612.md): Mooney M20E · Cassoday, KS · Accident · 1 fatal · Closed · Oct 9, 1973 · N6985U · Destroyed
- [NTSB MKC74DCQ08](https://openairdocs.org/ntsb/MKC74DCQ08.md): Mooney M20E · Hugoton, KS · Accident · No injuries · Closed · Aug 23, 1973 · N5743Q · Substantial damage
- [NTSB MKC71AK017](https://openairdocs.org/ntsb/MKC71AK017.md): Mooney M20E · Enterprise, KS · Accident · No injuries · Closed · Oct 3, 1970 · N1287X · Substantial damage
- [NTSB MKC71DCG15](https://openairdocs.org/ntsb/MKC71DCG15.md): Mooney M20E · Kansas City, KS · Accident · No injuries · Closed · Aug 7, 1970 · N2716W · Substantial damage
- [NTSB MKC69F0216](https://openairdocs.org/ntsb/MKC69F0216.md): Mooney M20E · Johnson, KS · Accident · No injuries · Closed · Sep 25, 1968 · N6009Q · Substantial damage
- [NTSB MKC68F0414](https://openairdocs.org/ntsb/MKC68F0414.md): Mooney M20E · Wichita, KS · Accident · No injuries · Closed · Jan 28, 1968 · N2716W · Substantial damage
- [NTSB MKC67D0588](https://openairdocs.org/ntsb/MKC67D0588.md): Mooney M20E · Garden City, KS · Accident · No injuries · Closed · May 17, 1967 · N79858 · Substantial damage
- [NTSB MKC67D0324](https://openairdocs.org/ntsb/MKC67D0324.md): Mooney M20E · Wallace, KS · Accident · No injuries · Closed · Oct 30, 1966 · N2725W · Substantial damage
- [NTSB MKC67A0028](https://openairdocs.org/ntsb/MKC67A0028.md): Mooney M20E · Spring Hill, KS · Accident · 2 fatal · Closed · Oct 13, 1966 · N7113U · Destroyed
- [NTSB MKC67D0139](https://openairdocs.org/ntsb/MKC67D0139.md): Mooney M20E · Portis, KS · Accident · No injuries · Closed · Jul 12, 1966 · N79329 · Substantial damage
- [NTSB MKC65A0055](https://openairdocs.org/ntsb/MKC65A0055.md): Mooney M-20E · Colby, KS · Accident · 4 fatal · Closed · Mar 22, 1965 · N6936U · Destroyed

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

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