Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 FTW67D0397Accident · No injuriesClosedPiper PA-28 · Bogalusa, LADec 27, 1966 · N7866W · Substantial damage NTSB FTW67F0376Accident · Serious injuriesClosedPiper PA-25 · Moreauville, LADec 24, 1966 · N6642Z · Destroyed NTSB FTW67D0394Accident · No injuriesClosedCessna 172G · Florien, LADec 24, 1966 · N4477L · Substantial damage NTSB FTW67F0360Accident · No injuriesClosedDehavilland 1142X · New Orleans, LADec 18, 1966 · N782R · Substantial damage NTSB FTW67A0065Accident · No injuriesClosedBell 204-B · Morgan City, LADec 18, 1966 · N8540F · Substantial damage NTSB FTW67A0063Accident · 1 fatalClosedCessna 150 · New Orleans, LADec 8, 1966 · 7Q-YFC · Destroyed NTSB FTW67A0059Accident · 2 fatalClosedCessna 175 · Alexandria, LADec 3, 1966 · N8185T · Destroyed NTSB FTW67D0321Accident · No injuriesClosedCessna 310" · Houma, LANov 30, 1966 · N6686B · Substantial damage NTSB FTW67D0315Accident · No injuriesClosedCessna 180 · Venice, LANov 16, 1966 · N5104E · Substantial damage NTSB FTW67D0314Accident · No injuriesClosedPiper PA-23 · Eunice, LANov 13, 1966 · N6209Y · Substantial damage NTSB FTW67A0050Accident · Serious injuriesClosedHughes 269B · New Orleans, LANov 9, 1966 · N9334F · Destroyed NTSB FTW67A0046Accident · Minor injuriesClosedDouglas DC-8 · New Orleans, LAOct 22, 1966 · N808E · Substantial damage NTSB FTW67D0248Accident · No injuriesClosedPiper PA-32 · Freemason Isl., LAOct 15, 1966 · N3520W · Substantial damage NTSB FTW67F0261Accident · No injuriesClosedAero Cmdr 520 · Houma, LAOct 14, 1966 · N4170B · Substantial damage NTSB FTW67D0288Accident · No injuriesClosedCessna 210A · New Orleans, LAOct 14, 1966 · N6685X · Substantial damage NTSB FTW67F0226Accident · No injuriesClosedLear Jet 23 · New Orleans, LAOct 10, 1966 · N242WT · Substantial damage NTSB FTW67A0043Accident · 11 fatalClosedBell 204B · Morgan City, LAOct 8, 1966 · N1187W · Destroyed NTSB FTW67F0307Accident · No injuriesClosedCessna 180 · Bayou Sorrel, LASep 29, 1966 · N3237D · Destroyed NTSB FTW67D0272Accident · No injuriesClosedBoeing A75 · Monroe, LASep 24, 1966 · N141J · Substantial damage NTSB FTW67D0219Accident · No injuriesClosedCessna 172 · Hammond, LASep 23, 1966 · N5740A · Substantial damage NTSB FTW67A0039Accident · 1 fatalClosedPiper J-3 · Kaplan, LASep 23, 1966 · N98571 · Destroyed NTSB FTW67A0038Accident · No injuriesClosedBell 47J · Leeville, LASep 23, 1966 · N6736D · Substantial damage NTSB FTW67D0255Accident · No injuriesClosedMooney M21 · Winnfield, LASep 22, 1966 · N6872U · Substantial damage NTSB FTW67A0037Accident · No injuriesClosedBell 47J-2A · Leeville, LASep 22, 1966 · N3092G · Substantial damage NTSB FTW67F0235Accident · No injuriesClosedErcoupe 415-C · Shreveport, LASep 21, 1966 · N99649 · Substantial damage NTSB FTW67A0035Accident · Serious injuriesClosedSikorsky S-62A · Morgan City, LASep 19, 1966 · N324Y · Destroyed NTSB FTW67F0253Accident · No injuriesClosedMooney M-18C · Monroe, LASep 18, 1966 · N4051 · Substantial damage NTSB FTW67D0204Accident · No injuriesClosedCessna 172 · Boyce, LASep 18, 1966 · N8233U · Substantial damage NTSB FTW67A0036Accident · 1 fatalClosedLuscombe 8A · Holly Ridge, LASep 18, 1966 · N25380 · Destroyed NTSB FTW67D0252Accident · No injuriesClosedPiper PA-22 · Cloutierville, LASep 12, 1966 · N4964Z · Substantial damage NTSB FTW67D0201Accident · No injuriesClosedCessna 140A · Springhill, LASep 11, 1966 · N5317C · Substantial damage NTSB FTW67F0196Accident · Minor injuriesClosedStinson 108 · St.Francisvlle, LASep 4, 1966 · N97163 · Substantial damage NTSB FTW67A0029Accident · 1 fatalClosedPiper J-3 · Morgan City, LASep 3, 1966 · N30746 · Destroyed NTSB FTW67D0192Accident · Minor injuriesClosedCessna 150 · Slaughter, LASep 1, 1966 · N6585F · Substantial damage NTSB FTW67F0185Accident · No injuriesClosedCessna 140A · Sikes, LAAug 25, 1966 · N5330C · Substantial damage NTSB FTW67D0137Accident · No injuriesClosedCessna 180 · Westwego, LAAug 18, 1966 · N2786X · Substantial damage NTSB FTW67D0138Accident · No injuriesClosedCessna 150 · Freemason Isle, LAAug 16, 1966 · N8459G · Substantial damage NTSB FTW67F0159Accident · No injuriesClosedPiper PA-18 · Vick, LAAug 11, 1966 · N3949Z · Substantial damage NTSB FTW67F0148Accident · Serious injuriesClosedCessna 150 · Gueydan, LAAug 7, 1966 · N6412Z · Destroyed NTSB FTW67F0157Accident · No injuriesClosedPiper PA-18 · Vick, LAAug 4, 1966 · N5390Y · Destroyed NTSB FTW67D0131Accident · No injuriesClosedPiper PA-18 · La Place, LAAug 2, 1966 · N1158C · Substantial damage NTSB FTW67F0124Accident · No injuriesClosedBeech 95-B55 · Shreveport, LAJul 26, 1966 · N275D · Substantial damage NTSB FTW67F0127Accident · Serious injuriesClosedAeronca 7AC · Lake Providenc, LAJul 25, 1966 · N82630 · Substantial damage NTSB FTW67A0018Accident · 2 fatalClosedPiper PA-18 · Cameron, LAJul 25, 1966 · N4101Z · 2 aircraft · Destroyed NTSB FTW67F0107Accident · No injuriesClosedBeech B35 · New Orleans, LAJul 22, 1966 · N5246C · Substantial damage NTSB FTW67F0096Accident · No injuriesClosedCessna 150F · Bogalusa, LAJul 16, 1966 · N8457G · Substantial damage NTSB FTW67D0070Accident · No injuriesClosedCessna 180 · St Martin, LAJul 14, 1966 · N9541B · Substantial damage NTSB FTW66F0094Accident · No injuriesClosedBoeing D75N1 · Tallulah, LAJul 14, 1966 · N75043 · Substantial damage NTSB FTW67D0067Accident · No injuriesClosedCessna 180 · Venice, LAJul 12, 1966 · N9227T · Substantial damage NTSB FTW67D0067Accident · Minor injuriesClosedCessna 185 · Houma, LAJul 10, 1966 · N1690Z · Substantial damage