Fatal NTSB investigations: Mooney M-20G
8 cases on aircraft the registry lists as Mooney M-20G. 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
| 1968 | 2 |
|---|---|
| 1969 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1988 | 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 ('5870216'))
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 ('5870216'))
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 ATL88FA131Accident · 1 fatalField investigationFinal reportMooney M20G · Jasper, GABefore depg blairsville, the plt reqd the current atlanta wx for the dekalb-peachtree arpt & for an afternoon outlook. He told the briefer that he had received a previous wx briefing. He was informed that the forecast was for instrument conds until noon with…NTSB ATL82FA032Accident · 1 fatalField investigationFinal reportMooney M20G · Henderson, NCThe pilot and his wife were at 6000 ft on a VFR cross-country when he became unconscious. The aircraft was equipped with a wing leveler and continued in level flight while the pilot's wife attended to him. When the pilot's wife could do nothing more for him,…NTSB DEN81FA023Accident · 2 fatalClosedMooney M20G · Ryegate, MTNTSB OAK76AP008Accident · 3 fatalClosedMooney M20G · Truckee, CANTSB NYC73AN042Accident · 1 fatalClosedMooney M20G · Skaneateles, NYNTSB NYC69A0097Accident · 2 fatalClosedMooney M20G · East Setauket, NYNTSB MKC69A0005Accident · 3 fatalClosedMooney M20G · Phillipsburg, KSNTSB DEN68A0044Accident · 4 fatalClosedMooney M20C · Briggsdale, CO