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 SEA70F0097Accident · Minor injuriesClosedKaman HUK-1 · Enumclaw, WAOct 4, 1969 · N11012 · Substantial damage NTSB SEA70D0133Accident · No injuriesClosedSchemp SHK-1 · Easton, WAOct 4, 1969 · N1582 · Substantial damage NTSB SEA70D0128Accident · No injuriesClosedChampion 7GCAA · Easton, WAOct 4, 1969 · N9528S · Substantial damage NTSB SEA70D0099Accident · No injuriesClosedCessna U206 · Sunnyside, WAOct 3, 1969 · N2191F · Substantial damage NTSB SEA70F0108Accident · 1 fatalClosedCessna A185E · Kent, WAOct 2, 1969 · N2726J · Destroyed NTSB SEA70F0106Accident · Minor injuriesClosedCessna 150 · Takoma, WASep 24, 1969 · N3538J · Substantial damage NTSB SEA70A0013Accident · 1 fatalClosedPiper PA-30 · Tacoma, WASep 22, 1969 · N8504Y · Destroyed NTSB SEA70A0012Accident · 2 fatalClosedCessna 177A · Spokane, WASep 21, 1969 · N30397 · Destroyed NTSB SEA70D0108Accident · No injuriesClosedCessna 170 · Alderwod Mnr, WASep 19, 1969 · N2534V · Substantial damage NTSB SEA70D0087Accident · No injuriesClosedCessna T-50 · Everett, WASep 14, 1969 · N1261N · Substantial damage NTSB SEA70D0085Accident · No injuriesClosedLuscombe 8A · Snohomish, WASep 7, 1969 · N28436 · Substantial damage NTSB SEA70D0100Accident · No injuriesClosedCessna 150 · Waterville, WASep 5, 1969 · N60886 · Substantial damage NTSB SEA70D0083Accident · No injuriesClosedCessna 150H · Colfax, WASep 1, 1969 · N6585S · Substantial damage NTSB SEA70F0122Accident · No injuriesClosedAlon A-2 · Vancouver, WAAug 31, 1969 · N5632F · Substantial damage NTSB SEA70F0075Accident · No injuriesClosedPiper PA-28 · Lester, WAAug 30, 1969 · N2839R · Substantial damage NTSB SEA70F0054Accident · No injuriesClosedCessna 140 · Everett, WAAug 30, 1969 · N89183 · Substantial damage NTSB SEA70F0070Accident · Minor injuriesClosedStinson 10A · Oroville, WAAug 24, 1969 · CF-WCJ · Substantial damage NTSB SEA70F0089Accident · Minor injuriesClosedBullock Curtis · Spokane, WAAug 23, 1969 · N5704N · Substantial damage NTSB SEA70D0086Accident · No injuriesClosedCessna 150 · Tacoma, WAAug 21, 1969 · N6533F · Substantial damage NTSB SEA70D0084Accident · Minor injuriesClosedCallair A-3 · Goldendale, WAAug 18, 1969 · N2911V · Substantial damage NTSB SEA70D0040Accident · No injuriesClosedTaylorcraft BC-65 · Colville, WAAug 17, 1969 · N21223 · Substantial damage NTSB SEA70D0098Accident · No injuriesClosedCessna 170B · Monroe, WAAug 16, 1969 · N4463B · Substantial damage NTSB SEA70D0067Accident · No injuriesClosedCessna 172 · Electric Cty, WAAug 14, 1969 · N5741A · Substantial damage NTSB SEA70D0096Accident · Minor injuriesClosedCessna 150 · Sultan, WAAug 11, 1969 · N3052S · Destroyed NTSB SEA70D0064Accident · No injuriesClosedPiper PA-25 · Othello, WAAug 10, 1969 · N4359Y · Substantial damage NTSB SEA70F0077Accident · Serious injuriesClosedPuss Moth 80A · Tekoa, WAAug 3, 1969 · N223EC · Substantial damage NTSB SEA70D0053Accident · No injuriesClosedHughes 269B · Castle Mt, WAJul 28, 1969 · N9432F · Substantial damage NTSB SEA70D0095Accident · No injuriesClosedBoeing A75N1 · Granger, WAJul 26, 1969 · N53098 · Substantial damage NTSB SEA70F0050Accident · No injuriesClosedBeech A35 · Seattle, WAJul 22, 1969 · N3940 · Substantial damage NTSB SEA70D0035Accident · No injuriesClosedGrumman G-164 · Walla Walla, WAJul 18, 1969 · N747Y · Substantial damage NTSB SEA70A0002Accident · 2 fatalClosedGlobe GC-1B · Winlock, WAJul 10, 1969 · N78155 · Destroyed NTSB SEA70D0025Accident · No injuriesClosedErco 415-C · Puyallup, WAJul 5, 1969 · N2741H · Substantial damage NTSB SEA70F0049Accident · 1 fatalClosedPitts JC-1 · Tacoma, WAJul 4, 1969 · N68652 · Destroyed NTSB SEA70D0023Accident · Minor injuriesClosedThorp T-18 · Puyallup, WAJul 1, 1969 · N3715 · Substantial damage NTSB SEA70D0024Accident · No injuriesClosedPiper PA-22 · Bellevue, WAJun 29, 1969 · N2827Z · Substantial damage NTSB SEA69A0062Accident · 3 fatalClosedConvair 880 · Moses Lake, WAJun 24, 1969 · JA-8028 · Destroyed NTSB SEA70F0033Accident · No injuriesClosedCessna 182 · Blakeley Isl, WAJun 20, 1969 · N3149Q · Destroyed NTSB SEA69A0061Accident · 2 fatalClosedBeech 99 · Pasco, WAJun 20, 1969 · N2550A · Destroyed NTSB SEA70F0019Accident · No injuriesClosedBell 47G · Stanwood, WAJun 18, 1969 · N964B · Substantial damage NTSB SEA70D0016Accident · Minor injuriesClosedCessna 140 · Alderwood M, WAJun 13, 1969 · N76756 · Substantial damage NTSB SEA70D0007Accident · No injuriesClosedPiper PA-25 · Pasco, WAJun 11, 1969 · N6263Z · Substantial damage NTSB SEA69A0059Accident · 3 fatalClosedAeronca 7AC · Snohomish, WAJun 2, 1969 · N85071 · 2 aircraft · Destroyed NTSB SEA70D0012Accident · No injuriesClosedBeech 35 · Lynden, WAJun 1, 1969 · N3786N · Substantial damage NTSB SEA70D0004Accident · No injuriesClosedCessna 188 · Sunnyside, WAJun 1, 1969 · N5550S · Substantial damage NTSB SEA70D0003Accident · No injuriesClosedBell 47G · Ritzville, WAJun 1, 1969 · N979B · Substantial damage NTSB SEA69D0268Accident · No injuriesClosedPiper PA-18 · Oraville, WAJun 1, 1969 · N1870A · Substantial damage NTSB SEA70F0005Accident · No injuriesClosedAeronca 7AC · Kent, WAMay 31, 1969 · N2943E · Substantial damage NTSB SEA70D0069Accident · No injuriesClosedPiper PA-25 · Dallesport, WAMay 29, 1969 · N6294Z · Substantial damage NTSB SEA69F0255Accident · 1 fatalClosedPiper PA-18A · Ralston, WAMay 26, 1969 · N3798P · Destroyed NTSB SEA69A0057Accident · 1 fatalClosedAeronca 65-TC · Orchards, WAMay 20, 1969 · N27396 · Destroyed