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 SEA72FYC38Accident · Serious injuriesClosedPiper PA-28 · Vancouver, WAApr 29, 1972 · N8814N · Substantial damage NTSB SEA72AS048Accident · 3 fatalClosedBellanca 17-31A · Onalaska, WAApr 28, 1972 · N6581V · Destroyed NTSB SEA72DYG36Accident · No injuriesClosedPiper PA-25 · Odessa, WAApr 26, 1972 · N4464Y · Destroyed NTSB SEA72DYC35Accident · No injuriesClosedBeech 23 · Battle Grnd, WAApr 23, 1972 · N2367Z · Substantial damage NTSB SEA72AS047Accident · 2 fatalClosedAeronca 7AC · Mead, WAApr 22, 1972 · N2218E · Destroyed NTSB SEA72DYE29Accident · No injuriesClosedCessna 120 · Seattle, WAApr 17, 1972 · N1701N · Substantial damage NTSB SEA72AS045Accident · 3 fatalClosedCessna 182A · Walla Walla, WAApr 11, 1972 · N4068D · Destroyed NTSB SEA72DYE28Accident · No injuriesClosedCessna 182 · Georgetown, WAApr 8, 1972 · N2511R · Substantial damage NTSB SEA72IS041Incident · No injuriesClosedBeech B99 · Yakima, WAMar 29, 1972 · N2880A · Minor damage NTSB SEA73FYG32Accident · No injuriesClosedCessna 120 · George, WAMar 27, 1972 · N2696N · Substantial damage NTSB SEA72FYE26Accident · No injuriesClosedCessna 150 · Mt Vernon, WAMar 18, 1972 · N6410F · Destroyed NTSB SEA72FYE25Accident · Serious injuriesClosedCessna 150 · Maple Valley, WAMar 17, 1972 · N61355 · Substantial damage NTSB SEA72DYG38Accident · No injuriesClosedLuscombe 8E · Pullman, WAMar 17, 1972 · N1404B · Substantial damage NTSB SEA72DYG30Accident · No injuriesClosedSnow 600S2R · Sunnyside, WAMar 17, 1972 · N1763S · Substantial damage NTSB SEA72FYG31Accident · Minor injuriesClosedPiper PA-25 · Pullman, WAMar 16, 1972 · N4566Y · Destroyed NTSB SEA72AS037Accident · 1 fatalClosedPiper PA-32 · Tacoma, WAMar 10, 1972 · N5567J · Destroyed NTSB SEA72DYE24Accident · Minor injuriesClosedHughes 369HE · Burlington, WAMar 6, 1972 · N9048F · Substantial damage NTSB SEA72DYE23Accident · No injuriesClosedPiper PA-28 · Spanaway, WAFeb 25, 1972 · N2336R · Substantial damage NTSB SEA72DYG26Accident · No injuriesClosedCessna 206 · Sprague, WAFeb 20, 1972 · N4622F · Substantial damage NTSB SEA72AS032Accident · Minor injuriesClosedBeech 99 · Spokane, WAFeb 18, 1972 · N21FW · Substantial damage NTSB SEA72DYG28Accident · No injuriesClosedCessna 140 · Ephrata, WAFeb 4, 1972 · N2803N · Substantial damage NTSB SEA72DYE22Accident · No injuriesClosedCessna 172 · Spanaway, WAFeb 3, 1972 · N3978S · Substantial damage NTSB SEA72DYE21Accident · No injuriesClosedCessna 150 · Auburn, WAJan 30, 1972 · N22609 · Substantial damage NTSB SEA72AS029Accident · 2 fatalClosedCessna 150F · Lynnwood, WAJan 30, 1972 · N8131F · Destroyed NTSB SEA72DVC26Accident · No injuriesClosedLuscombe 8E · Orchards, WAJan 28, 1972 · N1717K · Substantial damage NTSB SEA72DYG27Accident · No injuriesClosedPiper PA-28 · Brewster, WAJan 22, 1972 · N5279W · Substantial damage NTSB SEA72AS026Accident · 3 fatalClosedPiper PA-28R · Paradise, WAJan 13, 1972 · N3025R · Destroyed NTSB SEA72DYG24Accident · No injuriesClosedErco 415-C · Richland, WAJan 2, 1972 · N99285 · Substantial damage NTSB SEA72AS027Accident · 1 fatalClosedCessna 150G · Kalama, WADec 31, 1971 · N2257J · Destroyed NTSB SEA72DYG23Accident · No injuriesClosedCessna 182A · Pulman, WADec 23, 1971 · N5948B · Substantial damage NTSB SEA72DVG22Accident · No injuriesClosedLuscombe 8F · Walla Walla, WADec 23, 1971 · N1870B · Substantial damage NTSB SEA72DYG21Accident · Minor injuriesClosedBeech 23 · Pullman, WADec 11, 1971 · N7608R · Substantial damage NTSB SEA72FYG20Accident · No injuriesClosedCessna 172K · Spokane, WANov 14, 1971 · N84034 · Substantial damage NTSB SEA72DYE20Accident · No injuriesClosedCessna 172 · Eastbound, WANov 8, 1971 · N8604B · Substantial damage NTSB SEA72FYE19Accident · 1 fatalClosedKasper BKB · Arlington, WANov 6, 1971 · N2991G · Destroyed NTSB SEA72DYG19Accident · No injuriesClosedCessna 182L · Spokane, WANov 5, 1971 · N42338 · Substantial damage NTSB SEA72FYG18Accident · Serious injuriesClosedPiper PA-32 · College Pl, WAOct 26, 1971 · N5268S · Destroyed NTSB SEA72DYE17Accident · No injuriesClosedPiper PA-22 · San Juan, WAOct 12, 1971 · N3028Z · Substantial damage NTSB SEA72AS016Accident · 1 fatalClosedChampion 7GCBC · North Bend, WAOct 10, 1971 · N5079X · Destroyed NTSB SEA72IS014Incident · No injuriesClosedBoeing 747 · Seattle, WAOct 9, 1971 · N601US · Minor damage NTSB SEA72AS015Accident · 1 fatalClosedChampion 7KCAB · Roche Harbor, WAOct 8, 1971 · N9124L · Destroyed NTSB SEA72DYE16Accident · No injuriesClosedBell 47G2 · Clallam Bay, WAOct 6, 1971 · N5160B · Substantial damage NTSB SEA72FYG15Accident · Serious injuriesClosedCessna A188 · Albion, WASep 23, 1971 · N9772V · Destroyed NTSB SEA72DYG13Accident · No injuriesClosedAero Comdr 600S24 · Pasco, WASep 18, 1971 · N8911Q · Destroyed NTSB SEA72AS013Accident · Minor injuriesClosedHughes 369HS · Shelton, WASep 18, 1971 · N9018F · Substantial damage NTSB SEA72DYE13Accident · No injuriesClosedBeech A35 · Prevost, WASep 9, 1971 · N654B · Substantial damage NTSB SEA72AS010Accident · 4 fatalClosedBellanca 17-30A · Seattle, WASep 9, 1971 · N6701V · Destroyed NTSB SEA72FYG09Accident · Minor injuriesClosedLuscombe 8A · Newport, WASep 5, 1971 · N28443 · Substantial damage NTSB SEA72DYG12Accident · No injuriesClosedCessna 182 · Outlook, WASep 3, 1971 · N2417X · Substantial damage NTSB SEA72AS009Accident · 2 fatalClosedStinson 108-2 · Port Angeles, WASep 3, 1971 · N890D · Destroyed