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 SEA67F0316Accident · Serious injuriesClosedCassutt R-1 · Arlington, WAApr 1, 1967 · N2280B · Substantial damage NTSB SEA67D0291Accident · No injuriesClosedPiper PA-28 · Cashmere, WAApr 1, 1967 · N4551R · Substantial damage NTSB SEA67A0064Accident · 1 fatalClosedVolmer VJ-22 · Lacey, WAApr 1, 1967 · N68648 · Destroyed NTSB SEA67F0280Accident · Minor injuriesClosedPiper PA-25 · Roosevelt, WAMar 30, 1967 · N7132Z · Destroyed NTSB SEA67D0270Accident · No injuriesClosedPiper PA-18 · Dusty, WAMar 27, 1967 · N8668C · Destroyed NTSB SEA67A0053Accident · 4 fatalClosedCessna 182J · Palmer, WAMar 24, 1967 · N2819F · Destroyed NTSB SEA67F0285Accident · Serious injuriesClosedPiper J5A · Pt.Townsend, WAMar 23, 1967 · N32896 · Substantial damage NTSB SEA67D0302Accident · No injuriesClosedCessna 170B · Puyallup, WAMar 21, 1967 · N3509C · Substantial damage NTSB SEA67D0356Accident · No injuriesClosedPiper PA-22 · Enumclaw, WAMar 19, 1967 · N9404D · Substantial damage NTSB SEA67A0052Accident · No injuriesClosedHughes 269A · Yakima, WAMar 19, 1967 · N8888F · Substantial damage NTSB SEA67D0263Accident · No injuriesClosedPiper PA-28 · Palouse, WAMar 12, 1967 · N5241W · Substantial damage NTSB SEA67F0259Accident · No injuriesClosedChampion 7ECA · Yakima, WAMar 8, 1967 · N11063 · Substantial damage NTSB SEA67D0250Accident · No injuriesClosedGrumman G-164 · Prescott, WAMar 6, 1967 · N517Y · Substantial damage NTSB SEA67D0262Accident · No injuriesClosedPiper PA-22 · Cheney, WAFeb 26, 1967 · N3458A · Substantial damage NTSB SEA67D0287Accident · No injuriesClosedBeech A35 · Maple Valley, WAFeb 19, 1967 · N752B · Substantial damage NTSB SEA67F0248Accident · No injuriesClosedPiper PA-12 · Bellevue, WAFeb 12, 1967 · N3498M · Substantial damage NTSB SEA67D0261Accident · No injuriesClosedPiper PA-25 · Colfax, WAFeb 11, 1967 · N7118Z · Substantial damage NTSB SEA67D0242Accident · No injuriesClosedPiper PA-22 · Starbuck, WAFeb 11, 1967 · N3346A · Substantial damage NTSB SEA67D0239Accident · Minor injuriesClosedMeyers 200-A · Pomeroy, WAFeb 10, 1967 · N34381 · Destroyed NTSB SEA67D0241Accident · No injuriesClosedCessna 140 · Starbuck, WAFeb 8, 1967 · N77018 · Substantial damage NTSB SEA67F0251Accident · No injuriesClosedPiper PA-18A · Moses Lake, WAFeb 7, 1967 · N2495P · Substantial damage NTSB SEA67D0247Accident · Minor injuriesClosedPiper PA-23 · Royal City, WAFeb 7, 1967 · N4619P · Substantial damage NTSB SEA67F0240Accident · No injuriesClosedLuscombe 8E · Colville, WAFeb 5, 1967 · CF-LYG · Substantial damage NTSB SEA68F0026Accident · 2 fatalClosedBellanca 14-13 · Everett, WAFeb 4, 1967 · N6524N · Destroyed NTSB SEA67D0246Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WAFeb 4, 1967 · N6936W · Substantial damage NTSB SEA67D0237Accident · No injuriesClosedLuscombe 8A · College Pl., WAFeb 2, 1967 · N2087K · Substantial damage NTSB SEA67D0284Accident · No injuriesClosedCessna 140 · Bothell, WAJan 30, 1967 · N2199N · Substantial damage NTSB SEA67D0283Accident · No injuriesClosedCessna 140 · Redmond, WAJan 30, 1967 · N89528 · Substantial damage NTSB SEA67D0238Accident · No injuriesClosedCessna 172 · Pasco, WAJan 29, 1967 · N3034U · Substantial damage NTSB SEA67D0229Accident · No injuriesClosedCessna 150 · Seattle, WAJan 24, 1967 · N8081S · Substantial damage NTSB SEA67D0230Accident · No injuriesClosedBeech K35 · Tacoma, WAJan 11, 1967 · N630Q · Substantial damage NTSB SEA67A0046Accident · No injuriesClosedBell 47G-3B · Pomeroy, WAJan 4, 1967 · N73919 · Substantial damage NTSB SEA67D0228Accident · No injuriesClosedPiper PA-28 · Bellevue, WADec 31, 1966 · N5745W · Substantial damage NTSB SEA67F0245Accident · Serious injuriesClosedCessna 170A · Kalama, WADec 30, 1966 · N9237A · Destroyed NTSB SEA67F0244Accident · Minor injuriesClosedPiper PA-28 · Tacoma, WADec 17, 1966 · N4545R · 2 aircraft · Substantial damage NTSB SEA67A0042Accident · No injuriesClosedHiller UH-12C · Rosalia, WADec 12, 1966 · N5316V · Substantial damage NTSB SEA67D0213Accident · No injuriesClosedCessna 172 · Fri.Harbor, WADec 6, 1966 · N6374E · Substantial damage NTSB SEA67A0041Accident · 1 fatalClosedCessna 150F · Ndavenport, WADec 6, 1966 · N8888S · Destroyed NTSB SEA67D0203Accident · No injuriesClosedPiper PA-23 · Almira, WADec 3, 1966 · N4947P · Substantial damage NTSB SEA67A0040Accident · No injuriesClosedBell 47G-2 · Maple Valley, WADec 1, 1966 · N2865B · Substantial damage NTSB SEA67D0200Accident · Serious injuriesClosedCessna 175 · Kettle Falls, WANov 24, 1966 · CF-SFS · Destroyed NTSB SEA67A0038Accident · 2 fatalClosedCessna 182H · Frances, WANov 23, 1966 · N2047X · Destroyed NTSB SEA67D0201Accident · No injuriesClosedCessna 150 · Colton, WANov 22, 1966 · N8974S · Substantial damage NTSB SEA67A0037Accident · No injuriesClosedAir-Space 18A · Hoquiam, WANov 21, 1966 · N6130S · Substantial damage NTSB SEA67F0205Accident · Serious injuriesClosedCessna 182 · Royal City, WANov 16, 1966 · N2349R · Substantial damage NTSB SEA67D0175Accident · No injuriesClosedCessna 150 · Spokane, WANov 13, 1966 · N8647G · Substantial damage NTSB SEA67D0202Accident · No injuriesClosedCessna 150 · Pasco, WANov 12, 1966 · N3986J · Substantial damage NTSB SEA67D0188Accident · No injuriesClosedStinson L-5B · Yakima, WANov 12, 1966 · N6439C · Destroyed NTSB SEA67D0182Accident · No injuriesClosedCessna 182 · Tonasket, WANov 11, 1966 · N3117Y · Substantial damage NTSB SEA67D0212Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WANov 9, 1966 · N6936W · Substantial damage