Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MIA71DKJ36Accident · No injuriesClosedCessna 172 · Bryant, ALDec 25, 1970 · N35683 · Substantial damage NTSB MIA71DKJ35Accident · No injuriesClosedBeech 95-C55 · Anniston, ALDec 18, 1970 · N365T · Substantial damage NTSB MIA71FKJ34Accident · No injuriesClosedPiper PA-24 · Birmingham, ALDec 9, 1970 · N8736P · Substantial damage NTSB MIA71DKJ31Accident · No injuriesClosedPiper PA-30 · Monroeville, ALDec 5, 1970 · N7400Y · Substantial damage NTSB MIA71FKJ32Accident · No injuriesClosedPiper PA-24 · Wetumpka, ALDec 3, 1970 · N9329P · Substantial damage NTSB MIA71FKJ30Accident · No injuriesClosedCessna 150 · Birmingham, ALNov 27, 1970 · N7046F · Substantial damage NTSB MIA71DKJ33Accident · No injuriesClosedPiper PA-28 · Talladega, ALNov 24, 1970 · N9777W · Substantial damage NTSB MIA71DKJ28Accident · No injuriesClosedMaule M4-210 · Gadsden, ALNov 8, 1970 · N2041U · Substantial damage NTSB MIA71DKJ29Accident · No injuriesClosedCessna 180 · Tuscaloosa, ALNov 7, 1970 · N7640A · Substantial damage NTSB MIA71FKJ27Accident · No injuriesClosedPiper PA-24 · Birmingham, ALNov 4, 1970 · N8877P · Substantial damage NTSB MIA71DKJ26Accident · Minor injuriesClosedCessna 182H · Gulf Shores, ALOct 29, 1970 · N2306X · Substantial damage NTSB MIA71AM037Accident · 1 fatalClosedPiper PA-18S · Demopolis, ALOct 27, 1970 · N118T · Destroyed NTSB MIA71FKJ25Accident · No injuriesClosedCessna 182B · Elberta, ALOct 11, 1970 · N7238E · Substantial damage NTSB MIA71FKJ24Accident · No injuriesClosedPiper PA-18 · Loxley, ALOct 3, 1970 · N8229C · Substantial damage NTSB MIA71FKJ23Accident · No injuriesClosedBeech E18S · Anniston, ALOct 3, 1970 · N4012 · Substantial damage NTSB MIA71DKJ22Accident · No injuriesClosedCessna 172K · Monroeville, ALOct 3, 1970 · N84684 · Substantial damage NTSB MIA71DKJ21Accident · No injuriesClosedPiper J-3 · Hazel Green, ALOct 1, 1970 · N5555P · Substantial damage NTSB MIA71AKJ20Accident · Minor injuriesClosedPiper PA-28 · Jasper, ALSep 29, 1970 · N5763U · Destroyed NTSB MIA71DKJ19Accident · No injuriesClosedCessna 150F · Enterprise, ALSep 27, 1970 · N8650S · Substantial damage NTSB MIA71FKJ18Accident · No injuriesClosedPiper PA-28 · Birmingham, ALSep 20, 1970 · N1576J · Substantial damage NTSB MIA71FKJ17Accident · No injuriesClosedMooney M20C · Montgomery, ALSep 9, 1970 · N2948L · Substantial damage NTSB MIA71DKJ15Accident · No injuriesClosedCessna 170B · Athens, ALSep 6, 1970 · N2272D · Substantial damage NTSB MIA71FKJ16Accident · 1 fatalClosedPiper PA-25 · Heflin, ALAug 30, 1970 · N7102Z · Destroyed NTSB MIA71FKJ14Accident · Serious injuriesClosedBeech 23 · Clanton, ALAug 15, 1970 · N2371L · 2 aircraft · Substantial damage NTSB MIA71DKJ12Accident · Minor injuriesClosedPiper PA-18A · Canoe, ALAug 14, 1970 · N9467D · Destroyed NTSB MIA71DKJ13Accident · No injuriesClosedMooney M20C · Mobile, ALAug 12, 1970 · N9226V · Substantial damage NTSB MIA71FKD04Accident · No injuriesClosedPiper PA-28 · Birmingham, ALAug 11, 1970 · N1692J · Substantial damage NTSB MIA71AM013Accident · 2 fatalClosedBeech D17S · Sterrett, ALAug 8, 1970 · N787MD · Destroyed NTSB MIA71FKJ10Accident · No injuriesClosedBeech D55 · Birmingham, ALAug 5, 1970 · N7528N · Substantial damage NTSB MIA71DKJ08Accident · No injuriesClosedPiper PA-32 · Marion Junctn, ALAug 2, 1970 · N5598J · Substantial damage NTSB MIA71FKJ07Accident · No injuriesClosedPiper PA-22 · Moundville, ALAug 1, 1970 · N4691Z · Substantial damage NTSB MIA71DKJ06Accident · No injuriesClosedAeronca 11AC · Evergreen, ALJul 28, 1970 · N3404E · Substantial damage NTSB MIA71DKJ05Accident · No injuriesClosedPiper PA-28 · Dutton, ALJul 25, 1970 · N5708F · Substantial damage NTSB MIA71DKJ04Accident · Minor injuriesClosedPiper PA-25 · Atmore, ALJul 24, 1970 · N4821Y · Substantial damage NTSB MIA71DKJ11Accident · No injuriesClosedCessna 150 · Brundidge, ALJul 18, 1970 · N8196S · Substantial damage NTSB MIA71DKJ09Accident · Minor injuriesClosedKnight KT90F · Selma, ALJul 11, 1970 · N99G · Substantial damage NTSB MIA71DKJ01Accident · No injuriesClosedCessna 337 · Alexander Cty, ALJul 10, 1970 · N5442S · Substantial damage NTSB MIA71DKJ03Accident · Serious injuriesClosedPiper PA-18A · Atmore, ALJul 5, 1970 · N7589D · Destroyed NTSB MIA71DKJ02Accident · No injuriesClosedCessna 150 · Siluria, ALJul 4, 1970 · N50395 · Substantial damage NTSB MIA70DKJ46Accident · No injuriesClosedMooney M20E · Greenville, ALJun 29, 1970 · N7187U · Substantial damage NTSB MIA70DKJ49Accident · No injuriesClosedAero Comdr 520 · Mobile, ALJun 24, 1970 · N2136 · Substantial damage NTSB MIA70DKJ45Accident · No injuriesClosedCessna 150 · Laceys Sprngs, ALJun 22, 1970 · N6619S · Substantial damage NTSB MIA70DKJ44Accident · No injuriesClosedCessna 177 · Muscle Shoals, ALJun 20, 1970 · N30564 · Substantial damage NTSB MIA70DKJ43Accident · No injuriesClosedGrumman G-164 · Mcintosh, ALJun 19, 1970 · N10263 · Substantial damage NTSB MIA70FKJ42Accident · Serious injuriesClosedPiper PA-25 · Atmore, ALJun 15, 1970 · N4789Y · Destroyed NTSB MIA70FKJ41Accident · No injuriesClosedAero Comdr 500-B · Clanton, ALJun 15, 1970 · N4517E · Destroyed NTSB MIA70DKJ51Accident · No injuriesClosedPiper PA-30 · Pine Hill, ALJun 11, 1970 · N7084Y · Substantial damage NTSB MIA70DKJ40Accident · No injuriesClosedBeech V35A · Union Springs, ALJun 11, 1970 · N7124N · Substantial damage NTSB MIA70FKJ38Accident · No injuriesClosedPiper PA-18 · Muscle Shoals, ALJun 9, 1970 · N3960Z · Destroyed NTSB MIA70DKJ50Accident · No injuriesClosedLuscombe 8E · Saints Crsrds, ALJun 9, 1970 · N2045K · Substantial damage