Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MKC73DCG31Accident · No injuriesClosedCessna 172D · Queen City, MODec 24, 1972 · N2817U · Substantial damage NTSB MKC73FCG22Accident · No injuriesClosedBeech M35 · Independence, MODec 23, 1972 · N2028C · Substantial damage NTSB MKC73AK045Accident · 4 fatalClosedPiper PA-28R · St.Charles, MODec 22, 1972 · N7571J · Destroyed NTSB MKC73FCA13Accident · Serious injuriesClosedCessna 182H · Chesterfield, MODec 21, 1972 · N1952X · Substantial damage NTSB MKC73FGC21Accident · 1 fatalClosedBeech T-34A · Wheeling, MODec 20, 1972 · N74020 · Substantial damage NTSB MKC73FCA12Accident · No injuriesClosedCessna 337B · St Louis, MODec 18, 1972 · N2421S · Substantial damage NTSB MKC73DCA11Accident · No injuriesClosedPiper PA-28R · Festus, MODec 15, 1972 · N3808T · Substantial damage NTSB MKC73DCA09Accident · Minor injuriesClosedBell 47G-5 · Chesterfield, MODec 13, 1972 · N7042J · Destroyed NTSB MKC73FCA10Accident · No injuriesClosedCessna 172 · Fulton, MODec 7, 1972 · N3597S · Substantial damage NTSB MKC73FCA08Accident · No injuriesClosedPiper PA-28 · Berkeley, MONov 15, 1972 · N9365W · Substantial damage NTSB MKC73FCG17Accident · No injuriesClosedMooney M-20E · Versailles, MONov 8, 1972 · N3353X · Substantial damage NTSB MKC73DCG18Accident · No injuriesClosedCessna P206A · Springfield, MONov 4, 1972 · N2690X · Substantial damage NTSB MKC73AKO34Accident · 2 fatalClosedCessna A150K · Wentzville, MONov 4, 1972 · N8344M · Destroyed NTSB MKC73AK033Accident · No injuriesClosedCessna 172 · Chesterfield, MONov 4, 1972 · N20183 · 2 aircraft · Substantial damage NTSB MKC73FCA07Accident · No injuriesClosedCessna 150 · Ft.Leonard Wd, MONov 2, 1972 · N51264 · Destroyed NTSB MKC73AK031Accident · Serious injuriesClosedBoeing 707 · St.Louis, MONov 1, 1972 · N784TW · Minor damage NTSB MKC73DCA06Accident · No injuriesClosedCessna A188A · Fisk, MOOct 16, 1972 · N5636J · Substantial damage NTSB MKC73AK026Accident · 2 fatalClosedCessna 170B · Richmond, MOOct 16, 1972 · N4607C · Substantial damage NTSB MKC73DCG15Accident · No injuriesClosedCessna 150 · Lees Summit, MOSep 30, 1972 · N8050S · Substantial damage NTSB MKC73DCG13Accident · No injuriesClosedLuscombe 8A · Independence, MOSep 28, 1972 · N45608 · Substantial damage NTSB MKC73FCA05Accident · No injuriesClosedPiper PA-25 · Steele, MOSep 25, 1972 · N4548Y · Substantial damage NTSB MKC73FCG10Accident · No injuriesClosedCessna 180 · Gainsville, MOSep 18, 1972 · N7601A · Substantial damage NTSB MKC73DCG09Accident · No injuriesClosedPiper PA-28 · Nelson, MOSep 18, 1972 · N8819J · Substantial damage NTSB MKC73DCG06Accident · No injuriesClosedBell 47G-5 · Forsyth, MOSep 2, 1972 · N6203N · Substantial damage NTSB MKC73AK032Accident · 1 fatalClosedCessna 172L · Thayer, MOSep 1, 1972 · N2897Q · Destroyed NTSB MKC73DCA04Accident · No injuriesClosedCessna 150H · Creve Coeur, MOAug 28, 1972 · N50158 · Substantial damage NTSB MKC73AK018Accident · No injuriesClosedN.American 265-40 · Columbia, MOAug 28, 1972 · N23G · Substantial damage NTSB MKC73FCG11Accident · Minor injuriesClosedCessna 172 · Shell Knob, MOAug 21, 1972 · N5728R · Destroyed NTSB MKC73FCG04Accident · No injuriesClosedBell 47G · Sedalia, MOAug 19, 1972 · N2812B · Substantial damage NTSB MKC73DCG08Accident · No injuriesClosedCessna 172 · Independence, MOAug 14, 1972 · N567Q · Substantial damage NTSB MKC73FCG02Accident · Minor injuriesClosedBell 47J · Osage Beach, MOAug 5, 1972 · N2881B · Substantial damage NTSB MKC73AK010Accident · 1 fatalClosedCessna 150J · Gravois Mills, MOJul 22, 1972 · N60171 · Destroyed NTSB MKC73FCA03Accident · No injuriesClosedCessna 150H · Wentzville, MOJul 19, 1972 · N50395 · Substantial damage NTSB MKC73DCG01Accident · Minor injuriesClosedHagensicker B8 · Joplin, MOJul 15, 1972 · N3071 · Substantial damage NTSB MKC73AK008Accident · 2 fatalClosedBeech C23 · Osage Beach, MOJul 15, 1972 · N9733L · Destroyed NTSB MKC73AK007Accident · 1 fatalClosedCessna 177 · Branson, MOJul 15, 1972 · N3474T · Destroyed NTSB MKC73AK006Accident · 2 fatalClosedCessna 150 · Ravanna, MOJul 13, 1972 · N7737E · Destroyed NTSB MKC73FCA02Accident · Serious injuriesClosedPiper PA-25 · Kewanee, MOJul 10, 1972 · N6466Z · Destroyed NTSB MKC73AK002Accident · 1 fatalClosedWheat Repl CW-JR · Oregon, MOJul 4, 1972 · N4N · Substantial damage NTSB MKC73FCA01Accident · No injuriesClosedRyan ST-A · Williamsburg, MOJul 3, 1972 · N17364 · Substantial damage NTSB MKC72IK065Incident · No injuriesClosedBoeing 727 · St.Louis, MOJun 24, 1972 · N6837 · Minor damage NTSB MKC72DCG66Accident · No injuriesClosedCessna 172K · Cosby, MOJun 24, 1972 · N7101G · Substantial damage NTSB MKC72DCG67Accident · No injuriesClosedTaylorcraft DC-65 · Sedalia, MOJun 18, 1972 · N47587 · Destroyed NTSB MKC72DCA31Accident · No injuriesClosedCessna 150 · Scott City, MOJun 15, 1972 · N1282Q · Substantial damage NTSB MKC72DCG62Accident · No injuriesClosedCessna 182G · Camdenton, MOJun 13, 1972 · N3778U · Substantial damage NTSB MKC72FCA30Accident · Serious injuriesClosedBell 47D1 · Dorena, MOJun 10, 1972 · N3111G · Substantial damage NTSB MKC72FCA29Accident · Minor injuriesClosedPiper PA-24 · Tyrone, MOJun 10, 1972 · N5909P · Substantial damage NTSB MKC72FCG59Accident · No injuriesClosedMooney M20E · Columbia, MOJun 7, 1972 · N6023Q · Substantial damage NTSB MKC72DCG60Accident · Serious injuriesClosedGrant GB-1 · Lamonte, MOJun 4, 1972 · N30090 · Substantial damage NTSB MKC72DCG56Accident · No injuriesClosedCessna 182L · St Joseph, MOJun 4, 1972 · N42472 · Substantial damage