NTSB investigations, 1976, LA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, LA per year, 1962–2026: 3,066 cases
19621
19633
1964120
1965109
1966108
1967118
1968100
1969100
197091
197175
197275
197388
197484
1975105
197693
1977106
1978108
1979103
1980110
198195
198278
198357
198472
198557
198647
198733
198836
198941
199040
199126
199225
199332
199425
199522
199640
199728
199827
199928
200026
200128
200226
200321
200427
200532
200618
200715
200813
200921
201016
201128
201223
201319
201419
201520
201621
201717
201818
201921
202023
202123
202216
202316
202426
202517
202610

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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
  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 FTW77FRD05Accident · No injuriesClosedGrumman G-164A · Welsh, LADec 28, 1976 · N8699H · Substantial damageNTSB FTW77FRD04Accident · Serious injuriesClosedPiper PA-22 · Port Sulphur, LADec 24, 1976 · N644A · Substantial damageNTSB FTW77DA021Accident · No injuriesClosedBell 206B · Morgan City, LADec 11, 1976 · N49669 · Substantial damageNTSB FTW77FRJ02Accident · Minor injuriesClosedCessna 182 · Arcadia, LANov 30, 1976 · N52317 · Substantial damageNTSB FTW77FA016Accident · 1 fatalClosedCessna 182A · Boutte, LANov 23, 1976 · N6304B · DestroyedNTSB FTW77FRD02Accident · No injuriesClosedCessna 180J · Lafayette, LANov 21, 1976 · N46090 · Substantial damageNTSB FTW77DRJ01Accident · No injuriesClosedCessna 210 · Arcadia, LANov 12, 1976 · N93022 · Substantial damageNTSB FTW77FA008Accident · 2 fatalClosedCessna 182L · Shaw, LAOct 23, 1976 · N42213 · DestroyedNTSB FTW77FRD01Accident · No injuriesClosedGrumman G-164 · Maurice, LAOct 9, 1976 · N10264 · DestroyedNTSB FTW77FA002Accident · 3 fatalClosedMooney M20C · Houma, LAOct 4, 1976 · N16515 · DestroyedNTSB FTW76DRD68Accident · Serious injuriesClosedCessna A185F · Patterson, LASep 23, 1976 · N70279 · Substantial damageNTSB FTW76AF125Accident · 1 fatalClosedPiper PA-12 · Greenwood, LASep 21, 1976 · N78592 · DestroyedNTSB FTW76AF123Accident · 4 fatalClosedPiper PA-32 · Oak Ridge, LASep 18, 1976 · N3918W · DestroyedNTSB FTW76DRJ48Accident · Minor injuriesClosedGrumman G-164A · Bonita, LASep 17, 1976 · N7939 · DestroyedNTSB FTW76FRJ47Accident · No injuriesClosedGrumman G-164B · Crowville, LASep 15, 1976 · N48429 · Substantial damageNTSB FTW76DRD67Accident · No injuriesClosedCessna 180 · Napoleonville, LASep 15, 1976 · N9973F · Substantial damageNTSB FTW76FRJ45Accident · 1 fatalClosedSnow 600S2R · Ferriday, LASep 6, 1976 · N5655X · DestroyedNTSB FTW76FRJ43Accident · Serious injuriesClosedCessna A188B · Monroe, LASep 6, 1976 · N4838Q · DestroyedNTSB FTW76FRD66Accident · No injuriesClosedPiper PA-25 · Port Barre, LASep 6, 1976 · N8791L · Substantial damageNTSB FTW76FRJ44Accident · 1 fatalClosedPiper PA-25 · W.Monroe, LASep 4, 1976 · N8786L · DestroyedNTSB FTW76FRD65Accident · No injuriesClosedCessna A185F · Lafayette, LASep 1, 1976 · N51BC · DestroyedNTSB FTW76FRD64Accident · No injuriesClosedCessna 172M · Lake Charles, LAAug 28, 1976 · N80347 · DestroyedNTSB FTW76DRD62Accident · Minor injuriesClosedPiper J-3 · Lake Charles, LAAug 23, 1976 · N41263 · Substantial damageNTSB FTW76FRD63Accident · No injuriesClosedStinson 108 · Baton Rouge, LAAug 22, 1976 · N97647 · Substantial damageNTSB FTW76FRD61Accident · No injuriesClosedCessna 310F · Lafayette, LAAug 20, 1976 · N6792X · Substantial damageNTSB FTW76DRJ41Accident · No injuriesClosedPiper PA-25 · Pioneer, LAAug 20, 1976 · N4761Y · Substantial damageNTSB FTW76FRD60Accident · Serious injuriesClosedCessna 180 · Gretna, LAAug 18, 1976 · N544Z · Substantial damageNTSB FTW76DRJ42Accident · No injuriesClosedGrumman G-164A · Lake Providnce, LAAug 17, 1976 · N8891H · Substantial damageNTSB FTW76FRD59Accident · No injuriesClosedCessna A185F · Lafayette, LAAug 13, 1976 · N38FC · Substantial damageNTSB FTW76FRJ40Accident · Serious injuriesClosedBoeing E75N1 · Tallulah, LAAug 9, 1976 · N5710N · DestroyedNTSB FTW76FRJ39Accident · Minor injuriesClosedGrumman G-164A · Delhi, LAAug 9, 1976 · N8917H · Substantial damageNTSB FTW76AF113Accident · 1 fatalClosedCessna 172 · Baker, LAAug 8, 1976 · N12697 · DestroyedNTSB FTW76FRJ38Accident · Minor injuriesClosedBoeing E75N1 · Epps, LAAug 7, 1976 · N1256V · Substantial damageNTSB FTW76FRD58Accident · Serious injuriesClosedHughes 369 · Intrcostl City, LAAug 4, 1976 · N9125F · DestroyedNTSB FTW76DRJ36Accident · No injuriesClosedCallair A-9 · Plain Dealing, LAJul 31, 1976 · N8292H · Substantial damageNTSB FTW76AF111Accident · No injuriesClosedCessna 180 · Houma, LAJul 29, 1976 · N2125Z · Substantial damageNTSB FTW76FRD56Accident · Serious injuriesClosedGrum Amer AA1-B · Eunice, LAJul 28, 1976 · N1497R · Substantial damageNTSB FTW76DRD55Accident · No injuriesClosedGrumman G-164A · Thibodaux, LAJul 25, 1976 · N6585 · 2 aircraft · Minor damageNTSB FTW76AF110Accident · No injuriesClosedBolkow BO-105 · Rockport, LAJul 25, 1976 · N90656 · Substantial damageNTSB FTW76DRJ34Accident · No injuriesClosedCessna 150M · Oil City, LAJul 24, 1976 · N66127 · Substantial damageNTSB FTW76DRD57Accident · No injuriesClosedCessna 180 · Baton Rouge, LAJul 23, 1976 · N5228D · Substantial damageNTSB FTW76DRJ32Accident · No injuriesClosedPiper PA-25 · Winnsboro, LAJul 19, 1976 · N4868Y · Substantial damageNTSB FTW76DRJ31Accident · No injuriesClosedPiper PA-18 · Ruston, LAJul 18, 1976 · TG-HIQ-F · Substantial damageNTSB FTW76FRJ30Accident · Serious injuriesClosedPiper PA-25 · Gilbert, LAJul 17, 1976 · N4704Y · DestroyedNTSB FTW76AF109Accident · Serious injuriesClosedBell 206B · Berwick, LAJul 15, 1976 · N8176J · DestroyedNTSB FTW76FRD54Accident · Serious injuriesClosedGrumman G-164 · Maringouin, LAJul 11, 1976 · N462RF · Substantial damageNTSB FTW76DRJ29Accident · No injuriesClosedPiper PA-18 · Oak Grove, LAJul 7, 1976 · N4296Z · Substantial damageNTSB FTW76FRD53Accident · Serious injuriesClosedGrumman G-164A · Crowley, LAJul 6, 1976 · N8508H · Substantial damageNTSB FTW76AF106Accident · No injuriesClosedCessna 180 · Golden Meadow, LAJun 24, 1976 · N4779U · DestroyedNTSB FTW76DRD51Accident · No injuriesClosedCessna 180 · Bayon Pigeon, LAJun 23, 1976 · N52009 · Substantial damage