NTSB investigations, AK
16 cases where the sequence of events included Midair collision.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 3 |
| 2015 | 2 |
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2023 | 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 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\" = '250' 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" = '250' 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 ANC23LA071Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · King Salmon, AKThe failure of both pilots to see and avoid while en route, which resulted in a midair collision.NTSB ANC22LA002Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Chickaloon, AKA mid-air collision for reasons that could not be determined based on the available evidence.NTSB ANC22LA001Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe unmanned aircraft pilot’s failure to yield the right of way to the helicopter.NTSB ANC20LA085Accident · 2 fatalClass 3 · LimitedFinal reportCessna A185 · Fairbanks, AKThe PA-18 pilot’s failure to see and avoid the Cessna 185 as it was landing. Contributing to the accident was the PA-18 pilot’s failure to hear the traffic advisory provided by the air traffic control tower.NTSB ANC20LA074Accident · 7 fatalClass 3 · LimitedFinal reportDe Havilland DHC-2 · Soldotna, AKThe failure of both pilots to see and avoid the other airplane. Contributing to the accident were (1) the PA-12 pilot’s decision to fly with a known severe vision deficiency that had resulted in denial of his most recent application for medical certification…NTSB CEN19MA141Accident · 6 fatalClass 1 · MajorFinal reportDe Havilland DHC-2 · Ketchikan, AKThe inherent limitations of the see-and-avoid concept, which prevented the two pilots from seeing the other airplane before the collision, and the absence of visual and aural alerts from both airplanes’ traffic display systems, while operating in a geographic…NTSB ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.NTSB ANC16FA061Accident · 5 fatalField investigationFinal reportCessna 208 · Russian Mission, AKThe failure of both pilots to see and avoid each other while in level cruise flight, which resulted in a midair collision.NTSB ANC16FA052Accident · Minor injuriesField investigationFinal reportCessna 210-5 · Wasilla, AKThe failure of both pilots to see and avoid each other while landing at a non-tower-controlled airport, which resulted in a midair collision. Contributing to the accident was the absence of radio calls from the Cessna during the traffic pattern preceding the…NTSB ANC15LA033Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe other pilot’s failure to maintain an adequate visual lookout, which resulted in a midair collision. Contributing to the accident was the other pilot’s failure to follow Federal Aviation Administration-recommended traffic pattern procedures.NTSB ANC15FA009Accident · Serious injuriesField investigationFinal reportPiper PA 18 · Wasilla, AKBoth pilots’ inadequate visual lookout and failure to see and avoid each other while in level cruise flight, which resulted in a midair collision. Contributing to the accident was the obscuration of the other pilot’s visibility due to sun glare.NTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.NTSB ANC11FA071Accident · 4 fatalField investigationFinal reportCessna U206G · Talkeetna, AKThe inadequate visual lookout and failure to see and avoid by the pilots of both airplanes while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the lack of standardized, unequivocal procedures concerning common…NTSB ANC11FA062Accident · No injuriesField investigationFinal reportCessna U206 · Port Alsworth, AKThe pilot’s failure to see and avoid the approaching airplane. Contributing to the accident was that the pilot’s failure to listen to radio position reports from the other airplane on the common traffic advisory frequency and the absence of any forward-facing…NTSB ANC10LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKBoth pilots’ failure to see and avoid each other during initial climb, resulting in a midair collision. Contributing to the accident was the pilot of N9699P’s inability to use his airplane's radio for air traffic advisories.NTSB ANC09LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairbanks, AKThe failure of the instructor pilot in the other airplane to maintain separation from the Cessna 182R, and his failure to follow the tower controller’s instructions.