NTSB investigations: Mooney M20C, KS
20 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 | 3 |
|---|---|
| 1965 | 2 |
| 1966 | 6 |
| 1967 | 3 |
| 1968 | 1 |
| 1969 | 1 |
| 1974 | 1 |
| 1988 | 1 |
| 2007 | 1 |
| 2016 | 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\" = 'KS' 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" = 'KS' 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 CEN16LA129Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Wichita, KSThe total loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel management.NTSB DEN08LA041Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Phillipsburg, KSTotal loss of engine power due to contamination of the carburetor, total blockage of the fuel inlet screen, and partial blockage of the fuel lines and fittings. Contributing to the accident were the dark night light conditions and the trees.NTSB MKC88LA140Accident · No injuriesLimited investigationFinal reportMooney M20C · Olathe, KSShortly after takeoff, the pilot said the engine failed. He said he pumped the throttle and the engine restarted about the same time the acft returned to the runway. The engine restart propelled the aft back into the air. The plt felt he had sufficient power…NTSB MKC75DCQ06Accident · No injuriesClosedMooney M20C · Sublette, KSNTSB MKC70A0034Accident · 3 fatalClosedMooney M-20C · Pittsburg, KSNTSB MKC68D0522Accident · Minor injuriesClosedMooney M20C · Hillsboro, KSNTSB MKC68D0295Accident · No injuriesClosedMooney M20C · Johnson, KSNTSB MKC68D0007Accident · No injuriesClosedMooney M20C · Oberlin, KSNTSB MKC67D0489Accident · No injuriesClosedMooney M20C · Wichita, KSNTSB MKC67D0432Accident · No injuriesClosedMooney M20C · Wichita, KSNTSB MKC67D0253Accident · No injuriesClosedMooney M20C · Dexter, KSNTSB MKC66A0067Accident · 1 fatalClosedMooney M20C · Kansas City, KSNTSB MKC67D0045Accident · No injuriesClosedMooney M20C · Wellington, KSNTSB MKC67D0012Accident · No injuriesClosedMooney M20C · Russell, KSNTSB MKC66F0369Accident · No injuriesClosedMooney M20C · Kansas City, KSNTSB MKC66F0275Accident · No injuriesClosedMooney M20C · Carbondale, KSNTSB MKC65F0056Accident · No injuriesClosedMooney 20C · Beloit, KSNTSB UNK64X3796Accident · No injuriesClosedMooney M20 · Kansas City, KSNTSB UNK64X1099Accident · Minor injuriesClosedMooney M21 · Ottawa, KSNTSB UNK64X0891Accident · No injuriesClosedMooney M21 · Kansas City, KS