NTSB investigations: Mooney M20C, 1974

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.

Cases per year

19642026
NTSB investigations: Mooney M20C, 1974 per year, 1964–2026: 824 cases
196443
196564
196668
196770
196847
196934
197037
197131
197231
197321
197426
197527
197620
197717
197815
197914
198012
198111
19824
19837
198414
19855
198611
198714
19885
19896
19909
19914
19926
19937
199410
19954
19965
19979
19984
19994
20008
20018
20023
20039
20047
20054
20064
20075
20086
20095
20101
20113
20122
20132
20144
20153
20164
20177
20183
20193
20204
20213
20224
20233
20251
20262

Latest 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\") = 1974
    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.

NTSB OAK75FVW11Accident · No injuriesClosedMooney M20C · Las Vegas, NVDec 21, 1974 · N6563U · Substantial damageNTSB MIA75DLA18Accident · No injuriesClosedMooney M20C · Palatka, FLOct 19, 1974 · N6673U · Substantial damageNTSB DEN75FQA17Accident · No injuriesClosedMooney M20C · Zuni, NMSep 2, 1974 · N6445U · Substantial damageNTSB NYC75FNE07Accident · No injuriesClosedMooney M20C · Fitchburg, MAAug 13, 1974 · N2550W · Substantial damageNTSB MKC75AK018Accident · Minor injuriesClosedMooney M20C · Stewartville, MNAug 6, 1974 · N3911N · Substantial damageNTSB DEN75FTC05Accident · No injuriesClosedMooney M20C · Sheridan, WYAug 5, 1974 · N6874U · Substantial damageNTSB CHI75DEV01Accident · No injuriesClosedMooney M20 · Mt Vernon, ILAug 4, 1974 · N99WK · Substantial damageNTSB OAK75DVG07Accident · No injuriesClosedMooney M20C · Fair Oaks, CAAug 2, 1974 · N5629Q · Substantial damageNTSB MKC75DER05Accident · No injuriesClosedMooney M20C · Winona, MNJul 26, 1974 · N3411X · Substantial damageNTSB MKC75DCQ06Accident · No injuriesClosedMooney M20C · Sublette, KSJul 13, 1974 · N78934 · Substantial damageNTSB MKC74FER63Accident · No injuriesClosedMooney M20C · Crystal, MNJun 29, 1974 · N6898U · Substantial damageNTSB IAD74FLQ38Accident · Minor injuriesClosedMooney M20C · Clarkson, KYJun 10, 1974 · N7173U · Substantial damageNTSB MIA75DLD95Accident · No injuriesClosedMooney M20C · Sanford, FLJun 9, 1974 · N9263V · Substantial damageNTSB NYC74AN103Accident · 1 fatalClosedMooney M20C · Matawan, NJJun 5, 1974 · N78944 · DestroyedNTSB MIA74FKG81Accident · Serious injuriesClosedMooney M20C · Chamblee, GAJun 4, 1974 · N6774N · Substantial damageNTSB CHI74FEV53Accident · Serious injuriesClosedMooney M20C · Watseka, ILMay 27, 1974 · N9251M · Minor damageNTSB MIA74DKJ58Accident · Minor injuriesClosedMooney M20C · Auburn, ALMay 12, 1974 · N5575Q · Substantial damageNTSB IAD74DKM54Accident · No injuriesClosedMooney M20C · Asheville, NCApr 21, 1974 · N6583U · Substantial damageNTSB NYC74AN088Accident · 4 fatalClosedMooney M20C · Dorset, VTApr 15, 1974 · N78990 · DestroyedNTSB MIA74DLA33Accident · No injuriesClosedMooney M20E · Pensacola, FLFeb 20, 1974 · N7105U · Substantial damageNTSB FTW74DRJ27Accident · No injuriesClosedMooney M20C · Ruston, LAFeb 17, 1974 · N7898V · Substantial damageNTSB FTW74FQD15Accident · No injuriesClosedMooney M20C · El Paso, TXFeb 5, 1974 · N7810V · DestroyedNTSB OAK74DVG21Accident · No injuriesClosedMooney M20C · Napa, CAJan 28, 1974 · N9272M · Substantial damageNTSB MKC74DCG18Accident · Minor injuriesClosedMooney M20C · Ashland, MOJan 19, 1974 · N6265U · Substantial damageNTSB IAD74DID25Accident · Serious injuriesClosedMooney M20C · Norfolk (Atlantic Ocean)Jan 7, 1974 · N78985 · DestroyedNTSB NYC74DHD25Accident · Minor injuriesClosedMooney M20C · Honeybrook, PAJan 1, 1974 · N7867V · Substantial damage