Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 MIA70F0283Accident · Minor injuriesClosedEnstrom F28A · Phenix City, ALDec 29, 1969 · N4880 · Substantial damage NTSB MIA70D0264Accident · No injuriesClosedCessna 150 · St Elmo, ALDec 27, 1969 · N3465J · Destroyed NTSB MIA70D0279Accident · No injuriesClosedCessna 170A · Bessemer, ALDec 20, 1969 · N5407C · Substantial damage NTSB MIA70A0046Accident · No injuriesClosedBeech E18S · Montgomery, ALDec 10, 1969 · N679T · Substantial damage NTSB MIA70D0242Accident · No injuriesClosedPiper PA-30 · Ozark, ALNov 29, 1969 · N7026Y · Substantial damage NTSB MIA70D0250Accident · No injuriesClosedCessna 150H · Geneva, ALNov 28, 1969 · N6734S · Substantial damage NTSB MIA70D0232Accident · No injuriesClosedChampion 7KCAB · Montevallo, ALNov 16, 1969 · N5176X · Substantial damage NTSB MIA70D0226Accident · No injuriesClosedBeech 35 · Greensboro, ALNov 12, 1969 · N2845V · Substantial damage NTSB MIA70D0236Accident · No injuriesClosedPiper PA-30 · Enterprise, ALNov 10, 1969 · N8319Y · Substantial damage NTSB MIA70F0225Accident · No injuriesClosedBeech 23 · Sylacauga, ALNov 4, 1969 · N2326Q · Substantial damage NTSB MIA70F0224Accident · No injuriesClosedCessna 150G · Moulton, ALOct 25, 1969 · N3678J · Substantial damage NTSB MIA70F0231Accident · No injuriesClosedCessna 182 · Muscle Shoals, ALOct 22, 1969 · N3198Y · Substantial damage NTSB MIA70F0254Accident · No injuriesClosedCessna 150F · Guntersville, ALOct 21, 1969 · N6484S · Substantial damage NTSB MIA70D0205Accident · Minor injuriesClosedCallair A-5 · Prattville, ALOct 10, 1969 · N29226 · Destroyed NTSB MIA70D0217Accident · No injuriesClosedMooney M20F · Altoona, ALOct 7, 1969 · N2984L · Substantial damage NTSB MIA70D0198Accident · No injuriesClosedPiper PA-28 · Birmingham, ALOct 5, 1969 · N5977W · Substantial damage NTSB MIA70D0186Accident · No injuriesClosedPiper J-3 · Bay Minette, ALSep 29, 1969 · N35471 · Substantial damage NTSB MIA70D0164Accident · No injuriesClosedCessna 172 · Gadsden, ALSep 29, 1969 · N8302B · Substantial damage NTSB MIA70A0021Accident · No injuriesClosedBeech 95-B55 · Camden, ALSep 16, 1969 · N8933M · Substantial damage NTSB MIA70D0222Accident · No injuriesClosedCessna 182 · Bessemer, ALSep 4, 1969 · N3532F · Substantial damage NTSB MIA70D0157Accident · No injuriesClosedCessna 150 · Hillsboro, ALAug 30, 1969 · N6237S · Substantial damage NTSB MIA70D0130Accident · No injuriesClosedCessna 170B · Andalusia, ALAug 30, 1969 · N2385D · Substantial damage NTSB MIA70A0016Accident · 3 fatalClosedBeech 65 · Mobile, ALAug 26, 1969 · N3333M · Destroyed NTSB MIA70D0169Accident · No injuriesClosedPiper PA-30 · Alexander Cty, ALAug 10, 1969 · N7012Y · Substantial damage NTSB MIA70F0111Accident · No injuriesClosedCessna 150F · St Elmo, ALJul 31, 1969 · N7752F · Substantial damage NTSB MIA70F0088Accident · 1 fatalClosedBoeing A75N1 · Eufaula, ALJul 25, 1969 · N49982 · Destroyed NTSB MIA70D0103Accident · Serious injuriesClosedPiper PA-25 · Atmore, ALJul 25, 1969 · N6655Z · Substantial damage NTSB MIA70F0112Accident · 1 fatalClosedPiper PA-18A · Alberta, ALJul 23, 1969 · N8173C · Destroyed NTSB MIA70D0158Accident · No injuriesClosedBeech B35 · Hamilton, ALJul 23, 1969 · N5257C · Substantial damage NTSB FTW70A0004Accident · Serious injuriesClosedDouglas DC-8 · Evergreen, ALJul 22, 1969 · N812E · No damage NTSB MIA70D0083Accident · No injuriesClosedCessna 150F · Ozark, ALJul 19, 1969 · N8207S · Substantial damage NTSB UNK69X0133Accident · 4 fatalClosedAero Comdr 100 · Lacey Springs, ALJul 15, 1969 · N5549M · Destroyed NTSB MIA70F0052Accident · No injuriesClosedBeech C-45 · Faunsdale, ALJul 12, 1969 · N9847Z · Substantial damage NTSB MIA70D0110Accident · No injuriesClosedCessna 210 · Decatur, ALJul 12, 1969 · N7398E · Substantial damage NTSB MIA70F0060Accident · Minor injuriesClosedAeronca 7FC · Weaver, ALJul 5, 1969 · N9891B · Substantial damage NTSB MIA70D0059Accident · No injuriesClosedCessna 195B · Meridianville, ALJul 5, 1969 · N2137C · Substantial damage NTSB MIA70D0133Accident · No injuriesClosedBeech B23 · Monroeville, ALJul 4, 1969 · N4003T · Substantial damage NTSB MIA70F0042Accident · Minor injuriesClosedCessna 182F · Owens X-Roads, ALJul 2, 1969 · N3208U · Substantial damage NTSB MIA70D0041Accident · Minor injuriesClosedCessna 150G · Ranburne, ALJul 1, 1969 · N2262J · Destroyed NTSB MIA70F0029Accident · No injuriesClosedPiper PA-28 · Birmingham, ALJun 29, 1969 · N5097W · Substantial damage NTSB MIA70D0043Accident · No injuriesClosedAeronca 65-CA · Enterprise, ALJun 27, 1969 · N31899 · Substantial damage NTSB MIA70D0005Accident · No injuriesClosedGrumman 164 · Dayton, ALJun 24, 1969 · N10289 · Destroyed NTSB MIA70F0046Accident · No injuriesClosedBeech B23 · Birmingham, ALJun 23, 1969 · N6051N · Substantial damage NTSB MIA70F0024Accident · Serious injuriesClosedPiper PA-25 · Rutledge, ALJun 23, 1969 · N7505Z · Destroyed NTSB MIA70F0015Accident · Minor injuriesClosedCessna 172 · Russellville, ALJun 22, 1969 · N3256U · Substantial damage NTSB MIA70D0085Accident · No injuriesClosedCessna 150 · Faunsdale, ALJun 12, 1969 · N7153X · Substantial damage NTSB MIA69D0494Accident · No injuriesClosedPiper PA-28 · Gordo, ALJun 1, 1969 · N5222W · Destroyed NTSB MIA70D0054Accident · No injuriesClosedPiper PA-28 · Cullman, ALMay 20, 1969 · N8592W · Substantial damage NTSB MIA70D0008Accident · No injuriesClosedLuscombe 8A · Stevenson, ALMay 18, 1969 · N9934C · Substantial damage NTSB MIA69A0079Accident · 1 fatalClosedCessna 150G · Riverview, ALMay 17, 1969 · N8600J · Destroyed