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 SEA79DYE45Accident · Minor injuriesClosedHughes 269B · Renton, WASep 15, 1979 · N9355K · Substantial damage NTSB SEA79DYE48Accident · Minor injuriesClosedGrum-Amer AA-5A · Friday Harbor, WASep 14, 1979 · N26832 · Destroyed NTSB SEA79DYE35Accident · No injuriesClosedPiper PA-28 · Lopez Island, WASep 8, 1979 · N75177 · Substantial damage NTSB SEA79FA057Accident · Serious injuriesClosedBeech D35 · Bellingham, WASep 7, 1979 · N249D · Substantial damage NTSB SEA79FA056Accident · Serious injuriesClosedHiller FH1100 · Arlington, WASep 6, 1979 · N377FH · Destroyed NTSB SEA79DYE42Accident · No injuriesClosedGreat Lakes Baby · Arlington, WAAug 31, 1979 · N8850 · Substantial damage NTSB SEA79FA055Accident · No injuriesClosedLear Jet 23 · Othello, WAAug 29, 1979 · N6GJ · Substantial damage NTSB SEA79FYE41Accident · No injuriesClosedCessna A185F · Renton, WAAug 28, 1979 · N9533H · Substantial damage NTSB SEA79FA052Accident · 5 fatalClosedPiper PA-32 · Maple Falls, WAAug 27, 1979 · CG-IMB · Destroyed NTSB SEA79DYE50Accident · Minor injuriesClosedDehavilland Moth · Martha Lake, WAAug 25, 1979 · N8722 · Substantial damage NTSB SEA79DYE47Accident · No injuriesClosedNavion A · Snohomish, WAAug 25, 1979 · N8750H · Substantial damage NTSB SEA79FA051Accident · Minor injuriesClosedMaule M-4 · Vancouver, WAAug 22, 1979 · N40332 · Substantial damage NTSB SEA79FYE43Accident · 1 fatalClosedZipper HH-1 · Everett, WAAug 15, 1979 · N2200Z · Destroyed NTSB SEA79FYP40Accident · No injuriesClosedCessna 172K · Deer Park, WAAug 13, 1979 · N46652 · Substantial damage NTSB SEA79DYE39Accident · Minor injuriesClosedBeech B24R · Burton, WAAug 11, 1979 · N4348W · Substantial damage NTSB SEA79FYE37Accident · No injuriesClosedBellanca 14-13 · Federal Way, WAAug 4, 1979 · N74353 · Destroyed NTSB SEA79FYE36Accident · No injuriesClosedCessna 180 · Auburn, WAAug 4, 1979 · N6014B · Substantial damage NTSB SEA79FYE38Accident · Serious injuriesClosedCessna 172N · Port Angeles, WAAug 3, 1979 · N733LC · Destroyed NTSB SEA79DYM56Accident · No injuriesClosedTailwind W-8 · Goldendale, WAAug 2, 1979 · N1416 · Substantial damage NTSB SEA79DYP39Accident · Minor injuriesClosedTaylorcraft DC-65 · Mead, WAJul 23, 1979 · N57833 · Substantial damage NTSB SEA79FYP37Accident · No injuriesClosedWaco YKS-6 · Pasco, WAJul 22, 1979 · N16512 · Substantial damage NTSB SEA79DYP38Accident · Minor injuriesClosedCessna 188B · Mattawa, WAJul 20, 1979 · N9845G · Substantial damage NTSB SEA79DYE32Accident · No injuriesClosedCessna 172M · Ocean Shores, WAJul 17, 1979 · N1169U · Substantial damage NTSB SEA79FYP35Accident · No injuriesClosedPiper PA-36 · Lind, WAJul 14, 1979 · N57591 · Substantial damage NTSB SEA79FYE31Accident · Minor injuriesClosedGlobe GC-1B · Puyallup, WAJul 13, 1979 · N80918 · Substantial damage NTSB SEA79DYM46Accident · No injuriesClosedCessna 182 · Vancouver, WAJul 11, 1979 · N735WR · Substantial damage NTSB SEA79DYE30Accident · No injuriesClosedNavion L-17 · Everett, WAJul 11, 1979 · N4755C · Substantial damage NTSB SEA79FYP34Accident · No injuriesClosedPiper PA-28 · Othello, WAJul 8, 1979 · N43097 · Substantial damage NTSB SEA79FA042Accident · 2 fatalClosedCessna 172M · Bremerton, WAJul 7, 1979 · N172KA · Destroyed NTSB SEA79FA043Accident · 2 fatalClosedAero Comdr 114 · Leavenworth, WAJul 6, 1979 · N5873N · Destroyed NTSB SEA79DYP33Accident · Minor injuriesClosedPiper PA-25 · Moses Lake, WAJul 6, 1979 · N4603Y · Substantial damage NTSB SEA79FYP31Accident · No injuriesClosedHiller Acft UH-12E · Quincy, WAJun 29, 1979 · N65048 · Substantial damage NTSB SEA79DYM46Accident · No injuriesClosedBell 47G-3B · Dallesport, WAJun 27, 1979 · N73234 · Substantial damage NTSB SEA79FYP30Accident · Minor injuriesClosedCessna 152 · Malaga, WAJun 26, 1979 · N757JM · Substantial damage NTSB SEA79FYE28Accident · No injuriesClosedPiper PA-28 · Federal Way, WAJun 24, 1979 · N44094 · Substantial damage NTSB SEA79FYM23Accident · Serious injuriesClosedCessna 172M · Vancouver, WAJun 21, 1979 · N1544V · Substantial damage NTSB SEA79DYP29Accident · No injuriesClosedCessna 337 · Wenatchee, WAJun 20, 1979 · N72377 · Substantial damage NTSB SEA79FYM39Accident · Minor injuriesClosedPiper PA-22 · Vancouver, WAJun 9, 1979 · N8540C · Substantial damage NTSB SEA79FA039Accident · 1 fatalClosedCessna T337F · Seattle, WAJun 8, 1979 · N6322S · Destroyed NTSB SEA79FA038Accident · No injuriesClosedCessna 402 · Wenatchee, WAJun 7, 1979 · N4549Q · Substantial damage NTSB SEA79DYP27Accident · No injuriesClosedCessna 150 · Garfield, WAJun 7, 1979 · N3312J · Substantial damage NTSB SEA79DYP28Accident · No injuriesClosedWeatherly 201A · Colville, WAJun 6, 1979 · N2933W · Substantial damage NTSB SEA79DYP26Accident · Minor injuriesClosedFlybaby 1 · Spangle, WAJun 3, 1979 · N2283Z · Substantial damage NTSB SEA79DYE25Accident · No injuriesClosedCessna 140 · Port Angeles, WAJun 3, 1979 · N2356V · Substantial damage NTSB SEA79DYE26Accident · No injuriesClosedLet Blanik L-13 · Issaquah, WAJun 2, 1979 · N93465 · Substantial damage NTSB SEA79FYP25Accident · Serious injuriesClosedCessna 188B · Patterson, WAMay 29, 1979 · N8017G · Substantial damage NTSB SEA79FA047Accident · 4 fatalClosedGrumman SCAN30 · Skykomish, WAMay 27, 1979 · N4451 · Destroyed NTSB SEA79DYE24Accident · No injuriesClosedCessna 177B · Mercer Island, WAMay 26, 1979 · N991MP · Substantial damage NTSB SEA79DYE23Accident · No injuriesClosedLake LA-4 · Bellingham, WAMay 23, 1979 · N2680P · Substantial damage NTSB SEA79FYP22Accident · No injuriesClosedCessna 150F · Mead, WAMay 22, 1979 · N3092X · Substantial damage