NTSB investigations: Mooney M20K, 1991
4 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.
Cases per year
| 1979 | 4 |
|---|---|
| 1980 | 6 |
| 1981 | 8 |
| 1982 | 2 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 5 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 8 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 8 |
| 2004 | 5 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 5 |
| 2008 | 4 |
| 2009 | 2 |
| 2011 | 9 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 4 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 3 |
Where
Latest 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 year(c.\"eventDate\") = 1991
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 year(c."eventDate") = 1991
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" 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 CHI91LA283Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Burlington, WIThe pilot's exceeding the airplane's licensed gross weight and the pilot's improper preflight planning and preparation.NTSB SEA91LA176Accident · No injuriesLimited investigationFinal reportMooney M-20K · Mccall, IDAn on ground collision with an animal during the landing roll. A factor to the accident was: a dark night condition.NTSB CHI91LA071Accident · 1 fatalLimited investigationFinal reportMooney M20K · Fayette, MOThe failure of the pilot to maintain control of the airplane. Factors were the pilot's overconfidence in his personal ability, and flight into known adverse weather.NTSB NYC91FA058Accident · 1 fatalField investigationFinal reportMooney M20K · Gallipolis, OHThe pilot allowed the speed of the airplane to get too slow, resulting in an inadvertant stall at too low an altitude to allow recovery. A factor relating to the accident was the pilot's trepidation about a successful landing because of the weather.