Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MKC78FCA10Accident · Minor injuriesClosedHeying PDQ-2 · Creve Coeur, MODec 30, 1977 · N68079 · Substantial damage NTSB MKC78FCG12Accident · 1 fatalClosedCessna 177B · Grain Valley, MODec 29, 1977 · N34769 · Substantial damage NTSB MKC78DCA12Accident · No injuriesClosedPiper PA-22 · Chesterfield, MODec 29, 1977 · N5467Z · 2 aircraft · Substantial damage NTSB MKC78FCA13Accident · No injuriesClosedCessna 195 · Willow Springs, MODec 26, 1977 · N195RW · Substantial damage NTSB MKC78IA015Incident · No injuriesClosedCessna 402 · Rolla, MODec 17, 1977 · N3295Q · Minor damage NTSB MKC78FA012Accident · 2 fatalClosedPiper PA-28R · Fordland, MODec 8, 1977 · N38775 · Destroyed NTSB MKC78FCA09Accident · Serious injuriesClosedBeech A23-24 · Festus, MONov 24, 1977 · N3677Q · Substantial damage NTSB MKC78DCG09Accident · No injuriesClosedCessna 150 · Nevada, MONov 24, 1977 · N3708J · Substantial damage NTSB MKC78FCA08Accident · Minor injuriesClosedCoot A · Creve Coeur, MONov 22, 1977 · N107D · Destroyed NTSB MKC78FCA07Accident · Minor injuriesClosedCessna 150F · St.Louis, MONov 21, 1977 · N8613G · Substantial damage NTSB MKC78FCA06Accident · No injuriesClosedPiper PA-24 · Fenton, MONov 20, 1977 · N6958P · Substantial damage NTSB MKC78FCG08Accident · No injuriesClosedCessna 182A · Atherton, MONov 19, 1977 · N4722D · Substantial damage NTSB MKC78DCG10Accident · No injuriesClosedTerrill SPEC-L · Kimberling, MONov 18, 1977 · N3622G · Substantial damage NTSB MKC78DCA05Accident · No injuriesClosedCessna 150 · West Plains, MONov 11, 1977 · N51284 · Substantial damage NTSB MKC78FA006Accident · 1 fatalClosedCessna 210L · Odessa, MONov 1, 1977 · N29161 · Destroyed NTSB MKC78DCG06Accident · No injuriesClosedAero Comdr 520 · Lamar, MOOct 29, 1977 · N4178B · Substantial damage NTSB MKC78DCA04Accident · No injuriesClosedCessna A188B · Kahoka, MOOct 27, 1977 · N9333R · Substantial damage NTSB MKC78FA005Accident · 1 fatalClosedPiper PA-28 · Lamar, MOOct 25, 1977 · N7983N · Destroyed NTSB MKC77FCA03Accident · No injuriesClosedCessna 177B · Union, MOOct 25, 1977 · N30713 · Substantial damage NTSB MKC78FA003Accident · 1 fatalClosedAmer Avco AA-1B · St Louis, MOOct 23, 1977 · N1473R · Destroyed NTSB MKC78FCA02Accident · Serious injuriesClosedCessna 140A · Washington, MOOct 19, 1977 · N9445A · Destroyed NTSB MKC78DCA01Accident · No injuriesClosedPiper PA-30 · Festus, MOOct 16, 1977 · N7885Y · Substantial damage NTSB MKC77DCG04Accident · Minor injuriesClosedPiper PA-28 · Warrensburg, MOOct 14, 1977 · N7006C · Substantial damage NTSB MKC78FCG02Accident · No injuriesClosedPiper PA-28 · Sweet Springs, MOOct 7, 1977 · N4100Q · Substantial damage NTSB MKC78FCG01Accident · Serious injuriesClosedPiper PA-22 · Plattsburg, MOOct 1, 1977 · N631A · Substantial damage NTSB MKC77IA041Incident · No injuriesClosedCessna 402 · Vichy, MOSep 28, 1977 · N3295Q · Minor damage NTSB MKC77DCG59Accident · No injuriesClosedCessna 150 · Butler, MOSep 28, 1977 · N8528U · Substantial damage NTSB MKC77DCA33Accident · No injuriesClosedHughes 369H · Mexico, MOSep 27, 1977 · N8319F · Substantial damage NTSB MKC77FCA32Accident · Serious injuriesClosedCessna 172E · Senath, MOSep 22, 1977 · N3635S · Substantial damage NTSB MKC77FCA31Accident · No injuriesClosedPiper PA-30 · Vichy, MOSep 22, 1977 · N7866Y · Substantial damage NTSB MKC77DCG56Accident · Serious injuriesClosedPiper PA-28 · Ashland, MOSep 20, 1977 · N11BA · Substantial damage NTSB MKC77FCG55Accident · No injuriesClosedPiper PA-28 · Lake Ozark, MOSep 19, 1977 · N8385R · Substantial damage NTSB MKC77FCG57Accident · Minor injuriesClosedBell 47J · Branson, MOSep 17, 1977 · N8579F · Substantial damage NTSB MKC77DCG54Accident · No injuriesClosedCessna 182L · Springfield, MOSep 10, 1977 · N3490R · Substantial damage NTSB MKC77FCG53Accident · Minor injuriesClosedCessna 172I · Lebanon, MOSep 8, 1977 · N46137 · Substantial damage NTSB MKC77FCG52Accident · Minor injuriesClosedCessna 172K · Kimberling Cy, MOSep 2, 1977 · N84104 · Substantial damage NTSB MKC77FCG58Accident · No injuriesClosedCessna 207 · Lees Summit, MOAug 22, 1977 · N1674U · Substantial damage NTSB MKC77FCG49Accident · Minor injuriesClosedMcbemas Lark · Cassville, MOAug 18, 1977 · N4087X · Destroyed NTSB MKC77FA034Accident · 2 fatalClosedLuscombe 8A · Carthage, MOAug 18, 1977 · N71272 · Destroyed NTSB MKC77FCA30Accident · Minor injuriesClosedCessna 177RG · St.Charles, MOAug 15, 1977 · N1610H · Destroyed NTSB MKC77FA033Accident · 3 fatalClosedCessna 172D · St.Louis, MOAug 14, 1977 · N2113Y · Destroyed NTSB MKC77DCG47Accident · No injuriesClosedAeronca 0-58B · Lee'S Summit, MOAug 14, 1977 · N48431 · Substantial damage NTSB MKC77DCG48Accident · No injuriesClosedMooney M20C · Lee'S Summit, MOAug 10, 1977 · N6226U · Destroyed NTSB MKC77FA032Accident · No injuriesClosedN American 265-60 · Perryville, MOAug 9, 1977 · N8000U · Substantial damage NTSB MKC77DCG45Accident · No injuriesClosedCessna 120 · Boonville, MOAug 5, 1977 · N1785N · Substantial damage NTSB MKC77DCG43Accident · No injuriesClosedCessna 150 · Excelsior Spgs, MOAug 1, 1977 · N66095 · Substantial damage NTSB MKC77FCG42Accident · No injuriesClosedMooney M20A · Independence, MOJul 30, 1977 · N82EA · Destroyed NTSB MKC77DCG44Accident · No injuriesClosedAlon A2 · Grant City, MOJul 29, 1977 · N6555Q · Substantial damage NTSB MKC77FCG41Accident · No injuriesClosedPiper J-3 · Trenton, MOJul 26, 1977 · N88570 · Substantial damage NTSB MKC77DCG40Accident · No injuriesClosedPiper PA-25 · Cairo, MOJul 20, 1977 · N6476Z · Substantial damage