NTSB investigations, 2016
13 cases where NTSB found Pole.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 9 |
| 2010 | 5 |
| 2011 | 10 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 8 |
| 2015 | 8 |
| 2016 | 13 |
| 2017 | 8 |
| 2018 | 18 |
| 2019 | 11 |
| 2020 | 6 |
| 2021 | 9 |
| 2022 | 2 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 4 |
| 2026 | 1 |
Where
Latest 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\") = 2016
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022010'))
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") = 2016 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03022010')) 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 CEN16CA393Accident · No injuriesData collectionFinal reportBell 230 · Fargo, NDThe pilot's failure to maintain clearance from the ground obstacle during the landing with gusting winds present.NTSB GAA16CA486Accident · No injuriesData collectionFinal reportChampion 7GC · Palmer, AKThe pilot’s inadequate preflight inspection and failure to assess the airplane’s fuel quantity before departure, which resulted in fuel exhaustion.NTSB GAA16CA485Accident · Minor injuriesData collectionFinal reportDormaier Monte R Baby Great Lakes · Mazama, WAThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.NTSB WPR16LA175Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Honolulu, HIThe pilot's failure to maintain helicopter control in gusting wind conditions, which resulted in the helicopter rescue net’s contact with a utility pole and serious injury to an occupant who fell from the rescue net. Contributing to the accident was the…NTSB GAA16CA445Accident · No injuriesData collectionFinal reportCessna T207 · Nanwalek, AKThe pilot’s unstabilized approach and a subsequent runway overrun while landing on a short runway in variable wind conditions.NTSB GAA16CA283Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Spring Branch, TXThe pilot's failure to maintain helicopter control while hovering in gusting tailwind conditions, resulting in the tailboom striking a light pole and impact with terrain.NTSB GAA16CA253Accident · No injuriesData collectionFinal reportCessna 172 · Shawnee, OKThe pilot's failure to remain a safe distance from obstacles while taxiing to parking, resulting in the airplane's wing striking a light pole.NTSB CEN16LA167Accident · No injuriesLimited investigationFinal reportProbst Zenair 601XL · Hempstead, TXA loose output connection from the generator voltage regulator, which resulted in a loss of power to the electronic ignition system, a total loss of engine power, and a subsequent forced landing, during which the airplane impacted a sign pole.NTSB GAA16CA186Accident · No injuriesData collectionFinal reportCessna 172 · Punta Gorda, FLThe pilot's failure to avoid obstacles and maintain situational awareness while taxiing.NTSB ERA16LA111Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pembroke Pines, FLThe loss of engine power while on approach for reasons that could not be determined based on the available evidence.NTSB GAA16LA135Accident · No injuriesLimited investigationFinal reportPinkston Randy T RV-7 · Tavernier, FLThe pilot's misidentification of a parallel roadway for the runway and the airplane's subsequent collision with numerous objects during landing.NTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.NTSB ERA16LA091Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Madison, GAThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.