Skip to content

NTSB investigations, 1979, AL

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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 MIA80FKJ15Accident · No injuriesClosedCessna 172I · Foley, ALDec 31, 1979 · N46053 · Substantial damage NTSB MIA80DKJ14Accident · No injuriesClosedCessna 152 · Huntsville, ALDec 21, 1979 · N67340 · Substantial damage NTSB MIA80FKJ16Accident · No injuriesClosedBeech 58 · Huntsville, ALDec 17, 1979 · N911FP · Substantial damage NTSB MIA80FA019Accident · 2 fatalClosedN American P-51D · Eufaula, ALDec 16, 1979 · N7711C · Destroyed NTSB MIA80FA014Accident · 4 fatalClosedPiper PA-32R · Anniston, ALNov 25, 1979 · N5RJ · Destroyed NTSB MIA80DKJ12Accident · No injuriesClosedCessna 182 · Grove Hill, ALNov 22, 1979 · N170AC · Substantial damage NTSB MIA80FKJ10Accident · Minor injuriesClosedPiper PA-38 · Stevenson, ALNov 16, 1979 · N2448C · Substantial damage NTSB MIA80DKJ13Accident · No injuriesClosedAeronca 11AC · Cottondale, ALNov 15, 1979 · N9180E · Substantial damage NTSB MIA80FKJ09Accident · Minor injuriesClosedPiper PA-28 · Gadsden, ALNov 3, 1979 · N8334R · Substantial damage NTSB MIA80FKJ08Accident · No injuriesClosedCessna 177RG · Eufaula, ALOct 30, 1979 · N50961 · Substantial damage NTSB MIA80FKJ07Accident · No injuriesClosedCessna 210 · Birmingham, ALOct 28, 1979 · N6638X · Substantial damage NTSB MIA80DKJ05Accident · Serious injuriesClosedCessna 172 · Alexander City, ALOct 14, 1979 · N609CW · Destroyed NTSB MIA80FKJ03Accident · No injuriesClosedGrumman G-164A · Vincent, ALOct 8, 1979 · N4593 · Substantial damage NTSB MIA80DKJ06Accident · Serious injuriesClosedHiller Acft 12E · Hurtsboro, ALOct 8, 1979 · N20MQ · Destroyed NTSB MIA80DKJ01Accident · Serious injuriesClosedPiper PA-25 · Samson, ALOct 1, 1979 · N7377Z · Destroyed NTSB MIA79FA120Accident · No injuriesClosedCessna 401 · Tuscaloosa, ALSep 7, 1979 · N8410F · Substantial damage NTSB MIA79FKJ65Accident · No injuriesClosedGrumman G-164 · Ashford, ALSep 1, 1979 · N617U · Substantial damage NTSB MIA79FKJ61Accident · Minor injuriesClosedHughes 269B · Mobile, ALAug 25, 1979 · N9534F · Destroyed NTSB MIA79FKJ62Accident · Minor injuriesClosedPiper PA-25 · Autaugaville, ALAug 21, 1979 · N82367 · Substantial damage NTSB MIA79ORJ60Accident · No injuriesClosedSchweizer SGU222 · Montevallo, ALAug 12, 1979 · N2411W · Substantial damage NTSB MIA79DKJ59Accident · No injuriesClosedHiller Acft UH-12E · Tuscaloosa, ALAug 10, 1979 · N702WA · Substantial damage NTSB MIA79DKJ57Accident · No injuriesClosedBell 47-D1 · Enterprise, ALJul 29, 1979 · N36015 · Substantial damage NTSB MIA79FKJ58Accident · Serious injuriesClosedHeadwind J.D. · Brewton, ALJul 26, 1979 · N101WG · Destroyed NTSB MIA79FA107Accident · 5 fatalClosedPiper PA-32 · Huntsville, ALJul 21, 1979 · N9181K · Destroyed NTSB MIA79FKJ53Accident · No injuriesClosedCessna 421B · Montgomery, ALJul 6, 1979 · N8079Q · Substantial damage NTSB MIA79FA099Accident · 1 fatalClosedBellanca 14-193 · Ozark, ALJul 4, 1979 · N7644E · Destroyed NTSB MIA79DKJ51Accident · No injuriesClosedAeronca 7AC · Pell City, ALJul 4, 1979 · N85663 · Substantial damage NTSB MIA79FKJ48Accident · No injuriesClosedCessna 310 · Birmingham, ALJul 3, 1979 · N4169Q · Substantial damage NTSB MIA79DKJ52Accident · No injuriesClosedHughes 269C · Hurtsboro, ALJul 3, 1979 · N222SW · Destroyed NTSB MIA79FKJ46Accident · No injuriesClosedPiper PA-25 · Opp, ALJun 28, 1979 · N4966Y · Substantial damage NTSB MIA79DKJ44Accident · Minor injuriesClosedCessna 180 · Pell City, ALJun 14, 1979 · N4802 · Destroyed NTSB MIA79DKJ43Accident · Serious injuriesClosedPiper PA-18 · Ozark, ALJun 13, 1979 · N46761 · Substantial damage NTSB MIA79FKJ42Accident · Serious injuriesClosedHiller UH-12E · Verbena, ALJun 8, 1979 · N87600 · Substantial damage NTSB MIA79FKJ47Accident · No injuriesClosedNavion A · Theodore, ALJun 6, 1979 · N4935K · Substantial damage NTSB MIA79FKJ40Accident · Minor injuriesClosedGrumman G-164A · Rehobeth, ALJun 1, 1979 · N7492 · Destroyed NTSB MIA79FA091Accident · 3 fatalClosedBeech C23 · Tuscaloosa, ALJun 1, 1979 · N1955L · Destroyed NTSB MIA79FKJ39Accident · Minor injuriesClosedCessna TU206C · Alexander City, ALMay 25, 1979 · N29093 · Substantial damage NTSB MIA79FA088Accident · 1 fatalClosedBeech G35 · Mobile, ALMay 23, 1979 · N46460 · Destroyed NTSB MIA79DKJ41Accident · No injuriesClosedBeech A36 · Harvest, ALMay 22, 1979 · N23621 · Substantial damage NTSB MIA79FKJ36Accident · No injuriesClosedBeech C-23 · Birmingham, ALMay 1, 1979 · N9186S · Substantial damage NTSB MIA79DKJ37Accident · No injuriesClosedCessna 150 · Jacksonville, ALMay 1, 1979 · N6045K · Substantial damage NTSB MIA79DKJ33Accident · No injuriesClosedPiper PA-28 · Eutaw, ALApr 13, 1979 · N32816 · Substantial damage NTSB MIA79FA068Accident · 1 fatalClosedBeech V35B · Grove Hill, ALApr 8, 1979 · N21KK · Destroyed NTSB MIA79DKJ30Accident · No injuriesClosedCessna 140 · Jacksonville, ALMar 31, 1979 · N9498A · Substantial damage NTSB MIA79FKJ27Accident · Serious injuriesClosedPiper PA-30 · Mobile, ALMar 22, 1979 · N8529Y · Destroyed NTSB MIA79DKJ49Accident · No injuriesClosedCessna 210 · Guntersville, ALMar 20, 1979 · N13CW · Substantial damage NTSB MIA79DKJ26Accident · Minor injuriesClosedGreat Lakes 2T-1A · Alabaster, ALMar 11, 1979 · N3586L · Substantial damage NTSB MIA79FKJ25Accident · No injuriesClosedGrumman G164A · Pleasant Hill, ALMar 5, 1979 · N7936 · Destroyed NTSB MIA79FKJ23Accident · No injuriesClosedCessna 310K · Clanton, ALJan 28, 1979 · N734SC · Substantial damage NTSB MIA79FKJ20Accident · No injuriesClosedBeech C-23 · Pinson, ALJan 5, 1979 · N9185S · Substantial damage