NTSB investigations, AK
6 cases where the first occurrence was “Near collision between aircraft”.
Cases per year
| 1986 | 1 |
|---|---|
| 1992 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 2000 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 280)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 280) 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 ANC00IA088Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKAn inoperative traffic alert and collision avoidance system (TCAS).NTSB ANC96IA065Incident · No injuriesIncident investigationFinal reportVeazie Super Acro Zenith CH · Fairbanks, AKthe pilot's improper understanding of his amended clearance, and the local controller's failure to assure that the pilot understood that he was cleared only to land. Factors in the incident were: the airport design that places two airplanes in close proximity…NTSB ANC94IA075Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Juneau, AKThe failure of the local controller to exercise his responsibility to have each aircraft adjust its flightpath to remain clear of the other, and the failure of the pilot of the Cessna 185 to maintain adequate visual separation from the Boeing 737.NTSB ANC93IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Anchorage, AKImproper ATC clearance instructions by the approach controller, resulting in a failure to insure safe separation between an airplane in visual conditions with an airplane in instrument meteorological conditions on converging courses. A factor which…NTSB ANC92IA100Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Dillingham, AKThe pilot in command's failure to maintain a visual lookout. Factors were the drizzle and fog and the impossibility of updating the recorded weather information by ATC personnel.NTSB ANC87IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10 · Adak, AKA canadian pacific Mcdonnell Douglas DC-10 (flt 3), cg-cpj, & a reeve aleutian Boeing 727 (flt 724), N832, were clrd to fly at FL 290 on 2 different airways. The airways crossed at picum intxn, ovr the bearing sea. While traveling in nrly opposite drctns at…