NTSB investigations, 1976, LA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1976
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") = 1976 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 FTW77FRD05Accident · No injuriesClosedGrumman G-164A · Welsh, LANTSB FTW77FRD04Accident · Serious injuriesClosedPiper PA-22 · Port Sulphur, LANTSB FTW77DA021Accident · No injuriesClosedBell 206B · Morgan City, LANTSB FTW77FRJ02Accident · Minor injuriesClosedCessna 182 · Arcadia, LANTSB FTW77FA016Accident · 1 fatalClosedCessna 182A · Boutte, LANTSB FTW77FRD02Accident · No injuriesClosedCessna 180J · Lafayette, LANTSB FTW77DRJ01Accident · No injuriesClosedCessna 210 · Arcadia, LANTSB FTW77FA008Accident · 2 fatalClosedCessna 182L · Shaw, LANTSB FTW77FRD01Accident · No injuriesClosedGrumman G-164 · Maurice, LANTSB FTW77FA002Accident · 3 fatalClosedMooney M20C · Houma, LANTSB FTW76DRD68Accident · Serious injuriesClosedCessna A185F · Patterson, LANTSB FTW76AF125Accident · 1 fatalClosedPiper PA-12 · Greenwood, LANTSB FTW76AF123Accident · 4 fatalClosedPiper PA-32 · Oak Ridge, LANTSB FTW76DRJ48Accident · Minor injuriesClosedGrumman G-164A · Bonita, LANTSB FTW76FRJ47Accident · No injuriesClosedGrumman G-164B · Crowville, LANTSB FTW76DRD67Accident · No injuriesClosedCessna 180 · Napoleonville, LANTSB FTW76FRJ45Accident · 1 fatalClosedSnow 600S2R · Ferriday, LANTSB FTW76FRJ43Accident · Serious injuriesClosedCessna A188B · Monroe, LANTSB FTW76FRD66Accident · No injuriesClosedPiper PA-25 · Port Barre, LANTSB FTW76FRJ44Accident · 1 fatalClosedPiper PA-25 · W.Monroe, LANTSB FTW76FRD65Accident · No injuriesClosedCessna A185F · Lafayette, LANTSB FTW76FRD64Accident · No injuriesClosedCessna 172M · Lake Charles, LANTSB FTW76DRD62Accident · Minor injuriesClosedPiper J-3 · Lake Charles, LANTSB FTW76FRD63Accident · No injuriesClosedStinson 108 · Baton Rouge, LANTSB FTW76FRD61Accident · No injuriesClosedCessna 310F · Lafayette, LANTSB FTW76DRJ41Accident · No injuriesClosedPiper PA-25 · Pioneer, LANTSB FTW76FRD60Accident · Serious injuriesClosedCessna 180 · Gretna, LANTSB FTW76DRJ42Accident · No injuriesClosedGrumman G-164A · Lake Providnce, LANTSB FTW76FRD59Accident · No injuriesClosedCessna A185F · Lafayette, LANTSB FTW76FRJ40Accident · Serious injuriesClosedBoeing E75N1 · Tallulah, LANTSB FTW76FRJ39Accident · Minor injuriesClosedGrumman G-164A · Delhi, LANTSB FTW76AF113Accident · 1 fatalClosedCessna 172 · Baker, LANTSB FTW76FRJ38Accident · Minor injuriesClosedBoeing E75N1 · Epps, LANTSB FTW76FRD58Accident · Serious injuriesClosedHughes 369 · Intrcostl City, LANTSB FTW76DRJ36Accident · No injuriesClosedCallair A-9 · Plain Dealing, LANTSB FTW76AF111Accident · No injuriesClosedCessna 180 · Houma, LANTSB FTW76FRD56Accident · Serious injuriesClosedGrum Amer AA1-B · Eunice, LANTSB FTW76DRD55Accident · No injuriesClosedGrumman G-164A · Thibodaux, LANTSB FTW76AF110Accident · No injuriesClosedBolkow BO-105 · Rockport, LANTSB FTW76DRJ34Accident · No injuriesClosedCessna 150M · Oil City, LANTSB FTW76DRD57Accident · No injuriesClosedCessna 180 · Baton Rouge, LANTSB FTW76DRJ32Accident · No injuriesClosedPiper PA-25 · Winnsboro, LANTSB FTW76DRJ31Accident · No injuriesClosedPiper PA-18 · Ruston, LANTSB FTW76FRJ30Accident · Serious injuriesClosedPiper PA-25 · Gilbert, LANTSB FTW76AF109Accident · Serious injuriesClosedBell 206B · Berwick, LANTSB FTW76FRD54Accident · Serious injuriesClosedGrumman G-164 · Maringouin, LANTSB FTW76DRJ29Accident · No injuriesClosedPiper PA-18 · Oak Grove, LANTSB FTW76FRD53Accident · Serious injuriesClosedGrumman G-164A · Crowley, LANTSB FTW76AF106Accident · No injuriesClosedCessna 180 · Golden Meadow, LANTSB FTW76DRD51Accident · No injuriesClosedCessna 180 · Bayon Pigeon, LA