NTSB investigations, 1965, MO

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1965, 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\") = 1965
    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 MKC66D0340Accident · No injuriesClosedCessna 150 · Faucett, MODec 29, 1965 · N8955S · Substantial damageNTSB MKC66F0427Accident · Serious injuriesClosedCessna 172F · Brigeton, MODec 26, 1965 · N7914U · DestroyedNTSB MKC66F0375Accident · No injuriesClosedBeech N35 · Springfield, MODec 21, 1965 · N1224Z · Substantial damageNTSB MKC66F0325Accident · No injuriesClosedCessna 172F · St Louis, MODec 17, 1965 · N8621U · Substantial damageNTSB MKC66D0341Accident · No injuriesClosedCessna 150 · St Charles, MODec 16, 1965 · N8666S · Substantial damageNTSB MKC66D0314Accident · No injuriesClosedCessna 182 · Cameron, MONov 25, 1965 · N5353B · Substantial damageNTSB MKC66A0329Accident · Serious injuriesClosedPiper PA-28 · Gravois Mills, MONov 14, 1965 · N9068W · No damageNTSB MKC66F0320Accident · No injuriesClosedSwift GC-1B · Republic, MONov 13, 1965 · N80663 · Substantial damageNTSB MKC66F0333Accident · No injuriesClosedPiper PA-22 · Cape Girardeau, MONov 11, 1965 · N3968P · Substantial damageNTSB MKC66F0300Accident · No injuriesClosedMooney M20 · Napoleon, MONov 8, 1965 · N1255X · Substantial damageNTSB MKC66D0357Accident · No injuriesClosedPiper PA-22 · Centerville, MONov 8, 1965 · N2663P · Substantial damageNTSB MKC66F0291Accident · Minor injuriesClosedPiper PA-22 · Trenton, MOOct 31, 1965 · N5335Z · Substantial damageNTSB MKC66F0328Accident · Minor injuriesClosedCessna 185C · Fenton, MOOct 26, 1965 · N5806T · Substantial damageNTSB MKC66F0283Accident · Minor injuriesClosedBeechcraft 35-33 · Marshall, MOOct 24, 1965 · N938T · DestroyedNTSB MKC66D0290Accident · No injuriesClosedCessna 172 · Reed Springs, MOOct 23, 1965 · N7286T · Substantial damageNTSB MKC66A0029Accident · 1 fatalClosedBeech 35 · Green City, MOOct 20, 1965 · N3105V · DestroyedNTSB MKC66D0280Accident · No injuriesClosedCessna 170B · Wheton, MOOct 19, 1965 · N8070A · Substantial damageNTSB MKC66F0288Accident · No injuriesClosedPiper PA-22 · Boschertown, MOOct 15, 1965 · N47332 · Substantial damageNTSB MKC66A0026Accident · 3 fatalClosedCessna 172E · Kansas City, MOOct 14, 1965 · N7745U · DestroyedNTSB MKC66D0257Accident · No injuriesClosedCessna 172 · Warrensburg, MOOct 13, 1965 · N5674R · Substantial damageNTSB MKC66F0389Accident · No injuriesClosedBeech E35 · Kansas City, MOOct 8, 1965 · N3510B · Substantial damageNTSB MKC66A0023Accident · 3 fatalClosedCessna 172C · Fulton, MOOct 8, 1965 · N1578Y · DestroyedNTSB MKC66A0022Accident · Serious injuriesClosedAir & Space 18A · Creve Coeur, MOOct 7, 1965 · N6166S · Substantial damageNTSB MKC66F0249Accident · Minor injuriesClosedBeechcraft T-34 · Dearborn, MOOct 4, 1965 · N1228 · Substantial damageNTSB MKC66F0268Accident · Minor injuriesClosedCessna 150 · Warrensburg, MOSep 28, 1965 · N7938Z · Substantial damageNTSB MKC66F0258Accident · No injuriesClosedMooney M20E · Carrollton, MOSep 26, 1965 · N79369 · Substantial damageNTSB MKC66F0279Accident · Minor injuriesClosedCessna 150 · Bloomsdale, MOSep 25, 1965 · N4391U · DestroyedNTSB MKC66F0273Accident · No injuriesClosedLockheed 12A · Kansas City, MOSep 19, 1965 · N1161V · Substantial damageNTSB MKC66F0252Accident · No injuriesClosedMooney M20C · Doniphan, MOSep 18, 1965 · N7192U · Substantial damageNTSB MKC66D0244Accident · No injuriesClosedPiper PA-23 · Springfield, MOSep 14, 1965 · N2180P · Substantial damageNTSB MKC66F0231Accident · No injuriesClosedPiper PA-22 · Bigelow, MOSep 13, 1965 · N7033D · Substantial damageNTSB MKC66A0018Accident · No injuriesClosedConvair CV-880 · Kansas City, MOSep 13, 1965 · N820TW · DestroyedNTSB MKC66F0245Accident · Serious injuriesClosedTaylorcraft BC12D · Waldron, MOSep 12, 1965 · N43675 · DestroyedNTSB MKC66D0289Accident · No injuriesClosedCessna 172 · Festus, MOSep 8, 1965 · N7662X · Substantial damageNTSB MKC66F0216Accident · No injuriesClosedCessna 182 · Chesterfield, MOSep 1, 1965 · N9200X · Substantial damageNTSB MKC66D0256Accident · No injuriesClosedPiper PA-28 · Sedalia, MOAug 29, 1965 · N8520W · Substantial damageNTSB MKC66D0220Accident · Minor injuriesClosedNavion B · Lathrop, MOAug 28, 1965 · N5397K · Substantial damageNTSB MKC66F0216Accident · No injuriesClosedAero Cmdr 520 · Warrensburg, MOAug 27, 1965 · N2604B · Substantial damageNTSB MKC66D0207Accident · No injuriesClosedCessna 210 · Branson, MOAug 26, 1965 · N3932Y · Substantial damageNTSB MKC66D0353Accident · No injuriesClosedBeechcraft 95-B55 · Grandin, MOAug 22, 1965 · N129Q · Substantial damageNTSB MKC66D0185Accident · No injuriesClosedBeechcraft M-35 · Osage Beach, MOAug 20, 1965 · N313Z · Substantial damageNTSB MKC66F0211Accident · No injuriesClosedPiper PA-22 · Warrensburg, MOAug 19, 1965 · N8298C · Substantial damageNTSB MKC66F0175Accident · No injuriesClosedLuscombe 8A · Excelsior Sps, MOAug 17, 1965 · N1004K · Substantial damageNTSB MKC66D0156Accident · No injuriesClosedCessna 172 · Camdenton, MOAug 16, 1965 · N5305T · Substantial damageNTSB MKC66F0344Accident · No injuriesClosedRyan ST-3KR · Fenton, MOAug 14, 1965 · N46220 · 2 aircraft · DestroyedNTSB MKC66D0154Accident · No injuriesClosedCessna 175 · Clinton, MOAug 13, 1965 · N8166T · Substantial damageNTSB MKC66D0202Accident · No injuriesClosedCessna 170B · Carthage, MOAug 12, 1965 · N3489C · Substantial damageNTSB MKC66D0138Accident · No injuriesClosedPiper PA-28 · Branson, MOAug 11, 1965 · N9063W · Substantial damageNTSB MKC66D0153Accident · No injuriesClosedMooney M21 · Cassville, MOAug 10, 1965 · N56590 · Substantial damageNTSB MKC66F0145Accident · No injuriesClosedCessna 150 · Montrose, MOAug 9, 1965 · N7943E · Substantial damage