NTSB investigations: Mooney M20A, 1966
24 cases on aircraft the registry lists as Mooney M20A. 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 | 28 |
|---|---|
| 1965 | 25 |
| 1966 | 24 |
| 1967 | 17 |
| 1968 | 13 |
| 1969 | 8 |
| 1970 | 6 |
| 1971 | 10 |
| 1972 | 9 |
| 1973 | 16 |
| 1974 | 5 |
| 1975 | 7 |
| 1976 | 5 |
| 1977 | 4 |
| 1978 | 3 |
| 1979 | 2 |
| 1980 | 2 |
| 1982 | 5 |
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1990 | 3 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2013 | 1 |
| 2019 | 1 |
| 2023 | 1 |
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\") = 1966
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870204'))
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") = 1966
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870204'))
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 MKC67F0364Accident · No injuriesClosedMooney M20A · Vermillion, SDNTSB NYC67F0433Accident · No injuriesClosedMooney M20A · Port Jefferson, NYNTSB DEN67F0177Accident · No injuriesClosedMooney M20A · Albuquerque, NMNTSB FTW67D0371Accident · No injuriesClosedMooney M20A · Hermosillo, MexicoNTSB FTW67D0355Accident · No injuriesClosedMooney M20A · Cumby, TXNTSB MIA67F0263Accident · Minor injuriesClosedMooney M20A · Paris, TNNTSB DEN67F0095Accident · Minor injuriesClosedMooney M20 · Rawlins, WYNTSB NYC67F0176Accident · No injuriesClosedMooney MK20A · Allentown, PANTSB MKC67F0207Accident · No injuriesClosedMooney M20A · Ottumwa, IANTSB LAX67D0158Accident · No injuriesClosedMooney M20A · Santa Susana, CANTSB MKC67F0182Accident · No injuriesClosedMooney M20A · Ellsworth Afb, SDNTSB OAK67D0082Accident · No injuriesClosedMooney MK20A · Kyburz, CANTSB MIA67F0168Accident · No injuriesClosedMooney M20A · Sarasota, FLNTSB FTW67F0074Accident · No injuriesClosedMooney M20A · El Paso, TXNTSB DEN67D0005Accident · No injuriesClosedMooney 20A · Holly, CONTSB OAK66D0304Accident · No injuriesClosedMooney M20A · Ukiah, CANTSB DEN66F0260Accident · No injuriesClosedMooney M20A · Yuma, AZNTSB CHI66D0617Accident · No injuriesClosedMooney 20A · Cleveland, OHNTSB OAK66A0034Accident · 3 fatalClosedMooney MK-20A · Eureka, CANTSB FTW66F0568Accident · Minor injuriesClosedMooney M20A · Orange, TXNTSB CHI66F0567Accident · No injuriesClosedMooney 20A · Plymouth, MINTSB DEN66D0200Accident · No injuriesClosedMooney M20A · Albuquerque, NMNTSB MKC66F0377Accident · No injuriesClosedMooney M20A · Goodland, KSNTSB MKC66D0349Accident · No injuriesClosedMooney M20A · Altura, MN