NTSB investigations: Mooney M20C, 1974
26 cases on aircraft the registry lists as Mooney M20C. 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 | 43 |
|---|---|
| 1965 | 64 |
| 1966 | 68 |
| 1967 | 70 |
| 1968 | 47 |
| 1969 | 34 |
| 1970 | 37 |
| 1971 | 31 |
| 1972 | 31 |
| 1973 | 21 |
| 1974 | 26 |
| 1975 | 27 |
| 1976 | 20 |
| 1977 | 17 |
| 1978 | 15 |
| 1979 | 14 |
| 1980 | 12 |
| 1981 | 11 |
| 1982 | 4 |
| 1983 | 7 |
| 1984 | 14 |
| 1985 | 5 |
| 1986 | 11 |
| 1987 | 14 |
| 1988 | 5 |
| 1989 | 6 |
| 1990 | 9 |
| 1991 | 4 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 10 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 9 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 8 |
| 2001 | 8 |
| 2002 | 3 |
| 2003 | 9 |
| 2004 | 7 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 5 |
| 2008 | 6 |
| 2009 | 5 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 4 |
| 2017 | 7 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 3 |
| 2025 | 1 |
| 2026 | 2 |
Where
Latest 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\") = 1974
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870208'))
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") = 1974
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870208'))
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 OAK75FVW11Accident · No injuriesClosedMooney M20C · Las Vegas, NVNTSB MIA75DLA18Accident · No injuriesClosedMooney M20C · Palatka, FLNTSB DEN75FQA17Accident · No injuriesClosedMooney M20C · Zuni, NMNTSB NYC75FNE07Accident · No injuriesClosedMooney M20C · Fitchburg, MANTSB MKC75AK018Accident · Minor injuriesClosedMooney M20C · Stewartville, MNNTSB DEN75FTC05Accident · No injuriesClosedMooney M20C · Sheridan, WYNTSB CHI75DEV01Accident · No injuriesClosedMooney M20 · Mt Vernon, ILNTSB OAK75DVG07Accident · No injuriesClosedMooney M20C · Fair Oaks, CANTSB MKC75DER05Accident · No injuriesClosedMooney M20C · Winona, MNNTSB MKC75DCQ06Accident · No injuriesClosedMooney M20C · Sublette, KSNTSB MKC74FER63Accident · No injuriesClosedMooney M20C · Crystal, MNNTSB IAD74FLQ38Accident · Minor injuriesClosedMooney M20C · Clarkson, KYNTSB MIA75DLD95Accident · No injuriesClosedMooney M20C · Sanford, FLNTSB NYC74AN103Accident · 1 fatalClosedMooney M20C · Matawan, NJNTSB MIA74FKG81Accident · Serious injuriesClosedMooney M20C · Chamblee, GANTSB CHI74FEV53Accident · Serious injuriesClosedMooney M20C · Watseka, ILNTSB MIA74DKJ58Accident · Minor injuriesClosedMooney M20C · Auburn, ALNTSB IAD74DKM54Accident · No injuriesClosedMooney M20C · Asheville, NCNTSB NYC74AN088Accident · 4 fatalClosedMooney M20C · Dorset, VTNTSB MIA74DLA33Accident · No injuriesClosedMooney M20E · Pensacola, FLNTSB FTW74DRJ27Accident · No injuriesClosedMooney M20C · Ruston, LANTSB FTW74FQD15Accident · No injuriesClosedMooney M20C · El Paso, TXNTSB OAK74DVG21Accident · No injuriesClosedMooney M20C · Napa, CANTSB MKC74DCG18Accident · Minor injuriesClosedMooney M20C · Ashland, MONTSB IAD74DID25Accident · Serious injuriesClosedMooney M20C · Norfolk (Atlantic Ocean)NTSB NYC74DHD25Accident · Minor injuriesClosedMooney M20C · Honeybrook, PA