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 FTW76DRD18Accident · No injuriesClosedCessna 170B · Westwego, LANov 9, 1975 · N12218 · Substantial damage NTSB FTW76FRD16Accident · No injuriesClosedBell 206B · Morgan City, LANov 2, 1975 · N7847S · Substantial damage NTSB FTW76AF040Accident · 3 fatalClosedPiper PA-28R · New Orleans, LANov 1, 1975 · N9489N · Destroyed NTSB FTW76FRD45Accident · No injuriesClosedGrumman G-164A · Sweet Lake, LAOct 29, 1975 · N9512 · Substantial damage NTSB FTW76FRD14Accident · No injuriesClosedPiper PA-25 · Opelousas, LAOct 22, 1975 · N8791L · Substantial damage NTSB FTW76AF034Accident · 2 fatalClosedCessna 150 · Oak Grove, LAOct 19, 1975 · N19003 · Destroyed NTSB FTW76DRD13Accident · No injuriesClosedCessna 185 · Golden Meadow, LAOct 10, 1975 · N12NT · Substantial damage NTSB FTW76AF028Accident · Serious injuriesClosedBell 206B · Pecan Island, LAOct 8, 1975 · N83134 · Substantial damage NTSB FTW76FRD10Accident · No injuriesClosedBoeing A75 · Lake Charles, LASep 29, 1975 · N4912N · Substantial damage NTSB FTW76AF025Accident · 1 fatalClosedMooney M20E · Freemason Isld, LASep 29, 1975 · N1247X · Destroyed NTSB FTW76DRD12Accident · No injuriesClosedGrum Amer AA1-B · Thibodaux, LASep 28, 1975 · N9937L · Substantial damage NTSB FTW76DRD11Accident · No injuriesClosedCessna 185 · Lake Arthur, LASep 28, 1975 · N1507F · Substantial damage NTSB FTW76FRD09Accident · No injuriesClosedPiper PA-28 · Plaquemine, LASep 27, 1975 · N33674 · Substantial damage NTSB FTW76FRJ10Accident · Serious injuriesClosedPiper PA-28 · Jena, LASep 20, 1975 · N8228N · Destroyed NTSB FTW76AF022Accident · 1 fatalClosedSemco TC-4 · Baton Rouge, LASep 19, 1975 · N3810 · Destroyed NTSB FTW76DRD08Accident · No injuriesClosedCessna 180F · Houma, LASep 17, 1975 · N9945V · Substantial damage NTSB FTW76AF021Accident · 2 fatalClosedPiper PA-32 · Alexandria, LASep 16, 1975 · N7747J · Destroyed NTSB FTW76AF020Accident · No injuriesClosedHughes 369HS · Venice, LASep 15, 1975 · N9088F · Substantial damage NTSB FTW76AF018Accident · 1 fatalClosedBellanca 17-31 · Larto, LASep 7, 1975 · N14713 · Destroyed NTSB FTW76DRJ09Accident · No injuriesClosedBeech B19 · Holly Ridge, LASep 1, 1975 · N6557R · Substantial damage NTSB FTW76DRD06Accident · Serious injuriesClosedLuscombe 8A · Gonzales, LAAug 24, 1975 · N25168 · Substantial damage NTSB FTW7LDRJ07Accident · No injuriesClosedCessna P337 · Alexandria, LAAug 22, 1975 · N5CS · Substantial damage NTSB FTW76DRJ08Accident · No injuriesClosedAero Comdr 112 · Monroe, LAAug 21, 1975 · N1041J · Substantial damage NTSB FTW76AF013Accident · No injuriesClosedBell 47G-4A · Leeville, LAAug 20, 1975 · N4003G · Substantial damage NTSB FTW76DRJ06Accident · Minor injuriesClosedPiper PA-23 · Alexandria, LAAug 16, 1975 · N54166 · Destroyed NTSB FTW75FRD04Accident · No injuriesClosedBeech G35 · Baton Rouge, LAAug 15, 1975 · N4480D · Substantial damage NTSB FTW7LDRD07Accident · No injuriesClosedPiper PA-18 · Wilson, LAAug 13, 1975 · N14299 · Substantial damage NTSB FTW76FRD05Accident · No injuriesClosedGrumman G-164A · Erath, LAAug 12, 1975 · N7231 · Substantial damage NTSB FTW76DRJ04Accident · No injuriesClosedGrumman G-164A · Rayville, LAAug 11, 1975 · N5256 · Destroyed NTSB FTW76FRD03Accident · Serious injuriesClosedCessna 180 · Golden Meadow, LAAug 5, 1975 · N9769G · Substantial damage NTSB FTW76AF007Accident · Minor injuriesClosedBell 206B · Morgan City, LAAug 5, 1975 · N4710R · Destroyed NTSB FTW76DRD02Accident · No injuriesClosedCessna 182 · Covington, LAJul 28, 1975 · N41GC · Substantial damage NTSB FTW76DRD01Accident · No injuriesClosedCessna 182K · New Orleans, LAJul 25, 1975 · N2496Q · Substantial damage NTSB FTW76AF031Accident · 2 fatalClosedPiper PA-32 · Bernice, LAJul 21, 1975 · N3704W · Destroyed NTSB FTW76DRJ03Accident · No injuriesClosedGlobe GC-1B · Minden, LAJul 13, 1975 · N3791K · Substantial damage NTSB FTW75FRD69Accident · Serious injuriesClosedGrumman G-164A · Iowa, LAJun 28, 1975 · N9774 · Substantial damage NTSB FTW75AF076Accident · 2 fatalClosedPiper PA-28 · Baton Rouge, LAJun 27, 1975 · N32558 · Destroyed NTSB FTW75DRJ38Accident · No injuriesClosedTern Glider · Lecompte, LAJun 21, 1975 · N7308 · Substantial damage NTSB FTW75FRJ37Accident · No injuriesClosedNavion A · Mansfield, LAJun 15, 1975 · N8885H · Substantial damage NTSB FTW75DRJ36Accident · No injuriesClosedBeech 35 · Leesville, LAJun 10, 1975 · N3956N · Substantial damage NTSB FTW75FRD67Accident · Serious injuriesClosedHopkins Sports · New Orleans, LAJun 9, 1975 · N6375 · No damage NTSB FTW75FRD66Accident · No injuriesClosedEmair MA-1 · Oberlin, LAJun 9, 1975 · N1014Y · Substantial damage NTSB FTW75FRD62Accident · No injuriesClosedBeech 95-B55 · Baton Rouge, LAJun 9, 1975 · N5895J · Substantial damage NTSB FTW75DRD65Accident · No injuriesClosedGrumman G-164A · Eunice, LAJun 6, 1975 · N5257 · Substantial damage NTSB FTW75FRD63Accident · No injuriesClosedBell 206B · St Martinville, LAJun 1, 1975 · N58099 · Destroyed NTSB FTW75DRJ35Accident · No injuriesClosedGrumman G-164 · Jones, LAMay 26, 1975 · N484Y · Substantial damage NTSB FTW75FRD60Accident · Minor injuriesClosedMooney M22 · New Orleans, LAMay 23, 1975 · N99HN · Substantial damage NTSB FTW75DRD61Accident · Minor injuriesClosedBoeing E75 · Mermentau, LAMay 23, 1975 · N51212 · Destroyed NTSB FTW75FRD58Accident · No injuriesClosedGrumman G-164A · Iowa, LAMay 21, 1975 · N5374 · Destroyed NTSB FTW75DRD59Accident · No injuriesClosedGruman G-164A · Gueydan, LAMay 21, 1975 · N5355 · Substantial damage