NTSB investigations, 1973, MO

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1973, MO per year, 1962–2026: 3,555 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
202620

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\") = 1973
    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 MKC74AK036Accident · No injuriesClosedDouglas DC-3 · Springfield, MODec 30, 1973 · N15565 · Substantial damageNTSB MKC74AK031Accident · 1 fatalClosedBeech 95-B55 · Willow Springs, MODec 12, 1973 · N8689Q · DestroyedNTSB MKC74AK030Accident · 1 fatalClosedBeech A45 · Cabool, MODec 12, 1973 · N12271 · DestroyedNTSB MKC74AK029Accident · 1 fatalClosedPiper PA-28 · Cuba, MODec 1, 1973 · N6554J · DestroyedNTSB MKC74DCG15Accident · No injuriesClosedAeronca 11AC · Ava, MONov 27, 1973 · N85875 · Substantial damageNTSB MKC74IK026Incident · No injuriesClosedPiper PA-32 · Readsville, MONov 26, 1973 · N3977W · Minor damageNTSB MKC74DCA17Accident · No injuriesClosedCessna 182P · Chesterfield, MONov 22, 1973 · N21358 · Substantial damageNTSB MKC74AK025Accident · 2 fatalClosedPiper PA-28R · Columbia, MONov 19, 1973 · N2307T · DestroyedNTSB MKC74AK020Accident · No injuriesClosedCurtis-Wrt C-46F · St.Louis, MONov 8, 1973 · N69346 · Substantial damageNTSB MKC74FCA15Accident · No injuriesClosedBeech E18S · F.Leonard Wood, MONov 5, 1973 · N3644B · Substantial damageNTSB MKC74FCA16Accident · Serious injuriesClosedPiper PA-32 · Rolla, MOOct 26, 1973 · N3222W · DestroyedNTSB MKC74DCA13Accident · No injuriesClosedCessna 150F · Matthews, MOOct 25, 1973 · N6887F · Substantial damageNTSB MKC74FCA14Accident · No injuriesClosedCessna 172M · Shelbyville, MOOct 24, 1973 · N12082 · Substantial damageNTSB MKC74FCA12Accident · No injuriesClosedBell 47G-5 · Creve Coeur, MOOct 22, 1973 · N2251W · Substantial damageNTSB MKC74DCA11Accident · No injuriesClosedGrumman G-164 · Charleston, MOOct 18, 1973 · N7248 · Substantial damageNTSB MKC74AK015Accident · 1 fatalClosedPiper PA-18 · Kennett, MOOct 3, 1973 · N1875P · DestroyedNTSB MKC74FCA10Accident · No injuriesClosedGrumman G-164A · Charleston, MOSep 28, 1973 · N6581 · Substantial damageNTSB MKC74DCG12Accident · No injuriesClosedCessna 180 · Kansas City, MOSep 20, 1973 · N26724 · Substantial damageNTSB MKC74FCG10Accident · Serious injuriesClosedMiniplane B-1 · Independence, MOSep 11, 1973 · N1006 · Substantial damageNTSB MKC74FCA08Accident · No injuriesClosedStinson 108-2 · Kennett, MOSep 10, 1973 · N9532K · Substantial damageNTSB MKC74DCG11Accident · No injuriesClosedLuscombe 8F · Lees Summit, MOSep 9, 1973 · N26507 · Substantial damageNTSB MKC74FCA07Accident · No injuriesClosedChampion 7ECA · Painton, MOSep 2, 1973 · N6311N · Substantial damageNTSB MKC74FCA06Accident · No injuriesClosedBeech E18S · St Louis, MOAug 29, 1973 · N1002C · Substantial damageNTSB MKC74AK007Accident · No injuriesClosedPiper PA-30 · Kansas City, MOAug 17, 1973 · N7876Y · Substantial damageNTSB MKC74FGG09Accident · 1 fatalClosedBensen B8 · Windsor, MOAug 12, 1973 · N6394 · DestroyedNTSB MKC74FCG06Accident · Minor injuriesClosedBell 47G-2 · Branson, MOAug 12, 1973 · N939B · Substantial damageNTSB MKC74FCG07Accident · No injuriesClosedCessna 140 · Kansas City, MOAug 10, 1973 · N2314N · Substantial damageNTSB MKC74FCA09Accident · No injuriesClosedBoeing A75N1 · Creve Coeur, MOAug 10, 1973 · N59768 · Substantial damageNTSB MKC74DCA05Accident · No injuriesClosedCessna 120 · House Springs, MOAug 10, 1973 · N2099V · Substantial damageNTSB MKC74DCA04Accident · No injuriesClosedBoeing A75 · Hannibal, MOAug 9, 1973 · N60421 · Substantial damageNTSB MKC74FCG05Accident · No injuriesClosedBeech A35 · Sedalia, MOAug 8, 1973 · N8478A · Substantial damageNTSB MKC74FCA03Accident · Minor injuriesClosedMooney M20E · Fenton, MOAug 5, 1973 · N79845 · Substantial damageNTSB MKC74AKO03Accident · 4 fatalClosedBellanca 14-19 · Kansas City, MOJul 31, 1973 · N1259R · DestroyedNTSB MKC74DCA01Accident · No injuriesClosedLuscombe 8F · Festus, MOJul 27, 1973 · N1386B · Substantial damageNTSB MKC74FCG04Accident · Serious injuriesClosedCessna 310 · Osage Beech, MOJul 26, 1973 · N7756Q · Substantial damageNTSB DEN74AD004Accident · Serious injuriesClosedBoeing 737 · St.Louis, MOJul 24, 1973 · N7370F · No damageNTSB MKC74FCG02Accident · No injuriesClosedBoeing A75N1 · Kansas City, MOJul 23, 1973 · N69696 · Substantial damageNTSB DCA74AZ003Accident · 38 fatalClosedFairchild FH227B · St.Louis, MOJul 23, 1973 · N4215 · DestroyedNTSB MKC74DCG03Accident · No injuriesClosedCessna 207 · Kansas City, MOJul 22, 1973 · N1574U · Substantial damageNTSB MKC74FCA02Accident · Minor injuriesClosedPiper PA-30 · Summersville, MOJul 20, 1973 · N8400Y · Substantial damageNTSB MKC74FCG08Accident · Serious injuriesClosedPiper PA-25 · Clifton Hill, MOJul 3, 1973 · N4904Y · Substantial damageNTSB MKC74FCG01Accident · No injuriesClosedAero Comdr 100 · Missouri City, MOJul 1, 1973 · N3637X · Substantial damageNTSB MKC73FCA30Accident · Minor injuriesClosedBell 47G-5 · St Louis, MOJun 24, 1973 · N7043J · DestroyedNTSB MKC73DCA29Accident · No injuriesClosedChampion 7KCAB · Houston, MOJun 21, 1973 · N2978G · Substantial damageNTSB MKC73DCG50Accident · No injuriesClosedCessna 150 · Marshall, MOJun 20, 1973 · N3030J · DestroyedNTSB MKC73AK074Accident · 2 fatalClosedAmer Avco AA1-B · Kansas City, MOJun 19, 1973 · N9417L · DestroyedNTSB MKC73FCG49Accident · Serious injuriesClosedAeronca L-3 · Branson, MOJun 17, 1973 · N48218 · Substantial damageNTSB MKC73DCG53Accident · Minor injuriesClosedSchweizer 1-23H · Grain Valley, MOJun 17, 1973 · N3908A · Substantial damageNTSB MKC73DCG49Accident · No injuriesClosedN.American Navion · Independence, MOJun 14, 1973 · N8698H · Substantial damageNTSB MKC73DCG51Accident · No injuriesClosedCessna 150 · Strafford, MOJun 9, 1973 · N23449 · Substantial damage