NTSB investigations, 1963
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\") = 1963 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") = 1963 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 LAX64A0036Accident · No injuriesClosedDouglas DC-6B · Los Angeles, CANTSB FTW64A0051Accident · No injuriesClosedBoeing 720 · New Orleans, LANTSB SEA64A0032Accident · No injuriesClosedDouglas DC-3 · Kalispell, MTNTSB DCA64A0003Accident · 81 fatalClosedBoeing 707 · Elkton, MDNTSB DEN64A0039Accident · 3 fatalClosedCurtiss-Wrt C-46A · Nederland, CONTSB MIA64A0063Accident · Serious injuriesClosedDouglas DC-8 · Lakeland, FLNTSB ANC64A0019Accident · No injuriesClosedPiper PA-18 · Kodiak, AKNTSB OAK64A0044Accident · No injuriesClosedSikorsky S-62A · Oakland, CANTSB NYC64A0074Accident · 1 fatalClosedDouglas DC-3 · Morgantown, WVNTSB MIA64A0055Accident · No injuriesClosedArmstrong AW650 · S.Johnson Afb, NCNTSB FTW64A0040Accident · Serious injuriesClosedDouglas DC-8 · Houston, TXNTSB NYC64A0062Accident · No injuriesClosedBoeing 720 · Boston, MANTSB MIA64A0050Accident · No injuriesClosedDouglas DC-7B · Atlanta, GANTSB MIA64A0049Accident · No injuriesClosedConvair 440 · Atlanta, GANTSB OAK64A0035Accident · No injuriesClosedSikorsky S-62A · San Francisco, CANTSB LAX64A0024Accident · Serious injuriesClosedLockheed 188A · Los Mochis, MexicoNTSB DCA64A0012Accident · 6 fatalClosedVertol 107-II · Jamaica, NYNTSB FTW64A0031Accident · No injuriesClosedDouglas DC-3A · Shreveport, LANTSB MIA64A0041Accident · No injuriesClosedDouglas DC-7 · Nashville, TNNTSB LAX64A0020Accident · No injuriesClosedBoeing 707 · Los Angeles, CANTSB OAK64A0028Accident · No injuriesClosedCurtiss-Wrt C-46F · Las Vegas, NVNTSB MIA64A0039Accident · No injuriesClosedCurtiss-Wrt C-46 · Orlando, FLNTSB DEN64A0023Accident · Serious injuriesClosedBoeing 707 · Phoenix, AZNTSB MKC64A0027Accident · Serious injuriesClosedBoeing 707 · Topeka, KSNTSB ANC64A0014Accident · No injuriesClosedCessna 180 · Egegik, AKNTSB LAX64A0016Accident · No injuriesClosedBoeing 707 · Los Angeles, CANTSB ANC64A0012Accident · No injuriesClosedCurtiss-Wrt C-46 · Anchorage, AKNTSB UNK63X0104Accident · Serious injuriesClosedFairchild F-27 · Calgary, CanadaNTSB ANC64A0008Accident · No injuriesClosedPilatus PC-6 · Quinhagak, AKNTSB NYC64A0029Accident · No injuriesClosedConvair 440 · Wilkes-Barre, PANTSB MIA64A0024Accident · No injuriesClosedDouglas DC-8 · Orlando, FLNTSB FTW64A0016Accident · No injuriesClosedDouglas DC-7C · Panama Cty, St. Pierre & MiquelonNTSB LAX64A0008Accident · 1 fatalClosedCurtiss-Wrt C-46F · Great Falls, MTNTSB NYC64A0024Accident · Serious injuriesClosedBoeing 707 · Mcguire Afbase, NJNTSB CHI64A0027Accident · No injuriesClosedDouglas DC-6 · Indianapolis, INNTSB OAK64A0019Accident · Minor injuriesClosedFairchild F-27A · San Francisco, CANTSB FTW64A0011Accident · No injuriesClosedCurtiss-Wrt C-46 · Wichita Falls, TXNTSB OAK64A0017Accident · Serious injuriesClosedDouglas DC-8 · Des Moines, IANTSB ANC64A0005Accident · No injuriesClosedGrumman G-44 · Seldovia, AKNTSB LAX64A0002Accident · No injuriesClosedSikorski S-61L · Los Angeles, CANTSB OAK64A0006Accident · No injuriesClosedFairchild F-27 · Kailua, HINTSB MIA68A0008Accident · Serious injuriesClosedBoeing 707 · Wilmington, NCNTSB NYC64A0008Accident · Serious injuriesClosedLockheed 188 · Bradford, PANTSB DCA64A0008Accident · 7 fatalClosedMartin 404 · Rochester, NYNTSB CHI63A0190Accident · Serious injuriesClosedBoeing 707 · Litchfield, MINTSB NYC63A0198Accident · Serious injuriesClosedDouglas DC-8 · Norfolk, VANTSB FTW63A0173Accident · No injuriesClosedMartin 404 · Baton Rouge, LANTSB CHI63A0183Accident · No injuriesClosedArmstrong AW650 · Fairfield, OHNTSB CHI63A0182Accident · Serious injuriesClosedLockheed 188 · Chicago, ILNTSB DCA63A0008Accident · 101 fatalClosedDouglas DC-7C · Annette Isld, AK