Ongoing NTSB investigations: Bell 206B
5 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
| 2024 | 1 |
|---|---|
| 2025 | 3 |
| 2026 | 1 |
Where
Open the mapLatest 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 c.\"completionStatus\" = 'Ongoing'
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.
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" = 'Ongoing'
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" DESCRun 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 CEN26LA264Accident · Serious injuriesClass 4 · LimitedInvestigation openBell 206B · Saint Joseph, ILNTSB ERA25LA338Accident · Serious injuriesClass 3 · LimitedPreliminary reportBell 206 · Monroe, GAOn September 10, 2025, about 1100 eastern daylight time, a Bell 206, N992MR, was destroyed when it was involved in an accident near Monroe, Geogia. The flight instructor and student pilot were seriously injured. The helicopter was operated as a Title 14 Code…NTSB CEN25LA232Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B · Edgerton, MOOn July 1, 2025, at 0845 central daylight time, a Bell 206B, N17626, was substantially damaged when it was involved in an accident near Edgerton, Missouri. The commercial pilot was uninjured. The helicopter was operated under Title 14 Code of Federal…NTSB WPR25LA134Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B · Amboy, WAOn April 14, 2025, about 1800 Pacific daylight time, a Bell 206B, N16671, was substantially damaged when it was involved in an accident near Amboy, Washington. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal Regulations,…NTSB CEN24FA287Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206 · Nashua, IAOn July 29, 2024 about 1330 central standard time, a Bell 206-B3 Helicopter, N94XA, was destroyed when it was involved in an accident near Nashua, Iowa. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal Regulations Part…