NTSB investigations, 1962
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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.
Cases per year
| 1962 | 72 |
|---|---|
| 1963 | 78 |
| 1964 | 5,253 |
| 1965 | 5,377 |
| 1966 | 5,912 |
| 1967 | 6,339 |
| 1968 | 5,199 |
| 1969 | 5,027 |
| 1970 | 4,915 |
| 1971 | 4,825 |
| 1972 | 4,430 |
| 1973 | 4,398 |
| 1974 | 4,565 |
| 1975 | 4,403 |
| 1976 | 4,314 |
| 1977 | 4,412 |
| 1978 | 4,624 |
| 1979 | 4,165 |
| 1980 | 3,921 |
| 1981 | 3,836 |
| 1982 | 3,545 |
| 1983 | 3,514 |
| 1984 | 3,405 |
| 1985 | 3,055 |
| 1986 | 2,831 |
| 1987 | 2,774 |
| 1988 | 2,685 |
| 1989 | 2,502 |
| 1990 | 2,479 |
| 1991 | 2,419 |
| 1992 | 2,328 |
| 1993 | 2,283 |
| 1994 | 2,229 |
| 1995 | 2,281 |
| 1996 | 2,150 |
| 1997 | 2,121 |
| 1998 | 2,195 |
| 1999 | 2,175 |
| 2000 | 2,183 |
| 2001 | 2,031 |
| 2002 | 2,000 |
| 2003 | 2,062 |
| 2004 | 1,930 |
| 2005 | 2,001 |
| 2006 | 1,826 |
| 2007 | 1,984 |
| 2008 | 1,882 |
| 2009 | 1,783 |
| 2010 | 1,786 |
| 2011 | 1,848 |
| 2012 | 1,834 |
| 2013 | 1,561 |
| 2014 | 1,534 |
| 2015 | 1,581 |
| 2016 | 1,662 |
| 2017 | 1,635 |
| 2018 | 1,687 |
| 2019 | 1,626 |
| 2020 | 1,396 |
| 2021 | 1,645 |
| 2022 | 1,700 |
| 2023 | 1,678 |
| 2024 | 1,693 |
| 2025 | 1,655 |
| 2026 | 1,342 |
Where
Latest cases
Query with SQL
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\") = 1962 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") = 1962 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 CHI62A0129Accident · No injuriesClosedDouglas DC-3 · Clinton, IANTSB MKC62A0052Accident · Serious injuriesClosedConvair 340 · Grand Island, NENTSB LAX62A0131Accident · 5 fatalClosedLockheed 1049H · No.Hollywood, CANTSB LAX62A0127Accident · No injuriesClosedDouglas DC-6 · Los Angeles, CANTSB MIA62A0090Accident · No injuriesClosedCurtiss-Wrt C-46A · Macon, GANTSB NYC62A0128Accident · 25 fatalClosedDouglas DC-7B · Jamaica, NYNTSB NYC62A0127Accident · 17 fatalClosedVickers 745D · Ellicott City, MDNTSB MIA63A0108Accident · Serious injuriesClosedBoeing 707 · Kingston, JamaicaNTSB UNK63X0101Accident · No injuriesClosedDouglas DC-7B · La Pa, St. BarthélemyNTSB MKC62A0046Accident · No injuriesClosedConvair 340 · Pierre, SDNTSB ANC62A0048Accident · No injuriesClosedDouglas DC-7C · Sitka Sound, AKNTSB NYC62A0108Accident · 1 fatalClosedConvair 340 · Windsor Lock, CTNTSB OAK62A0045Accident · No injuriesClosedDouglas DC-7 · Sacramento, CANTSB NYC62A0103Accident · No injuriesClosedMartin 404 · Baltimore, MDNTSB UNK63X0100Accident · No injuriesClosedBeech C18S · Pow B Dewlne, AKNTSB UNK62X0104Accident · 28 fatalClosedLockheed 1049H · No.Atlantic Ocean (Atlantic Ocean)NTSB NYC62A0099Accident · Serious injuriesClosedBoeing 720 · Albany, NYNTSB MIA62A0072Accident · No injuriesClosedBoeing 720B · Miami, FLNTSB MIA62A0070Accident · Minor injuriesClosedDouglas DC-7B · Daytona Beach, FLNTSB CHI62A0089Accident · No injuriesClosedSud Avn SE 210 · Cleveland, OHNTSB FTW62A0072Accident · No injuriesClosedBoeing 720 · New Orleans, LANTSB MIA62A0062Accident · Minor injuriesClosedMartin 404 · Wilmington, NCNTSB MIA62A0061Accident · No injuriesClosedCurtiss-Wrt C-46R · Miami, FLNTSB ANC62A0038Accident · No injuriesClosedBeech AT-11 · Liz A Dewlne, AKNTSB UNK62X0103Accident · No injuriesClosedLockheed L-1049 · Clark Afb, RPNTSB MIA62A0056Accident · Minor injuriesClosedLockheed 188 · Knoxville, TNNTSB MIA62A0055Accident · No injuriesClosedMartin 404 · Rocky Mount, NCNTSB NYC62A0076Accident · Serious injuriesClosedBoeing 707 · Amsterdam, NetherlandsNTSB NYC62A0074Accident · No injuriesClosedArmstrong AW-650 · Rome, NYNTSB LAX94LA336Accident · 4 fatalLimited investigationClosedPiper PA24-180 · Bridgeport, CAIn-flight collision with terrain for unknown reason(s).NTSB LAX62A0073Accident · No injuriesClosedGrumman G-21A · Avalon Bay, CANTSB UNK62X0102Accident · No injuriesClosedCurtis-Wrt C-46 · F.W.I, GuadeloupeNTSB FTW62A0052Accident · Minor injuriesClosedVickers 812 · Amarillo, TXNTSB UNK62X0101Accident · 94 fatalClosedDouglas DC-8 · Bombay, IndiaNTSB ANC62A0027Accident · No injuriesClosedBeech C18S · Kotzebue, AKNTSB LAX62A0070Accident · No injuriesClosedCurtiss-Wrt C-46F · Vandenburg Ab, CANTSB ANC62A0025Accident · No injuriesClosedBeech C18S · Clear Afbase, AKNTSB NYC62A0067Accident · No injuriesClosedArmstrong AW650 · Wilmington, DENTSB MIA62A0087Accident · Serious injuriesClosedBoeing 707 · San Juan (Atlantic Ocean)NTSB MIA62A0073Accident · Serious injuriesClosedDouglas DC-8 · Marco, FLNTSB MIA62A0042Accident · No injuriesClosedDouglas DC-7B · Miami, FLNTSB MIA62A0039Accident · No injuriesClosedCurtiss-Wrt C-46R · San Juan, PRNTSB NYC62A0047Accident · No injuriesClosedLockheed 1049 · New York, NYNTSB MIA62A0034Accident · No injuriesClosedCurtiss WRT C-46A · Tyndall Afb, FLNTSB NYC62A0052Accident · 45 fatalClosedBoeing 707 · Unionville, MONTSB FTW62A0034Accident · No injuriesClosedDouglas C-54B · Ackerly, TXNTSB OAK62A0015Accident · No injuriesClosedBoeing 707 · Manila, RPNTSB NYC62A0037Accident · Minor injuriesClosedVickers 745D · New York, NYNTSB FTW62A0028Accident · 3 fatalClosedDouglas DC-3 · Dallas, TXNTSB LAX62A0038Accident · No injuriesClosedMartin 404 · Lompoc, CA