Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 MIA66F0395Accident · Minor injuriesClosedPiper PA-24 · Dothan, ALDec 26, 1965 · N5204P · Substantial damage NTSB MIA66F0390Accident · No injuriesClosedLuscombe 8A · Bay Minette, ALDec 26, 1965 · N71928 · Substantial damage NTSB MIA66A0072Accident · 1 fatalClosedMooney M-18C · Newbern, ALDec 25, 1965 · N4190 · Destroyed NTSB MIA66A0071Accident · No injuriesClosedPiper PA-23 · Huntsville, ALDec 21, 1965 · N5636Y · Substantial damage NTSB MIA66D0436Accident · No injuriesClosedBeechcraft C35 · Hazelgreen, ALDec 19, 1965 · N1882D · Substantial damage NTSB MIA66A0066Accident · 1 fatalClosedCessna 172B · Oneonta, ALDec 12, 1965 · N7543X · Destroyed NTSB MIA66D0391Accident · No injuriesClosedBeech E35 · Aliceville, ALDec 8, 1965 · N5810C · Substantial damage NTSB MIA66D0368Accident · No injuriesClosedPiper PA-28 · Muscle Shoals, ALDec 2, 1965 · N5542W · Substantial damage NTSB MIA66D0371Accident · No injuriesClosedCessna 210 · Owens Cross R, ALNov 30, 1965 · N9429T · Substantial damage NTSB MIA66D0427Accident · No injuriesClosedPiper PA-24 · Grove Hill, ALNov 27, 1965 · N6523P · Substantial damage NTSB MIA66F0364Accident · No injuriesClosedPiper PA-28 · Camden, ALNov 25, 1965 · N5423W · Substantial damage NTSB MIA66D0396Accident · No injuriesClosedPiper PA-23 · Haleyville, ALNov 22, 1965 · N4926F · Substantial damage NTSB MIA66F0370Accident · No injuriesClosedPiper PA-28 · Huntsville, ALNov 10, 1965 · N5866W · Substantial damage NTSB MIA66F0326Accident · Serious injuriesClosedUniv Acft D-16A · Gainestown, ALNov 8, 1965 · N703T · Destroyed NTSB MIA66F0288Accident · Minor injuriesClosedPiper PA-11 · Clanton, ALOct 31, 1965 · N4727H · Substantial damage NTSB MIA49A0049Accident · 2 fatalClosedTaylorcraft BF-12 · Horton, ALOct 30, 1965 · N33957 · Destroyed NTSB MIA66F0369Accident · No injuriesClosedCessna 150E · Theodore, ALOct 24, 1965 · N3082J · Substantial damage NTSB MIA66D0359Accident · No injuriesClosedCessna 172 · Aliceville, ALOct 17, 1965 · N8385B · Substantial damage NTSB MIA66A0044Accident · Minor injuriesClosedDouglas DC-6 · Huntsville, ALOct 17, 1965 · N37519 · Substantial damage NTSB MIA66F0298Accident · No injuriesClosedLockheed T-33 · Montgomery, ALOct 12, 1965 · AF80632 · 2 aircraft · Substantial damage NTSB MIA66F0363Accident · No injuriesClosedPiper PA-23 · Mobile, ALOct 8, 1965 · N3486P · Substantial damage NTSB MIA66F0310Accident · No injuriesClosedPiper PA-22 · Sterrett, ALOct 2, 1965 · N5744Z · Substantial damage NTSB MIA66A0038Accident · 1 fatalClosedCessba 140 · Trenton, ALOct 1, 1965 · N77409 · Destroyed NTSB MIA66D0273Accident · No injuriesClosedErcoupe 415-C · Sylacauga, ALSep 26, 1965 · N87272 · Substantial damage NTSB MIA66D0349Accident · No injuriesClosedBeechcraft H-50 · Montgomery, ALSep 24, 1965 · N126WP · Substantial damage NTSB MIA66F0274Accident · Serious injuriesClosedAeronca 11AC · Oneonta, ALSep 22, 1965 · N8605 · Substantial damage NTSB MIA66F0262Accident · Minor injuriesClosedPiper PA-22 · Jasper, ALSep 18, 1965 · N2943Z · Destroyed NTSB MIA66F0257Accident · Minor injuriesClosedCessna 150 · Birmingham, ALSep 16, 1965 · N8667S · Destroyed NTSB MIA66F0226Accident · No injuriesClosedPiper PA-18 · Centre, ALSep 14, 1965 · N140T · Destroyed NTSB MIA66F0205Accident · No injuriesClosedPiper PA-18A · Wing, ALSep 14, 1965 · N4703A · Substantial damage NTSB MIA66D0198Accident · No injuriesClosedCessna 150 · Birmingham, ALSep 13, 1965 · N3987U · Substantial damage NTSB MIA66F0232Accident · Serious injuriesClosedL.Kauffman LK10A · Harvest, ALSep 12, 1965 · N56300 · Substantial damage NTSB MIA66F0213Accident · Serious injuriesClosedCessna 120 · Holtville, ALSep 12, 1965 · N76185 · Substantial damage NTSB MIA66F0212Accident · No injuriesClosedPiper PA-25 · Florala, ALSep 12, 1965 · N6789Z · Substantial damage NTSB MIA66F0249Accident · No injuriesClosedPiper PA-18 · Jefferson, ALSep 2, 1965 · N3292Z · Substantial damage NTSB MIA66F0260Accident · No injuriesClosedPiper PA-30 · Mobile, ALSep 1, 1965 · N7025Y · Substantial damage NTSB MIA66F0250Accident · No injuriesClosedBoeing A-75N1 · Huntsville, ALAug 25, 1965 · N55134 · Substantial damage NTSB MIA66F0216Accident · No injuriesClosedPiper PA-23 · Mobile, ALAug 25, 1965 · N4300Y · Substantial damage NTSB MIA66F0196Accident · No injuriesClosedPiper PA-25 · Moundville, ALAug 23, 1965 · N7245Z · Substantial damage NTSB MIA66D0195Accident · No injuriesClosedPiper PA-28 · Huntsville, ALAug 17, 1965 · N6666W · Substantial damage NTSB MIA66F0175Accident · No injuriesClosedPiper PA-22 · Slocomb, ALAug 15, 1965 · N7059D · Destroyed NTSB MIA66A0020Accident · 1 fatalClosedTaylorcraft BC12-D · Selma, ALAug 14, 1965 · N96729 · Substantial damage NTSB MIA66F0225Accident · No injuriesClosedPiper PA-30 · Birmingham, ALAug 13, 1965 · N7602Y · Substantial damage NTSB MIA66F0193Accident · Minor injuriesClosedPiper J-3 · Elba, ALAug 9, 1965 · N35301 · Substantial damage NTSB MIA66D0191Accident · No injuriesClosedAeronca 7EC · Centreville, ALAug 7, 1965 · N7482B · Substantial damage NTSB MIA66F0118Accident · No injuriesClosedPiper PA-28 · Selma, ALAug 3, 1965 · N5880W · Substantial damage NTSB MIAL6F0115Accident · No injuriesClosedCessna 310 · Greensboro, ALJul 30, 1965 · N192R · Substantial damage NTSB MIA66F0176Accident · Minor injuriesClosedCallair A-9 · Sardis, ALJul 30, 1965 · N8265H · Destroyed NTSB MIA66A0017Accident · 1 fatalClosedPiper PA-18 · Gordon, ALJul 28, 1965 · N2208A · Destroyed NTSB MIA66F0177Accident · No injuriesClosedPiper PA-24 · Clanton, ALJul 26, 1965 · N6502P · Substantial damage