NTSB investigations: Boeing E75, 1974

14 cases on aircraft the registry lists as Boeing E75. 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: Boeing E75, 1974 per year, 1964–2026: 222 cases
196413
19658
196610
19678
19687
196914
197017
197112
197214
197310
197414
19755
197610
19775
19784
19805
19813
19825
19831
19853
19864
19872
19882
19893
19902
19913
19922
19932
19941
19951
19961
19971
19981
19993
20002
20011
20021
20031
20061
20071
20081
20092
20102
20111
20122
20131
20141
20171
20201
20212
20243
20251
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 ('1380120'))
  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 OAK75FVA20Accident · No injuriesClosedBoeing A75 · Kerman, CASep 22, 1974 · N1064N · Substantial damageNTSB CHI75FEE16Accident · No injuriesClosedBoeing E75 · Streator, ILAug 26, 1974 · N4593N · Substantial damageNTSB MIA75FKG19Accident · Minor injuriesClosedBoeing A75N1 · Blakely, GAAug 20, 1974 · N65871 · Substantial damageNTSB FTW74FPG79Accident · 1 fatalClosedBoeing E75 · Hazen, ARJun 29, 1974 · N69239 · DestroyedNTSB SEA74FYI13Accident · Serious injuriesClosedStearman A75N1 · Klamath Flls, ORJun 28, 1974 · N53399 · Substantial damageNTSB MKC74FCQ46Accident · No injuriesClosedBoeing A75N1 · Hope, KSJun 24, 1974 · N268HC · DestroyedNTSB SEA74DYA37Accident · No injuriesClosedBoeing E75 · Shoshone, IDJun 17, 1974 · N1731B · Substantial damageNTSB SEA74DVA36Accident · No injuriesClosedBoeing E75 · Roberts, IDJun 7, 1974 · N5307N · Substantial damageNTSB IAD74FLQ33Accident · Serious injuriesClosedBoeing E75 · Clay, KYMay 23, 1974 · N1068N · DestroyedNTSB MIA74DLD86Accident · No injuriesClosedBoeing E75 · Avon Park, FLMay 15, 1974 · N4808V · Substantial damageNTSB IAD74FIA17Accident · No injuriesClosedBoeing E75 · Manassas, VAMay 14, 1974 · N52143 · Substantial damageNTSB FTW74FRA39Accident · 1 fatalClosedBoeing A75N1 · Nome, TXMay 2, 1974 · N59750 · DestroyedNTSB NYC74FHA29Accident · No injuriesClosedBoeing E-75 · E Stroudsburg, PAApr 21, 1974 · N33621 · Substantial damageNTSB FTW74FRA35Accident · 1 fatalClosedBoeing E75 · Beaumont, TXApr 20, 1974 · N4546N · Destroyed