NTSB investigations: Mooney M20C, WI
18 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 3 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 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\" = 'WI' 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" = 'WI' 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 GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.NTSB CHI94LA101Accident · No injuriesLimited investigationFinal reportMooney M20C · Richland Center, WIimproper use of carburetor heat. Factors related to the accident were carburetor icing conditions, and the sign and fence poles.NTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.NTSB CHI90DER06Accident · 1 fatalFinal reportMooney M20C · Webster, WIThe pilot's failure to maintain control of the airplane. Factors related to the accident were: the dark night, the pilot's alcohol impairment, and his night flying restriction.NTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…NTSB CHI83LA131Accident · No injuriesLimited investigationFinal reportMooney M20C · Solon Springs, WIThe pilot reported that when he departed Solon Springs, WI at 2100 CST, the weather was windy, but the sky was clear. He landed at minneapolis, MN to pick up a passenger, then departed on a return flight to Solon. While returning, he encountered snow. The…NTSB CHI82DA029Accident · No injuriesFinal reportMooney M-20 · Shell Lake, WIThe pilot initiated his takeoff roll on a runway covered with hard packed snow. As the nosewheel was lifted off of the runway, the aircraft started to drift left. The pilot stated that when he applied right rudder and slightly lowered the nose, the plane came…NTSB CHI73FEP39Accident · No injuriesClosedMooney M20C · Middleton, WINTSB CHI72FEP31Accident · Minor injuriesClosedMooney M20C · Franksville, WINTSB CHI72DEP20Accident · No injuriesClosedMooney M20C · Dodgeville, WINTSB CHI72FEP09Accident · No injuriesClosedMooney M20C · La Crosse, WINTSB CHI71FDJ01Accident · Serious injuriesClosedMooney M20C · Union Grove, WINTSB CHI69A0053Accident · 3 fatalClosedMooney M20C · Rhinelander, WINTSB CHI68A0049Accident · 3 fatalClosedMooney M20C · Cable, WINTSB CHI68A0040Accident · 1 fatalClosedMooney M20C · Athelstane, WINTSB CHI68D0305Accident · No injuriesClosedMooney 20C · Park Falls, WINTSB CHI67F0268Accident · Minor injuriesClosedMooney M20C · Crivitz, WINTSB CHI66A0019Accident · 1 fatalClosedMooney M-20C · Beloit, WI