Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 MIA76FKJ40Accident · No injuriesClosedBeech 65-80 · Birmingham, ALDec 31, 1975 · N1110P · Substantial damage NTSB MIA76DKJ38Accident · No injuriesClosedPiper PA-28 · Anniston, ALDec 19, 1975 · N5085W · Substantial damage NTSB MIA76DKJ37Accident · No injuriesClosedPiper PA-24 · Huntsville, ALDec 19, 1975 · N8883P · Substantial damage NTSB MIA76FKJ36Accident · Minor injuriesClosedMooney M21 · Alabaster, ALDec 17, 1975 · N7177U · Destroyed NTSB MIA76FKJ34Accident · No injuriesClosedHughes 269B · Birmingham, ALDec 15, 1975 · N9444F · Substantial damage NTSB MIA76AM043Accident · 1 fatalClosedCessna 182P · Huntsville, ALNov 20, 1975 · N5729J · Destroyed NTSB MIA76FKJ33Accident · No injuriesClosedPiper PA-24 · Birmingham, ALNov 18, 1975 · N5304P · Substantial damage NTSB MIA76DKJ32Accident · No injuriesClosedSchweizer 1-26C · Montevallo, ALNov 8, 1975 · N5747S · Substantial damage NTSB MIA76AM039Accident · 2 fatalClosedCessna 180 · Eufaula, ALNov 2, 1975 · N9100C · Substantial damage NTSB MIA76DKJ30Accident · Minor injuriesClosedCessna 150 · Tuscaloosa, ALOct 21, 1975 · N4225U · Substantial damage NTSB MIA76DKJ29Accident · No injuriesClosedCessna 182P · Camden, ALOct 18, 1975 · N540GF · Substantial damage NTSB MIA76DKJ28Accident · No injuriesClosedGrumman G-164 · Sylacauga, ALOct 12, 1975 · N960X · Substantial damage NTSB MIA76DKJ27Accident · No injuriesClosedCessna 150H · Ashland, ALOct 12, 1975 · N22277 · Substantial damage NTSB MIA76DKJ26Accident · No injuriesClosedCessna A188B · Centre, ALOct 10, 1975 · N4490Q · Substantial damage NTSB MIA76DKJ25Accident · No injuriesClosedCessna 150 · Ozark, ALOct 9, 1975 · N6816G · Substantial damage NTSB MIA76DKJ24Accident · No injuriesClosedPiper PA-25 · Elkmont, ALOct 3, 1975 · N6296Z · Substantial damage NTSB MIA76FKJ22Accident · 1 fatalClosedBellanca 8GCBC · Wheeler, ALSep 29, 1975 · N86613 · Destroyed NTSB MIA76DKJ23Accident · No injuriesClosedPipep PA-22 · Laceys Springs, ALSep 28, 1975 · N6934D · Substantial damage NTSB MIA76DKJ21Accident · No injuriesClosedCessna 188 · Muscle Shoals, ALSep 19, 1975 · N5618G · Substantial damage NTSB MIA76FKJ19Accident · Minor injuriesClosedPiper PA-28 · Clanton, ALSep 1, 1975 · N16252 · Substantial damage NTSB MIA76FKJ20Accident · Serious injuriesClosedPiper PA-22 · Talladega, ALAug 30, 1975 · N3240B · Destroyed NTSB MIA76DKJ17Accident · No injuriesClosedPiper PA-28R · Selma, ALAug 26, 1975 · N1228T · Substantial damage NTSB MIA76DKJ15Accident · No injuriesClosedCessna 150 · Sardis, ALAug 26, 1975 · N11535 · Destroyed NTSB MIA76DKJ14Accident · Minor injuriesClosedTaylorcraft BF12-D · Hanceville, ALAug 23, 1975 · N34044 · Destroyed NTSB MIA76DKJ13Accident · No injuriesClosedCessna 170B · Tuscaloosa, ALAug 11, 1975 · N8396A · Substantial damage NTSB MIA76DKJ12Accident · Serious injuriesClosedCessna A188B · Muscle Shoals, ALAug 10, 1975 · N8220G · Substantial damage NTSB MIA76DKJ11Accident · No injuriesClosedPiper PA-28 · Camden, ALAug 10, 1975 · N32685 · Substantial damage NTSB IAD76AI007Accident · 2 fatalClosedBeech A35 · Mumford, ALAug 10, 1975 · N559B · Destroyed NTSB MIA76DKJ10Accident · No injuriesClosedPiper PA-25 · Elkmont, ALAug 2, 1975 · N5240Z · Substantial damage NTSB MIA76DKJ09Accident · No injuriesClosedCessna 150 · Jasper, ALAug 2, 1975 · N1523Q · Substantial damage NTSB MIA76FKJ18Accident · Minor injuriesClosedGrum Amer AA1-B · Demopolis, ALAug 1, 1975 · N1439R · Destroyed NTSB MIA76AM012Accident · 2 fatalClosedBeech J35 · Bay Minette, ALAug 1, 1975 · N2525X · Destroyed NTSB MIA76DKJ07Accident · Minor injuriesClosedBellanca 8GCBC · Courtland, ALJul 29, 1975 · N8590V · Substantial damage NTSB MIA76DKJ06Accident · No injuriesClosedTemco GC-1B · Millerville, ALJul 27, 1975 · N78328 · Substantial damage NTSB MIA76DKJ05Accident · Minor injuriesClosedCessna 182 · Elberta, ALJul 20, 1975 · N7123E · Substantial damage NTSB MIA76DKJ08Accident · No injuriesClosedCessna 182 · Bessemer, ALJul 11, 1975 · N3580F · Substantial damage NTSB MIA76DKJ03Accident · Minor injuriesClosedPiper PA-28 · Luverne, ALJul 11, 1975 · N7638W · Substantial damage NTSB MIA76DKJ01Accident · No injuriesClosedCessna 172H · Bessemer, ALJul 3, 1975 · N51059 · Substantial damage NTSB MIA75FKJ66Accident · No injuriesClosedCessna 421B · Mobile, ALJun 29, 1975 · N69289 · Substantial damage NTSB MIA75FKJ65Accident · Serious injuriesClosedCessna 150 · Meridianville, ALJun 28, 1975 · N45378 · Substantial damage NTSB MIA75DKJ63Accident · No injuriesClosedPiper PA-20 · Columbiana, ALJun 21, 1975 · N7059K · Substantial damage NTSB MIA76DKJ04Accident · No injuriesClosedCessna 172 · Elmore, ALJun 14, 1975 · N12527 · Substantial damage NTSB MIA75DKJ61Accident · Minor injuriesClosedBellanca 8GCBC · Town Creek, ALJun 9, 1975 · N8597V · Substantial damage NTSB MIA75FKJ60Accident · No injuriesClosedEnstrom F-28A · Dora, ALMay 16, 1975 · N158Q · Substantial damage NTSB MIA75AM078Accident · 2 fatalClosedBell 206B · Mount Pinson, ALMay 3, 1975 · N8130J · Destroyed NTSB MIA75AM077Accident · 2 fatalClosedCessna 206 · Union Springs, ALMay 1, 1975 · N1TL · Destroyed NTSB MIA75FKJ59Accident · Minor injuriesClosedPiper PA-36 · Dothan, ALApr 30, 1975 · N9916P · Destroyed NTSB MIA75DKJ58Accident · No injuriesClosedCessna 150 · Huntsville, ALApr 29, 1975 · N8752G · Substantial damage NTSB MIA75DKJ56Accident · No injuriesClosedCessna 150 · Huntsville, ALApr 16, 1975 · N18212 · Substantial damage NTSB MIA75FKJ55Accident · Minor injuriesClosedAeronca 7EC · Selma, ALApr 15, 1975 · N8544E · Destroyed