Skip to content

NTSB investigations, WA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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'
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 UNK64X3204Accident · 1 fatalClosedMooney M20 · La Touche, WAAug 3, 1964 · N5294B · Destroyed NTSB UNK64X3176Accident · No injuriesClosedBeechcraft D35 · Lind, WAAug 2, 1964 · N2979F · Substantial damage NTSB UNK64X3038Accident · Minor injuriesClosedAeronca 15AC · Spokane, WAJul 25, 1964 · N1326H · Substantial damage NTSB UNK64X3003Accident · 2 fatalClosedBeech D-35 · Richland, WAJul 24, 1964 · N4558V · Destroyed NTSB UNK64X3000Accident · No injuriesClosedSikorsky R6A · Auburn, WAJul 24, 1964 · N5282N · Substantial damage NTSB UNK64X2994Accident · No injuriesClosedPiper PA18 · Pt Townsend, WAJul 23, 1964 · N1041A · Substantial damage NTSB UNK64X2935Accident · No injuriesClosedBell 47D1 · Toppenish, WAJul 19, 1964 · N1161N · Substantial damage NTSB UNK64X2867Accident · Serious injuriesClosedPiper PA18A · Ferndale, WAJul 16, 1964 · N9872D · Destroyed NTSB UNK64X2768Accident · No injuriesClosedCulver V · Gig Harbor, WAJul 11, 1964 · N44664 · Destroyed NTSB UNK64X2747Accident · No injuriesClosedAeronca 7ACS · Kenmore, WAJul 10, 1964 · N82554 · Substantial damage NTSB UNK64X2719Accident · 1 fatalClosedBell 47G3 · Manson, WAJul 8, 1964 · N8441E · Destroyed NTSB UNK64X2676Accident · Minor injuriesClosedPiper PA25 · Warden, WAJul 6, 1964 · N6100Z · Destroyed NTSB UNK64X2467Accident · No injuriesClosedPiper PA25 · Moses Lake, WAJun 24, 1964 · N6900Z · Substantial damage NTSB UNK64X2361Accident · 1 fatalClosedStinson 10A · Mineral, WAJun 18, 1964 · N34692 · Destroyed NTSB UNK64X2296Accident · No injuriesClosedPiper PA18 · Spokane, WAJun 15, 1964 · N198T · Substantial damage NTSB SEA76AS001Accident · 2 fatalClosedCessna 182A · Mineral, WAJun 15, 1964 · N4029D · Destroyed NTSB UNK64X2272Accident · Serious injuriesClosedBeechcraft 35 · Martha Lake, WAJun 13, 1964 · N80410 · Destroyed NTSB UNK64X2258Accident · No injuriesClosedPiper J3C · Hartline, WAJun 13, 1964 · N6849H · Substantial damage NTSB UNK64X2231Accident · Minor injuriesClosedPiper PA18A · Deep Creek, WAJun 11, 1964 · N7369A · Substantial damage NTSB UNK64X2080Accident · No injuriesClosedCallair A6 · Waterville, WAJun 3, 1964 · N2934G · Destroyed NTSB UNK64X1896Accident · No injuriesClosedPiper PA18 · Tacoma, WAMay 23, 1964 · N7151C · Substantial damage NTSB UNK64X1864Accident · 1 fatalClosedCallair A5 · Winthrop, WAMay 20, 1964 · N9960C · Destroyed NTSB UNK64X1829Accident · No injuriesClosedRepublic RC3 · Everett, WAMay 18, 1964 · N6728K · Substantial damage NTSB UNK64X1816Accident · 4 fatalClosedBeechraft M-23 · Washougal, WAMay 17, 1964 · N2344J · Destroyed NTSB UNK64X1789Accident · No injuriesClosedCessna 140 · Ellensburg, WAMay 16, 1964 · N2432N · Substantial damage NTSB UNK64X1768Accident · No injuriesClosedBrantly B2 · Bryant, WAMay 14, 1964 · N5900X · Substantial damage NTSB UNK64X1702Accident · No injuriesClosedCessna 172 · Pe Ell, WAMay 10, 1964 · N8724B · Substantial damage NTSB UNK64X1611Accident · No injuriesClosedStinson 108 · Chelan, WAMay 4, 1964 · N97626 · Substantial damage NTSB UNK64X1449Accident · No injuriesClosedCessna 195B · Mt Vernon, WAApr 25, 1964 · N2179C · Substantial damage NTSB UNK64X1390Accident · No injuriesClosedAero Comm 520 · Brewster, WAApr 20, 1964 · N4154B · Substantial damage NTSB UNK64X1387Accident · 6 fatalClosedStinson 108-3 · Camas, WAApr 19, 1964 · N6657M · Destroyed NTSB UNK64X1354Accident · No injuriesClosedHiller 12E · Pomeroy, WAApr 17, 1964 · N9785C · Substantial damage NTSB UNK64X1294Accident · 2 fatalClosedFairchild 24C-8E · Wapato, WAApr 12, 1964 · N16843 · Destroyed NTSB UNK64X1288Accident · No injuriesClosedCessna 170B · Seattle, WAApr 12, 1964 · N3218A · Destroyed NTSB UNK64X1247Accident · No injuriesClosedCessna 170 · Spokane, WAApr 10, 1964 · N2929D · Substantial damage NTSB UNK64X1194Accident · No injuriesClosedHughes 269A · Puyallup, WAApr 5, 1964 · N8792F · Substantial damage NTSB UNK64X1148Accident · Minor injuriesClosedBoeing 75 · Colfax, WAApr 3, 1964 · N54950 · Destroyed NTSB UNK64X1146Accident · No injuriesClosedPiper PA18 · Walla Walla, WAApr 3, 1964 · N8191D · Substantial damage NTSB UNK64X1119Accident · No injuriesClosedBell 47G2 · Walla Walla, WAMar 31, 1964 · N10194 · Substantial damage NTSB UNK64X1083Accident · No injuriesClosedBeechcraft 35 · Renton, WAMar 28, 1964 · N519B · Substantial damage NTSB UNK64X1079Accident · No injuriesClosedMooney M20 · Tacoma, WAMar 28, 1964 · N6507B · Substantial damage NTSB UNK64X1046Accident · 1 fatalClosedPiper PA-22 · Cle Elum, WAMar 26, 1964 · N7117D · Destroyed NTSB UNK64X1023Accident · No injuriesClosedPiper PA22 · Bremerton, WAMar 23, 1964 · N5336Z · Substantial damage NTSB UNK64X1019Accident · No injuriesClosedCessna 182 · Anacortes, WAMar 22, 1964 · CFPJ0 · Substantial damage NTSB UNK64X0984Accident · No injuriesClosedPiper PA22 · Fairchild Afb, WAMar 19, 1964 · N5153Z · Substantial damage NTSB UNK64X0982Accident · Minor injuriesClosedPiper PA25 · Walla Walla, WAMar 19, 1964 · N6612Z · Destroyed NTSB UNK64X0979Accident · Serious injuriesClosedBoeing PT17 · Pullman, WAMar 19, 1964 · N58700 · Substantial damage NTSB UNK64X0921Accident · No injuriesClosedAeronca 7AC · Woodlawn, WAMar 15, 1964 · N3133E · Destroyed NTSB UNK64X0732Accident · No injuriesClosedCessna 210 · Wenatchee, WAFeb 28, 1964 · N7478E · Substantial damage NTSB UNK64X0688Accident · Serious injuriesClosedBoeing 75N1 · Dodge Jct, WAFeb 25, 1964 · N56938 · Substantial damage