NTSB investigations: Bell 206B, 1976

16 cases on aircraft the registry lists as Bell 206B. 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: Bell 206B, 1976 per year, 1967–2026: 720 cases
19671
19681
19691
19701
19711
19727
197312
19746
197520
197616
197718
197816
197918
198022
198125
198214
198318
198419
198518
198617
198711
198812
198923
199020
199113
19929
199316
199422
199513
199623
199715
199813
199914
200015
200110
200210
200317
200417
200514
20068
200717
20085
20094
201011
20119
201211
201312
201411
20158
20168
201711
20188
201910
20205
20217
202211
20238
20249
20257
20262

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\") = 1976
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181511'))
  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 FTW77DA021Accident · No injuriesClosedBell 206B · Morgan City, LADec 11, 1976 · N49669 · Substantial damageNTSB DEN77DQA03Accident · No injuriesClosedBell 206B · Aztec, NMOct 17, 1976 · N9914K · Substantial damageNTSB ANC76AA115Accident · No injuriesClosedBell 206B · Colville River, AKJul 29, 1976 · N59568 · Substantial damageNTSB FTW76AF109Accident · Serious injuriesClosedBell 206B · Berwick, LAJul 15, 1976 · N8176J · DestroyedNTSB DEN76FTM39Accident · Minor injuriesClosedBell 206B · Coalville, UTJul 14, 1976 · N49570 · Substantial damageNTSB OAK76AP060Accident · 3 fatalClosedBell 206B · Carson City, NVJul 5, 1976 · N600SW · Substantial damageNTSB ANC76AA108Accident · 4 fatalClosedBell 206B · Palmer, AKJun 30, 1976 · N58013 · DestroyedNTSB ANC76AA118Accident · No injuriesClosedBell 206B · Eagle, AKJun 28, 1976 · N2953W · Substantial damageNTSB SEA76DYI46Accident · No injuriesClosedBell 206B · Westport, WAJun 26, 1976 · N100YB · Substantial damageNTSB ANC76AA098Accident · No injuriesClosedBell 206B · Talkeetna, AKJun 11, 1976 · N39AL · Substantial damageNTSB ANC76AA094Accident · No injuriesClosedBell 206B · Coldfoot, AKJun 3, 1976 · N90188 · Substantial damageNTSB FTW76AF085Accident · 1 fatalClosedBell 206B · Leeville, LAApr 17, 1976 · N14856 · DestroyedNTSB DEN76AD041Accident · No injuriesClosedBell 206B · Gobernador, NMMar 18, 1976 · N7849S · Substantial damageNTSB ANC76AA067Accident · No injuriesClosedBell 206B · Augustine Isld, AKFeb 2, 1976 · N90217 · Substantial damageNTSB OAK76FJA09Accident · 1 fatalClosedBell 206B · Honolulu, HIJan 9, 1976 · N59471 · Substantial damageNTSB ANC76AA059Accident · Serious injuriesClosedBell 206B · Kenai, AKJan 4, 1976 · N59481 · Substantial damage