NTSB investigations, 1974, 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, 1974, 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\") = 1974
    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 MKC75AK033Accident · 3 fatalClosedPiper PA-28 · Swedeborg, MODec 24, 1974 · N6698J · Substantial damageNTSB MKC75FCG25Accident · No injuriesClosedAero Comdr 560 · Lees Summit, MODec 23, 1974 · N2730B · Substantial damageNTSB MKC75FCG23Accident · Serious injuriesClosedErco 415-D · Sedalia, MODec 20, 1974 · N99863 · Substantial damageNTSB MKC75FCG26Accident · No injuriesClosedPiper PA-30 · Bolivar, MODec 19, 1974 · N7465Y · Substantial damageNTSB MKC75AK031Accident · 2 fatalClosedPiper PA-23 · Perryville, MODec 18, 1974 · N2223R · DestroyedNTSB MKC75FCA19Accident · 1 fatalClosedAmer Avco AA1-B · Fenton, MODec 17, 1974 · N8867L · DestroyedNTSB MKC75FCG22Accident · No injuriesClosedCessna 182 · Lees Summit, MODec 16, 1974 · N2353R · Substantial damageNTSB MKC75FCA17Accident · No injuriesClosedCessna 150F · Morley, MODec 13, 1974 · N8621G · Substantial damageNTSB MKC75DCG21Accident · No injuriesClosedBellanca 8GCBC · Carthage, MONov 28, 1974 · N8558V · Substantial damageNTSB MKC75DCG19Accident · No injuriesClosedCessna 150 · Corder, MONov 15, 1974 · N10486 · Substantial damageNTSB MKC75FCA16Accident · No injuriesClosedMooney M20E · Vichy, MONov 3, 1974 · N1261X · Substantial damageNTSB MKC75FCA15Accident · No injuriesClosedBeech E18S · Festus, MONov 3, 1974 · N762SP · Substantial damageNTSB MKC75DCG18Accident · No injuriesClosedPiper PA-32 · Boonville, MOOct 24, 1974 · N56994 · Substantial damageNTSB MKC75FCA14Accident · Minor injuriesClosedCessna 172 · Wellsville, MOOct 21, 1974 · N566QL · Substantial damageNTSB MKC75FCA13Accident · Serious injuriesClosedPiper PA-25 · Poplar Bluff, MOOct 17, 1974 · N4863Y · Substantial damageNTSB MKC75FCG17Accident · Minor injuriesClosedCessna 210C · Clinton, MOOct 13, 1974 · N3665Y · Substantial damageNTSB MKC75FCA11Accident · 1 fatalClosedCallair A-9 · Charleston, MOOct 9, 1974 · N9661Z · DestroyedNTSB MKC74FCA12Accident · No injuriesClosedAero Comdr A9B · Caruthersville, MOOct 9, 1974 · N7662V · Substantial damageNTSB MKC75FCG15Accident · Serious injuriesClosedCessna 172G · Eldon, MOSep 27, 1974 · N5910B · DestroyedNTSB MKC75DCA10Accident · No injuriesClosedAmer Avco AA-1 · Creve Coeur, MOSep 26, 1974 · N5938L · Substantial damageNTSB MKC75FCG14Accident · Serious injuriesClosedPiper PA-31 · Duenweg, MOSep 20, 1974 · N510BB · DestroyedNTSB MKC75DCA09Accident · No injuriesClosedCessna 172 · Montgomery Cty, MOSep 17, 1974 · N84456 · Substantial damageNTSB MKC74FCA06Accident · No injuriesClosedNavion A · St Charles, MOSep 1, 1974 · N8798H · Substantial damageNTSB MKC75FCG12Accident · Serious injuriesClosedCessna 172 · Marshfield, MOAug 23, 1974 · N7130G · Substantial damageNTSB MKC75AK015Accident · 2 fatalClosedCessna 150J · Kewanee, MOAug 23, 1974 · N47CA · DestroyedNTSB MKC75AK009Accident · 1 fatalClosedCessna 172D · Shelbyville, MOAug 7, 1974 · N2804U · DestroyedNTSB MKC75FCG07Accident · 1 fatalClosedGrumman G-164A · St Joseph, MOAug 5, 1974 · N6606 · 2 aircraft · Substantial damageNTSB MKC75FCA08Accident · No injuriesClosedCessna 177 · Garwood, MOAug 4, 1974 · N2224Y · Substantial damageNTSB MKC75AK006Accident · 1 fatalClosedMaule M-4 · Lee'S Summit, MOJul 28, 1974 · N2068U · DestroyedNTSB MKC75AK005Accident · 2 fatalClosedAmer Avco AA1-B · Kansas City, MOJul 26, 1974 · N9969L · DestroyedNTSB MKC74FCG05Accident · No injuriesClosedCessna 210 · Kansas City, MOJul 26, 1974 · N9501T · Substantial damageNTSB MKC75FCG08Accident · Serious injuriesClosedPretzer MTC · Reeds Springs, MOJul 24, 1974 · N30095 · Substantial damageNTSB MKC75DCG03Accident · No injuriesClosedPiper PA-28 · Columbia, MOJul 22, 1974 · N8049N · Substantial damageNTSB MKC75FCG02Accident · Minor injuriesClosedStinson 108-3 · Harrisonville, MOJul 14, 1974 · N6782M · Substantial damageNTSB MKC75FCA03Case · Minor injuriesClosedCessna 182L · Fenton, MOJul 13, 1974 · N42275 · Substantial damageNTSB MKC75AK002Accident · 2 fatalClosedBeech 95-A55 · Holt, MOJul 13, 1974 · N9567V · DestroyedNTSB MKC75DCG01Accident · No injuriesClosedCessna 172 · Strafford, MOJul 9, 1974 · N84907 · Substantial damageNTSB MKC75DCA04Accident · No injuriesClosedCessna 150 · Chesterfield, MOJul 9, 1974 · N11952 · Substantial damageNTSB MKC75DCA02Accident · No injuriesClosedCessna 170A · House Springs, MOJul 5, 1974 · N9734A · Substantial damageNTSB MKC75FCA05Accident · Serious injuriesClosedCessna 150L · Cuba, MOJul 3, 1974 · N10781 · Substantial damageNTSB MKC75FCA01Accident · No injuriesClosedPiper PA-32 · Fredericktown, MOJul 1, 1974 · N3361W · Substantial damageNTSB MKC75DCG04Accident · No injuriesClosedCessna 172 · Lebanon, MOJul 1, 1974 · N8442U · Substantial damageNTSB MKC74FCG47Accident · Serious injuriesClosedAeronca 11AC · Humphreys, MOJun 29, 1974 · N3223E · Substantial damageNTSB MKC74FCA29Accident · No injuriesClosedPiper PA-28 · Fenton, MOJun 26, 1974 · N7016W · Substantial damageNTSB MKC74DCG44Accident · No injuriesClosedCessna 172 · Columbia, MOJun 23, 1974 · N8319B · Substantial damageNTSB MKC74FCA27Accident · Serious injuriesClosedAeronca 7AC · Wentzville, MOJun 22, 1974 · N81503 · Substantial damageNTSB MKC74FCG43Accident · No injuriesClosedCessna 421 · Springfield, MOJun 14, 1974 · N4572L · Substantial damageNTSB MKC74DCA30Accident · No injuriesClosedPiper PA-28 · Kahoka, MOJun 14, 1974 · N6404R · Substantial damageNTSB MKC74DCG40Accident · No injuriesClosedCessna 120 · Monett, MOJun 4, 1974 · N2702N · Substantial damageNTSB MKC74FCA28Accident · Serious injuriesClosedPiper PA-25 · Sikeston, MOMay 30, 1974 · N4918Y · Destroyed