NTSB investigations, 2012, AK

10 cases where the sequence of events included Miscellaneous/other.

Cases per year

20082026
NTSB investigations, 2012, AK per year, 2008–2026: 109 cases
20087
20093
20107
20111
201210
20133
20144
20151
201613
20179
201815
201916
20209
20214
20233
20242
20252

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\" = '900' 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 ANC13FA001Accident · 1 fatalField investigationFinal reportGrumman G-44 · Aleknagik, AKThe pilot's decision to make multiple low passes over the glassy surface water, which resulted in an impact with the surface of the lake.Oct 8, 2012 · N139F · Substantial damageNTSB 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 ANC12LA106Accident · No injuriesLimited investigationFinal reportCessna A185F · Denali Park, AKThe pilot’s failure to maintain clearance from an electric transmission line during the approach to land because he was distracted by the airplane’s broken and deflected landing ski. Contributing to the accident was the in-flight failure of the right ski…Sep 13, 2012 · N4786Q · Substantial damageNTSB ANC12CA101Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Ekwok, AKThe pilot's diverted attention during the initial climb, which resulted in a collision with trees.Sep 5, 2012 · N4127Z · Substantial damageNTSB ANC12CA100Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 · Talkeetna, AKThe entanglement of a plastic tarp in the helicopter’s tail rotor after becoming dislodged from its securement.Sep 1, 2012 · N178CH · Substantial damageNTSB ANC12CA092Accident · Minor injuriesData collectionFinal reportDehavilland Beaver U-6 · Kenai, AKThe pilot’s failure to maintain adequate ground clearance during his landing approach, which resulted in a collision with terrain.Aug 25, 2012 · N314HA · Substantial damageNTSB ANC12CA086Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe passenger's inadvertent application of the brake pedals during landing, which resulted in a noseover.Aug 13, 2012 · N37WP · Substantial damageNTSB ANC12CA070Accident · No injuriesData collectionFinal reportDehavilland DHC-2 · Cantwell, AKThe right seat passenger’s inadvertent contact with the emergency fuel shutoff valve, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot's failure to provide a thorough preflight briefing to the…Jul 8, 2012 · N906JS · Substantial damageNTSB ANC12CA072Accident · No injuriesData collectionFinal reportPiper PA-12 · Quinhagak, AKThe pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.Jul 6, 2012 · N7779H · 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 damage