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 SEA67D0070Accident · No injuriesClosedLuscombe 8E · Puyallup, WAJul 10, 1966 · N2282K · Substantial damage NTSB SEA67D0126Accident · No injuriesClosedCessna 120 · Alderwood, WAJul 4, 1966 · N77299 · Destroyed NTSB SEA67D0117Accident · No injuriesClosedPiper PA-22 · Vancouver, WAJul 4, 1966 · N4507A · Substantial damage NTSB SEA67D0068Accident · No injuriesClosedBeech K35 · Ocean Shores, WAJun 29, 1966 · N5504D · Substantial damage NTSB SEA67F0052Accident · No injuriesClosedCessna 150 · Leavenworth, WAJun 26, 1966 · N8801S · Substantial damage NTSB SEA66A0070Accident · 2 fatalClosedMooney MK20E · Kelso, WAJun 23, 1966 · N79843 · Substantial damage NTSB SEA66A0069Accident · No injuriesClosedPiper PA-25 · Royal City, WAJun 20, 1966 · N6807Z · Minor damage NTSB SEA67F0071Accident · No injuriesClosedCessna 182 · Lester, WAJun 19, 1966 · N3040F · Substantial damage NTSB SEA67D0014Accident · No injuriesClosedCessna 150 · Richland, WAJun 18, 1966 · N7794E · Substantial damage NTSB SEA66A0073Accident · No injuriesClosedBell 47G-2 · Winslow, WAJun 18, 1966 · N2866B · Substantial damage NTSB SEA67D0034Accident · No injuriesClosedPiper PA-18A · Prosser, WAJun 17, 1966 · N7362D · Substantial damage NTSB SEA67D0049Accident · No injuriesClosedCessna 180 · Ocean Shores, WAJun 15, 1966 · N4679A · Substantial damage NTSB SEA67F0009Accident · No injuriesClosedPiper PA-25 · Quincy, WAJun 14, 1966 · N6352Z · Destroyed NTSB SEA67D0069Accident · No injuriesClosedTemco D-16 · Seattle, WAJun 14, 1966 · N131N · Substantial damage NTSB SEA67D0048Accident · No injuriesClosedCessna 150 · Renton, WAJun 11, 1966 · N7807F · Substantial damage NTSB SEA67D0027Accident · No injuriesClosedPiper PA-18 · Odessa, WAJun 9, 1966 · N3686A · Substantial damage NTSB SEA67F0006Accident · No injuriesClosedPiper PA24 · Bellevue, WAJun 5, 1966 · N8864P · Substantial damage NTSB SEA67D0047Accident · No injuriesClosedCessna 175 · Friday Harbr, WAJun 4, 1966 · N6899E · Substantial damage NTSB SEA67F0046Accident · No injuriesClosedHoward DGA-15 · Renton, WAJun 1, 1966 · N66546 · Substantial damage NTSB SEA67F0045Accident · No injuriesClosedCessna 150 · Bellevue, WAMay 31, 1966 · N4444U · Substantial damage NTSB SEA67D0044Accident · No injuriesClosedMooney M20B · Bellevue, WAMay 31, 1966 · N74587 · Substantial damage NTSB SEA66A0062Accident · No injuriesClosedBell 47J-2A · Seattle, WAMay 27, 1966 · N251PH · Substantial damage NTSB SEA66F0299Accident · No injuriesClosedPiper PA-30 · Pasco, WAMay 25, 1966 · N7068Y · Substantial damage NTSB SEA66A0060Accident · 3 fatalClosedCessna 172 · Metaline Fls, WAMay 24, 1966 · N7230A · Substantial damage NTSB SEA67F0005Accident · No injuriesClosedCessna 180 · Tacoma, WAMay 18, 1966 · N2734X · Substantial damage NTSB SEA67F0043Accident · No injuriesClosedCessna 150 · Chehalis, WAMay 17, 1966 · N5972E · Substantial damage NTSB SEA67D0130Accident · No injuriesClosedCessna 180 · Easton, WAMay 13, 1966 · N8214V · Substantial damage NTSB SEA66A0055Accident · 4 fatalClosedCessna 175A · Cumberland, WAMay 9, 1966 · N6903E · Destroyed NTSB SEA67F0041Accident · Serious injuriesClosedCessna 172 · Ocean Shores, WAMay 8, 1966 · N5949A · Destroyed NTSB SEA67F0004Accident · No injuriesClosedCessna 182 · Moclips, WAMay 8, 1966 · N2798G · Substantial damage NTSB SEA67D0042Accident · No injuriesClosedBeech D50 · Long Beach, WAMay 8, 1966 · N5674D · Substantial damage NTSB SEA66A0056Accident · 2 fatalClosedCessna 180 · Neah Bay, WAMay 6, 1966 · N4546B · Destroyed NTSB SEA67F0013Accident · Minor injuriesClosedBeech 23 · Vancouver, WAApr 30, 1966 · N2333J · Destroyed NTSB SEA66D0286Accident · No injuriesClosedBeech 23A · Shelton, WAApr 29, 1966 · N3507R · Substantial damage NTSB SEA66F0284Accident · Minor injuriesClosedCessna 172 · Bellevue, WAApr 28, 1966 · N7363J · Substantial damage NTSB SEA66F0268Accident · 1 fatalClosedPiper PA-25 · Kennewick, WAApr 28, 1966 · N6873Z · Destroyed NTSB SEA66F0248Accident · No injuriesClosedCessna 180 · Chewelah, WAApr 27, 1966 · N2868A · Substantial damage NTSB SEA67D0003Accident · No injuriesClosedCessna 170B · Aldrwood Mnr, WAApr 26, 1966 · N2207D · Substantial damage NTSB SEA67D0002Accident · No injuriesClosedCessna 140 · Crane Island, WAApr 24, 1966 · N77086 · Substantial damage NTSB SEA66D0294Accident · No injuriesClosedBeech A23 · Vancouver, WAApr 22, 1966 · N2374W · Substantial damage NTSB SEA66F0245Accident · No injuriesClosedCessna 150 · Moses Lake, WAApr 21, 1966 · N8652G · Substantial damage NTSB SEA67D0001Accident · No injuriesClosedAeronca 7AC · Ocean Shores, WAApr 17, 1966 · N84312 · Substantial damage NTSB SEA66F0285Accident · Minor injuriesClosedPiper PA-22 · Maple Valley, WAApr 16, 1966 · N2442P · Substantial damage NTSB SEA66F0240Accident · Minor injuriesClosedCessna 172 · Pullman, WAApr 13, 1966 · N7721T · Substantial damage NTSB SEA66F0237Accident · No injuriesClosedCessna 180 · Naches, WAApr 12, 1966 · N172AA · Substantial damage NTSB SEA66F0262Accident · No injuriesClosedLuscombe 8E · Vancouver, WAApr 8, 1966 · N1717K · Substantial damage NTSB SEA66F0259Accident · No injuriesClosedCessna 172E · Anacortes, WAApr 5, 1966 · N3559S · Substantial damage NTSB SEA66D0251Accident · No injuriesClosedCessna 182G · Port Angeles, WAApr 5, 1966 · N2181R · Substantial damage NTSB SEA66F0258Accident · No injuriesClosedCessna 150 · Mount Vernon, WAApr 4, 1966 · N8004S · Substantial damage NTSB SEA66D0255Accident · No injuriesClosedNavion A · Kingston, WAApr 3, 1966 · N5326K · Substantial damage