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 SEA70IS044Incident · No injuriesClosedBoeing 747 · Moses Lake, WAMay 24, 1970 · N7470 · Minor damage NTSB SEA70DWD16Accident · No injuriesClosedStearman PT-17 · Skykomish, WAMay 23, 1970 · N56909 · Destroyed NTSB SEA70DWD15Accident · Minor injuriesClosedRyan ST-3KR · Lacy, WAMay 23, 1970 · N56028 · Substantial damage NTSB SEA70DWD22Accident · No injuriesClosedWaco CTO · Mt.Vernon, WAMay 14, 1970 · N845V · Substantial damage NTSB SEA70AS041Accident · 1 fatalClosedCessna 150J · Wenatchee, WAMay 11, 1970 · N50493 · Substantial damage NTSB SEA70AS040Accident · 2 fatalClosedAeronca 7AC · Woodinville, WAMay 10, 1970 · N85445 · Destroyed NTSB SEA70FWD13Accident · No injuriesClosedBell 47-G2 · Maple Valley, WAMay 9, 1970 · N6141 · Substantial damage NTSB SEA70DWG14Accident · No injuriesClosedHelio Acft H-295 · Winthrop, WAMay 6, 1970 · N6327V · Substantial damage NTSB SEA70DWD14Accident · No injuriesClosedHughes 269B · Hamilton, WAMay 3, 1970 · N9408F · Substantial damage NTSB SEA70DWD11Accident · No injuriesClosedCessna 185D · Orcas, WAMay 2, 1970 · N1541F · Substantial damage NTSB SEA70FWG12Accident · No injuriesClosedCessna 150G · Wenatchee, WAMay 1, 1970 · N3694J · Substantial damage NTSB SEA70DWG10Accident · No injuriesClosedCessna 206 · Colfax, WAApr 25, 1970 · N3882G · Substantial damage NTSB SEA70DWD09Accident · No injuriesClosedErco 415-C · Puyallup, WAApr 16, 1970 · N2641H · Substantial damage NTSB SEA70AS038Accident · 2 fatalClosedLuscombe 8A · Vancouver, WAApr 12, 1970 · N2142K · Destroyed NTSB SEA70FWD08Accident · 1 fatalClosedBensen B-8 · Arlington, WAApr 5, 1970 · N7787 · Destroyed NTSB SEA70FWD07Accident · No injuriesClosedCessna 150 · Everett, WAMar 31, 1970 · N8063S · Substantial damage NTSB SEA70FWD06Accident · No injuriesClosedBeech 35 · Georgetown, WAMar 23, 1970 · N3164V · Substantial damage NTSB SEA70FWG06Accident · No injuriesClosedHughes 269B · Albion, WAMar 19, 1970 · N9539F · Substantial damage NTSB SEA70FWD10Accident · No injuriesClosedLuscombe 8A · Kent, WAMar 13, 1970 · N72037 · Substantial damage NTSB SEA70DWG05Accident · No injuriesClosedCessna 150 · Pomeroy, WAMar 13, 1970 · N5750E · Substantial damage NTSB SEA70AS036Accident · 3 fatalClosedMooney M20F · Cougar, WAMar 13, 1970 · N9072V · Destroyed NTSB SEA70DWD04Accident · No injuriesClosedCessna 120 · Auburn, WAFeb 28, 1970 · N77336 · Substantial damage NTSB SEA70DWD05Accident · No injuriesClosedBell 47G-2 · Rochester, WAFeb 25, 1970 · N2899B · Substantial damage NTSB SEA70FWG02Accident · No injuriesClosedHiller Acft UH-12E · Colfax, WAFeb 23, 1970 · N90465 · Substantial damage NTSB SEA70DWG03Accident · No injuriesClosedCessna 150J · Wenatchee, WAFeb 23, 1970 · N50949 · Substantial damage NTSB SEA70DW601Accident · No injuriesClosedPiper PA-18 · Rice, WAFeb 21, 1970 · N1194C · Substantial damage NTSB SEA70DWD03Accident · No injuriesClosedHughes 269B · Seattle, WAFeb 14, 1970 · N9337F · Substantial damage NTSB SEA70AS032Accident · 1 fatalClosedAeronca 7AC · Snohomish, WAFeb 8, 1970 · N83800 · 2 aircraft · Substantial damage NTSB SEA70AS029Accident · 1 fatalClosedLuscombe 8A · Mead, WAJan 31, 1970 · N71395 · Destroyed NTSB SEA70AS028Accident · 1 fatalClosedBeech A23-19 · Marysville, WAJan 20, 1970 · N4710J · Destroyed NTSB SEA70FWA01Accident · Serious injuriesClosedPiper PA-23 · Centerville, WAJan 19, 1970 · N4495P · Substantial damage NTSB SEA70FWD01Accident · No injuriesClosedCessna 150 · Snohomish, WAJan 18, 1970 · N2415J · Substantial damage NTSB SEA70F0136Accident · Serious injuriesClosedCessna 185 · North Bend, WADec 23, 1969 · N4519F · Substantial damage NTSB SEA70F0137Accident · Serious injuriesClosedPiper PA-28 · Bremerton, WADec 15, 1969 · N98296 · Substantial damage NTSB SEA70F0129Accident · Serious injuriesClosedCessna 150H · Spokane, WADec 15, 1969 · N22640 · Destroyed NTSB SEA70D0150Accident · No injuriesClosedAmerican AA-1 · Vancouver, WADec 14, 1969 · N5763L · Substantial damage NTSB SEA70I0024Incident · No injuriesClosedBoeing 747 · Renton, WADec 13, 1969 · N732PA · Minor damage NTSB SEA70F0138Accident · Minor injuriesClosedCessna 172 · Port Townsnd, WADec 10, 1969 · N8692U · Destroyed NTSB SEA70D0115Accident · No injuriesClosedAeronca 15AC · Mead, WANov 21, 1969 · N1458H · Substantial damage NTSB SEA70I0021Incident · No injuriesClosedFairchild F-27A · Pullman, WANov 17, 1969 · N755L · Minor damage NTSB SEA70A0022Accident · 1 fatalClosedCessna 150F · Cougar, WANov 17, 1969 · N8879G · Destroyed NTSB SEA70D0112Accident · No injuriesClosedCessna 180 · Seattle, WANov 15, 1969 · N7699A · Substantial damage NTSB SEA70D0116Accident · Minor injuriesClosedStinson 108-1 · Ellensburg, WANov 10, 1969 · N97963 · Destroyed NTSB SEA79FA059Accident · 1 fatalClosedCessna 140 · Lester, WANov 2, 1969 · N2050N · Destroyed NTSB SEA70F0119Accident · 2 fatalClosedBell 47G-2 · Loomis, WAOct 31, 1969 · N2803B · Destroyed NTSB SEA70F0110Accident · Minor injuriesClosedCessna 180 · Mountlake Tr, WAOct 27, 1969 · N1772C · Destroyed NTSB SEA70F0105Accident · No injuriesClosedCessna 172 · Auburn, WAOct 25, 1969 · N6064R · Substantial damage NTSB SEA70D0109Accident · No injuriesClosedMonocoupe 110 · Monroe, WAOct 19, 1969 · N18642 · Substantial damage NTSB SEA70D0102Accident · No injuriesClosedCessna 210E · Wenatchee, WAOct 18, 1969 · N4969U · Substantial damage NTSB SEA70A0015Accident · 1 fatalClosedErco 415-D · Issaquah, WAOct 12, 1969 · N2137H · Destroyed