Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 FTW66F0473Accident · No injuriesClosedBeechcraft AT-11 · Monroe, LADec 29, 1965 · N556T · Substantial damage NTSB FTW66F0461Accident · Minor injuriesClosedCessna 150E · Florriessant, LADec 24, 1965 · N3059J · Substantial damage NTSB FTW66D0451Accident · No injuriesClosedCessna 310D · Thornwell, LADec 20, 1965 · N6899T · Substantial damage NTSB FTW66F0466Accident · Serious injuriesClosedPiper PA-32 · Alexandria, LADec 15, 1965 · N3341W · Destroyed NTSB FTW66F0414Accident · No injuriesClosedCessna 150 · Shreveport, LADec 12, 1965 · N8897S · Substantial damage NTSB FTW66F0413Accident · No injuriesClosedPiper PA-24 · Natchitoches, LADec 8, 1965 · N6485P · Substantial damage NTSB FTW66F0412Accident · No injuriesClosedBeechcraft D95A · New Orleans, LADec 3, 1965 · N8965M · Substantial damage NTSB FTW66F0400Accident · No injuriesClosedBeechcraft D35 · Shreveport, LANov 25, 1965 · N2162D · Substantial damage NTSB FTW66A0046Accident · No injuriesClosedBell 47-J2A · Empire, LANov 15, 1965 · N3092G · Substantial damage NTSB FTW66F0379Accident · No injuriesClosedCessna 210D · New Orleans, LANov 13, 1965 · N3926Y · Substantial damage NTSB FTW66D0407Accident · No injuriesClosedPiper PA-18 · Timbalier Bay, LANov 13, 1965 · N3690P · Substantial damage NTSB FTW66F0376Accident · No injuriesClosedPiper PA-28 · Lafayette, LANov 5, 1965 · N7000W · Substantial damage NTSB FTW66F0360Accident · No injuriesClosedMooney M20E · Shreveport, LANov 1, 1965 · N6688R · Substantial damage NTSB FTW66F0405Accident · Serious injuriesClosedPiper PA-22 · Jennings, LAOct 29, 1965 · N6912B · Destroyed NTSB FTW66D0347Accident · No injuriesClosedAeronca 7AC · Tallulah, LAOct 27, 1965 · N83837 · Substantial damage NTSB FTW66A0037Accident · No injuriesClosedBell CHG2 · Vivian, LAOct 15, 1965 · N5235N · Substantial damage NTSB FTW66F0351Accident · No injuriesClosedBeechcraft 95-A55 · Alexandria, LAOct 8, 1965 · N1532Z · Substantial damage NTSB FTW66F0384Accident · No injuriesClosedCessna 172 · Tallulah, LASep 30, 1965 · N7895U · Substantial damage NTSB FTW66D0324Accident · No injuriesClosedCessna 185 · Baton Rouge, LASep 25, 1965 · N5885T · Substantial damage NTSB FTW66F0312Accident · Serious injuriesClosedCessna 150 · Westwego, LASep 23, 1965 · N4323U · Substantial damage NTSB FTW66D0323Accident · No injuriesClosedBeechcraft M-23 · Afton, LASep 20, 1965 · N3551R · Substantial damage NTSB FTW66D0322Accident · No injuriesClosedCessna 172 · New Orleans, LASep 19, 1965 · N1803Y · Substantial damage NTSB FTW66D0311Accident · No injuriesClosedPiper PA-18 · Slidell, LASep 16, 1965 · N7187Z · Substantial damage NTSB FTW66F0286Accident · No injuriesClosedChampion 7GC · Shreveport, LASep 8, 1965 · N8523E · Substantial damage NTSB FTW66F0479Accident · Serious injuriesClosedAeronca 11AC · Schriever, LASep 7, 1965 · N9049E · Substantial damage NTSB FTW66F0278Accident · No injuriesClosedCessna 195 · Bossier City, LASep 7, 1965 · N7807B · Destroyed NTSB FTW66F0253Accident · 1 fatalClosedPiper PA-25 · Bonita, LAAug 31, 1965 · N7281Z · 2 aircraft · Substantial damage NTSB FTW66D0272Accident · No injuriesClosedCessna 172 · De Quincy, LAAug 26, 1965 · N5621A · Substantial damage NTSB FTW66A0023Accident · 1 fatalClosedPiper PA-18A · Rayville, LAAug 26, 1965 · N4074Z · Destroyed NTSB FTW66F0247Accident · No injuriesClosedPiper PA-25 · Newellton, LAAug 20, 1965 · N6656Z · Substantial damage NTSB FTW66F0226Accident · No injuriesClosedBeechcraft 35 · Shreveport, LAAug 20, 1965 · N3105V · Substantial damage NTSB FTW66F0200Accident · No injuriesClosedPiper PA-25 · Sterlington, LAAug 18, 1965 · N7267Z · Substantial damage NTSB FTW66F0246Accident · No injuriesClosedGrumman G-164 · Maringouin, LAAug 17, 1965 · N463RF · Substantial damage NTSB FTW66A0018Accident · No injuriesClosedBell 47G4 · Intracostl Cty, LAAug 15, 1965 · N73263 · Substantial damage NTSB FTW66D0224Accident · No injuriesClosedCessna 210 · Baton Rouge, LAAug 14, 1965 · N2326F · Substantial damage NTSB FTW66F0198Accident · No injuriesClosedGrumman G-164 · Welsh, LAAug 11, 1965 · N10275 · Substantial damage NTSB FTW66F0195Accident · Serious injuriesClosedPiper PA-18A · Franklin, LAAug 9, 1965 · N6999D · Substantial damage NTSB FTW66F0192Accident · Minor injuriesClosedPiper PA-18A · Waterproof, LAAug 8, 1965 · N1629A · Destroyed NTSB FTW66F0265Accident · No injuriesClosedTaylorcraft L-2M · Covington, LAAug 7, 1965 · N50084 · Substantial damage NTSB FTW66F0170Accident · No injuriesClosedGrumman G-164 · Lakeland, LAAug 7, 1965 · N463RF · Substantial damage NTSB FTW66F0264Accident · No injuriesClosedBoeing A-75N1 · Houma, LAAug 5, 1965 · N1559M · Substantial damage NTSB FTW66F0167Accident · No injuriesClosedPiper PA-18 · Oak Grove, LAJul 25, 1965 · N8059C · Substantial damage NTSB FTW66F0182Accident · No injuriesClosedPiper PA-24 · New Orleans, LAJul 22, 1965 · N8188P · Substantial damage NTSB FTW66A0006Accident · 4 fatalClosedPiper PA-24 · Lake Charles, LAJul 22, 1965 · N7769P · Destroyed NTSB FTW66F0236Accident · Serious injuriesClosedBoeing B75 · Bosco, LAJul 20, 1965 · N5242N · Substantial damage NTSB FTW66F0138Accident · Serious injuriesClosedBoeing A-75 · Sulphur, LAJul 16, 1965 · N75227 · Destroyed NTSB FTW66D0157Accident · No injuriesClosedBeechcraft T-34A · Baton Rouge, LAJul 15, 1965 · N3889C · Substantial damage NTSB FTW66F0130Accident · No injuriesClosedPiper PA-25 · Newellton, LAJul 14, 1965 · N7175Z · Substantial damage NTSB FTW66F0156Accident · No injuriesClosedLuscombe 8A · Westwego, LAJul 13, 1965 · N71267 · Substantial damage NTSB FTW66F0129Accident · Minor injuriesClosedCessna 210-5A · Sicily Island, LAJul 13, 1965 · N4832U · Substantial damage