Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 FTW80DRD13Accident · No injuriesClosedCessna 185 · Morgan City, LADec 28, 1979 · N185M · Substantial damage NTSB FTW80FRD12Accident · Serious injuriesClosedAerospatle AS-350 · Intracstl Cy, LADec 26, 1979 · N3594B · Substantial damage NTSB FTW80FA028Accident · 2 fatalClosedBeech 65-90 · Leeville, LADec 22, 1979 · N724N · Destroyed NTSB FTW80FRD14Accident · No injuriesClosedHughes 369D · Westwego, LADec 19, 1979 · N58270 · Substantial damage NTSB FTW80FA023Accident · 1 fatalClosedCessna 180K · Harvey, LADec 18, 1979 · N2594K · Substantial damage NTSB FTW80FA022Accident · 2 fatalClosedCessna A185F · Venice, LADec 15, 1979 · N1850R · Destroyed NTSB FTW80FRD11Accident · Serious injuriesClosedCessna 421B · Lafayette, LADec 9, 1979 · N5970M · Substantial damage NTSB FTW80FRD09Accident · No injuriesClosedPiper PA-32 · Cameron, LADec 5, 1979 · N321HF · Substantial damage NTSB FTW80FRD10Accident · No injuriesClosedSikorsky S-76A · Intracstl City, LANov 29, 1979 · N476AL · Substantial damage NTSB FTW80DRD05Accident · No injuriesClosedAero-Comdr S2R · Vinton, LANov 27, 1979 · N4857X · Substantial damage NTSB FTW80DRD03Accident · No injuriesClosedCessna 185 · Morgan City, LANov 24, 1979 · N51BC · Substantial damage NTSB FTW80FRJ07Accident · Minor injuriesClosedCessna 150M · Ruston, LANov 2, 1979 · N714LX · Substantial damage NTSB FTW80FRJ06Accident · No injuriesClosedCessna 310P · Shreveport, LAOct 25, 1979 · N5911M · Substantial damage NTSB FTW80FRJ03Accident · No injuriesClosedCessna 310A · Shreveport, LAOct 23, 1979 · N5340A · Substantial damage NTSB FTW80DRD02Accident · No injuriesClosedCessna 180F · Morgan City, LAOct 22, 1979 · N9976N · Substantial damage NTSB FTW80FRD08Accident · No injuriesClosedHughes 369D · Abbeville, LAOct 11, 1979 · N58240 · Substantial damage NTSB FTW80FRD07Accident · No injuriesClosedBell 206L · Lake Charles, LAOct 9, 1979 · N5018N · Destroyed NTSB FTW80DRD06Accident · No injuriesClosedCessna 185F · E Timbalier Is, LAOct 9, 1979 · N5074R · Substantial damage NTSB FTW80FRJ01Accident · Minor injuriesClosedAero Comdr 680W · Alexandria, LAOct 4, 1979 · N713SP · Destroyed NTSB FTW80FRD01Accident · No injuriesClosedPiper PA-23 · Opelousas, LAOct 3, 1979 · N62267 · Substantial damage NTSB FTW80DRD04Accident · No injuriesClosedCessna 152 · Kentwood, LAOct 1, 1979 · N49991 · Substantial damage NTSB FTW79DRD57Accident · No injuriesClosedPiper PA-25 · Baton Rouge, LASep 28, 1979 · N4485Y · Substantial damage NTSB FTW79DA109Accident · No injuriesClosedBell 212 · Morgan City, LASep 25, 1979 · N49673 · Substantial damage NTSB FTW79DRD56Accident · No injuriesClosedCessna 188B · Vacherie, LASep 24, 1979 · N9448G · Substantial damage NTSB FTW79DRJ25Accident · No injuriesClosedGrum-Amer AA1-C · Minden, LASep 21, 1979 · N9784U · Substantial damage NTSB FTW79FA108Accident · 4 fatalClosedPiper PA-31 · Luling, LASep 20, 1979 · N27614 · Destroyed NTSB FTW79FRD55Accident · No injuriesClosedBell 206B · Patterson, LASep 18, 1979 · N155AL · Substantial damage NTSB FTW79FRJ52Accident · No injuriesClosedBoeing PT-17 · Shreveport, LASep 13, 1979 · N63804 · Substantial damage NTSB FTW79FRD53Accident · No injuriesClosedBoeing A75N1 · Cade, LASep 12, 1979 · N53165 · Substantial damage NTSB FTW79DRD54Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LASep 12, 1979 · N3030S · Substantial damage NTSB FTW79FA107Accident · 1 fatalClosedCessna 172N · Lafayette, LASep 8, 1979 · N1944F · Destroyed NTSB FTW79FRD52Accident · No injuriesClosedBell 47G-4A · Hackberry, LASep 6, 1979 · N7104J · Substantial damage NTSB FTW79DRD51Accident · Minor injuriesClosedPiper PA-25 · White Castle, LASep 6, 1979 · N7759Z · Substantial damage NTSB FTW79DRJ23Accident · No injuriesClosedBellanca 17-30 · Jena, LASep 3, 1979 · N11811 · Substantial damage NTSB FTW79DA104Accident · 1 fatalClosedCessna T210P · Intercoastal, LASep 1, 1979 · N6531P · Destroyed NTSB FTW79DRJ22Accident · No injuriesClosedGrumman G-164B · Monterey, LAAug 30, 1979 · N6890K · Substantial damage NTSB FTW79DRJ21Accident · No injuriesClosedBoeing A75N1 · Tallulah, LAAug 23, 1979 · N4440N · Substantial damage NTSB FTW79DA102Accident · No injuriesClosedCessna 180 · Mandeville, LAAug 22, 1979 · N3494V · Substantial damage NTSB FTW79FRD50Accident · No injuriesClosedBell 47G-4A · Lafayette, LAAug 19, 1979 · N1400W · Substantial damage NTSB FTW79FA101Accident · 2 fatalClosedCessna A185F · Westwego, LAAug 16, 1979 · N8245Q · Destroyed NTSB FTW79FRJ20Accident · 1 fatalClosedRockwell S-2R · Waterproof, LAAug 15, 1979 · N4251X · Destroyed NTSB FTW79DA100Accident · 1 fatalClosedBell 206B · Morgan City, LAAug 11, 1979 · N5018F · Destroyed NTSB FTW79DRD48Accident · No injuriesClosedCessna 150 · New Roads, LAAug 9, 1979 · N63342 · Substantial damage NTSB FTW79DRD49Accident · Minor injuriesClosedBell 206B · Intracstl City, LAAug 8, 1979 · N90171 · Substantial damage NTSB FTW79DRJ19Accident · No injuriesClosedBell 47G-2A · Plaucheville, LAJul 31, 1979 · N166 · Destroyed NTSB FTW79DRJ18Accident · No injuriesClosedBell 47WASP · Plaucheville, LAJul 28, 1979 · N38092 · Substantial damage NTSB FTW79FA097Accident · 1 fatalClosedCessna A185F · Lafayette, LAJul 20, 1979 · N4616E · Destroyed NTSB FTW79FA096Accident · No injuriesClosedBell 206B · Cut Off, LAJul 17, 1979 · N4715R · Substantial damage NTSB FTW79FRJ17Accident · Minor injuriesClosedSnow S2R · Jonesville, LAJul 13, 1979 · N4958X · Destroyed NTSB FTW79DA093Accident · 1 fatalClosedCessna 140 · Basile, LAJul 6, 1979 · N1607V · Destroyed