NTSB investigations: Bell 206L-3, 1993
3 cases on aircraft the registry lists as Bell 206L-3. 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
| 1983 | 3 |
|---|---|
| 1984 | 3 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 2 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 3 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 4 |
| 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\") = 1993
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182108'))
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") = 1993
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182108'))
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 LAX93FA316Accident · Serious injuriesField investigationFinal reportBell 206L1 · Tusayan, AZFailure of the pilot of N444CR to maintain adequate main rotor clearance from N38903, and the operator's failure to provide adequate or recommended safe helipad dimensions. A factor in the accident was the lack of visual reference to the rotating blades of…NTSB LAX93GA270Accident · Minor injuriesFinal reportBell 206L-3 · Agoura Hills, CAThe improper configuration of the aerial ignition device by the crew chief and an inadvertent activation of the unit by the pilot. The improper installation and configuration of the unit by maintenance personnel, inadequate crew coordination, and insufficient…NTSB FTW93FA192Accident · Minor injuriesField investigationFinal reportBell 206L-3 · West Monroe, LAThe pilot's inadequate planning and preparation prior to takeoff, and his failure to maintain obstacle clearance. Factors were the fog and low ceiling