NTSB investigations, AK
10 cases where the first occurrence was “Undetermined”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 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\" = 400)
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" = 400) 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 ANC99LA065Accident · 1 fatalLimited investigationFinal reportStinson 108 · Anchorage, AKUndetermined.NTSB ANC98LA001Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Sterling, AKUndetermined.NTSB ANC97FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Bethel, AKfailure of the pilot to maintain control of the airplane, while maneuvering to reverse direction after takeoff, after encountering an undetermined anomaly. The undetermined anomaly was a related factor.NTSB ANC94LA133Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairbanks, AKUndetermined.NTSB ANC94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, AKUndetermined.NTSB ANC89LA181Accident · 4 fatalLimited investigationFinal reportCessna R172K · Anchorage, AKUndetermined.NTSB ANC87LA005Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chickaloon Flat, AKThe pilot-in-command refused to cooperate and would not submit an NTSB form 6120.1 nor would he discuss the accident except that he crashed upon landing. The plts med. Cert had expired.NTSB ANC86LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot lost control of the aircraft on landing at a winter ice landing strip.NTSB ANC83FA143Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Hope, AKThe acft crashed under unknown circumstances. The wreckage was removed after an aerial survey & has not been located.NTSB ANC82FAG14Accident · 3 fatalFinal reportCessna 180 · Skwenta, AKThe aircraft departed finger lake at approximately 1000 ast for a short ice fishing trip to fish lakes. The aircraft never returned and a search was started. The wreckage was located near the kahiltna river about 5 miles from the intended destination on…