NTSB investigations: Mooney M20F, OK

14 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

19682026

NTSB investigations: Mooney M20F, OK per year, 1968–2026: 14 cases
1968	1
1969	3
1970	1
1976	1
1977	1
1981	1
1983	1
1987	1
1990	1
1995	1
1997	1
2012	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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 CEN12LA368Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Hooker, OKThe pilot’s loss of airplane control after a partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures, which resulted in an…Jun 12, 2012 · N6455Q · Substantial damage NTSB FTW97LA153Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marietta, OKThe pilot's inadequate short field takeoff. A factor was the pilot's lack of recent experience in short field takeoffs from a grass/turf runway.Apr 6, 1997 · N6492Q · Substantial damage NTSB FTW95LA092Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Miami, OKThe pilot's failure to maintain control of the airplane during takeoff due to his attention being diverted. Factors were the passenger's seat belt buckle blocking the gear up latching mechanism, and his lack of familiarity with the airplane.Jan 14, 1995 · N4024N · Substantial damage NTSB FTW90DPJ04Accident · 1 fatalFinal reportMooney M20F · Bethany, OKLoss of control in flight when the pilot stalled and spun the airplane inadvertently while turning to the base leg. A factor was lack of night flying time.Apr 3, 1990 · N3514X · Destroyed NTSB FTW87DPJ07Accident · No injuriesFinal reportMooney M20F · Jenks, OKEngine failed during initial climb. Aircraft collided with airport perimeter fence and slid across road during landing attempt. Water was found in the fuel distributor system following the accident.Sep 17, 1987 · N9520M · Substantial damage NTSB FTW84FA100Accident · 2 fatalField investigationFinal reportMooney M20F · Ada, OKThe eng lost power shortly after takeoff & the acft stalled while in a slight left turn. Examination revealed that the left wing fuel sump drain contained frozen water in the drain ports. The fuel injector screen, after thawing out, contained frozen water…Dec 22, 1983 · N7165V · Minor damage NTSB FTW81FA029Accident · 2 fatalClosedMooney M20F · Bethany, OKFeb 6, 1981 · N7100V · Destroyed NTSB FTW77FA042Accident · 2 fatalClosedMooney MK-21 · El Reno, OKMar 14, 1977 · N6440Q · Destroyed NTSB FTW76FPJ51Accident · Serious injuriesClosedMooney M20F · Norman, OKSep 18, 1976 · N9521M · Destroyed NTSB FTW71FPJ15Accident · No injuriesClosedMooney M20F · Oklahoma Cty, OKAug 20, 1970 · N9321V · Substantial damage NTSB FTW70I0256Incident · No injuriesClosedMooney M-20F · Checotah, OKSep 26, 1969 · N2987L · Minor damage NTSB FTW70A0001Accident · 2 fatalClosedMooney M20F · El Reno, OKJul 3, 1969 · N9143V · Destroyed NTSB FTW69D0485Accident · No injuriesClosedMooney M20F · Okla City, OKApr 21, 1969 · N9724M · Substantial damage NTSB FTW68D0439Accident · No injuriesClosedMooney M20F · Webber Falls, OKFeb 4, 1968 · N3881N · Substantial damage