NTSB investigations, WA
14 cases where NTSB found Operating environment.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2017 | 2 |
| 2023 | 1 |
| 2025 | 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\", '0301'))
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", '0301')) 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 DCA25LA117Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-832 · Seattle, WAThe Japan Airlines flight crew’s failure to maintain adequate clearance from the parked Delta Air Lines aircraft while taxiing in congested ramp conditions.NTSB WPR23LA293Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Port Angeles, WAThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel starvation.NTSB DCA18IA081Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 402 · Pullman, WAthe flight crew's misidentification of the taxiway as the landing runway due to the failure of the runway lighting that caused only the taxiway lights to be illuminated.NTSB WPR17LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-260 · Mukilteo, WAThe improper maintenance of the carburetor, which resulted in a stuck float and a partial loss of engine power during takeoff.NTSB WPR11CA022Accident · Minor injuriesData collectionFinal reportRotherwick Glasair III · Colville, WAThe pilot's misjudged approach and failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB WPR10FA384Accident · Minor injuriesField investigationFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to attain an adequate climb airspeed due to his use of flaps for takeoff, and his selection of a runway, which resulted in an uphill, and possibly downwind, takeoff and subsequent collision with a known obstacle. Contributing to the…NTSB WPR09CA416Accident · No injuriesData collectionFinal reportMorgan James E Morgan RV6 · Everett, WAThe pilot’s failure to maintain clearance from objects during taxi. Contributing to the accident was the inadequate marking of the taxiway and obstacles.NTSB WPR09CA084Accident · No injuriesData collectionFinal reportCessna U206E · Crane Island, San Juan Is., WAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.NTSB LAX08CA234Accident · No injuriesData collectionFinal reportCessna 172M · Leavenworth, WAThe pilot's inadequate preflight planning and failure to attain a sufficient airspeed to continue the takeoff. A contributing factor was the high density altitude and short runway.NTSB LAX08CA225Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's misjudged altitude and distance, which resulted in the airplane's failure to attain the proper touchdown point and a landing overrun. Contributing to the accident were trees and the short runway.NTSB LAX08CA216Accident · No injuriesData collectionFinal reportCessna 172M · Skykomish, WAThe pilot's inadequate in-flight planning/decision and failure to execute a go-around when the airplane floated during the flare. Contributing to the accident was the short and wet turf runway surface, which reduced braking action.NTSB LAX08CA176Accident · No injuriesData collectionFinal reportClarke Colin Glastar · Wenatchee, WAThe pilot's failure to initiate a timely go-around after the first bounce.NTSB LAX08CA106Accident · No injuriesData collectionFinal reportMaule M-5-235C · Monroe, WAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing rollout.NTSB LAX08CA082Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilot's inadequate compensation for the wind conditions, failure to attain and maintain an adequate airspeed that resulted in a stall mush, and, the subsequent failure to maintain terrain and obstacle clearance during the takeoff initial climb.…