NTSB investigations: Mooney M20C
12 cases on aircraft the registry lists as Mooney M20C, where the first occurrence was “In flight collision with terrain/water”. 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 | 3 |
| 1987 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2003 | 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 ('5870208')
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\" = 230))
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 ('5870208')
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" = 230))
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 LAX03FA061Accident · 1 fatalField investigationFinal reportMooney M20C · Warner Springs, CAthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.NTSB MIA96LA133Accident · No injuriesLimited investigationFinal reportMooney M20C · Cullowhee, NCThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB FTW93FA235Accident · 1 fatalField investigationFinal reportMooney M20C · Big Lake, TXThe pilot's failure to maintain terrain clearance.NTSB NYC92LA031Accident · 2 fatalLimited investigationFinal reportMooney M20C · Painesville, OHThe pilot's failure to see and avoid the powerline tower structure while executing a visual approach to the airport. Factors related to the accident were the lack of proper radio equipment necessary to execute the instrument approach, restricted visibility…NTSB ANC91LA006Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Madison Creek, AKThe pilot's premature lift off at an inadequate airspeed. Contributing to the accident was the unplowed snow on the runway.NTSB LAX87IA326Incident · No injuriesIncident investigationFinal reportMooney M20C · Los Angeles, CAThe plt rprtd that before landing, he went thru the landing checklist, but the green gear light did not illuminate. He contd the landing, & subsequently, the acft touched down & came to rest with the gear retracted. There was evidence the gear was retracted…NTSB DEN87LA073Accident · No injuriesLimited investigationFinal reportMooney M20C · Wahpeton, NDA CFI and a dual student were making practice landings. On the sixth landing, the student failed to lower the landing gear. The CFI did not notice that the acft did not have landing gear extended. The acft landed with gear fully retracted.NTSB DEN87LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Eureka, SDAfter normal takeoff, the acft contacted the terrain then continued on until it came to rest aprx 350' from the initial impact point. The landing gear had been retracted at the time of initial impact and the plt had no indication of any malfunction/failure.NTSB CHI84FA239Accident · 2 fatalField investigationFinal reportMooney M20C · Middlefield, OHThe acft props touched the rwy during a wheels-up approach and the plt initiated a go-around with bent props. The acft climbed to about 100 ft AGL with less than full power. The wings began to rock,the left wing dropped and the acft fell straight down to the…NTSB LAX84LA190Accident · No injuriesLimited investigationFinal reportMooney M20C · Scottsdale, AZThe plt reported that he failed to extend the landing gear prior to touchdown. Subsequently, the acft was damaged during a wheels up landing.NTSB DEN84LA088Accident · No injuriesLimited investigationFinal reportMooney M20C · Angel Fire, NMThe plt reported that during takeoff, the acft slowed as it hit patches of slush. He lifted off at the end of the rwy & retracted the gear while in ground effect. The acft would not maintain flying speed & settled in snow. It then went thru a fence beyond the…NTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…