NTSB investigations, 2013
5 cases where the sequence of events included External load event (Rotorcraft).
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 4 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 1 |
| 2020 | 5 |
| 2021 | 2 |
| 2023 | 3 |
| 2024 | 4 |
| 2025 | 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 year(c.\"eventDate\") = 2013
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '480' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2013 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '480' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR14CA041Accident · No injuriesData collectionFinal reportBell 206B · Superior, MTThe pilot's failure to maintain aircraft control while maneuvering during a long-line operation.NTSB CEN13LA461Accident · 2 fatalLimited investigationFinal reportHughes 369D · Ackerly, TXThe pilot’s failure to identify and maintain adequate clearance from a shield wire that was suspended between power transmission line towers.NTSB WPR13GA338Accident · 1 fatalFinal reportBell HH-1H · Mount Charleston, NVThe premature hoisting operation and the inadvertent disengagement of the hoist hook on the rescuer’s harness in dark night conditions. Contributing to the accident was a lack of direct audio communication between the rescuer and the hoist operator.NTSB WPR13LA303Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Missoula, MTThe pilot's failure to prevent the helicopter from settling with power and to maintain proper position relative to an external load, which resulted in a loss of control and subsequent hard landing.NTSB CEN13CA281Accident · No injuriesData collectionFinal reportHughes 369D · Camdenton, MOThe piece of wood/tree that contacted the main rotor blade during the low altitude tree-trimming flight.