Skip to content

NTSB investigations, 1976, AL

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, AL per year, 1962–2026: 2,501 cases
1962	1
1963	1
1964	61
1965	92
1966	70
1967	85
1968	68
1969	75
1970	89
1971	73
1972	76
1973	82
1974	67
1975	71
1976	77
1977	82
1978	72
1979	50
1980	50
1981	48
1982	61
1983	60
1984	41
1985	45
1986	48
1987	45
1988	36
1989	33
1990	32
1991	30
1992	40
1993	33
1994	27
1995	42
1996	32
1997	17
1998	27
1999	29
2000	17
2001	25
2002	27
2003	30
2004	27
2005	22
2006	24
2007	29
2008	28
2009	13
2010	8
2011	17
2012	25
2013	10
2014	24
2015	23
2016	12
2017	19
2018	20
2019	15
2020	17
2021	15
2022	21
2023	19
2024	11
2025	18
2026	17

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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 MIA77FKJ10Accident · No injuriesClosedPiper PA-24 · Birmingham, ALDec 16, 1976 · N2172M · Substantial damage NTSB MIA77FKJ08Accident · No injuriesClosedMitsubishi MU-2B · Gadsden, ALDec 3, 1976 · N304L · Substantial damage NTSB MIA77DKJ06Accident · Minor injuriesClosedCessna 150 · Eufaula, ALNov 26, 1976 · N8363J · Substantial damage NTSB MIA77DA011Accident · No injuriesClosedPiper PA-24 · Birmington, ALNov 23, 1976 · N8902P · Substantial damage NTSB MIA77FKJ04Accident · No injuriesClosedPiper PA-34 · Selma, ALOct 29, 1976 · N4484T · Substantial damage NTSB MIA77FKJ03Accident · Serious injuriesClosedCessna 150 · New Brockton, ALOct 25, 1976 · N802AA · Substantial damage NTSB MIA77DKJ05Accident · No injuriesClosedBoeing 75 · Montgomery, ALOct 13, 1976 · N75869 · Substantial damage NTSB MIA77DKJ02Accident · No injuriesClosedAero Comdr 690A · Fayette, ALOct 13, 1976 · N123G · Substantial damage NTSB MIA77FKJ01Accident · 1 fatalClosedGrumman G-164 · Pansey, ALOct 2, 1976 · N23RA · Destroyed NTSB MIA76FKK04Accident · No injuriesClosedCessna 150 · Pell City, ALSep 21, 1976 · N5970G · Destroyed NTSB MIA76DKK03Accident · No injuriesClosedPiper PA-23 · Demopolis, ALSep 16, 1976 · N62569 · Substantial damage NTSB MIA76DKK02Accident · No injuriesClosedGrumman G-164A · Ashford, ALSep 9, 1976 · N9936 · Substantial damage NTSB MIA76DKK01Accident · No injuriesClosedCessna 188 · Huntsville, ALSep 6, 1976 · N5606J · Destroyed NTSB MIA76FKJ99Accident · Minor injuriesClosedHiller UH-12B · Midland City, ALSep 5, 1976 · N47091 · Destroyed NTSB MIA76AM107Accident · 3 fatalClosedCessna T210G · Brantley, ALSep 4, 1976 · N6826R · Destroyed NTSB MIA76FKJ97Accident · 1 fatalClosedAero-Comdr 600S2R · Ashland, ALAug 30, 1976 · N5652X · 2 aircraft · No damage NTSB MIA76DKJ98Accident · No injuriesClosedBiplane EAA · Talladega, ALAug 29, 1976 · N52RZ · Substantial damage NTSB MIA76FKJ96Accident · Minor injuriesClosedPiper J5A · Bessemer, ALAug 23, 1976 · N38027 · Substantial damage NTSB MIA76FKJ95Accident · No injuriesClosedPiper PA-18 · Birmingham, ALAug 21, 1976 · N222T · Substantial damage NTSB MIA76DKJ94Accident · No injuriesClosedBoeing A75N1 · Headland.Al, ALAug 20, 1976 · N3965B · Substantial damage NTSB MIA76FKJ92Accident · 1 fatalClosedPiper PA-25 · Flomaton, ALAug 14, 1976 · N9517P · Substantial damage NTSB MIA76FKJ93Accident · No injuriesClosedCessna 188 · Geneva, ALAug 11, 1976 · N9829V · Substantial damage NTSB MIA76FKJ90Accident · No injuriesClosedTed Smith 601 · Eufaula, ALAug 5, 1976 · N27HA · Substantial damage NTSB MIA76DKJ91Accident · No injuriesClosedCessna 210L · Mobile, ALAug 5, 1976 · N2226S · Substantial damage NTSB MIA76DKJ89Accident · No injuriesClosedPiper PA-28 · Talladega, ALJul 29, 1976 · N5738U · Substantial damage NTSB MIA76DKJ87Accident · No injuriesClosedAero Comdr A-9B · Ozark, ALJul 28, 1976 · N7952V · Substantial damage NTSB MIA76DKJ86Accident · No injuriesClosedBell 47D1 · Centre, ALJul 24, 1976 · N29WL · Destroyed NTSB MIA76DKJ85Accident · Minor injuriesClosedCessna 150M · Russellville, ALJul 24, 1976 · N63476 · Substantial damage NTSB MIA76DKJ84Accident · No injuriesClosedMooney M20 · Huntsville, ALJul 23, 1976 · N74759 · Substantial damage NTSB MIA76DKJ88Accident · No injuriesClosedCessna 150 · Hazel Green, ALJul 19, 1976 · N5297Q · Substantial damage NTSB MIA76DKJ83Accident · No injuriesClosedCessna 305A · Huntsville, ALJul 17, 1976 · N64836 · Substantial damage NTSB MIA76FKJ81Accident · No injuriesClosedPiper PA-23 · Mobile, ALJul 8, 1976 · N16442 · Substantial damage NTSB MIA76FKJ79Accident · No injuriesClosedCessna 188 · Enterprise, ALJul 6, 1976 · N5517S · Substantial damage NTSB MIA76DKJ80Accident · No injuriesClosedPiper PA-34 · Harvest, ALJul 4, 1976 · N9303K · Substantial damage NTSB MIA76DKJ78Accident · Serious injuriesClosedBoeing E-75 · Headland, ALJul 1, 1976 · N65949 · Substantial damage NTSB MIA76DKJ77Accident · Minor injuriesClosedBell 47G-4 · Natural Bridge, ALJun 28, 1976 · N1216W · Substantial damage NTSB MIA76DKJ76Accident · No injuriesClosedCessna 177A · Geneva, ALJun 21, 1976 · N30564 · Substantial damage NTSB MIA76FKJ73Accident · Serious injuriesClosedBell 204B · Ozark, ALJun 17, 1976 · N8513F · Substantial damage NTSB MIA76DKJ75Accident · No injuriesClosedChampion 7ECA · Goodway, ALJun 17, 1976 · N2543F · Substantial damage NTSB MIA76DKJ72Accident · No injuriesClosedRyan ST-3KR · Fairhope, ALJun 17, 1976 · N53430 · Substantial damage NTSB MIA76DKJ71Accident · No injuriesClosedHughes 269B · Laceys Spring, ALJun 16, 1976 · N9435F · Substantial damage NTSB MIA76FKJ74Accident · No injuriesClosedPiper PA-22 · Talladega, ALJun 13, 1976 · N8049D · Substantial damage NTSB MIA76FKJ70Accident · No injuriesClosedPiper PA-28 · Birmingham, ALJun 13, 1976 · N33396 · Substantial damage NTSB MIA76FKJ69Accident · No injuriesClosedPiper PA-25 · Dothan, ALJun 8, 1976 · N4619Y · Substantial damage NTSB MIA76DKJ68Accident · Minor injuriesClosedGrumman G-164 · Perdido Beach, ALJun 7, 1976 · N10245 · Destroyed NTSB MIA76DKJ67Accident · No injuriesClosedCessna 172A · Bessemer, ALJun 6, 1976 · N7432T · Substantial damage NTSB MIA76DKJ66Accident · No injuriesClosedCessna 150 · Russellville, ALJun 6, 1976 · N3060X · Substantial damage NTSB MIA76DKJ65Accident · No injuriesClosedPiper PA-28 · Montgomery, ALMay 29, 1976 · N4421T · Substantial damage NTSB MIA76DKJ64Accident · No injuriesClosedCessna 210 · Andalusia, ALMay 28, 1976 · N3775Y · Substantial damage NTSB MIA76DKJ63Accident · No injuriesClosedPiper PA-30 · Monroeville, ALMay 24, 1976 · N718JR · Substantial damage