NTSB investigations: Mooney M20E, 2007
6 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\") = 2007
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") = 2007
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 MIA08LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Sarasota, FLA loss of engine power due to contamination in the fuel filter.NTSB CHI08CA035Accident · No injuriesData collectionFinal reportMooney M20E · Lafayette, INThe improper installation of the connecting rod bolts during major overhaul, which resulted in the separation of the connecting rod from the crankshaft in flight. Contributing to the accident was the rising terrain encountered during touchdown and the…NTSB CHI08LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Muskegon, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing available to the pilot due to the presence of a residential sub-division and trees.NTSB SEA07FA218Accident · 2 fatalField investigationFinal reportMooney M20E · Tonasket, WAThe pilot's failure to maintain an adequate airspeed during initial climb following an aborted landing that resulted in a stall/spin. The pilot's misjudged speed and distance that resulted in a failure to attain a proper touchdown point was a factor.NTSB NYC07LA157Accident · No injuriesLimited investigationFinal reportMooney M20E · Winnsboro, SCA loss of engine power due to contamination within the fuel injector servo, which was not detected during a recent inadequate annual inspection.NTSB DFW07CA139Accident · No injuriesData collectionFinal reportMooney M-20E · Van, TXThe pilot's failure to maintain directional control during the takeoff run.