Skip to content

NTSB investigations, WA

19 cases where the first occurrence was “Gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19882026

Where

Latest cases

Query with SQL

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" = 190) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 190)
  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" = 190)
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 SEA07LA026Accident · No injuriesLimited investigationFinal reportCessna 310B · Lake Stevens, WAThe collapse of the main landing gear for an undetermined reason while taxiing from landing.Dec 6, 2006 · N6640B · Substantial damage NTSB SEA06CA030Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Auburn, WAThe collapse of the left main landing gear after landing for undetermined reasons.Nov 27, 2005 · N7692B · Substantial damage NTSB SEA06LA003Accident · No injuriesLimited investigationFinal reportBeech B-60 · Arlington, WAMain landing gear collapse during the landing rollout for undetermined reasons.Oct 1, 2005 · N924GF · Substantial damage NTSB SEA05LA065Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Graham, WAThe failure of the right main gear due to separation of the attachment hardware.Mar 13, 2005 · N5509M · Substantial damage NTSB SEA04LA017Accident · No injuriesLimited investigationFinal reportCessna 150C · Toledo, WAFailure of the main landing gear attachment during the landing roll. An inadequate maintenance modification was a factor.Nov 10, 2003 · N7934Z · Substantial damage NTSB SEA03LA027Accident · No injuriesLimited investigationFinal reportClassic Fighter Industries ME-262 Reproduction · Everett, WAFailure of the left main gear hydraulic actuator locking slide during landing. Factors include an embankment adjacent to the landing runway.Jan 17, 2003 · N262AZ · Substantial damage NTSB SEA02LA136Accident · No injuriesLimited investigationFinal reportStearman C3-R · Arlington, WAThe pilot's inadequate remedial action when responding to the swerve/veer of the tailwheel equipped aircraft, leading to a failure to maintain directional control during the landing roll. Factors include the pilot’s lack of experience in the make and model…Jul 23, 2002 · N656K · Substantial damage NTSB SEA02LA018Accident · No injuriesLimited investigationFinal reportLuscombe 8C · Olympia, WADirectional control not maintained during the landing roll. Factors include main gear overload and standing water on the runway.Nov 26, 2001 · N1577K · Substantial damage NTSB SEA02LA015Accident · No injuriesLimited investigationFinal reportCessna 402B · Pasco, WAthe pilot's failure to keep the aircraft from touching down short of the displaced threshold, and his failure to maintain directional control after the aircraft's left main gear tire deflated as a result of impacting the lip at the beginning of the subject…Nov 15, 2001 · N910WT · Substantial damage NTSB SEA00LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Snohomish, WAThe right main landing gear failed for undetermined reasons.Jul 15, 2000 · N6473A · Substantial damage NTSB SEA00LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Townsend, WAThe pilot's failure to adequately compensate for changing wind conditions during the landing roll in a tailwheel-equipped aircraft. Factors include a variable, shifting wind that changed from a quartering headwind to a quartering tailwind just prior to the…Mar 11, 2000 · N4994A · Substantial damage NTSB SEA00LA024Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Goldendale, WAThe pilot's failure to maintain directional control. A factor was a rock just off the edge of the runway surface.Nov 28, 1999 · N7243V · Substantial damage NTSB SEA95LA140Accident · No injuriesLimited investigationFinal reportCessna 182R · Copalis Beach, WAThe pilot's selection of an unsuitable landing area.Jul 5, 1995 · N4836E · Substantial damage NTSB SEA95LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe pilot misjudging the flare. A factor to the accident was the tailwind.Jan 22, 1995 · N6605P · Substantial damage NTSB SEA93LA212Accident · No injuriesLimited investigationFinal reportCessna 182RG · Vancouver, WAThe pilot's inadvertent landing gear retraction.Sep 23, 1993 · N736ZV · Substantial damage NTSB SEA89LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vashon, WAThe pilot's inadequate preflight planning/preparation. Factors related to the accident were: unfavorable wind conditions, high obstructions (trees), and soft terrain where the aircraft touched down during the aborted takeoff.Jul 24, 1989 · N8402C · Substantial damage NTSB SEA89LA072Accident · No injuriesLimited investigationFinal reportBeech A55 · Arlington, WAA premature/improper retraction of the landing gear by the second pilot (aircraft owner), who was occupying the right front seat.Apr 20, 1989 · N6866Q · Destroyed NTSB SEA89LA017Accident · No injuriesLimited investigationFinal reportCessna 210K · Anacortes, WADuring a gusty crosswind landing, touchdown was accomplished about 500 feet past the runway threshold. The aircraft bounced at touchdown. The pilot stated that he thought he had a flat main tire. The pilot momentarily added power after touchdown to go-around…Nov 7, 1988 · N9495M · Substantial damage NTSB SEA88LA085Accident · No injuriesLimited investigationFinal reportBeech 35 · Pasco, WADuring lndg roll, NLG and rmlg collapsed. During tow in from rwy, lndg gear cb was noted to be tripped. Cause of cb activation unk.Apr 28, 1988 · N2839V · Substantial damage