Skip to content

NTSB investigations, 1972, WA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year

19632026

NTSB investigations, 1972, WA per year, 1963–2026: 4,814 cases
1963	1
1964	110
1965	131
1966	140
1967	159
1968	125
1969	116
1970	118
1971	86
1972	107
1973	104
1974	109
1975	129
1976	117
1977	104
1978	118
1979	118
1980	107
1981	102
1982	95
1983	101
1984	89
1985	73
1986	100
1987	79
1988	80
1989	76
1990	78
1991	94
1992	79
1993	69
1994	67
1995	73
1996	65
1997	62
1998	67
1999	68
2000	67
2001	66
2002	66
2003	74
2004	75
2005	59
2006	49
2007	53
2008	58
2009	58
2010	51
2011	58
2012	54
2013	37
2014	47
2015	36
2016	32
2017	39
2018	47
2019	37
2020	28
2021	41
2022	35
2023	36
2024	29
2025	37
2026	29

Where

Latest cases

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 year(c."eventDate") = 1972 AND 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 year(c.\"eventDate\") = 1972
    AND 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 year(c."eventDate") = 1972
  AND 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 SEA73DYE23Accident · Minor injuriesClosedRyan ST-3KR · Snohomish, WADec 24, 1972 · N57185 · Substantial damage NTSB SEA73FYG21Accident · 2 fatalClosedSikorsky S-61A · Chelan, WADec 14, 1972 · N318Y · Destroyed NTSB SEA73FYE22Accident · Minor injuriesClosedCessna 150 · Renton, WADec 8, 1972 · N3230J · Substantial damage NTSB SEA73ASO13Accident · 1 fatalClosedLuscombe 8A · Ellensburg, WANov 28, 1972 · N1170B · Destroyed NTSB SEA73FYE21Accident · Minor injuriesClosedCessna T337D · Kent, WANov 27, 1972 · N85866 · Substantial damage NTSB SEA73FYE20Accident · No injuriesClosedPiper PA-28 · Monroe, WANov 23, 1972 · N9694W · Substantial damage NTSB SEA73ASO12Accident · 3 fatalClosedPiper PA-28 · Brinnon, WANov 15, 1972 · N1964T · Destroyed NTSB SEA73DYG20Accident · Minor injuriesClosedCessna 182 · Republic, WANov 13, 1972 · N7211E · Substantial damage NTSB SEA73FYE19Accident · No injuriesClosedSwift GC-1B · Snohomish, WANov 12, 1972 · N78165 · Substantial damage NTSB SEA73FYE18Accident · Serious injuriesClosedCessna 172 · Longmire, WANov 12, 1972 · N1837Y · Destroyed NTSB SEA73FYG19Accident · No injuriesClosedCessna 150 · Spokane, WANov 10, 1972 · N5527G · Substantial damage NTSB SEA73DYG18Accident · No injuriesClosedRobertson 182J · Connell, WAOct 25, 1972 · N3392F · Substantial damage NTSB SEA73DYG16Accident · No injuriesClosedStinson 108-2 · Republic, WAOct 23, 1972 · N201C · Substantial damage NTSB SEA73DYG15Accident · No injuriesClosedPiper PA-22 · Moses Lake, WAOct 13, 1972 · N8143D · Substantial damage NTSB SEA73DYE17Accident · No injuriesClosedCessna 210 · Bellingham, WAOct 10, 1972 · N9557T · Substantial damage NTSB SEA73ASO09Accident · 1 fatalClosedPiper PA-23 · Dixie, WAOct 10, 1972 · N6707Y · Destroyed NTSB SEA73AS007Accident · 2 fatalClosedBeech D55 · Mansfield, WASep 24, 1972 · N7705R · Destroyed NTSB SEA73FYG13Accident · 1 fatalClosedBell 47-G2A · Selah, WASep 23, 1972 · N73284 · Substantial damage NTSB SEA73FYE15Accident · Serious injuriesClosedHughes 269A · Elma, WASep 17, 1972 · N8914F · Substantial damage NTSB SEA73DYE16Accident · No injuriesClosedAmer Avco AA1A · Oak Harbor, WASep 17, 1972 · N6372L · Substantial damage NTSB SEA73FYE14Accident · Minor injuriesClosedPiper PA-32 · Olympia, WASep 11, 1972 · N4281R · Substantial damage NTSB SEA73AS005Accident · 5 fatalClosedPiper PA-32 · Ryderwood, WASep 8, 1972 · N3600W · Destroyed NTSB SEA73FYE12Accident · Serious injuriesClosedHugo R & K Spcl · Puyallup, WASep 2, 1972 · N115R · Destroyed NTSB SEA73DYE13Accident · No injuriesClosedPiper PA-28R · Roche Harbor, WASep 1, 1972 · N4959J · Substantial damage NTSB SEA73FYC06Accident · Serious injuriesClosedWaco UPF-7 · Vancouver, WAAug 19, 1972 · N29949 · Substantial damage NTSB SEA73DYE11Accident · Serious injuriesClosedAeronca 11AC · Edmonds, WAAug 18, 1972 · N4495E · Minor damage NTSB SEA73DYG11Accident · No injuriesClosedCessna 120 · Rockford, WAAug 14, 1972 · N77336 · Substantial damage NTSB SEA73DYG12Accident · No injuriesClosedStinson 108 · Connell, WAAug 12, 1972 · N217C · Substantial damage NTSB SEA73DYG10Accident · No injuriesClosedSnow S-2R · Wiley City, WAAug 12, 1972 · N1763S · Substantial damage NTSB SEA73FYE10Accident · No injuriesClosedBucker Jungmn · Welcome, WAAug 6, 1972 · N121U · Substantial damage NTSB SEA73AS003Accident · 5 fatalClosedCessna 170B · Issaquah, WAAug 6, 1972 · N4617C · Destroyed NTSB SEA73DTI06Accident · No injuriesClosedCessna 180D · Fort Shaw, WAAug 5, 1972 · N6418X · Substantial damage NTSB SEA73FYG08Accident · Serious injuriesClosedStinson 108-2 · Asotin, WAAug 3, 1972 · N9572K · Destroyed NTSB SEA73DYG07Accident · No injuriesClosedPiper PA-22 · Ellisford, WAJul 27, 1972 · N2618P · Substantial damage NTSB SEA73DYG06Accident · No injuriesClosedConvair PB4Y-2 · Wenatchee, WAJul 27, 1972 · N6816D · Destroyed NTSB SEA73FYE08Accident · Minor injuriesClosedBellanca 14-193 · Kelso, WAJul 26, 1972 · N8531R · 2 aircraft · Substantial damage NTSB SEA73DYE09Accident · Serious injuriesClosedJeannie TWO · Arlington, WAJul 26, 1972 · N6284 · Substantial damage NTSB SEA73FYE05Accident · No injuriesClosedHiller Acft FH1100 · Skykomish, WAJul 21, 1972 · N5044F · Substantial damage NTSB SEA73FYE07Accident · Minor injuriesClosedBensen B8M · Olympia, WAJul 20, 1972 · N3685 · Substantial damage NTSB SEA73DYG05Accident · Minor injuriesClosedPiper PA-11 · Wapato, WAJul 20, 1972 · N4930H · Substantial damage NTSB SEA73DYE06Accident · No injuriesClosedKaman K-600 · Toutle, WAJul 20, 1972 · N2848J · Substantial damage NTSB SEA73AS001Accident · No injuriesClosedHiller Acft FH1100 · North Bend, WAJul 19, 1972 · N590FH · Substantial damage NTSB SEA73DYG04Accident · Minor injuriesClosedPiper PA-25 · Othello, WAJul 15, 1972 · N8804L · Substantial damage NTSB SEA73DYG03Accident · No injuriesClosedGrumman G-164A · Touchet, WAJul 14, 1972 · N7372 · Substantial damage NTSB SEA73DYC02Accident · Minor injuriesClosedPiper PA-22 · Dallesport, WAJul 13, 1972 · N9199D · Substantial damage NTSB SEA73DYE03Accident · No injuriesClosedPiper PA-28 · Vashon Hghts, WAJul 10, 1972 · N5725W · Substantial damage NTSB SEA73FYE02Accident · Serious injuriesClosedCessna 182 · Bellevue, WAJul 9, 1972 · N5452B · Substantial damage NTSB SEA73DYG09Accident · No injuriesClosedBell 47G3B2 · Molsen, WAJul 8, 1972 · N7825S · Substantial damage NTSB SEA73DYG02Accident · No injuriesClosedBell 47G-2 · Twisp, WAJul 7, 1972 · N6717D · Substantial damage NTSB SEA72FYE36Accident · No injuriesClosedStinson 108 · Seattle, WAJul 7, 1972 · N97909 · Substantial damage