NTSB investigations, 2014
6 cases where the sequence of events included Settling with power/vortex ring state.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 5 |
| 2013 | 3 |
| 2014 | 6 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 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\") = 2014
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '244' 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") = 2014 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '244' 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 WPR15CA063Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 Ecureuil · Bicknell, UTThe pilot's failure to prevent the helicopter from settling with power while maneuvering at a low altitude, which resulted in a loss of control and subsequent hard landing.NTSB WPR14CA385Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Mokuleia, HIThe pilot's failure to maintain aircraft control during landing with a quartering tailwind, which resulted in a hard landing.NTSB WPR14FA324Accident · Serious injuriesField investigationFinal reportS.N.I.A.S. AS350B · Tahoma, CAThe pilot's loss of helicopter control due to settling with power while maneuvering for takeoff.NTSB WPR14CA290Accident · Minor injuriesData collectionFinal reportBell 47K · Kingston, WAThe pilot's failure to maintain aircraft control during the landing approach, which resulted in an excessive descent angle and settling with power.NTSB ANC14CA042Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Coldfoot, AKThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude, which resulted in an emergency landing on uneven terrain.NTSB CEN14CA252Accident · No injuriesData collectionFinal reportAerospatiale AS 365 N2 Dauphin · Constantine, MIThe pilot's loss of control while entering a vortex ring state (settling with power) condition, which resulted in a hard landing.