NTSB investigations: Mooney M20C, KY
11 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
| 1965 | 3 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1993 | 1 |
| 2000 | 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 ('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" = '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 ('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 NYC01IA046Incident · Minor injuriesIncident investigationFinal reportMooney M20C · Hazard, KYThe incorrect routing of the cabin air scat tubing by an unknown person, which resulted in a carbon monoxide leak into the cabin, and subsequent pilot incapacitation.NTSB BFO93LA157Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Oak Grove, KYThe pilot's innacurate preflight fuel consuption calculations and inadequate in-flight planning/decisions, which resulted in fuel exhaustion and subsequent loss of engine power. A factor related to the accident was: high obstructions in the emergency landing…NTSB IAD75DLQ14Accident · Minor injuriesClosedMooney M20 · Pine Knot, KYNTSB IAD74FLQ38Accident · Minor injuriesClosedMooney M20C · Clarkson, KYNTSB IAD74DLQ03Accident · No injuriesClosedMooney M20C · Paducah, KYNTSB CHI72FLQ29Accident · No injuriesClosedMooney M20C · Ferguson, KYNTSB CHI68F0301Accident · No injuriesClosedMooney M20C · Hazard, KYNTSB CHI67D0408Accident · No injuriesClosedMooney M20C · Pikeville, KYNTSB CHI66F0302Accident · No injuriesClosedMooney M20C · Owensboro, KYNTSB CHI66F0063Accident · No injuriesClosedMooney M20C · Paintsville, KYNTSB CHI66F0066Accident · No injuriesClosedMooney M20C · Pikeville, KY