NTSB investigations, 2016, AK
8 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 9 |
| 2010 | 5 |
| 2011 | 6 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 8 |
| 2017 | 8 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 4 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 4 |
Where
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\") = 2016
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.
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") = 2016 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
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 ANC17LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · McGrath, AKThe failure of the nose landing gear to extend and lock due to the failure of the alternator and reduced battery power due to the cold ambient temperature, which prohibited the electrically-driven hydraulic pump from supplying adequate hydraulic pressure to…NTSB ANC17LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA32R · Bethel, AKA total loss of engine power due to oil starvation, which resulted from an oil cooler leak at a fractured brazed seam.NTSB GAA17CA057Accident · No injuriesData collectionFinal reportPiper PA18 · Mouth of The Big Susitna River, AKThe pilot’s decision to take off with a gusting quartering tailwind and his subsequent loss of airplane control.NTSB ANC16LA067Accident · No injuriesLimited investigationFinal reportHelio H 295 · Fairbanks, AKExcessive side loads imposed on the tailwheel A-frame during the takeoff roll, which resulted in a separation of the tailwheel and the subsequent loss of directional control.NTSB GAA16CA434Accident · No injuriesData collectionFinal reportCessna 182 · Anchorage, AKThe pilot's failure to maintain a controlled landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's inattention and distraction.NTSB ANC16CA055Accident · No injuriesData collectionFinal reportKirbybilt Xcalibur · Valdez, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the airstrip, a landing gear collapse, and subsequent substantial damage to the fuselage.NTSB GAA16CA264Accident · No injuriesData collectionFinal reportPiper PA18 · Seward, AKThe pilot receiving instruction's failure to maintain proper airspeed and descent rate, and the flight instructor's delayed remedial action during the landing flare, which resulted in a hard landing and landing gear collapse.NTSB GAA16CA207Accident · No injuriesData collectionFinal reportCessna U206 · Port Alsworth, AKThe pilot's failure to maintain an appropriate descent rate during the landing flare in gusty crosswind conditions, which resulted in a hard landing, aerodynamic stall, impact with terrain, nose gear collapse, and nose over.