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 SEA70D0034Accident · Serious injuriesClosedBell 47G-2 · Centralia, WAMay 18, 1969 · N2498B · Destroyed NTSB SEA69A0056Accident · 4 fatalClosedCessna 177 · Wenatchee, WAMay 17, 1969 · N29649 · Destroyed NTSB SEA69D0261Accident · No injuriesClosedStinson 108-2 · Bellevue, WAMay 15, 1969 · N9714K · Substantial damage NTSB SEA69D0267Incident · No injuriesClosedCessna 182J · Wenatchee, WAMay 9, 1969 · N3402F · No damage NTSB SEA69D0264Accident · Minor injuriesClosedGrumman TBM · Sumas, WAMay 9, 1969 · CF-KCJ · Substantial damage NTSB SEA69D0260Accident · No injuriesClosedLuscombe 8A · Alderwd Mnor, WAApr 30, 1969 · N71715 · Substantial damage NTSB OAK70A0002Accident · 3 fatalClosedCessna 206 · Hyak, WAApr 29, 1969 · N8714Z · Destroyed NTSB SEA69D0231Accident · No injuriesClosedPiper PA-28R · Friday Harbr, WAApr 26, 1969 · N9448N · Substantial damage NTSB SEA69D0246Accident · No injuriesClosedCessna 172 · Waterville, WAApr 25, 1969 · N8602B · Substantial damage NTSB SEA69D0250Accident · No injuriesClosedCessna 172 · Maple Valley, WAApr 24, 1969 · N8295B · Substantial damage NTSB SEA69F0240Accident · No injuriesClosedPiper PA-28 · Enumclaw, WAApr 21, 1969 · N4910J · Substantial damage NTSB SEA69D0241Accident · Minor injuriesClosedKaman H-43A · Castle Rock, WAApr 16, 1969 · N2849J · Destroyed NTSB SEA69D0216Accident · No injuriesClosedCessna 210G · Palouse, WAApr 13, 1969 · N5918F · Substantial damage NTSB SEA69F0238Accident · Minor injuriesClosedCessna 150 · Everett, WAApr 12, 1969 · N50918 · Destroyed NTSB SEA69D0266Accident · No injuriesClosedCessna 140 · Yale, WAApr 12, 1969 · N90021 · Substantial damage NTSB SEA69F0226Accident · Minor injuriesClosedCessna 150H · Fall City, WAApr 10, 1969 · N6984S · Substantial damage NTSB SEA69A0051Accident · 3 fatalClosedBeech 35 · Albion, WAApr 7, 1969 · N2875V · Destroyed NTSB SEA69D0234Accident · No injuriesClosedPiper PA-20 · Wilbur, WAApr 3, 1969 · N7666K · Substantial damage NTSB SEA69D0228Accident · No injuriesClosedPiper PA-25 · Pomeroy, WAApr 3, 1969 · N7478Z · Substantial damage NTSB SEA69D0227Accident · No injuriesClosedPiper PA-20 · Chehalis, WAMar 30, 1969 · N7028K · Substantial damage NTSB SEA69F0212Accident · Serious injuriesClosedCessna 150 · Kittitas, WAMar 26, 1969 · N7252S · Destroyed NTSB SEA69D0220Accident · No injuriesClosedGrumman G-164 · Colfax, WAMar 26, 1969 · N702Y · Substantial damage NTSB SEA69D0221Accident · No injuriesClosedCessna 150 · Pullman, WAMar 25, 1969 · N8974S · Substantial damage NTSB SEA69D0207Accident · No injuriesClosedBeech A23 · Tacoma, WAMar 25, 1969 · N1472L · Substantial damage NTSB SEA69A0050Accident · 3 fatalClosedCessna 172I · Spokane, WAMar 22, 1969 · N8497L · Destroyed NTSB SEA69D0218Accident · No injuriesClosedCessna 150G · Vancouver, WAMar 16, 1969 · N3423J · Substantial damage NTSB SEA69F0215Accident · No injuriesClosedCessna 150F · Orchards, WAMar 14, 1969 · N7854F · Substantial damage NTSB SEA69F0213Accident · No injuriesClosedCessna 182 · Woodland, WAMar 9, 1969 · N9886Z · Substantial damage NTSB SEA69A0048Accident · 1 fatalClosedBreguet 905A · Issaquah, WAMar 9, 1969 · N280M · Destroyed NTSB SEA69D0202Accident · No injuriesClosedPiper PA-25 · Pomeroy, WAMar 8, 1969 · N7263Z · Substantial damage NTSB SEA69F0208Accident · Serious injuriesClosedLaister LK-10A · Dallesport, WAMar 2, 1969 · N49911 · Destroyed NTSB SEA69F0196Accident · No injuriesClosedCessna 185 · Trout Lake, WAMar 1, 1969 · N9845X · Substantial damage NTSB SEA69D0190Accident · Minor injuriesClosedCessna 150G · Ephrata, WAFeb 27, 1969 · N3902J · Substantial damage NTSB SEA69D0194Accident · No injuriesClosedBeech A23-19 · Moses Lake, WAFeb 24, 1969 · N6909Q · Substantial damage NTSB SEA69F0192Accident · Minor injuriesClosedCessna 172 · Port Orchard, WAFeb 21, 1969 · N2459Y · Substantial damage NTSB SEA69D0193Accident · No injuriesClosedCessna 120 · Blaine, WAFeb 19, 1969 · N2818N · Substantial damage NTSB SEA69D0183Accident · No injuriesClosedBell 47G-2 · Chelan, WAFeb 14, 1969 · N6712D · Substantial damage NTSB SEA69F0198Accident · No injuriesClosedCessna 150 · Chehalis, WAFeb 13, 1969 · N3198J · Substantial damage NTSB SEA69D0185Accident · Minor injuriesClosedPiper PA-18A · Othello, WAFeb 9, 1969 · N6191D · Substantial damage NTSB SEA69A0046Accident · Serious injuriesClosedBoeing B-727 · Seattle, WAFeb 9, 1969 · N7056U · No damage NTSB SEA69D0191Accident · No injuriesClosedCessna 172B · Shelton, WAFeb 6, 1969 · N7996X · Substantial damage NTSB SEA69A0045Accident · 10 fatalClosedBeech C-45H · Port Angeles, WAFeb 5, 1969 · N8181H · Destroyed NTSB SEA69F0195Accident · No injuriesClosedCessna T210F · Vancouver, WAFeb 3, 1969 · N6143R · Substantial damage NTSB SEA69D0178Accident · No injuriesClosedCessna 172 · Shelton, WAJan 18, 1969 · N1165F · Substantial damage NTSB SEA69D0179Accident · No injuriesClosedCessna 150 · Silverdale, WAJan 17, 1969 · N6798S · Substantial damage NTSB SEA69I0041Incident · No injuriesClosedBoeing 727 · Seattle, WAJan 13, 1969 · N8167G · Minor damage NTSB SEA69F0182Accident · Serious injuriesClosedPietenpol Parasl · Spanaway, WAJan 11, 1969 · N9258 · Destroyed NTSB SEA69D0175Accident · No injuriesClosedCessna 150 · Bellingham, WAJan 2, 1969 · N6264T · Substantial damage NTSB SEA69F0165Accident · No injuriesClosedHughes 269A · Renton, WADec 28, 1968 · N8780F · Substantial damage NTSB SEA69D0155Accident · No injuriesClosedPiper PA-28 · Spokane, WADec 15, 1968 · N8283W · Substantial damage