Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MIA69D0335Accident · No injuriesClosedCessna 177 · Lacey Sprgs, ALDec 20, 1968 · N2385Y · Substantial damage NTSB MIA69F0316Accident · Serious injuriesClosedCessna 172 · Heflin, ALDec 19, 1968 · N46271 · Substantial damage NTSB MIA69F0333Accident · No injuriesClosedPiper PA-22 · Goshen, ALDec 7, 1968 · N2376P · Substantial damage NTSB MIA69D0243Accident · No injuriesClosedCessna 120 · Geneva, ALNov 24, 1968 · N90177 · Substantial damage NTSB MIA69I0259Incident · No injuriesClosedPiper J-3 · Ozark, ALNov 23, 1968 · N98576 · No damage NTSB MIA69D0247Accident · No injuriesClosedCessna 182L · Weaver, ALNov 20, 1968 · N3447R · Substantial damage NTSB MIA69D0248Accident · No injuriesClosedPiper PA-32 · Gadsden, ALNov 4, 1968 · N3441W · Substantial damage NTSB MIA69F0205Accident · No injuriesClosedMooney M20 · Andalusia, ALOct 21, 1968 · N9540M · Substantial damage NTSB MIA69F0197Accident · Serious injuriesClosedPiper J3C-65 · Headland, ALOct 20, 1968 · N92043 · Substantial damage NTSB MIA69F0204Accident · No injuriesClosedCessna 210 · Montgomery, ALSep 28, 1968 · N9666T · Substantial damage NTSB MIA69F0193Accident · No injuriesClosedCessna 172 · Clopton, ALSep 27, 1968 · N8822B · Substantial damage NTSB MIA69F0188Accident · No injuriesClosedBeech 35-C33 · Birmingham, ALSep 26, 1968 · N5808K · Substantial damage NTSB MIA69D0179Accident · No injuriesClosedCessna 150H · Elmore, ALSep 26, 1968 · N7088S · Substantial damage NTSB MIA69F0200Accident · No injuriesClosedMooney M20C · Decatur, ALSep 23, 1968 · N6620U · Substantial damage NTSB MIA69A0016Accident · 2 fatalClosedPiper PA-28 · Eufaula, ALSep 22, 1968 · N6544W · Destroyed NTSB MIA69F0165Accident · No injuriesClosedCessna 150 · Pell City, ALSep 9, 1968 · N22614 · Substantial damage NTSB MIA69D0199Accident · No injuriesClosedMooney M20A · Headland, ALSep 8, 1968 · N82EA · Substantial damage NTSB MIA69D0163Accident · No injuriesClosedCessna 150 · Skipperville, ALSep 7, 1968 · N8207S · Substantial damage NTSB MIA69F0174Accident · Serious injuriesClosedPiper PA-23 · Montgomery, ALAug 28, 1968 · N3376P · Destroyed NTSB MIA69D0130Accident · No injuriesClosedCessna 150G · Montgomery, ALAug 24, 1968 · N2760S · Substantial damage NTSB MIA69F0137Accident · Minor injuriesClosedPiper PA-25 · River Falls, ALAug 23, 1968 · N4697Y · Substantial damage NTSB MIA69D0151Accident · Minor injuriesClosedPiper PA-18 · Decatur, ALAug 22, 1968 · N7868D · Substantial damage NTSB MIA69D0129Accident · No injuriesClosedBoeing A75 · Monroeville, ALAug 21, 1968 · N55175 · Substantial damage NTSB MIA69D0128Accident · No injuriesClosedPiper PA-18 · Cottonwood, ALAug 19, 1968 · N9490D · Substantial damage NTSB MIA69F0098Accident · No injuriesClosedPiper PA-24 · Huntsville, ALAug 4, 1968 · N8906P · Substantial damage NTSB MIA69F0053Accident · No injuriesClosedPiper PA-25 · Harpersville, ALAug 3, 1968 · N6465Z · Substantial damage NTSB MIA69D0082Accident · No injuriesClosedCessna 182L · Muscle Shoals, ALJul 31, 1968 · N3456R · Substantial damage NTSB MIA69F0099Accident · Minor injuriesClosedPiper PA-25 · Eufala, ALJul 27, 1968 · N4908Y · Destroyed NTSB MIA69D0075Accident · No injuriesClosedCessna 180 · Alexander Cty, ALJul 19, 1968 · N4971A · 2 aircraft · Minor damage NTSB MIA69D0158Accident · No injuriesClosedCessna 150 · Mt.Vernon, ALJul 18, 1968 · N2423J · Substantial damage NTSB MIA69F0063Accident · No injuriesClosedBoeing A75N1 · Clanton, ALJul 13, 1968 · N55530 · Substantial damage NTSB MIA69F0094Accident · No injuriesClosedBeech 35-B33 · Montgomery, ALJul 4, 1968 · N513AA · Substantial damage NTSB MIA69F0061Accident · Serious injuriesClosedPiper PA-25 · Clanton, ALJul 4, 1968 · N7149Z · Destroyed NTSB MIA69D0044Accident · No injuriesClosedBeech J35 · Clanton, ALJul 4, 1968 · N8309D · Substantial damage NTSB MIA69D0025Accident · Minor injuriesClosedPiper J-5 · Brownsboro, ALJul 4, 1968 · N30924 · Substantial damage NTSB MIA69D0034Accident · No injuriesClosedPiper PA-28 · Decatur, ALJun 27, 1968 · N6321R · Substantial damage NTSB MIA69D0031Accident · No injuriesClosedPiper PA-18 · Montgomery, ALJun 25, 1968 · N1956A · Substantial damage NTSB MIA69F0028Accident · No injuriesClosedPiper PA-22 · Scottsboro, ALJun 20, 1968 · N4970Z · 2 aircraft · Substantial damage NTSB MIA69F0040Accident · Minor injuriesClosedFlaglor II · Gadsden, ALJun 17, 1968 · N12042 · Substantial damage NTSB MIA69D0026Accident · No injuriesClosedCessna 182 · Hurtsboro, ALJun 13, 1968 · N6374A · Substantial damage NTSB MIA68A0104Accident · Minor injuriesClosedCessna 150F · Irvington, ALJun 9, 1968 · N8853S · Substantial damage NTSB MIA68F0542Accident · No injuriesClosedPiper PA-30 · Birmingham, ALJun 8, 1968 · N7474Y · Substantial damage NTSB MIA68A0103Accident · 2 fatalClosedPiper J3C-65 · Montgomery, ALJun 8, 1968 · N65886 · Substantial damage NTSB MIA68D0544Accident · No injuriesClosedPiper PA-28 · Madison, ALJun 6, 1968 · N1748J · Substantial damage NTSB MIA68F0531Accident · No injuriesClosedPiper PA-28 · Gadsden, ALMay 31, 1968 · N5828W · Substantial damage NTSB MIA68F0543Accident · Serious injuriesClosedCessna 140 · Brownsboro, ALMay 30, 1968 · N1895V · Substantial damage NTSB MIA68F0540Accident · Minor injuriesClosedSchempp SHK · Brownsboro, ALMay 30, 1968 · N801M · Substantial damage NTSB MIA69F0001Accident · No injuriesClosedCessna 150G · Geraldine, ALMay 28, 1968 · N3196J · Substantial damage NTSB MIA69F0039Accident · No injuriesClosedAero Comdr 520 · Geiger, ALMay 21, 1968 · N2604B · Substantial damage NTSB MIA68F0538Accident · Serious injuriesClosedCessna 172 · Thomaston, ALMay 19, 1968 · N5810R · Destroyed