Skip to content

Final NTSB investigations, 1963

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

19622026

Final NTSB investigations, 1963 per year, 1962–2026: 171,584 cases
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,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,139
2025	779
2026	365

Where

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") = 1963 AND c."completionStatus" = 'Completed' 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\") = 1963
    AND c.\"completionStatus\" = 'Completed'
  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
  AND c."completionStatus" = 'Completed'
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, CADec 17, 1963 · N93131 · Substantial damage NTSB FTW64A0051Accident · No injuriesClosedBoeing 720 · New Orleans, LADec 12, 1963 · N8711E · Substantial damage NTSB SEA64A0032Accident · No injuriesClosedDouglas DC-3 · Kalispell, MTDec 11, 1963 · N2025A · Substantial damage NTSB DCA64A0003Accident · 81 fatalClosedBoeing 707 · Elkton, MDDec 8, 1963 · N709PA · Destroyed NTSB DEN64A0039Accident · 3 fatalClosedCurtiss-Wrt C-46A · Nederland, CODec 7, 1963 · N609Z · Destroyed NTSB MIA64A0063Accident · Serious injuriesClosedDouglas DC-8 · Lakeland, FLDec 4, 1963 · N8601 · No damage NTSB ANC64A0019Accident · No injuriesClosedPiper PA-18 · Kodiak, AKDec 4, 1963 · N3682Z · Substantial damage NTSB OAK64A0044Accident · No injuriesClosedSikorsky S-62A · Oakland, CADec 2, 1963 · N88067 · Substantial damage NTSB NYC64A0074Accident · 1 fatalClosedDouglas DC-3 · Morgantown, WVNov 29, 1963 · N386T · Destroyed NTSB MIA64A0055Accident · No injuriesClosedArmstrong AW650 · S.Johnson Afb, NCNov 21, 1963 · N6507R · Substantial damage NTSB FTW64A0040Accident · Serious injuriesClosedDouglas DC-8 · Houston, TXNov 9, 1963 · N8603 · Substantial damage NTSB NYC64A0062Accident · No injuriesClosedBoeing 720 · Boston, MANov 6, 1963 · N8708E · Substantial damage NTSB MIA64A0050Accident · No injuriesClosedDouglas DC-7B · Atlanta, GANov 1, 1963 · N823D · Substantial damage NTSB MIA64A0049Accident · No injuriesClosedConvair 440 · Atlanta, GANov 1, 1963 · N4815C · Substantial damage NTSB OAK64A0035Accident · No injuriesClosedSikorsky S-62A · San Francisco, CAOct 29, 1963 · N323Y · Substantial damage NTSB LAX64A0024Accident · Serious injuriesClosedLockheed 188A · Los Mochis, MexicoOct 19, 1963 · N7142C · No damage NTSB DCA64A0012Accident · 6 fatalClosedVertol 107-II · Jamaica, NYOct 14, 1963 · N6673D · Destroyed NTSB FTW64A0031Accident · No injuriesClosedDouglas DC-3A · Shreveport, LASep 29, 1963 · N33656 · Substantial damage NTSB MIA64A0041Accident · No injuriesClosedDouglas DC-7 · Nashville, TNSep 28, 1963 · N843D · Substantial damage NTSB LAX64A0020Accident · No injuriesClosedBoeing 707 · Los Angeles, CASep 28, 1963 · N7741W · Substantial damage NTSB OAK64A0028Accident · No injuriesClosedCurtiss-Wrt C-46F · Las Vegas, NVSep 25, 1963 · N67935 · Substantial damage NTSB MIA64A0039Accident · No injuriesClosedCurtiss-Wrt C-46 · Orlando, FLSep 25, 1963 · N1243N · Substantial damage NTSB DEN64A0023Accident · Serious injuriesClosedBoeing 707 · Phoenix, AZSep 23, 1963 · N7523A · No damage NTSB MKC64A0027Accident · Serious injuriesClosedBoeing 707 · Topeka, KSSep 21, 1963 · N742TW · No damage NTSB ANC64A0014Accident · No injuriesClosedCessna 180 · Egegik, AKSep 12, 1963 · N5398D · Substantial damage NTSB LAX64A0016Accident · No injuriesClosedBoeing 707 · Los Angeles, CASep 10, 1963 · N705PA · Substantial damage NTSB ANC64A0012Accident · No injuriesClosedCurtiss-Wrt C-46 · Anchorage, AKSep 5, 1963 · N7779B · Substantial damage NTSB UNK63X0104Accident · Serious injuriesClosedFairchild F-27 · Calgary, CanadaAug 24, 1963 · N2707 · Substantial damage NTSB ANC64A0008Accident · No injuriesClosedPilatus PC-6 · Quinhagak, AKAug 23, 1963 · N4914 · Substantial damage NTSB NYC64A0029Accident · No injuriesClosedConvair 440 · Wilkes-Barre, PAAug 21, 1963 · N9320 · Substantial damage NTSB MIA64A0024Accident · No injuriesClosedDouglas DC-8 · Orlando, FLAug 21, 1963 · N8601 · Substantial damage NTSB FTW64A0016Accident · No injuriesClosedDouglas DC-7C · Panama Cty, St. Pierre & MiquelonAug 15, 1963 · N5906 · Substantial damage NTSB LAX64A0008Accident · 1 fatalClosedCurtiss-Wrt C-46F · Great Falls, MTAug 14, 1963 · N67941 · Substantial damage NTSB NYC64A0024Accident · Serious injuriesClosedBoeing 707 · Mcguire Afbase, NJAug 13, 1963 · N719PA · No damage NTSB CHI64A0027Accident · No injuriesClosedDouglas DC-6 · Indianapolis, INAug 13, 1963 · N1907M · Substantial damage NTSB OAK64A0019Accident · Minor injuriesClosedFairchild F-27A · San Francisco, CAAug 7, 1963 · N2771R · Substantial damage NTSB FTW64A0011Accident · No injuriesClosedCurtiss-Wrt C-46 · Wichita Falls, TXJul 31, 1963 · N1824M · Substantial damage NTSB OAK64A0017Accident · Serious injuriesClosedDouglas DC-8 · Des Moines, IAJul 28, 1963 · N8037U · No damage NTSB ANC64A0005Accident · No injuriesClosedGrumman G-44 · Seldovia, AKJul 23, 1963 · N9929H · Destroyed NTSB LAX64A0002Accident · No injuriesClosedSikorski S-61L · Los Angeles, CAJul 15, 1963 · N300Y · Substantial damage NTSB OAK64A0006Accident · No injuriesClosedFairchild F-27 · Kailua, HIJul 9, 1963 · N5096A · Substantial damage NTSB MIA68A0008Accident · Serious injuriesClosedBoeing 707 · Wilmington, NCJul 8, 1963 · N710PA · No damage NTSB NYC64A0008Accident · Serious injuriesClosedLockheed 188 · Bradford, PAJul 2, 1963 · N6126 · No damage NTSB DCA64A0008Accident · 7 fatalClosedMartin 404 · Rochester, NYJul 2, 1963 · N449A · Destroyed NTSB CHI63A0190Accident · Serious injuriesClosedBoeing 707 · Litchfield, MIJun 28, 1963 · N7509A · No damage NTSB NYC63A0198Accident · Serious injuriesClosedDouglas DC-8 · Norfolk, VAJun 23, 1963 · N8617 · Minor damage NTSB FTW63A0173Accident · No injuriesClosedMartin 404 · Baton Rouge, LAJun 17, 1963 · N145S · Substantial damage NTSB CHI63A0183Accident · No injuriesClosedArmstrong AW650 · Fairfield, OHJun 9, 1963 · N6506R · Substantial damage NTSB CHI63A0182Accident · Serious injuriesClosedLockheed 188 · Chicago, ILJun 8, 1963 · N6134A · No damage NTSB DCA63A0008Accident · 101 fatalClosedDouglas DC-7C · Annette Isld, AKJun 3, 1963 · N290 · Destroyed