NTSB investigations, WA
17 cases where the defining event was Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 3 |
| 2022 | 1 |
| 2026 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '120')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '120') 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 WPR27FA014Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-18-150 · Wauconda, WAOn October 10, 2026, about 2014 Pacific daylight time, a Piper PA-18-150, N927JS, was substantially damaged when it was involved in an accident near Wauconda, Washington. The flight instructor and student pilot were fatally injured. The airplane was operated…NTSB WPR22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lyman, WAThe pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.NTSB WPR18LA151Accident · 1 fatalLimited investigationFinal reportCessna 150M · Bainbridge Island, WAThe pilot's failure to maintain clearance from the water and his distraction by using the tablet for navigation, which resulted in his failure to detect that the airplane had entered a descent.NTSB WPR18FA104Accident · 1 fatalField investigationFinal reportPiper PA 18-150 · La Center, WAThe pilot's failure to maintain clearance from trees while maneuvering at a low altitude.NTSB ANC18FA024Accident · 1 fatalField investigationFinal reportMooney M20 · Chuckanut, WAThe pilot's failure to maintain clearance from terrain during a visual approach in dark night visual meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…NTSB WPR17LA084Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Brinnon, WAThe flight instructor's decision to fly into a valley without ensuring adequate clearance to avoid the rising terrain.NTSB GAA17CA072Accident · No injuriesData collectionFinal reportPiper PA 28R · Payallup, WAThe airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing.NTSB WPR15FA215Accident · 2 fatalField investigationFinal reportPiper PA 22-160 · Twin Sisters Mtn, WAThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB WPR15FA212Accident · 2 fatalField investigationFinal reportBeech A35 · Mazama, WAThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance from mountainous terrain.NTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.NTSB WPR12CA026Accident · Serious injuriesData collectionFinal reportAyres S2R-600 · Kahlotus, WAThe pilot’s failure to maintain clearance from the ground due to his distraction with programming a global positioning system receiver.NTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.NTSB WPR11LA306Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA-5 · Yacoit, WAThe pilot’s failure to maintain clearance from terrain.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR10FA223Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D1 · Skokomish, WAThe pilot's failure to maintain clearance from trees while flying over hilly, forested terrain.NTSB LAX08FA246Accident · 3 fatalField investigationFinal reportCessna 172N · McMurray, WAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.