NTSB investigations: Hughes 269B, WA
16 cases on aircraft the registry lists as Hughes 269B. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 4 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 3 |
| 1980 | 1 |
| 1982 | 1 |
| 2000 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470502'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4470502'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA00LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Burlington, WAMintenance personnel not following the mandatory service bulletin procedure of not exceeding 0.0005 inch paint thickness on the cylinder flange. Factors were the fatigue separation of multiple cylinder hold down bolts resulting in looseness of the cylinder;…NTSB SEA82DA090Accident · Minor injuriesFinal reportHughes 269B · Mt St Helens, WAThe pilot intended to proceed to Mt St Helens to land near spirit lake. The winds in the vicinity of the desired landing point were too strong for a safe landing. Therefore, an alternate spot was selected below the ridge line and presumably sheltered from the…NTSB SEA81DYP04Accident · No injuriesClosedHughes 269B · Ephrata, WANTSB SEA78DYE29Accident · Minor injuriesClosedHughes 269B · Snoqualamie, WANTSB SEA78DYE17Accident · No injuriesClosedHughes 269B · Puyallup, WANTSB SEA78DYE07Accident · No injuriesClosedHughes 269B · Graham, WANTSB SEA76FYE25Accident · No injuriesClosedHughes 269B · Renton, WANTSB SEA74FYE43Accident · Serious injuriesClosedHughes 269B · Seattle, WANTSB SEA74DYE10Accident · No injuriesClosedHughes 269B · Puyallup, WANTSB SEA72DYG03Accident · No injuriesClosedHughes 269B · Pullman, WANTSB SEA71FWD01Accident · No injuriesClosedHughes 269B · Bellingham, WANTSB SEA70DWD14Accident · No injuriesClosedHughes 269B · Hamilton, WANTSB SEA70FWG06Accident · No injuriesClosedHughes 269B · Albion, WANTSB SEA70DWD03Accident · No injuriesClosedHughes 269B · Seattle, WANTSB SEA70D0053Accident · No injuriesClosedHughes 269B · Castle Mt, WANTSB SEA68A0059Accident · No injuriesClosedHughes 269B · Walla Walla, WA