NTSB investigations, 2012, AK

12 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2012, AK per year, 2008–2026: 229 cases
200819
200919
201019
201117
201212
201314
201412
201513
201611
201711
20188
201914
20209
202111
20229
20236
202412
202512
20261

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\" = '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.

NTSB ANC13FA017Accident · Serious injuriesField investigationFinal reportEurocopter AS350 B3 · Beluga, AKThe pilot's failure to stabilize the external load, which led to the synthetic long-line separating about midspan and the remaining line becoming entangled in the tail rotor gearbox output shaft and resulted in the separation of the tail rotor gearbox and…Dec 15, 2012 · C-GYPH · Substantial damageNTSB ANC13CA002Accident · No injuriesData collectionFinal reportCessna U206F · Buckland, AKThe pilot's loss of airplane control during final approach in gusty wind conditions.Oct 9, 2012 · N9575G · 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 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 ANC12LA096Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F21 · Willow, AKThe pilot’s failure to maintain control of the airplane after a loss of engine power during takeoff due to carburetor ice.Sep 3, 2012 · N2005E · Substantial damageNTSB ANC12FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Fairbanks, AKThe noninstrument-rated pilot's decision to continue visual flight into instrument meteorological conditions likely leading to spatial disorientation, which resulted in a loss of airplane control and in-flight structural failure.Jul 19, 2012 · N432LT · DestroyedNTSB ANC12LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kenai, AKThe in-flight separation of a propeller tip due to an unauthorized and undocumented propeller repair.Jul 14, 2012 · N7154Z · Substantial damageNTSB ANC12CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tynoek, AKThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.Jul 11, 2012 · N4272Z · Substantial damageNTSB ANC12CA043Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot’s failure to maintain directional control while landing in a gusting crosswind.May 29, 2012 · N3772Z · Substantial damageNTSB ANC12CA034Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe student pilot did not maintain sufficient airspeed during a steep turn after takeoff, which resulted in an aerodynamic stall.Apr 30, 2012 · N8976D · Substantial damageNTSB ANC12LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe student pilot did not control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to use the pre-takeoff checklist.Apr 22, 2012 · N7911F · Substantial damageNTSB ANC12LA017Accident · No injuriesLimited investigationFinal reportPzl-Swidnik SW-4 · Fairbanks, AKA loss of control during a simulated hydraulic emergency, which resulted in an inadvertent dynamic rollover from the which the pilot could not recover.Jan 15, 2012 · SP-SSW · Substantial damage