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

19622026
NTSB investigations, 1963 per year, 1962–2026: 180,581 cases
196272
196378
19645,253
19655,377
19665,912
19676,339
19685,199
19695,027
19704,915
19714,825
19724,430
19734,398
19744,565
19754,403
19764,314
19774,412
19784,624
19794,165
19803,921
19813,836
19823,545
19833,514
19843,405
19853,055
19862,831
19872,774
19882,685
19892,502
19902,479
19912,419
19922,328
19932,283
19942,229
19952,281
19962,150
19972,121
19982,195
19992,175
20002,183
20012,031
20022,000
20032,062
20041,930
20052,001
20061,826
20071,984
20081,882
20091,783
20101,786
20111,848
20121,834
20131,561
20141,534
20151,581
20161,662
20171,635
20181,687
20191,626
20201,396
20211,645
20221,700
20231,678
20241,693
20251,655
20261,342

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.

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