NTSB investigations: Mooney M20K
12 cases on aircraft the registry lists as Mooney M20K, where the first occurrence was “In flight encounter with weather”. 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
| 1982 | 2 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
Where
Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870220')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870220')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DEN04FA079Accident · 3 fatalField investigationFinal reportMooney M20K · Pinedale, WYThe pilot's inadvertent flight into adverse weather conditions, and his failure to maintain terrain clearance while maneuvering. Contributing factors were the downdraft, the snow shower weather and mountainous terrain.NTSB LAX03LA276Accident · No injuriesLimited investigationFinal reportMooney M20K · Novato, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions during the dark early morning takeoff, which resulted in spatial disorientation and lead to a collision with trees off the departure end of the runway.NTSB DEN01FA027Accident · 1 fatalField investigationFinal reportMooney M20K · Ogden, UTthe pilot's inadvertent VFR flight into IMC, which resulted in a collision with mountainous terrain. Contributing factors were the blowing snow, turbulence, dark night light conditions, and pilot fatigue due to the long flight day.NTSB LAX96FA294Accident · 1 fatalField investigationFinal reportMooney M20K · Grand Canyon, AZdue to an in-flight loss of control resulting from a probable incapacitation for unknown reasons. The loss of control occurred while the aircraft was being flown in close proximity to a level 6 thunderstorm. The failure of the pilot to obtain current weather…NTSB SEA94FA060Accident · 1 fatalField investigationFinal reportMooney M20K · Applegate, ORPoor in-flight planning/decision and icing conditions. Factors to the accident were: selected flight into known adverse weather, dark night, and mountainous terrain.NTSB CHI91LA071Accident · 1 fatalLimited investigationFinal reportMooney M20K · Fayette, MOThe failure of the pilot to maintain control of the airplane. Factors were the pilot's overconfidence in his personal ability, and flight into known adverse weather.NTSB MKC89LA053Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Malmo, MNThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), which resulted in his loss of aircraft control, due spatial disorientation. A related factor to the accident was: the adverse weather condition.NTSB NYC86FA133Accident · 3 fatalField investigationFinal reportMooney M20K · West Milford, NJWhile on an IFR flight the aircraft entered an area of thunderstorms, lost control of the aircraft and crashed. In an attempt to circumnavigate the storms the plt inadvertently entered a storm and collided with the ground in an uncontrolled descent. The plts…NTSB FTW84LA341Accident · No injuriesLimited investigationFinal reportMooney M20 · Thibodaux, LAAt 0729 CDT the plt filed a flight plan and obtained a wx brief forecasting moist unstable air with several scattered and broken cloud layers beginning at 1,500 ft. the briefer further advised the plt of thunderstorm activity at various locations along the…NTSB DEN84FA107Accident · 1 fatalField investigationFinal reportMooney M20K · Craig, COWitnesses observed & heard the plt making an apch & subsequent go-around or pass over the ground at the arpt. Heavy fog conditions existed which were below IFR minimums. The plt failed to realize higher terrain exsisted north of the arpt. The acft collided…NTSB SEA83FA196Accident · 1 fatalField investigationFinal reportMooney M-20 · Sandy, ORThe acft crashed into rising terrain in marginal weather conditions. No flt plan had been filed. The acft crashed 25 miles from the takeoff point on 6/12/82 and was missing until 9/9/83. The pilot had received a weather briefing from portland fss indicating…NTSB FTW82FQD10Accident · 4 fatalFinal reportMooney M20K · Van Horn, TXN99996 departed riverside, CA on a flight to nacogdoches, TX the aircraft made a refueling stop in deming, NM, the last known en route position. The left seat pilot held a pvt certificate, the right seat pilot was a former FAA designated pilot examiner.…