Ongoing NTSB investigations, AK
4 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2025 | 3 |
|---|---|
| 2026 | 1 |
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\" = '240' 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" = '240' 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 ANC26LA042Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-14 · Nenana, AKNTSB ANC25FA079Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Dillingham, AKOn July 25, 2025, about 0916 Alaska daylight time, a Piper J3C-65 airplane, N5050R, was substantially damaged when it was involved in an accident near Dillingham, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC25LA065Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 180J · King Salmon, AKOn July 5, 2025, about 1430 Alaska daylight time, a Cessna 180J airplane, N52009, was substantially damaged when it was involved in an accident near King Salmon, Alaska. The pilot and two passengers were seriously injured and one passenger sustained minor…NTSB ANC25LA060Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-22-150 · Chinitna Bay, AKOn June 30, 2025, about 1630 Alaska daylight time, a Piper PA 22-150 airplane, N3609Z, was substantially damaged when it was involved in an accident near Chinitna Bay, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…