NTSB investigations, 1976, MO

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
NTSB investigations, 1976, MO per year, 1962–2026: 3,556 cases
19621
19631
1964118
1965136
1966155
1967173
1968100
196983
1970111
1971112
197280
197380
197480
197598
1976101
197796
1978111
1979100
198085
198195
198286
198384
198474
198572
198654
198759
198867
198947
199041
199137
199240
199358
199447
199539
199628
199733
199829
199943
200031
200133
200230
200330
200432
200531
200627
200731
200831
200923
201023
201132
201233
201321
201419
201531
201629
201728
201822
201920
202024
202115
202219
202325
202422
202519
202621

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\" = 'MO' 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 MKC77FA010Accident · 1 fatalClosedCessna 210L · Fenton, MODec 28, 1976 · N2148S · DestroyedNTSB MKC77FCA07Accident · No injuriesClosedCessna 182H · Monticello, MODec 27, 1976 · N1873X · Substantial damageNTSB MKC77FCA06Accident · No injuriesClosedCessna 172K · Fenton, MODec 22, 1976 · N46694 · Substantial damageNTSB MKC77FA006Accident · No injuriesClosedPiper PA-30B · St Louis, MONov 30, 1976 · N8489Y · Substantial damageNTSB MKC77FCG07Accident · No injuriesClosedCessna 182M · Grain Valley, MONov 24, 1976 · N71857 · Substantial damageNTSB MKC77DCG09Accident · No injuriesClosedPiper PA-28 · Fayette, MONov 24, 1976 · N9898W · Substantial damageNTSB MKC77FCA04Accident · No injuriesClosedPiper PA-28R · Chesterfield, MONov 20, 1976 · N9354N · Substantial damageNTSB MKC77FCG03Accident · Minor injuriesClosedCessna 120 · Waldron, MOOct 17, 1976 · N1980V · 2 aircraft · DestroyedNTSB MKC77DCG04Accident · No injuriesClosedLuscombe 8A · Carthage, MOOct 17, 1976 · N1108B · 2 aircraft · Substantial damageNTSB MKC77FCG01Accident · No injuriesClosedCessna 205 · Point Lookout, MOOct 16, 1976 · N707K · Substantial damageNTSB MKC77FCA01Accident · No injuriesClosedHawker H HH1 · Cape Girardeau, MOOct 6, 1976 · N33000 · Substantial damageNTSB MKC77DCA02Accident · Minor injuriesClosedGrumman G-164 · Hayti, MOOct 4, 1976 · N6607 · DestroyedNTSB MKC76FCA46Accident · No injuriesClosedCessna 140 · Vandalia, MOSep 25, 1976 · N72343 · Substantial damageNTSB MKC76DCG99Accident · No injuriesClosedBeech A23-19 · Clinton, MOSep 24, 1976 · N2378W · Substantial damageNTSB MKC76FCG98Accident · No injuriesClosedBell 47G-5 · King City, MOSep 22, 1976 · N8599F · DestroyedNTSB MKC76FCA45Accident · Minor injuriesClosedCessna 177 · Creve Coewr, MOSep 19, 1976 · N2325Y · Substantial damageNTSB MKC76AK081Accident · Serious injuriesClosedPiper PA-23 · Independence, MOSep 15, 1976 · N6510Y · DestroyedNTSB MKC76AK080Accident · 1 fatalClosedErco 415-C · Saint James, MOSep 11, 1976 · N87059 · DestroyedNTSB MKC76DCG97Accident · No injuriesClosedCessna 210 · Kansas City, MOSep 6, 1976 · N94069 · Substantial damageNTSB MKC76DCG96Accident · No injuriesClosedCessna 140 · Salisbury, MOAug 23, 1976 · N72780 · Substantial damageNTSB MKC76FCA41Accident · No injuriesClosedPiper PA-34 · Fenton, MOAug 22, 1976 · N15974 · Substantial damageNTSB MKC76FCA42Accident · Minor injuriesClosedCessna 172M · Centerville, MOAug 21, 1976 · N9230H · DestroyedNTSB MKC76DCA43Accident · No injuriesClosedCessna A188B · Portageville, MOAug 21, 1976 · N4833R · DestroyedNTSB MKC76AK074Accident · 1 fatalClosedBeech B55 · Washington, MOAug 13, 1976 · N9026S · DestroyedNTSB MKC76AK073Accident · 2 fatalClosedBell 47J-2A · Branson, MOAug 13, 1976 · N1192W · Substantial damageNTSB MKC76FCA40Accident · Serious injuriesClosedPiper PA-28 · Festus, MOAug 12, 1976 · N55037 · DestroyedNTSB MKC76FCA39Accident · No injuriesClosedBell 47J · St Louis, MOAug 7, 1976 · N5154B · Substantial damageNTSB MKC76DCG94Accident · No injuriesClosedBellanca 8KCAB · Excelsior Spgs, MOAug 6, 1976 · N11FS · Substantial damageNTSB MKC76AK072Accident · 6 fatalClosedBeech 58 · Chillicothe, MOAug 3, 1976 · N1553W · DestroyedNTSB MKC76DCA38Accident · No injuriesClosedStinson 108-2 · Cape Girardeau, MOJul 31, 1976 · N93885 · Substantial damageNTSB MKC76DCG93Accident · No injuriesClosedBeech B55 · Kansas City, MOJul 28, 1976 · N1580W · Substantial damageNTSB MKC76AK071Accident · No injuriesClosedCessna 401 · Farmington, MOJul 28, 1976 · N4010Q · Substantial damageNTSB MKC76FCG92Accident · No injuriesClosedPiper PA-24 · Joplin, MOJul 25, 1976 · N29BJ · Substantial damageNTSB MKC76FCG91Accident · No injuriesClosedNavion G · Springfield, MOJul 25, 1976 · N2408T · Substantial damageNTSB MKC76AK069Accident · 5 fatalClosedPiper PA-28R · Huntsville, MOJul 24, 1976 · N7941C · 2 aircraft · DestroyedNTSB MKC76FCG89Accident · Minor injuriesClosedBeech M35 · Grain Valley, MOJul 23, 1976 · N9328Y · DestroyedNTSB MKC76DCA37Accident · No injuriesClosedCessna 150 · Cuba, MOJul 22, 1976 · N63199 · Substantial damageNTSB MKC76DCA36Accident · Serious injuriesClosedBriegleb BG-12B · Painton, MOJul 18, 1976 · N9015 · Substantial damageNTSB MKC76FCG88Accident · No injuriesClosedPiper J-3 · Springfield, MOJul 17, 1976 · N42755 · Substantial damageNTSB MKC76FCG86Accident · Serious injuriesClosedBarnes AX6 · Liberty, MOJul 17, 1976 · N2047F · DestroyedNTSB MKC76FCA35Accident · Minor injuriesClosedBell 47G · Chesterfield, MOJul 13, 1976 · N2812B · Substantial damageNTSB MKC76DCA34Accident · No injuriesClosedCessna 177 · Fenton, MOJul 13, 1976 · N2958X · Substantial damageNTSB MKC76FCA33Accident · No injuriesClosedAero Comdr 680 · Bunker, MOJul 11, 1976 · N6866S · Substantial damageNTSB MKC76DCA32Accident · No injuriesClosedGrumman G-164A · Fisk, MOJul 10, 1976 · N8701H · Substantial damageNTSB MKC76FCG85Accident · Serious injuriesClosedCessna 177 · Eldon, MOJul 9, 1976 · N2224Y · Substantial damageNTSB MKC76DCA30Accident · Minor injuriesClosedCessna 182 · Belleview, MOJul 8, 1976 · N2990Y · Substantial damageNTSB MKC76FCG83Accident · No injuriesClosedPiper PA-22 · Carthage, MOJul 5, 1976 · N916A · Substantial damageNTSB MKC76FCA31Accident · Serious injuriesClosedEnstrom F-28A · Lutesville, MOJul 5, 1976 · N1224R · DestroyedNTSB MKC76FCG80Accident · Minor injuriesClosedCessna 172L · Lees Summit, MOJun 29, 1976 · N4305Q · Substantial damageNTSB MKC76DCG82Accident · No injuriesClosedPiper PA-28 · Lamar, MOJun 27, 1976 · N7983N · Substantial damage