NTSB investigations: Cessna 182P, 1974

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

19722026
NTSB investigations: Cessna 182P, 1974 per year, 1972–2026: 700 cases
197213
197323
197424
197529
197640
197736
197842
197931
198020
198119
198225
198322
198413
198517
198614
19877
19888
198910
199013
19918
19928
199311
199420
19958
199615
199713
199810
19997
20009
200113
20027
20038
200413
20057
20065
200713
20083
20099
201010
20119
20128
20136
20143
20154
20167
20177
20188
20196
20207
20214
20226
20232
20246
20259
20265

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 ('2075816'))
  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 OAK75DXQ33Accident · No injuriesClosedCessna 182 · Jackpot, NVDec 19, 1974 · N7211N · Substantial damageNTSB NYC75AN061Accident · 1 fatalClosedCessna 182P · Niagara Falls, NYNov 13, 1974 · N21168 · DestroyedNTSB CHI75FEE28Accident · No injuriesClosedCessna 182P · Chicago, ILOct 31, 1974 · N7248N · Substantial damageNTSB CHI75FEP31Accident · Serious injuriesClosedCessna 182P · Racine, WIOct 28, 1974 · N21534 · Substantial damageNTSB MIA75DKT18Accident · No injuriesClosedCessna 182 · Miami, FLOct 12, 1974 · N58615 · Substantial damageNTSB IAD75AI019Accident · 1 fatalClosedCessna 182 · Relief, KYOct 6, 1974 · N84311 · Substantial damageNTSB MIA75FLA17Accident · No injuriesClosedCessna 182P · Pensacola, FLOct 4, 1974 · N21283 · Substantial damageNTSB DEN75FTE30Accident · Minor injuriesClosedCessna 182P · Center, COOct 1, 1974 · N7381N · Substantial damageNTSB OAK75DVG28Accident · No injuriesClosedCessna 182 · Covelo, CASep 27, 1974 · N9341G · Substantial damageNTSB NYC75FHM09Accident · No injuriesClosedCessna 182 · Spring Valley, NYSep 17, 1974 · N21408 · Substantial damageNTSB CHI75FEA09Accident · No injuriesClosedCessna 182 · Franklin, INAug 14, 1974 · N21538 · Substantial damageNTSB SEA75DYA11Accident · Minor injuriesClosedCessna 182P · Rockland, IDAug 12, 1974 · N91298 · DestroyedNTSB NYC75AN012Accident · 4 fatalClosedPiper PA-28R · Toms River, NJJul 25, 1974 · N43100 · 2 aircraft · DestroyedNTSB SEA74AS051Accident · 1 fatalClosedCessna 182P · Zigzag, ORJun 25, 1974 · N21018 · DestroyedNTSB MIA74FLG30Accident · Serious injuriesClosedCessna 182P · Ridgeway, SCJun 9, 1974 · N7287N · Substantial damageNTSB DEN74FTE78Accident · Serious injuriesClosedCessna 182 · Englewood, COMay 21, 1974 · N52681 · Substantial damageNTSB FTW74DPG57Accident · No injuriesClosedCessna 182 · Jonesboro, ARApr 14, 1974 · N52406 · Substantial damageNTSB CHI74DEI37Accident · No injuriesClosedCessna 182P · Fremont, OHApr 3, 1974 · N91377 · Substantial damageNTSB DEN74DTE60Accident · Minor injuriesClosedCessna 182 · Lake City, COMar 26, 1974 · N9378G · Substantial damageNTSB LAX74AL062Accident · 4 fatalClosedCessna 182P · Ventura, CAMar 17, 1974 · N20860 · DestroyedNTSB CHI74FE134Accident · Minor injuriesClosedCessna 182 · Vickery, OHMar 7, 1974 · N21388 · Substantial damageNTSB LAX74DVW11Accident · No injuriesClosedCessna 182P · Shoshone, CAJan 7, 1974 · N7335Q · Substantial damageNTSB DEN74AD032Accident · 1 fatalClosedCessna 182P · Ward, COJan 6, 1974 · N21267 · DestroyedNTSB NYC74FGT14Accident · No injuriesClosedCessna 182 · New Cumberland, PAJan 4, 1974 · N52372 · Substantial damage