NTSB investigations: Mooney M20E
8 cases on aircraft the registry lists as Mooney M20E, 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212')
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 ('5870212')
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 DEN99LA104Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Canon City, COThe pilot's poor judgement due to his intentional and continued flight into instrument meteorological conditions. Factors were the existing weather conditions that included clouds and obscuration.NTSB FTW98FA121Accident · 1 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot attempting VFR flight into instrument meteorological conditions and his lack of an instrument rating. Factors were weather conditions that included mountain wave activity conducive to turbulence, and clouds obscuring the mountainous terrain.NTSB SEA96FA175Accident · 2 fatalField investigationFinal reportMooney M20E · Purdy, WAThe noninstrument-rated pilot's continuation of VFR flight into instrument meteorological conditions which led to pilot spatial disorientation and loss of control of the aircraft. Factors were: pilot self-induced pressure, night conditions, low ceilings, and…NTSB DEN93FA063Accident · 2 fatalField investigationFinal reportMooney M20E · Westcliffe, COThe pilot's loss of aircraft control as he attempted to turn away from a line of thunderstorms. Factors were thunderstorms and associated turbulence.NTSB LAX87FA101Accident · 2 fatalField investigationFinal reportMooney M20E · Dunsmuir, CADuring a pleasure flight, the airplane was seen flying low and disappeared into instrument meteorological conditions, consisting of low clouds, gusty winds and snow which lasted throughout the day. The airplane was found on the side of a hill in a descending…NTSB ATL86LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Meridian, MSThe non-instrument rated pilot received a weather briefing before take-off and was advised that VFR flight was not recommended for a flight to chattanooga, TN. The pilot was unable to maintain VFR conditions and attempted a precision approach. While being…NTSB MKC85FA012Accident · 3 fatalField investigationFinal reportMooney M20E · Carbondale, KSThe flt was en route from little rock, AR, to topeka, ka. Ten miles south of topeka's frobes field the plt requested wx info and was told that a current observation was being taken & he would be advised. Contact between the tower and the flt could not be…NTSB CHI84FA027Accident · 2 fatalField investigationFinal reportMooney M20E · Newark, INThe acft had been recently purchased by the plt & this was the 2nd leg of a 3 leg trip which had originally departed hickory, NC. Two witnesses located about 5 mi sse of the accident site observed the acft. One witness stated the visibility was less than 1 mi…