NTSB investigations, WA
6 cases where NTSB found Management.
Cases per year
| 2008 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2022 | 1 |
| 2024 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0402'))
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", '0402')) 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 WPR24LA319Accident · No injuriesClass 3 · LimitedFinal reportBell 206L · Fern Prairie, WAAn aeroelastic interaction between the helicopter’s main rotor blades and nodal beam system, which resulted in oscillations that exceeded the design limits of the tailboom. Contributing to the accident was the failure of the main rotor blade manufacturer to…NTSB DCA22MA193Accident · 10 fatalClass 1 · MajorFinal reportDehavilland DHC-3 · Freeland, WAThe in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…NTSB GAA17CA072Accident · No injuriesData collectionFinal reportPiper PA 28R · Payallup, WAThe airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing.NTSB WPR14LA308Accident · Serious injuriesLimited investigationFinal reportMdhi 369D · Oso, WAThe pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…NTSB WPR13TA081Accident · No injuriesFinal reportBell Helicopter Textron Canada 407 · Renton, WAThe pilot's failure to maintain helicopter control during takeoff from an unstable landing platform. Contributing to the accident was the operator's inadequate chocking procedures for the wheeled landing platform, which included chocking only two of the…NTSB WPR09IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-890 · Seattle, WAThe failure of the deicing crew to follow company procedures by not receiving confirmation from the flight crew before beginning to deice the airplane.