NTSB investigations: Mooney M20F, KS
10 cases on aircraft the registry lists as Mooney M20F. 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
| 1967 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1994 | 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 ('5870214'))
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 ('5870214'))
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 CHI94LA315Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Hanston, KSThe failure of the number two connecting rod. Factors in the accident were the fouled windshield utility wires, the road sign, and the telephone pole.NTSB MKC89FA179Accident · 3 fatalField investigationFinal reportMooney M20F · Mound City, KSThe pilot's continued VFR flight into an area of thunderstorms & heavy rain which resulted in a loss of control of the airplane. Factors related to the accident were thunderstorms and heavy rain.NTSB MKC88LA135Accident · No injuriesLimited investigationFinal reportMooney M20-F · Lawrence, KSThe pilot said the engine quit due to fuel exhaustion during a personal cross country flight. He said he tried to glide to his final destination airport, but made an emergency ldg in a farm field about 2 miles short of the airport.NTSB MKC83LA219Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Benton, KSThe pilot was using rwy 34 with the winds 190 degrees at 14 KTS gusting 20 KTS. The acft lifted off to about 10 ft and mushed back to the ground. The acft crossed a ditch and a rood and contacted a 2nd ditch which knocked off its right main landing gear.NTSB MKC82FCQ08Accident · 1 fatalFinal reportMooney M20F · Cedar Vale, KSWhile landing on the previous flight, the propeller was damaged when it struck an electric fence. After the propeller was repaired, the pilot elected to takeoff at night. A mechanic stated that the pilot had removed all frost before takeoff. Witnesses stated…NTSB MKC79FCQ06Accident · No injuriesClosedMooney M20F · Cedar Point, KSNTSB MKC71DCQ40Accident · No injuriesClosedMooney M20F · Montezuma, KSNTSB MKC69A0057Accident · 1 fatalClosedMooney M20F · Plainville, KSNTSB MKC68D0540Accident · No injuriesClosedMooney M20F · Russell, KSNTSB MKC68F0008Accident · Serious injuriesClosedMooney M20F · Beaumont, KS