Final NTSB investigations, 1976, Outside the U.S.

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, Outside the U.S. per year, 1962–2026: 1,202 cases
19629
19633
1964108
196599
1966106
1967101
196864
196963
197070
197156
197279
197366
197465
197558
197616
197724
197836
197914
19805
19812
19825
19845
19852
19861
19875
19888
19891
19903
19914
19921
19932
19943
19952
19962
199710
19981
19994
20002
20011
20023
20034
20043
20061
20073
20086
200911
20104
20114
20124
20135
20147
20156
20163
20173
20186
20196
20203
20211
20222
20232
20247
20252

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.\"eventCountry\" <> 'USA'
    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 UNK77X0101Accident · 5 fatalClosedPiper PA-31T · Shannon Arpt, EINov 12, 1976 · HB-LHT · DestroyedNTSB LAX770A001Accident · No injuriesClosedPiper PA-34 · Santa Clara, MexicoOct 23, 1976 · N9AZ · Substantial damageNTSB MIA76OM012Accident · No injuriesClosedPiper PA-32 · Point-Pitre, GuadeloupeSep 28, 1976 · N3679W · Substantial damageNTSB MIA76OM011Accident · No injuriesClosedDouglas C-54B · Grand Turk, TokelauSep 16, 1976 · N88939 · Substantial damageNTSB MIA76OKT95Accident · No injuriesClosedCessna 182 · Eleuthera, Burkina FasoAug 27, 1976 · N1449M · DestroyedNTSB SEA76OO508Accident · Minor injuriesClosedPiper PA-34 · San Luis, MexicoJul 2, 1976 · N1057U · Substantial damageNTSB MIA76OKT77Accident · Minor injuriesClosedCessna 411 · Walker Cay, Burkina FasoMay 28, 1976 · N34JH · DestroyedNTSB LAX76O0018Accident · No injuriesClosedPiper PA-32 · Cabo Sn Lucas, MexicoMay 22, 1976 · N55571 · Substantial damageNTSB MIA76OM009Accident · Minor injuriesClosedVolver VJ22 · Bwi, Ascension IslandMay 14, 1976 · N2801J · DestroyedNTSB UNK76X0100Accident · No injuriesClosedBoeing 707 · Paris, FranceApr 24, 1976 · N8738 · Substantial damageNTSB OAK76O0002Accident · No injuriesClosedBeech 35 · Punta Pscadro, MexicoApr 12, 1976 · N3944N · Substantial damageNTSB MKC76OK004Accident · No injuriesClosedCessna 210 · Manila, RPApr 5, 1976 · N9423P · Substantial damageNTSB MIA76OKT55Accident · No injuriesClosedTaylorcraft BL-65 · Abaco, Burkina FasoFeb 29, 1976 · N29807 · Substantial damageNTSB MIA76RKT51Accident · Serious injuriesClosedCessna 320 · Stella Maris, Burkina FasoFeb 2, 1976 · N5723X · DestroyedNTSB MIA760KT50Accident · No injuriesClosedCessna 182 · Grnd Bhma, Burkina FasoJan 18, 1976 · N21550 · Substantial damageNTSB DCA76RA017Accident · Serious injuriesClosedDouglas DC-10 · Istanbul, TUJan 2, 1976 · N1031F · Substantial damage