Fatal NTSB investigations: Mooney M20D

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

Fatal NTSB investigations: Mooney M20D per year, 1965–2026: 9 cases
1965	1
1967	2
1969	2
1980	1
1999	1
2004	1
2009	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870210')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870210'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870210'))
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 ERA09FA311Accident · 1 fatalField investigationFinal reportMooney M20D · Clintwood, VAThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.May 29, 2009 · N6628U · Substantial damage NTSB DEN04FA134Accident · 1 fatalField investigationFinal reportMooney M20D · Pagosa Springs, COthe pilot's inadequate preflight planning and his failure to maintain directional control. Contributing factors were the pilot's failure to abort the takeoff, and the rough and uneven runway surface.Sep 6, 2004 · N1907Y · Destroyed NTSB LAX99FA294Accident · 1 fatalField investigationFinal reportMooney M20D · Bear Valley, CAThe pilot's in-flight loss of control for undetermined reasons.Sep 2, 1999 · N6831U · Destroyed NTSB LAX80FA130Accident · 2 fatalClosedMooney M20C · Elk, CAAug 8, 1980 · N6624U · Destroyed NTSB MIA70A0006Accident · 4 fatalClosedMooney M20D · Winter Haven, FLJul 29, 1969 · N6640U · Destroyed NTSB FTW69A0065Accident · 2 fatalClosedMooney M20D · Ft Stockton, TXMar 22, 1969 · N7122U · Destroyed NTSB UNK67X0151Accident · 2 fatalClosedMooney M20D · Oshawa, CanadaAug 27, 1967 · N6828U · Destroyed NTSB MKC67A0074Accident · 2 fatalClosedMooney M20D · Boone, IAMay 31, 1967 · N5713Q · Destroyed NTSB FTW65A0108Accident · 1 fatalClosedMooney M20 · Jonesboro, ARMay 1, 1965 · N1976Y · Destroyed