NTSB investigations, 1981, MO

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1981, 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\") = 1981
    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 MKC82FCG16Accident · Minor injuriesClosedCessna 150F · Independence, MODec 31, 1981 · N8287F · Substantial damageNTSB MKC82FCA07Accident · No injuriesClosedBrantly B-2 · Kennett, MODec 25, 1981 · N5990X · DestroyedNTSB MKC82FA014Accident · 2 fatalClosedPiper PA-28 · Hedrick, MODec 20, 1981 · N9403W · DestroyedNTSB MKC82DCG13Accident · Minor injuriesClosedPiper PA-28 · St.Joseph, MODec 19, 1981 · N33574 · Substantial damageNTSB MKC82DCA06Accident · No injuriesClosedCessna 150M · Lutesville, MODec 13, 1981 · N8792U · Substantial damageNTSB MKC82FA011Accident · No injuriesClosedCessna 172 · Kansas City, MODec 11, 1981 · N35672 · Substantial damageNTSB MKC82DCG10Accident · No injuriesClosedMustang II · Kearney, MONov 29, 1981 · N48342 · Substantial damageNTSB MKC82DCG12Accident · No injuriesClosedPiper PA-28 · Willow Spgs, MONov 27, 1981 · N8276H · Substantial damageNTSB MKC82FCG09Accident · No injuriesClosedBeech V35 · East Lynne, MONov 22, 1981 · N2054W · Substantial damageNTSB MKC82DCG07Accident · Minor injuriesClosedVolksplane VP-1 · St Joseph, MONov 21, 1981 · N92217 · Substantial damageNTSB MKC82DCA05Accident · No injuriesClosedCessna 172D · Jefferson City, MONov 21, 1981 · N2509Y · Substantial damageNTSB MKC82FCA04Accident · No injuriesClosedCessna 182Q · Eunice, MONov 20, 1981 · N7578S · Substantial damageNTSB MKC82FCG08Accident · Minor injuriesClosedBeech J35 · Sedalia, MONov 19, 1981 · N7263B · Substantial damageNTSB MKC82FCA03Accident · No injuriesClosedLuscombe 8A · Bunker, MONov 13, 1981 · N71130 · Substantial damageNTSB MKC82FA005Accident · 1 fatalClosedPitts SPL · Oak Grove, MONov 13, 1981 · N77LB · DestroyedNTSB MKC82FCG06Accident · Minor injuriesClosedPiper PA-28R · Macomb, MONov 5, 1981 · N5084S · Substantial damageNTSB MKC82FCG05Accident · Minor injuriesClosedCessna 150M · Eldon, MONov 5, 1981 · N3120V · DestroyedNTSB MKC82FCA02Accident · Minor injuriesClosedCessna 172 · Piedmont, MONov 2, 1981 · N7284A · DestroyedNTSB MKC82FA004Accident · 2 fatalClosedBeech G33 · Rushville, MOOct 31, 1981 · N1649W · DestroyedNTSB MKC82FCG03Accident · Minor injuriesClosedBensen B-8 · Joplin, MOOct 19, 1981 · N3071 · Substantial damageNTSB MKC82DA002Accident · No injuriesClosedBoeing 727 · St Louis, MOOct 12, 1981 · N8142N · Substantial damageNTSB MKC82DCG02Accident · No injuriesClosedPiper PA-38 · Forsyth, MOOct 2, 1981 · N91324 · Substantial damageNTSB MKC82DCG01Accident · No injuriesClosedCessna 152 · Point Lookout, MOOct 2, 1981 · N49480 · Substantial damageNTSB MKC81FCA01Accident · No injuriesClosedPiper PA-38 · Chesterfield, MOOct 1, 1981 · N6342A · Substantial damageNTSB MKC81DCA26Accident · No injuriesClosedPiper PA-38 · Poplar Bluff, MOSep 28, 1981 · N2437D · Substantial damageNTSB MKC81FCG56Accident · No injuriesClosedCessna 152 · Liberty, MOSep 12, 1981 · N48920 · Substantial damageNTSB MKC81DCG57Accident · No injuriesClosedMooney M20C · Brookfield, MOSep 11, 1981 · N6288U · Substantial damageNTSB MKC81DCA25Accident · No injuriesClosedCessna 152 · Rollo, MOAug 30, 1981 · N24400 · Substantial damageNTSB MKC81FA052Accident · Serious injuriesClosedPiper PA-38 · Clinton, MOAug 29, 1981 · N9663T · DestroyedNTSB MKC81FCG54Accident · No injuriesClosedRockwell 114 · Warrensburg, MOAug 23, 1981 · N5773N · Substantial damageNTSB MKC81FA051Accident · No injuriesClosedDouglas DC-9 · St.Louis, MOAug 13, 1981 · N924L · Substantial damageNTSB MKC81FCA23Accident · No injuriesClosedGrumman AA-5B · Wentzville, MOAug 4, 1981 · N28917 · Substantial damageNTSB MKC81FCA22Accident · No injuriesClosedGrumman G-164A · Fisk, MOAug 3, 1981 · N8605H · Substantial damageNTSB MKC81FA048Accident · 4 fatalClosedPiper PA-28 · Kirksville, MOAug 3, 1981 · N8080Z · DestroyedNTSB MKC81FCA21Accident · No injuriesClosedCessna 172 · Fenton, MOAug 2, 1981 · N734FA · Substantial damageNTSB MKC81FA046Accident · 1 fatalClosedBensen B-8M · Columbia, MOJul 31, 1981 · N8068H · DestroyedNTSB MKC81FCA24Accident · No injuriesClosedMooney M20F · Licking, MOJul 30, 1981 · N7402V · Substantial damageNTSB MKC81FA045Accident · 1 fatalClosedPietenpol A'CAMP · Emma, MOJul 26, 1981 · N68064 · DestroyedNTSB MKC81DCG52Accident · No injuriesClosedCessna 150 · Lees Summit, MOJul 26, 1981 · N7691C · Substantial damageNTSB MKC81DCA20Accident · No injuriesClosedGrumman G-164A · Fagus, MOJul 25, 1981 · N677U · Substantial damageNTSB MKC81DCG48Accident · Minor injuriesClosedPiper PA-28 · Trenton, MOJul 17, 1981 · N8304G · Substantial damageNTSB MKC81DCA18Accident · No injuriesClosedCessna 182P · Kahoka, MOJul 15, 1981 · N9884M · DestroyedNTSB MKC81FCG50Accident · No injuriesClosedCessna 152 · Liberty, MOJul 12, 1981 · N66949 · Substantial damageNTSB MKC81FCA19Accident · No injuriesClosedVarga 2150A · Sullivan, MOJul 12, 1981 · N8265J · Substantial damageNTSB MKC81FCG49Accident · No injuriesClosedPiper PA-25 · Knob Noster, MOJul 11, 1981 · N8516L · DestroyedNTSB MKC81FCG46Accident · No injuriesClosedCessna A188B · Orrick, MOJul 11, 1981 · N731BD · Substantial damageNTSB MKC81FCG47Accident · No injuriesClosedCessna 182 · Osage Beach, MOJul 10, 1981 · N735ND · Substantial damageNTSB MKC81FCG45Accident · No injuriesClosedCessna 182A · Lexington, MOJul 5, 1981 · N9949B · Substantial damageNTSB MKC81FA042Accident · 2 fatalClosedCessna 172G · Newburg, MOJul 5, 1981 · N1383F · DestroyedNTSB MKC81FCG44Accident · No injuriesClosedPiper PA-32 · Liberty, MOJul 3, 1981 · N4828S · Substantial damage