NTSB investigations: Mooney M20C, Outside the U.S.

9 cases on aircraft the registry lists as Mooney M20C. 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

19652026

NTSB investigations: Mooney M20C, Outside the U.S. per year, 1965–2026: 9 cases
1965	2
1967	1
1970	2
1972	1
1984	1
2004	1
2005	1

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."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 ('5870208')) 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.\"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 ('5870208'))
  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."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 ('5870208'))
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 MIA05WA137Accident · No injuriesForeign investigationMooney M20C · Albenga, ItalyJul 8, 2005 · N90TK · Destroyed NTSB FTW04WA154Accident · No injuriesForeign investigationMooney M20C · Mazamitla, MexicoJan 11, 2004 · N6763V · Destroyed NTSB MIA84LA259Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bimini, BahamasThe plt reported that he had been airborne for about 30 min when eng missed one time and stopped running. He attempted to switch fuel tanks but the selector only went to the off position and stuck. The plt ditched about 20 mi nw of Bimini island.Sep 24, 1984 · N6770U · Destroyed NTSB MIA72OKT70Accident · Minor injuriesClosedMooney M20C · Porvenir Islnd, RPFeb 26, 1972 · N5844Q · Substantial damage NTSB MIA71OM015Accident · 2 fatalClosedMooney M20C · C.Engano, DRAug 12, 1970 · N7102U · Destroyed NTSB CAN71AA906Accident · Minor injuriesClosedMooney M20C · Drummond Sta, CanadaJun 30, 1970 · N6590U · Substantial damage NTSB LAX68O0299Accident · No injuriesClosedMooney M-21 · Montemorelos, MexicoJun 25, 1967 · N9316M · Substantial damage NTSB UNK65X1490Accident · No injuriesClosedMooney M21 · Freeport, Burkina FasoApr 30, 1965 · N7836V · Substantial damage NTSB UNK65X1476Accident · No injuriesClosedMooney M20 · Mulege, MexicoMar 18, 1965 · N6690U · Substantial damage