NTSB investigations: Mooney M20C, SD

10 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, SD per year, 1965–2026: 10 cases
1965	2
1966	2
1967	1
1968	1
1969	1
1970	1
1987	1
1998	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" = 'SD' 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 ('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.\"eventStateOrRegion\" = 'SD' 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 ('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."eventStateOrRegion" = 'SD' 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 ('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 CHI98LA104Accident · No injuriesLimited investigationFinal reportMooney M20C · White River, SDthe pilot's delay in applying carburetor heat. A factor associated with the accident was the low altitude at which the pilot was flying which limited his landing site selections when the loss of power occurred.Mar 10, 1998 · N6235U · Substantial damage NTSB DEN87LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Eureka, SDAfter normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.Feb 11, 1987 · N3451X · Substantial damage NTSB MKC70AK056Accident · 2 fatalClosedMooney M20C · Rosholt, SDApr 14, 1970 · N6759U · Destroyed NTSB MKC69F0457Accident · No injuriesClosedMooney M-20C · Lake Andes, SDMay 5, 1969 · N7820V · Substantial damage NTSB MKC68A0058Accident · 1 fatalClosedMooney M20C · Wessgtn Spg, SDApr 4, 1968 · N3437X · Destroyed NTSB MKC67D0623Accident · No injuriesClosedMooney M20C · Sioux Falls, SDJun 12, 1967 · N6035Q · Substantial damage NTSB MKC67D0226Accident · No injuriesClosedMooney M20C · Pickstown, SDSep 24, 1966 · N6430U · Substantial damage NTSB MKC67F0129Accident · Serious injuriesClosedMooney M20C · Murdo, SDJul 7, 1966 · N6095Q · Destroyed NTSB MKC66A0035Accident · 1 fatalClosedMooney M-20C · Timber Lake, SDDec 22, 1965 · N7880V · Destroyed NTSB MKC66D0265Accident · No injuriesClosedMooney M20C · Iona, SDAug 11, 1965 · N79334 · Substantial damage