NTSB investigations: Mooney M20C, MD
9 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
| 1966 | 1 |
|---|---|
| 1968 | 3 |
| 1969 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1998 | 1 |
| 2021 | 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\" = 'MD' 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" = 'MD' 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 ERA21LA170Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · College Park, MDImproper maintenance of the airplane by its owners and their failure to have qualified maintenance personnel determine the root cause of water infiltration into the fuel system. Also causal was the pilot’s inadequate preflight inspection, which failed to…NTSB IAD98LA099Accident · No injuriesLimited investigationFinal reportMooney M-20C · Kent Island, MDthe pilot's improper takeoff technique and his failure to abort the takeoff.NTSB BFO87LA054Accident · No injuriesLimited investigationFinal reportMooney M20C · Baltimore, MDThe plt refueled the acft at princeton, NJ, bfr departing on a flt to linden, NJ, then continued on to laurel, MD. He believed that he had positioned the fuel selector to the rgt fuel tank & said that he had used fuel out of the same tank until he arrived at…NTSB NYC85LA022Accident · No injuriesLimited investigationFinal reportMooney M20C · Landover, MDFlt departed danbury, CT, on x-country flt to college park, MD. According to plt there was sufficient fuel on board, however plt extended flt to northern VA before returning to college park. Prior to reaching arpt a loss of power occurred and plt made gear up…NTSB DIA69D0159Accident · No injuriesClosedMooney MK-20E · Beltsville, MDNTSB DIA69F0061Accident · No injuriesClosedMooney M20C · Mitchellville, MDNTSB DIA69F0057Accident · No injuriesClosedMooney M21 · Mitchellville, MDNTSB DIA68F0195Accident · Minor injuriesClosedMooney M20C · Mitchellville, MDNTSB NYC67F0301Accident · Minor injuriesClosedMooney M20C · Mitchellville, MD