Skip to content

NTSB investigations, 1980, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1980, MO per year, 1962–2026: 3,556 cases
1962	1
1963	1
1964	118
1965	136
1966	155
1967	173
1968	100
1969	83
1970	111
1971	112
1972	80
1973	80
1974	80
1975	98
1976	101
1977	96
1978	111
1979	100
1980	85
1981	95
1982	86
1983	84
1984	74
1985	72
1986	54
1987	59
1988	67
1989	47
1990	41
1991	37
1992	40
1993	58
1994	47
1995	39
1996	28
1997	33
1998	29
1999	43
2000	31
2001	33
2002	30
2003	30
2004	32
2005	31
2006	27
2007	31
2008	31
2009	23
2010	23
2011	32
2012	33
2013	21
2014	19
2015	31
2016	29
2017	28
2018	22
2019	20
2020	24
2021	15
2022	19
2023	25
2024	22
2025	19
2026	21

Where

Latest cases

Query with SQL

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") = 1980 AND c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1980
    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.

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") = 1980
  AND c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MKC81FCG19Accident · No injuriesClosedBede BD-5B · Springfield, MODec 15, 1980 · N8065V · Substantial damage NTSB MKC81FCG18Accident · No injuriesClosedPiper PA-31 · Springfield, MODec 10, 1980 · N450GC · Substantial damage NTSB MKC81FCA05Accident · Serious injuriesClosedPiper PA-36 · Hayti, MODec 5, 1980 · N55713 · Destroyed NTSB MKC81IA008Incident · No injuriesClosedBeech C90 · Kansas City, MONov 28, 1980 · N16 · Minor damage NTSB MKC81FA007Accident · No injuriesClosedAvions Mrcl 10 · Kansas City, MONov 20, 1980 · N223FJ · Substantial damage NTSB MKC81FCG15Accident · No injuriesClosedPiper PA-22 · Independence, MONov 15, 1980 · N2637P · Substantial damage NTSB MKC81DCA04Accident · No injuriesClosedPiper PA-24 · Des Arc, MONov 13, 1980 · N6345P · Substantial damage NTSB MKC81FA006Accident · Minor injuriesClosedPiper PA-28 · Independence, MONov 12, 1980 · N8086H · Substantial damage NTSB MKC81DCG11Accident · No injuriesClosedPiper PA-32 · Green City, MONov 11, 1980 · N3209W · Substantial damage NTSB MKC81DCG10Accident · Minor injuriesClosedCessna 150 · Webb City, MONov 11, 1980 · N8290F · Substantial damage NTSB MKC81FCG12Accident · No injuriesClosedBeech H35 · Columbia, MONov 9, 1980 · N5431D · Substantial damage NTSB MKC81DCG13Accident · Serious injuriesClosedCessna 150G · Columbia, MONov 7, 1980 · N3799J · Substantial damage NTSB MKC81DCG09Accident · No injuriesClosedMinibat 01 · Grain Valley, MONov 2, 1980 · N3783R · Substantial damage NTSB MKC81FCA03Accident · No injuriesClosedCessna 172H · West Plains, MOOct 24, 1980 · N3236L · Substantial damage NTSB MKC81FCG08Accident · No injuriesClosedPiper PA-30 · Springfield, MOOct 21, 1980 · N8456Y · Substantial damage NTSB MKC81DCG05Accident · No injuriesClosedCassutt Iiim · Independence, MOOct 18, 1980 · N17517 · Substantial damage NTSB MKC81DCG07Accident · No injuriesClosedPiper PA-28 · Cassville, MOOct 17, 1980 · N95436 · Substantial damage NTSB MKC81FCG04Accident · No injuriesClosedPiper PA-32R · Ozark, MOOct 15, 1980 · N7698C · Substantial damage NTSB MKC80DCG06Accident · No injuriesClosedCessna 172M · Greenfield, MOOct 14, 1980 · N9658V · Substantial damage NTSB MKC81FCA12Accident · Minor injuriesClosedCessna 182N · Salem, MOOct 13, 1980 · N92200 · Destroyed NTSB MKC81FCA01Accident · Serious injuriesClosedBellanca 17-30A · Fenton, MOOct 9, 1980 · N8856V · Substantial damage NTSB MKC81FA004Accident · 1 fatalClosedPiper J3C-65 · Senath, MOOct 8, 1980 · N98058 · Destroyed NTSB MKC81DCG02Accident · No injuriesClosedTaylorcraft BC12-D · Shell Knob, MOOct 4, 1980 · N96937 · Substantial damage NTSB MKC81FA001Accident · No injuriesClosedCessna 337A · Springfield, MOOct 2, 1980 · N3666X · Substantial damage NTSB MKC80FCG47Accident · Minor injuriesClosedBeech C23 · Ozark, MOSep 18, 1980 · N24567 · Substantial damage NTSB MKC80FA057Accident · 3 fatalClosedGulf-Amer AA-5B · Chesterfield, MOSep 17, 1980 · N4516L · Destroyed NTSB MKC80FCG43Accident · No injuriesClosedBeech C23 · Osage Beach, MOSep 10, 1980 · N823BA · Destroyed NTSB MKC80DCG45Accident · No injuriesClosedPiper PA-28 · Albany, MOSep 8, 1980 · N1883T · Substantial damage NTSB MKC80FCG41Accident · No injuriesClosedPiper PA-22 · Cassville, MOAug 21, 1980 · N1212H · Substantial damage NTSB MKC80FCA30Accident · No injuriesClosedAir Tractor AT-301 · Mathews, MOAug 21, 1980 · N8762S · Substantial damage NTSB MKC80FCA28Accident · No injuriesClosedLuscombe 8A · Kennett, MOAug 18, 1980 · N71877 · Substantial damage NTSB MKC80FCA29Accident · No injuriesClosedCessna 152 · Chesterfield, MOAug 16, 1980 · N757YE · Substantial damage NTSB MKC80FCA27Accident · No injuriesClosedGrum-Amer AA-1B · Farmington, MOAug 10, 1980 · N9897L · Substantial damage NTSB MKC80FCG40Accident · No injuriesClosedCessna 170 · Lake Winnebago, MOAug 7, 1980 · N4137V · Destroyed NTSB MKC80FCG37Accident · No injuriesClosedMooney M21 · Lee'S Summit, MOAug 6, 1980 · N5601Q · Substantial damage NTSB MKC80FCG38Accident · No injuriesClosedBeech A35 · Lees Summit, MOAug 2, 1980 · N8731A · Substantial damage NTSB MKC80FCA24Accident · Minor injuriesClosedBensen B8M · Chesterfield, MOJul 27, 1980 · N5584C · Substantial damage NTSB MKC80DCA25Accident · No injuriesClosedLuscombe 8F · Sullivan, MOJul 27, 1980 · N9930C · Substantial damage NTSB MKC80DCG35Accident · No injuriesClosedStinson 108 · Liberty, MOJul 23, 1980 · N97350 · Substantial damage NTSB MKC80FCA23Accident · No injuriesClosedCessna 152 · Poplar Bluff, MOJul 19, 1980 · N48904 · Substantial damage NTSB MKC80FCA22Accident · 1 fatalClosedBensen B8M · Montgomery Cy, MOJul 19, 1980 · N9981 · Substantial damage NTSB MKC80FA046Accident · No injuriesClosedCessna P210N · Marceline, MOJul 17, 1980 · N731XH · Substantial damage NTSB MKC80FA045Accident · No injuriesClosedBeech 95-B55 · Malden, MOJul 17, 1980 · N7EW · Substantial damage NTSB MKC80FCA26Accident · No injuriesClosedCessna 188B · Advance, MOJul 11, 1980 · N84354 · Substantial damage NTSB MKC80FCA21Accident · Serious injuriesClosedBeech C23 · St Charles, MOJul 11, 1980 · N9368S · Substantial damage NTSB MKC80FCG36Accident · No injuriesClosedPiper PA-28 · Grain Valley, MOJul 6, 1980 · N5780F · Substantial damage NTSB MKC80DCG32Accident · No injuriesClosedPiper PA-28 · Excelsior Spgs, MOJul 1, 1980 · N33480 · Substantial damage NTSB MKC80FCG31Accident · Minor injuriesClosedAero Comdr A-9B · Cameron, MOJun 28, 1980 · N8025V · Substantial damage NTSB MKC80FCA20Accident · No injuriesClosedCessna 182RG · Wentzville, MOJun 27, 1980 · N5241S · Substantial damage NTSB MKC80FA042Accident · 1 fatalClosedCessna 172M · Cardwell, MOJun 26, 1980 · N20495 · Destroyed