NTSB investigations, WA
8 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1983 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 2002 | 1 |
Where
Open the mapLatest 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 191)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 191) 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 SEA02LA084Accident · No injuriesLimited investigationFinal reportPaxhia Murphy SR3500 · Seattle, WAThe failure of the left main gear leg AN-5 attach fitting bolt.NTSB SEA93LA159Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau BU-131 · Arlington, WAThe pilot's improper use of the brakes. The gusty, crosswind was a factor.NTSB SEA93LA148Accident · No injuriesLimited investigationFinal reportCessna 414A · Seattle, WAThe disengagement of the gear down-lock mechanism due to corrosion and the pilot's intentional operation of the aircraft with known deficiencies in equipment.NTSB SEA93LA022Accident · No injuriesLimited investigationFinal reportCessna 210N · Spokane, WAThe pilot's premature retraction of the gear. Factors include a wet and icy runway.NTSB SEA89FA155Accident · No injuriesField investigationFinal reportCessna 402B · Seattle, WAThe landing gear down lock mechanism failure.NTSB SEA89LA089Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Copalis Beach, WAThe pilot's failure to perform the necessary preflight planning and preparation which resulted in the selection of unsuitable terrain for landing. Contributing to the accident was the soft sand bar.NTSB SEA87LA103Accident · No injuriesLimited investigationFinal reportAyres S2R · Walla Walla, WADuring takeoff run the right main gear collapsed. The right wing dropped and the aircraft spun to the right. The plt discovered that the right main gear failed at the weld. The pilot, who is also an a & p mechanic, stated that this was an original weld from…NTSB SEA83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Burlington, WAThe acft groundlooped after the main landing gear collapsed during landing. Investigation revealed that the main landinggear tubing failed after being weakened by corrosion inside the tube.