Skip to content

NTSB investigations, 1980, LA

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, 1980, LA per year, 1962–2026: 3,066 cases
1962	1
1963	3
1964	120
1965	109
1966	108
1967	118
1968	100
1969	100
1970	91
1971	75
1972	75
1973	88
1974	84
1975	105
1976	93
1977	106
1978	108
1979	103
1980	110
1981	95
1982	78
1983	57
1984	72
1985	57
1986	47
1987	33
1988	36
1989	41
1990	40
1991	26
1992	25
1993	32
1994	25
1995	22
1996	40
1997	28
1998	27
1999	28
2000	26
2001	28
2002	26
2003	21
2004	27
2005	32
2006	18
2007	15
2008	13
2009	21
2010	16
2011	28
2012	23
2013	19
2014	19
2015	20
2016	21
2017	17
2018	18
2019	21
2020	23
2021	23
2022	16
2023	16
2024	26
2025	17
2026	10

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") = 1980 AND c."eventStateOrRegion" = 'LA' 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\") = 1980
    AND c.\"eventStateOrRegion\" = 'LA' 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") = 1980
  AND c."eventStateOrRegion" = 'LA' 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 FTW81FA020Accident · No injuriesClosedBell 206B · Patterson, LADec 31, 1980 · N222LM · Substantial damage NTSB FTW81DRD11Accident · No injuriesClosedCessna 172M · Belle Chasse, LADec 26, 1980 · N73214 · Substantial damage NTSB FTW81FA018Accident · 3 fatalClosedAero Cmdr 1121 · Many, LADec 19, 1980 · N29LB · Destroyed NTSB FTW81DRD10Accident · No injuriesClosedBoeing 75 · Sulphur, LADec 17, 1980 · N62418 · Substantial damage NTSB FTW81DA014Accident · 1 fatalClosedBell 206B3 · Cameron, LADec 2, 1980 · N5003Q · Destroyed NTSB FTW81DRD09Accident · No injuriesClosedGrum-Amer AA-1A · Clinton, LADec 1, 1980 · N9314L · Substantial damage NTSB FTW81FRJ06Accident · No injuriesClosedCessna 152 · Springhill, LANov 28, 1980 · N47314 · Substantial damage NTSB FTW81DRD07Accident · Minor injuriesClosedPiper PA-32 · Loreauville, LANov 25, 1980 · N4690F · Substantial damage NTSB FTW81DRD06Accident · No injuriesClosedPiper PA-25 · White Castle, LANov 11, 1980 · N7053Z · Substantial damage NTSB FTW81FRD04Accident · No injuriesClosedPitts S-2A · New Orleans, LANov 4, 1980 · N333BD · 2 aircraft · Substantial damage NTSB FTW81DRJ04Accident · No injuriesClosedCessna 152 · Florien, LAOct 26, 1980 · N48825 · Substantial damage NTSB FTW81DRD03Accident · No injuriesClosedCessna 185F · Cameron, LAOct 22, 1980 · N5458E · Substantial damage NTSB FTW81DRD02Accident · No injuriesClosedPiper PA-28 · Lake Charles, LAOct 11, 1980 · N2202W · Substantial damage NTSB FTW81FA003Accident · 1 fatalClosedCessna 182A · Kentwood, LAOct 7, 1980 · N2015G · Destroyed NTSB FTW81DRD05Accident · No injuriesClosedSchweizer 2-33A · Robert, LAOct 4, 1980 · N5732S · Substantial damage NTSB FTW81FRJ01Accident · Serious injuriesClosedGrumman G-164 · Marksville, LAOct 2, 1980 · N494Y · Destroyed NTSB FTW81DRD01Accident · No injuriesClosedCessna T188C · White Castle, LAOct 2, 1980 · N4017J · Substantial damage NTSB FTW80DRJ45Accident · No injuriesClosedCessna 180 · Pitkin, LASep 25, 1980 · N7577K · Substantial damage NTSB FTW80DA121Accident · No injuriesClosedBell 206L-1 · Creole, LASep 24, 1980 · N27483 · Substantial damage NTSB FTW80DRJ44Accident · No injuriesClosedCessna 172C · Rocky Branch, LASep 23, 1980 · N1829Y · Substantial damage NTSB FTW80FA116Accident · 4 fatalClosedPiper PA-32 · Goodwill, LASep 17, 1980 · N1806T · Destroyed NTSB FTW80DA117Accident · No injuriesClosedBell 206B · Intracstl Cy, LASep 16, 1980 · N27758 · Substantial damage NTSB FTW80FA114Accident · 1 fatalClosedCessna 401 · Houma, LASep 12, 1980 · N444CS · 2 aircraft · Destroyed NTSB FTW80DRJ41Accident · No injuriesClosedCessna U206G · Delhi, LASep 11, 1980 · N9942N · Substantial damage NTSB FTW80DRJ40Accident · No injuriesClosedPiper PA-23 · Pineville, LASep 11, 1980 · N62730 · Substantial damage NTSB FTW80FRJ39Accident · No injuriesClosedCessna 150K · Shreveport, LASep 8, 1980 · N5803G · Substantial damage NTSB FTW80DRJ38Accident · No injuriesClosedPiper J-3 · Tallulah, LASep 7, 1980 · N41232 · Substantial damage NTSB FTW80DRD62Accident · No injuriesClosedCessna 180F · Westwego, LASep 7, 1980 · N2135Z · Substantial damage NTSB FTW80FRD61Accident · Serious injuriesClosedPietenpol Aircmp · Patterson, LASep 6, 1980 · N4272 · Destroyed NTSB FTW80FRJ37Accident · 2 fatalClosedBell 47G-2A · Cottonport, LASep 3, 1980 · N73988 · Destroyed NTSB FTW80FA112Accident · No injuriesClosedAerospatial AS350 · Patterson, LASep 3, 1980 · N3602V · Substantial damage NTSB FTW80FA111Accident · Minor injuriesClosedSikorsky S-76 · Patterson, LASep 3, 1980 · N766AL · Destroyed NTSB FTW80DRD60Accident · No injuriesClosedCessna 185F · Leeville, LASep 3, 1980 · N5125E · Substantial damage NTSB FTW80DA110Accident · No injuriesClosedCessna 185 · Houma, LASep 1, 1980 · N8308Q · Substantial damage NTSB FTW80DRD59Accident · No injuriesClosedBell 206L-1 · Intracstl Cty, LAAug 29, 1980 · N2775A · Substantial damage NTSB FTW80DA109Accident · No injuriesClosedPiper PA-31 · Patterson, LAAug 29, 1980 · N228CH · Substantial damage NTSB FTW80DRJ36Accident · Minor injuriesClosedWeatherly 201B · Winnsboro, LAAug 28, 1980 · N1285W · 2 aircraft · Substantial damage NTSB FTW80FRJ35Accident · 1 fatalClosedPiper PA-25 · Transylvania, LAAug 23, 1980 · N8503L · Destroyed NTSB FTW80DRD58Accident · No injuriesClosedCessna 185F · Slidell, LAAug 22, 1980 · N4805Q · Substantial damage NTSB FTW80DRD54Accident · Minor injuriesClosedHughes 269B · Wakefield, LAAug 16, 1980 · N1093D · Substantial damage NTSB FTW80FRD56Accident · Serious injuriesClosedCessna 150 · Sulphur, LAAug 14, 1980 · N3660V · Substantial damage NTSB FTW80DRD57Accident · No injuriesClosedCessna 188B · Port Barre, LAAug 12, 1980 · N9230G · Destroyed NTSB FTW80FRD55Accident · Minor injuriesClosedPiper PA-25 · Plaquemine, LAAug 11, 1980 · N4485Y · Destroyed NTSB FTW80DRJ31Accident · No injuriesClosedStearman B75 · Tallulah, LAAug 7, 1980 · N8095E · Substantial damage NTSB FTW80FA100Accident · 13 fatalClosedBell 205A-1 · Houma, LAAug 6, 1980 · N95AL · Destroyed NTSB FTW80DRD53Accident · No injuriesClosedCessna 180 · Empire, LAAug 6, 1980 · N9945V · Destroyed NTSB FTW80DRD50Accident · No injuriesClosedBeech E55 · Houma, LAJul 31, 1980 · N9047V · Substantial damage NTSB FTW80DRD51Accident · No injuriesClosedGrumman G-164A · Kinder, LAJul 29, 1980 · N48377 · Substantial damage NTSB FTW80FA097Accident · 1 fatalClosedCessna 182Q · Vidalia, LAJul 28, 1980 · N759SS · Destroyed NTSB FTW80FA094Accident · 5 fatalClosedSikorsky S-58T · Morgan City, LAJul 18, 1980 · N69CH · Destroyed