NTSB investigations, 2011, AK

6 cases where the sequence of events included Landing gear collapse.

Cases per year

20082026
NTSB investigations, 2011, AK per year, 2008–2026: 87 cases
20088
20099
20105
20116
20123
20135
20141
20151
20168
20178
20186
20196
20203
20214
20224
20244
20252
20264

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\") = 2011
    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\" = '094' 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 ANC11CA081Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Valdez, AKThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot.Aug 17, 2011 · N91134 · Substantial damageNTSB ANC11TA079Accident · No injuriesFinal reportDehavilland DHC-2 MK. I(L20A) · Northway, AKThe pilot's failure to identify unsuitable terrain for landing and subsequent contact with a dirt mound, resulting in the separation of the tailwheel from the airframe.Aug 3, 2011 · N723DR · Substantial damageNTSB ANC11CA072Accident · No injuriesData collectionFinal reportAeronca 7AC · McCarthy, AKThe separation of the right main landing gear oleo strut assembly, resulting in the collapse of the main landing gear during the landing roll.Jul 24, 2011 · N85194 · Substantial damageNTSB ANC11LA061Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Anchorage, AKThe pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…Jul 9, 2011 · N9129M · Substantial damageNTSB ANC11CA049Accident · No injuriesData collectionFinal reportChampion 7HC · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear, and a nose over.Jun 16, 2011 · N8976R · Substantial damageNTSB ANC11CA018Accident · No injuriesData collectionFinal reportCessna A185F · Aniak, AKThe inadvertent contact with a rut in the snow while taxiing, resulting in the collapse of the right main landing gear.Mar 19, 2011 · N5182H · Substantial damage