Skip to content

NTSB investigations, 1964, 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, 1964, 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") = 1964 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\") = 1964
    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") = 1964
  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 UNK65X1115Accident · Minor injuriesClosedMooney M20B · Goodwater, ALDec 24, 1964 · N74504 · Substantial damage NTSB UNK65X1098Accident · 1 fatalClosedCessna 175 · Leeds, ALDec 22, 1964 · N7086M · Substantial damage NTSB UNK65X0922Accident · No injuriesClosedPiper PA28 · Huntsville, ALDec 5, 1964 · N5581W · Substantial damage NTSB UNK65X0755Accident · No injuriesClosedPiper PA24 · Montgomery, ALNov 19, 1964 · N7812P · Substantial damage NTSB UNK65X0698Accident · No injuriesClosedCessna 150E · Tuscaloosa, ALNov 14, 1964 · N6197T · Substantial damage NTSB UNK65X0688Accident · No injuriesClosedCessna 120 · Russellville, ALNov 13, 1964 · N98538 · Substantial damage NTSB UNK65X0496Accident · No injuriesClosedCessna 172 · Theodore, ALOct 31, 1964 · N7426X · Substantial damage NTSB UNK65X0473Accident · No injuriesClosedBrewster FLEET1 · Mobile, ALOct 29, 1964 · N760V · Substantial damage NTSB UNK65X0429Accident · No injuriesClosedPiper PA28 · Fairhope, ALOct 25, 1964 · N6212W · Substantial damage NTSB UNK65X0339Accident · No injuriesClosedCessna 170B · Jasper, ALOct 19, 1964 · N3032A · Substantial damage NTSB UNK65X0326Accident · Minor injuriesClosedCurtis-Wght 12W · Gadsden, ALOct 18, 1964 · N418W · Destroyed NTSB UNK65X0290Accident · No injuriesClosedPiper PA28 · Bessemer, ALOct 16, 1964 · N6021W · Substantial damage NTSB UNK65X0272Accident · 2 fatalClosedCessna 175 · Cuba, ALOct 14, 1964 · N6691E · Destroyed NTSB UNK64X4217Accident · No injuriesClosedPiper PA-28 · Fairhope, ALSep 30, 1964 · N7683W · Substantial damage NTSB UNK64X4214Accident · No injuriesClosedAero Comm 560E · Montgomery, ALSep 30, 1964 · N6222B · Substantial damage NTSB UNK64X4160Accident · No injuriesClosedBeechcraft 23 · Muscle Shoals, ALSep 26, 1964 · N2329J · Substantial damage NTSB UNK64X4145Accident · No injuriesClosedBoeing A75N1 · Florence, ALSep 25, 1964 · N54560 · Substantial damage NTSB UNK64X4096Accident · Minor injuriesClosedPiper PA25 · New Lexington, ALSep 22, 1964 · N6493Z · Destroyed NTSB UNK64X3910Incident · No injuriesClosedConsolidatd PBY285 · Decatur, ALSep 11, 1964 · N19Q · Minor damage NTSB UNK64X3685Accident · No injuriesClosedPiper PA22 · Florence, ALAug 30, 1964 · N4602Z · Substantial damage NTSB UNK64X3639Accident · No injuriesClosedBeechcraft H50 · Mobile, ALAug 28, 1964 · N126WP · Substantial damage NTSB UNK64X3582Accident · No injuriesClosedPiper PA18A · Atmore, ALAug 25, 1964 · N1374C · Substantial damage NTSB UNK64X3542Accident · Minor injuriesClosedCallair A6 · Detroit, ALAug 22, 1964 · N2932G · Substantial damage NTSB UNK64X3504Accident · No injuriesClosedPiper PA25 · New Lexington, ALAug 21, 1964 · N6488Z · Destroyed NTSB UNK64X3481Accident · Minor injuriesClosedPiper J3 · Talladega, ALAug 19, 1964 · N98023 · Destroyed NTSB UNK64X3478Accident · No injuriesClosedCessna 310H · Birmingham, ALAug 19, 1964 · N1052Q · Substantial damage NTSB UNK64X3444Accident · No injuriesClosedPiper J3L-S · Dothan, ALAug 18, 1964 · N35301 · Substantial damage NTSB UNK64X3442Accident · Minor injuriesClosedPiper J3C · Headland, ALAug 17, 1964 · N92304 · Substantial damage NTSB UNK64X3431Accident · No injuriesClosedPiper PA25 · Trickham, ALAug 16, 1964 · N6657Z · Destroyed NTSB UNK64X2838Accident · No injuriesClosedCessna 205 · Anniston, ALJul 15, 1964 · N4834U · Substantial damage NTSB UNK64X2826Accident · No injuriesClosedPiper PA18A · Webb, ALJul 14, 1964 · N9473D · Substantial damage NTSB UNK64X2754Accident · Minor injuriesClosedCessna 150 · Butler, ALJul 10, 1964 · N7966Z · Substantial damage NTSB UNK64X2584Accident · Serious injuriesClosedBoeing E75 · Greensboro, ALJun 30, 1964 · N65690 · Destroyed NTSB UNK64X2521Accident · No injuriesClosedCessna 172 · Gadsen, ALJun 27, 1964 · N7300A · Substantial damage NTSB UNK64X2470Accident · No injuriesClosedCessna 195 · Guin, ALJun 24, 1964 · N6747C · Substantial damage NTSB UNK64X2108Accident · Minor injuriesClosedPiper PA28 · Bessemer, ALJun 4, 1964 · N5097W · Substantial damage NTSB UNK64X2070Accident · No injuriesClosedCessna 120 · Sylacauga, ALJun 2, 1964 · N76185 · Substantial damage NTSB UNK64X2035Accident · No injuriesClosedGlobe Swift Gcib · Mobile, ALMay 30, 1964 · N3719K · Substantial damage NTSB UNK64X1843Accident · No injuriesClosedCessna 182G · Fort Morgan, ALMay 19, 1964 · N2346R · Substantial damage NTSB UNK64X1833Accident · No injuriesClosedPiper PA24 · Birmingham, ALMay 18, 1964 · N6646P · Substantial damage NTSB UNK64X1662Accident · No injuriesClosedCessna 195 · Fort Rucker, ALMay 8, 1964 · N64900 · Substantial damage NTSB UNK64X1658Accident · Minor injuriesClosedStearman E75N1 · Henry County, ALMay 7, 1964 · N3724C · Destroyed NTSB UNK64X1505Accident · No injuriesClosedMooney MK21 · Huntsville, ALApr 29, 1964 · N6802U · Substantial damage NTSB UNK64X1405Accident · No injuriesClosedCessna 175 · Montgomery, ALApr 21, 1964 · N7220M · Substantial damage NTSB UNK64X1293Accident · Serious injuriesClosedCessna 182 · Alexander Cty, ALApr 12, 1964 · N2205G · Destroyed NTSB UNK64X1082Accident · Minor injuriesClosedPiper PA-18 · Enterprise, ALMar 28, 1964 · N10556 · Destroyed NTSB UNK64X0962Accident · Minor injuriesClosedErcoupe 415C · Red Bay, ALMar 17, 1964 · N3535H · Destroyed NTSB UNK64X0856Accident · Minor injuriesClosedCessna 182E · Mobile, ALMar 9, 1964 · N3511Y · Substantial damage NTSB UNK64X0853Accident · 1 fatalClosedPiper J-3C · Chunchula, ALMar 8, 1964 · N24879 · Destroyed NTSB UNK64X0844Accident · No injuriesClosedAeronca 7AC · Ozark, ALMar 8, 1964 · N3408E · Substantial damage