NTSB investigations: Mooney M20K, MN
5 cases on aircraft the registry lists as Mooney M20K. 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
| 1989 | 1 |
|---|---|
| 1994 | 1 |
| 1997 | 1 |
| 2012 | 2 |
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\" = 'MN' 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 ('5870220'))
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" = 'MN' 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 ('5870220'))
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 CEN12CA461Accident · No injuriesData collectionFinal reportMooney M20K · Hutchinson, MNThe student pilot’s inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with obstructions.NTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.NTSB CHI98LA042Accident · No injuriesLimited investigationFinal reportMooney M20K · Eden Prairie, MNthe pilot's improper decision to continue the approach beyond decision height, when he could not see the runway; and his attempt to land without being properly aligned on the runway. Factors relating to this accident were: darkness, fog and and runway lights.NTSB CHI95LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Minneapolis, MNthe pilot's misjudging of distance and airspeed during the approach to landing which resulted in an overrun. Factors associated with the accident were the separation of the exhaust pipe and the pilot's not understanding communications from the air traffic…NTSB MKC89LA053Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Malmo, MNThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), which resulted in his loss of aircraft control, due spatial disorientation. A related factor to the accident was: the adverse weather condition.