NTSB investigations, 1971, 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, 1971, 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\") = 1971
    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 MKC72AK042Accident · Serious injuriesClosedBoeing 727 · Kansas City, MODec 29, 1971 · N7277F · No damageNTSB CHI72AC054Accident · 2 fatalClosedPiper PA-30 · Chesterfield, MODec 26, 1971 · N7756Y · DestroyedNTSB MKC72AK035Accident · 2 fatalClosedPiper PA-28 · Success, MODec 13, 1971 · N2185T · DestroyedNTSB MKC72FCA18Accident · Serious injuriesClosedPiper PA-30 · Scott City, MODec 7, 1971 · N8040Y · DestroyedNTSB MKC72AK032Accident · 2 fatalClosedPiper PA-28 · Rutledge, MODec 1, 1971 · N3393R · 2 aircraft · Substantial damageNTSB MKC72AK031Accident · 4 fatalClosedBeech H35 · Bland, MONov 26, 1971 · N5520D · DestroyedNTSB MKC72FCA17Accident · No injuriesClosedCessna 172K · Fenton, MONov 25, 1971 · N7041G · Substantial damageNTSB MKC72FCA16Accident · No injuriesClosedN.American SNJ-4 · Chesterfield, MONov 16, 1971 · N1395N · Substantial damageNTSB MKC72DCG23Accident · No injuriesClosedPiper PA-24 · Joplin, MONov 8, 1971 · N9046P · Substantial damageNTSB MKC72DCA14Accident · No injuriesClosedBeech H18 · Bonne Terre, MONov 8, 1971 · N800G · Substantial damageNTSB MKC72DCA13Accident · No injuriesClosedPiper PA-22 · Vichy, MONov 6, 1971 · N2827P · Substantial damageNTSB MKC72FCA11Accident · No injuriesClosedCessna 150B · Creve Coeur, MOOct 27, 1971 · N7317X · Substantial damageNTSB MKC72DCA15Accident · No injuriesClosedCessna 182 · Jefferson City, MOOct 26, 1971 · N3241Y · Substantial damageNTSB MKC72DCG30Accident · No injuriesClosedN. American SNJ-5 · Grain Valley, MOOct 25, 1971 · N21JD · Substantial damageNTSB MKC72FCG31Accident · No injuriesClosedPiper PA-22 · Buffalo, MOOct 24, 1971 · N8603C · Substantial damageNTSB MKC72FCA12Accident · No injuriesClosedCessna 182H · Dexter, MOOct 19, 1971 · N1871X · Substantial damageNTSB MKC72FCG24Accident · No injuriesClosedBeech B35A · Warrensburg, MOOct 7, 1971 · N8756A · Substantial damageNTSB MKC72AK025Accident · 1 fatalClosedCessna 150L · Stover, MOOct 7, 1971 · N1600Q · DestroyedNTSB MKC72DCG27Accident · Minor injuriesClosedAero Comdr 100 · Grain Valley, MOOct 6, 1971 · N3637X · Substantial damageNTSB MKC72DCG25Accident · No injuriesClosedCessna 140 · Independence, MOOct 4, 1971 · N76567 · Substantial damageNTSB MKC72DCA09Accident · No injuriesClosedPiper PA-25 · Kewanee, MOOct 4, 1971 · N8740L · Substantial damageNTSB MKC72FCA10Accident · No injuriesClosedAero Comdr A-9B · Clarkton, MOOct 2, 1971 · N7761V · Substantial damageNTSB MKC72AK024Accident · 2 fatalClosedNavion A · Macon, MOOct 2, 1971 · N4249K · DestroyedNTSB MKC72DCG32Accident · No injuriesClosedCessna 310D · Lamar, MOSep 30, 1971 · N6925T · Substantial damageNTSB MKC72DCG23Accident · No injuriesClosedHelio Acft H-550A · Nevada, MOSep 30, 1971 · N9550A · Substantial damageNTSB MKC72DCG28Accident · No injuriesClosedLuscombe 8E · Waldron, MOSep 17, 1971 · N1356K · Substantial damageNTSB MKC72FCG20Accident · No injuriesClosedPiper PA-32 · Boonville, MOSep 15, 1971 · N3244W · Substantial damageNTSB MKC72FCG16Accident · Serious injuriesClosedGlobe GC-1B · Brunswick, MOSep 12, 1971 · N3843K · Substantial damageNTSB MKC72DCG19Accident · No injuriesClosedPiper PA-22 · Brookfield, MOSep 12, 1971 · N4790Z · Substantial damageNTSB MKC72FCG22Accident · No injuriesClosedCessna 310N · Mound City, MOSep 10, 1971 · N111KC · Substantial damageNTSB MKC72FCG17Accident · Serious injuriesClosedStinson 108-3 · Amazonia, MOSep 10, 1971 · N559C · Substantial damageNTSB MKC72FCG18Accident · No injuriesClosedCessna 206A · Richmond, MOSep 5, 1971 · N4644F · Substantial damageNTSB MKC72FCG15Accident · No injuriesClosedPiper PA-18 · Lexington, MOAug 28, 1971 · N9126D · Substantial damageNTSB MKC72DCA06Accident · No injuriesClosedCessna 150C · Poplar Bluff, MOAug 25, 1971 · N8434J · Substantial damageNTSB MKC72FCA07Accident · No injuriesClosedPiper PA-28 · Augusta, MOAug 22, 1971 · N5690U · Substantial damageNTSB MKC72FCG14Accident · Serious injuriesClosedCessna 210F · Bolivar, MOAug 21, 1971 · N4719F · DestroyedNTSB MKC72DCA05Accident · No injuriesClosedCessna 150J · Ft Leonard Wd, MOAug 16, 1971 · N50506 · Substantial damageNTSB MKC72FCG12Accident · No injuriesClosedCessna 310K · New Boston, MOAug 15, 1971 · N7014L · Substantial damageNTSB MKC72FCG11Accident · Minor injuriesClosedHiller UH-12A · Springfield, MOAug 11, 1971 · N4287C · Substantial damageNTSB CHI72FEV09Accident · No injuriesClosedPiper PA-25 · Perryville, MOAug 11, 1971 · N6221Z · Substantial damageNTSB MKC72DCG10Accident · No injuriesClosedPiper PA-28 · Osage City, MOAug 7, 1971 · N7134R · Substantial damageNTSB MKC72DCA03Accident · No injuriesClosedAero Comdr A9B · Fulton, MOAug 7, 1971 · N7706V · Substantial damageNTSB MKC72IK008Incident · Serious injuriesClosedBell 47G · St Louis, MOAug 3, 1971 · N54047 · Substantial damageNTSB MKC72DCG13Accident · Minor injuriesClosedPiper PA-12 · Chariton, MOAug 2, 1971 · N92775 · Substantial damageNTSB MKC72FCG09Accident · No injuriesClosedMong Sport MS-2-K · Grain Valley, MOJul 31, 1971 · N72411 · Substantial damageNTSB MKC72FCA04Accident · No injuriesClosedBoeing E75N1 · St.Charles, MOJul 30, 1971 · N4783V · Substantial damageNTSB MKC72DCG08Accident · No injuriesClosedCessna 170A · Gainsville, MOJul 28, 1971 · N9087A · Substantial damageNTSB MKC72FCG07Accident · Serious injuriesClosedPiper PA-28 · Stockton, MOJul 27, 1971 · N8669W · DestroyedNTSB MKC72FCA02Accident · 1 fatalClosedPiper PA-25 · Old Monroe, MOJul 20, 1971 · N6619Z · DestroyedNTSB MKC72IK006Incident · No injuriesClosedLockheed T-33 · R.Gebaur Afb, MOJul 18, 1971 · AF 70751 · 2 aircraft · Minor damage