Skip to content

NTSB investigations: Mooney M20C, OH

21 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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 CHI07CA265Accident · No injuriesData collectionFinal reportMooney M20-C · Hicksville, OHThe pilot failed to execute a go-around.Aug 12, 2007 · N6837U · Substantial damage NTSB CHI07LA121Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sidney, OHThe total loss of engine power during initial climb due to oil starvation as a result of improper maintenance. The fixed base operator's failure to advise the pilot that the engine had been operated without oil in the engine and soft terrain were factors.Apr 16, 2007 · N3529H · Substantial damage NTSB NYC03CA156Accident · Minor injuriesData collectionFinal reportMooney M20C · Utica, OHThe pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A factor was the unsuitable terrain.Jul 13, 2003 · N33WL · Substantial damage 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…Nov 16, 1991 · N9637M · Destroyed 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…Jun 16, 1984 · N6262U · Destroyed NTSB CHI81FA083Accident · 2 fatalClosedMooney M20C · Plymouth, OHAug 3, 1981 · N6698U · Destroyed NTSB CHI75FEK24Accident · No injuriesClosedMooney M20C · Pataskala, OHMar 2, 1975 · N78928 · Substantial damage NTSB CHI73FEI21Accident · No injuriesClosedMooney M20-C · Strongsville, OHNov 22, 1972 · N7101U · Substantial damage NTSB CHI71FGG21Accident · No injuriesClosedMooney M20C · Van Wert, OHNov 26, 1970 · N5547Q · Substantial damage NTSB CHI71DGD06Accident · No injuriesClosedMooney M20C · Put-In-Bay, OHJul 4, 1970 · N6840N · Substantial damage NTSB CHI70FGA13Accident · No injuriesClosedMooney M20C · Cincinnati, OHJun 9, 1970 · N6811N · Substantial damage NTSB CHI68F0503Accident · Minor injuriesClosedMooney M20C · Shadyside, OHDec 17, 1967 · N79800 · Substantial damage NTSB CHI68F0462Accident · Minor injuriesClosedMooney 20C · Columbus, OHNov 19, 1967 · N78912 · Substantial damage NTSB CHI68F0393Accident · No injuriesClosedMooney M20C · Zanesville, OHOct 28, 1967 · N6001Q · Substantial damage NTSB CHI67D0379Accident · No injuriesClosedMooney M20C · Bowling Grn, OHNov 5, 1966 · N6731U · Substantial damage NTSB CHI67D0103Accident · No injuriesClosedMooney M20C · Nelsonville, OHAug 2, 1966 · N2793W · Substantial damage NTSB CHI67D0011Accident · No injuriesClosedMooney MK20C · Hopewell, OHJun 17, 1966 · N6604U · Substantial damage NTSB CHI66D0038Accident · No injuriesClosedMooney M20 · Mansfield, OHMay 15, 1965 · N6877U · Substantial damage NTSB CHI65D0203Accident · No injuriesClosedMooney M-21 · Toledo, OHMay 9, 1965 · N6671R · Substantial damage NTSB CHI65D0128Accident · No injuriesClosedMooney M20 · New Philadepa, OHApr 20, 1965 · N78975 · Substantial damage NTSB UNK65X0274Accident · No injuriesClosedMooney M21 · Athens, OHOct 14, 1964 · N6408U · Substantial damage