Major NTSB investigations, 1980

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1980 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") = 1980 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\") = 1980
    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") = 1980
  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 DCA81AA003Accident · Serious injuriesClosedBoeing 727 · Yap, MicronesiaNov 21, 1980 · N18479 · Destroyed NTSB DCA80AA022Accident · 3 fatalClosedPiper PA-31 · Philadelphia, PAJul 25, 1980 · N5MS · Destroyed NTSB DCA80AA020Accident · 3 fatalClosedLockheed 1049H · Columbus, INJun 22, 1980 · N74CA · Destroyed NTSB DCA80AA019Accident · 13 fatalClosedSwearingen 226TC · Valley, NEJun 12, 1980 · N650S · Destroyed NTSB DCA80AA017Accident · 2 fatalClosedLear Jet 23 · Richmond, VAMay 6, 1980 · N866JS · Destroyed NTSB LAX80FA092Accident · Serious injuriesClosedDouglas DC-9 · Edwards Afb, CAMay 2, 1980 · N980DC · Substantial damage NTSB FTW80AA057Accident · 7 fatalClosedPiper PA-31 · Houston, TXMar 21, 1980 · N59932 · Destroyed NTSB DEN80AA023Accident · 4 fatalClosedCessna TU206G · Clovis, NMFeb 6, 1980 · N7393N · 2 aircraft · Destroyed NTSB CHI80AA024Accident · 2 fatalClosedFalcon 10 · Chicago, ILJan 30, 1980 · N253K · Destroyed