NTSB investigations, 1964, 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.
Cases per year
| 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
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\") = 1964
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") = 1964 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 UNK65X1172Accident · No injuriesClosedPiper PA-24 · Opelousas, LANTSB UNK65X1154Accident · No injuriesClosedCessna 172 · Galiano, LANTSB UNK65X1134Accident · 1 fatalClosedPiper PA15 · Denham Springs, LANTSB UNK65X1127Accident · No injuriesClosedBeechraft T34A · Jonesboro, LANTSB UNK65X1123Accident · No injuriesClosedBell 47J · Intracoastal C, LANTSB UNK65X1048Accident · No injuriesClosedBeechcraft 35-33 · Mansfield, LANTSB UNK65X1023Accident · No injuriesClosedCessna 310B · Shreveport, LANTSB UNK65X0996Accident · Minor injuriesClosedCessna 185 · Buras, LANTSB UNK65X0950Accident · 3 fatalClosedBell 47J2 · Venice, LANTSB UNK65X0942Accident · No injuriesClosedCessna 180 · Franklin, LANTSB UNK65X0813Accident · No injuriesClosedCurtiss C-46 · Baton Rouge, LANTSB UNK65X0811Accident · Minor injuriesClosedAeronca 11AC · Benton, LANTSB UNK65X0800Accident · No injuriesClosedBellanca 260A · Westwego, LANTSB UNK65X0730Accident · 1 fatalClosedCessna 172 · Caddo Lake, LANTSB UNK65X0649Accident · Serious injuriesClosedCessna 180 · Venice, LANTSB UNK65X0428Accident · Minor injuriesClosedCessna 170A · Freemason Is, LANTSB UNK65X0361Accident · Minor injuriesClosedCessna 172 · Covington, LANTSB UNK65X0173Accident · Minor injuriesClosedNardi FN333 · Chandeleur Is, LANTSB UNK65X0161Accident · No injuriesClosedCessna 210 · Crowley, LANTSB UNK64X4204Incident · No injuriesClosedDouglas DC-6 · New Orleans, LANTSB UNK64X4073Accident · No injuriesClosedHoward DGA15P · Deridder, LANTSB UNK64X3983Accident · 1 fatalClosedPiper PA-18 · Rayville, LANTSB UNK64X3838Accident · No injuriesClosedCessna 180 · Houma, LANTSB UNK64X3748Accident · No injuriesClosedBeechcraft H35 · Monroe, LANTSB UNK64X3737Accident · 3 fatalClosedBeechcraft 35-33 · Vinton, LANTSB UNK64X3699Accident · No injuriesClosedBoeing A75N1 · Whitteville, LANTSB UNK64X3691Accident · No injuriesClosedCessna 120 · Pride, LANTSB UNK64X3687Accident · No injuriesClosedFairchild 24 · Deridder, LANTSB UNK64X3650Accident · No injuriesClosedAeronca 7AC · Covington, LANTSB UNK64X3648Accident · No injuriesClosedAeronca 7AC · Slidell, LANTSB UNK64X3632Accident · No injuriesClosedHughes 269A · New Orleans, LANTSB UNK64X3622Accident · Minor injuriesClosedBoeing A75 · Monroe, LANTSB UNK64X3593Accident · Serious injuriesClosedPiper PA12 · Timbalier Is, LANTSB UNK64X3571Accident · No injuriesClosedCessna 150 · Lacombe, LANTSB UNK64X3555Accident · No injuriesClosedPiper PA25 · Columbia, LANTSB UNK64X3534Accident · No injuriesClosedPiper PA24 · Baton Rouge, LANTSB UNK64X3530Accident · No injuriesClosedGrumman G164 · Tallulah, LANTSB UNK64X3510Accident · No injuriesClosedCessna 185 · Cypremort Pt, LANTSB UNK64X3470Accident · No injuriesClosedBeechcraft D45 · New Orleans, LANTSB UNK64X3446Accident · No injuriesClosedPiper PA18A · Bunkie, LANTSB UNK64X3430Accident · No injuriesClosedBoeing A75N1 · Raceland, LANTSB UNK64X3387Accident · No injuriesClosedBoeing A75N1 · Thibodaux, LANTSB UNK64X3377Accident · No injuriesClosedHawker MK11 · Houma, LANTSB UNK64X3373Accident · No injuriesClosedBoeing B75N1 · St James, LANTSB UNK64X3351Accident · Minor injuriesClosedBoeing A-75 · Vacherie, LANTSB UNK64X3336Accident · Minor injuriesClosedSikorsky S62A · Leesville, LANTSB UNK64X3318Accident · Minor injuriesClosedPiper PA22 · Thibodaux, LANTSB UNK64X3168Accident · No injuriesClosedTaylorcraft DC065 · Shreveport, LANTSB UNK64X3132Accident · Minor injuriesClosedPiper PA18A · Pioneer, LANTSB UNK64X3126Accident · Serious injuriesClosedBell 47G2 · Cameron, LA