NTSB investigations, 1976

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, 1976 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\") = 1976
  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