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 FTW75FRO56Accident · Serious injuriesClosedGrumman G-164A · Welsh, LAMay 20, 1975 · N7694 · Destroyed NTSB FTW75FRD55Accident · No injuriesClosedGrumman G-164A · Iota, LAMay 20, 1975 · N677U · Destroyed NTSB FTW75FRD57Accident · No injuriesClosedPiper PA-25 · Basile, LAMay 16, 1975 · N7011Z · Substantial damage NTSB FTW75FRD52Accident · Minor injuriesClosedGrumman G-164A · Iowa, LAMay 15, 1975 · N8661H · Substantial damage NTSB FTW75FRD54Accident · No injuriesClosedGrumman G-164A · Eunice, LAMay 14, 1975 · N9830 · Substantial damage NTSB FTW75FRD53Accident · No injuriesClosedGrumman G-164A · Welsh, LAMay 14, 1975 · N9684 · Substantial damage NTSB FTW75FRD51Accident · No injuriesClosedGrumman G-164A · E.Lake Charles, LAMay 13, 1975 · N6535 · Substantial damage NTSB FTW75DRD64Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LAMay 11, 1975 · N32558 · Substantial damage NTSB FTW75FRD50Accident · No injuriesClosedSnow 600S2R · Oakdale, LAMay 10, 1975 · N3652X · Substantial damage NTSB FTW75FRD49Accident · No injuriesClosedGrumman G-164A · Abbeville, LAMay 10, 1975 · N4963 · 2 aircraft · Substantial damage NTSB FTW75FRD48Accident · No injuriesClosedGrumman G-164A · Mermentau, LAMay 9, 1975 · N979X · Substantial damage NTSB FTW75FRD47Accident · No injuriesClosedGrumman G-164A · Morse, LAMay 9, 1975 · N956X · Substantial damage NTSB FTW75FRD46Accident · Minor injuriesClosedPiper PA-25 · Leroy, LAMay 9, 1975 · N8787L · Substantial damage NTSB FTW75FRD44Accident · Minor injuriesClosedPiper PA-22 · Mamou, LAMay 4, 1975 · N1249C · Substantial damage NTSB FTW75FRD45Accident · No injuriesClosedGrumman G-164A · Oberlin, LAMay 2, 1975 · N7360 · Substantial damage NTSB FTW75FRD43Accident · Serious injuriesClosedGrumman G-164A · Welsh, LAApr 29, 1975 · N7802 · Substantial damage NTSB FTW75FRD41Accident · No injuriesClosedBoeing A75N1 · Iowa, LAApr 27, 1975 · N60885 · Substantial damage NTSB FTW75FRD42Accident · No injuriesClosedGrumman G-164A · Reeves, LAApr 25, 1975 · N5477 · Substantial damage NTSB FTW75AF065Accident · 5 fatalClosedBeech A36 · New Orleans, LAApr 23, 1975 · N9123Q · Substantial damage NTSB FTW75DRJ32Accident · Minor injuriesClosedPiper PA-28 · Alexandria, LAApr 21, 1975 · N15011 · Destroyed NTSB FTW75DRJ33Accident · No injuriesClosedAeronca 7ECA · Zwolle, LAApr 20, 1975 · N2510G · Substantial damage NTSB FTW75DRJ31Accident · No injuriesClosedPiper PA-28 · Many, LAApr 17, 1975 · N1467T · Substantial damage NTSB FTW75DRJ34Accident · No injuriesClosedBellanca 8GCBC · Lk Providence, LAApr 13, 1975 · N86632 · Substantial damage NTSB FTW75FRD39Accident · Minor injuriesClosedCessna 185D · New Orleans, LAApr 11, 1975 · N1568F · Substantial damage NTSB FTW75FRD40Accident · No injuriesClosedCessna 150 · Arnaudville, LAApr 6, 1975 · N7515G · Substantial damage NTSB FTW75DRJ29Accident · Serious injuriesClosedCessna 180J · Tallulah, LAApr 5, 1975 · N42677 · Destroyed NTSB FTW75AF060Accident · Serious injuriesClosedBell 206B · Grand Chenier, LAApr 4, 1975 · N59621 · Substantial damage NTSB FTW75FRD38Accident · Minor injuriesClosedCessna 172F · Slidell, LAMar 31, 1975 · N7902U · Substantial damage NTSB FTW75DRD37Accident · No injuriesClosedCessna 185 · Henderson, LAMar 19, 1975 · N70140 · Substantial damage NTSB FTW75FRD36Accident · No injuriesClosedPiper PA-32 · Lucy, LAMar 13, 1975 · N8995N · Substantial damage NTSB FTW75DRJ24Accident · Minor injuriesClosedPiper PA-28 · Monroe, LAMar 2, 1975 · N8898N · Substantial damage NTSB FTW75ARD33Accident · No injuriesClosedSchweizer SGS126 · Covington, LAMar 1, 1975 · N8637R · Substantial damage NTSB FTW75FRD31Accident · 1 fatalClosedAero Comdr 600S2R · Oberlin, LAFeb 21, 1975 · N4887X · Destroyed NTSB FTW75DRJ25Accident · Minor injuriesClosedBoeing A75 · Tallulah, LAFeb 20, 1975 · N63910 · Destroyed NTSB FTW75AF054Accident · Minor injuriesClosedHughes 369HS · Grand Chenier, LAFeb 20, 1975 · N84AL · Substantial damage NTSB FTW75FRD29Accident · No injuriesClosedChampion 7KCAB · Abita Springs, LAFeb 17, 1975 · N88442 · Substantial damage NTSB FTW75FRD28Accident · No injuriesClosedHelio Acft H-295 · Lafayette, LAFeb 17, 1975 · N68879 · Substantial damage NTSB FTW75AF052Accident · 2 fatalClosedPiper PA-23 · New Orleans, LAFeb 17, 1975 · N4321P · Destroyed NTSB FTW75FRD27Accident · No injuriesClosedCessna 150 · New Orleans, LAFeb 12, 1975 · N3568V · Substantial damage NTSB FTW75DRJ23Accident · No injuriesClosedCessna 150K · Natchitoches, LAFeb 12, 1975 · N6358G · Substantial damage NTSB FTW75DRD32Accident · No injuriesClosedAero Comdr 100 · Simmesport, LAJan 31, 1975 · N4018X · Substantial damage NTSB FTW75FRD26Accident · Serious injuriesClosedCessna 150L · Kinder, LAJan 27, 1975 · N16121 · Substantial damage NTSB FTW75DRJ22Accident · Minor injuriesClosedTaylorcraft BL-65 · Kilbourne, LAJan 6, 1975 · N22267 · Substantial damage NTSB FTW75FRD23Accident · No injuriesClosedPiper PA-31 · Kenner, LAJan 5, 1975 · N7577L · Substantial damage NTSB FTW75DRD24Accident · No injuriesClosedCessna 120 · Golden Meadow, LADec 31, 1974 · N76235 · Substantial damage NTSB FTW75AF047Accident · 1 fatalClosedCessna 175 · Abbeville, LADec 31, 1974 · N8066T · Destroyed NTSB FTW75DRD21Accident · No injuriesClosedPiper PA-28 · Lockport, LADec 26, 1974 · N5413S · Substantial damage NTSB FTW75FRD22Accident · No injuriesClosedAero Comdr 500-B · New Orleans, LADec 23, 1974 · N99JG · Substantial damage NTSB FTW75FRD19Accident · No injuriesClosedPiper J3C-65 · Baton Rouge, LADec 21, 1974 · N21636 · 2 aircraft · Substantial damage NTSB FTW75FRD17Accident · No injuriesClosedAmer Avco AA1-B · Houma, LADec 10, 1974 · N6515L · Substantial damage