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 SEA75FYE04Accident · 1 fatalClosedSorrell JA3-80 · Arlington, WAJul 19, 1974 · N68654 · Destroyed NTSB SEA75DYG05Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 18, 1974 · N8803L · Substantial damage NTSB SEA75DYG03Accident · Minor injuriesClosedBell 47G-2 · Wapato, WAJul 18, 1974 · N7891B · Destroyed NTSB SEA75AS004Accident · 2 fatalClosedCessna 172H · Snoqualme Ps, WAJul 18, 1974 · N1669F · Destroyed NTSB SEA75FYE03Accident · Minor injuriesClosedCessna 150F · Buckley, WAJul 16, 1974 · N7777F · Destroyed NTSB SEA75FYG02Accident · Minor injuriesClosedBellanca 8KCAB · Deer Park, WAJul 14, 1974 · N33MJ · Destroyed NTSB SEA75AS003Accident · 1 fatalClosedCessna 180C · Tacoma, WAJul 12, 1974 · N9321T · Destroyed NTSB SEA75AS002Accident · 4 fatalClosedBeech D95A · Anacortes, WAJul 11, 1974 · N8888V · Destroyed NTSB SEA75DYE01Accident · No injuriesClosedCessna 172 · Lopez, WAJul 7, 1974 · N12788 · Substantial damage NTSB SEA75AS001Accident · 4 fatalClosedBellanca 14-132 · Bremerton, WAJul 7, 1974 · N4852N · Destroyed NTSB SEA74DYE50Accident · No injuriesClosedCessna 172 · Burlington, WAJun 30, 1974 · N79931 · Substantial damage NTSB SEA74DYC63Accident · Minor injuriesClosedAmer Avco AA1-B · Vancouver, WAJun 30, 1974 · N8892L · Substantial damage NTSB SEA74DYG49Accident · No injuriesClosedBell 47G-2 · Ephrata, WAJun 24, 1974 · N2899B · Substantial damage NTSB SEA74DYG50Accident · Minor injuriesClosedBell 47G3B2 · Clarkston, WAJun 23, 1974 · N8169J · Destroyed NTSB SEA74AS050Accident · 4 fatalClosedCessna 150K · Seattle, WAJun 21, 1974 · N562QL · 2 aircraft · Destroyed NTSB SEA74DYE49Accident · No injuriesClosedLuscombe 8E · Arlington, WAJun 20, 1974 · N2029K · Substantial damage NTSB SEA74DYC58Accident · No injuriesClosedCessna 172 · Battle Grnd, WAJun 16, 1974 · N8044L · Substantial damage NTSB SEA74DYG47Accident · Minor injuriesClosedPiper PA-28 · Wenatchee, WAJun 13, 1974 · N5611U · Destroyed NTSB SEA74DYE48Accident · No injuriesClosedBell 47G · Elma, WAJun 11, 1974 · N927B · Substantial damage NTSB SEA74DYE47Accident · No injuriesClosedCessna 182A · Everett, WAJun 10, 1974 · N5343D · Substantial damage NTSB SEA74DYE46Accident · No injuriesClosedCessna 180H · Granite Fall, WAJun 7, 1974 · N2788X · Substantial damage NTSB SEA74DYG45Accident · No injuriesClosedAeronca 7AC · Walla Walla, WAJun 6, 1974 · N84607 · Substantial damage NTSB SEA74DYG44Accident · No injuriesClosedBell 47G3B1 · Stratford, WAJun 4, 1974 · N1135W · Destroyed NTSB SEA74AS047Accident · 4 fatalClosedPiper PA-23 · Toledo, WAJun 3, 1974 · N54074 · Destroyed NTSB SEA74DYG43Accident · No injuriesClosedPiper PA-24 · Othello, WAMay 31, 1974 · N7722P · Substantial damage NTSB OAK74DYE45Accident · Minor injuriesClosedKasper 100 · Arlington, WAMay 28, 1974 · N88818 · Substantial damage NTSB SEA74AS045Accident · 1 fatalClosedGlobe GC-1B · Metaline Fls, WAMay 27, 1974 · N80951 · Substantial damage NTSB SEA74DYG46Accident · No injuriesClosedAero Comdr 600S2R · Moses Lake, WAMay 25, 1974 · N88250 · Substantial damage NTSB SEA74FYG40Accident · Serious injuriesClosedPitts Spcl S-1C · Mead, WAMay 19, 1974 · N5S · Destroyed NTSB SEA74DYG41Accident · No injuriesClosedStearman E75 · Dayton, WAMay 17, 1974 · N49413 · Substantial damage NTSB SEA74FYG39Accident · Minor injuriesClosedBeech A23-19 · Moses Lake, WAMay 14, 1974 · N6909Q · Substantial damage NTSB SEA74DYG37Accident · No injuriesClosedCessna 170B · Garfield, WAMay 5, 1974 · N1625D · Substantial damage NTSB SEA74DYG38Accident · Minor injuriesClosedBell 47G-2 · Ephrata, WAMay 4, 1974 · N7887B · Substantial damage NTSB SEA74DYG35Accident · No injuriesClosedBell 47G3B1 · Chelan, WAMay 2, 1974 · N73932 · Substantial damage NTSB SEA74DYG34Accident · No injuriesClosedPiper PA-25 · Othello, WAApr 29, 1974 · N8804L · Substantial damage NTSB SEA74DYG30Accident · No injuriesClosedCessna 305A · Buena, WAApr 25, 1974 · N5283G · Substantial damage NTSB SEA74AS041Accident · 1 fatalClosedCessna 182K · Walla Walla, WAApr 23, 1974 · N2510R · Destroyed NTSB SEA74FYG31Accident · Minor injuriesClosedPiper PA-25 · Endicott, WAApr 22, 1974 · N4565Y · Destroyed NTSB SEA74FYG42Accident · No injuriesClosedPiper PA-28 · Laurier, WAApr 18, 1974 · CF-ELV · Substantial damage NTSB SEA74FYE43Accident · Serious injuriesClosedHughes 269B · Seattle, WAApr 18, 1974 · N9332F · No damage NTSB SEA74DYE42Accident · No injuriesClosedBell 47G-2 · Centralia, WAApr 18, 1974 · N984B · Substantial damage NTSB SEA74FYC46Accident · Serious injuriesClosedCessna 177 · Battle Grnd, WAApr 15, 1974 · N3405T · Destroyed NTSB SEA74DYG33Accident · No injuriesClosedPiper PA-28 · Walla Walla, WAApr 14, 1974 · N3487K · Destroyed NTSB SEA74DYE44Accident · Minor injuriesClosedBell 47G3B1 · Forks, WAApr 8, 1974 · N1325X · Destroyed NTSB SEA74FYC41Accident · Minor injuriesClosedBeech 35 · Vancouver, WAMar 29, 1974 · N3165V · Substantial damage NTSB SEA74FYE41Accident · No injuriesClosedCessna 150 · Redmond, WAMar 20, 1974 · N5469Q · Substantial damage NTSB SEA74FYG27Accident · Minor injuriesClosedStinson 108-1 · Tekoa, WAMar 17, 1974 · N97675 · Substantial damage NTSB SEA74FYC37Accident · Serious injuriesClosedErco 415-C · Vancouver, WAMar 9, 1974 · N2243H · Substantial damage NTSB SEA74DYE40Accident · No injuriesClosedCessna 172 · Olympia, WAMar 9, 1974 · N4681L · Substantial damage NTSB SEA74DYE39Accident · No injuriesClosedBell 47G-2 · Forks, WAMar 3, 1974 · N5161B · Substantial damage