NTSB investigations: Mooney M20F, MO

9 cases on aircraft the registry lists as Mooney M20F. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

NTSB investigations: Mooney M20F, MO per year, 1969–2026: 9 cases
1969	1
1970	1
1971	1
1977	2
1981	1
1983	1
1996	1
1999	1

Where

Open the map

Latest cases

Query with 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" = 'MO' 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 ('5870214')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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\" = 'MO' 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 ('5870214'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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" = 'MO' 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 ('5870214'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CHI99FA101Accident · 1 fatalField investigationFinal reportMooney M20F · Cabool, MOThe pilot not maintaining an appropriate airspeed during the turn from base to final resulting in a stall.Mar 4, 1999 · N9381M · Destroyed NTSB CHI96LA182Accident · No injuriesLimited investigationFinal reportMooney M20F · Festus, MOthe pilot's not maintaining proper alignment with the runway and his inadequate compensation for wind conditions. A factor was the crosswind condition.May 31, 1996 · N9532M · Substantial damage NTSB MKC83LA080Accident · No injuriesLimited investigationFinal reportMooney M20F · Springfield, MOThe aircraft sustained damage when the left main and nose gears collapsed while the pilot was taxiing in from landing. The aircraft landed on runway 31 and had begun a right turn onto a taxiway when the nose gear and then the left main gear retracted. The…Mar 22, 1983 · N3386X · Substantial damage NTSB MKC81FCA24Accident · No injuriesClosedMooney M20F · Licking, MOJul 30, 1981 · N7402V · Substantial damage NTSB MKC77DCA19Accident · No injuriesClosedMooney M20F · Bismark, MOMay 10, 1977 · N7142V · Substantial damage NTSB MKC77FCG22Accident · No injuriesClosedMooney M20F · Moberly, MOMay 8, 1977 · N797MD · Substantial damage NTSB MKC71AK038Accident · 2 fatalClosedMooney M20F · Houston, MOJan 11, 1971 · N9139V · Destroyed NTSB MKC70AK042Accident · Serious injuriesClosedMooney M20F · Kansas City N., MOFeb 5, 1970 · N9699M · Destroyed NTSB MKC70A0030Accident · 4 fatalClosedMooney M-20F · St Louis, MONov 27, 1969 · N6493Q · Destroyed