NTSB investigations, AK
26 cases where the sequence of events included Ground collision.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '200' 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 c."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '200' 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 ANC26LA040Accident · No injuriesClass 4 · LimitedInvestigation openDouglas DC3C · Anchorage, AKNTSB ANC26LA009Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-31-310 · Anchorage, AKNTSB ANC25LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Fairbanks, AKThe pilot’s failure to recognize that an automated taxiway gate was closing, and the pilot’s failure stop for the closing gate.NTSB ANC24LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB ANC23LA058Accident · Minor injuriesClass 4 · LimitedFinal reportCort J Neuman Apex · Wasilla, AKThe pilot’s failure to maintain clearance during takeoff, which resulted in impact with trees.NTSB ANC23LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · McGrath, AKThe pilot’s delayed decision to abort the takeoff, which resulted in a forced landing and impact with terrain.NTSB ANC23LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Chugiak, AKThe pilot’s failure to maintain directional control during takeoff in flat light conditions which resulted in a loss of control and impact with a snow berm.NTSB WPR22LA325Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Hope, AKThe pilot’s failure to maintain clearance from a tree while taxiing.NTSB ANC20CA067Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Naknek, AKThe PA-32 pilot's failure to see and avoid the other airplane.NTSB GAA19CA239Accident · No injuriesData collectionFinal reportGippsland GA8 · Bethel, AKThe pilot's failure to maintain adequate clearance from a shipping container while taxiing.NTSB GAA18CA087Accident · No injuriesData collectionFinal reportMaule MX7 · Willow, AKThe pilot’s failure to see and avoid another airplane stopped on the taxiway while taxiing in sun glare conditions.NTSB GAA16CA009Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Ketchikan, AKThe pilot's failure to maintain directional control during the engine start sequence, which resulted in the helicopter sliding on a steel deck and impacting a crane. Contributing to the accident was the absence of traction material on the helicopter…NTSB ANC14CA044Accident · No injuriesData collectionFinal reportCessna 208B · Egegik, AKThe pilot's loss of situational awareness during the takeoff roll resulting in a collision with a refrigeration trailer.NTSB ANC14CA036Accident · No injuriesData collectionFinal reportCessna 208B · Aniak, AKThe pilot's failure to maintain clearance from a forklift while taxiing.NTSB ANC12CA048Accident · No injuriesData collectionFinal reportCessna 207A · Platinum, AKThe pilot inadvertently taxied the airplane into a ditch.NTSB ANC12CA015Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Hughes, AKThe pilot did not clear the area surrounding the airplane prior to taxi, resulting in the airplane contacting a piece of baggage.NTSB ANC11CA097Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's misidentification of the runway environment in dusk light conditions.NTSB ANC10LA012Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Gulkana, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage to the airplane during landing.NTSB ANC09LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Anchorage, AKThe pilot's unfamiliarity with the airport environment, which resulted in his taxiing the airplane onto a no-taxi section of roadway and into a road sign. Contributing to the accident was the pilot's failure to avail himself of additional information that…NTSB ANC09CA041Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain clearance from a tree while taxiing.NTSB ANC09CA014Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Willow, AKA partial loss of engine power during takeoff, which prevented the airplane from reaching takeoff airspeed, resulting in an aborted takeoff, and an on-ground collision with a tree.NTSB ANC09TA005Accident · No injuriesFinal reportCessna A185F · Kenai, AKThe pilot's failure to maintain clearance from high vegetation while taxiing after landing.NTSB ANC09LA004Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe failure of both pilots to maintain adequate clearance/distance from each other at the taxiway intersection to avoid a collision. Contributing to the accident was a lack of clear and concise instruction to either airplane by the ground controller to…NTSB ANC08LA106Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot of the other airplane's excessive taxi speed while taxiing to the runway, and his failure to see the stopped airplane ahead of him in time to avoid a collision.NTSB ANC08CA086Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Pilot Point, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB ANC08CA048Accident · No injuriesData collectionFinal reportCessna 172 · Anchorge, AKThe pilot's failure to maintain clearance from a road sign while taxiing from landing.