Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 FTW73FRD14Accident · No injuriesClosedBeech B95 · New Orleans, LADec 28, 1972 · N635B · Substantial damage NTSB FTW73DRD12Accident · No injuriesClosedGrumman G-164A · Duson, LADec 18, 1972 · N962X · Substantial damage NTSB FTW73AF029Accident · 1 fatalClosedHughes 369HS · Venice, LADec 18, 1972 · N9093F · Destroyed NTSB FTW73AF027Accident · No injuriesClosedBeech C-45H · Houma, LADec 12, 1972 · N3329G · Substantial damage NTSB FTW73AF021Accident · 1 fatalClosedCessna 150F · New Orleans, LANov 30, 1972 · N6958F · Destroyed NTSB FTW73FRD11Accident · No injuriesClosedPiper PA-28 · New Orleans, LANov 22, 1972 · N486FL · Substantial damage NTSB FTW73DRJ24Accident · Minor injuriesClosedAeronca 7DC · Lk Providence, LANov 22, 1972 · N81475 · Substantial damage NTSB FTW73FRJ21Accident · No injuriesClosedCessna 150L · Shreveport, LANov 19, 1972 · N5202Q · Substantial damage NTSB FTW73DRJ22Accident · No injuriesClosedCessna 205 · Bonita, LANov 15, 1972 · N511RJ · Substantial damage NTSB FTW73DRD10Accident · Minor injuriesClosedBell 47G-4A · Dulac, LANov 10, 1972 · N4708R · Substantial damage NTSB FTW73DRJ20Accident · Serious injuriesClosedChampion 7GCB · Lak Providence, LANov 4, 1972 · N8523E · Destroyed NTSB FTW73FRD09Accident · Serious injuriesClosedPiper PA-18 · Bayou Chene, LAOct 15, 1972 · N1860P · Destroyed NTSB FTW73FRD08Accident · Serious injuriesClosedAeronca 7AC · Fenton, LAOct 12, 1972 · N4198E · Substantial damage NTSB FTW73FRD07Accident · Minor injuriesClosedCessna 180 · Patterson, LASep 19, 1972 · N41CH · Substantial damage NTSB FTW73FRJ15Accident · Minor injuriesClosedBoeing E75N1 · Mcdade, LASep 16, 1972 · N5200N · Substantial damage NTSB FTW73FRD06Accident · No injuriesClosedCessna 150E · Chalamette, LASep 15, 1972 · N2590J · Substantial damage NTSB FTW73DRJ16Accident · No injuriesClosedBoeing A75N1 · Evelyn, LASep 13, 1972 · N9199R · Substantial damage NTSB FTW73FRD05Accident · No injuriesClosedBell 47J2A · Leeville, LASep 9, 1972 · N8431E · Substantial damage NTSB FTW73AF009Accident · 1 fatalClosedBeech F35 · Ruston, LASep 4, 1972 · N5048B · Destroyed NTSB FTW73DRJ14Accident · Minor injuriesClosedPiper PA-24 · West Monroe, LASep 2, 1972 · N6166P · Destroyed NTSB FTW73FRD04Accident · No injuriesClosedBell 47J-2A · Venice, LAAug 29, 1972 · N3092G · Substantial damage NTSB FTW73DRD03Accident · No injuriesClosedBeech B23 · Abita Sprgs, LAAug 26, 1972 · N4025T · Substantial damage NTSB FTW73DRJ10Accident · No injuriesClosedTaylorcraft BC12-D · Jones, LAAug 19, 1972 · N96770 · Substantial damage NTSB FTW73FRJ08Accident · No injuriesClosedPiper PA-25 · Holly Ridge, LAAug 15, 1972 · N4525Y · Substantial damage NTSB FTW73FRJ09Accident · 1 fatalClosedPiper PA-18 · Mangham, LAAug 11, 1972 · N9490D · Destroyed NTSB FTW73FRJ11Accident · No injuriesClosedCessna 150 · Natchitoches, LAAug 10, 1972 · N1630Q · 2 aircraft · Substantial damage NTSB FTW73FRD02Accident · No injuriesClosedS.N.I.A.S SA316B · St.Martinville, LAAug 8, 1972 · N5957 · Substantial damage NTSB FTW73DRD01Accident · No injuriesClosedCessna A185E · Jeanerette, LAAug 8, 1972 · N77AM · Substantial damage NTSB FTW73FRJ07Accident · No injuriesClosedChampion 7KCAB · Shreveport, LAAug 5, 1972 · N7600F · Substantial damage NTSB FTW73FRJ06Accident · 1 fatalClosedPiper PA-18 · Tallulah, LAAug 3, 1972 · N7465D · Destroyed NTSB FTW73FRJ05Accident · Serious injuriesClosedCessna U206 · Many, LAAug 2, 1972 · N3944G · Substantial damage NTSB FTW73AF006Accident · 2 fatalClosedCessna 150H · White Castle, LAAug 2, 1972 · N7089S · Destroyed NTSB FTW73IF005Incident · No injuriesClosedBoeing 727 · New Orleans, LAJul 26, 1972 · N4735 · Minor damage NTSB FTW73FRJ04Accident · No injuriesClosedPiper PA-25 · Alexandria, LAJul 17, 1972 · N4824Y · Substantial damage NTSB FTW73IF003Incident · Minor injuriesClosedBell 206A · Morgan City, LAJul 15, 1972 · N7944S · Minor damage NTSB FTW73FRJ03Accident · No injuriesClosedGrumman G-164A · Ferriday, LAJul 14, 1972 · N7355 · Substantial damage NTSB FTW73AF001Accident · 5 fatalClosedPiper PA-28 · Intrcoastl Cty, LAJul 4, 1972 · N8602W · Destroyed NTSB FTW72DRD39Accident · No injuriesClosedCessna 180H · Venice, LAJun 29, 1972 · N3461Y · Substantial damage NTSB FTW72AF087Accident · 2 fatalClosedBell 206B · Cameron, LAJun 28, 1972 · N1457W · Destroyed NTSB FTW72DRD38Accident · No injuriesClosedSnow S2C · Eunice, LAJun 26, 1972 · N1624S · Substantial damage NTSB FTW72DRJ31Accident · Serious injuriesClosedPiper PA-25 · Ferriday, LAJun 24, 1972 · N8719L · Destroyed NTSB FTW72DRD36Accident · No injuriesClosedGrumman G-164 · Welsh, LAJun 20, 1972 · N459RF · Substantial damage NTSB FTW72DRD35Accident · Minor injuriesClosedBoeing A75N1 · Elton, LAJun 20, 1972 · N59378 · Substantial damage NTSB FTW72AF086Accident · Minor injuriesClosedAlouette II SA318C · Venice, LAJun 20, 1972 · N6458 · Substantial damage NTSB FTW72DRD34Accident · No injuriesClosedPiper PA-22 · New Orleans, LAJun 17, 1972 · N5905D · Substantial damage NTSB FTW72DRD32Accident · No injuriesClosedCessna 206 · Lake Charles, LAJun 16, 1972 · N2515X · Substantial damage NTSB FTW72FRD30Accident · No injuriesClosedCessna 180 · Westwego, LAJun 10, 1972 · N2800T · Substantial damage NTSB FTW72DRJ30Accident · No injuriesClosedCessna 150 · Frierson, LAJun 7, 1972 · N6427G · Substantial damage NTSB FTW72AF083Accident · No injuriesClosedBeech 65-B80 · Baton Rouge, LAJun 5, 1972 · N284M · Substantial damage NTSB FTW72DRD28Accident · No injuriesClosedCessna 172 · Venice, LAMay 29, 1972 · N9114B · Substantial damage