Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MIA73AM071Accident · 4 fatalClosedCessna 210D · Hollins, ALDec 31, 1972 · N3773Y · Destroyed NTSB MIA73AM068Accident · 1 fatalClosedMooney M20C · Ashland, ALDec 26, 1972 · N6386Q · Destroyed NTSB MIA73DKJ37Accident · No injuriesClosedPiper PA-28 · Russellville, ALDec 16, 1972 · N8370R · Substantial damage NTSB MIA73FKJ35Accident · No injuriesClosedSwift GC-1B · Birmingham, ALNov 29, 1972 · N2328B · Substantial damage NTSB MIA73AM015Accident · 1 fatalClosedPiper PA-28 · Detroit, ALNov 18, 1972 · N15431 · Substantial damage NTSB MIA73DKJ34Accident · No injuriesClosedChampian 7GCBC · Sanford, ALNov 16, 1972 · N11699 · Substantial damage NTSB MIA73AMO49Accident · 1 fatalClosedCessna 310Q · Montgomery, ALNov 10, 1972 · N7798Q · Destroyed NTSB MIA73DKJ33Accident · No injuriesClosedPiper PA-28 · Huntsville, ALNov 5, 1972 · N5640U · Substantial damage NTSB MIA73DKJ32Accident · No injuriesClosedCessna 150L · Ozark, ALOct 29, 1972 · N5228Q · Substantial damage NTSB MIA73DKJ31Accident · No injuriesClosedCessna 150J · Tuscaloosa, ALOct 29, 1972 · N60902 · Substantial damage NTSB MIA73FKJ30Accident · No injuriesClosedPiper PA-23 · Alabaster, ALOct 13, 1972 · N6980Y · Substantial damage NTSB MIA73DKJ29Accident · No injuriesClosedCessna 150 · Centre, ALOct 4, 1972 · N7941F · Substantial damage NTSB MIA73DKJ26Accident · No injuriesClosedAero Comdr 100 · Slocomb, ALOct 1, 1972 · N3650X · Substantial damage NTSB MIA73FKJ24Accident · No injuriesClosedPiper PA-18 · Tuscaloosa, ALSep 29, 1972 · N3949Z · Substantial damage NTSB MIA73DKJ25Accident · Minor injuriesClosedPiper PA-22 · Atmore, ALSep 27, 1972 · N1147C · Substantial damage NTSB MIA73DKJ27Accident · No injuriesClosedCessna 180 · Elberta, ALSep 23, 1972 · N9377T · Substantial damage NTSB MIA73FKJ28Accident · Serious injuriesClosedStampe SV4C · Selma, ALSep 22, 1972 · N65SV · Destroyed NTSB MIA73AM033Accident · 2 fatalClosedAero Comdr 100 · Tarrant City, ALSep 19, 1972 · N3757X · Destroyed NTSB MIA73FKJ21Accident · Serious injuriesClosedBellanca 17-31A · Alexander Cty, ALSep 15, 1972 · N8205R · Substantial damage NTSB MIA73FKJ22Accident · Serious injuriesClosedPiper PA-22 · Ashland, ALSep 13, 1972 · N2514P · Substantial damage NTSB MIA73FKJ20Accident · No injuriesClosedPiper PA-30 · Tallassee, ALSep 13, 1972 · N718JR · Substantial damage NTSB MIA73AM027Accident · 2 fatalClosedBeech B35 · Albertville, ALSep 10, 1972 · N29M · Destroyed NTSB MIA73FKJ19Accident · Minor injuriesClosedCessna 150F · Weaver, ALSep 5, 1972 · N7984F · Substantial damage NTSB MIA73FKJ17Accident · Minor injuriesClosedCallair A-9B · Samson, ALAug 29, 1972 · N7957V · Destroyed NTSB MIA73DKJ18Accident · No injuriesClosedBeech 58 · Birmingham, ALAug 29, 1972 · N26BW · Substantial damage NTSB MIA73DKJ16Accident · No injuriesClosedPiper PA-28 · Talladega, ALAug 26, 1972 · N9602W · Substantial damage NTSB MIA73FKJ15Accident · No injuriesClosedMitsubishi MU-2B · Montgomery, ALAug 25, 1972 · N3543X · Substantial damage NTSB MIA73DKJ14Accident · No injuriesClosedBeech 56TC · Russelville, ALAug 16, 1972 · N5479U · Substantial damage NTSB MIA73DKJ12Accident · No injuriesClosedCessna 182 · Bayou La Batr, ALAug 13, 1972 · N3290U · Substantial damage NTSB MIA73DKJ13Accident · Minor injuriesClosedPiper PA-25 · Elkmont, ALAug 12, 1972 · N6293Z · Substantial damage NTSB MIA73AM017Accident · No injuriesClosedHawker-Sdly DH-125 · Haleyville, ALAug 12, 1972 · N621ST · Substantial damage NTSB MIA73FKJ09Accident · Serious injuriesClosedLake LA-4 · Riverside, ALAug 6, 1972 · N6652L · Destroyed NTSB MIA73DKJ08Accident · No injuriesClosedCessna 210F · Montgomery, ALAug 4, 1972 · N6148R · Substantial damage NTSB MIA73FKJ07Accident · No injuriesClosedBellanca 17-30 · Huntsville, ALAug 3, 1972 · N7302V · Substantial damage NTSB MIA73FKJ06Accident · No injuriesClosedNavion B · Flomaton, ALJul 30, 1972 · N5366K · Substantial damage NTSB MIA73DKJ05Accident · No injuriesClosedCessna 172 · Irvington, ALJul 14, 1972 · N1444Y · Substantial damage NTSB MIA73DKJ04Accident · No injuriesClosedStearman A75 · Tuskegee, ALJul 13, 1972 · N55376 · Substantial damage NTSB OAK72DVD04Accident · No injuriesClosedCessna 140 · Livermore, ALJul 12, 1972 · N2046N · Substantial damage NTSB MIA73FKJ03Accident · Serious injuriesClosedCallair A-9B · Demopolis, ALJul 11, 1972 · N7793V · Destroyed NTSB MIA73DKJ02Accident · Serious injuriesClosedAero Comdr A-9B · Greensboro, ALJul 10, 1972 · N7770V · Substantial damage NTSB MIA73AM007Accident · 2 fatalClosedBeech B95 · Shelby Sprngs, ALJul 5, 1972 · N902T · Destroyed NTSB MIA73DKJ01Accident · No injuriesClosedCessna 188 · Prattville, ALJul 2, 1972 · N21717 · Substantial damage NTSB MIA73AM002Accident · 1 fatalClosedPiper PA-28R · Hillsboro, ALJul 1, 1972 · N3826T · Destroyed NTSB MIA72FKJ66Accident · No injuriesClosedBeech 23 · Birmingham, ALJun 29, 1972 · N14BW · Substantial damage NTSB MIA72DKJ65Accident · No injuriesClosedBeech A23 · Catherine, ALJun 28, 1972 · N3532R · Substantial damage NTSB MIA72DKJ64Accident · No injuriesClosedCessna 150F · Mobile, ALJun 25, 1972 · N8192F · Substantial damage NTSB MIA72DKJ61Accident · No injuriesClosedBeech B35 · Talladega, ALJun 13, 1972 · N5015C · Substantial damage NTSB MIA72FKJ59Accident · 1 fatalClosedPiper PA-18A · Robertsdale, ALJun 5, 1972 · N4391A · Destroyed NTSB MIA72DKJ62Accident · No injuriesClosedAeronca 7AC · Corner, ALJun 4, 1972 · N85188 · Substantial damage NTSB MIA72DKJ58Accident · No injuriesClosedLuscombe 8A · Pell City, ALJun 4, 1972 · N77837 · Substantial damage