Final NTSB investigations: Mooney M20F, ND

6 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

19672026

Final NTSB investigations: Mooney M20F, ND per year, 1967–2026: 6 cases
1967	1
1969	1
1976	1
1977	1
1982	2

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" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    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" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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 DEN82DA170Accident · Minor injuriesFinal reportMooney M-20F · Arthur, NDThe pilot landed long and fast. The aircraft collided with an elevated roadbed, shearing off the landing gear.Aug 21, 1982 · N9066V · Substantial damage NTSB DEN82DA058Accident · No injuriesFinal reportMooney M20F · Crosby, NDThe pilot reported that the runway had a 6 to 7 ft snowbank on the left side of the runway and a 2 to 3 ft snowbank on the right side. Also, water was on the runway intermittently along the entire length. After landing, the plane started hydroplaning. As the…Apr 13, 1982 · N7446V · Substantial damage NTSB MKC77FTG07Accident · Serious injuriesClosedMooney M20F · Lawton, NDMay 20, 1977 · N9510M · Destroyed NTSB MKC76AK039Accident · 1 fatalClosedMooney M20F · Lakota, NDJan 23, 1976 · N7746M · Destroyed NTSB MKC69A0051Accident · 1 fatalClosedMooney M20F · Jamestown, NDMar 2, 1969 · N9720M · Destroyed NTSB MKC68F0057Accident · No injuriesClosedMooney M20C · Minot, NDJun 10, 1967 · N3386X · Substantial damage