Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 FTW70F0339Accident · Minor injuriesClosedCessna 177 · Berwick, LADec 27, 1969 · N29549 · Substantial damage NTSB FTW70D0340Accident · No injuriesClosedCessna 185 · Catahoula, LADec 25, 1969 · N4564F · Substantial damage NTSB FTW70A0043Accident · 4 fatalClosedPiper PA-23 · Norwood, LADec 19, 1969 · N4723P · Destroyed NTSB FTW70F0337Accident · No injuriesClosedAeronca 7AC · Pineville, LADec 16, 1969 · N2202E · Substantial damage NTSB FTW70A0041Accident · 1 fatalClosedChampion 7ECA · Jeanerette, LADec 12, 1969 · N1875G · Destroyed NTSB FTW70F0308Accident · No injuriesClosedCessna 150K · Shreveport, LANov 29, 1969 · N8418M · Substantial damage NTSB FTW70F0306Accident · Serious injuriesClosedPiper J-3 · Esterwood, LANov 25, 1969 · N1353M · Substantial damage NTSB FTW70F0314Accident · No injuriesClosedCessna 150 · Bell City, LANov 24, 1969 · N7224S · Substantial damage NTSB FTW70F0292Accident · Minor injuriesClosedCessna 180 · New Orleans, LANov 19, 1969 · N3470Y · Substantial damage NTSB FTW70F0305Accident · No injuriesClosedPiper PA-24 · Oak Grove, LANov 14, 1969 · N5328P · Substantial damage NTSB FTW70F0304Accident · Serious injuriesClosedPiper PA-28 · Slidell, LANov 11, 1969 · N5718F · Destroyed NTSB FTW70F0300Accident · Minor injuriesClosedCessna 185 · Morgan City, LANov 11, 1969 · N32S · Substantial damage NTSB FTW70F0296Accident · No injuriesClosedBell 206A · New Iberia, LAOct 31, 1969 · N4043G · Substantial damage NTSB FTW70F0283Accident · Minor injuriesClosedBell 47J · Grand Isle, LAOct 31, 1969 · N5153B · Substantial damage NTSB FTW70F0281Accident · Minor injuriesClosedBeech P35 · Oakdale, LAOct 26, 1969 · N9640Y · Substantial damage NTSB FTW70F0249Accident · No injuriesClosedBell 206A · Morgan City, LAOct 7, 1969 · N292FW · Substantial damage NTSB FTW70F0265Accident · Minor injuriesClosedCessna 177 · Georgetown, LAOct 2, 1969 · N2928X · Destroyed NTSB FTW70A0024Accident · Minor injuriesClosedCessna 180 · Venice, LASep 30, 1969 · N5019E · Substantial damage NTSB FTW70A0023Accident · 1 fatalClosedAeronca 0-58A · Farmerville, LASep 28, 1969 · N64906 · Destroyed NTSB FTW70A0021Accident · No injuriesClosedBoeing 727 · New Orleans, LASep 26, 1969 · N8173G · No damage NTSB FTW70A0019Accident · 1 fatalClosedCessna 172G · Morgan City, LASep 19, 1969 · N4620L · Destroyed NTSB FTW70D0216Accident · No injuriesClosedCessna 150 · Eunice, LASep 18, 1969 · N2089Z · Substantial damage NTSB FTW70D0208Accident · No injuriesClosedCessna 180G · Oaklawn, LASep 17, 1969 · N4744U · Substantial damage NTSB FTW70D0207Accident · No injuriesClosedGrumman G-164A · Ferriday, LASep 15, 1969 · N5345 · Substantial damage NTSB FTW70A0016Accident · No injuriesClosedBell 47G-4A · Pecan Island, LASep 13, 1969 · N4708R · Substantial damage NTSB FTW70A0014Accident · No injuriesClosedBell 47G-2 · Buras, LASep 8, 1969 · N955 · Substantial damage NTSB FTW70F0195Accident · Minor injuriesClosedStinson 108-1 · De Quincy, LASep 7, 1969 · N8912K · Destroyed NTSB FTW70F0166Accident · No injuriesClosedGrumman G164 · Deridder, LASep 6, 1969 · N608U · Substantial damage NTSB FTW70D0173Accident · No injuriesClosedPiper PA-25 · Duson, LASep 1, 1969 · N7765Z · Substantial damage NTSB FTW70D0189Accident · No injuriesClosedCessna 180G · Leeville, LAAug 29, 1969 · N4631U · Substantial damage NTSB FTW70F0160Accident · No injuriesClosedCessna T-50 · Ville Platte, LAAug 27, 1969 · N5621Z · Substantial damage NTSB FTW70D0176Accident · Minor injuriesClosedGrumman G-164 · Jeanerette, LAAug 20, 1969 · N466RF · Substantial damage NTSB FTW70A0011Accident · 4 fatalClosedBeech 35-A33 · New Orleans, LAAug 19, 1969 · N623B · Destroyed NTSB FTW70F0141Accident · 1 fatalClosedBoeing B75N1 · Lake Charles, LAAug 18, 1969 · N75263 · Destroyed NTSB FTW70D0163Accident · No injuriesClosedBoeing A75N1 · Lettsworth, LAAug 15, 1969 · N59031 · Substantial damage NTSB FTW70D0154Accident · Minor injuriesClosedPiper PA-18A · Houma, LAAug 10, 1969 · N7298D · Substantial damage NTSB FTW70F0147Accident · Serious injuriesClosedPiper PA-18A · Hayes, LAAug 9, 1969 · N2981Z · Destroyed NTSB FTW70D0118Accident · No injuriesClosedBell 47G-4A · Morgan City, LAAug 7, 1969 · N7818S · Substantial damage NTSB FTW70F0144Accident · Serious injuriesClosedAero Comdr S-2D · Lockport, LAAug 6, 1969 · N1711S · Destroyed NTSB FTW70F0168Accident · No injuriesClosedCessna 185 · Delacroix, LAAug 5, 1969 · N5842T · Substantial damage NTSB FTW70D0117Accident · Minor injuriesClosedPiper PA-18 · Cameron, LAAug 1, 1969 · N4119Z · Substantial damage NTSB FTW70D0134Accident · No injuriesClosedGrumman G-164A · Waterproof, LAJul 30, 1969 · N981X · Destroyed NTSB FTW70F0132Accident · No injuriesClosedBell 206A · Venice, LAJul 27, 1969 · N4059G · Destroyed NTSB FTW70A0003Accident · 1 fatalClosedPiper PA-22 · Sulphur, LAJul 22, 1969 · N3583A · Destroyed NTSB FTW70D0106Accident · Minor injuriesClosedCessna 150J · Florien, LAJul 11, 1969 · N51384 · Substantial damage NTSB FTW70F0129Accident · Minor injuriesClosedPiper PA-28 · St.Martinville, LAJul 10, 1969 · N4916L · Substantial damage NTSB FTW70F0077Accident · No injuriesClosedPiper PA-12 · Cottonport, LAJul 3, 1969 · N7903H · Destroyed NTSB FTW69A0087Accident · 2 fatalClosedPiper J3C-65 · Gurley, LAJun 28, 1969 · N3665K · Destroyed NTSB FTW70D0038Accident · No injuriesClosedCessna 182 · St Francisvile, LAJun 26, 1969 · N2678F · Substantial damage NTSB FTW70F0022Accident · 1 fatalClosedBell 47D1 · Livingston, LAJun 24, 1969 · N3111G · Destroyed