Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 MIA68D0424Accident · No injuriesClosedPiper PA-32 · Eufala, ALDec 25, 1967 · N3936W · Substantial damage NTSB MIA68F0351Accident · No injuriesClosedBeech 23 · Birmingham, ALDec 22, 1967 · N2374L · Substantial damage NTSB MIA68F0347Accident · Minor injuriesClosedCessna 210 · Bay Minette, ALDec 19, 1967 · N4803U · Substantial damage NTSB MIA68D0369Accident · No injuriesClosedCessna 150 · Pell City, ALDec 16, 1967 · N3316J · Substantial damage NTSB MIA68F0307Accident · No injuriesClosedAero Comdr 680 · Decatur, ALDec 12, 1967 · N8302 · Substantial damage NTSB MIA68D0366Accident · No injuriesClosedCessna 182 · Dothan, ALDec 9, 1967 · N3514F · Substantial damage NTSB MIA68D0328Accident · No injuriesClosedPiper PA-30 · Dothan, ALNov 25, 1967 · N7026Y · Substantial damage NTSB MIA68D0345Accident · No injuriesClosedBeech 35-33 · Mobile, ALNov 24, 1967 · N13232 · Substantial damage NTSB MIA68A0049Accident · 1 fatalClosedPiper PA-30 · Oxford, ALNov 21, 1967 · N8124Y · Destroyed NTSB MIA68D0365Accident · No injuriesClosedCessna 150G · Enterprise, ALNov 19, 1967 · N6345S · Substantial damage NTSB MIA68A0048Accident · Minor injuriesClosedAeronca 11AC · Athens, ALNov 18, 1967 · N3719E · Substantial damage NTSB MIA68D0287Accident · No injuriesClosedCessna 150 · Laceys Spring, ALNov 17, 1967 · N8745S · Substantial damage NTSB MIA68A0046Accident · 3 fatalClosedBeech C35 · Birmingham, ALNov 16, 1967 · N8985A · Destroyed NTSB MIA68F0360Accident · Serious injuriesClosedBoeing E75 · Mobile, ALNov 14, 1967 · N4890N · Substantial damage NTSB MIA68F0339Accident · Minor injuriesClosedPiper PA-24 · Muscle Shoals, ALNov 14, 1967 · N5203P · Substantial damage NTSB MIA68F0267Accident · Serious injuriesClosedPiper PA-24 · Birmingham, ALNov 3, 1967 · N7034P · Substantial damage NTSB MIA68F0283Accident · No injuriesClosedLear Jet 23 · Huntsville, ALOct 31, 1967 · N825LJ · Substantial damage NTSB MIA68F0281Accident · No injuriesClosedPiper PA-23 · Muscle Shoals, ALOct 29, 1967 · N4776P · Substantial damage NTSB MIA68A0041Accident · 1 fatalClosedCessna 150 · Lacy Springs, ALOct 28, 1967 · N7797F · Destroyed NTSB MIA68F0225Accident · No injuriesClosedPiper PA-24 · Alabaster, ALOct 4, 1967 · N5949P · Substantial damage NTSB MIA68D0193Accident · No injuriesClosedTaylorcraft BC12 · Millry, ALSep 17, 1967 · N34238 · Substantial damage NTSB MIA68F0216Accident · Serious injuriesClosedCessna 150 · Hazel Green, ALSep 13, 1967 · N2206J · Substantial damage NTSB MIA68D0170Accident · Minor injuriesClosedPiper PA-25 · Foley, ALSep 7, 1967 · N7632Z · Destroyed NTSB MIA68F0155Accident · No injuriesClosedMooney M20E · Loachapoka, ALAug 24, 1967 · N5520Q · Substantial damage NTSB MIA68D0149Accident · Minor injuriesClosedPiper PA-25 · Childersburg, ALAug 23, 1967 · N7251Z · Destroyed NTSB MIA68F0146Accident · No injuriesClosedPiper PA-18 · Atmore, ALAug 19, 1967 · N7589D · Substantial damage NTSB MIA68F0140Accident · No injuriesClosedPiper PA-28 · New Hope, ALAug 19, 1967 · N9882W · Substantial damage NTSB MIA68F0127Accident · Serious injuriesClosedPiper PA-18 · Section, ALAug 18, 1967 · N7073D · Substantial damage NTSB MIA68F0088Accident · No injuriesClosedPiper PA-25 · Centerville, ALAug 15, 1967 · N6480Z · Substantial damage NTSB MIA68A0020Accident · 1 fatalClosedPiper PA-25 · Millbrook, ALAug 11, 1967 · N7209Z · Destroyed NTSB MIA68A0018Accident · 1 fatalClosedPiper J3C-65 · Headland, ALAug 9, 1967 · N3419N · Destroyed NTSB MIA68D0095Accident · No injuriesClosedPiper PA-25 · Centre, ALAug 7, 1967 · N7102Z · Substantial damage NTSB MIA68D0143Accident · No injuriesClosedCessna 172 · Fyffe, ALAug 6, 1967 · N7586T · Substantial damage NTSB MIA68A0015Accident · No injuriesClosedLockheed L-18 · Northport, ALAug 1, 1967 · N637E · Substantial damage NTSB MIA68D0109Accident · No injuriesClosedCessna 182 · Birmingham, ALJul 30, 1967 · N2395R · Substantial damage NTSB MIA68F0066Accident · Minor injuriesClosedPiper PA-25 · Elmore, ALJul 26, 1967 · N7706Z · Substantial damage NTSB MIA68D0092Accident · No injuriesClosedPiper PA-18A · Brent, ALJul 21, 1967 · N6185D · Substantial damage NTSB MIA68F0044Accident · No injuriesClosedErco 415-C · Bessemer, ALJul 10, 1967 · N94144 · Substantial damage NTSB MIA68F0035Accident · No injuriesClosedPiper PA-24 · Mobile, ALJul 8, 1967 · N7749P · Substantial damage NTSB MIA68D0045Accident · No injuriesClosedBoeing A75N1 · Tallassee, ALJul 4, 1967 · N5521N · Substantial damage NTSB MIA68F0093Accident · No injuriesClosedBeech B35 · Bessemer, ALJul 1, 1967 · N8721A · Substantial damage NTSB MIA68F0086Accident · Minor injuriesClosedGlobe GC-1B · Birmingham, ALJul 1, 1967 · N3815K · Substantial damage NTSB MIA68D0054Accident · Serious injuriesClosedPiper J-3 · Dothan, ALJul 1, 1967 · N42999 · Destroyed NTSB MIA68D0121Accident · No injuriesClosedBeech 35 · Monroeville, ALJun 29, 1967 · N8505A · Substantial damage NTSB MIA68D0168Accident · No injuriesClosedCessna 180 · Montgomery, ALJun 25, 1967 · N2953A · Destroyed NTSB MIA68D0107Accident · No injuriesClosedPiper PA-28 · Fairhope, ALJun 25, 1967 · N9458J · Substantial damage NTSB MIA68D0018Accident · No injuriesClosedAero Comdr 500-B · Huntsville, ALJun 23, 1967 · N6194X · Substantial damage NTSB MIA68D0049Accident · No injuriesClosedCessna 150 · Linden, ALJun 15, 1967 · N4608X · Substantial damage NTSB MIA67F0580Accident · No injuriesClosedCessna 150 · Ozark, ALJun 15, 1967 · N4642X · Substantial damage NTSB MIA68D0137Accident · No injuriesClosedCessna 310C · Gadsden, ALJun 12, 1967 · N1737H · Substantial damage