NTSB investigations: Mooney M20E, 2013
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\") = 2013
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") = 2013
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 WPR14FA012Accident · 2 fatalField investigationFinal reportMooney M20E · Julian, CAThe pilot’s failure to maintain clearance from terrain while maneuvering to avoid clouds in mountainous terrain.NTSB CEN13FA217Accident · 2 fatalField investigationFinal reportMooney M20E · Guymon, OKThe noninstrument-rated pilot's encounter with instrument meteorological conditions, which resulted in spatial disorientation and his subsequent loss of airplane control. Contributing to the accident was the pilot's decision to take off in deteriorating…NTSB CEN13CA190Accident · Serious injuriesData collectionFinal reportMooney M20E · Middletown, OHThe total loss of engine power due to fuel exhaustion, which resulted from the noncurrent pilot’s improper in-flight fuel management and decision-making and his decision to conduct the flight after consuming alcohol.NTSB CEN13FA183Accident · 4 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot's loss of control while flying in a turbulent mountain-wave environment. Contributing to the accident was the pilot's overconfidence in his ability to safely pilot the airplane in gusting wind conditions and his lack of experience operating in…