Skip to content

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1979, MO per year, 1962–2026: 3,555 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	20

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") = 1979 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\") = 1979
    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") = 1979
  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 MKC80DCA05Accident · Minor injuriesClosedCessna 185F · Chesterfield, MODec 15, 1979 · N9712H · Substantial damage NTSB MKC80FA014Accident · 1 fatalClosedCessna 182S · Womack, MODec 11, 1979 · N3594U · Destroyed NTSB MKC80FA013Accident · No injuriesClosedPiper PA-31 · Lee'S Summit, MODec 11, 1979 · N7511L · Substantial damage NTSB MKC80DCA04Accident · Serious injuriesClosedAdams,Md A55 · Ballwin, MODec 9, 1979 · N1060N · Minor damage NTSB MKC80DCG05Accident · No injuriesClosedCessna 152 · Lee'S Summit, MODec 6, 1979 · N24547 · Substantial damage NTSB MKC80DCA03Accident · No injuriesClosedEnstrom F-28A · St. Louis, MODec 2, 1979 · N4896 · Substantial damage NTSB MKC80FCG03Accident · No injuriesClosedPiper PA-25 · Salisbury, MONov 28, 1979 · N4546Y · Substantial damage NTSB MKC80FCG07Accident · Minor injuriesClosedPiper PA-18 · Lincoln, MONov 27, 1979 · N82076 · Substantial damage NTSB MKC80FCA02Accident · Serious injuriesClosedYoung-Owens Cassut · Valles Mines, MONov 25, 1979 · N67Y · Substantial damage NTSB MKC80FA007Accident · 1 fatalClosedCessna 210 · Mountain View, MONov 21, 1979 · N732EH · Destroyed NTSB MKC80FA008Accident · 1 fatalClosedAmer Avco AA1-A · New Boston, MONov 20, 1979 · N9387L · Destroyed NTSB MKC80FA005Accident · 1 fatalClosedCessna 150D · Stet, MONov 16, 1979 · N7999Z · Destroyed NTSB MKC80DCA01Accident · No injuriesClosedCessna 150L · Willow Springs, MONov 15, 1979 · N7137G · Substantial damage NTSB MKC80FCG02Accident · No injuriesClosedBeech 58 · Kansas City, MONov 14, 1979 · N7347R · Substantial damage NTSB MKC80DCG01Accident · Minor injuriesClosedCessna 152 · Warrensburg, MONov 10, 1979 · N69206 · Substantial damage NTSB MKC80FA002Accident · Minor injuriesClosedPiper PA-22 · Lee'S Summit, MOOct 28, 1979 · N3425A · Substantial damage NTSB MKC79DCG81Accident · No injuriesClosedPiper PA-32 · Green City, MOSep 30, 1979 · N3209W · Substantial damage NTSB MKC79FA058Accident · Minor injuriesClosedCessna 177 · Freeman, MOSep 22, 1979 · N3261T · Substantial damage NTSB MKC79DCG80Accident · No injuriesClosedPiper PA-28 · Lamar, MOSep 22, 1979 · N1214T · Substantial damage NTSB MKC79FA057Accident · 1 fatalClosedCessna 150F · West Quincy, MOSep 20, 1979 · N8240S · Substantial damage NTSB MKC79FCG79Accident · Minor injuriesClosedStoeger Vol VJ22 · Waldron, MOSep 19, 1979 · N16DS · Substantial damage NTSB MKC79FCG78Accident · No injuriesClosedWar FW-190 · Harrisonville, MOSep 19, 1979 · N18828 · Substantial damage NTSB MKC79FA054Accident · 1 fatalClosedPiper PA-28 · Mountain View, MOSep 13, 1979 · N5518V · Destroyed NTSB MKC79FCG77Accident · Serious injuriesClosedPiper PA-28R · Lake Winnebago, MOSep 11, 1979 · N1094X · Destroyed NTSB MKC79DA053Incident · No injuriesClosedBeech 95 · St Charles, MOSep 6, 1979 · N84Z · Minor damage NTSB MKC79DCG76Accident · No injuriesClosedCessna 150 · Branson, MOAug 24, 1979 · N704UB · Substantial damage NTSB MKC79FCG74Accident · No injuriesClosedCessna 150E · Pleasant Hill, MOAug 21, 1979 · N4070U · Substantial damage NTSB MKC79DCG72Accident · No injuriesClosedCessna 150 · Odessa, MOAug 19, 1979 · N16025 · Substantial damage NTSB MKC79FA048Accident · 1 fatalClosedCessna 150J · Pleasant Hill, MOAug 14, 1979 · N60677 · Destroyed NTSB MKC79FCG69Accident · Serious injuriesClosedPiper PA-28 · Gainesville, MOAug 12, 1979 · N6546J · Destroyed NTSB MKC79FA049Accident · Serious injuriesClosedBalloon WKS F'FLY7 · Clinton, MOAug 12, 1979 · N2076F · No damage NTSB MKC79FCG68Accident · Minor injuriesClosedBeech F35 · Theodosia, MOAug 10, 1979 · N4233B · Destroyed NTSB MKC79DCA25Accident · No injuriesClosedPiper PA-28 · Alton, MOAug 9, 1979 · N5931W · Substantial damage NTSB MKC79FCG66Accident · No injuriesClosedCessna 150 · Ozark, MOAug 1, 1979 · N4065V · Substantial damage NTSB MKC79FCA24Accident · No injuriesClosedGrumman G-164A · Risco, MOAug 1, 1979 · N8499 · Substantial damage NTSB MKC79FCA23Accident · No injuriesClosedGrumman G-164 · Neelyville, MOJul 31, 1979 · N701Y · Substantial damage NTSB MKC79FCA22Accident · No injuriesClosedCessna 172 · St Peters, MOJul 31, 1979 · N1461E · Substantial damage NTSB MKC79DCG65Accident · No injuriesClosedPiper PA-28 · Columbia, MOJul 28, 1979 · N57320 · Substantial damage NTSB MKC79FA044Accident · No injuriesClosedCessna 401 · St.Louis, MOJul 26, 1979 · N8299F · Substantial damage NTSB MKC79DA045Accident · Serious injuriesClosedConvair 580 · Joplin, MOJul 26, 1979 · N120 · No damage NTSB MKC79FA042Accident · No injuriesClosedBeech E18S · Ft Wood, MOJul 25, 1979 · N3785B · Substantial damage NTSB MKC79FCA21Accident · Serious injuriesClosedCessna 177RG · Thayer, MOJul 22, 1979 · N53097 · Substantial damage NTSB MKC79FCG63Accident · No injuriesClosedPiper PA-17 · Warrensburg, MOJul 21, 1979 · N4894H · Substantial damage NTSB MKC79FA041Accident · 1 fatalClosedAmer Avco AA-1A · Versailles, MOJul 20, 1979 · N9355L · Destroyed NTSB MKC79DC662Accident · No injuriesClosedRockwell S2R · Mound City, MOJul 17, 1979 · N5012X · Substantial damage NTSB MKC79DCG59Accident · No injuriesClosedBensen Gyro · Mountain Grove, MOJul 15, 1979 · N47814 · Substantial damage NTSB MKC79DCA20Accident · No injuriesClosedGrumman G-164A · Clarence, MOJul 10, 1979 · N676U · Destroyed NTSB MKC79FCG58Accident · No injuriesClosedPiper PA-22 · Clinton, MOJul 9, 1979 · N4707C · Substantial damage NTSB MKC79DCG53Accident · No injuriesClosedMooney M20C · Ava, MOJul 3, 1979 · N6668R · Substantial damage NTSB MKC79FCA19Accident · 2 fatalClosedDavis DA2B · Bowling Green, MOJun 23, 1979 · N74FJ · Destroyed