NTSB investigations, 2012, AK

9 cases where the sequence of events included Abnormal runway contact.

Cases per year

20082026
NTSB investigations, 2012, AK per year, 2008–2026: 86 cases
20086
20096
20104
20115
20129
20135
20145
20156
201610
20171
20184
20196
20204
20214
20223
20243
20253
20262

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 year(c.\"eventDate\") = 2012
    AND c.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '090' 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.

NTSB ANC13CA003Accident · No injuriesData collectionFinal reportCessna 172D · Buckland, AKThe pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.Oct 8, 2012 · N8808 · Substantial damageNTSB ANC12CA111Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Anchorage, AKThe flight instructor's inadequate supervision of the student pilot during a hovering autorotation, which resulted in a dynamic rollover.Sep 26, 2012 · N4171J · Substantial damageNTSB ANC12CA089Accident · No injuriesData collectionFinal reportMaule M-5-210C · Coldfoot, AKThe pilot's delayed decision to turn around while flying through a narrow mountain pass, which resulted in a forced landing and impact with terrain.Aug 18, 2012 · N319X · Substantial damageNTSB ANC12FA073Accident · 1 fatalField investigationFinal reportCessna U206G · Homer, AKThe pilot’s improper evaluation of the weather conditions and his subsequent downwind water landing in gusting wind conditions, which resulted in a nose-over.Jul 11, 2012 · N206VR · Substantial damageNTSB ANC12CA081Accident · No injuriesData collectionFinal reportPiper J3F-65 · Beluga, AKThe pilot's delayed decision to go around, which resulted in a hard landing.Jun 21, 2012 · N77EC · Substantial damageNTSB ANC12CA049Accident · No injuriesData collectionFinal reportCessna U206G · Homer, AKThe pilot's selection of unsuitable terrain for landing.Jun 7, 2012 · N9049G · Substantial damageNTSB ANC12CA040Accident · No injuriesData collectionFinal reportCessna T210L · Whittier, AKThe pilot’s failure use the prelanding checklist and to extend the landing gear before landing.May 20, 2012 · N732BE · Substantial damageNTSB ANC12CA036Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series 3 · Chefornak, AKThe pilot's misidentification of a nearby snow-covered road as the snow-covered runway in flat light conditions.May 3, 2012 · N1906 · Substantial damageNTSB ANC12CA033Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 Ecureuil · Valdez, AKThe pilot's selection of an unsuitable landing surface, which resulted in the tail rotor contacting terrain.Apr 18, 2012 · N191EH · Substantial damage