NTSB investigations: Cessna 182K, 1974

15 cases on aircraft the registry lists as Cessna 182K. 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

19672026
NTSB investigations: Cessna 182K, 1974 per year, 1967–2026: 271 cases
196726
196828
196920
197010
197112
19729
19737
197415
197511
19767
197712
19783
19795
198014
19814
19822
19832
19842
19851
19862
19873
19884
19902
19914
19923
19945
19953
19961
19974
19982
19994
20002
20015
20033
20045
20062
20072
20081
20093
20101
20114
20121
20142
20163
20171
20181
20191
20202
20212
20221
20231
20241

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 ('2072724'))
  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 DEN75FTC12Accident · Minor injuriesClosedCessna 182 · Gillette, WYDec 16, 1974 · N3087Q · Substantial damageNTSB LAX75FUJ33Accident · Serious injuriesClosedCessna 182 · Phoenix, AZSep 15, 1974 · N3114Q · DestroyedNTSB FTW75DQD10Accident · No injuriesClosedCessna 182 · Alpine, TXAug 16, 1974 · N2525R · Substantial damageNTSB OAK75FVM09Accident · No injuriesClosedCessna 182K · S.Francisco, CAAug 6, 1974 · N3004Q · Substantial damageNTSB FTW75FRG01Accident · No injuriesClosedCessna 182 · Port Lavaca, TXJul 7, 1974 · N2569R · Substantial damageNTSB IAD74FID39Accident · No injuriesClosedCessna 182K · Chesterfield, VAMay 6, 1974 · N2850R · Substantial damageNTSB DEN74FQD21Accident · No injuriesClosedCessna 182K · Ruidoso, NMMay 4, 1974 · N2504R · Substantial damageNTSB SEA74AS041Accident · 1 fatalClosedCessna 182K · Walla Walla, WAApr 23, 1974 · N2510R · DestroyedNTSB IAD74FLT14Accident · No injuriesClosedCessna 182K · Dyersburg, TNApr 22, 1974 · N2890R · Substantial damageNTSB SEA74DYC31Accident · No injuriesClosedCessna 182K · Hillsboro, ORApr 7, 1974 · N3004Q · Substantial damageNTSB IAD74DKM46Accident · No injuriesClosedCessna 182 · Asheville, NCMar 4, 1974 · N2493Q · Substantial damageNTSB SEA74DYG26Accident · No injuriesClosedCessna 182 · Yakima, WAFeb 23, 1974 · N2821R · Substantial damageNTSB DEN74DTE46Accident · No injuriesClosedCessna 182K · Englewood, COJan 16, 1974 · N2653Q · Substantial damageNTSB LAX74DUG38Accident · No injuriesClosedCessna 182 · El Monte, CAJan 13, 1974 · N2809R · Substantial damageNTSB SEA74DYC32Accident · No injuriesClosedCessna 182 · Portland, ORJan 2, 1974 · N2511R · Substantial damage