NTSB investigations: Mooney M20E, MI

11 cases on aircraft the registry lists as Mooney M20E. 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 M20E, MI per year, 1965–2026: 11 cases
1965	2
1967	3
1969	2
1982	1
1994	1
2007	1
2017	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" = 'MI' 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 ('5870212')) 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\" = 'MI' 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 ('5870212'))
  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" = 'MI' 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 ('5870212'))
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 CEN17LA184Accident · No injuriesLimited investigationFinal reportMooney M20E · Dowling, MIInnacurate airspeed indications due to contamination of the pitot-static system with insect remains, which resulted in a high approach and landing speed and subsequent runway overrun.May 15, 2017 · N9265M · Substantial damage NTSB CHI08LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Muskegon, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing available to the pilot due to the presence of a residential sub-division and trees.Oct 13, 2007 · N1261X · Substantial damage NTSB CHI94LA328Accident · No injuriesLimited investigationFinal reportMooney M20E · Plymouth, MIthe pilot's improper (maintenance) modification and his initiating an operation with known deficiencies in equipmentSep 14, 1994 · N6944U · Substantial damage NTSB CHI82FA350Accident · 2 fatalField investigationFinal reportMooney M20E · Houghton, MIThe acft crashed into trees while making an ILS approach to Houghton county memorial arpt, hancock, MI. The weather was IMC and an IFR flt plan had been filed. The two occupants were held in the acft by seat belts and were fatally injured in the crash and…Sep 11, 1982 · N5518Q · Destroyed NTSB CHI70F0215Accident · No injuriesClosedMooney M20E · Grand Rapids, MISep 11, 1969 · N5664Q · Substantial damage NTSB CHI69F0569Accident · No injuriesClosedMooney M20E · Owosso, MIApr 9, 1969 · N1294X · Substantial damage NTSB CHI68F0285Accident · No injuriesClosedMooney M20E · Holland, MIAug 11, 1967 · N6943U · Substantial damage NTSB CHI67F0026Accident · No injuriesClosedMooney M20E · Alpena, MIMay 6, 1967 · N79828 · Substantial damage NTSB CHI67F0601Accident · No injuriesClosedMooney M20E · Kalamazoo, MIMar 29, 1967 · N6945U · Substantial damage NTSB CHI66F0447Accident · No injuriesClosedMooney M20E · Lewiston, MIJul 4, 1965 · N79828 · Substantial damage NTSB CHI65F0052Accident · No injuriesClosedMooney S-21 · Big Rapids, MIJun 16, 1965 · N1306W · Substantial damage