Skip to content

NTSB investigations: Mooney M20C, CO

38 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

19642026

Where

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 ('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\" = '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 ('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" = '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 ('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 CEN15FA051Accident · 2 fatalField investigationFinal reportMooney M20C · Pagosa Springs, COThe noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.Nov 15, 2014 · N6466U · Destroyed NTSB CEN09FA147Accident · 1 fatalField investigationFinal reportMooney M20C · Elbert, COThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control.Feb 1, 2009 · N7774M · Substantial damage NTSB DEN03LA117Accident · No injuriesLimited investigationFinal reportMooney M20C · Englewood, COthe pilot's failure to maintain aircraft control during landing. Factors contributing to the accident were the gusting crosswinds and the high density altitude.Jul 1, 2003 · N2686W · Substantial damage NTSB DEN03LA047Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Colo Springs, COthe pilot's failure to maintain aircraft control during initial climb which resulted in impact with terrain. Contributing factors include the downdraft, crosswind and gusty wind conditions.Mar 9, 2003 · N9313V · Substantial damage NTSB DEN02LA072Accident · No injuriesLimited investigationFinal reportMooney M20C · Watkins, COthe pilot's failure to use the pre-landing checklist, resulting in an inadvertent wheels up landing.Jun 30, 2002 · N6283U · Substantial damage NTSB DEN02FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Glenwood Sprngs, COthe pilot's failure to maintain aircraft control due to spatial disorientation, resulting in a collision with terrain. Contributing factors were the pilot's lack of an instrument rating and the dark night conditions.Mar 11, 2002 · N1323D · Destroyed NTSB DEN00LA153Accident · No injuriesLimited investigationFinal reportMooney M20C · Erie, COFailure by the pilot to follow procedures and lower the landing gear.Jul 24, 2000 · N5549Q · Substantial damage NTSB DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.Jul 22, 2000 · N6253U · Substantial damage NTSB DEN00LA054Accident · No injuriesLimited investigationFinal reportMooney M-20C · Boulder, COThe pilot not following procedures in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing, weather conditions conducive to carburetor ice, and lack of suitable terrain for landing.Feb 26, 2000 · N90MR · Substantial damage NTSB FTW95LA024Accident · No injuriesLimited investigationFinal reportMooney M20C · Greeley, COInadvertent landing gear retraction by the pilot flying the aircraft. A factor was inadequate supervision by the flight instructor.Oct 21, 1994 · N6958V · Substantial damage NTSB DEN87LA242Accident · No injuriesLimited investigationFinal reportMooney M20K · Aspen, COWhile on a cross country pleasure flt the acft engine failed apx four miles short of the dest aprt. A forced landing was made in a field.Sep 20, 1987 · N6874U · Destroyed NTSB DEN81FTE69Accident · Minor injuriesClosedMooney M20C · Delta, COSep 13, 1981 · N78899 · Destroyed NTSB DEN79FTE50Accident · Serious injuriesClosedMooney M20C · Falcon, COJun 22, 1979 · N6776V · Destroyed NTSB DEN78FTE61Accident · No injuriesClosedMooney M20C · Bennett, COJun 6, 1978 · N3528H · Substantial damage NTSB DEN77FTE71Accident · No injuriesClosedMooney M20C · Aurora, COAug 12, 1977 · N6725N · Substantial damage NTSB DEN77FA039Accident · 1 fatalClosedMooney M20C · Silver Plume, COMay 1, 1977 · N9685M · Destroyed NTSB DEN73DTE45Accident · No injuriesClosedMooney M20C · Englewood, COJan 14, 1973 · N6482U · Substantial damage NTSB DEN72AD038Accident · 1 fatalClosedMooney M20C · Parshall, COFeb 29, 1972 · N9766M · Destroyed NTSB DEN72FTE15Accident · No injuriesClosedMooney M20C · Littleton, COAug 14, 1971 · N6812U · Substantial damage NTSB DEN70DXD20Accident · No injuriesClosedMooney M20C · Sterling, COApr 5, 1970 · N6229U · Substantial damage NTSB DEN70AD051Accident · 1 fatalClosedMooney M20C · Colo.Springs, COMar 26, 1970 · N6259U · Destroyed NTSB DEN69D0154Accident · No injuriesClosedMooney M20C · Loveland, COOct 31, 1968 · N6935N · Substantial damage NTSB DEN69D0131Accident · No injuriesClosedCessna 195 · Broomfield, COSep 14, 1968 · N1015D · 2 aircraft · Substantial damage NTSB DEN69A0006Accident · 1 fatalClosedMooney M20C · Wetmore, COAug 10, 1968 · N5917Q · Destroyed NTSB DEN68A0053Accident · 4 fatalClosedMooney M20C · Littleton, COMay 24, 1968 · N6706U · Destroyed NTSB DEN68F0237Accident · No injuriesClosedMooney M20C · Broomfield, COApr 2, 1968 · N6406U · Substantial damage NTSB DEN68F0091Accident · No injuriesClosedMooney M20C · Broomfield, COAug 27, 1967 · N6482U · Substantial damage NTSB DEN67D0229Accident · No injuriesClosedMooney M20C · Walden, COMar 19, 1967 · N6229U · Substantial damage NTSB DEN67D0163Accident · No injuriesClosedMooney M20C · Colorado Spg, CONov 26, 1966 · N3381X · Substantial damage NTSB DEN67A0025Accident · 2 fatalClosedMooney M20C · Rye, COSep 24, 1966 · N6777U · Destroyed NTSB DEN67D0038Accident · No injuriesClosedMooney M20-C · Littleton, COJun 11, 1966 · N6519U · Substantial damage NTSB DEN66F0188Accident · No injuriesClosedMooney M20C · Denver, CONov 28, 1965 · N1219X · Substantial damage NTSB DEN66F0118Accident · No injuriesClosedMooney M20C · Boulder, COOct 1, 1965 · N6722U · Substantial damage NTSB DEN66D0079Accident · Minor injuriesClosedMooney M20C · Pueblo, COAug 8, 1965 · N6259U · Substantial damage NTSB DEN66D0116Accident · No injuriesClosedMooney M20C · Broomfield, COAug 4, 1965 · N6447U · Substantial damage NTSB DEN65D0100Accident · Minor injuriesClosedMooney 20C · Delta, COMay 20, 1965 · N185DC · Substantial damage NTSB DEN65A0052Accident · 1 fatalClosedMooney M-20 · Estcliffe, COJan 24, 1965 · N1365W · Destroyed NTSB UNK64X3834Accident · 1 fatalClosedMooney M20C · Alamosa, COSep 6, 1964 · N6815U · Destroyed