Skip to content

NTSB investigations, LA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, newest first

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 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 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 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 FTW77FA016Accident · 1 fatalClosedCessna 182A · Boutte, LANov 23, 1976 · N6304B · Destroyed NTSB FTW77FRD02Accident · No injuriesClosedCessna 180J · Lafayette, LANov 21, 1976 · N46090 · Substantial damage NTSB FTW77DRJ01Accident · No injuriesClosedCessna 210 · Arcadia, LANov 12, 1976 · N93022 · Substantial damage NTSB FTW77FA008Accident · 2 fatalClosedCessna 182L · Shaw, LAOct 23, 1976 · N42213 · Destroyed NTSB FTW77FRD01Accident · No injuriesClosedGrumman G-164 · Maurice, LAOct 9, 1976 · N10264 · Destroyed NTSB FTW77FA002Accident · 3 fatalClosedMooney M20C · Houma, LAOct 4, 1976 · N16515 · Destroyed NTSB FTW76DRD68Accident · Serious injuriesClosedCessna A185F · Patterson, LASep 23, 1976 · N70279 · Substantial damage NTSB FTW76AF125Accident · 1 fatalClosedPiper PA-12 · Greenwood, LASep 21, 1976 · N78592 · Destroyed NTSB FTW76AF123Accident · 4 fatalClosedPiper PA-32 · Oak Ridge, LASep 18, 1976 · N3918W · Destroyed NTSB FTW76DRJ48Accident · Minor injuriesClosedGrumman G-164A · Bonita, LASep 17, 1976 · N7939 · Destroyed NTSB FTW76FRJ47Accident · No injuriesClosedGrumman G-164B · Crowville, LASep 15, 1976 · N48429 · Substantial damage NTSB FTW76DRD67Accident · No injuriesClosedCessna 180 · Napoleonville, LASep 15, 1976 · N9973F · Substantial damage NTSB FTW76FRJ45Accident · 1 fatalClosedSnow 600S2R · Ferriday, LASep 6, 1976 · N5655X · Destroyed NTSB FTW76FRJ43Accident · Serious injuriesClosedCessna A188B · Monroe, LASep 6, 1976 · N4838Q · Destroyed NTSB FTW76FRD66Accident · No injuriesClosedPiper PA-25 · Port Barre, LASep 6, 1976 · N8791L · Substantial damage NTSB FTW76FRJ44Accident · 1 fatalClosedPiper PA-25 · W.Monroe, LASep 4, 1976 · N8786L · Destroyed NTSB FTW76FRD65Accident · No injuriesClosedCessna A185F · Lafayette, LASep 1, 1976 · N51BC · Destroyed NTSB FTW76FRD64Accident · No injuriesClosedCessna 172M · Lake Charles, LAAug 28, 1976 · N80347 · Destroyed NTSB FTW76DRD62Accident · Minor injuriesClosedPiper J-3 · Lake Charles, LAAug 23, 1976 · N41263 · Substantial damage NTSB FTW76FRD63Accident · No injuriesClosedStinson 108 · Baton Rouge, LAAug 22, 1976 · N97647 · Substantial damage NTSB FTW76FRD61Accident · No injuriesClosedCessna 310F · Lafayette, LAAug 20, 1976 · N6792X · Substantial damage NTSB FTW76DRJ41Accident · No injuriesClosedPiper PA-25 · Pioneer, LAAug 20, 1976 · N4761Y · Substantial damage NTSB FTW76FRD60Accident · Serious injuriesClosedCessna 180 · Gretna, LAAug 18, 1976 · N544Z · Substantial damage NTSB FTW76DRJ42Accident · No injuriesClosedGrumman G-164A · Lake Providnce, LAAug 17, 1976 · N8891H · Substantial damage NTSB FTW76FRD59Accident · No injuriesClosedCessna A185F · Lafayette, LAAug 13, 1976 · N38FC · Substantial damage NTSB FTW76FRJ40Accident · Serious injuriesClosedBoeing E75N1 · Tallulah, LAAug 9, 1976 · N5710N · Destroyed NTSB FTW76FRJ39Accident · Minor injuriesClosedGrumman G-164A · Delhi, LAAug 9, 1976 · N8917H · Substantial damage NTSB FTW76AF113Accident · 1 fatalClosedCessna 172 · Baker, LAAug 8, 1976 · N12697 · Destroyed NTSB FTW76FRJ38Accident · Minor injuriesClosedBoeing E75N1 · Epps, LAAug 7, 1976 · N1256V · Substantial damage NTSB FTW76FRD58Accident · Serious injuriesClosedHughes 369 · Intrcostl City, LAAug 4, 1976 · N9125F · Destroyed NTSB FTW76DRJ36Accident · No injuriesClosedCallair A-9 · Plain Dealing, LAJul 31, 1976 · N8292H · Substantial damage NTSB FTW76AF111Accident · No injuriesClosedCessna 180 · Houma, LAJul 29, 1976 · N2125Z · Substantial damage NTSB FTW76FRD56Accident · Serious injuriesClosedGrum Amer AA1-B · Eunice, LAJul 28, 1976 · N1497R · Substantial damage NTSB FTW76DRD55Accident · No injuriesClosedGrumman G-164A · Thibodaux, LAJul 25, 1976 · N6585 · 2 aircraft · Minor damage NTSB FTW76AF110Accident · No injuriesClosedBolkow BO-105 · Rockport, LAJul 25, 1976 · N90656 · Substantial damage NTSB FTW76DRJ34Accident · No injuriesClosedCessna 150M · Oil City, LAJul 24, 1976 · N66127 · Substantial damage NTSB FTW76DRD57Accident · No injuriesClosedCessna 180 · Baton Rouge, LAJul 23, 1976 · N5228D · Substantial damage NTSB FTW76DRJ32Accident · No injuriesClosedPiper PA-25 · Winnsboro, LAJul 19, 1976 · N4868Y · Substantial damage NTSB FTW76DRJ31Accident · No injuriesClosedPiper PA-18 · Ruston, LAJul 18, 1976 · TG-HIQ-F · Substantial damage NTSB FTW76FRJ30Accident · Serious injuriesClosedPiper PA-25 · Gilbert, LAJul 17, 1976 · N4704Y · Destroyed NTSB FTW76AF109Accident · Serious injuriesClosedBell 206B · Berwick, LAJul 15, 1976 · N8176J · Destroyed NTSB FTW76FRD54Accident · Serious injuriesClosedGrumman G-164 · Maringouin, LAJul 11, 1976 · N462RF · Substantial damage NTSB FTW76DRJ29Accident · No injuriesClosedPiper PA-18 · Oak Grove, LAJul 7, 1976 · N4296Z · Substantial damage NTSB FTW76FRD53Accident · Serious injuriesClosedGrumman G-164A · Crowley, LAJul 6, 1976 · N8508H · Substantial damage NTSB FTW76AF106Accident · No injuriesClosedCessna 180 · Golden Meadow, LAJun 24, 1976 · N4779U · Destroyed NTSB FTW76DRD51Accident · No injuriesClosedCessna 180 · Bayon Pigeon, LAJun 23, 1976 · N52009 · Substantial damage NTSB FTW76AF101Accident · 1 fatalClosedBolkow BO105C · Intracoastal, LAJun 13, 1976 · N149BB · Substantial damage NTSB FTW76FRD52Accident · No injuriesClosedBell 47G-5 · Walker, LAJun 10, 1976 · N4713R · Substantial damage NTSB FTW76AF097Accident · Minor injuriesClosedBell 47J-2 · Baton Rouge, LAMay 31, 1976 · N73255 · Destroyed NTSB FTW76DRJ28Accident · No injuriesClosedCessna 172 · Many, LAMay 30, 1976 · N13441 · Substantial damage