NTSB investigations: Bell 206A, 1983
3 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.
Cases per year
| 1967 | 1 |
|---|---|
| 1968 | 9 |
| 1969 | 18 |
| 1970 | 12 |
| 1971 | 7 |
| 1972 | 14 |
| 1973 | 9 |
| 1974 | 11 |
| 1975 | 7 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2008 | 1 |
| 2014 | 1 |
| 2020 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 1983
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 year(c."eventDate") = 1983
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" 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 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…NTSB FTW83LA328Accident · No injuriesLimited investigationFinal reportBell 206 · Houston, TXThe plt stated he intended to move the helicopter from a dolly platform to a surface parking area when the left skid collided with the dolly and the acft rolled over.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…