Skip to content

NTSB investigations, 1974, AL

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 MIA75AM038Accident · 1 fatalClosedPiper PA-24 · Mobile, ALDec 23, 1974 · N9168P · Destroyed NTSB MIA75FKJ36Accident · Serious injuriesClosedBeech K35 · Jasper, ALDec 15, 1974 · N3082C · Destroyed NTSB MIA75DKJ35Accident · No injuriesClosedPiper PA-24 · Fredonia, ALDec 1, 1974 · N5231P · Substantial damage NTSB MIA75AM030Accident · 2 fatalClosedBeech 100 · Birmingham, ALDec 1, 1974 · N50PC · Destroyed NTSB MIA75DKJ34Accident · No injuriesClosedPiper PA-18 · Gadsden, ALNov 29, 1974 · N6715C · Substantial damage NTSB MIA75DKJ33Accident · No injuriesClosedStinson 10A · Cullman, ALNov 28, 1974 · N27771 · Substantial damage NTSB MIA75DKJ39Accident · No injuriesClosedCessna 182 · Muscle Shoals, ALNov 27, 1974 · N71420 · Substantial damage NTSB MIA74DKJ31Accident · No injuriesClosedBeech B55 · Birmingham, ALNov 21, 1974 · N1229M · Substantial damage NTSB MIA75DKJ40Accident · Serious injuriesClosedChampion 7FC · Bessemer, ALNov 16, 1974 · N7950B · Destroyed NTSB MIA75DKJ32Accident · No injuriesClosedPiper PA-28 · Wetumpka, ALOct 30, 1974 · N4421T · 2 aircraft · Substantial damage NTSB MIA75DKJ30Accident · Serious injuriesClosedCessna 305A · Vincent, ALOct 28, 1974 · N5187G · Substantial damage NTSB MIA75AM024Accident · 4 fatalClosedCessna 172K · Haleyville, ALOct 27, 1974 · N7046G · Destroyed NTSB MIA75DKJ31Accident · No injuriesClosedAeronca 7AC · Ozark, ALOct 5, 1974 · N83983 · Substantial damage NTSB MIA75FKJ27Accident · No injuriesClosedPiper PA-32 · Tarrant City, ALSep 23, 1974 · N41481 · Substantial damage NTSB MIA75DKJ25Accident · Minor injuriesClosedAeronca 7AC · Luverne, ALSep 21, 1974 · N1875E · Destroyed NTSB MIA75DKJ24Accident · No injuriesClosedPitts S-2A · Gurley, ALSep 19, 1974 · N32Z · Substantial damage NTSB MIA75FKJ23Accident · No injuriesClosedPiper PA-31 · Birmingham, ALSep 17, 1974 · N7413L · Substantial damage NTSB MIA75KKJ22Accident · No injuriesClosedCallair A-4 · Bessemer, ALSep 14, 1974 · N6147C · Substantial damage NTSB MIA75DKJ21Incident · No injuriesClosedBeech B50 · Mobile, ALSep 14, 1974 · N9664R · Minor damage NTSB MIA75DKJ20Accident · Serious injuriesClosedCessna 188 · Mobile, ALSep 12, 1974 · N5685J · Destroyed NTSB MIA75DKJ19Accident · No injuriesClosedCessna 182 · Grand Bay, ALSep 10, 1974 · N5355B · Substantial damage NTSB MIA75DKJ18Accident · No injuriesClosedPiper PA-25 · Gantt, ALSep 10, 1974 · N6676Z · Substantial damage NTSB MIA75DKJ16Accident · No injuriesClosedPiper PA-24 · Montgomery, ALAug 24, 1974 · N7507P · Substantial damage NTSB MIA75DKJ15Accident · No injuriesClosedCessna 182A · Grove Hill, ALAug 23, 1974 · N4738D · Substantial damage NTSB MIA75DKJ14Accident · No injuriesClosedBeech A45 · Huntsville, ALAug 20, 1974 · N1115V · Substantial damage NTSB MIA75FKJ28Accident · 1 fatalClosedBellanca 8GCBC · Meridianville, ALAug 18, 1974 · N86912 · Destroyed NTSB MIA75FKJ13Accident · No injuriesClosedPiper PA-23 · Birmingham, ALAug 17, 1974 · N6380Y · Substantial damage NTSB MIA75DKJ12Accident · No injuriesClosedPiper PA-20 · Bay Minette, ALAug 15, 1974 · N7311K · Substantial damage NTSB MIA74DKJ09Accident · No injuriesClosedCessna A150L · Meridianville, ALAug 8, 1974 · N6073J · Substantial damage NTSB MIA75DKJ08Accident · No injuriesClosedPiper PA-28 · Sylacauga, ALAug 5, 1974 · N9517W · Substantial damage NTSB MIA75DKJ10Accident · No injuriesClosedPiper PA-32 · Grove Hill, ALAug 4, 1974 · N3916W · Substantial damage NTSB MIA75AM012Accident · 3 fatalClosedBeech M35 · Newton, ALAug 2, 1974 · N9760R · Destroyed NTSB MIA75DKJ07Accident · No injuriesClosedBoeing A75 · Marion, ALAug 1, 1974 · N53280 · Substantial damage NTSB MIA75DKJ06Accident · No injuriesClosedCessna 172K · Clanton, ALJul 26, 1974 · N84613 · Substantial damage NTSB MIA75FKJ05Accident · No injuriesClosedCessna 188 · Tuscaloosa, ALJul 21, 1974 · N7DS · Substantial damage NTSB MIA74DKJ04Accident · Serious injuriesClosedPiper J3C · Guntersville, ALJul 21, 1974 · N7473H · Substantial damage NTSB MIA75AM008Accident · 3 fatalClosedBeech F35 · Huntsville, ALJul 16, 1974 · N3860B · Destroyed NTSB MIA75FKJ03Accident · Minor injuriesClosedCessna 172K · Jasper, ALJul 12, 1974 · N46465 · Destroyed NTSB MIA75DLJ02Accident · Minor injuriesClosedPiper PA-18A · Athens, ALJul 8, 1974 · N4728A · Destroyed NTSB MIA74DKJ01Accident · No injuriesClosedAmer Avco AA5 · Centreville, ALJul 3, 1974 · N5840L · Substantial damage NTSB MIA74DKJ64Accident · Minor injuriesClosedBensen B8M · Fairhope, ALJun 30, 1974 · N62518 · Substantial damage NTSB MIA74DKJ63Accident · No injuriesClosedGrumman G-164 · Moundville, ALJun 16, 1974 · N9725 · Substantial damage NTSB MIA74DKJ62Accident · No injuriesClosedCessna 172 · Slocomb, ALJun 16, 1974 · N2485Y · Substantial damage NTSB MIA74DKJ61Accident · No injuriesClosedBell 47G-4 · Gaylesville, ALJun 14, 1974 · N1160W · Substantial damage NTSB MIA74DKJ60Accident · No injuriesClosedBeech E35 · Lacey Springs, ALJun 11, 1974 · N7300B · Substantial damage NTSB MIA74DKJ59Accident · Minor injuriesClosedCessna 170 · Clanton, ALMay 18, 1974 · N2697V · Substantial damage NTSB MIA74FKJ57Accident · 1 fatalClosedCessna 210E · Bay Minette, ALMay 13, 1974 · N4918U · Destroyed NTSB MIA74DKJ58Accident · Minor injuriesClosedMooney M20C · Auburn, ALMay 12, 1974 · N5575Q · Substantial damage NTSB MIA74FKJ55Accident · No injuriesClosedCessna 150 · Brewton, ALMay 7, 1974 · N5612G · Substantial damage NTSB MIA74DKJ54Accident · No injuriesClosedBellanca 17-31A · Huntsville, ALMay 7, 1974 · N6585V · Substantial damage