NTSB investigations: Bell 206B-III
5 cases on aircraft the registry lists as Bell 206B-III, where the first occurrence was “In flight collision with object”. 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
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181506')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181506')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 LAX07CA072Accident · Minor injuriesData collectionFinal reportBell Helicopter 206BIII · Springville, CAThe pilot's failure to maintain terrain/obstacle clearance while maneuvering. Factors were the mountainous terrain, trees, and low-altitude flight maneuvers.NTSB MIA97FA070Accident · 4 fatalField investigationFinal reportBell 206-B3 · Fort Lauderdale, FLThe pilot's incapacitation by carbon monoxide from undetermined sources which led to his diminished ability to see and avoid a radio tower.NTSB LAX92FA088Accident · 5 fatalField investigationFinal reportBell 206BIII · Crockett, CAThe pilot's failure to maintain vigilant watch for obstructions while intentionally cruising slowly at a low altitude. A factor was the power line was supported by distant towers, and the line was not conspicuous.NTSB ANC87FA051Accident · 1 fatalField investigationFinal reportBell 206B-3 · Valdez, AKThe helicopter collided with transmission lines while on pipeline patrol, fatally injuring the pilot and seriously injuring the observer. The observer stated that he and the pilot had been flying towards a burning object on the snow near two snow machines…NTSB MIA85LA192Accident · Minor injuriesLimited investigationFinal reportBell 206B · West Palm Beach, FLTwo helicopters had just completed a mail delivery operation as a flt of two. N159L had landed and the plt left the eng running so as to let the eng operting temp stabilize. N156L approached in a ground hover and collided with N159L. The two plts received…