NTSB investigations: Mooney M20C, UT

12 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

19672026

NTSB investigations: Mooney M20C, UT per year, 1967–2026: 12 cases
1967	1
1972	2
1978	1
1979	1
1980	1
1987	1
1991	1
1997	1
2003	1
2004	1
2007	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" = 'UT' 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\" = 'UT' 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" = 'UT' 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 SEA07LA177Accident · 2 fatalLimited investigationFinal reportMooney M20C · Price, UTThe pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…Jun 23, 2007 · N6713N · Substantial damage NTSB DEN04LA105Accident · No injuriesLimited investigationFinal reportMooney M20C · Escalante, UTthe improper installation of an oil pan quick-drain fitting resulting in the loss of engine oil, failure of the engine, and subsequent impact with terrain following an attempted forced landing. A contributing factor was the lack of suitable terrain for a…Jul 18, 2004 · N6773U · Substantial damage NTSB DEN03FA136Accident · 4 fatalField investigationFinal reportMooney M20C · Blanding, UTthe pilot's failure to maintain airspeed which resulted in a stall/spin.Jul 26, 2003 · N35KR · Destroyed NTSB SEA97LA184Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Bountiful, UTThe pilot's inadequate fuel management which resulted in fuel starvation.Aug 10, 1997 · N9666M · Substantial damage NTSB SEA91LA064Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Loa, UTThe pilot-in-command's failure to maintain airspeed on takeoff climb in a turn resulting in an inadvertnent stall and subsequent in flight collision with terrain. Contributing to the accident was a crosswind with gusts.Mar 10, 1991 · N7108U · Substantial damage NTSB DCA87MA018Accident · 10 fatalClass 1 · MajorFinal reportSwearingen SA-226TC · Kearns, UTThe two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…Jan 15, 1987 · N163SW · 2 aircraft · Destroyed NTSB DEN80FA024Accident · 1 fatalClosedMooney M20C · Scipio, UTFeb 6, 1980 · N6489U · Destroyed NTSB DEN79FTM18Accident · No injuriesClosedMooney M20C · Bullfrog, UTMay 25, 1979 · N2957L · Substantial damage NTSB DEN78DTM19Accident · Minor injuriesClosedMooney M20C · Kanab, UTMay 3, 1978 · N6489U · Substantial damage NTSB DEN73AD017Accident · 4 fatalClosedMooney M20C · Monticello, UTOct 18, 1972 · N5971Q · Destroyed NTSB DEN72AD035Accident · 2 fatalClosedMooney M20C · Dugway, UTFeb 4, 1972 · N9412V · Destroyed NTSB DEN67D0290Accident · No injuriesClosedMooney M20C · Moab, UTMay 4, 1967 · N5708Q · Substantial damage