Skip to content

NTSB investigations: Mooney M20E, FL

32 cases on aircraft the registry lists as Mooney M20E. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212'))
  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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA24LA022Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20E · Pembroke Pines, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.Oct 26, 2023 · N1953Y · Substantial damage NTSB ERA11IA110Incident · No injuriesIncident investigationFinal reportMooney M20E · St. Petersburg, FLAn inadequately maintained interior cockpit boot, which allowed a flashlight to fall through and subsequently jam the airplane's flight controls. Contributing to the incident was a lack of emphasis by government, industry, and advocacy groups that the…Jan 6, 2011 · N7828V · No damage NTSB ERA11CA020Accident · Minor injuriesData collectionFinal reportMooney M20E · New Smyrna Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the loss of engine power due to water contaminated fuel.Oct 13, 2010 · N5743Q · Substantial damage NTSB MIA08LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Sarasota, FLA loss of engine power due to contamination in the fuel filter.Dec 26, 2007 · N5875Q · Substantial damage NTSB ATL01LA011Accident · No injuriesLimited investigationFinal reportMooney M20E · Fort Myers, FLFuel system contamination that resulted in fuel starvation.Nov 27, 2000 · N9198V · Substantial damage NTSB MIA94FA031Accident · 1 fatalField investigationFinal reportMooney M20E · Jacksonville, FLFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall. A factor related to the accident was: the lack of altitude for recovery from a stall.Nov 30, 1993 · N9241V · Substantial damage NTSB MIA93LA140Accident · No injuriesLimited investigationFinal reportMooney M20E · Miami, FLThe pilot-in-command's improper flare during a forced landing which resulted in a hard landing. Contributing to the accident was the total loss of engine power for undetermined reasons.Jun 10, 1993 · N1305W · Substantial damage NTSB MIA88LA237Accident · No injuriesLimited investigationFinal reportMooney M-20E · Punta Gorda, FLThe plt stated he kept his acft outdoors & he had not flown it for 7 days. He stated he had not refueled the acft after the last flt & had parked it with 1/2 tanks. Fss personnel stated there had been rain showers in the area during that time. The plt stated…Jul 26, 1988 · N9369M · Substantial damage NTSB MIA88LA022Accident · No injuriesLimited investigationFinal reportMooney M20F · Vero Beach, FLPlt stated that while turning final approach he believes he placed the landing gear handle in the down position and observed red gear intransit lights. He was occupied by a strong wind for the landing and never checked for a gear down and safe indication. The…Oct 29, 1987 · N413HM · Substantial damage NTSB MIA83LA131Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Daytona Beach, FLThe plt stated that during touch down the acft bounced & he lost control. He elected to go around to try to regain control of the acft. During the go-around the acft veered right & collided with a palm tree.Apr 27, 1983 · N9450V · Substantial damage NTSB MIA81FLD47Accident · No injuriesClosedMooney M20E · Tampa, FLJun 1, 1981 · N6061Q · Substantial damage NTSB MIA80DLD72Accident · No injuriesClosedMooney M20E · Merritt Island, FLJun 7, 1980 · N9234M · Substantial damage NTSB MIA80DKT25Accident · Serious injuriesClosedMooney M20C · Marco Island, FLFeb 6, 1980 · N3256F · Substantial damage NTSB MIA79FKT70Accident · Minor injuriesClosedMooney M20E · Pompano, FLJun 2, 1979 · N6873U · Substantial damage NTSB MIA76FLA51Accident · No injuriesClosedMooney M20E · Cross City, FLMay 28, 1976 · N6941U · Substantial damage NTSB MIA76FLA50Accident · No injuriesClosedMooney M20E · Lake City, FLMay 26, 1976 · N6922U · Substantial damage NTSB MIA75DLD61Accident · No injuriesClosedMooney M20E · Sumterville, FLMar 16, 1975 · N9299M · Substantial damage NTSB MIA74DLA48Accident · No injuriesClosedMooney M20E · Keystone Hts, FLJun 29, 1974 · N9299M · Substantial damage NTSB MIA73AM028Accident · 2 fatalClosedMooney 101E · Perry, FLSep 9, 1972 · N5759Q · Destroyed NTSB MIA72FKT65Accident · No injuriesClosedMooney M20E · Boca Raton, FLMar 27, 1972 · N9455V · Substantial damage NTSB MIA71FLD44Accident · No injuriesClosedMooney M20E · St Petersburg, FLJan 13, 1971 · N9238V · Substantial damage NTSB MIA70DLD11Accident · No injuriesClosedMooney M20E · Leesburg, FLJan 22, 1970 · N9279M · Substantial damage NTSB MIA68A0052Accident · 4 fatalClosedMooney M20E · Tallahassee, FLNov 26, 1967 · N9253M · Destroyed NTSB MIA68F0269Accident · Serious injuriesClosedMooney M20E · Ft.Mccoy, FLOct 29, 1967 · N1302W · Substantial damage NTSB MIA67D0164Accident · No injuriesClosedMooney M20A · Holopaw, FLAug 20, 1966 · N1990Y · Substantial damage NTSB MIA66D0542Accident · No injuriesClosedMooney M20E · Lantana, FLApr 29, 1966 · N5811Q · Substantial damage NTSB MIA66D0461Accident · No injuriesClosedMooney M20E · Tavernier, FLMar 23, 1966 · N79821 · Destroyed NTSB MIA66F0287Accident · Minor injuriesClosedMooney M20E · Cedar Key, FLOct 2, 1965 · N1290X · Substantial damage NTSB MIA66F0037Accident · No injuriesClosedMooney M2OE · Cedar Key, FLJun 4, 1965 · N6990U · Substantial damage NTSB UNK64X3081Accident · No injuriesClosedMooney MK21E · Crystal River, FLJul 28, 1964 · N1302W · Substantial damage NTSB UNK64X2982Accident · No injuriesClosedMooney M20E · Chipley, FLJul 23, 1964 · N1938Y · Substantial damage NTSB UNK64X1773Accident · No injuriesClosedMooney M20E · Vero Beach, FLMay 15, 1964 · N1950Y · Substantial damage