Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MIA78DKJ16Accident · No injuriesClosedPiper PA-32R · Selma, ALDec 27, 1977 · N3570Q · Substantial damage NTSB MIA78DKJ15Accident · No injuriesClosedCessna 177B · Tuscaloosa, ALDec 23, 1977 · N18643 · Substantial damage NTSB MIA78AF019Accident · 1 fatalClosedCessna 150 · Dauphin Island, ALDec 17, 1977 · N6589T · Destroyed NTSB MIA78FKJI4Accident · No injuriesClosedCessna 421C · Bay Minette, ALDec 16, 1977 · N8305G · Substantial damage NTSB MIA78FKJ11Accident · Minor injuriesClosedCessna 177 · Scearcy, ALDec 4, 1977 · N76HS · Substantial damage NTSB MIA78FKJ08Accident · No injuriesClosedBeech A23 · Redhill, ALNov 29, 1977 · N8790M · Substantial damage NTSB MIA78DKJ10Accident · No injuriesClosedBeech J35 · Huntsville, ALNov 16, 1977 · N8318D · Substantial damage NTSB MIA78FA013Accident · 7 fatalClosedCessna 441 · Greensboro, ALNov 15, 1977 · N9971G · Destroyed NTSB MIA78DKJ07Accident · No injuriesClosedCessna 182 · Wetumpka, ALNov 15, 1977 · N1264S · Substantial damage NTSB MIA78FKJ05Accident · No injuriesClosedStinson 108-1 · Gurley, ALOct 30, 1977 · N9170K · Destroyed NTSB MIA78DKJ04Accident · No injuriesClosedGrum Amer AA1-B · Haleyville, ALOct 15, 1977 · N9943L · Substantial damage NTSB MIA78DKJ03Accident · No injuriesClosedBeech T34 · Headland, ALOct 15, 1977 · N10554 · Substantial damage NTSB MIA78DKJ01Accident · No injuriesClosedPiper PA28 · Toxey, ALOct 5, 1977 · N3293Q · Substantial damage NTSB MIA78DKJ02Accident · No injuriesClosedCessna 172P · Clanton, ALOct 4, 1977 · N4667K · Substantial damage NTSB MIA77FA093Accident · 1 fatalClosedBeech 100 · Auburn, ALSep 27, 1977 · N925BD · Destroyed NTSB MIA77FKJ83Accident · No injuriesClosedPiper PA-24 · Birmingham, ALSep 17, 1977 · N5779P · Substantial damage NTSB MIA78FKJ81Accident · No injuriesClosedCessna 172 · Grove Hill, ALSep 3, 1977 · N64260 · Minor damage NTSB MIA77FKJ80Accident · Minor injuriesClosedCessna 188 · Coosada, ALSep 3, 1977 · N3564Q · Destroyed NTSB MIA77FKJ88Accident · Serious injuriesClosedCessna 172 · Weaver, ALAug 31, 1977 · N8302B · Substantial damage NTSB MIA77DKJ79Accident · No injuriesClosedPiper PA-25 · Mccullough, ALAug 25, 1977 · N7509Z · Substantial damage NTSB MIA77DKJ78Accident · No injuriesClosedAero Comdr A9 · Berry, ALAug 21, 1977 · N7291V · Substantial damage NTSB MIA77DKJ77Accident · No injuriesClosedHughes 269A · Clanton, ALAug 21, 1977 · N8877F · Substantial damage NTSB MIA77FKJ76Accident · 1 fatalClosedPiper PA-25 · Castleberry, ALAug 20, 1977 · N4622Y · Destroyed NTSB MIA77DKJ75Accident · Minor injuriesClosedBellanca 1730 · Dauphin Is, ALAug 17, 1977 · N7324V · Substantial damage NTSB MIA77DKJ74Accident · No injuriesClosedPiper PA-25 · Ashford, ALAug 16, 1977 · N4960Y · Substantial damage NTSB MIA77DKJ73Accident · Minor injuriesClosedPiper PA-18 · Cullman, ALAug 16, 1977 · N8176C · Substantial damage NTSB MIA77FKJ69Accident · 1 fatalClosedPiper PA-18 · Vincent, ALAug 15, 1977 · N4731A · Destroyed NTSB MIA77DKJ70Accident · Minor injuriesClosedBoeing E75 · Mexia, ALAug 15, 1977 · N4850N · Substantial damage NTSB MIA77FKJ68Accident · No injuriesClosedCessna 195 · Dothan, ALAug 14, 1977 · N195GN · Substantial damage NTSB MIA77DKJ67Accident · Minor injuriesClosedBeech C-23 · Montgomery, ALAug 13, 1977 · N18766 · Substantial damage NTSB MIA77DKJ72Accident · No injuriesClosedPiper PA-30 · Montgomery, ALAug 12, 1977 · N7555Y · Substantial damage NTSB MIA77DKJ71Accident · No injuriesClosedHughes 269A1 · Mt.Meigs, ALAug 11, 1977 · N8897F · Substantial damage NTSB MIA77DKJ65Accident · No injuriesClosedBell 47D1 · New Brockton, ALAug 6, 1977 · N8282 · Substantial damage NTSB MIA77DKJ64Accident · Minor injuriesClosedRockwell S2R · Bay Minette, ALAug 6, 1977 · N8942Q · Substantial damage NTSB MIA77DKJ66Accident · No injuriesClosedBeech 58 · Centerville, ALAug 5, 1977 · N21BW · Substantial damage NTSB MIA77FKJ63Accident · No injuriesClosedAero Comdr A9 · Samson, ALAug 4, 1977 · N7284V · Substantial damage NTSB MIA77FKJ54Accident · No injuriesClosedCessna 182 · Foley, ALAug 1, 1977 · N2378R · Destroyed NTSB MIA77DKJ62Accident · Serious injuriesClosedEnstrom F28 · Montgomery, ALJul 31, 1977 · N2950 · Substantial damage NTSB MIA77FA072Accident · 3 fatalClosedPiper PA-32 · Clanton, ALJul 29, 1977 · N8663N · Destroyed NTSB MIA77FKJ61Accident · No injuriesClosedPiper PA-23 · Montgomery, ALJul 27, 1977 · N1908T · Substantial damage NTSB MIA77FKJ60Accident · No injuriesClosedCessna 177RG · Weaver, ALJul 26, 1977 · N33273 · Substantial damage NTSB MIA77FA067Accident · 2 fatalClosedBellanca 7KCAB · Elberta, ALJul 14, 1977 · N87045 · Destroyed NTSB MIA77DKJ57Accident · No injuriesClosedPiper PA18 · Alabaster, ALJul 9, 1977 · N221T · Substantial damage NTSB MIA77FKJ56Accident · Serious injuriesClosedBeech C18S · Irvington, ALJul 4, 1977 · N711SM · Substantial damage NTSB MIA77FKJ55Accident · Minor injuriesClosedCessna 177G · Monroeville, ALJul 4, 1977 · N35869 · Substantial damage NTSB MIA77FKJ53Accident · No injuriesClosedPiper PA-18 · Riverside, ALJun 29, 1977 · N9115D · Substantial damage NTSB MIA77FA065Accident · 1 fatalClosedPiper PA18 · Foley, ALJun 26, 1977 · N9578D · Destroyed NTSB MIA77DKJ51Accident · No injuriesClosedCessna 150H · Birmingham, ALJun 25, 1977 · N6470S · Substantial damage NTSB MIA77FKJ50Accident · Minor injuriesClosedPiper PA-28 · Talladega, ALJun 24, 1977 · N75041 · Substantial damage NTSB MIA77FKJ48Accident · No injuriesClosedCessna 150 · Gordon, ALJun 20, 1977 · N704JZ · Substantial damage