NTSB investigations, 2009
15 cases where the sequence of events included Roll over.
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 15 |
| 2010 | 14 |
| 2011 | 13 |
| 2012 | 18 |
| 2013 | 12 |
| 2014 | 19 |
| 2015 | 19 |
| 2016 | 13 |
| 2017 | 17 |
| 2018 | 34 |
| 2019 | 20 |
| 2020 | 7 |
| 2021 | 8 |
| 2022 | 4 |
| 2023 | 8 |
| 2024 | 6 |
| 2025 | 6 |
| 2026 | 8 |
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\") = 2009
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '097' 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") = 2009 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '097' 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 WPR10CA064Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe pilot's failure to maintain control of the helicopter.NTSB ERA10CA051Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Morovis, PRThe pilot’s delayed attempt to go around.NTSB CEN09LA558Accident · No injuriesLimited investigationFinal reportHughes 269C · Arapahoe, NEA sudden vibration for undetermined reasons.NTSB CEN09CA539Accident · No injuriesData collectionFinal reportDunn David RAF 2000 C · Lakeville, MNThe pilot's failure to maintain control of the aircraft during the landing flare.NTSB WPR09LA373Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Riverdale, CAThe partial loss of engine power due to the failure of the engine's supercharger-blower.NTSB WPR09CA339Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Marysville, CAThe pilot’s failure to maintain adequate clearance from the power line wires.NTSB ERA09CA349Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe pilot's failure to maintain control of the helicopter during hover, resulting in a rollover.NTSB WPR09LA213Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Las Vegas, NVLoss of engine power during approach for undetermined reasons.NTSB WPR09LA161Accident · No injuriesLimited investigationFinal reportBrown Barnett J4B · Sheridan, CAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.NTSB CEN09LA202Accident · Serious injuriesLimited investigationFinal reportHughes 269C · El Indio, TXThe pilot's failure to maintain control of the helicopter while attempting to land on a transport trailer in heavy rain and gusting winds.NTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.NTSB WPR09IA128Incident · No injuriesIncident investigationFinal reportCessna 172H · Tucson, AZThe flight instructor’s inadequate situational awareness while taxiing that led to an encounter with jet blast.NTSB CEN09CA133Accident · Minor injuriesData collectionFinal reportBrantly B-2B · Cement, OKThe pilot's failure to maintain proper airspeed and descent rate during approach, which resulted in a hard landing. Contributing to the accident were the nearby power lines.NTSB WPR09FA072Accident · No injuriesField investigationFinal reportEurocopter AS 350 BA · Honolulu, HIThe partial loss of engine power during landing for an undetermined reason.