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 SEA66F0252Accident · No injuriesClosedBeech B35 · Auburn, WAMar 25, 1966 · N5214C · Substantial damage NTSB SEA66D0254Accident · No injuriesClosedAeronca 7AC · Kent, WAMar 25, 1966 · N82651 · Substantial damage NTSB SEA66A0050Accident · 1 fatalClosedFairchild M-62A · Kent, WAMar 25, 1966 · N49264 · Substantial damage NTSB SEA66A0049Accident · No injuriesClosedKaman K-240 · Latah, WAMar 24, 1966 · N6060C · Substantial damage NTSB SEA66D0257Accident · No injuriesClosedAeronca 7AC · Spanaway, WAMar 22, 1966 · N2132E · Substantial damage NTSB SEA66A0048Accident · 1 fatalClosedStinson 108 · Port Angeles, WAMar 21, 1966 · N8930K · No damage NTSB SEA66D0256Accident · No injuriesClosedCessna 120 · Gardiner, WAMar 17, 1966 · N3177N · Destroyed NTSB SEA66F0218Accident · No injuriesClosedCessna 205 · Bellevue, WAMar 12, 1966 · N8496Z · Substantial damage NTSB SEA66A0047Accident · 1 fatalClosedTravel Air S6000B · Ellensburg, WAMar 4, 1966 · N9842 · Destroyed NTSB SEA66A0046Accident · 1 fatalClosedCessna 172C · Montesano, WAFeb 28, 1966 · N8279X · Destroyed NTSB SEA66F0213Accident · Minor injuriesClosedPiper PA-22 · Vancouver, WAFeb 12, 1966 · N898A · Substantial damage NTSB SEA66D0219Accident · No injuriesClosedCessna 170B · Center Islnd, WAFeb 5, 1966 · N3495C · Substantial damage NTSB SEA66F0207Accident · Serious injuriesClosedCessna 150 · Pullman, WAJan 30, 1966 · N4074U · Destroyed NTSB SEA66D0217Accident · No injuriesClosedCessna 150 · Redmond, WAJan 29, 1966 · N1256Y · Substantial damage NTSB SEA66F0208Accident · No injuriesClosedBeechcraft C35 · Newport, WAJan 24, 1966 · N5813C · Substantial damage NTSB SEA66F0253Accident · Serious injuriesClosedCessna 150 · Seattle, WAJan 20, 1966 · N5718E · Substantial damage NTSB SEA66D0220Accident · No injuriesClosedPiper PA-28 · Port Orchard, WAJan 18, 1966 · N5837W · Substantial damage NTSB SEA66D0191Accident · No injuriesClosedCessna 150 · Pullman, WAJan 11, 1966 · N8974S · Substantial damage NTSB SEA66F0198Accident · No injuriesClosedCessna 150 · Renton, WAJan 10, 1966 · N8226S · Substantial damage NTSB SEA66F0202Accident · Minor injuriesClosedPiper PA-16 · Edmonds, WAJan 9, 1966 · N5924H · Destroyed NTSB SEA66D0216Accident · No injuriesClosedAeronca 7FC · Snohomish, WAJan 7, 1966 · N7508E · Substantial damage NTSB SEA66D0196Accident · No injuriesClosedPiper PA-22 · Olympia, WAJan 2, 1966 · N50942 · Substantial damage NTSB SEA66F0193Accident · No injuriesClosedCessna 150 · Ellensburg, WADec 30, 1965 · N7718E · Substantial damage NTSB SEA66D0199Accident · No injuriesClosedCessna 150 · Mount Vernon, WADec 27, 1965 · N8751S · Substantial damage NTSB SEA66D0179Accident · No injuriesClosedBeechcraft 35 · Pullman, WADec 17, 1965 · N3854N · Substantial damage NTSB SEA66F0181Accident · No injuriesClosedCessna 150F · Redmond, WADec 15, 1965 · N8801S · Substantial damage NTSB SEA66A0037Accident · No injuriesClosedBell 47G-2 · Auburn, WADec 14, 1965 · N2865B · Substantial damage NTSB SEA66F0182Accident · Minor injuriesClosedTaylorcraft DC0-65 · Kent, WADec 11, 1965 · N49174 · Substantial damage NTSB SEA66F0172Accident · No injuriesClosedCessna 182 · Pasco, WADec 8, 1965 · N5111D · Substantial damage NTSB SEA66D0169Accident · No injuriesClosedCessna 140 · Wenatchee, WADec 5, 1965 · N89528 · Substantial damage NTSB SEA66D0183Accident · No injuriesClosedCessna 172 · Bellingham, WADec 3, 1965 · N6933X · Substantial damage NTSB SEA66A0035Accident · Minor injuriesClosedDouglas DC-3 · Hoquiam, WADec 1, 1965 · N62375 · Substantial damage NTSB SEA66F0184Accident · No injuriesClosedCessna 150 · Renton, WANov 28, 1965 · N8081S · Substantial damage NTSB SEA66A0032Accident · Minor injuriesClosedBell 47G-2 · 38mi E.Kelso, WANov 23, 1965 · N6145C · Substantial damage NTSB SEA66D0159Accident · No injuriesClosedCessna 182 · Othello, WANov 19, 1965 · N2417X · Substantial damage NTSB SEA66F0176Accident · Minor injuriesClosedAeronca 7AC · Vancouver, WANov 17, 1965 · N81933 · Substantial damage NTSB SEA66I0034Incident · No injuriesClosedDouglas DC-8 · Mcchord Afb, WANov 15, 1965 · N8026U · No damage NTSB SEA66F0166Accident · Minor injuriesClosedPiper PA-18 · Waitsburg, WANov 13, 1965 · N1265A · Substantial damage NTSB SEA66D0162Accident · No injuriesClosedCessna 140A · Seattle, WANov 13, 1965 · N358TA · Substantial damage NTSB SEA66A0031Accident · No injuriesClosedHiller UH-12B · Federal Way, WANov 11, 1965 · N7212H · Substantial damage NTSB SEA66F0158Accident · No injuriesClosedPiper PA-18 · White Swan, WANov 9, 1965 · N1323A · Destroyed NTSB SEA66F0163Accident · Serious injuriesClosedErco 415C · Coupeville, WAOct 31, 1965 · N99300 · Destroyed NTSB SEA66F0151Accident · No injuriesClosedBeechcraft D-17S · Tacoma, WAOct 31, 1965 · N9000C · Substantial damage NTSB SEA66F0185Accident · Serious injuriesClosedStinson HW-75 · Port Orchard, WAOct 26, 1965 · N22511 · Substantial damage NTSB SEA66F0152Accident · No injuriesClosedCessna 170B · Silverdale, WAOct 13, 1965 · N3122A · Substantial damage NTSB SEA66F0145Accident · Serious injuriesClosedLuscombe 8A · Goldbar, WAOct 11, 1965 · N1157K · Destroyed NTSB SEA66A0025Accident · 1 fatalClosedCessna 172 · Puyallup, WAOct 10, 1965 · N5724A · Destroyed NTSB SEA66A0024Accident · 2 fatalClosedPiper PA-28 · Enumclaw, WAOct 8, 1965 · N8662W · Destroyed NTSB SEA66F0157Accident · No injuriesClosedCessna 310C · Pasco, WAOct 6, 1965 · N6675B · Substantial damage NTSB SEA66D0150Accident · No injuriesClosedErcoupe 415-C · Anacortes, WAOct 1, 1965 · N3572H · Substantial damage