NTSB investigations, WA
12 cases where NTSB found Rough terrain.
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2025 | 2 |
Where
Latest 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\", '03021015'))
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", '03021015')) 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 WPR25LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 185A · Ilwaco, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR25LA184Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180E · Rockford, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB WPR22LA247Accident · Serious injuriesClass 3 · LimitedFinal reportBeech H35 · LaCrosse, WAThe pilot’s failure to monitor and manage the fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB GAA18CA296Accident · No injuriesData collectionFinal reportCessna 182 · Prescott, WAThe pilot’s taxiing too fast on rough terrain, which resulted in a loss of directional control.NTSB WPR15LA101Accident · Minor injuriesLimited investigationFinal reportVans RV7 - Undesignat · Belfair, WAA total loss of engine power during cruise flight due to the fatigue failure of the engine crankshaft. Contributing to the accident was the unapproved repair and improper inspection of the engine crankshaft.NTSB WPR14CA004Accident · Minor injuriesData collectionFinal reportVenables Zenith CH701 · Snohomish, WAA jammed rudder control while maneuvering in the pattern for reasons that could not be determined. No follow-up examination was conducted due to a lapse in agency funding and subsequent government shutdown.NTSB WPR12CA159Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Westport, WAThe pilot’s inadequate crosswind compensation, which resulted in a loss of directional control during the landing roll.NTSB WPR10CA434Accident · Minor injuriesData collectionFinal reportPiper PA-15 · Duvall, WAAn in-flight collision with a bird while maneuvering.NTSB WPR10LA412Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Manson, WAA loss of engine power due to fuel exhaustion, and the pilot’s failure to ensure that a sufficient quantity of fuel was on board to complete the flight.NTSB WPR10LA122Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAA partial loss of engine power during takeoff due to a bird's nest being sucked into the induction air ducting.NTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.NTSB WPR09LA371Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Chelan, WAFailure of a seal in the hydraulic system resulting in a loss of hydraulic pressure while maneuvering at low altitude.