NTSB investigations: Mooney M20F, CO
21 cases on aircraft the registry lists as Mooney M20F. 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.
Cases per year
| 1967 | 2 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1977 | 3 |
| 1979 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1995 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2014 | 1 |
| 2020 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('5870214'))
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 ('5870214'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN21LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Denver, COFailure of the landing gear motor that prevented the gear from extending fully to the down and locked position, which resulted in a gear collapse on landing and a subsequent loss of directional control.NTSB CEN15FA030Accident · 1 fatalField investigationFinal reportMooney M20 · Boulder, COThe loss of airplane control for reasons that could not be determined by the postaccident examination, which was limited due to impact damage and postcrash fire.NTSB DEN99LA133Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Montrose, COThe pilot's inadequate preflight planning and preparation and his failure to maintain clearance from the signpost. A factor was the signpost.NTSB FTW98FA378Accident · 2 fatalField investigationFinal reportMooney M20F · Fort Collins, COThe pilot's inadvertent stall/mush due to his excessive angle of bank during his traffic pattern turn to base. Factors were the pilot's improper downwind altitude, the pilot not properly setting his Kollsman Window in his altimeter, and the high density…NTSB FTW98LA224Accident · No injuriesLimited investigationFinal reportMooney M20F · Telluride, COThe pilot exceeded the crosswind capability performance of the aircraft, and his delayed response in initiating a go around. Factors were gusty, crosswind and tailwind conditions, and high density altitude.NTSB FTW95FA359Accident · 2 fatalField investigationFinal reportMooney M20F · Red Cliff, COImproper in-flight planning/decision by the flight crew, and their failure to maintain sufficient airspeed over mountainous terrain, which resulted in an inadvertent stall and collision with terrain. Factors relating to the accident were: high density…NTSB FTW95LA195Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Frederick, COThe pilot's use of unsuitable terrain for takeoff and his delay in initiating an abort. Factors were a soft and wet air strip.NTSB DEN86LA097Accident · No injuriesLimited investigationFinal reportMooney M20F · Longmont, COAccording to the plt, during the flare to touchdown, the acft stalled and the left wing contacted the ground along with four runway lights. The plt said the accident could have been prevented by maintaining a higher airspeed on apch.NTSB DEN83LA225Accident · No injuriesLimited investigationFinal reportMooney M20F · La Junta, COThe acft stalled into the ground during a takeoff in windy conditions. The winds were reported to be from 210 degrees at 22 KTS gusting to 28 KTS. The plt received a weather briefing from the fss and knew a strong crosswind from the left was present. He used…NTSB DEN82FA010Accident · 1 fatalClosedMooney M-21 · La Veta, CONTSB DEN79FA032Accident · 3 fatalClosedMooney M20F · Crestone, CONTSB MKC77FCQ57Accident · No injuriesClosedMooney M2OF · Holly, CONTSB DEN77DTE56Accident · Minor injuriesClosedMooney M20F · Fredrick, CONTSB DEN77FAO24Accident · 2 fatalClosedMooney M20F · Franktown, CONTSB DEN74DTE13Accident · No injuriesClosedMooney M20F · Meeker, CONTSB DEN72DTE32Accident · No injuriesClosedMooney M20F · Flagler, CONTSB DEN71FXD40Accident · No injuriesClosedMooney M20F · Aurora, CONTSB DEN69A0043Accident · 2 fatalClosedMooney M20F · Colorado Sps, CONTSB DEN68A0058Accident · 1 fatalClosedMooney M20F · Toponas, CONTSB DEN67A0075Accident · 2 fatalClosedMooney M20F · Longmont, CONTSB DEN67D0273Accident · No injuriesClosedMooney M20F · Las Animas, CO