Skip to content

NTSB investigations, 1976, IA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 MKC77FCD06Accident · Minor injuriesClosedAero-Star 600 · Pella, IADec 29, 1976 · N7468S · Substantial damage NTSB MKC77IA008Incident · No injuriesClosedPiper PA-28 · Muscatine, IADec 16, 1976 · N6474W · 2 aircraft · Minor damage NTSB MKC77DCD05Accident · No injuriesClosedCessna 150H · Solon, IADec 12, 1976 · N22938 · Substantial damage NTSB MKC77FA003Accident · Serious injuriesClosedBeech B99 · Spencer, IANov 19, 1976 · N8099R · Substantial damage NTSB MKC77DCD04Accident · No injuriesClosedPiper PA-28 · Atlantic, IANov 15, 1976 · N8701N · Substantial damage NTSB MKC77DCD03Accident · No injuriesClosedCessna 120 · Forest City, IANov 14, 1976 · N388R · Substantial damage NTSB MKC77DCD02Accident · No injuriesClosedCessna 210 · Modale, IANov 13, 1976 · N5851F · Substantial damage NTSB MKC77DCD01Accident · No injuriesClosedCessna 195B · Tripoli, IAOct 23, 1976 · N2173C · Substantial damage NTSB MKC76DCD67Accident · No injuriesClosedPiper PA-22 · Marion, IASep 17, 1976 · N87760 · Substantial damage NTSB MKC76FCD66Accident · Serious injuriesClosedAeronca 7AC · Prairieburg, IASep 5, 1976 · N81486 · Substantial damage NTSB MKC76DCD65Accident · Minor injuriesClosedTaylorcraft BC12-D · Springville, IAAug 27, 1976 · N95719 · Substantial damage NTSB MKC76FCD64Accident · No injuriesClosedBeech B24R · Lamoni, IAAug 24, 1976 · N48SS · Substantial damage NTSB MKC76FCD63Accident · Serious injuriesClosedPiper PA-25 · Rembranot, IAAug 10, 1976 · N8828L · Destroyed NTSB MKC76DCD62Accident · No injuriesClosedCessna 170B · Council Bluffs, IAAug 3, 1976 · N3253A · Substantial damage NTSB MKC76DCD61Accident · No injuriesClosedPiper PA-28 · Jefferson, IAAug 3, 1976 · N5746F · Substantial damage NTSB MKC76DCD59Accident · No injuriesClosedCessna 150 · Leighton, IAAug 1, 1976 · N19153 · Substantial damage NTSB MKC76FCD60Accident · No injuriesClosedBell 47G-2 · Oskaloosa, IAJul 29, 1976 · N12412 · Substantial damage NTSB MKC76FCD58Accident · No injuriesClosedHughes 269C · Clutier, IAJul 23, 1976 · N9580F · Substantial damage NTSB MKC76AK068Accident · 2 fatalClosedPiper PA-28 · Hiawatha, IAJul 22, 1976 · N6381J · Destroyed NTSB MKC76DCD57Accident · No injuriesClosedCessna 170B · Salix, IAJul 18, 1976 · N1856C · Substantial damage NTSB MKC76AK066Accident · 1 fatalClosedCessna 140 · Lake Mills, IAJul 10, 1976 · N89103 · Destroyed NTSB MKC76FCD55Accident · 1 fatalClosedAcroduster 1 · Council Bluffs, IAJul 4, 1976 · N91FF · Destroyed NTSB MKC76DCD52Accident · No injuriesClosedPiper PA-25 · Tipton, IAJul 1, 1976 · N7089Z · Substantial damage NTSB MKC76FCD53Accident · No injuriesClosedMooney M20G · Melvin, IAJun 28, 1976 · N6765N · Substantial damage NTSB MKC76FCD51Accident · Serious injuriesClosedPiper PA-28 · Cedar Falls, IAJun 27, 1976 · N41642 · Destroyed NTSB MKC76FCD50Accident · No injuriesClosedCessna T210 · Iowa Falls, IAJun 27, 1976 · N1675X · 2 aircraft · Substantial damage NTSB MKC76DCD54Accident · No injuriesClosedBell 47J-2A · Keokuk, IAJun 27, 1976 · N8523F · Substantial damage NTSB MKC76DCD56Accident · No injuriesClosedPiper PA-28 · Cherokee, IAJun 23, 1976 · N461CT · Substantial damage NTSB MKC76DCD49Accident · No injuriesClosedPiper PA-22 · Larchwood, IAJun 13, 1976 · N5933D · Substantial damage NTSB MKC76DCD48Accident · No injuriesClosedPiper PA-28 · Algona, IAJun 8, 1976 · N8066W · Substantial damage NTSB MKC76FCD47Accident · No injuriesClosedHiller Acft UH-12D · Dallas Center, IAJun 6, 1976 · N79SW · Destroyed NTSB MKC76FCD46Accident · No injuriesClosedPiper PA-28 · New Vienna, IAMay 30, 1976 · N5734F · Substantial damage NTSB MKC76DCD45Accident · No injuriesClosedCessna 175 · Oelwein, IAMay 30, 1976 · N6782E · Substantial damage NTSB MKC76DCD44Accident · No injuriesClosedCessna 150J · Muscatine, IAMay 27, 1976 · N51183 · Substantial damage NTSB MKC76FCD43Accident · Minor injuriesClosedCessna 150M · Perry, IAMay 20, 1976 · N7925U · Substantial damage NTSB MKC76DCD42Accident · No injuriesClosedCessna 188 · Cedar Falls, IAMay 18, 1976 · N9735G · Substantial damage NTSB MKC76FCD41Accident · Minor injuriesClosedRaven RX-6 · Carlisle, IAApr 29, 1976 · N8671L · Destroyed NTSB MKC76FCD40Accident · Minor injuriesClosedBrantley B-2B · Marshalltown, IAApr 27, 1976 · N5987X · Destroyed NTSB MKC76FCD39Accident · No injuriesClosedCessna 172C · Orchard, IAApr 18, 1976 · N8440X · Substantial damage NTSB MKC76FCD37Accident · 1 fatalClosedTecumseh Spec · Madrid, IAApr 11, 1976 · N200AM · Destroyed NTSB MKC76AK053Accident · 3 fatalClosedPiper PA-24 · Decorah, IAApr 10, 1976 · N8749P · Destroyed NTSB MKC76DCD38Accident · No injuriesClosedCessna 172 · Council Bluffs, IAApr 8, 1976 · N84412 · Substantial damage NTSB MKC76FCD36Accident · No injuriesClosedPiper PA-24 · Eagle Grove, IAApr 4, 1976 · N7935P · Substantial damage NTSB MKC76DCD35Accident · No injuriesClosedPiper PA-28 · Castalia, IAMar 28, 1976 · N4203J · Substantial damage NTSB MKC76DCD34Accident · No injuriesClosedPiper PA-22 · Hartley, IAMar 20, 1976 · N5728D · Substantial damage NTSB MKC76FCD33Accident · No injuriesClosedPitts S-1S · Harlan, IAMar 18, 1976 · N1115M · Substantial damage NTSB MKC76FCD31Accident · No injuriesClosedBell 47G-2 · Dows, IAMar 17, 1976 · N90529 · Destroyed NTSB MKC76DCD32Accident · No injuriesClosedBeech H35 · Des Moines, IAMar 17, 1976 · N356B · Substantial damage NTSB MKC76AK046Accident · 4 fatalClosedCessna 336 · Mcgregor, IAMar 11, 1976 · N1787Z · Destroyed NTSB MKC76FCD30Accident · No injuriesClosedBeech P35 · Mapleton, IAFeb 25, 1976 · N7117A · Substantial damage