NTSB investigations: Mooney M20E, 1988
8 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\") = 1988
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") = 1988
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 FTW89FA006Accident · 1 fatalField investigationFinal reportMooney M20E · Longview, TXThe airplane was in cruise flight when the pilot transmitted that he had smoke in the cockpit. 53 seconds later contact was lost. The nose and left wing were slightly down when the acft struck trees and terrain at high speed. Fire started several minutes…NTSB LAX88LA279Accident · No injuriesLimited investigationFinal reportMooney M20E · Visalia, CAThe pilot removed the vacuum pump from the engine prior to the flight because of an internal failure in the pump. The pilot did not install a cover plate on the accessory mounting hole vacated by the pump. After takeoff on the local flight, the pilot noticed…NTSB MIA88LA237Accident · No injuriesLimited investigationFinal reportMooney M-20E · Punta Gorda, FLThe plt stated he kept his acft outdoors & he had not flown it for 7 days. He stated he had not refueled the acft after the last flt & had parked it with 1/2 tanks. Fss personnel stated there had been rain showers in the area during that time. The plt stated…NTSB ATL88LA188Accident · No injuriesLimited investigationFinal reportMooney M-20 · Hartwell, GAThe nose gear collapsed while taxiing at a speed of about 5 mph after landing. The annual inspection failed to disclose a material problem with the gear truss. Examination of the fractured component disclosed that the tubular material had rusted from the…NTSB SEA88LA079Accident · Minor injuriesLimited investigationFinal reportMooney M20E · The Dalles, OROn arrival, plt found destination obscured by unforecast fog, held briefly, then diverted to an alternate airport. On arrival at alt in darkness, plt did not know freq (UNICOM) to activate rwy lights. Plt made low pass to acquire rwy environment as fuel state…NTSB NYC88LA117Accident · No injuriesLimited investigationFinal reportMooney M20 · Manchester, NHMaintenance personnel improperly installed the number two connecting rod (p/n L-10646) causing it to separate, create a hole in the engine case, loss of engine oil and engine power. Due to the pilot's improper inflight decision, he performed a wheels up…NTSB DEN88LA076Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Miles City, MTNTSB ATL88LA087Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Liberty, NCThe plt rptd that he overestimated the amount of fuel on board the acft prior to departure. The engine subsequently lost pwr at cruise due to fuel exhaustion. A forced ldg was made in a field. During the rollout, the airplane vaulted the crest of a small hill…