NTSB investigations: Mooney M20J, 2001
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\") = 2001
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") = 2001
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 NYC01LA191Accident · No injuriesLimited investigationFinal reportMooney M20J · East Greenwich, NJThe pilot's premature liftoff which resulted in an inadvertent stall.NTSB NYC01LA186Accident · No injuriesLimited investigationFinal reportMooney M20J · Mitchellville, MDThe flight instructor's failure to maintain control of the airplane during an aborted landing, and her delay in remedial action. A factor related to the accident was the excessive trim setting.NTSB LAX01LA246Accident · No injuriesLimited investigationFinal reportMooney M20J · Las Vegas, NVThe pilot's inadaquate visual lookout and failure to maintain proper clearance from an object. A factor was the pilot's distraction by a conversation with ground control.NTSB CHI01LA182Accident · 1 fatalLimited investigationFinal reportMooney M20J · Columbia, MOThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB LAX01LA203Accident · No injuriesLimited investigationFinal reportMooney M20J · Jackson, CAFailure of the pilot to maintain proper airspeed for landing and airplane control with an existing crosswind. A contributing factor was the distraction of the pilot by a yelling passenger.NTSB MIA01FA151Accident · 3 fatalField investigationFinal reportMooney M-20J · Monroe, NCThe pilot in command’s failure to maintain airspeed while maneuvering to avoid objects, resulting in a stall/mush and collision with the terrain during uncontrolled descent. Contributing to the accident was the improper approach to land and his failure to…NTSB FTW01LA090Accident · No injuriesLimited investigationFinal reportMooney M20J · Pecos, TXthe pilot's failure to obtain a proper glide path during landing, which resulted in the airplane's impact with terrain short of the runway. Contributory factors were the open baggage door and the pilot's diverted attention to the open door.