NTSB investigations, WA
8 cases where the first occurrence was “Propeller/rotor contact to person”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1990 | 2 |
| 1994 | 2 |
| 2007 | 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\" = 370)
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" = 370) 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 LAX07LA270Accident · 1 fatalLimited investigationFinal reportHughes 369D · Ellensburg, WAThe passenger's inadequate visual lookout and failure to maintain clearance from the rotating main rotor disc while the helicopter was hovering. An uphill terrain condition was a factorNTSB SEA94LA159Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Friday Harbor, WAThe pilot's accidental extension of his hand into the arc of the turning propeller. Factors include high winds during the docking process.NTSB SEA94LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Auburn, WAClearance was not maintained by an other person. A factor to the accident was: procedures/directives were inadequate.NTSB SEA90FA115Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Glacier, WAPassenger did not follow the procedures associated with the operations in the vicinity of the helicopter.NTSB SEA90LA067Accident · Serious injuriesLimited investigationFinal reportBecker Bensen B8M · Burlington, WAThe pilot's failure to maintain clearance from the propeller.NTSB SEA86LA176Accident · 1 fatalLimited investigationFinal reportBell 47G-3B1 · Burbank, WAThe helicopter had landed for reloading and was stationary with rotors idling. A ground loader person approached the helicopter over a small sandy knoll and was struck by the main rotor, sustaining fatal injury.NTSB SEA83LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150-J · Connell, WAThe plt stated he was preparing to shut down the engine when the passenger deplaned & inadvertently walked into the prop.NTSB SEA82DA165Accident · 1 fatalFinal reportPiper PA-28-180C · Renton, WAPilot parked aircraft with engine running to discharge passenger. Passenger jumped off right wing into prop.