Final NTSB investigations, 1962

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.

Cases per year

19622026
Final NTSB investigations, 1962 per year, 1962–2026: 171,584 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,511
19843,403
19853,051
19862,824
19872,757
19882,651
19892,478
19902,451
19912,391
19922,293
19932,244
19942,190
19952,216
19962,091
19972,038
19982,061
19992,069
20002,026
20011,876
20021,868
20031,928
20041,776
20051,826
20061,644
20071,809
20081,714
20091,613
20101,561
20111,612
20121,578
20131,317
20141,321
20151,317
20161,344
20171,334
20181,354
20191,309
20201,141
20211,216
20221,272
20231,216
20241,139
2025779
2026365

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
    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.

NTSB CHI62A0129Accident · No injuriesClosedDouglas DC-3 · Clinton, IADec 22, 1962 · N184D · Substantial damageNTSB MKC62A0052Accident · Serious injuriesClosedConvair 340 · Grand Island, NEDec 21, 1962 · N73130 · DestroyedNTSB LAX62A0131Accident · 5 fatalClosedLockheed 1049H · No.Hollywood, CADec 14, 1962 · N6913C · DestroyedNTSB LAX62A0127Accident · No injuriesClosedDouglas DC-6 · Los Angeles, CADec 10, 1962 · N37503 · Substantial damageNTSB MIA62A0090Accident · No injuriesClosedCurtiss-Wrt C-46A · Macon, GADec 4, 1962 · N5131B · Substantial damageNTSB NYC62A0128Accident · 25 fatalClosedDouglas DC-7B · Jamaica, NYNov 30, 1962 · N815D · DestroyedNTSB NYC62A0127Accident · 17 fatalClosedVickers 745D · Ellicott City, MDNov 23, 1962 · N7430 · DestroyedNTSB MIA63A0108Accident · Serious injuriesClosedBoeing 707 · Kingston, JamaicaNov 9, 1962 · N710PA · No damageNTSB UNK63X0101Accident · No injuriesClosedDouglas DC-7B · La Pa, St. BarthélemyOct 29, 1962 · N51702 · Substantial damageNTSB MKC62A0046Accident · No injuriesClosedConvair 340 · Pierre, SDOct 24, 1962 · N90857 · Substantial damageNTSB ANC62A0048Accident · No injuriesClosedDouglas DC-7C · Sitka Sound, AKOct 22, 1962 · N285 · DestroyedNTSB NYC62A0108Accident · 1 fatalClosedConvair 340 · Windsor Lock, CTOct 19, 1962 · N8415H · Minor damageNTSB OAK62A0045Accident · No injuriesClosedDouglas DC-7 · Sacramento, CAOct 14, 1962 · N6311C · Substantial damageNTSB NYC62A0103Accident · No injuriesClosedMartin 404 · Baltimore, MDOct 3, 1962 · N40423 · Minor damageNTSB UNK63X0100Accident · No injuriesClosedBeech C18S · Pow B Dewlne, AKOct 1, 1962 · N6416C · Substantial damageNTSB UNK62X0104Accident · 28 fatalClosedLockheed 1049H · No.Atlantic Ocean (Atlantic Ocean)Sep 23, 1962 · N6923C · DestroyedNTSB NYC62A0099Accident · Serious injuriesClosedBoeing 720 · Albany, NYSep 23, 1962 · N7209U · Minor damageNTSB MIA62A0072Accident · No injuriesClosedBoeing 720B · Miami, FLSep 21, 1962 · N8715E · Substantial damageNTSB MIA62A0070Accident · Minor injuriesClosedDouglas DC-7B · Daytona Beach, FLSep 19, 1962 · N801D · Substantial damageNTSB CHI62A0089Accident · No injuriesClosedSud Avn SE 210 · Cleveland, OHSep 11, 1962 · N1014U · Substantial damageNTSB FTW62A0072Accident · No injuriesClosedBoeing 720 · New Orleans, LAAug 30, 1962 · N8706E · Substantial damageNTSB MIA62A0062Accident · Minor injuriesClosedMartin 404 · Wilmington, NCAug 22, 1962 · N40401 · DestroyedNTSB MIA62A0061Accident · No injuriesClosedCurtiss-Wrt C-46R · Miami, FLAug 17, 1962 · N3944C · Substantial damageNTSB ANC62A0038Accident · No injuriesClosedBeech AT-11 · Liz A Dewlne, AKAug 11, 1962 · N79019 · Substantial damageNTSB UNK62X0103Accident · No injuriesClosedLockheed L-1049 · Clark Afb, RPAug 10, 1962 · N7121C · Substantial damageNTSB MIA62A0056Accident · Minor injuriesClosedLockheed 188 · Knoxville, TNAug 6, 1962 · N6102A · Substantial damageNTSB MIA62A0055Accident · No injuriesClosedMartin 404 · Rocky Mount, NCAug 6, 1962 · N40415 · Substantial damageNTSB NYC62A0076Accident · Serious injuriesClosedBoeing 707 · Amsterdam, NetherlandsJul 26, 1962 · N726PA · Minor damageNTSB NYC62A0074Accident · No injuriesClosedArmstrong AW-650 · Rome, NYJul 23, 1962 · N6502R · Substantial damageNTSB LAX94LA336Accident · 4 fatalLimited investigationClosedPiper PA24-180 · Bridgeport, CAIn-flight collision with terrain for unknown reason(s).Jul 20, 1962 · N5069P · DestroyedNTSB LAX62A0073Accident · No injuriesClosedGrumman G-21A · Avalon Bay, CAJul 17, 1962 · N324 · Substantial damageNTSB UNK62X0102Accident · No injuriesClosedCurtis-Wrt C-46 · F.W.I, GuadeloupeJul 11, 1962 · N74811 · Substantial damageNTSB FTW62A0052Accident · Minor injuriesClosedVickers 812 · Amarillo, TXJul 8, 1962 · N243V · DestroyedNTSB UNK62X0101Accident · 94 fatalClosedDouglas DC-8 · Bombay, IndiaJul 7, 1962 · IT1 · DestroyedNTSB ANC62A0027Accident · No injuriesClosedBeech C18S · Kotzebue, AKJul 7, 1962 · N8044H · Substantial damageNTSB LAX62A0070Accident · No injuriesClosedCurtiss-Wrt C-46F · Vandenburg Ab, CAJul 6, 1962 · N619Z · Substantial damageNTSB ANC62A0025Accident · No injuriesClosedBeech C18S · Clear Afbase, AKJul 5, 1962 · N5080K · Substantial damageNTSB NYC62A0067Accident · No injuriesClosedArmstrong AW650 · Wilmington, DEJul 2, 1962 · N6501R · Substantial damageNTSB MIA62A0087Accident · Serious injuriesClosedBoeing 707 · San Juan (Atlantic Ocean)Jun 15, 1962 · N707PA · No damageNTSB MIA62A0073Accident · Serious injuriesClosedDouglas DC-8 · Marco, FLJun 14, 1962 · N812PA · No damageNTSB MIA62A0042Accident · No injuriesClosedDouglas DC-7B · Miami, FLJun 8, 1962 · N805D · Substantial damageNTSB MIA62A0039Accident · No injuriesClosedCurtiss-Wrt C-46R · San Juan, PRJun 5, 1962 · N1243N · Substantial damageNTSB NYC62A0047Accident · No injuriesClosedLockheed 1049 · New York, NYMay 28, 1962 · N6213C · Substantial damageNTSB MIA62A0034Accident · No injuriesClosedCurtiss WRT C-46A · Tyndall Afb, FLMay 24, 1962 · N75388 · Substantial damageNTSB NYC62A0052Accident · 45 fatalClosedBoeing 707 · Unionville, MOMay 22, 1962 · N70775 · DestroyedNTSB FTW62A0034Accident · No injuriesClosedDouglas C-54B · Ackerly, TXMay 9, 1962 · N88894 · Substantial damageNTSB OAK62A0015Accident · No injuriesClosedBoeing 707 · Manila, RPApr 27, 1962 · N720PA · Substantial damageNTSB NYC62A0037Accident · Minor injuriesClosedVickers 745D · New York, NYApr 27, 1962 · N6598C · Substantial damageNTSB FTW62A0028Accident · 3 fatalClosedDouglas DC-3 · Dallas, TXApr 18, 1962 · N3588 · DestroyedNTSB LAX62A0038Accident · No injuriesClosedMartin 404 · Lompoc, CAApr 17, 1962 · N40436 · Substantial damage