Final NTSB investigations, 1976

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, 1976 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\") = 1976
    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 SEA77FA011Accident · 1 fatalClosedBeech V35B · Auburn, WADec 31, 1976 · N84BB · DestroyedNTSB OAK77FVM05Accident · No injuriesClosedPiper PA-24 · San Carlos, CADec 31, 1976 · N6642P · Substantial damageNTSB OAK77FVA13Accident · Minor injuriesClosedCessna 150L · Madera, CADec 31, 1976 · N5419Q · DestroyedNTSB OAK77FVA12Accident · 1 fatalClosedBoeing A75N1 · Oakdale, CADec 31, 1976 · N53039 · DestroyedNTSB OAK77DXQ04Accident · No injuriesClosedPiper PA28 · Winnemucca, NVDec 31, 1976 · N4388X · Substantial damageNTSB NYC77FFJ08Accident · No injuriesClosedTed Smith 601 · Dunkirk, NYDec 31, 1976 · N7437S · Substantial damageNTSB NYC77FA026Accident · Serious injuriesClosedPiper PA-30 · College Point, NYDec 31, 1976 · N44SS · DestroyedNTSB NYC77DHA10Accident · No injuriesClosedCessna 182K · Pittstown, NJDec 31, 1976 · N2675R · Substantial damageNTSB MIA77FLD24Accident · Minor injuriesClosedCessna 401 · Tampa, FLDec 31, 1976 · N111TV · DestroyedNTSB MIA77FLD23Accident · Minor injuriesClosedLet-Np-K L-13 · Clearwater, FLDec 31, 1976 · N65139 · Substantial damageNTSB LAX77FUG17Accident · No injuriesClosedMooney M20C · Big Bear City, CADec 31, 1976 · N6423U · Substantial damageNTSB LAX77FA018Accident · 4 fatalClosedBeech 95-B55 · Barstow, CADec 31, 1976 · N4635S · DestroyedNTSB IAD77DKW11Accident · No injuriesClosedBrantly B2B · Fayetteville, TNDec 31, 1976 · N2271U · DestroyedNTSB FTW77FQG07Accident · Minor injuriesClosedNa Rockwell 112 · Wildorado, TXDec 31, 1976 · N1082J · Substantial damageNTSB DEN77FA016Accident · 3 fatalClosedCessna 182P · Santa Rosa, NMDec 31, 1976 · N8338M · DestroyedNTSB CHI77FEI08Accident · Minor injuriesClosedPiper PA-28 · Avon Lake, OHDec 31, 1976 · N5320W · Substantial damageNTSB SEA77FYC12Accident · No injuriesClosedCessna TU206D · Farmington, ORDec 30, 1976 · N72160 · Substantial damageNTSB MKC77FER12Accident · Minor injuriesClosedCessna 172 · Morris, MNDec 30, 1976 · N7834U · Substantial damageNTSB MIA77FKG14Accident · Serious injuriesClosedPiper PA-28 · Cleveland, GADec 30, 1976 · N5922W · DestroyedNTSB IAD77DLJ03Accident · No injuriesClosedCessna 180 · Rougemont, NCDec 30, 1976 · N2464C · Substantial damageNTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXDec 30, 1976 · N53DP · DestroyedNTSB CHI77FEC08Accident · No injuriesClosedCessna 150 · Pontiac, MIDec 30, 1976 · N10090 · Substantial damageNTSB MKC77FER13Accident · No injuriesClosedCessna 182 · Brainerd, MNDec 29, 1976 · N4GL · Substantial damageNTSB MKC77FCJ08Accident · Minor injuriesClosedBellanca 7ECA · Tecumseh, NEDec 29, 1976 · N11664 · Substantial damageNTSB MKC77FCD06Accident · Minor injuriesClosedAero-Star 600 · Pella, IADec 29, 1976 · N7468S · Substantial damageNTSB MKC77DCJ07Accident · No injuriesClosedCessna 150 · Omaha, NEDec 29, 1976 · N16210 · Substantial damageNTSB MIA77FLG05Accident · No injuriesClosedCessna 172 · Columbia, SCDec 29, 1976 · N5529T · Substantial damageNTSB LAX77FA017Accident · No injuriesClosedDehavilland DHC-6 · Los Angeles, CADec 29, 1976 · N66191 · 2 aircraft · Substantial damageNTSB CHI77FEC07Accident · No injuriesClosedCessna 172 · Detroit, MIDec 29, 1976 · N2791L · Substantial damageNTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MIDec 29, 1976 · N411EF · DestroyedNTSB MKC77FA010Accident · 1 fatalClosedCessna 210L · Fenton, MODec 28, 1976 · N2148S · DestroyedNTSB MIA77FA021Accident · 2 fatalClosedCessna 172N · Chiefland, FLDec 28, 1976 · N73840 · DestroyedNTSB MIA77DLA22Accident · No injuriesClosedBeech 35 · Ft.Pierce, FLDec 28, 1976 · N3314C · Substantial damageNTSB MIA77DLA12Accident · No injuriesClosedPiper PA-11 · Perry, FLDec 28, 1976 · N78698 · DestroyedNTSB MIA77DA022Accident · 6 fatalClosedPiper PA-23 · Missing AircraftDec 28, 1976 · N4573P · DestroyedNTSB LAX77DUQ12Accident · No injuriesClosedCessna 150 · California Cty, CADec 28, 1976 · N3986U · Substantial damageNTSB LAX77DUJ16Accident · No injuriesClosedCessna 150 · Bagdad, AZDec 28, 1976 · N6682F · DestroyedNTSB IAD77FLJ06Accident · Serious injuriesClosedTaylorcraft BC12-D · Durants Neck, NCDec 28, 1976 · N95923 · DestroyedNTSB FTW77FRD05Accident · No injuriesClosedGrumman G-164A · Welsh, LADec 28, 1976 · N8699H · Substantial damageNTSB FTW77FRD03Accident · No injuriesClosedBell 206B · Gulf Of Mexico (Gulf of Mexico)Dec 28, 1976 · N49667 · Substantial damageNTSB FTW77DQD04Accident · No injuriesClosedCessna 177 · El Paso, TXDec 28, 1976 · N30044 · Substantial damageNTSB CHI77FA019Accident · Serious injuriesClosedBeech D-18S · Cairo, ILDec 28, 1976 · N3128B · Substantial damageNTSB ANC77FAA08Accident · No injuriesClosedCessna 170B · Fairbanks, AKDec 28, 1976 · N4699C · Substantial damageNTSB SEA77DYE06Accident · No injuriesClosedPiper PA-34 · Verlot, WADec 27, 1976 · N33589 · DestroyedNTSB NYC77IA025Incident · No injuriesClosedBoeing 727 · Bangor, MEDec 27, 1976 · N473DA · Minor damageNTSB NYC77FNC14Accident · No injuriesClosedCessna 310J · New London, NHDec 27, 1976 · N3196L · Substantial damageNTSB NYC77FFJ09Accident · No injuriesClosedPiper PA-28 · Akron, NYDec 27, 1976 · N3916T · Substantial damageNTSB MKC77FCA07Accident · No injuriesClosedCessna 182H · Monticello, MODec 27, 1976 · N1873X · Substantial damageNTSB MIA77FLG04Accident · No injuriesClosedBeech D55 · Charleston, SCDec 27, 1976 · N535Q · Substantial damageNTSB MIA77FLD21Accident · No injuriesClosedGrum Amer AA-1B · St.Cloud, FLDec 27, 1976 · N6311L · Substantial damage