Skip to content

NTSB investigations, 1969, IA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1969, IA per year, 1962–2026: 2,216 cases
1962	2
1963	2
1964	72
1965	74
1966	108
1967	129
1968	87
1969	98
1970	101
1971	105
1972	76
1973	53
1974	60
1975	49
1976	55
1977	57
1978	65
1979	51
1980	41
1981	60
1982	52
1983	53
1984	39
1985	35
1986	26
1987	30
1988	27
1989	24
1990	24
1991	23
1992	23
1993	22
1994	16
1995	12
1996	15
1997	22
1998	20
1999	18
2000	11
2001	7
2002	14
2003	20
2004	13
2005	13
2006	8
2007	17
2008	18
2009	17
2010	27
2011	23
2012	21
2013	15
2014	9
2015	13
2016	13
2017	16
2018	12
2019	9
2020	12
2021	16
2022	14
2023	17
2024	7
2025	13
2026	15

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") = 1969 AND c."eventStateOrRegion" = 'IA' 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\") = 1969
    AND c.\"eventStateOrRegion\" = 'IA' 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") = 1969
  AND c."eventStateOrRegion" = 'IA' 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 MKC70D0315Accident · No injuriesClosedCessna 310N · Monticello, IADec 31, 1969 · N4115Q · Substantial damage NTSB MKC70F0303Accident · No injuriesClosedCessna 140 · Newton, IADec 19, 1969 · N72363 · Substantial damage NTSB MKC70A0033Accident · 2 fatalClosedAlon A-2A · Clear Lake, IADec 15, 1969 · N5646F · Destroyed NTSB MKC70F0290Accident · No injuriesClosedCessna 150H · Winterset, IADec 13, 1969 · N6796S · Substantial damage NTSB MKC70D0302Accident · No injuriesClosedCessna 182G · Marshalltown, IADec 13, 1969 · N2467R · Substantial damage NTSB MKC70D0301Accident · No injuriesClosedCessna 310P · Pocahontas, IADec 9, 1969 · N5733M · Substantial damage NTSB MKC70DCD18Accident · No injuriesClosedPiper PA-18 · Clarinda, IADec 8, 1969 · N1387A · Substantial damage NTSB MKC70D0288Accident · No injuriesClosedCessna 170B · Holstein, IADec 1, 1969 · N2356D · Substantial damage NTSB MKC70D0280Accident · No injuriesClosedPiper PA-22 · Quasqueton, IANov 30, 1969 · N9431D · Substantial damage NTSB MKC70D0289Accident · No injuriesClosedPiper PA-28 · Creston, IANov 26, 1969 · N4139J · Substantial damage NTSB MKC70A0029Accident · 1 fatalClosedChampion 7ECA · Royal, IANov 25, 1969 · N9634S · Destroyed NTSB MKC70F0278Accident · Serious injuriesClosedAeronca 7AC · Harlan, IANov 23, 1969 · N84331 · Destroyed NTSB MKC70F0281Accident · Serious injuriesClosedCessna 120 · Riverton, IANov 15, 1969 · N1878N · Destroyed NTSB MKC70D0264Accident · No injuriesClosedPiper PA-28R · Muscatine, IANov 9, 1969 · N4696J · Substantial damage NTSB MKC70D0242Accident · No injuriesClosedCessna 150J · Waterloo, IAOct 26, 1969 · N50473 · Substantial damage NTSB MKC70D0234Accident · No injuriesClosedPiper PA-23 · Des Moines, IAOct 13, 1969 · N6385Y · Substantial damage NTSB MKC70F0230Accident · No injuriesClosedBeech V35 · Dows, IAOct 5, 1969 · N563DB · Substantial damage NTSB MKC70A0020Accident · Serious injuriesClosedCessna 402A · Decorah, IAOct 2, 1969 · N4554Q · No damage NTSB MKC70A0014Accident · 2 fatalClosedCessna 140 · Hartley, IAOct 1, 1969 · N1984V · Destroyed NTSB MKC70F0218Accident · No injuriesClosedPiper PA-22 · Cedar Falls, IASep 27, 1969 · N5970Z · Substantial damage NTSB MKC70D0236Accident · Minor injuriesClosedCessna 150 · Council Bluf, IASep 21, 1969 · N2846S · Substantial damage NTSB MKC70F0217Accident · No injuriesClosedPiper PA-32 · Carroll, IASep 19, 1969 · N5540J · Substantial damage NTSB MKC70D0215Accident · No injuriesClosedCessna 177 · Des Moines, IASep 17, 1969 · N3499T · Substantial damage NTSB MKC70F0216Accident · No injuriesClosedCessna 177 · Polk City, IASep 13, 1969 · N29490 · Substantial damage NTSB MKC70F018OAccident · Serious injuriesClosedBreezy 17A · Washington, IASep 10, 1969 · N1683 · Minor damage NTSB MKC70D0206Accident · No injuriesClosedPiper PA-18 · West Liberty, IASep 7, 1969 · N3838Z · Substantial damage NTSB MKC70D0199Accident · Minor injuriesClosedRose A M A-1 · Ottumwa, IASep 7, 1969 · N14843 · Substantial damage NTSB MKC70F0192Accident · 1 fatalClosedCallair A9 · Yale, IASep 3, 1969 · N7276V · Destroyed NTSB MKC70D0185Accident · No injuriesClosedCallair A-9 · Greattinger, IASep 1, 1969 · N7240V · Destroyed NTSB MKC70D0173Accident · Minor injuriesClosedCessna 150 · Council Blfs, IAAug 31, 1969 · N8547G · Substantial damage NTSB MKC70A0008Accident · 3 fatalClosedCessna 172H · Newton, IAAug 31, 1969 · N3149X · Destroyed NTSB MKC70F0153Accident · No injuriesClosedRose A-M A-1 · Ottumwa, IAAug 30, 1969 · N18252 · 2 aircraft · Substantial damage NTSB MKC70D0235Accident · No injuriesClosedPiper PA-28 · Guttenberg, IAAug 29, 1969 · N7235W · Substantial damage NTSB MKC70D0149Accident · No injuriesClosedFournier RF-4D · Pella, IAAug 28, 1969 · N7752 · Substantial damage NTSB MKC70F0191Accident · 1 fatalClosedPiper PA-18A · Gillett Grve, IAAug 26, 1969 · N9901D · Destroyed NTSB MKC70D0204Accident · No injuriesClosedBell 47G-5 · Irwin, IAAug 26, 1969 · N7801S · Substantial damage NTSB MKC70D0157Accident · No injuriesClosedCessna 177 · Marshallton, IAAug 25, 1969 · N2295Y · Substantial damage NTSB MKC70D0224Accident · No injuriesClosedCessna 172 · Missouri Val, IAAug 24, 1969 · N5806R · Substantial damage NTSB MKC70D0147Accident · No injuriesClosedBeech S35 · Spirit Lake, IAAug 23, 1969 · N171H · Substantial damage NTSB MKC70D0162Accident · No injuriesClosedBeech B35 · Clinton, IAAug 17, 1969 · N3399V · Substantial damage NTSB MKC70I0141Incident · No injuriesClosedBeech B95A · Oskaloosa, IAAug 12, 1969 · N9697Y · Minor damage NTSB MKC70D0144Accident · No injuriesClosedStinson 108-3 · Mcgregor, IAAug 12, 1969 · N6427M · Substantial damage NTSB MKC70D0142Accident · No injuriesClosedBeech 35-B33 · Grinnell, IAAug 11, 1969 · N9703Y · Substantial damage NTSB MKC70D0131Accident · No injuriesClosedPiper PA-24 · Laporte City, IAAug 8, 1969 · N7481P · Substantial damage NTSB MKC70D0105Accident · No injuriesClosedCessna 150 · Davenport, IAAug 6, 1969 · N8613S · Substantial damage NTSB MKC70D0123Accident · No injuriesClosedPiper PA-28 · Sac City, IAAug 5, 1969 · N5497W · Substantial damage NTSB MKC70D0143Accident · No injuriesClosedBoeing A75 · Hawarden, IAJul 29, 1969 · N54545 · Substantial damage NTSB MKC70D0139Accident · No injuriesClosedPiper PA-28 · Atlantic, IAJul 26, 1969 · N8243N · Substantial damage NTSB MKC70D0104Accident · No injuriesClosedPiper PA-28 · Epworth, IAJul 24, 1969 · N4839L · Substantial damage NTSB MKC70F0096Accident · Serious injuriesClosedPiper PA-23 · Newton, IAJul 22, 1969 · N5246Y · Destroyed