NTSB investigations: Bell 206L-3, 1992
5 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\") = 1992
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") = 1992
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 FTW92LA166Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ponca City, OKThe pilot's failure to maintain main rotor RPM. A factor was the contaminated fuel.NTSB LAX92LA254Accident · Minor injuriesLimited investigationFinal reportBell 206-L3 · Waikoloa, HIFailure of the rear landing gear cross tube due to corrosion.NTSB FTW92FA112Accident · 2 fatalField investigationFinal reportBell 206L-3 · Venice, LAThe pilot's incapacitation due to food poisoning.NTSB FTW92LA070Accident · No injuriesLimited investigationFinal reportBell 206L-3 · South Pelto #1The pilot's inability to control the helicopter due to spatial disorientation. Factors were the fog and the pilot's failure to receive a weather briefing prior to the flight.NTSB FTW92LA062Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · E.I. Blk 108The pilot's failure to maintain altitude above the water. Factors were the pilot attempting flight into known adverse weather conditions of fog and low ceilings during dawn light conditions.