Skip to content

Fatal NTSB investigations: Bell 206A

33 cases on aircraft the registry lists as Bell 206A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

Where

Latest cases

Query with SQL

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 c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181508')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181508'))
  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.

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 c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181508'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR14FA310Accident · 1 fatalField investigationFinal reportBell 206A · Wenatchee, WAThe pilot's failure to maintain a proper decent rate and path, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's impairment by a sedating medication.Jul 23, 2014 · N949FM · Substantial damage NTSB LAX94LA187Accident · 2 fatalLimited investigationFinal reportBell 206A · Pacific Ocean (Pacific Ocean)undetermined.Mar 1, 1994 · N4712R · Destroyed NTSB NYC83FA188Accident · 4 fatalField investigationFinal reportCessna U206G · Brooklyn, NYA Cessna U206G float plane, N5328X, & a bell 206A police helicopter, N4797R, collided in flt over Brooklyn, NY. The aircrew of the police helicopter were on a traffic observation flt & had just reported traffic conditions in the vicinity of a toll station…Jul 22, 1983 · N5328X · 2 aircraft · Destroyed NTSB ANC83FA032Accident · 1 fatalField investigationFinal reportBell 206B · Cordova, AKThe helicopter was on a rescue/recovery flt for the Alaska state troopers with the plt & a state trooper on board. They departed in variable wx conditions to rescue the plt of another acft. Reportedly, snow was falling in the search area & the winds were…Jan 13, 1983 · N74PR · Destroyed NTSB FTW83FA066Accident · 3 fatalField investigationFinal reportBell 206B · San Antonio, TXThe acft departed brackettville at 0715 & at 0740 contacted uvalde UNICOM for their wx. When informed that uvalde was "zero-zero" the flt continued east. The acft was later observed & heard flying above the low indefinite ceiling shortly before impacting the…Dec 23, 1982 · N206H · Destroyed NTSB DEN80FA059Accident · 3 fatalClosedBell 206A/B · Red Lodge, MTAug 30, 1980 · N8030 · Destroyed NTSB MIA77FA031Accident · 1 fatalClosedBell 206-A · Jayuya, PRFeb 17, 1977 · N4046G · Destroyed NTSB OAK76AP057Accident · 2 fatalClosedBell 206B · Bishop, CAJun 22, 1976 · N7941S · Destroyed NTSB FTW76AF059Accident · 1 fatalClosedBell 206B · Intercstl City, LAJan 19, 1976 · N143PA · Destroyed NTSB OAK75FJA04Accident · 1 fatalClosedBell 206 · Honokaa, HISep 30, 1974 · N4760R · Substantial damage NTSB ANC75AA007Accident · 1 fatalClosedBell 206A · Umiat, AKJul 30, 1974 · N7854S · Destroyed NTSB OAK75FXQ01Accident · 1 fatalClosedBell 206B · Reno, NVJul 5, 1974 · N206DB · Destroyed NTSB FTW74AF053Accident · 1 fatalClosedBell 206B · Venice, LAJan 8, 1974 · N4020G · Destroyed NTSB NYC74AN046Accident · 1 fatalClosedBell 206A · Webster, PANov 20, 1973 · N461NC · 2 aircraft · Destroyed NTSB IAD74AI017Accident · 2 fatalClosedBell 206A · Beltsville, MDSep 18, 1973 · N6294N · Destroyed NTSB NYC74AN009Accident · 1 fatalClosedBell 206A · New York, NYJul 28, 1973 · N4087G · Destroyed NTSB NYC73AN056Accident · 2 fatalClosedBell 206A · Graysonville, MDOct 28, 1972 · N4069G · Destroyed NTSB NYC73AN050Accident · 2 fatalClosedBell 206A · Whitehaven, PAOct 7, 1972 · N6260N · Destroyed NTSB FTW72AF087Accident · 2 fatalClosedBell 206B · Cameron, LAJun 28, 1972 · N1457W · Destroyed NTSB NYC72AN163Accident · 4 fatalClosedBell 206A · New Cumberland, PAJun 26, 1972 · N25BB · Destroyed NTSB ANC72AA001Accident · 3 fatalClosedBell 206 · Fairbanks, AKJul 21, 1971 · N7893S · Destroyed NTSB LAX71AL043Accident · 1 fatalClosedBell 206A · Bakersfield, CADec 31, 1970 · N22DA · Destroyed NTSB ANC71AA009Accident · 1 fatalClosedBell 206A · Fairbanks, AKAug 1, 1970 · N6253N · Substantial damage NTSB ANC71AA002Accident · 1 fatalClosedBell 206A · Hurricane, AKJul 10, 1970 · N1462W · Destroyed NTSB ANC70AA081Accident · 1 fatalClosedBell 206-A · Deadhorse, AKMay 28, 1970 · N830JA · Substantial damage NTSB NYC70AN094Accident · 2 fatalClosedBell 206A · Floral Park, NYMar 1, 1970 · N7867S · Destroyed NTSB LAX70A0036Accident · 1 fatalClosedBell 206A · Grnd Canyon, AZDec 15, 1969 · N1479W · Destroyed NTSB LAX70F0230Accident · 2 fatalClosedBell 206A · Grnd Canyon, AZJul 29, 1969 · N4057G · Destroyed NTSB LAX69A0061Accident · 2 fatalClosedBell 206A · San Diego, CAApr 30, 1969 · N1430W · Destroyed NTSB DIA69A0046Accident · 2 fatalClosedBell 206A · Clintwood, VAFeb 28, 1969 · N4720R · Destroyed NTSB FTW68A0103Accident · 1 fatalClosedBell 206A · Morgan City, LAJun 3, 1968 · N7943S · Destroyed NTSB LAX68A0096Accident · 5 fatalClosedBell 206A · Carpenteria, CAApr 27, 1968 · N6275N · Destroyed NTSB FTW68A0079Accident · 1 fatalClosedBell 206A · Saginaw, TXMar 13, 1968 · N6270N · Substantial damage