Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 FTW74DRJ22Accident · No injuriesClosedCessna 177 · Jonesville, LADec 29, 1973 · N3170T · Substantial damage NTSB FTW74AF048Accident · 1 fatalClosedCessna 150A · Grand Isle, LADec 27, 1973 · N7133X · Destroyed NTSB FTW74AF042Accident · No injuriesClosedCessna 180H · Pilottown, LADec 13, 1973 · N7994V · Substantial damage NTSB FTW74DRJ19Accident · Minor injuriesClosedCessna 150 · Minden, LANov 23, 1973 · N11229 · Substantial damage NTSB FTW74AF036Accident · 1 fatalClosedPiper PA-28 · Slidell, LANov 22, 1973 · N6629J · Destroyed NTSB FTW74AF034Accident · Minor injuriesClosedBell 206B · Intrcstl Cty, LANov 20, 1973 · N7904J · Destroyed NTSB FTW74AF032Accident · 1 fatalClosedPitts S-2A · Bogalusa, LANov 17, 1973 · N80022 · Destroyed NTSB FTW74AF031Accident · 2 fatalClosedCessna 150D · Melville, LANov 17, 1973 · N4113U · Destroyed NTSB FTW74AF030Accident · Minor injuriesClosedBell 206B · Intracstl Cty, LANov 13, 1973 · N2929W · Substantial damage NTSB FTW74FRD18Accident · Minor injuriesClosedBell 47G-5A · Belle Chasse, LANov 8, 1973 · N2994W · Destroyed NTSB FTW74FRD17Accident · No injuriesClosedGrumman G-164 · Eunice, LAOct 25, 1973 · N592Y · Substantial damage NTSB FTW74FRD16Accident · No injuriesClosedCessna 150L · Clinton, LAOct 22, 1973 · N1661Q · Destroyed NTSB FTW74DRJ17Accident · Serious injuriesClosedCessna A188 · Oak Ridge, LAOct 22, 1973 · N8170V · Destroyed NTSB FTW74DRD15Accident · No injuriesClosedCessna 177 · Bogalusa, LAOct 17, 1973 · N34517 · Substantial damage NTSB FTW74DRJ15Accident · No injuriesClosedGrumman G-164 · Mer Rouge, LAOct 6, 1973 · N6625 · Substantial damage NTSB FTW74DRJ16Accident · No injuriesClosedLuscombe 8F · Kilbourne, LAOct 1, 1973 · N2129B · Substantial damage NTSB FTW74FRD14Accident · No injuriesClosedPiper PA-25 · Norwood, LASep 26, 1973 · N8506L · Destroyed NTSB FTW74AF017Accident · 6 fatalClosedBeech E18S · Natchitoches, LASep 20, 1973 · N50JR · Destroyed NTSB FTW74AF016Accident · 2 fatalClosedBell 47G-4A · Leeville, LASep 18, 1973 · N4800R · Destroyed NTSB FTW74FRD13Accident · No injuriesClosedGrumman G-164A · Indian Village, LASep 17, 1973 · N6609 · Destroyed NTSB FTW74DRD10Accident · No injuriesClosedCessna 180F · Romer Pass, LASep 14, 1973 · N91291 · Substantial damage NTSB FTW74FRD09Accident · No injuriesClosedAmer Avco AA1-B · Slidell, LASep 9, 1973 · N9917L · Substantial damage NTSB FTW74DPJ08Accident · No injuriesClosedCessna 175C · Hollis, LASep 2, 1973 · N8369T · Substantial damage NTSB FTW74FRJ11Accident · Minor injuriesClosedAmer Avco AA-1 · Converse, LASep 1, 1973 · N5928L · Substantial damage NTSB FTW74FRJ10Accident · Minor injuriesClosedPiper PA-28 · Shreveport, LAAug 31, 1973 · N5064T · Substantial damage NTSB FTW74DRJ09Accident · No injuriesClosedBoeing A75N1 · Mansfield, LAAug 29, 1973 · N212PC · Substantial damage NTSB FTW74DRD08Accident · Minor injuriesClosedGrumman G-164A · Welsh, LAAug 27, 1973 · N6647 · Destroyed NTSB FTW74FRJ12Accident · Minor injuriesClosedPiper PA-25 · Rayville, LAAug 24, 1973 · N7581Z · Destroyed NTSB FTW74DRJ07Accident · No injuriesClosedCessna 150H · Ruston, LAAug 23, 1973 · N23392 · Substantial damage NTSB FTW74DRJ06Accident · Minor injuriesClosedAmer Avco AA1-A · Leesville, LAAug 22, 1973 · N6448L · Destroyed NTSB FTW74FRD06Accident · No injuriesClosedAmer Avco AA-5 · Westwego, LAAug 18, 1973 · N6382L · Substantial damage NTSB FTW74DRJ08Accident · No injuriesClosedTaylorcraft BC12-D · Collingston, LAAug 17, 1973 · N4359A · Substantial damage NTSB FTW74DRD05Accident · Minor injuriesClosedCessna 185E · Venice, LAAug 14, 1973 · N5818J · Substantial damage NTSB FTW74FRJ04Accident · No injuriesClosedPiper PA-32 · Minden, LAAug 11, 1973 · N3691W · Substantial damage NTSB MIA74AM013Accident · Serious injuriesClosedDouglas DC-10 · New Orleans, LAAug 10, 1973 · N67NA · No damage NTSB FTW74DRD07Accident · No injuriesClosedGrumman G-164A · Bell City, LAAug 7, 1973 · N5305 · Substantial damage NTSB FTW74FRJ03Accident · Minor injuriesClosedBell 47G-5A · Shreveport, LAJul 30, 1973 · N58077 · Substantial damage NTSB FTW74AF006Accident · 1 fatalClosedBeech B35 · Natchitoches, LAJul 28, 1973 · N8798A · Destroyed NTSB FTW74DRD04Accident · Serious injuriesClosedCessna 150K · Baton Rouge, LAJul 26, 1973 · N8359M · Destroyed NTSB FTW74FRD03Accident · No injuriesClosedGrumman G-164A · Lake Charles, LAJul 19, 1973 · N4864 · Substantial damage NTSB FTW74AF003Accident · 3 fatalClosedBeech A60 · New Orleans, LAJul 18, 1973 · N7658D · Destroyed NTSB FTW74FRD02Accident · No injuriesClosedGrumman G-164 · Parks, LAJul 17, 1973 · N463RF · Substantial damage NTSB FTW74DRD01Accident · No injuriesClosedGrumman G-164 · Lake Arthur, LAJul 16, 1973 · N468RF · Substantial damage NTSB FTW74FRJ01Accident · No injuriesClosedCessna 310 · Ruston, LAJul 4, 1973 · N2606C · Substantial damage NTSB FTW74FRJ02Accident · Minor injuriesClosedAmer Avco AA-1B · West Monroe, LAJul 2, 1973 · N6277L · Destroyed NTSB FTW73FRD38Accident · No injuriesClosedGrumman G-164 · Thornwell, LAJun 27, 1973 · N464RF · Substantial damage NTSB FTW73DRD37Accident · Minor injuriesClosedGrumman G-164 · Breaux Bridge, LAJun 25, 1973 · N492Y · Substantial damage NTSB FTW73DRJ41Accident · No injuriesClosedAmer Avco AA-5 · Zwolle, LAJun 19, 1973 · N6177L · Substantial damage NTSB FTW73FRJ40Accident · 1 fatalClosedPiper PA-25 · Monroe, LAJun 14, 1973 · N8943L · Destroyed NTSB FTW73DRD36Accident · No injuriesClosedGrumman G-164 · Ville Platte, LAJun 5, 1973 · N10292 · Substantial damage