NTSB investigations: Mooney M20E, OK
13 cases on aircraft the registry lists as Mooney M20E. 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 | 1 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 2 |
| 1978 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 2008 | 1 |
| 2013 | 1 |
| 2022 | 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 ('5870212'))
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 ('5870212'))
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 CEN22LA255Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Stillwater, OKThe inadequate maintenance and inspection of the engine induction air coupling, which impeded airflow to the engine and resulted in the subsequent partial loss of engine power.NTSB CEN13FA217Accident · 2 fatalField investigationFinal reportMooney M20E · Guymon, OKThe noninstrument-rated pilot's encounter with instrument meteorological conditions, which resulted in spatial disorientation and his subsequent loss of airplane control. Contributing to the accident was the pilot's decision to take off in deteriorating…NTSB DFW08CA171Accident · Minor injuriesData collectionFinal reportMooney M20 · Lake Ft Gibson, OKThe pilot's loss of control while maneuvering the aircraft.NTSB FTW86LA166Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oklahoma City, OKThe pilot apparently had neglected to check his engine oil supply before takeoff since there was no oil in the crankcase at the time of the accident. If five quarts of oil (the amount the pilot reportedly stated was in the engine at takeoff) had leaked out…NTSB FTW83FA079Accident · 2 fatalField investigationFinal reportMooney M20E · Cushing, OKThe acft collided with a powerline during a low flt down a river. The acft impacted 3 high tension cables spanning the river. Witnesses said the acft was flying low and fast. The collision produced a sound 'like a gunshot' and the acft fell to the ground and…NTSB FTW78FPM06Accident · No injuriesClosedMooney M20E · Jay, OKNTSB FTW69A0019Accident · 1 fatalClosedMooney M20E · Hugo, OKNTSB FTW69D0182Accident · Minor injuriesClosedMooney M20E · Henryetta, OKNTSB FTW67A0068Accident · 4 fatalClosedMooney M20E · Ardmore, OKNTSB FTW67D0200Accident · No injuriesClosedMooney M20C · Guthrie, OKNTSB FTW67D0210Accident · No injuriesClosedMooney M20E · Ada, OKNTSB FTW66D0261Accident · No injuriesClosedMooney M21 · Albion, OKNTSB UNK64X2462Accident · No injuriesClosedMooney MK20E · Hugo, OK