NTSB investigations: Mooney M20J, 2013
9 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\") = 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 ('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") = 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 ('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 WPR14CA011Accident · Serious injuriesData collectionFinal reportMooney M20J · Sedona, AZThe pilot's inadequate flare which resulted in a bounced landing and subsequent loss of aircraft control during an aborted landing.NTSB WPR13LA407Accident · No injuriesLimited investigationFinal reportMooney M20J · Lund, NVThe pilot’s failure to monitor the environment, which led to a collision with power lines during climbout. Contributing to the accident was the loss of engine power during low-altitude flight for reasons that could not be determined because postaccident…NTSB ERA13LA374Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Marco Island, FLThe pilot’s improper pitch trim setting before takeoff, which resulted in the airplane’s rapid, nose-high pitch at takeoff and the pilot’s subsequent loss of control.NTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…NTSB ERA13LA342Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Leonardtown, MDThe improper installation and inspection of the throttle linkage by maintenance personnel, which resulted in the throttle linkage coming loose and a subsequent partial loss of engine power.NTSB CEN13LA370Accident · No injuriesLimited investigationFinal reportMooney M20J · El Reno, OKA loss of engine power, which resulted from the failure of the magneto assembly for reasons that could not be determined during postaccident examinations.NTSB CEN13FA221Accident · 2 fatalField investigationFinal reportMooney M20J · Collinsville, OKThe pilot’s loss of control of the airplane for reasons that could not be determined because an examination of the airplane did not find an abnormality that would have precluded normal operations.NTSB ERA13CA172Accident · No injuriesData collectionFinal reportMooney M20J · Springfield, TNThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.NTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…