Major NTSB investigations, 1968

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 per year

19622026

Major NTSB investigations, 1968 per year, 1962–2026: 654 cases
1968	5
1969	13
1970	12
1971	12
1972	11
1973	10
1974	9
1975	11
1976	8
1977	7
1978	10
1979	11
1980	9
1981	11
1982	9
1983	19
1984	25
1985	31
1986	48
1987	30
1988	17
1989	24
1990	12
1991	14
1992	11
1993	14
1994	16
1995	7
1996	12
1997	10
1998	7
1999	8
2000	14
2001	13
2002	6
2003	10
2004	17
2005	18
2006	11
2007	12
2008	15
2009	8
2010	5
2011	9
2012	1
2013	9
2014	4
2015	6
2016	4
2017	4
2018	3
2019	11
2020	1
2021	1
2022	3
2023	3
2024	2
2025	9
2026	2

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") = 1968 AND (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') 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\") = 1968
    AND (c.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
  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") = 1968
  AND (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
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 DCA69A0010Accident · 27 fatalClosedConvair 580 · Chicago, ILDec 27, 1968 · N2045 · Destroyed NTSB DCA69A0009Accident · Serious injuriesClosedDouglas DC- 9 · Sioux City, IADec 27, 1968 · N974Z · Destroyed NTSB DCA69A0008Accident · 3 fatalClosedBoeing 707 · Anchorage, AKDec 26, 1968 · N799PA · Destroyed NTSB DCA69A0004Accident · 32 fatalClosedFairchild FH227C · Hanover, NHOct 25, 1968 · N380NE · Destroyed NTSB DCA69A0003Accident · 21 fatalClosedSikorsky S-61L · Compton, CAAug 14, 1968 · N300Y · Destroyed