NTSB investigations, WA

6 cases where NTSB found Gear extension and retract sys.

Cases per year

20082026
NTSB investigations, WA per year, 2008–2026: 6 cases
20081
20091
20121
20141
20161
20201

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\", '01023230'))
  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 WPR20CA243Accident · Minor injuriesClass 4 · Data collectionFinal reportQuest Kodiac 100 · Hunts Point, WAThe pilot’s failure to retract the landing gear during a water landing, which resulted in a nose over. Contributing to the accident was the pilot’s failure to properly use a prelanding checklist.Jul 28, 2020 · N856TC · Substantial damageNTSB WPR16LA187Accident · No injuriesLimited investigationFinal reportJurcan Seawind 3000 · Renton, WAThe failure of the landing gear system to either fully retract or extend due to a cracked hydraulic fitting flare, which resulted in the loss of hydraulic pressure.Sep 18, 2016 · N57TJ · Substantial damageNTSB WPR14CA287Accident · No injuriesData collectionFinal reportMooney M20TN · Yakima, WAThe pilot's failure to configure the landing gear for landing.Jun 28, 2014 · N633GL · Substantial damageNTSB WPR12CA393Accident · No injuriesData collectionFinal reportBeech 95-55 · Spanoway, WAThe pilot’s failure to lower the landing gear prior to landing.Sep 4, 2012 · N4QC · Substantial damageNTSB WPR09CA294Accident · No injuriesData collectionFinal reportDornier ALPHA-JET · Arlington, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident were the distractions created by the pilot incorrectly setting a radio frequency and by his fixation on an airplane that was on the runway during his approach.Jun 17, 2009 · N707XA · Substantial damageNTSB LAX08FA144Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 MK I · Stehekin, WAThe pilot's failure to retract the landing gear wheels prior to performing a water landing. Contributing to the accident were the pilot's disabling of the landing gear warning/advisory system and possible fatigue due to his work schedule.May 17, 2008 · N9558Q · Substantial damage