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 SEA66F0136Accident · No injuriesClosedGreat Lakes 2T-1E · Spokane, WASep 30, 1965 · N11333 · Substantial damage NTSB SEA66F0140Accident · No injuriesClosedCessna 175 · Kent, WASep 25, 1965 · N9356B · Substantial damage NTSB SEA66D0139Accident · No injuriesClosedCessna 140 · Everett, WASep 24, 1965 · N89983 · Substantial damage NTSB SEA66F0126Accident · No injuriesClosedCessna 337 · Spokane, WASep 17, 1965 · N2181X · Substantial damage NTSB SEA66F0134Accident · Minor injuriesClosedTaylorcraft DC-65 · Hooper, WASep 13, 1965 · N36341 · Destroyed NTSB SEA66F0130Accident · Minor injuriesClosedCessna 150 · Mazama, WASep 12, 1965 · N8210S · Destroyed NTSB SEA66D0138Accident · No injuriesClosedPiper PA-22 · Port Angeles, WASep 9, 1965 · N4780Z · Destroyed NTSB SEA66A0019Accident · 1 fatalClosedSmith Mini DSA-1 · Puyallup, WASep 6, 1965 · N93139 · Destroyed NTSB SEA66F0132Accident · No injuriesClosedCessna 180 · Orchards, WASep 5, 1965 · N2468C · Substantial damage NTSB SEA66D0110Accident · No injuriesClosedAeronca 7CCM · Bremerton, WASep 3, 1965 · N6436C · Substantial damage NTSB SEA66F0115Accident · No injuriesClosedAeronca 11AC · Bellevue, WAAug 22, 1965 · N9500E · Substantial damage NTSB SEA66A0016Accident · No injuriesClosedHughes 269A · Granite Flls, WAAug 22, 1965 · N8772F · Substantial damage NTSB SEA66D0101Accident · Minor injuriesClosedCessna 150 · Dalkena, WAAug 21, 1965 · N6420T · Substantial damage NTSB SEA66A0014Accident · 1 fatalClosedHelio Acft H-391B · Mead, WAAug 19, 1965 · N4132D · Destroyed NTSB SEA66F0100Accident · No injuriesClosedCessna 172 · Othello, WAAug 18, 1965 · N8613U · Substantial damage NTSB SEA66F0090Accident · No injuriesClosedPiper PA-25 · Othello, WAAug 18, 1965 · N6900Z · Substantial damage NTSB SEA66F0092Accident · No injuriesClosedCessna 172 · Kent, WAAug 15, 1965 · N9739T · Substantial damage NTSB SEA66A0010Accident · 1 fatalClosedCessna 180A · 8s Mt Vernon, WAAug 11, 1965 · N9561B · Destroyed NTSB SEA66F0085Accident · Minor injuriesClosedLuscombe 8A · Deer Park, WAAug 7, 1965 · N25229 · Substantial damage NTSB SEA66F0086Accident · No injuriesClosedPiper PA-28 · Walla Walla, WAAug 6, 1965 · N7902W · Substantial damage NTSB SEA66D0074Accident · No injuriesClosedGlobe GC-1B · Seattle, WAAug 6, 1965 · N80659 · Substantial damage NTSB SEA66F0071Accident · No injuriesClosedPiper PA-22 · Spokane, WAAug 5, 1965 · N6121D · Substantial damage NTSB SEA66A0006Accident · Serious injuriesClosedHiller UH-12E · 20sw Easton, WAAug 3, 1965 · N9732C · Destroyed NTSB SEA66F0123Accident · No injuriesClosedPiper PA-22 · Bellevue, WAAug 2, 1965 · N970A · Substantial damage NTSB SEA66A0007Accident · No injuriesClosedBell 47G-3B · 16sw Easton, WAAug 1, 1965 · N73230 · Substantial damage NTSB SEA66F0088Accident · Serious injuriesClosedBoeing A75 · Othello, WAJul 31, 1965 · N47659 · Destroyed NTSB SEA66D0070Accident · No injuriesClosedCessna 180S · Kenmore, WAJul 31, 1965 · N8627X · Substantial damage NTSB SEA66D0114Accident · No injuriesClosedStinson 108 · Sultan, WAJul 30, 1965 · N8760K · Substantial damage NTSB SEA66D0084Accident · No injuriesClosedCessna 170A · Tieton, WAJul 30, 1965 · N9076A · Substantial damage NTSB SEA66F0098Accident · No injuriesClosedMooney M20 · Vancouver, WAJul 29, 1965 · N851B · Substantial damage NTSB SEA66D0053Accident · No injuriesClosedPiper PA-23 · Wenatchee, WAJul 20, 1965 · N4850P · Substantial damage NTSB SEA66F0089Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 16, 1965 · N6607Z · Substantial damage NTSB SEA66F0060Accident · No injuriesClosedBeechcraft A-23 · Tacoma, WAJul 13, 1965 · N3507R · Substantial damage NTSB SEA66F0044Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 13, 1965 · N63522 · Substantial damage NTSB SEA66A0004Accident · 1 fatalClosedPiper PA-18 · Snohomish, WAJul 12, 1965 · N1355C · Destroyed NTSB SEA66F0052Accident · Serious injuriesClosedPiper PA18A · Sunnyside, WAJul 10, 1965 · N7573D · Destroyed NTSB SEA66D0031Accident · No injuriesClosedCessna 182 · Walla Walla, WAJul 9, 1965 · N6119B · Substantial damage NTSB SEA66D0026Accident · No injuriesClosedPiper PA-28 · Bellvue, WAJul 7, 1965 · N7394W · Substantial damage NTSB SEA66F0063Accident · No injuriesClosedPiper PA-22 · Underwood, WAJul 5, 1965 · N8130C · Substantial damage NTSB SEA66F0025Accident · No injuriesClosedBeechcraft 35-B33 · Everett, WAJul 4, 1965 · N1523S · Substantial damage NTSB SEA66D0054Accident · No injuriesClosedBeechcraft K35 · Blaxely Isl., WAJul 3, 1965 · N3062C · Substantial damage NTSB SEA66D0018Accident · No injuriesClosedCessna 172D · Latah, WAJul 3, 1965 · N2180Y · Substantial damage NTSB SEA66F0056Accident · No injuriesClosedCessna 172 · Vancouver, WAJul 2, 1965 · N8230U · Substantial damage NTSB SEA66F0093Accident · Serious injuriesClosedPhillips CT-2 · Vancouver, WAJun 27, 1965 · N19989 · Substantial damage NTSB SEA66F0006Accident · No injuriesClosedPiper PA-18A · Sunnyside, WAJun 27, 1965 · N2889P · Substantial damage NTSB SEA66D0030Accident · No injuriesClosedPiper PA-22 · Rosalia, WAJun 26, 1965 · N2603P · Substantial damage NTSB SEA66F0028Accident · No injuriesClosedCessna 210 · Seattle, WAJun 25, 1965 · N9502T · Substantial damage NTSB SEA66F0024Accident · No injuriesClosedBeechcraft 23 · Anacortes, WAJun 23, 1965 · N8719M · Substantial damage NTSB SEA66D0010Accident · No injuriesClosedCessna 150 · Everett, WAJun 21, 1965 · N2023Z · Substantial damage NTSB SEA66F0021Accident · No injuriesClosedCessna 120 · Brewster, WAJun 19, 1965 · N2792N · Substantial damage