NTSB investigations: Mooney M20C, 1987
14 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 | 43 |
|---|---|
| 1965 | 64 |
| 1966 | 68 |
| 1967 | 70 |
| 1968 | 47 |
| 1969 | 34 |
| 1970 | 37 |
| 1971 | 31 |
| 1972 | 31 |
| 1973 | 21 |
| 1974 | 26 |
| 1975 | 27 |
| 1976 | 20 |
| 1977 | 17 |
| 1978 | 15 |
| 1979 | 14 |
| 1980 | 12 |
| 1981 | 11 |
| 1982 | 4 |
| 1983 | 7 |
| 1984 | 14 |
| 1985 | 5 |
| 1986 | 11 |
| 1987 | 14 |
| 1988 | 5 |
| 1989 | 6 |
| 1990 | 9 |
| 1991 | 4 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 10 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 9 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 8 |
| 2001 | 8 |
| 2002 | 3 |
| 2003 | 9 |
| 2004 | 7 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 5 |
| 2008 | 6 |
| 2009 | 5 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 4 |
| 2017 | 7 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 3 |
| 2025 | 1 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 1987
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 year(c."eventDate") = 1987
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 NYC88FA041Accident · 4 fatalField investigationFinal reportMooney M20C · St. Marys, PAWhile getting fuel, the pilot of the Mooney M20C and his 3 pals were attempting to remove frost with paper towels and plastic credit cards after being told by the fuel truck driver that the arpt had no ice removal solution. A witness stated that as the…NTSB LAX88FA042Accident · 4 fatalField investigationFinal reportMooney M20C · Grand Canyon, AZWhile cruising en route all engine power was suddenly lost and the plt attempted an emergency ldg at the Grand Canyon arpt. During the glide, the acft crashed into an outcrop of rocks on a steep cliff, 0.5 mi from the end of the rwy. Exam of the engine…NTSB FTW88LA001Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bulverde, TXOn the second approach after a go-around, the aircraft landed approximately halfway down the 2850 ft runway. In an attempt to go around the pilot applied power. The aircraft started to climb but collided with the top of a tree causing the tail of the aircraft…NTSB DEN87LA242Accident · No injuriesLimited investigationFinal reportMooney M20K · Aspen, COWhile on a cross country pleasure flt the acft engine failed apx four miles short of the dest aprt. A forced landing was made in a field.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 FTW87FA209Accident · 1 fatalField investigationFinal reportMooney M-20C · Waller, TXIt was reported that a private pilot was receiving instrument flight instructions from a CFI when the accident occurred. However, the CFI stated that he was invited by the pvt plt to go with him on a short flight and that he was only a passenger. During the…NTSB BFO87LA054Accident · No injuriesLimited investigationFinal reportMooney M20C · Baltimore, MDThe plt refueled the acft at princeton, NJ, bfr departing on a flt to linden, NJ, then continued on to laurel, MD. He believed that he had positioned the fuel selector to the rgt fuel tank & said that he had used fuel out of the same tank until he arrived at…NTSB NYC87LA219Accident · No injuriesLimited investigationFinal reportMooney M20C · Mclean, NYThe aircraft had flown for about 1-1/2 hours when the pilot began a descent from 12000 feet for an approach. However at 3500 feet, the engine suddenly went from normal cruise to idle. An emergency landing was made in a corn field and the aircraft was…NTSB BFO87LA052Accident · No injuriesLimited investigationFinal reportMooney M-20C · Basye, VAWhen the pilot applied brakes during the landing roll the acft swerved left. He applied the right brake to straighten the acft and the acft swerved right. The pilot attempted to correct with left brake and the right main gear collapsed. No malfunctions were…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 NYC87FA063Accident · 1 fatalField investigationFinal reportMooney M20C · Highgate, VTAccording to the surviving pax, a snowshower was enctrd, so the plt reversed course & diverted to another arpt. Drg a ngt apch to lnd, the pax noted a white light on the left side of the rwy. (A VASI light sys was installed for that rwy.) The plt aborted the…NTSB DCA87MA018Accident · 10 fatalClass 1 · MajorFinal reportSwearingen SA-226TC · Kearns, UTThe two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…NTSB LAX87LA082Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Spring Valley, CAA Mooney M20C collided with an automobile during landing roll after landing on a road. The plt indicated that while cruising at 3,500 ft MSL he noticed the eng oil pressure fall to zero. The constant speed propellor simultaneously went to low pitch, followed…