Ongoing NTSB investigations, AK
9 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2024 | 2 |
|---|---|
| 2025 | 2 |
| 2026 | 5 |
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 c.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Ongoing'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' 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."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' 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 ANC26FA106Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-18-150 · Northway, AKOn September 17, 2026, about 1930 Alaska daylight time, a Piper PA-18-150 airplane, N9128D, was substantially damaged when it was involved in an accident near Northway, Alaska. The pilot and passenger were fatally injured. The airplane was operated as a Title…NTSB ANC26FA105Accident · 2 fatalClass 3 · FieldPreliminary reportCessna A185F · Stony River, AKOn September 15, 2026 about 1210 Alaska daylight time, a Cessna A185F airplane, N4358Q, was substantially damaged when it was involved in an accident near Stony River, Alaska. The pilot and passenger were fatally injured. The airplane was operated as a Title…NTSB WPR26FA309Accident · 8 fatalClass 3 · FieldPreliminary reportCessna 441 · Cape Newenham, AKOn August 20, 2026, at about 1145 Alaska daylight time, a Cessna 441, N128EZ, was destroyed when it was involved in an accident near Cape Newenham, Alaska. The two pilots and six passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ANC26FA077Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA22 · Chitina, AKOn July 27, 2026, about 2130 Alaska daylight time, a deregistered Piper PA-22-150 airplane, N4535A, was destroyed when it was involved in an accident near Chitina, Alaska. The pilot and two passengers were fatally injured. The airplane was operated as a Title…NTSB ANC26LA071Accident · Serious injuriesClass 4 · LimitedInvestigation openBellanca 7GCBC · Skwentna, AKNTSB ANC25FA044Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Kaparuk, AKOn June 4, 2025 about 1055 Alaska daylight time, a Robinson R66 turbine-powered helicopter, N962MD, was substantially damaged when it was involved in an accident near Kaparuk, Alaska. The pilot and passenger were fatally injured. The helicopter was operated…NTSB ANC25FA035Accident · 2 fatalClass 3 · FieldPreliminary reportCessna T207 · Nanwalek, AKOn April 28, 2025, about 1355 Alaska daylight time, a Cessna T207 airplane, N91025, was substantially damaged when it was involved in an accident near Nanwalek, Alaska. The pilot and one passenger were fatally injured. One passenger was seriously injured. The…NTSB ANC24FA091Accident · 2 fatalClass 3 · FieldPreliminary reportChampion 7GCBC · Ninilchik, AKOn September 13, 2024, about 0803 Alaska daylight time (AKDT), a Champion (Citabria) 7GCBC, N8CK, was substantially damaged when it was involved in an accident near Ninilchik, Alaska. The pilot and passenger were fatally injured. The airplane was operated as…NTSB ANC24FA052Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-18-150 · Moose Pass, AKOn June 18, 2024, about 1400 Alaska daylight time, a float-equipped Piper PA-18-150 airplane, N645DT, was substantially damaged when it was involved in an accident near Moose Pass, Alaska. The instructor pilot and the pilot receiving instruction were fatally…