NTSB investigations: Mooney M20E, 2024
4 cases on aircraft the registry lists as Mooney M20E. 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
| 1964 | 20 |
|---|---|
| 1965 | 34 |
| 1966 | 48 |
| 1967 | 55 |
| 1968 | 34 |
| 1969 | 23 |
| 1970 | 28 |
| 1971 | 18 |
| 1972 | 16 |
| 1973 | 21 |
| 1974 | 6 |
| 1975 | 12 |
| 1976 | 11 |
| 1977 | 9 |
| 1978 | 12 |
| 1979 | 10 |
| 1980 | 9 |
| 1981 | 12 |
| 1982 | 5 |
| 1983 | 10 |
| 1984 | 9 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 6 |
| 1988 | 8 |
| 1989 | 5 |
| 1990 | 7 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 7 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 5 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 1 |
| 2002 | 5 |
| 2003 | 2 |
| 2004 | 5 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 6 |
| 2008 | 4 |
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 5 |
| 2013 | 4 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2024
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212'))
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") = 2024
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212'))
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 CEN25LA007Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Richmond, TXThe partial separation of a portion of the propeller spinner and its mounting bulkhead along with the upper cowl fairing while in a full-power climb.NTSB ERA24LA194Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Hornell, NYA cabin fire as a result of a damaged lithium-ion battery pack.NTSB CEN24LA145Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20E · Alpine, ARThe improper maintenance of the cabin air and exhaust system which resulted in a cracked exhaust pipe and damaged cabin air tubing, and the subsequent elevated carbon monoxide levels in the cockpit and a forced landing to unsuitable terrain after the pilot…NTSB WPR24LA066Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Byron, CAThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.