Skip to content

NTSB investigations: Mooney M20C, VA

20 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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 ERA22LA020Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Lynchburg, VAThe uncommanded landing gear retraction following a hard landing for reasons that could not be determined.Oct 17, 2021 · N669GJ · Substantial damage NTSB GAA18CA004Accident · Minor injuriesData collectionFinal reportMooney M20 · Topping, VAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a departure stall.Oct 7, 2017 · N7884V · Substantial damage NTSB NYC04CA115Accident · No injuriesData collectionFinal reportMooney M20C · Front Royal, VAThe pilot's failure to maintain directional control during an aborted landing. A factor in this accident was the crosswind conditions.Apr 29, 2004 · N99NH · Substantial damage NTSB IAD02LA023Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Martinsville, VAThe pilot's premature rotation and his failure to maintain directional control during the takeoff roll.Dec 30, 2001 · N6779U · Substantial damage NTSB BFO94LA106Accident · No injuriesLimited investigationFinal reportMooney M20C · Leesburg, VAThe pilot's failure to maintain the minimum descent altitude until the published approach fix. Factors related to the accident was pilot fatigue, low ceilings, obscuration, and fog.Jun 18, 1994 · N6679U · Substantial damage 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…Jul 19, 1987 · N6769U · Substantial damage NTSB ATL86FA222Accident · Serious injuriesField investigationFinal reportMooney M20C · Hillsville, VAThe plt, also an A&P and IA, had flown the acft on the previous day and noted RPM at 2500 on initial climb. On the accident flt, the acft was loaded to near max gross weight and takeoff was attempted at a density alt of 4810 ft MSL. The acft used about 3/4 of…Aug 16, 1986 · N3986N · Destroyed NTSB IAD79FIJ01Accident · Serious injuriesClosedMooney M20C · Grundy, VAOct 20, 1978 · N1348W · Substantial damage NTSB IAD77FA027Accident · 1 fatalClosedMooney M20C · Forest, VAMar 5, 1977 · N6755U · Destroyed NTSB IAD75FIA17Accident · Serious injuriesClosedMooney M20C · New Market, VAMar 15, 1975 · N6705U · Substantial damage NTSB IAD71AI027Accident · No injuriesClosedMooney M20C · Lynchburg, VAOct 21, 1970 · N9170V · Substantial damage NTSB IAD70AI040Accident · No injuriesClosedMooney M20C · Manassas, VAJan 24, 1970 · N9339V · Substantial damage NTSB DIA69D0072Accident · No injuriesClosedMooney M20C · Baileys Xroads, VAOct 2, 1968 · N6770U · Substantial damage NTSB DIA68D0222Accident · No injuriesClosedMooney M21 · Culpepper, VAApr 28, 1968 · N9256M · Substantial damage NTSB DIA67F0033Accident · No injuriesClosedMooney M20C · Richmond, VAJan 21, 1967 · N639MA · Substantial damage NTSB NYC67D0235Accident · Minor injuriesClosedMooney M21 · Monterey, VAAug 27, 1966 · N78876 · Destroyed NTSB NYC66A0109Accident · 2 fatalClosedMooney M20C · Belmead, VAApr 3, 1966 · N6760U · Destroyed NTSB NYC66F0588Accident · No injuriesClosedMooney M20C · Gordonsville, VAMar 24, 1966 · N6255U · Substantial damage NTSB UNK64X1335Accident · No injuriesClosedMooney M20C · Gretna, VAApr 16, 1964 · N6751U · Substantial damage NTSB UNK64X0185Accident · Serious injuriesClosedMooney M20C · Head Waters, VAJan 8, 1964 · N6886U · Destroyed