NTSB investigations: Mooney M20J, 1984
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\") = 1984
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") = 1984
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 FTW85FA088Accident · 4 fatalField investigationFinal reportMooney M20J · San Antonio, TXThe non-instrument rated plt obtained a wx briefing & filed an IFR flt plan although poor wx conditions existed (200 ft ceiling & one-half mi visibility) at San Antonio. The tower instructions to N5681K were to fly rwy heading (120 deg) after departure,…NTSB LAX85FA073Accident · 4 fatalField investigationFinal reportMooney M20J · Grand Canyon, AZThe plt received a wx briefing and was advised of moderate rime and mixed icing in clouds. He filed an IFR flt plan and departed. While at 12000 ft, he reported encountering severe rime ice and requested a lower altitude. He stated thathe was trying to fling…NTSB LAX85LA046Accident · No injuriesLimited investigationFinal reportMooney M20J · Tulelake, CAThe plt stated that he was conducting touch and go landings on a road when the left wing struck a 4X4 in wooden speed limit sign post.NTSB NYC85LA041Accident · No injuriesLimited investigationFinal reportMooney M20J · Marlboro, NJPlt stated that on late final, with airspeed and descent path normal, acft encountered downdraft and collided with upslope at runway threshold before corrective action could be taken. A 60 degree left crosswind of 15 KTS existed at the time.NTSB ATL84FA292Accident · 2 fatalField investigationFinal reportMooney M20J · Lanett, ALCommunications with columbus apch revealed plt was unfamiliar with area and had difficulities finding the arpt witnesses viewed acft on final for rwy 08 with landing gear extended. Acft described as being low and slow. Witnesses stated engine sounds…NTSB NYC84FHD04Accident · Serious injuriesFinal reportMooney M20 · Atlantic City, NJThe flt to Atlantic-city-bader field was uneventful, except the acft touched down hard during the landing. The plt taxied to the terminal & parked with the exit door facing the terminal. He elected not to shut down the eng since he intended to immediately…NTSB NYC84LA087Accident · No injuriesLimited investigationFinal reportMooney M20J · Bristol, PAThe acft encountered weather and head winds on a x-country flt. Nearing his destination after a long flt the plt was trying to let down VFR through breaks on the clouds when he realized the critical nature of his fuel level. A search foran arpt produced the…