NTSB investigations: Cessna 172G, 1974

14 cases on aircraft the registry lists as Cessna 172G. 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

19652026
NTSB investigations: Cessna 172G, 1974 per year, 1965–2026: 595 cases
19652
196667
196781
196841
196935
197027
197132
197222
197321
197414
197511
197614
197711
197811
19797
19805
19819
19825
19836
19844
19854
19866
19878
19888
19899
19907
199110
19929
19934
19945
19958
19966
19976
19985
19997
20004
20012
20026
20034
20052
20063
20072
20102
20111
20121
20132
20154
20173
20186
20193
20201
20216
20223
20233
20243
20255
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 ('2072420'))
  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 IAD75FKW07Accident · Serious injuriesClosedCessna 172 · Livingston, TNDec 18, 1974 · N1384F · Substantial damageNTSB SEA75FYE23Accident · No injuriesClosedCessna 172 · Seattle, WAOct 31, 1974 · N3763L · Substantial damageNTSB SEA75DYE22Accident · No injuriesClosedCessna 172 · Lummi Island, WAOct 26, 1974 · N3942L · Substantial damageNTSB FTW75FQG23Accident · Minor injuriesClosedCessna 172G · Amarillo, TXSep 11, 1974 · N5808R · DestroyedNTSB MIA75FLD10Accident · Serious injuriesClosedCessna 172G · Wauchula, FLAug 11, 1974 · N4320L · Substantial damageNTSB MKC75DCG06Accident · No injuriesClosedCessna 172 · Leawood, KSJul 24, 1974 · N5958R · Substantial damageNTSB DEN75AQA02Accident · Minor injuriesClosedCessna 172G · Wagon Mound, NMJul 8, 1974 · N3735L · Substantial damageNTSB IAD74DIG28Accident · Minor injuriesClosedCessna 172G · Petersburg, WVJun 11, 1974 · N4638L · Substantial damageNTSB SEA74DYE40Accident · No injuriesClosedCessna 172 · Olympia, WAMar 9, 1974 · N4681L · Substantial damageNTSB SEA74DYE38Accident · No injuriesClosedCessna 172 · Bellingham, WAFeb 24, 1974 · N4112L · Substantial damageNTSB IAD74DLJ31Accident · No injuriesClosedCessna 172 · Farmville, NCFeb 21, 1974 · N1100F · Substantial damageNTSB NYC74DNA32Accident · No injuriesClosedCessna 172 · Marlboro, MAJan 25, 1974 · N4261L · Substantial damageNTSB IAD74DLJ30Accident · No injuriesClosedCessna 172G · Hamilton, NCJan 18, 1974 · N4642L · Substantial damageNTSB SEA74DVE35Accident · Minor injuriesClosedCessna 172 · Bellingham, WAJan 2, 1974 · N1300T · Substantial damage