NTSB investigations, AK
12 cases where the first occurrence was “Altitude deviation,uncontrolled”.
Cases per year
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 4 |
| 1991 | 3 |
| 1992 | 1 |
| 2001 | 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\" = 110)
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" = 110) 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 ANC01FA100Accident · Serious injuriesField investigationFinal reportCessna 172S · Cooper Landing, AKThe pilot's inadequate remedial action to disconnect the autopilot during an uncommanded altitude deviation while in cruise flight. Factors in the accident were activation of the autopilot; the pilot's lack of familiarity with the airplane's autopilot system;…NTSB ANC92LA087Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Klutina Lake, AKThe pilo'ts poor inflight planning. Factors include downdrafts, and mountainous/ hilly terrain.NTSB ANC92LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Moose Pass, AKThe pilot's premature lift-off, causing the airplane to settle back to the ground. Contributing to the accident was the pilot's loss of directional control after settling back on the runway, due to his visibility being restricted by frost on the windshield.NTSB ANC92LA008Accident · No injuriesLimited investigationFinal reportCessna A185E · Dog Salmon Riv, AKThe pilot's failure to maintain airspeed. Contributing to the accident was the downdraft.NTSB ANC91LA051Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Kahiltna Glac., AKA downdraft and the pilot's inadequate remedial action.NTSB ANC89LA112Accident · No injuriesLimited investigationFinal reportCessna 185F · Dillingham, AKImproper planning/decision by the pilot & a strong downdraft.NTSB SEA89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Skagway, AKThe failure of the pilot to use proper inflight planning to identify wind conditions (downdrafts) during the flight. As a result, the pilot was unable to maintain altitude and the airplane collided with mountainous terrain.NTSB ANC89LA085Accident · No injuriesLimited investigationFinal reportCessna 180-J · Glennallen, AKPilot used poor judgement and planning for his takeoff.NTSB ANC89FA049Accident · Minor injuriesField investigationFinal reportCessna A-185-F · Puntilla Lake, AKThe pilot's failure to obtain an adequate airspeed, the turn to reverse course maneuver performed at the reduced airspeed and poor preflight planning. Contributing to the accident were the mountainous terrain and the downdraft conditions.NTSB ANC87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · High Lake, AKThe pilot and his passenger were on a fishing/sight-seeing flight when they encountered winds estimated at 35 knots blowing over a mountain ridge. The pilot attempted to fly over the ridge but turned away after experiencing a strong down draft. A second…NTSB ANC86LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Chugiak, AKWhile flying in the mountains at about 5000 feet MSL (200 feet AGL), the airplane encountered a downdraft, causing it to crash on a glacier. Pilot estimated the winds to be about 10 knots.NTSB ANC85LA039Accident · No injuriesLimited investigationFinal reportCessna C-207 · Nome, AKPlt obtained a special VFR to land at Nome arpt. Plt saw apch lights and made a left circle to line up with rwy. Plt stated, ceiling was 300 ft AGL, low visibility and freezing drizzle was present. Aprx 3/8 inch of ice was on airframe and windshield. Plt…