Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 MIA67F0398Accident · No injuriesClosedBeech 95-A55 · Bessemer, ALDec 26, 1966 · N1449G · Substantial damage NTSB MIA67D0463Accident · No injuriesClosedCessna 182 · Huntsville, ALDec 24, 1966 · N2600G · Substantial damage NTSB MIA67F0388Accident · No injuriesClosedAeronca 11AC · Centre, ALDec 17, 1966 · N85873 · Substantial damage NTSB MIA67F0389Accident · No injuriesClosedPiper PA-28 · Andalusia, ALDec 16, 1966 · N6112W · Substantial damage NTSB MIA67D0338Accident · No injuriesClosedCessna 150F · Decatur, ALNov 30, 1966 · N7797F · Substantial damage NTSB MIA67F0363Accident · No injuriesClosedPiper PA-24 · Auburn, ALNov 26, 1966 · N8371P · Substantial damage NTSB MIA67F0293Accident · No injuriesClosedBellanca 14-13- · Bessemer, ALNov 26, 1966 · N86761 · Substantial damage NTSB MIA67D0312Accident · No injuriesClosedPiper L-4 · Guntersville, ALNov 24, 1966 · N42933 · Substantial damage NTSB MIA67D0554Accident · No injuriesClosedCessna 337 · Hartselle, ALNov 12, 1966 · N6357F · Substantial damage NTSB MIA67F0302Accident · Serious injuriesClosedCessna 150F · Scottsboro, ALNov 6, 1966 · N8163F · Destroyed NTSB MIA67F0303Accident · No injuriesClosedPiper PA-23 · Birmingham, ALNov 5, 1966 · N5203Y · Substantial damage NTSB MIA67A0056Accident · 2 fatalClosedBeech D18S · Heflin, ALNov 2, 1966 · N411Z · Destroyed NTSB MIA67A0055Accident · 2 fatalClosedPiper PA-28 · Greenville, ALNov 1, 1966 · N7802W · Destroyed NTSB MIA67D0283Accident · No injuriesClosedCessna 150 · Eufaula, ALOct 30, 1966 · N8312G · Substantial damage NTSB MIA67D0315Accident · No injuriesClosedPiper PA-24 · Montgomery, ALOct 25, 1966 · N5051P · Substantial damage NTSB MIA67F0276Accident · No injuriesClosedCessna 150 · Mobile, ALOct 22, 1966 · N7752F · Substantial damage NTSB MIA67A0052Accident · Serious injuriesClosedAir-Space 18A · Birmingham, ALOct 22, 1966 · N6149S · Substantial damage NTSB MIA67D0282Accident · No injuriesClosedCessna 172 · Jasper, ALOct 19, 1966 · N5372R · Substantial damage NTSB MIA67D0269Accident · No injuriesClosedMooney M20C · Sylacauga, ALOct 19, 1966 · N6802U · Substantial damage NTSB MIA67D0314Accident · No injuriesClosedCessna 150 · Huntsville, ALOct 12, 1966 · N8728S · Substantial damage NTSB MIA67D0300Accident · No injuriesClosedAeronca 11AC · Weaver, ALOct 8, 1966 · N9618E · Substantial damage NTSB MIA67D0242Accident · Minor injuriesClosedPiper J-3 · Florence, ALSep 24, 1966 · N98069 · Substantial damage NTSB MIA67D0210Accident · No injuriesClosedN.American P-51 · Eutaw, ALSep 18, 1966 · N351D · Substantial damage NTSB MIA67F0161Accident · No injuriesClosedPiper J3C-65 · Fort Payne, ALSep 7, 1966 · N32612 · Substantial damage NTSB MIA67D0281Accident · No injuriesClosedCessna 172 · Hazel Green, ALSep 1, 1966 · N5748R · Substantial damage NTSB MIA67F0167Accident · Minor injuriesClosedPiper PA-28 · Auburn, ALAug 25, 1966 · N8118W · Substantial damage NTSB MIA67F0192Accident · No injuriesClosedAero Comdr 520 · Mobile, ALAug 19, 1966 · N4162B · Substantial damage NTSB MIA67A0026Accident · 1 fatalClosedPiper PA-18A · Eufaula Ala, ALAug 19, 1966 · N8675C · Destroyed NTSB MIA67D0191Accident · Minor injuriesClosedPiper PA-25 · Harpersville, ALAug 17, 1966 · N6433Z · Substantial damage NTSB MIA67D0153Accident · No injuriesClosedCessna 210 · Decatur, ALAug 11, 1966 · N4986U · Substantial damage NTSB MIA67F0094Accident · Minor injuriesClosedCessna 150 · Bessemer, ALAug 6, 1966 · N3987V · 2 aircraft · Substantial damage NTSB MIA67F0085Accident · Serious injuriesClosedPiper PA-28 · Cullman, ALAug 3, 1966 · N8030W · Substantial damage NTSB MIA67D0093Accident · No injuriesClosedCessna 172 · Birmingham, ALJul 28, 1966 · N3823L · Substantial damage NTSB MIA67F0060Accident · Serious injuriesClosedPiper PA-25 · Eufaula, ALJul 23, 1966 · N7486Z · Destroyed NTSB MIA67D0387Accident · Minor injuriesClosedCessna 150 · Phil Campbell, ALJul 23, 1966 · N6211T · Substantial damage NTSB MIA67A0011Accident · 2 fatalClosedPiper PA-30 · Gordo, ALJul 22, 1966 · N7602Y · Destroyed NTSB MIA67O0070Accident · No injuriesClosedCessna 170 · Evergreen, ALJul 15, 1966 · N5407C · Substantial damage NTSB MIA67D0141Accident · No injuriesClosedCessna 172 · Millers Ferry, ALJul 14, 1966 · N1460Y · Substantial damage NTSB MIA67D0127Accident · No injuriesClosedPiper PA-28 · Enterprise, ALJul 10, 1966 · N7042R · Substantial damage NTSB MIA67D0109Accident · No injuriesClosedLuscombe 8E · Gadsen, ALJul 10, 1966 · N2634K · Substantial damage NTSB MIA67D0106Accident · No injuriesClosedBeech 23 · Mobile, ALJul 10, 1966 · N2308Z · Substantial damage NTSB MIA67D0098Accident · No injuriesClosedCessna 195 · Weaver, ALJul 9, 1966 · N6394D · Substantial damage NTSB MIA66A0149Accident · 4 fatalClosedPiper PA-23 · Ashland, ALJun 27, 1966 · N5775Y · Destroyed NTSB MIA67D0068Accident · No injuriesClosedMaule M-4 · Decatur, ALJun 22, 1966 · N9814M · Substantial damage NTSB MIA67D0535Accident · No injuriesClosedCessna 172 · Brewton, ALJun 20, 1966 · N4021F · Substantial damage NTSB MIA67D0096Accident · No injuriesClosedCessna 337 · Mobile, ALJun 6, 1966 · N2283X · Substantial damage NTSB MIA66A0134Accident · 1 fatalClosedCessna 172F · Dothan, ALMay 16, 1966 · N5701R · Destroyed NTSB MIA66F0534Accident · No injuriesClosedPiper PA-18 · Selma, ALMay 13, 1966 · N9132D · Substantial damage NTSB MIA66A0129Accident · 2 fatalClosedPiper PA-18 · Atmore, ALMay 3, 1966 · N1119C · Destroyed NTSB MIA66D0538Accident · No injuriesClosedPiper PA-23 · Foley, ALApr 24, 1966 · N5208Y · Substantial damage