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 FTW76FRJ27Accident · No injuriesClosedPiper PA-28 · Cotton Valley, LAMay 28, 1976 · N1656J · Substantial damage NTSB FTW76DRD50Accident · No injuriesClosedCessna A185F · Venice, LAMay 24, 1976 · N102AM · Substantial damage NTSB FTW76DRD49Accident · No injuriesClosedCessna 150 · Lake Charles, LAMay 21, 1976 · N11265 · Substantial damage NTSB FTW76FRD46Accident · No injuriesClosedGrumman G-164 · Simmesport, LAMay 18, 1976 · N461RF · Substantial damage NTSB FTW76FRD48Accident · No injuriesClosedRobertson B8M · Dequincy, LAMay 15, 1976 · N31170 · Substantial damage NTSB FTW76FRD47Accident · No injuriesClosedGrumman G-164A · Lake Charles, LAMay 14, 1976 · N4864 · Substantial damage NTSB FTW76FRD43Accident · No injuriesClosedCessna 180 · Port Sulphur, LAMay 12, 1976 · N52165 · Substantial damage NTSB FTW76FRD45Accident · Minor injuriesClosedDierrea · Broussard, LAMay 9, 1976 · NONE · Substantial damage NTSB FTW76FRD44Accident · No injuriesClosedPiper PA-28 · Lafayette, LAMay 9, 1976 · N8730E · Substantial damage NTSB FTW76FRJ24Accident · Serious injuriesClosedTeenie II · Ruston, LAMay 8, 1976 · N75AS · Destroyed NTSB FTW76FRD42Accident · Serious injuriesClosedGrumman G-164A · Elton, LAMay 6, 1976 · N9816 · Destroyed NTSB FTW76AF093Accident · 1 fatalClosedCessna 337 · Bunkie, LAMay 6, 1976 · N5419S · Destroyed NTSB FTW76FRD41Accident · No injuriesClosedPiper PA-25 · Elton, LAMay 1, 1976 · N8784L · Substantial damage NTSB FTW76DRD40Accident · No injuriesClosedCessna 120 · Covington, LAMay 1, 1976 · N76630 · Substantial damage NTSB FTW76FRJ21Accident · No injuriesClosedPiper PA-25 · Crowville, LAApr 22, 1976 · N4647Y · Substantial damage NTSB FTW76DRJ22Accident · No injuriesClosedCessna 172M · Alexandria, LAApr 21, 1976 · N80327 · Substantial damage NTSB FTW76DRD38Accident · No injuriesClosedGrumman G-164A · Kaplan, LAApr 19, 1976 · N5262 · Substantial damage NTSB FTW76AF085Accident · 1 fatalClosedBell 206B · Leeville, LAApr 17, 1976 · N14856 · Destroyed NTSB FTW76FRD36Accident · Minor injuriesClosedAeronca 0-58B · New Iberia, LAApr 14, 1976 · N58084 · Substantial damage NTSB FTW76FRJ20Accident · Serious injuriesClosedCessna 182P · Jones, LAApr 13, 1976 · N9110M · Destroyed NTSB FTW76FRJ19Accident · Serious injuriesClosedAeronca 7AC · Transylvania, LAApr 11, 1976 · N2606E · Substantial damage NTSB FTW76DRD39Accident · No injuriesClosedErco 415-C · Baton Rouge, LAApr 4, 1976 · N99729 · Substantial damage NTSB FTW76AF082Accident · 1 fatalClosedCessna 177 · New Iberia, LAApr 3, 1976 · N2894X · 2 aircraft · Destroyed NTSB FTW76DRD37Accident · No injuriesClosedCessna 150 · Hathaway, LAApr 2, 1976 · N6616G · Substantial damage NTSB FTW76DRD35Accident · No injuriesClosedGrumman G-164 · Oakdale, LAMar 31, 1976 · N6590 · Substantial damage NTSB FTW76FRD34Accident · No injuriesClosedGrumman G-164A · Elton, LAMar 26, 1976 · N8559H · Substantial damage NTSB FTW76FRD33Accident · No injuriesClosedBoeing A75N1 · Lafayette, LAMar 26, 1976 · N53165 · Substantial damage NTSB FTW76FRD32Accident · No injuriesClosedPiper PA-36 · Palmetto, LAMar 22, 1976 · N55632 · Substantial damage NTSB FTW76AF071Accident · 1 fatalClosedCessna 172 · Marksville, LAMar 12, 1976 · N5928R · Destroyed NTSB FTW76DRJ17Accident · No injuriesClosedPiper PA-31 · Many, LAMar 9, 1976 · N6568L · Substantial damage NTSB FTW76FRD31Accident · No injuriesClosedPiper PA-32 · Convent, LAMar 4, 1976 · N3650W · Substantial damage NTSB FTW76DRD30Accident · No injuriesClosedAir & Space 18A · Baton Rouge, LAFeb 16, 1976 · N6154S · Substantial damage NTSB FTW76DRD29Accident · Serious injuriesClosedPiper PA-28 · Sorrento, LAFeb 14, 1976 · N57296 · Destroyed NTSB FTW76DRJ16Accident · No injuriesClosedPiper PA-22 · Gilliam, LAFeb 12, 1976 · N9039D · Substantial damage NTSB FTW76AF062Accident · 2 fatalClosedBeech C-45H · Lafayette, LAFeb 3, 1976 · N3329G · Destroyed NTSB FTW76AF061Accident · 2 fatalClosedCessna 210 · Jena, LAJan 25, 1976 · N9490T · Destroyed NTSB FTW76FRD27Accident · No injuriesClosedPiper PA-28 · Church Point, LAJan 19, 1976 · N57312 · Substantial damage NTSB FTW76AF059Accident · 1 fatalClosedBell 206B · Intercstl City, LAJan 19, 1976 · N143PA · Destroyed NTSB FTW76DRD28Accident · No injuriesClosedPiper PA-23 · Abita Springs, LAJan 11, 1976 · N13903 · Substantial damage NTSB FTW76FRD26Accident · Serious injuriesClosedCessna 185A · Delcambre, LADec 20, 1975 · N39FC · No damage NTSB FTW76ARD25Accident · Minor injuriesClosedCessna 172 · Lafayette, LADec 18, 1975 · N5092R · Substantial damage NTSB FTW76FRD24Accident · No injuriesClosedNavion A · New Orleans, LADec 14, 1975 · N8884H · Substantial damage NTSB FTW76AF048Accident · 3 fatalClosedBeech M35 · Jena, LANov 29, 1975 · N1169R · Destroyed NTSB FTW76FRD22Accident · No injuriesClosedGrumman G-164 · Iowa, LANov 25, 1975 · N11983 · Substantial damage NTSB FTW76DRD23Accident · No injuriesClosedMooney M20C · Meraux, LANov 23, 1975 · N9206M · Substantial damage NTSB FTW76DRD21Accident · No injuriesClosedCessna 185 · Houma, LANov 21, 1975 · N1744R · Substantial damage NTSB FTW76FRJ12Accident · Serious injuriesClosedCessna 150F · Oil City, LANov 18, 1975 · N7116F · Substantial damage NTSB FTW76DRD19Accident · No injuriesClosedCessna 140 · New Orleans, LANov 16, 1975 · N2996N · Substantial damage NTSB FTW76AF045Accident · 1 fatalClosedCessna 150F · Crowville, LANov 15, 1975 · N8607S · Destroyed NTSB FTW76FRD20Accident · No injuriesClosedPiper J3C-65 · Melville, LANov 13, 1975 · N70421 · Substantial damage