Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 FTW78DRD12Accident · No injuriesClosedHughes 369HS · Harahan, LADec 31, 1977 · N9104F · Substantial damage NTSB FTW78DA020Accident · No injuriesClosedCessna 180 · Marsh Island, LADec 23, 1977 · N9047M · Substantial damage NTSB FTW78FA016Accident · 17 fatalClosedS.N.I.A.S. SA330J · Intracstl City, LADec 8, 1977 · N4730S · Destroyed NTSB FTW78FRD11Accident · Serious injuriesClosedCessna 305A · Crowley, LADec 6, 1977 · N5176G · Substantial damage NTSB FTW78DRD10Accident · Minor injuriesClosedCessna 182P · White Castle, LADec 1, 1977 · N78152 · Substantial damage NTSB FTW78FRJ08Accident · 1 fatalClosedPiper J-3 · Farmerville, LANov 27, 1977 · N88338 · Destroyed NTSB FTW78DRD09Accident · Minor injuriesClosedCessna 180 · Venice, LANov 16, 1977 · N64467 · Substantial damage NTSB FTW78DRJ07Accident · No injuriesClosedCessna 182 · Shreveport, LANov 13, 1977 · N5846B · Substantial damage NTSB FTW78DRD08Accident · No injuriesClosedCessna 210 · New Orleans, LANov 13, 1977 · N732CS · Substantial damage NTSB FTW78FA011Accident · 3 fatalClosedN.American NA-265 · New Orleans, LANov 7, 1977 · N77AP · Destroyed NTSB FTW78DRD07Accident · Minor injuriesClosedCessna A188B · Le Blance, LANov 7, 1977 · N9313R · Destroyed NTSB FTW78FRJ05Accident · No injuriesClosedCessna 172 · Ruston, LANov 2, 1977 · N7123T · Substantial damage NTSB FTW78DRJ06Accident · No injuriesClosedPiper J3C · Pineville, LANov 2, 1977 · N71022 · Substantial damage NTSB FTW78DRJ04Accident · No injuriesClosedCessna 150 · Crowville, LAOct 26, 1977 · N22041 · Substantial damage NTSB FTW78FA005Accident · 1 fatalClosedBeech M35 · Dubach, LAOct 23, 1977 · N9840R · Destroyed NTSB FTW78DRD06Accident · No injuriesClosedPiper J3C-65 · Baton Rouge, LAOct 23, 1977 · N70273 · Substantial damage NTSB FTW78DRJ03Accident · No injuriesClosedBoeing 75N1 · Shreveport, LAOct 22, 1977 · N48579 · Substantial damage NTSB UNK78X0102Accident · No injuriesClosedBeech C24R · Freemason Isl, LAOct 21, 1977 · N24016 · Destroyed NTSB FTW78DRD03Accident · No injuriesClosedGrumman AA-5 · Lafayette, LAOct 12, 1977 · N5421L · Substantial damage NTSB FTW78DRJ02Accident · No injuriesClosedCessna 182A · Ruston, LAOct 11, 1977 · N38940 · Substantial damage NTSB FTW78DRJ01Accident · No injuriesClosedCessna A188B · Mansfield, LAOct 11, 1977 · N6380G · Substantial damage NTSB FTW78FA003Accident · 2 fatalClosedBell 206B · Grand Chenier, LAOct 10, 1977 · N157AL · Destroyed NTSB FTW78DRD04Accident · Minor injuriesClosedBolkow BO-105 · Intracoastal, LAOct 10, 1977 · N90760 · Destroyed NTSB FTW78FRD02Accident · No injuriesClosedCessna A188B · De Ridder, LAOct 4, 1977 · N8125G · Substantial damage NTSB FTW78DRD01Accident · Minor injuriesClosedBell 47G2A1 · Kenner, LAOct 1, 1977 · N3075G · Destroyed NTSB FTW77FRJ25Accident · No injuriesClosedAeronca 7AC · Jonesville, LASep 29, 1977 · N82375 · Destroyed NTSB FTW77FRJ24Accident · No injuriesClosedCessna 175A · Gilliam, LASep 28, 1977 · N6848E · Substantial damage NTSB FTW77FRD53Accident · No injuriesClosedPiper PA-28 · Leonville, LASep 27, 1977 · N1041Q · Substantial damage NTSB FTW77FRD52Accident · Minor injuriesClosedCessna 337A · Gonzales, LASep 24, 1977 · N90BD · Substantial damage NTSB FTW77DRJ76Accident · No injuriesClosedGrumman G-164A · Natchitoches, LASep 24, 1977 · N8623H · Destroyed NTSB FTW77FRD51Accident · No injuriesClosedLear 24 · Baton Rouge, LASep 16, 1977 · N56LS · Substantial damage NTSB FTW77DRD50Accident · No injuriesClosedCessna 180F · Houma, LASep 16, 1977 · N91476 · Substantial damage NTSB FTW77FRJ23Accident · 1 fatalClosedCessna 150M · Oil City, LASep 15, 1977 · N6199K · Destroyed NTSB FTW77DRJ22Accident · No injuriesClosedGrumman G-164A · Transylvania, LASep 2, 1977 · N9375 · Substantial damage NTSB FTW77FRJ20Accident · No injuriesClosedGrumman G-164A · Gilliam, LAAug 30, 1977 · N959X · Substantial damage NTSB FTW77DRD49Accident · No injuriesClosedGrumman G-164A · Grant, LAAug 28, 1977 · N9512 · Substantial damage NTSB FTW77FRD45Accident · Minor injuriesClosedBell 206B · Venice, LAAug 26, 1977 · N90151 · Destroyed NTSB FTW77DRJ21Accident · Serious injuriesClosedMurrayair MA-1 · Coushatta, LAAug 26, 1977 · N1020Y · Destroyed NTSB FTW77FRD48Accident · No injuriesClosedCessna 210M · Eunice, LAAug 25, 1977 · N732ZE · Substantial damage NTSB FTW77FRO44Accident · No injuriesClosedGrumman G-164A · Washington, LAAug 24, 1977 · N85124 · Substantial damage NTSB FTW77DRD47Accident · Minor injuriesClosedBell 47G-4A · Lafayette, LAAug 24, 1977 · N4004G · Destroyed NTSB FTW77FRJ19Accident · Serious injuriesClosedCessna 188B · Mer Rouge, LAAug 23, 1977 · N91432 · Destroyed NTSB FTW77FRD24Accident · Serious injuriesClosedGrumman G-164A · Ville Platte, LAAug 21, 1977 · N5264 · Destroyed NTSB FTW77FRJ17Accident · No injuriesClosedCessna A188B · Oak Ridge, LAAug 20, 1977 · N9602G · Substantial damage NTSB FTW77FA070Accident · 1 fatalClosedBeech V35B · Ida, LAAug 18, 1977 · N1605W · Destroyed NTSB FTW77DRJ18Accident · No injuriesClosedPiper PA-25 · Jonesville, LAAug 15, 1977 · N7470Z · Substantial damage NTSB FTW77FRJ16Accident · 1 fatalClosedGrumman G-164A · Waterproof, LAAug 8, 1977 · N5417 · Destroyed NTSB FTW77FRJ15Accident · Serious injuriesClosedLuscombe 8E · Shreveport, LAAug 6, 1977 · N2480K · Destroyed NTSB FTW77FRD43Accident · No injuriesClosedGrumman G-164 · Maringouin, LAAug 1, 1977 · N462RF · Destroyed NTSB FTW77FRD42Accident · Serious injuriesClosedPiper J3-C65 · Beaux Bridge, LAJul 31, 1977 · N71024 · Destroyed