NTSB investigations, WA
8 cases where NTSB found Main landing gear.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2017 | 1 |
| 2021 | 1 |
| 2023 | 1 |
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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01023210'))
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 c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01023210')) 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 WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.NTSB WPR22LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Puyallup, WAAn overstress fracture of the left main landing gear pivot assembly, which resulted in the failure of the left main landing gear to fully extend and lock into place.NTSB WPR18LA022Accident · No injuriesLimited investigationFinal reportCessna P210N · Mount Vernon, WAThe failure of the right main landing gear (MLG) down-lock mechanism due to an out-of-tolerance down-lock hook, which resulted in the collapse of the right MLG during the landing roll.NTSB WPR12CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Royal City, WAThe pilot’s failure to maintain adequate clearance from an object during an aerial application, which resulted in damage to the landing gear and led to the airplane ground looping during the subsequent landing.NTSB WPR11FA103Accident · 1 fatalField investigationFinal reportCessna T206H · Stanwood, WAThe pilot did not confirm retraction of the landing gear before landing on water as a result of distraction. Contributing to the accident was the pilot coping with the death of a close family member in the days before the accident, which resulted in a…NTSB WPR10LA171Accident · No injuriesLimited investigationFinal reportCarr RV-4 · Arlington, WAThe failure of both main landing gear's drag link bolts in overstress and the subsequent collapse of the landing gear during landing rollout.NTSB WPR10LA090Accident · No injuriesLimited investigationFinal reportCessna 310 · Pasco, WAThe failure of the right main landing gear up-lock.NTSB SEA08LA147Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Tacoma, WAThe collapse of the right main landing gear for undetermined reasons.