NTSB investigations: Mooney M20K, CO

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

19802026

NTSB investigations: Mooney M20K, CO per year, 1980–2026: 11 cases
1980	1
1984	1
1985	1
1987	1
1988	1
2002	1
2003	2
2005	1
2013	1
2023	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" = 'CO' 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 ('5870220')) 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\" = 'CO' 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 ('5870220'))
  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" = 'CO' 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 ('5870220'))
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 CEN24LA030Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Lamar, COThe pilot's inadequate fuel planning and improper in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.Oct 31, 2023 · N1167J · Substantial damage NTSB CEN13LA388Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Hudson, COThe pilot's improper fuel management, which resulted in the loss of engine power due to fuel starvation.Jun 28, 2013 · N5254G · Substantial damage NTSB DEN05LA139Accident · No injuriesLimited investigationFinal reportMooney M20K · Englewood, COthe pilot's failure to maintain control of the airplane and the pilot's improper use of unusual attitude recovery procedure. Contributing factors were the failure of the HSI and the clouds.May 29, 2005 · N928MB · Substantial damage NTSB DEN04LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Grand Junction, COthe pilot's improper flare and his failure to maintain airspeed resulting in a stall and hard landing.Oct 14, 2003 · N5659L · Substantial damage NTSB DEN03LA086Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Colorado Sprngs, COthe pilot's improper decision to land in the reported crosswind conditions, and his failure to maintain aircraft control. Contributing factors were the crosswind, rough terrain, airport stop sign, and fence.May 24, 2003 · N231JM · Substantial damage NTSB DEN03LA024Accident · No injuriesLimited investigationFinal reportMooney M20K · Eagle, COthe pilot's failure to remove protective coverings from the engine air scoops during the preflight inspection, resulting in air starvation and a loss of engine power shortly after takeoff. A contributing factor was the lack of suitable terrain for a forced…Dec 10, 2002 · N252DR · Substantial damage NTSB DEN88LA143Accident · No injuriesLimited investigationFinal reportMooney M-20K · Gunnison, COJul 1, 1988 · N231PG · Substantial damage NTSB DEN87FA148Accident · 2 fatalField investigationFinal reportMooney M20K · Broomfield, CODrg takeoff, the baggage door (bd) came open. Twr psnl advised the plt, but recd no discernible reply. At aprx 100' AGL,the acft pitched up & rolled left, then entered a steep dscnt & crashed aprx 500' left of the rwy. Except for the bd, nopreimpact mech…Jun 14, 1987 · N4047H · Destroyed NTSB DEN85LA158Accident · No injuriesLimited investigationFinal reportMooney M20K · Lafayette, COOn June 8, 1985, a Mooney M20K, impacted the ground off the rwy while landing at alexander dawson arpt, Lafayette, o. the plt said he was attempting to make a short field apchto the plt, the apch was high and fast. The acft landed, porpoised, and departed the…Jun 8, 1985 · N5764N · Substantial damage NTSB DEN84FA107Accident · 1 fatalField investigationFinal reportMooney M20K · Craig, COWitnesses observed & heard the plt making an apch & subsequent go-around or pass over the ground at the arpt. Heavy fog conditions existed which were below IFR minimums. The plt failed to realize higher terrain exsisted north of the arpt. The acft collided…Mar 10, 1984 · N231F · Destroyed NTSB DEN81FA010Accident · 5 fatalClosedMooney MZ0K · Grand Junction, CONov 8, 1980 · N231GP · Destroyed