Skip to content

NTSB investigations: Mooney M20C, GA

26 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.

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" = 'GA' 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 ('5870208')) 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\" = 'GA' 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 ('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 c."eventStateOrRegion" = 'GA' 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 ('5870208'))
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 ERA23LA120Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20C · Calhoun, GAA partial loss of engine power during the initial climb due to an improperly installed spark plug.Jan 28, 2023 · N5587Q · Destroyed NTSB ERA20LA123Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · McIntyre, GAA total loss of engine power for reasons that could not be determined.Mar 7, 2020 · N9281M · Substantial damage NTSB ATL03FA137Accident · 1 fatalField investigationFinal reportMooney M-20C · Monticello, GAThe pilot's continued VFR flight into IMC conditions, and his failure to maintain obstacle clearance and collision with trees. A factor was low ceiling.Sep 13, 2003 · N2764W · Substantial damage NTSB ATL02FA026Accident · 1 fatalField investigationFinal reportMooney M20C · Gainesville, GAThe loss of engine power due to fuel starvation, resulting from fuel system blockage and improper maintenance by maintenance personnel. A factor was the unsuitable terrain.Dec 29, 2001 · N6953V · Destroyed NTSB ATL89IA180Incident · No injuriesIncident investigationFinal reportMooney M20C · Marietta, GAThe pilot's failure to properly flare the airplane.Jul 18, 1989 · N1379W · Minor damage NTSB ATL85FA252Accident · 4 fatalField investigationFinal reportMooney M20C · Columbus, GAAcft departed airport after enroute stop for fueling.VFR conditions with broken clouds at 2800 feet and turbulence in clouds. Acft was cleared to 4500 and PIC asked to report reaching. During climb PIC was asked his altitude. His response was unintelligible…Aug 17, 1985 · N5844Q · Destroyed NTSB MIA85LA164Accident · No injuriesLimited investigationFinal reportMooney M20C · Bainbridge, GAWhile en route, the plt noted a severe eng vibration. He shut down the eng & made an emergency landing. During the roll-out, the acft hit a ditch & was damaged. An investigation revealed that one prop blade had failed from fatigue & the end of the blade had…May 4, 1985 · N6850U · Substantial damage NTSB ATL83IA302Incident · No injuriesIncident investigationFinal reportMooney M20C · St.Simonsisland, GAAcft had neither a green light nor mechanical indication of safe gear confirmed by the tower. All landing gear collapsedon touchdown. The motor to actuator coupling which is common to both electric & manual landing gear systems failed.Jul 28, 1983 · N9244V · Minor damage NTSB ATL82FLA02Accident · No injuriesClosedMooney M20C · Folkston, GAOct 16, 1981 · N9244V · Substantial damage NTSB ATL81FLA09Accident · No injuriesClosedMooney M20C · Thomasville, GAJul 17, 1981 · N5832Q · Substantial damage NTSB ATL80FKG03Accident · No injuriesClosedMooney M20C · Columbus, GAMay 26, 1980 · N5832Q · Substantial damage NTSB MIA79FKG24Accident · No injuriesClosedMooney M20C · Peachtree City, GAMar 13, 1979 · N1956Y · Substantial damage NTSB MIA74FKG81Accident · Serious injuriesClosedMooney M20C · Chamblee, GAJun 4, 1974 · N6774N · Substantial damage NTSB MIA73DKG74Accident · No injuriesClosedMooney M20C · Villa Rica, GAApr 29, 1973 · N9256M · Substantial damage NTSB MIA73AM011Accident · 3 fatalClosedMooney M-20C · Texas, GAJul 25, 1972 · N5951Q · Destroyed NTSB NYC72AN162Accident · 2 fatalClosedMooney M20C · Milan, GAJun 25, 1972 · N9286M · Destroyed NTSB MIA72FKG75Accident · Serious injuriesClosedMooney M20E · Augusta, GAFeb 24, 1972 · N7867V · Minor damage NTSB MIA71AM088Accident · 4 fatalClosedMooney M20C · Athens, GAApr 17, 1971 · N6752V · Destroyed NTSB MIA69F0156Accident · No injuriesClosedMooney M20C · Calhoun, GAMay 11, 1968 · N7856V · Substantial damage NTSB MIA68D0245Accident · No injuriesClosedMooney M20C · Lithonia, GAOct 14, 1967 · N2615W · Substantial damage NTSB MIA68D0161Accident · No injuriesClosedMooney M20C · Chamberlee, GASep 2, 1967 · N2948L · Substantial damage NTSB MIA68F0039Accident · No injuriesClosedMooney M20C · Mitchell, GAJun 22, 1967 · N2600W · Substantial damage NTSB MIA67F0545Accident · Minor injuriesClosedMooney M20C · Roopville, GAMay 5, 1967 · N6589U · Destroyed NTSB MIA67F0250Accident · No injuriesClosedMooney M20C · Augusta, GASep 3, 1966 · N6281U · Substantial damage NTSB UNK64X1540Accident · No injuriesClosedMooney M21 · Atlanta, GAMay 1, 1964 · N6903U · Substantial damage NTSB UNK64X0671Accident · No injuriesClosedMooney M21 · Columbus, GAFeb 23, 1964 · N1362W · Substantial damage