NTSB investigations: Mooney M20C, OK
16 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 | 1 |
|---|---|
| 1965 | 3 |
| 1966 | 1 |
| 1967 | 2 |
| 1969 | 4 |
| 1975 | 2 |
| 2011 | 1 |
| 2016 | 1 |
| 2020 | 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\" = 'OK' 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" = 'OK' 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 CEN20CA249Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Lahoma, OKThe loss of engine power due to fuel exhaustion and the pilot’s improper fuel planning before the flight.NTSB CEN16LA164Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sand Springs, OKA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.NTSB FTW76FPM12Accident · No injuriesClosedMooney M20C · Tulsa, OKNTSB FTW75FPJ18Accident · No injuriesClosedMooney M20C · Porter Hill, OKNTSB FTW70F0307Accident · Minor injuriesClosedMooney M20C · Edmond, OKNTSB FTW70F0246Accident · No injuriesClosedMooney M-20C · Oklahoma Cty, OKNTSB FTW70D0202Accident · No injuriesClosedMooney M20C · Waurika, OKNTSB FTW69D0417Accident · No injuriesClosedMooney M20C · Mangum, OKNTSB FTW68D0338Accident · No injuriesClosedMooney M20C · Marlow, OKNTSB FTW67A0092Accident · No injuriesClosedMooney M20C · Mangum, OKNTSB FTW67F0266Accident · No injuriesClosedMooney M20C · Oklahoma Cty, OKNTSB FTW66F0350Accident · No injuriesClosedMooney M20C · Bethany, OKNTSB FTW66D0296Accident · No injuriesClosedMooney M20C · Mangum, OKNTSB FTW66F0016Accident · Serious injuriesClosedMooney M20C · Foraker, OKNTSB UNK64X3151Accident · No injuriesClosedMooney MK20C · Okla City, OK