NTSB investigations: Mooney M20F, KY
11 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
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 2005 | 1 |
| 2007 | 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\" = 'KY' 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" = 'KY' 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 NYC07FA159Accident · 2 fatalField investigationFinal reportMooney M20F · Brooks, KYThe pilot's failure to maintain aircraft control during the aborted landing. Contributing to the accident was the exceedance of the airplane's maximum gross weight, and the pilot's inadequate preflight planning.NTSB NYC06IA036Incident · No injuriesIncident investigationFinal reportMooney M20F · Cadiz, KYFuel starvation, which resulted in a loss of engine power.NTSB ATL89FA131Accident · 2 fatalField investigationFinal reportMooney M20F · Lynch, KYContinued VFR flight by the pilot into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions, terrain, and the pilot's lack of instrument experience.NTSB ATL88LA228Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Burkesville, KYThe plt reported that the airplane encountered heavy rain and extreme turbulence while flying over a black cloud at 8,500 ft. he stated that it was as if an 'invisible tornado had reached out' and grabbed the airplane; excessive climb & descent rates were…NTSB ATL88FA174Accident · 4 fatalField investigationFinal reportMooney M20F · Middlesboro, KYWitnesses rprted the eng did not sound like it was providing full power drg takeoff & that abt 3/4 of the 3600' rwy was used for the takeoff roll. After lift-off, the acft climbed at a shallow angle to abt 250 to 300 ft AGL. It then entereda shallow left…NTSB ATL82DA064Accident · No injuriesFinal reportMooney M20F · Belton, KYAfter leveling at 2500 ft, oil fumes were noted, but no abnormal indications were noted on the engine gauges. The pilot suspected oil had been spilled during a repair before takeoff. A short time later, the engine RPM began to increase & was adjusted by the…NTSB IAD80DLQ11Accident · No injuriesClosedMooney M20F · Albany, KYNTSB IAD78FLQ16Accident · No injuriesClosedMooney M20F · Danville, KYNTSB IAD76DLQ19Accident · No injuriesClosedMooney M20 · Whitesburg, KYNTSB CHI70FGJ04Accident · No injuriesClosedMooney M20F · Madisonville, KYNTSB CHI70F0002Accident · No injuriesClosedMooney M20F · Waddy, KY