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 SEA66F0002Accident · No injuriesClosedBeech B33 · Prosser, WAJun 13, 1965 · N8628M · Substantial damage NTSB SEA66D0001Accident · No injuriesClosedRawdon T1 · Oakesdale, WAJun 11, 1965 · N6804D · Substantial damage NTSB SEA66F0013Accident · Serious injuriesClosedPiper PA-22 · Sequim, WAJun 8, 1965 · N2755C · Substantial damage NTSB SEA65A0067Accident · No injuriesClosedBell 47G2 · Centralia, WAJun 8, 1965 · N2865B · Substantial damage NTSB SEA65A0066Accident · 1 fatalClosedPiper PA-22 · Carson, WAJun 7, 1965 · N2459P · Destroyed NTSB SEA66F0009Accident · No injuriesClosedCessna 182F · Colville, WAMay 31, 1965 · N3299U · Substantial damage NTSB SEA66F0007Accident · Serious injuriesClosedRyan ST-A · Olympia, WAMay 31, 1965 · N18923 · Substantial damage NTSB SEA65A0065Accident · No injuriesClosedBrantly B-2 · Martha Lake, WAMay 31, 1965 · N5901X · Substantial damage NTSB SEA66F0003Accident · No injuriesClosedPiper PA-24 · Seatte, WAMay 30, 1965 · N6678P · Substantial damage NTSB SEA66F0012Accident · No injuriesClosedPiper PA-23 · Bremerton, WAMay 29, 1965 · N1479P · Substantial damage NTSB SEA66F0004Accident · No injuriesClosedSchweizer SGSI26 · Richland, WAMay 29, 1965 · N8650R · Substantial damage NTSB SEA65A0064Accident · 1 fatalClosedCessna 182C · Forks, WAMay 26, 1965 · N8536T · Destroyed NTSB SEA65F0065Accident · No injuriesClosedPiper PA-20 · Othello, WAMay 25, 1965 · N7092K · Substantial damage NTSB SEA65D0066Accident · No injuriesClosedCessna 172 · Yakima, WAMay 23, 1965 · N2134Y · Substantial damage NTSB SEA65F0068Accident · Minor injuriesClosedAeronca 7AC · Seattle, WAMay 22, 1965 · N1363E · Substantial damage NTSB SEA65D0064Accident · No injuriesClosedCessna 170B · Pasco, WAMay 20, 1965 · N1625D · Substantial damage NTSB SEA65F0059Accident · No injuriesClosedCessna 310D · Wenatchee, WAMay 18, 1965 · N6835T · Substantial damage NTSB SEA65D0071Accident · No injuriesClosedPiper PA-22 · Oak Harbor, WAMay 17, 1965 · N5307Z · Substantial damage NTSB SEA66D0008Accident · No injuriesClosedCallair A-9 · Palouse, WAMay 11, 1965 · N9661Z · Substantial damage NTSB SEA65A0061Accident · 1 fatalClosedGlobe Swift GC-1B · Lacrosse, WAMay 9, 1965 · N80610 · Destroyed NTSB SEA66D0061Accident · No injuriesClosedBoeing PT-17 · Walla Walla, WAMay 7, 1965 · N4812V · Substantial damage NTSB SEA65F0053Accident · No injuriesClosedMooney 20E · Spokane, WAMay 7, 1965 · N1277X · Substantial damage NTSB SEA65D0048Accident · No injuriesClosedPiper PA-18A · Washtucna, WAApr 29, 1965 · N7060D · Substantial damage NTSB SEA65A0059Accident · Minor injuriesClosedBell 47G3B1 · Marblemount, WAApr 28, 1965 · N68645 · Substantial damage NTSB SEA65A0055Accident · No injuriesClosedBell 47G · Prescott, WAApr 25, 1965 · N927B · Substantial damage NTSB SEA65A0053Accident · 5 fatalClosedDouglas DC-6A · Mt Rainier, WAApr 23, 1965 · N6541C · Destroyed NTSB SEA65A0052Accident · 1 fatalClosedLuscombe 8A · Mead, WAApr 23, 1965 · N28416 · Destroyed NTSB SEA65F0049Accident · No injuriesClosedCessna 170B · Mesa, WAApr 19, 1965 · N2599D · Substantial damage NTSB SEA65F0037Accident · No injuriesClosedPiper PA-28 · Othello, WAApr 13, 1965 · N5279W · Substantial damage NTSB SEA65A0050Accident · Minor injuriesClosedHughes 269A · L.Quinault, WAApr 8, 1965 · N8886F · Destroyed NTSB SEA65F0036Accident · No injuriesClosedBeechcraft 95 · Renton, WAApr 1, 1965 · N9608R · Substantial damage NTSB SEA65F0035Accident · Minor injuriesClosedCessna 175 · Omak, WAApr 1, 1965 · N9412B · Destroyed NTSB SEA65F0032Accident · No injuriesClosedPiper PA-22 · Othello, WAMar 31, 1965 · N5990D · Substantial damage NTSB SEA65F0033Accident · No injuriesClosedPiper PA-24 · North Bend, WAMar 29, 1965 · N6133P · Substantial damage NTSB SEA65F0031Accident · No injuriesClosedLuscombe 8A · Mead, WAMar 28, 1965 · N1115K · Substantial damage NTSB SEA65A0048Accident · 3 fatalClosedTaylorcraft BC-65 · Tacoma, WAMar 28, 1965 · N26632 · Destroyed NTSB SEA65D0052Accident · No injuriesClosedPiper PA-22 · Bellevue, WAMar 25, 1965 · N2475A · Substantial damage NTSB SEA65F0042Accident · No injuriesClosedBoeing B-75N1 · Ewan, WAMar 19, 1965 · N37194 · Substantial damage NTSB SEA65D0029Accident · No injuriesClosedBeechcraft 23 · Gig Harbor, WAMar 18, 1965 · N8735M · Substantial damage NTSB SEA65A0047Accident · Minor injuriesClosedBell 47G-2 · Wenatchee, WAMar 13, 1965 · N2483B · Destroyed NTSB SEA65F0022Accident · No injuriesClosedPiper PA-22 · Pullman, WAMar 11, 1965 · N3648P · Substantial damage NTSB SEA65F0020Accident · No injuriesClosedCessna 140 · Pullman, WAMar 9, 1965 · N72232 · Substantial damage NTSB SEA65F0046Accident · Minor injuriesClosedSwift GC-1B · Camas, WAMar 6, 1965 · N80656 · Destroyed NTSB SEA65F0021Accident · No injuriesClosedCessna 172 · Pullman, WAMar 4, 1965 · N7200T · Substantial damage NTSB SEA65F0028Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WAMar 3, 1965 · N5545W · Substantial damage NTSB SEA65D0027Accident · No injuriesClosedCessna 172A · Seattle, WAMar 2, 1965 · N7377T · Substantial damage NTSB SEA65F0007Accident · No injuriesClosedCessna 180 · Seattle, WAFeb 10, 1965 · N2392C · Substantial damage NTSB SEA65A0042Accident · 4 fatalClosedMooney M20 · Longmire, WAFeb 8, 1965 · N6529B · Destroyed NTSB SEA65F0003Accident · No injuriesClosedPiper J3C · Reardon, WAFeb 7, 1965 · N87787 · Substantial damage NTSB SEA65F0002Accident · No injuriesClosedShinn 2150A · Othello, WAFeb 6, 1965 · N5122V · Substantial damage