NTSB investigations: Cessna 182L, 1974

14 cases on aircraft the registry lists as Cessna 182L. 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 182L, 1974 per year, 1967–2026: 252 cases
19671
196829
196925
197022
197114
19728
19738
197414
197510
197611
19773
19784
19795
19805
19816
19824
19833
19843
19853
19863
19873
19884
19894
19903
19912
19922
19933
19944
19952
19962
19983
20002
20014
20023
20033
20063
20071
20083
20101
20112
20121
20131
20141
20153
20163
20171
20191
20201
20212
20241
20252

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 ('2072726'))
  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 MIA75DLD45Accident · Minor injuriesClosedCessna 182L · Summerfield, FLDec 29, 1974 · N3372R · Substantial damageNTSB MIA75DKT45Accident · No injuriesClosedCessna 182L · Ft Lauderdale, FLDec 9, 1974 · N3494R · Substantial damageNTSB NYC75AN064Accident · 4 fatalClosedCessna 182L · White Plains, NYNov 20, 1974 · N3343R · DestroyedNTSB FTW75AF008Accident · 2 fatalClosedCessna 182L · San Antonio, TXAug 17, 1974 · N42791 · DestroyedNTSB OAK75DVG06Accident · No injuriesClosedCessna 182 · Lk Pillsbry, CAAug 2, 1974 · N42209 · Substantial damageNTSB NYC75FGM03Accident · Minor injuriesClosedCessna 182 · Beaver Falls, PAJul 29, 1974 · N42946 · Substantial damageNTSB MKC75FCA03Case · Minor injuriesClosedCessna 182L · Fenton, MOJul 13, 1974 · N42275 · Substantial damageNTSB CHI74FEV52Accident · Serious injuriesClosedCessna 182L · Salem, ILMay 21, 1974 · N3112R · Substantial damageNTSB IAD74FKW31Accident · Minor injuriesClosedCessna 182 · Nashville, TNMar 31, 1974 · N3149R · Substantial damageNTSB IAD74DLJ35Accident · No injuriesClosedCessna 182 · Jacksonville, NCMar 24, 1974 · N42603 · Substantial damageNTSB DEN74DTC28Accident · No injuriesClosedCessna 182L · Cheyenne, WYMar 2, 1974 · N3439R · Substantial damageNTSB NYC74FHM17Accident · Serious injuriesClosedCessna 182L · Matawan, NJFeb 22, 1974 · N3342R · Substantial damageNTSB LAX74DUM19Accident · No injuriesClosedCessna 182 · Chula Vista, CAFeb 2, 1974 · N3320R · Substantial damageNTSB SEA74DYA19Accident · No injuriesClosedCessna 182L · Bellevue, IDJan 8, 1974 · N3396R · Substantial damage