NTSB investigations: Mooney M20J, 1987
13 cases on aircraft the registry lists as Mooney M20J. 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
| 1977 | 2 |
|---|---|
| 1978 | 13 |
| 1979 | 7 |
| 1980 | 3 |
| 1981 | 9 |
| 1982 | 9 |
| 1983 | 11 |
| 1984 | 7 |
| 1985 | 10 |
| 1986 | 3 |
| 1987 | 13 |
| 1988 | 11 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 7 |
| 1992 | 5 |
| 1993 | 11 |
| 1994 | 11 |
| 1995 | 9 |
| 1996 | 6 |
| 1997 | 4 |
| 1998 | 9 |
| 1999 | 7 |
| 2000 | 9 |
| 2001 | 7 |
| 2002 | 9 |
| 2003 | 10 |
| 2004 | 8 |
| 2005 | 7 |
| 2006 | 9 |
| 2007 | 6 |
| 2008 | 4 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 9 |
| 2013 | 9 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 7 |
| 2017 | 5 |
| 2018 | 7 |
| 2019 | 8 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 6 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 6 |
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 ('5870219'))
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 ('5870219'))
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 MIA88LA060Accident · No injuriesLimited investigationFinal reportMooney M20J · St Theresa, FLWhile in cruise flt at 3000 ft south-southeast of st. Theresa, FL over the gulf of Mexico, the plt reported a total loss of power. Attempts to restart were unsuccessful. The acft was then ditched aprx 11 nautical miles & 146 degrees from st. Theresa, FL, near…NTSB MKC88LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Springdale, ARDrg a wx briefing bfr tkof, the plt was adzd that VFR flt was not rcmdd due to low ceiling & icing conds. He was adzd the freezing lvl was forecast to be at 4000' over little rock & to slope down to the surface in se Missouri. Also, he was briefed on pireps…NTSB FTW88LA002Accident · No injuriesLimited investigationFinal reportMooney M-20-J · Kerrville, TXAcft was substantially damaged when it collided with a road sign and the grnd during an off arpt emergency lndg following a complete eng failure during descent. Plt stated that about 20 mins out from his dest, the oil press decreased into the yellow arc, but…NTSB MIA87LA249Accident · No injuriesLimited investigationFinal reportMooney M20J · Macclenny, FLWhile en route at 8000', the eng lost power & the plt obtained vectors for an emerg landing at an arpt with a grass strip. Drg the roll-out, the left wing tip hit a hay wagon near the end of the rwy, then the acft veered & struck a hangar. An exam of the…NTSB LAX87FA335Accident · 1 fatalField investigationFinal reportMooney M20J · Dublin, CAThe pilot had flown 5.6 hours during the day, starting the first flight about 0600. ATC controllers stated that the pilot did not follow the clearance issued to him. The controllers then issued radar vectors. The instructor the pilot flew with earlier in the…NTSB LAX87FA296Accident · No injuriesField investigationFinal reportCessna 152 · Palo Alto, CAA midair collision occurred abt 2.8 mi west of Palo Alto arpt (pao) as Cessna 152, N152SC, was on a left x-wnd dep fm rwy 30 & Mooney 20J, N5201Y was transitting the arpt traffic area (ata) fm se to NE & dscndg fm 2400' to 1500'. N152SC was on twr freq.…NTSB FTW87LA159Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Dallas, TXDuring flare/touchdown on runway 15, the aircraft's right wing came up sharply, due to a gusting cross wind, causing the left wing to strike the runway. The aircraft then cartwheeled, left wing, nose, right wing, causing substantial damage. Reported winds at…NTSB MIA87FA187Accident · 1 fatalField investigationFinal reportMooney M20J · Merritt Island, FLAccording to witnesses, the plt performed a hasty preflt & an abbreviated run-up bfr taking off. After lift-off, the acft bgn a rgt turn, then rolled rapidly to the left & crossed over the extended rwy centerline twd a left downwind. Subsequently, it rolled…NTSB FTW87LA128Accident · No injuriesLimited investigationFinal reportMooney M20J · Marietta, OKThe plt attempted takeoff from the 2450 ft rwy at the mcgeehe catfish airport near Marietta, OK. The rwy was soft with a sharp rise in the direction of takeoff. The plt failed to maintain airspeed after liftoff and directional control was lost resulting in…NTSB DEN87LA126Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COThe private plt and his pax were starting a cross country business flt. The plt reported that on initial climb, at 100 feet AGL. The acft lost partial pwr and began to settle. A gear up, forced landing to a field resulted in substantial damage to the acft.…NTSB LAX87FA134Accident · 1 fatalField investigationFinal reportMooney M20J · Weed, CABefore takeoff, the plt was adzd that strong head winds, mod to svr turbc, mtn obscurement, multiple layers of icing & deteriorating wx were forecast along his route of flt. He filed an IFR clnc & took off at 1115 PST. While en route, he reqd the medford wx &…NTSB CHI87LA062Accident · No injuriesLimited investigationFinal reportMooney M20J · Kalamazoo, MIAfter requesting clearance to Kalamazoo county airport (azo) due to icing problems, the plt was given radar vectors to the ILS runway 35 approach. Four minutes later the plt stated that it was 'probably going to be a dead stick landing.' When asked what he…NTSB FTW87FA043Accident · 1 fatalField investigationFinal reportMooney M20J · Gladewater, TXThe pilot departed into low overcast clouds (about 200 foot ceiling) with one to two miles visibility in light rain and fog. He did not file a flight plan although he was instrument rated. His currency for flight in instrument conditions are unknown.…