NTSB investigations: Mooney M20J, 2005
7 cases on aircraft the registry lists as Mooney M20J. 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
| 1977 | 2 |
|---|---|
| 1978 | 13 |
| 1979 | 7 |
| 1980 | 3 |
| 1981 | 9 |
| 1982 | 9 |
| 1983 | 11 |
| 1984 | 7 |
| 1985 | 10 |
| 1986 | 3 |
| 1987 | 13 |
| 1988 | 11 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 7 |
| 1992 | 5 |
| 1993 | 11 |
| 1994 | 11 |
| 1995 | 9 |
| 1996 | 6 |
| 1997 | 4 |
| 1998 | 9 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 7 |
| 2002 | 9 |
| 2003 | 10 |
| 2004 | 8 |
| 2005 | 7 |
| 2006 | 9 |
| 2007 | 6 |
| 2008 | 4 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 9 |
| 2013 | 9 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 7 |
| 2017 | 5 |
| 2018 | 7 |
| 2019 | 8 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 6 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 6 |
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\") = 2005
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870219'))
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") = 2005
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870219'))
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 DFW06CA047Accident · No injuriesData collectionFinal reportMooney M20J · Yoakum, TXThe pilot's misjudged distance/speed which resulted in an overrun.NTSB SEA05LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Sunriver, ORThe loss of engine power as a result of both sets of magneto points failing to open due to excessive wear of the nylon cam followers. The excessive wear of the cam followers was due to maintenance personnel's failure to follow the magneto manufacturer's…NTSB DFW05FA185Accident · 3 fatalField investigationFinal reportMooney M20J · Saginaw, TXThe pilot's loss of control for undetermined reasons while maneuvering.NTSB SEA05LA129Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Hailey, IDThe pilot's failure to maintain aircraft control while on final approach for undetermined reasons.NTSB NYC05CA108Accident · No injuriesData collectionFinal reportMooney M-20J · Toughkenamon, PAThe pilot's failure to maintain directional control during an aborted landing, which resulted in an in-flight collision with trees. A factor was the crosswind.NTSB IAD05LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Rocky Hill, NJThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall, and subsequent impact with terrain. Factors included the night lighting conditions, and the airplane approaching the opposite runway.NTSB ATL05LA051Accident · Serious injuriesLimited investigationFinal reportMooney 20P · Smith, ALMaintenance personnel failure to properly torque the cylinder head during installation that resulted in the separation from the engine assembly and the subsequent loss of power.