Final NTSB investigations: Bell 206B II

5 cases on aircraft the registry lists as Bell 206B II. 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

19742026

Final NTSB investigations: Bell 206B II per year, 1974–2026: 5 cases
1974	1
1984	1
1991	1
2000	1
2010	1

Where

Open the map

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181505')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181505'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181505'))
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 WPR10CA364Accident · No injuriesData collectionFinal reportBell 206 B II · Big Bear City, CAThe pilot's failure to maintain directional control during the landing approach.Jul 24, 2010 · N788BD · Substantial damage NTSB SEA00LA197Accident · No injuriesLimited investigationFinal reportBell 206BII · Newhalem, WADebonding between the elastomeric material and the center plate of the transmission isolation mount.Aug 24, 2000 · N90307 · Substantial damage NTSB SEA91FA124Accident · No injuriesField investigationFinal reportBell 206BII · Brewster, WAThe pilot-in-command's selection of unsuitable terrain for the emergency simulation.May 28, 1991 · N90307 · Substantial damage NTSB SEA84LA219Accident · No injuriesLimited investigationFinal reportBell 206 · Boulder City, NVThe plt was landing at a helipad that was surrounded by a wire fence. He reported that as he was about to land, he misjudged his apch & the tail rotor struck the fence. Subsequently, the helicopter hit the ground while turning right & the gear collapsed.Sep 4, 1984 · N13ML · Substantial damage NTSB ANC75AA013Accident · No injuriesClosedBell 206B · Umiat, AKAug 10, 1974 · N6227N · Destroyed