NTSB investigations: Mooney M20C, MN
16 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.
Cases per year
| 1967 | 2 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1974 | 3 |
| 1975 | 2 |
| 1988 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 2002 | 1 |
| 2017 | 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\" = 'MN' 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" = 'MN' 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" 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 CEN17LA101Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Ellendale, MNThe pilot’s incapacitation from carbon monoxide poisoning in flight due to cracks in the exhaust muffler, which resulted in the airplane’s continued flight until it ran out of fuel and its subsequent collision with terrain.NTSB CHI02LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Warroad, MNThe loss of engine power due to the failure of the muffler baffles which blocked the exhaust system. A factor to the accident was the treeline.NTSB CHI93LA231Accident · No injuriesLimited investigationFinal reportMooney M20C · Eveleth, MNThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI91FA116Accident · 1 fatalField investigationFinal reportMooney M-20C · Prior Lake, MNFailure to maintain airspeed while executing a forced landing. Factors related to the accident were the pilot's improper inflight planning/decision, and fuel exhaustion.NTSB CHI88LA086Accident · No injuriesLimited investigationFinal reportMooney M-20C · Minneapolis, MNWhile executing touch and go landings the pilot's attention was diverted inside the aircraft while adjusting the interior lights to determine the position of the flaps. He lost control of the aircraft and it departed the runway striking a snow bank.NTSB MKC75DER63Accident · No injuriesClosedMooney M20C · Winona, MNNTSB MKC75DER46Accident · No injuriesClosedMooney M20C · Hector, MNNTSB MKC75AK018Accident · Minor injuriesClosedMooney M20C · Stewartville, MNNTSB MKC75DER05Accident · No injuriesClosedMooney M20C · Winona, MNNTSB MKC74FER63Accident · No injuriesClosedMooney M20C · Crystal, MNNTSB MKC72DER25Accident · No injuriesClosedMooney M20C · Walnut Grove, MNNTSB MKC71AK023Accident · 3 fatalClosedMooney M20C · St Cloud, MNNTSB MKC69D0384Accident · No injuriesClosedMooney M20C · Rosemount, MNNTSB MKC69D0029Accident · No injuriesClosedMooney M20C · Grand Rapids, MNNTSB MKC68F0003Accident · Minor injuriesClosedMooney 20C · Willmar, MNNTSB MKC67A0063Accident · 1 fatalClosedMooney M20C · Austin, MN