NTSB investigations, WA
19 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2004 | 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\" = 160)
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" = 160) 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 SEA04LA055Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Cusick, WAThe pilot's failure to adequately compensate for crosswind conditions and his failure to maintain proper alignment in the direction of landing during the touchdown portion of a water landing on a river. Factors include crosswind conditions.NTSB SEA01LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Friday Harbor, WAThe pilot's failure to maintain directional control during landing.NTSB SEA01LA022Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Mercer Island, WAThe pilot's failure to maintain aircraft control during a left turning step taxi to takeoff, resulting in a wing contacting the water during the step turn.NTSB SEA00LA083Accident · No injuriesLimited investigationFinal reportde Havilland U-6A · Kenmore, WAThe pilot's failure to maintain control of the aircraft during the landing roll. Contributing factors were the power wave created by the nearby yacht, the rough water conditions, and the pilot's loss of visual contact with the wave during the rollout.NTSB SEA99IA148Incident · No injuriesIncident investigationFinal reportEmbraer ERJ-135 · Moses Lake, WAMinimum aircraft control exceeded during takeoff test flight, which resulted in dragging a wing on the runway surface.NTSB SEA98LA174Accident · No injuriesLimited investigationFinal reportCessna 180J · Oroville, WAThe pilot-in-command's failure to establish and maintain proper alignment.NTSB SEA97LA102Accident · No injuriesLimited investigationFinal reportBoeing E75 · Spokane, WAThe pilot-in-command's inadequate application of crosswind controls during landing rollout. Factors were gusty crosswinds.NTSB SEA94LA010Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Marysville, WAThe student pilot's failure to maintain altitude.NTSB SEA94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orting, WAThe pilot in command's failure to maintain aircraft control.NTSB SEA93LA108Accident · No injuriesLimited investigationFinal reportGrove GR-2 · Buckley, WAThe pilot's premature liftoff. The pilot's failure to maintain directional control and the high vegetation beside the runway were factors.NTSB SEA92LA199Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bucoda, WAThe failure of the pilot to maintain proper alignment while landing on water, resulting in a swerve during deceleration.NTSB SEA92FA160Accident · 1 fatalField investigationFinal reportCessna 172P · Kingston, WAThe pilot's attempt to conduct VFR flight in instrument meteorological conditions. Factors include fog and low ceilings.NTSB SEA91LA251Accident · No injuriesLimited investigationFinal reportBell BH-47-G3B1 · Rock Island, WAThe failure of the pilot to use the proper touchdown point while landing on a trailer.NTSB SEA88LA133Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAOn the first leg of the scheduled float plane flight the plt had landed on lake union to embark addl pax. As the acft decelerated 'off the step,' a power boat converged on acft path. Plt made rudder input to avoid collision and wingtip contacted water.NTSB SEA85LA183Accident · No injuriesLimited investigationFinal reportCessna T-188C · Pasco, WAThe pilot elected to depart an 1800 foot gravel airstrip with a 90 degrdd f temperature. The density altitude was about 3100 feet. The aircraft was heavily loaded, approaching gross weight. The pilot made the decision during the last 1/3 of the runway to…NTSB SEA84LA049Accident · No injuriesLimited investigationFinal reportCessna A185F · Winslow, WADuring a water landing the acft was in turbulent crosswind conditions when the left float and wing dug into the water. The acft cartwheeled and came to rest with the right wingtip touching the bottom of the bay. The plt stated it would have been more prudent…NTSB SEA84IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Seattle, WAThe capt stated that upon visual contact with the rwy, the acft was displaced slightly to the lt & he corrected toward centerline with rt rudder. Wing tip contact was neither heard not felt in the cockpit. There were several concurrent reports of arriving…NTSB SEA83LA109Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-29D · Ephrata, WAThe plt reported that he was forced to land after thermal activity subsided and he was unable to find an area of lift. He elected to land in the last cultivated field before reaching an area of sage brush. Reportedly, a dust devil was encountered during…NTSB SEA82DA133Accident · No injuriesFinal reportCessna A185F · Friday Harbor, WAThe plt reported that while he was making a water landing, everything was normal until after touchdown. As the acft decelerated "off the step," the right float rose off the water as if it road over a swell or encountered an object. When the float contacted…