Skip to content

NTSB investigations, 1975, LA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 FTW76FRD26Accident · Serious injuriesClosedCessna 185A · Delcambre, LADec 20, 1975 · N39FC · No damage NTSB FTW76ARD25Accident · Minor injuriesClosedCessna 172 · Lafayette, LADec 18, 1975 · N5092R · Substantial damage NTSB FTW76FRD24Accident · No injuriesClosedNavion A · New Orleans, LADec 14, 1975 · N8884H · Substantial damage NTSB FTW76AF048Accident · 3 fatalClosedBeech M35 · Jena, LANov 29, 1975 · N1169R · Destroyed NTSB FTW76FRD22Accident · No injuriesClosedGrumman G-164 · Iowa, LANov 25, 1975 · N11983 · Substantial damage NTSB FTW76DRD23Accident · No injuriesClosedMooney M20C · Meraux, LANov 23, 1975 · N9206M · Substantial damage NTSB FTW76DRD21Accident · No injuriesClosedCessna 185 · Houma, LANov 21, 1975 · N1744R · Substantial damage NTSB FTW76FRJ12Accident · Serious injuriesClosedCessna 150F · Oil City, LANov 18, 1975 · N7116F · Substantial damage NTSB FTW76DRD19Accident · No injuriesClosedCessna 140 · New Orleans, LANov 16, 1975 · N2996N · Substantial damage NTSB FTW76AF045Accident · 1 fatalClosedCessna 150F · Crowville, LANov 15, 1975 · N8607S · Destroyed NTSB FTW76FRD20Accident · No injuriesClosedPiper J3C-65 · Melville, LANov 13, 1975 · N70421 · Substantial damage NTSB FTW76DRD18Accident · No injuriesClosedCessna 170B · Westwego, LANov 9, 1975 · N12218 · Substantial damage NTSB FTW76FRD16Accident · No injuriesClosedBell 206B · Morgan City, LANov 2, 1975 · N7847S · Substantial damage NTSB FTW76AF040Accident · 3 fatalClosedPiper PA-28R · New Orleans, LANov 1, 1975 · N9489N · Destroyed NTSB FTW76FRD45Accident · No injuriesClosedGrumman G-164A · Sweet Lake, LAOct 29, 1975 · N9512 · Substantial damage NTSB FTW76FRD14Accident · No injuriesClosedPiper PA-25 · Opelousas, LAOct 22, 1975 · N8791L · Substantial damage NTSB FTW76AF034Accident · 2 fatalClosedCessna 150 · Oak Grove, LAOct 19, 1975 · N19003 · Destroyed NTSB FTW76DRD13Accident · No injuriesClosedCessna 185 · Golden Meadow, LAOct 10, 1975 · N12NT · Substantial damage NTSB FTW76AF028Accident · Serious injuriesClosedBell 206B · Pecan Island, LAOct 8, 1975 · N83134 · Substantial damage NTSB FTW76FRD10Accident · No injuriesClosedBoeing A75 · Lake Charles, LASep 29, 1975 · N4912N · Substantial damage NTSB FTW76AF025Accident · 1 fatalClosedMooney M20E · Freemason Isld, LASep 29, 1975 · N1247X · Destroyed NTSB FTW76DRD12Accident · No injuriesClosedGrum Amer AA1-B · Thibodaux, LASep 28, 1975 · N9937L · Substantial damage NTSB FTW76DRD11Accident · No injuriesClosedCessna 185 · Lake Arthur, LASep 28, 1975 · N1507F · Substantial damage NTSB FTW76FRD09Accident · No injuriesClosedPiper PA-28 · Plaquemine, LASep 27, 1975 · N33674 · Substantial damage NTSB FTW76FRJ10Accident · Serious injuriesClosedPiper PA-28 · Jena, LASep 20, 1975 · N8228N · Destroyed NTSB FTW76AF022Accident · 1 fatalClosedSemco TC-4 · Baton Rouge, LASep 19, 1975 · N3810 · Destroyed NTSB FTW76DRD08Accident · No injuriesClosedCessna 180F · Houma, LASep 17, 1975 · N9945V · Substantial damage NTSB FTW76AF021Accident · 2 fatalClosedPiper PA-32 · Alexandria, LASep 16, 1975 · N7747J · Destroyed NTSB FTW76AF020Accident · No injuriesClosedHughes 369HS · Venice, LASep 15, 1975 · N9088F · Substantial damage NTSB FTW76AF018Accident · 1 fatalClosedBellanca 17-31 · Larto, LASep 7, 1975 · N14713 · Destroyed NTSB FTW76DRJ09Accident · No injuriesClosedBeech B19 · Holly Ridge, LASep 1, 1975 · N6557R · Substantial damage NTSB FTW76DRD06Accident · Serious injuriesClosedLuscombe 8A · Gonzales, LAAug 24, 1975 · N25168 · Substantial damage NTSB FTW7LDRJ07Accident · No injuriesClosedCessna P337 · Alexandria, LAAug 22, 1975 · N5CS · Substantial damage NTSB FTW76DRJ08Accident · No injuriesClosedAero Comdr 112 · Monroe, LAAug 21, 1975 · N1041J · Substantial damage NTSB FTW76AF013Accident · No injuriesClosedBell 47G-4A · Leeville, LAAug 20, 1975 · N4003G · Substantial damage NTSB FTW76DRJ06Accident · Minor injuriesClosedPiper PA-23 · Alexandria, LAAug 16, 1975 · N54166 · Destroyed NTSB FTW75FRD04Accident · No injuriesClosedBeech G35 · Baton Rouge, LAAug 15, 1975 · N4480D · Substantial damage NTSB FTW7LDRD07Accident · No injuriesClosedPiper PA-18 · Wilson, LAAug 13, 1975 · N14299 · Substantial damage NTSB FTW76FRD05Accident · No injuriesClosedGrumman G-164A · Erath, LAAug 12, 1975 · N7231 · Substantial damage NTSB FTW76DRJ04Accident · No injuriesClosedGrumman G-164A · Rayville, LAAug 11, 1975 · N5256 · Destroyed NTSB FTW76FRD03Accident · Serious injuriesClosedCessna 180 · Golden Meadow, LAAug 5, 1975 · N9769G · Substantial damage NTSB FTW76AF007Accident · Minor injuriesClosedBell 206B · Morgan City, LAAug 5, 1975 · N4710R · Destroyed NTSB FTW76DRD02Accident · No injuriesClosedCessna 182 · Covington, LAJul 28, 1975 · N41GC · Substantial damage NTSB FTW76DRD01Accident · No injuriesClosedCessna 182K · New Orleans, LAJul 25, 1975 · N2496Q · Substantial damage NTSB FTW76AF031Accident · 2 fatalClosedPiper PA-32 · Bernice, LAJul 21, 1975 · N3704W · Destroyed NTSB FTW76DRJ03Accident · No injuriesClosedGlobe GC-1B · Minden, LAJul 13, 1975 · N3791K · Substantial damage NTSB FTW75FRD69Accident · Serious injuriesClosedGrumman G-164A · Iowa, LAJun 28, 1975 · N9774 · Substantial damage NTSB FTW75AF076Accident · 2 fatalClosedPiper PA-28 · Baton Rouge, LAJun 27, 1975 · N32558 · Destroyed NTSB FTW75DRJ38Accident · No injuriesClosedTern Glider · Lecompte, LAJun 21, 1975 · N7308 · Substantial damage NTSB FTW75FRJ37Accident · No injuriesClosedNavion A · Mansfield, LAJun 15, 1975 · N8885H · Substantial damage