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 SEA73FYE31Accident · Serious injuriesClosedWood VJ-22 · Langley, WAApr 14, 1973 · N5510 · Substantial damage NTSB SEA73DYG27Accident · No injuriesClosedCessna 180 · Palouse, WAApr 14, 1973 · N2904C · Substantial damage NTSB SEA73FYG28Accident · Serious injuriesClosedAmer Avco AA1 · Colville, WAApr 13, 1973 · N5771L · Substantial damage NTSB SEA73DYG25Accident · No injuriesClosedStinson 108-1 · Electric Cty, WAApr 6, 1973 · N97755 · Substantial damage NTSB SEA73DYG26Accident · No injuriesClosedCessna 172 · Othello, WAApr 5, 1973 · N7021T · Substantial damage NTSB SEA73DYE30Accident · Serious injuriesClosedCessna 172 · Chehalis, WAApr 3, 1973 · N6718A · Substantial damage NTSB SEA73AS027Accident · 4 fatalClosedCessna 210A · Kelso, WAMar 28, 1973 · N6699X · Destroyed NTSB SEA73AS026Accident · 2 fatalClosedN.American T-28A · Gorst, WAMar 24, 1973 · N2800N · Destroyed NTSB SEA73FYE29Accident · No injuriesClosedStinson 108 · Kent, WAMar 17, 1973 · N9150K · Substantial damage NTSB SEA73FYG24Accident · No injuriesClosedLuscombe 8F · Newman Lake, WAMar 4, 1973 · N1510B · Substantial damage NTSB SEA73DYG23Accident · Minor injuriesClosedLuscombe T-8F · Cashmere, WAMar 3, 1973 · N1827B · Substantial damage NTSB SEA73DYE28Accident · Minor injuriesClosedAmer Avco AA-1 · Arlington, WAFeb 22, 1973 · N5957L · Substantial damage NTSB SEA73DYE27Accident · Minor injuriesClosedStinson 108-3 · Anacortes, WAFeb 18, 1973 · N6585M · Substantial damage NTSB SEA73FYE26Accident · Serious injuriesClosedCessna 172G · Bellevue, WAFeb 17, 1973 · N4126L · No damage NTSB SEA73FYE25Accident · No injuriesClosedCessna 150L · Renton, WAFeb 17, 1973 · N6519G · Substantial damage NTSB SEA73AS025Accident · 3 fatalClosedAero Comdr 680F · Battle Grnd, WAFeb 17, 1973 · N69HE · Destroyed NTSB SEA73AS024Accident · No injuriesClosedCessna 172 · Sekiu, WAFeb 14, 1973 · N20186 · Substantial damage NTSB SEA73AS023Accident · 4 fatalClosedCessna 320E · Walla Walla, WAFeb 12, 1973 · N3483Q · Destroyed NTSB SEA73AS019Accident · Minor injuriesClosedAlouette III · Clarkston, WAJan 19, 1973 · N9703 · Substantial damage NTSB SEA73AS018Accident · Minor injuriesClosedHughes 369HS · North Bend, WAJan 16, 1973 · N9033F · Substantial damage NTSB SEA73FYE24Accident · No injuriesClosedBeech F35 · Lester, WAJan 2, 1973 · N4218B · Substantial damage NTSB SEA73DYE23Accident · Minor injuriesClosedRyan ST-3KR · Snohomish, WADec 24, 1972 · N57185 · Substantial damage NTSB SEA73FYG21Accident · 2 fatalClosedSikorsky S-61A · Chelan, WADec 14, 1972 · N318Y · Destroyed NTSB SEA73FYE22Accident · Minor injuriesClosedCessna 150 · Renton, WADec 8, 1972 · N3230J · Substantial damage NTSB SEA73ASO13Accident · 1 fatalClosedLuscombe 8A · Ellensburg, WANov 28, 1972 · N1170B · Destroyed NTSB SEA73FYE21Accident · Minor injuriesClosedCessna T337D · Kent, WANov 27, 1972 · N85866 · Substantial damage NTSB SEA73FYE20Accident · No injuriesClosedPiper PA-28 · Monroe, WANov 23, 1972 · N9694W · Substantial damage NTSB SEA73ASO12Accident · 3 fatalClosedPiper PA-28 · Brinnon, WANov 15, 1972 · N1964T · Destroyed NTSB SEA73DYG20Accident · Minor injuriesClosedCessna 182 · Republic, WANov 13, 1972 · N7211E · Substantial damage NTSB SEA73FYE19Accident · No injuriesClosedSwift GC-1B · Snohomish, WANov 12, 1972 · N78165 · Substantial damage NTSB SEA73FYE18Accident · Serious injuriesClosedCessna 172 · Longmire, WANov 12, 1972 · N1837Y · Destroyed NTSB SEA73FYG19Accident · No injuriesClosedCessna 150 · Spokane, WANov 10, 1972 · N5527G · Substantial damage NTSB SEA73DYG18Accident · No injuriesClosedRobertson 182J · Connell, WAOct 25, 1972 · N3392F · Substantial damage NTSB SEA73DYG16Accident · No injuriesClosedStinson 108-2 · Republic, WAOct 23, 1972 · N201C · Substantial damage NTSB SEA73DYG15Accident · No injuriesClosedPiper PA-22 · Moses Lake, WAOct 13, 1972 · N8143D · Substantial damage NTSB SEA73DYE17Accident · No injuriesClosedCessna 210 · Bellingham, WAOct 10, 1972 · N9557T · Substantial damage NTSB SEA73ASO09Accident · 1 fatalClosedPiper PA-23 · Dixie, WAOct 10, 1972 · N6707Y · Destroyed NTSB SEA73AS007Accident · 2 fatalClosedBeech D55 · Mansfield, WASep 24, 1972 · N7705R · Destroyed NTSB SEA73FYG13Accident · 1 fatalClosedBell 47-G2A · Selah, WASep 23, 1972 · N73284 · Substantial damage NTSB SEA73FYE15Accident · Serious injuriesClosedHughes 269A · Elma, WASep 17, 1972 · N8914F · Substantial damage NTSB SEA73DYE16Accident · No injuriesClosedAmer Avco AA1A · Oak Harbor, WASep 17, 1972 · N6372L · Substantial damage NTSB SEA73FYE14Accident · Minor injuriesClosedPiper PA-32 · Olympia, WASep 11, 1972 · N4281R · Substantial damage NTSB SEA73AS005Accident · 5 fatalClosedPiper PA-32 · Ryderwood, WASep 8, 1972 · N3600W · Destroyed NTSB SEA73FYE12Accident · Serious injuriesClosedHugo R & K Spcl · Puyallup, WASep 2, 1972 · N115R · Destroyed NTSB SEA73DYE13Accident · No injuriesClosedPiper PA-28R · Roche Harbor, WASep 1, 1972 · N4959J · Substantial damage NTSB SEA73FYC06Accident · Serious injuriesClosedWaco UPF-7 · Vancouver, WAAug 19, 1972 · N29949 · Substantial damage NTSB SEA73DYE11Accident · Serious injuriesClosedAeronca 11AC · Edmonds, WAAug 18, 1972 · N4495E · Minor damage NTSB SEA73DYG11Accident · No injuriesClosedCessna 120 · Rockford, WAAug 14, 1972 · N77336 · Substantial damage NTSB SEA73DYG12Accident · No injuriesClosedStinson 108 · Connell, WAAug 12, 1972 · N217C · Substantial damage NTSB SEA73DYG10Accident · No injuriesClosedSnow S-2R · Wiley City, WAAug 12, 1972 · N1763S · Substantial damage