NTSB investigations, WA
4 cases where the first occurrence was “Rotor failure/malfunction”.
Cases per year
| 1998 | 2 |
|---|---|
| 2004 | 2 |
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\" = 132)
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" = 132) 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 SEA05FA019Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Arlington, WAThe divergence of the main rotor from its normal plane of rotation for an undetermined reason, resulting in rotor contact with the aircraft's left windscreen. The failure of the door pins to be installed was a factor.NTSB SEA04LA043Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Liberty, WAThe failure of the tail rotor slider lugs due to fatigue while the helicopter was maneuvering.NTSB SEA98LA160Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Oso, WAThe separation of the 90 degree gearbox and tail rotor assembly for undetermined reasons followed by the inability of the pilot-in-command to maintain control of the rotorcraft.NTSB SEA98LA124Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Eltopia, WAFatigue of the control rotor blade spar and failure of the maintenance inspector to follow the procedures set forth in the airworthiness directive.