NTSB investigations, 1969, RI

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

19642026

NTSB investigations, 1969, RI per year, 1964–2026: 327 cases
1964	14
1965	7
1966	15
1967	12
1968	7
1969	9
1970	9
1971	9
1972	12
1973	5
1974	10
1975	6
1976	11
1977	5
1978	11
1979	3
1980	11
1981	5
1982	6
1983	7
1984	8
1985	7
1986	5
1987	6
1988	9
1989	4
1990	6
1991	8
1992	2
1993	8
1994	5
1995	5
1996	5
1997	3
1998	1
1999	2
2000	4
2001	3
2002	5
2003	7
2004	3
2005	1
2006	3
2007	4
2008	8
2009	1
2010	1
2011	1
2012	2
2014	1
2015	2
2016	6
2017	2
2019	1
2020	2
2021	1
2022	1
2024	3
2025	2
2026	5

Where

Open the map

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") = 1969 AND c."eventStateOrRegion" = 'RI' 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\") = 1969
    AND c.\"eventStateOrRegion\" = 'RI' 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") = 1969
  AND c."eventStateOrRegion" = 'RI' 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 NYC70F0249Accident · No injuriesClosedStinson 108-1 · Warwick, RIDec 25, 1969 · N400T · Substantial damage NTSB NYC70F0186Accident · No injuriesClosedBell 47G-4 · E Providence, RIOct 16, 1969 · N73943 · Substantial damage NTSB NYC70A0035Accident · No injuriesClosedN.American NA-265 · Westerly, RISep 18, 1969 · N881MC · Substantial damage NTSB NYC70A0020Accident · 1 fatalClosedBeech E35 · Block Island, RIAug 6, 1969 · N8818A · Destroyed NTSB NYC70D0041Accident · No injuriesClosedBeech C55 · Block Island, RIJun 26, 1969 · N9562Q · Substantial damage NTSB NYC70D0016Accident · Minor injuriesClosedCessna 150G · Coventry, RIMay 30, 1969 · N3688J · Destroyed NTSB NYC69F0441Accident · No injuriesClosedCessna 150F · Coventry, RIMay 13, 1969 · N8066S · Substantial damage NTSB NYC69A0095Accident · 5 fatalClosedCessna 150H · Middletown, RIApr 23, 1969 · N23140 · 2 aircraft · Destroyed NTSB NYC69A0083Accident · No injuriesClosedPiper PA-30B · Warwick, RIFeb 26, 1969 · N8555Y · Substantial damage