NTSB investigations: Cessna 170A, 1974

19 cases on aircraft the registry lists as Cessna 170A. 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: Cessna 170A, 1974 per year, 1964–2026: 457 cases
196422
196518
196620
196728
196822
196921
197018
197115
197213
197317
197419
197515
19766
197713
197813
197911
19807
19818
19826
19838
19842
19857
19863
19879
19885
19896
19907
19914
19925
19932
19944
19952
19964
19975
19987
19993
20001
20014
20023
20037
20043
20051
20063
20076
20083
20093
20102
20115
20123
20132
20141
20154
20164
20176
20181
20203
20215
20222
20232
20245
20252
20261

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 ('2072304'))
  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 NYC75DHA28Accident · No injuriesClosedCessna 170A · Pittstown, NJDec 28, 1974 · N7A · Substantial damageNTSB NYC75FHD25Accident · Minor injuriesClosedCessna 170 · Marlton, NJOct 5, 1974 · N3860V · DestroyedNTSB MKC75DTK02Accident · No injuriesClosedCessna 170 · Vermillion, SDSep 17, 1974 · N5732C · Substantial damageNTSB DEN75AD005Accident · 2 fatalClosedCessna 170A · Bernardo, NMAug 25, 1974 · N5423C · DestroyedNTSB OAK74DVG69Accident · No injuriesClosedCessna 170A · Redding, CAJul 13, 1974 · N1700D · DestroyedNTSB MKC75DCA02Accident · No injuriesClosedCessna 170A · House Springs, MOJul 5, 1974 · N9734A · Substantial damageNTSB CHI74FER05Accident · No injuriesClosedCessna 170A · Horse Creek, WIJun 30, 1974 · N9546A · Substantial damageNTSB DEN74AD058Accident · 2 fatalClosedCessna 170A · Dubois, WYJun 18, 1974 · N5787C · DestroyedNTSB MIA74DKT84Accident · No injuriesClosedCessna 170A · Naples, FLJun 11, 1974 · N9152A · Substantial damageNTSB NYC74FHM28Accident · No injuriesClosedCessna 170A · Fairfield, NJMay 20, 1974 · N5461C · Substantial damageNTSB ANC74FAA35Accident · Serious injuriesClosedCessna 170 · Mckinley Prk, AKMay 19, 1974 · N1312D · DestroyedNTSB ANC74FAA34Accident · No injuriesClosedCessna 170A · North Pole, AKMay 18, 1974 · N5583C · Substantial damageNTSB IAD74AI058Accident · 2 fatalClosedCessna 170A · Newport News, VAMay 3, 1974 · N9503A · DestroyedNTSB CHI74DEP43Accident · No injuriesClosedCessna 170A · Gratiot, WIApr 21, 1974 · N5781C · Substantial damageNTSB ANC74DAG98Accident · No injuriesClosedCessna 170A · Mt.Village, AKApr 12, 1974 · N5724C · Substantial damageNTSB MKC74FCG28Accident · No injuriesClosedCessna 170A · Bonner Sprgs, KSMar 30, 1974 · N1242D · Substantial damageNTSB NYC74DFJ26Accident · No injuriesClosedCessna 170A · Batavia, NYFeb 18, 1974 · N5709C · Substantial damageNTSB MKC74DTK08Accident · No injuriesClosedCessna 170A · Bemis, SDJan 20, 1974 · N1279D · Substantial damageNTSB LAX74DVA40Accident · No injuriesClosedCessna 170A · Kennedy Mds, CAJan 12, 1974 · N9781A · Substantial damage