Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 MIA74AM051Accident · 2 fatalClosedMooney M20F · Huntsville, ALDec 30, 1973 · N9619M · Destroyed NTSB MIA74DKJ38Accident · No injuriesClosedBeech B95 · Birmingham, ALDec 21, 1973 · N2710Y · Substantial damage NTSB MIA74DKJ37Accident · No injuriesClosedCessna 182 · Hazel Green, ALDec 21, 1973 · N3186Y · Substantial damage NTSB MIA74DKJ36Accident · No injuriesClosedCessna 207 · Troy, ALDec 17, 1973 · N91061 · Substantial damage NTSB MIA74DKJ35Accident · Minor injuriesClosedPitts S-2A · Letohatchee, ALDec 16, 1973 · N80029 · Destroyed NTSB MIA74DKJ34Accident · No injuriesClosedTradewind C-45H · Jasper, ALDec 10, 1973 · N711FW · Substantial damage NTSB MIA74DKJ33Accident · No injuriesClosedCessna 182 · New Hope, ALNov 30, 1973 · N217CC · Substantial damage NTSB MIA74AM048Accident · 1 fatalClosedCessna 150H · Ashland, ALNov 24, 1973 · N22591 · Destroyed NTSB MIA74DKJ32Accident · Minor injuriesClosedCessna 206 · Huntsville, ALNov 22, 1973 · N4628F · Substantial damage NTSB MIA74AM046Accident · 1 fatalClosedAero Comdr 680-E · Birmingham, ALNov 22, 1973 · N277LP · Destroyed NTSB MIA74AM045Accident · 1 fatalClosedPiper PA-32 · Evergreen, ALNov 20, 1973 · N8665N · Destroyed NTSB MIA74DKJ30Accident · No injuriesClosedCessna 210 · Alabaster, ALNov 11, 1973 · N734SC · Substantial damage NTSB MIA74DKJ29Accident · No injuriesClosedAero Comdr 720 · Birmingham, ALOct 12, 1973 · N825WD · Substantial damage NTSB MIA74DKJ27Accident · No injuriesClosedPiper PA-28R · Tuscaloosa, ALOct 5, 1973 · N1434T · Substantial damage NTSB MIA74DKJ25Accident · No injuriesClosedPiper PA-23 · Robertsdale, ALSep 21, 1973 · N4510P · Substantial damage NTSB MIA74AM024Accident · 1 fatalClosedCessna 182P · Red Level, ALSep 15, 1973 · N9348G · Destroyed NTSB MIA74DKJ24Accident · No injuriesClosedPiper PA-22 · Daphne, ALSep 9, 1973 · N3425Z · Substantial damage NTSB MIA74DKJ22Accident · No injuriesClosedPiper PA-34 · Huntsville, ALSep 4, 1973 · N55697 · Substantial damage NTSB MIA74DKJ21Accident · No injuriesClosedWaco UPF-7 · Huntsville, ALAug 30, 1973 · N29982 · Substantial damage NTSB MIA74DKJ20Accident · No injuriesClosedAero Comdr A-9B · Hazel Green, ALAug 28, 1973 · N7726V · Substantial damage NTSB MIA74DKJ19Accident · No injuriesClosedAeronca 7AC · Vallermosa Sp, ALAug 25, 1973 · N85162 · Substantial damage NTSB MIA74DKJ18Accident · No injuriesClosedAeronca 7AC · Clanton, ALAug 25, 1973 · N83608 · Substantial damage NTSB MIA74DKJ17Accident · No injuriesClosedCessna 206 · Mobile, ALAug 22, 1973 · N71223 · Substantial damage NTSB MIA74DKJ16Accident · No injuriesClosedPiper PA-34 · Huntsville, ALAug 19, 1973 · N2890T · Substantial damage NTSB MIA74DKJ15Accident · No injuriesClosedCessna 170A · Gadsden, ALAug 19, 1973 · N1619D · Substantial damage NTSB MIA74DKJ74Accident · No injuriesClosedCessna 150 · Ider, ALAug 13, 1973 · N60318 · Substantial damage NTSB MIA74DKJ13Accident · No injuriesClosedPiper PA-28 · Huntsville, ALAug 11, 1973 · N712FL · Substantial damage NTSB MIA74FKJ11Accident · 1 fatalClosedPiper PA-25 · Trinity, ALAug 6, 1973 · N7432Z · Destroyed NTSB MIA74DKJ10Accident · No injuriesClosedPiper PA-28 · Wetumpka, ALAug 5, 1973 · N95357 · Substantial damage NTSB MIA74DKJ09Accident · No injuriesClosedCessna 150C · Arley, ALAug 3, 1973 · N6246T · Substantial damage NTSB MIA74DKJ08Accident · Minor injuriesClosedPiper PA-25 · Millers Ferry, ALAug 1, 1973 · N6499Z · Substantial damage NTSB MIA74DKJ07Accident · No injuriesClosedCessna 172 · Andalusa, ALJul 28, 1973 · N20234 · Substantial damage NTSB MIA74DKJ05Accident · No injuriesClosedPiper PA-23 · Huntsville, ALJul 27, 1973 · N5894Y · Substantial damage NTSB MIA73DKJ04Accident · No injuriesClosedBellanca 17-31A · Courtland, ALJul 25, 1973 · N6585V · Substantial damage NTSB MIA74AM003Accident · 1 fatalClosedCessna 150L · Wicksburg, ALJul 11, 1973 · N7007X · Destroyed NTSB MIA74DKJ02Accident · No injuriesClosedBeech D50E · Muscle Shoals, ALJul 8, 1973 · N460T · Substantial damage NTSB MIA74DKJ01Accident · No injuriesClosedBensen B8M · Montgomery, ALJul 1, 1973 · N3704 · Substantial damage NTSB MIA73DKJ74Accident · No injuriesClosedChampion 7GCA · Hazel Green, ALJun 29, 1973 · N9529S · Substantial damage NTSB MIA73DKJ72Accident · No injuriesClosedCessna 150H · Weaver, ALJun 29, 1973 · N22016 · Substantial damage NTSB MIA73FKJ71Accident · Serious injuriesClosedRyan ST-3KR · Wetumpka, ALJun 23, 1973 · N5246 · Substantial damage NTSB MIA73DKJ73Accident · No injuriesClosedCessna 411 · Tuscaloosa, ALJun 23, 1973 · N49BC · Substantial damage NTSB MIA73DKJ70Accident · Minor injuriesClosedCessna 188 · Florence, ALJun 21, 1973 · N8087V · Destroyed NTSB MIA73FKJ69Accident · No injuriesClosedBeech 95-B55 · Dothan, ALJun 18, 1973 · N7098N · Substantial damage NTSB MIA73DKJ68Accident · No injuriesClosedPiper PA-30 · Greenville, ALJun 9, 1973 · N8643Y · Substantial damage NTSB MIA73DKJ66Accident · No injuriesClosedBeech 95-55 · Mobile, ALJun 6, 1973 · N8933M · Substantial damage NTSB MIA73DKJ67Accident · No injuriesClosedPiper PA-12 · Brownsboro, ALJun 3, 1973 · N2849M · Substantial damage NTSB MIA73DKJ65Accident · No injuriesClosedCessna 172H · Birmingham, ALJun 3, 1973 · N3824R · Substantial damage NTSB MIA73AM105Accident · 1 fatalClosedCessna 140A · Burkville, ALJun 2, 1973 · N3798V · Destroyed NTSB MIA73DKJ63Accident · Minor injuriesClosedMooney M20E · Camden, ALMay 27, 1973 · N6922U · Substantial damage NTSB MIA73FKJ61Accident · Serious injuriesClosedCessna 188B · Talladega, ALMay 24, 1973 · N9985G · Destroyed