Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MIA72FKJ37Accident · Minor injuriesClosedTaylorcraft DCO-65 · Mobile, ALDec 24, 1971 · N52423 · Substantial damage NTSB MIA72FKJ36Accident · 1 fatalClosedCessna 172F · Oneonta, ALDec 24, 1971 · N7856U · Destroyed NTSB MIA72DKJ35Accident · No injuriesClosedMooney M20C · Jasper, ALNov 28, 1971 · N9078V · Substantial damage NTSB MIA72DKJ34Accident · No injuriesClosedCessna 150G · Owens X-Rds, ALNov 25, 1971 · N3124J · Substantial damage NTSB MIA72DKJ32Accident · No injuriesClosedPiper PA-28 · Auburn, ALNov 23, 1971 · N5957W · Substantial damage NTSB MIA72AM047Accident · 1 fatalClosedCessna 182E · Heflin, ALNov 21, 1971 · N2946Y · Destroyed NTSB MIA72DKJ33Accident · No injuriesClosedPiper PA-32 · Montgomery, ALNov 16, 1971 · N8660N · Substantial damage NTSB MIA72FKJ31Accident · No injuriesClosedBeech 65-A80 · Birmingham, ALNov 13, 1971 · N277Q · Substantial damage NTSB MIA72DKJ30Accident · No injuriesClosedCessna 210 · Jasper, ALOct 28, 1971 · N7472E · Substantial damage NTSB MIA72DKJ29Accident · No injuriesClosedCessna 172G · Opelika, ALOct 22, 1971 · N3951L · Substantial damage NTSB MIA72DKJ28Accident · No injuriesClosedCessna 310 · Troy, ALOct 12, 1971 · N8988Z · Substantial damage NTSB MIA72DKJ26Accident · No injuriesClosedAero Comdr 680T · Mobile, ALOct 1, 1971 · N5051E · Substantial damage NTSB MIA72DKJ24Accident · No injuriesClosedCessna 150 · Arab, ALSep 25, 1971 · N6063G · Substantial damage NTSB MIA72FKJ25Accident · No injuriesClosedCessna 195 · Benton, ALSep 12, 1971 · N3895V · Substantial damage NTSB MIA72DKJ21Accident · No injuriesClosedPiper PA-25 · Ardmore, ALSep 8, 1971 · N7704Z · Substantial damage NTSB MIA72FKJ19Accident · Serious injuriesClosedBede BD-4 · Hazel Green, ALSep 5, 1971 · N4381F · Destroyed NTSB MIA72DKJ20Accident · No injuriesClosedCessna 188 · Slocomb, ALSep 4, 1971 · N5517S · Substantial damage NTSB MIA72AM021Accident · 2 fatalClosedPiper PA-22 · Morris, ALAug 29, 1971 · N8526D · Destroyed NTSB MIA72AM016Accident · 3 fatalClosedCessna 210A · Madison, ALAug 22, 1971 · N9432X · Destroyed NTSB MIA72IM013Incident · 1 fatalClosedCessna 150G · Foley, ALAug 17, 1971 · N3984J · No damage NTSB MIA72FKJ18Accident · No injuriesClosedGrumman G-164 · Southside, ALAug 16, 1971 · N960X · Substantial damage NTSB MIA72FKJ17Accident · No injuriesClosedPiper PA-28 · Attalla, ALAug 15, 1971 · N1692J · Substantial damage NTSB MIA72DKJ16Accident · No injuriesClosedPiper J-3 · Courtland, ALAug 13, 1971 · N3612N · Destroyed NTSB MIA72FKJ15Accident · No injuriesClosedCessna 150 · Gadsden, ALAug 11, 1971 · N22016 · Substantial damage NTSB MIA72DKJ14Accident · No injuriesClosedPiper PA-32 · Gadsden, ALAug 8, 1971 · N4726S · Substantial damage NTSB MIA72DKJ13Accident · No injuriesClosedPiper PA-25 · Muscle Shoals, ALAug 7, 1971 · N4414Y · Substantial damage NTSB MIA72FKJ22Accident · 1 fatalClosedAero Comdr A-9 · Aliceville, ALAug 5, 1971 · N8406V · Destroyed NTSB MIA72FKJ12Accident · No injuriesClosedAeronca 7DC · Clanton, ALAug 5, 1971 · N81741 · Substantial damage NTSB MIA72DKJ09Accident · No injuriesClosedPiper PA-28 · Montgomery, ALAug 2, 1971 · N9840W · Substantial damage NTSB MIA72FKJ11Accident · No injuriesClosedPiper PA-28 · Castleberry, ALJul 31, 1971 · N1754T · Substantial damage NTSB MIA72FKJ10Accident · No injuriesClosedPiper PA-22 · Meridianville, ALJul 31, 1971 · N5746Z · Destroyed NTSB MIA72DKJ08Accident · Minor injuriesClosedPiper PA-25 · Mooresville, ALJul 28, 1971 · N7432Z · Substantial damage NTSB MIA72KKJ07Accident · Minor injuriesClosedHiller FH1100 · Birmingham, ALJul 17, 1971 · N5058F · Substantial damage NTSB MIA72DKJ06Incident · No injuriesClosedM-Saulnier MS-760 · Huntsville, ALJul 16, 1971 · N760X · Minor damage NTSB MIA72DKJ04Accident · No injuriesClosedJeannies Teenie · Hazel Green, ALJul 12, 1971 · N11HN · Destroyed NTSB MIA72FKJ03Accident · Serious injuriesClosedPiper J3L-65 · Dothan, ALJul 10, 1971 · N27120 · Substantial damage NTSB MIA72FKJ02Accident · No injuriesClosedBoeing E75N1 · Echo, ALJul 9, 1971 · N66308 · Substantial damage NTSB MIA72DKJ05Accident · No injuriesClosedCessna 182 · Auburn, ALJul 9, 1971 · N9104G · Substantial damage NTSB MIA72FKJ01Accident · No injuriesClosedGrumman G-164 · Dothan, ALJul 1, 1971 · N748Y · Substantial damage NTSB MIA71FKJ64Accident · No injuriesClosedCessna 210 · Maxwell Afb, ALJun 24, 1971 · N9490T · Substantial damage NTSB MIA71AM115Accident · 2 fatalClosedBeech E18S · Birmingham, ALJun 22, 1971 · N5605D · Destroyed NTSB MIA71DKJ63Accident · No injuriesClosedCessna 172 · Crossville, ALJun 20, 1971 · N4637L · Substantial damage NTSB MIA71DKJ62Accident · No injuriesClosedCessna 150H · Montevallo, ALJun 20, 1971 · N7012S · Substantial damage NTSB MIA71DKJ61Accident · No injuriesClosedCessna 150 · Detroit, ALJun 12, 1971 · N23197 · Substantial damage NTSB MIA71DKJ60Accident · No injuriesClosedCessna 150 · Guin, ALJun 10, 1971 · N3914J · Substantial damage NTSB MIA71DKJ59Accident · No injuriesClosedCessna 150 · Muscle Shoals, ALJun 9, 1971 · N2968S · Substantial damage NTSB MIA71FKJ58Accident · No injuriesClosedBeech 95 · Anniston, ALJun 6, 1971 · N2033C · Substantial damage NTSB MIA71DKJ57Accident · No injuriesClosedCessna 310 · Tuscaloosa, ALJun 4, 1971 · N8172M · Substantial damage NTSB MIA71FKJ56Accident · No injuriesClosedCessna 177 · Jemison, ALJun 1, 1971 · N30133 · Substantial damage NTSB MIA71DLA48Accident · No injuriesClosedPiper PA-28 · Florala, ALMay 21, 1971 · N5540F · Substantial damage