Skip to content

NTSB investigations, 1978, MO

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 MKC79FCG15Accident · Minor injuriesClosedPiper PA-28 · Pt Lookout, MODec 25, 1978 · N9089J · Substantial damage NTSB MKC79FA011Accident · 4 fatalClosedPiper PA-28 · Kennett, MODec 22, 1978 · N5716W · Destroyed NTSB MKC79DCG16Accident · No injuriesClosedPiper PA-28 · Buckner, MODec 16, 1978 · N1780T · Substantial damage NTSB MKC79FCA03Accident · No injuriesClosedCessna 182RG · Festus, MODec 12, 1978 · N2303C · Substantial damage NTSB MKC79DCG14Accident · No injuriesClosedCessna 205 · Liberty, MODec 9, 1978 · N1869Z · Substantial damage NTSB MKC78FCG13Accident · Minor injuriesClosedBeech E35 · Kirksville, MODec 2, 1978 · N3234C · Substantial damage NTSB MKC79FA006Accident · 4 fatalClosedCessna 182C · Eureka, MONov 22, 1978 · N8485T · Destroyed NTSB MKC79DER06Accident · No injuriesClosedCessna 172 · Eveleth, MONov 22, 1978 · N9816G · Substantial damage NTSB MKC79FCA01Accident · Serious injuriesClosedBell 47G-2 · St Louis, MONov 14, 1978 · N4997U · Substantial damage NTSB MKC79FCG12Accident · No injuriesClosedCessna U206F · Springfield, MONov 10, 1978 · N9658G · Substantial damage NTSB MKC79DCG11Accident · No injuriesClosedCessna 152 · Point Lookout, MONov 7, 1978 · N66947 · Substantial damage NTSB MKC79FCG10Accident · No injuriesClosedBeech B95-55 · Kansas City, MOOct 27, 1978 · N4825J · Substantial damage NTSB MKC79FCG08Accident · Serious injuriesClosedPiper PA-22 · Ozark, MOOct 21, 1978 · N9675D · Substantial damage NTSB MKC79FCA02Accident · No injuriesClosedBell 47J-2 · St Louis, MOOct 21, 1978 · N4989T · Substantial damage NTSB MKC78FCG09Accident · Serious injuriesClosedGlobe GC-1B · Bolivar, MOOct 20, 1978 · N80796 · Substantial damage NTSB MKC79FCG06Accident · No injuriesClosedPiper PA-31 · Marshall, MOOct 16, 1978 · N61463 · Substantial damage NTSB MKC79FCG07Accident · No injuriesClosedBellanca 7KCAB · Excelsior Spgs, MOOct 14, 1978 · N88063 · Substantial damage NTSB MKC79DCG05Accident · No injuriesClosedAeronca 7AC · Corning, MOOct 14, 1978 · N82140 · Substantial damage NTSB MKC79DCG03Accident · No injuriesClosedPiper PA-30 · Nevada, MOOct 10, 1978 · N7900Y · Substantial damage NTSB MKC78FCG02Accident · Serious injuriesClosedPiper PA-32 · Columbia, MOOct 7, 1978 · N4852S · Substantial damage NTSB MKC79FCG01Accident · Serious injuriesClosedCessna 150M · Milo, MOOct 1, 1978 · N3726V · Destroyed NTSB MKC78FCG71Accident · No injuriesClosedBeech C24R · Joplin, MOSep 30, 1978 · N18767 · Substantial damage NTSB MKC78DCA52Accident · No injuriesClosedPiper PA-28R · Memphis, MOSep 27, 1978 · N9350K · Substantial damage NTSB MKC78DCA51Accident · No injuriesClosedCessna 182H · Millersville, MOSep 26, 1978 · N2418X · Substantial damage NTSB MKC78FCG69Accident · Serious injuriesClosedCessna 172 · Gravois Mills, MOSep 23, 1978 · N70395 · Substantial damage NTSB MKC78FCG70Accident · Minor injuriesClosedCessna 172 · Higginsville, MOSep 22, 1978 · N737LX · Substantial damage NTSB MKC78DCG68Accident · No injuriesClosedCessna 170B · Grain Valley, MOSep 22, 1978 · N3542C · Substantial damage NTSB IAD78DA113Accident · Serious injuriesClosedBoeing 707 · St Louis, MOSep 20, 1978 · N7573A · No damage NTSB MKC78FA069Accident · 2 fatalClosedLuscombe 8A · Fayette, MOSep 11, 1978 · N28828 · Destroyed NTSB MKC78DCA49Accident · No injuriesClosedErco 415-C · Sullivan, MOSep 5, 1978 · N2400H · Substantial damage NTSB MKC78FCA50Accident · No injuriesClosedPiper PA-28 · Thayer, MOSep 4, 1978 · N32411 · Substantial damage NTSB MKC78FCA48Accident · Serious injuriesClosedCessna 182 · Cape Girardeau, MOAug 30, 1978 · N8148G · Substantial damage NTSB MKC78DCG62Accident · No injuriesClosedCessna 182 · Columbia, MOAug 27, 1978 · N52591 · Substantial damage NTSB MKC78DCG67Accident · No injuriesClosedPiper PA-25 · Excello, MOAug 23, 1978 · N7221Z · Substantial damage NTSB MKC78FA065Accident · 3 fatalClosedBell 47-G2 · Branson, MOAug 18, 1978 · N939B · Destroyed NTSB MKC78FCG60Accident · No injuriesClosedAero Comdr 680T · Springfield, MOAug 16, 1978 · N808GU · Substantial damage NTSB MKC78DCG61Accident · Minor injuriesClosedCessna 188 · Clarence, MOAug 14, 1978 · N21665 · Substantial damage NTSB MKC78FCG59Accident · No injuriesClosedCessna 172M · Kansas City, MOAug 13, 1978 · N1280U · Substantial damage NTSB MKC78FA062Accident · 4 fatalClosedPiper PA-28 · Brighton, MOAug 12, 1978 · N7245W · Substantial damage NTSB MKC78DCA46Accident · No injuriesClosedCessna 172 · Taylor, MOAug 12, 1978 · N4191L · Substantial damage NTSB MKC78FCA44Accident · Minor injuriesClosedCessna 172 · De Soto, MOAug 11, 1978 · N734JC · Substantial damage NTSB MKC78DCA45Accident · No injuriesClosedPiper PA-25 · Naylor, MOAug 11, 1978 · N7304Z · Substantial damage NTSB MKC78DCG58Accident · Minor injuriesClosedSchweizer 1-34 · Grain Valley, MOAug 5, 1978 · N7646 · Substantial damage NTSB MKC78DCA43Accident · No injuriesClosedPiper PA-36 · Wyconda, MOAug 3, 1978 · N57702 · Destroyed NTSB MKC78FA057Accident · Serious injuriesClosedHughes 269A · Jefferson City, MOAug 1, 1978 · N90MP · Substantial damage NTSB MKC78FCA47Accident · Minor injuriesClosedCessna 172N · Pevely, MOJul 31, 1978 · N734MH · Substantial damage NTSB MKC78DCG54Accident · No injuriesClosedPiper PA-28R · Bethany, MOJul 31, 1978 · N47416 · Substantial damage NTSB MKC78FCA47Accident · No injuriesClosedCessna 180 · Charleston, MOJul 30, 1978 · N66675 · Substantial damage NTSB MKC78FCA40Accident · Minor injuriesClosedCessna 150 · St Charles, MOJul 29, 1978 · N19552 · Substantial damage NTSB MKC78FCA42Accident · Serious injuriesClosedCessna 195 · Rolla, MOJul 27, 1978 · N4331V · Destroyed