Skip to content

NTSB investigations, 1978, AL

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 MIA79FKJ18Accident · No injuriesClosedCessna 182 · Decatur, ALDec 29, 1978 · N1933X · Minor damage NTSB MIA79DKJ16Accident · Minor injuriesClosedCessna 172 · Huntsville, ALDec 21, 1978 · N7215Q · Substantial damage NTSB MIA79DKJ17Accident · No injuriesClosedBeech 23 · Montgomery, ALDec 18, 1978 · N2219L · Substantial damage NTSB MIA79FA023Accident · 1 fatalClosedSikorsky S55B · Hanceville, ALNov 29, 1978 · N8307 · Destroyed NTSB MIA79DKJ12Accident · No injuriesClosedAeronca 7AC · Opp, ALNov 16, 1978 · N83644 · Substantial damage NTSB MIA79DKJ11Accident · No injuriesClosedCessna 172 · Decatur, ALNov 12, 1978 · N79894 · Destroyed NTSB MIA79FA005Accident · 3 fatalClosedBeech 95 · Madison, ALOct 30, 1978 · N2753Y · Destroyed NTSB MIA79FA004Accident · 1 fatalClosedGreat Lakes 2T-1A2 · Guntersville, ALOct 29, 1978 · N3809 · Destroyed NTSB MIA79FKJ09Accident · 1 fatalClosedAmateur Mini · Bessemer, ALOct 28, 1978 · N152CM · Destroyed NTSB MIA79DKJ07Accident · Serious injuriesClosedCessna 152 · Alabaster, ALOct 21, 1978 · N67494 · Destroyed NTSB MIA79DKJ05Accident · No injuriesClosedCessna 152T · Dothan, ALOct 16, 1978 · N757TM · Substantial damage NTSB MIA79DKJ04Accident · No injuriesClosedPiper PA-38T · Birmingham, ALOct 15, 1978 · N2414E · Substantial damage NTSB MIA79DKJ03Accident · No injuriesClosedCessna 170B · Huntsville, ALOct 15, 1978 · N3101A · Substantial damage NTSB MIA79DKJ02Accident · No injuriesClosedAero Comdr S2R · Scottsboro, ALOct 6, 1978 · N8515V · Substantial damage NTSB MIA79DKJ01Accident · Minor injuriesClosedPiper PA-25 · Huntsville, ALOct 3, 1978 · N7520Z · Substantial damage NTSB MIA78FKJ95Accident · Minor injuriesClosedPiper PA-28R · Huntsville, ALSep 28, 1978 · N16369 · Substantial damage NTSB MIA78FKJ94Accident · Serious injuriesClosedEnstrom F-28 · Brookwood, ALSep 24, 1978 · N9253 · Destroyed NTSB MIA78DKJ93Accident · Minor injuriesClosedErco 415-C · Cragford, ALSep 24, 1978 · N3100H · Substantial damage NTSB MIA78DKJ91Accident · Minor injuriesClosedBellanca 7KCAB · Jasper, ALSep 17, 1978 · N333DJ · Substantial damage NTSB MIA78DKJ90Accident · No injuriesClosedZ-Bird LD-1 · Oneonta, ALSep 17, 1978 · N52RZ · Destroyed NTSB MIA78DKJ88Accident · No injuriesClosedBellanca 7ECA · Huntsville, ALSep 10, 1978 · N5524K · Substantial damage NTSB MIA78FKJ87Accident · No injuriesClosedBeech E55 · Montgomery, ALSep 5, 1978 · N3620A · Substantial damage NTSB MIA78DKJ85Accident · Serious injuriesClosedAero Comdr S2R · Montgomery, ALAug 28, 1978 · N5030X · Destroyed NTSB MIA78FKJ84Accident · No injuriesClosedPiper PA-25 · Evergreen, ALAug 26, 1978 · N7755Z · Substantial damage NTSB MIA78FKJ82Accident · No injuriesClosedGrumman G-164 · Ashford, ALAug 26, 1978 · N598Y · Substantial damage NTSB MIA78DKJ83Accident · No injuriesClosedCessna 150 · Pell City, ALAug 26, 1978 · N6581S · Substantial damage NTSB MIA78DKJ79Accident · Serious injuriesClosedVolksplane II · Jasper, ALAug 19, 1978 · N2257X · Substantial damage NTSB MIA78FKJ75Accident · No injuriesClosedCessna 172 · Orrville, ALAug 16, 1978 · N1479V · Substantial damage NTSB MIA78DKJ73Accident · No injuriesClosedCessna 150 · Vincent, ALAug 6, 1978 · N8390J · Substantial damage NTSB MIA78FKJ70Accident · Minor injuriesClosedGrumman G-164A · Prattville, ALAug 5, 1978 · N9930 · Destroyed NTSB MIA78FKJ72Accident · Minor injuriesClosedPiper PA-25 · Dothan, ALAug 1, 1978 · N4619Y · Substantial damage NTSB MIA78DKJ69Accident · No injuriesClosedCessna 172B · Hanover, ALAug 1, 1978 · N7615X · Substantial damage NTSB MIA78FKJ78Accident · Serious injuriesClosedBreezy I · Cullman, ALJul 29, 1978 · N45870 · Substantial damage NTSB MIA78FKJ67Accident · No injuriesClosedPiper PA-28 · Muscle Shoals, ALJul 27, 1978 · N3846T · Substantial damage NTSB MIA78FKJ66Accident · No injuriesClosedPiper PA-28 · Tuscaloosa, ALJul 26, 1978 · N5239W · Substantial damage NTSB MIA78FKJ63Accident · Serious injuriesClosedPiper PA-28R · Tuscaloosa, ALJul 20, 1978 · N331CS · Destroyed NTSB MIA78FKJ62Accident · No injuriesClosedPiper PA-25 · Shorter, ALJul 19, 1978 · N6965Z · Substantial damage NTSB MIA78DKJ61Accident · No injuriesClosedAeronca L3 · Ozark, ALJul 18, 1978 · N46748 · Substantial damage NTSB MIA78FKJ59Accident · No injuriesClosedCessna 206 · Elberta, ALJul 9, 1978 · N5277U · Substantial damage NTSB MIA78DKJ58Accident · No injuriesClosedCessna 150 · Talladega, ALJul 8, 1978 · N6916G · Substantial damage NTSB MIA78DKJ56Accident · No injuriesClosedBeech 23 · Montgomery, ALJul 7, 1978 · N2219L · Substantial damage NTSB MIA78FA101Accident · 2 fatalClosedPiper PA-28R · Courtland, ALJul 1, 1978 · N47975 · Destroyed NTSB MIA78FA100Accident · 1 fatalClosedBeechcraft 65-80 · Mobile, ALJun 27, 1978 · N975SQ · Destroyed NTSB MIA78FA099Accident · No injuriesClosedBeech E18S · Birmingham, ALJun 26, 1978 · N5644D · Substantial damage NTSB MIA78FKJ55Accident · Minor injuriesClosedCessna 182 · Elberta, ALJun 25, 1978 · N6306B · Substantial damage NTSB MIA78FKJ54Accident · No injuriesClosedMaule M-4 · Brewton, ALJun 24, 1978 · N4130C · Substantial damage NTSB MIA78FKJ53Accident · Serious injuriesClosedBeech 100 · Muscle Shoals, ALJun 22, 1978 · N941K · Substantial damage NTSB MIA78DKJ50Accident · Minor injuriesClosedCessna 172 · Huntsville, ALJun 12, 1978 · N6136E · Substantial damage NTSB MIA78FKJ49Accident · No injuriesClosedCessna 150 · Auburn, ALJun 11, 1978 · N7195F · Substantial damage NTSB MIA78FKJ48Accident · No injuriesClosedGrumman G-164 · Elmore, ALJun 8, 1978 · N4778T · Substantial damage