NTSB investigations: Bell Helicopter Textron 206L-1, 1986
4 cases on aircraft the registry lists as Bell Helicopter Textron 206L-1. 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
| 1978 | 1 |
|---|---|
| 1979 | 2 |
| 1980 | 5 |
| 1981 | 16 |
| 1982 | 7 |
| 1983 | 5 |
| 1984 | 9 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 13 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 1 |
| 1997 | 5 |
| 1998 | 2 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 9 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 3 |
| 2009 | 5 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 7 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182107'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182107'))
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 SEA87MA034Accident · 3 fatalMajor investigationFinal reportBell 206L-1 · Pendleton, ORThe helicopter departed Pendleton on an emerg med svc/med-evac (EMS) flt to transport a patient to portland. After delivering the patient, the plt took off on the rtn flt with 2 med psnl aboard. Drg arrival at 1658 PST, he requested a special VFR (svfr)…NTSB ATL87MA035Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Jamestown, TNThe helicopter was being used in an emerg med svc/med-evac (EMS) opn. At 0230, the plt obtained a partial wx briefing. He was advised of flt prctns for IFR wx thru-out the area with low ceilings, fog, precip & mtns obscd. The flt departed nashville at 0245 &…NTSB SEA86LA204Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grangeville, IDThe helicopter plt was on an emergency medical service (ems/medivac) flt to transport survivors from an airplane accident. He landed at night on a ridge about 1/4 mi from the airplane crash site. At about 2400 MDT, the plt attempted to takeoff from the…NTSB FTW86LRA07Accident · Serious injuriesFinal reportBell 206L-1 · Sabine Pass, TXAcft encountered deteriorating weather enroute from shore to an oil rig that was under tow in the gulf of Mexico. Upon encountering IMC conditions, the plt climbed to 600' AGL for better obstacle clearance and turned back toward the beach. During a subsequent…