NTSB investigations: Mooney M20C, MI
16 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 | 4 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1978 | 1 |
| 1995 | 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 c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA'
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 CHI95LA312Accident · No injuriesLimited investigationFinal reportMooney M20C · Ironwood, MIthe pilot's failure to maintain control of the airplane due to his diverted attention.NTSB CHI78FET07Accident · Minor injuriesClosedMooney M20C · Coloma, MINTSB CHI73DEM68Accident · Minor injuriesClosedMooney M20 · Iron River, MINTSB CHI73FEC16Accident · Minor injuriesClosedMooney M20C · Salem, MINTSB CHI72FEC32Accident · No injuriesClosedMooney M-20C · Howell, MINTSB CHI71FBJ52Accident · No injuriesClosedMooney M20C · Lansing, MINTSB CHI71DDW14Accident · No injuriesClosedMooney M20C · Port Huron, MINTSB CHI69D0180Accident · Minor injuriesClosedMooney M20C · Mears, MINTSB CHI68F0307Accident · No injuriesClosedMooney M20C · Flint, MINTSB CHI67F0464Accident · No injuriesClosedMooney M20C · Ann Arbor, MINTSB CHI66A0080Accident · 2 fatalClosedMooney MK 20C · Freeland, MINTSB CHI66F0177Accident · No injuriesClosedMooney M20C · Lapeer, MINTSB UNK65X0512Accident · No injuriesClosedMooney M20C · Lansing, MINTSB UNK65X0301Accident · Serious injuriesClosedMooney M20C · Birmingham, MINTSB UNK64X3965Accident · No injuriesClosedMooney M20E · Reed City, MINTSB UNK64X3312Accident · Serious injuriesClosedMooney M20C · Blaney Park, MI