Fatal NTSB investigations: Mooney M20
18 cases on aircraft the registry lists as Mooney M20. 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 | 2 |
| 1966 | 1 |
| 1968 | 2 |
| 1971 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1997 | 1 |
| 2001 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870202'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870202'))
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 MIA02LA027Accident · 2 fatalLimited investigationFinal reportMooney M-20-20 · Hilton Head, SCThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control, an uncontrolled descent, and an impact with the water.NTSB LAX98FA039Accident · 2 fatalField investigationFinal reportMooney M20 · Big Bear, CAVFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…NTSB DEN88FA115Accident · 3 fatalField investigationFinal reportMooney M20 · Jamestown, COThe plt told a friend that he was going to conduct a sightseeing flt in the local area. Residents of a small town 2 miles from the acdt site said the acft circled the town at low alt several times at about the time of the accident. There were no witnesses to…NTSB SEA83FA095Accident · 1 fatalField investigationFinal reportMooney M20 · Edmonds, WAThe plt had earlier visited his fiancee. She stated that he was intoxicated & she gave back her engagement ring to him. He was later observed departing the arpt. Shortly thereafter police began receiving complaints of a low flying acft overthe beach area. The…NTSB LAX78FA072Accident · 2 fatalClosedMooney M20 · Los Angeles, CANTSB FTW77FA064Accident · 1 fatalClosedMooney M20 · Shelbyville, TXNTSB DEN76AD054Accident · 2 fatalClosedMooney M20 · Cody, WYNTSB LAX74AL041Accident · 3 fatalClosedMooney M-20 · Fillmore, CANTSB MIA72AM018Accident · 3 fatalClosedMooney M20 · Ashland, MSNTSB FTW69A0032Accident · 1 fatalClosedMooney M20 · Wayne, OKNTSB FTW68A0078Accident · 4 fatalClosedMooney M20 · Page, OKNTSB MIA67S0002Accident · 2 fatalClosedMooney M20 · Vera Cruz, MexicoNTSB UNK66X0102Accident · 2 fatalClosedMooney M20 · British Clmba, CanadaNTSB SEA65A0042Accident · 4 fatalClosedMooney M20 · Longmire, WANTSB UNK64X3957Accident · 3 fatalClosedMooney M20 · Waterford, MINTSB UNK64X3548Accident · 1 fatalClosedMooney MK-20 · Seigler Spgs, CANTSB UNK64X3204Accident · 1 fatalClosedMooney M20 · La Touche, WANTSB UNK64X1291Accident · 3 fatalClosedMooney M20 · Beckwourth, CA