Fatal NTSB investigations
5 cases where the first occurrence was “Roll over”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 2004 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 380)
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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 380) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 LAX04LA249Accident · 1 fatalLimited investigationFinal reportBell 206B · Mesa, AZthe pilot's failure to adequately clear the left skid of obstacles resulting in a dynamic rollover of the helicopter and collision with terrain. A factor in the accident was the dark nighttime lighting conditions.NTSB LAX92LA030Accident · 1 fatalLimited investigationFinal reportBell 47-G5A · KosraeThe pilot-in-command's improper preflight inspection of the helicopter resulting in a tiedown strap not being removed from the right skid and subsequent roll over on takeoff.NTSB LAX88FA085Accident · 1 fatalField investigationFinal reportBell 47G-2A1 · San Diego, CAPilots complacency in performing the preflight inspection. His failure to disconnect the two tie downs straps attached to the right side of the helicopter resulted the roll.NTSB CHI85FA198Accident · 1 fatalField investigationFinal reportBell 47G-2 · Burlington, MIThe helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.NTSB DEN84FA102Accident · 1 fatalField investigationFinal reportBell 206B-III · Coalville, UTThe helicopter was equipped with 'bear paws'. Snowshoe-like devices on the skids to distribute weight on soft surfaces. The bear paws on this acft rotated freely around the skids, not tightened down as per design spec. Also, bear paws are not approved for…