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 FTW79DRD57Accident · No injuriesClosedPiper PA-25 · Baton Rouge, LASep 28, 1979 · N4485Y · Substantial damage NTSB FTW79DA109Accident · No injuriesClosedBell 212 · Morgan City, LASep 25, 1979 · N49673 · Substantial damage NTSB FTW79DRD56Accident · No injuriesClosedCessna 188B · Vacherie, LASep 24, 1979 · N9448G · Substantial damage NTSB FTW79DRJ25Accident · No injuriesClosedGrum-Amer AA1-C · Minden, LASep 21, 1979 · N9784U · Substantial damage NTSB FTW79FA108Accident · 4 fatalClosedPiper PA-31 · Luling, LASep 20, 1979 · N27614 · Destroyed NTSB FTW79FRD55Accident · No injuriesClosedBell 206B · Patterson, LASep 18, 1979 · N155AL · Substantial damage NTSB FTW79FRJ52Accident · No injuriesClosedBoeing PT-17 · Shreveport, LASep 13, 1979 · N63804 · Substantial damage NTSB FTW79FRD53Accident · No injuriesClosedBoeing A75N1 · Cade, LASep 12, 1979 · N53165 · Substantial damage NTSB FTW79DRD54Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LASep 12, 1979 · N3030S · Substantial damage NTSB FTW79FA107Accident · 1 fatalClosedCessna 172N · Lafayette, LASep 8, 1979 · N1944F · Destroyed NTSB FTW79FRD52Accident · No injuriesClosedBell 47G-4A · Hackberry, LASep 6, 1979 · N7104J · Substantial damage NTSB FTW79DRD51Accident · Minor injuriesClosedPiper PA-25 · White Castle, LASep 6, 1979 · N7759Z · Substantial damage NTSB FTW79DRJ23Accident · No injuriesClosedBellanca 17-30 · Jena, LASep 3, 1979 · N11811 · Substantial damage NTSB FTW79DA104Accident · 1 fatalClosedCessna T210P · Intercoastal, LASep 1, 1979 · N6531P · Destroyed NTSB FTW79DRJ22Accident · No injuriesClosedGrumman G-164B · Monterey, LAAug 30, 1979 · N6890K · Substantial damage NTSB FTW79DRJ21Accident · No injuriesClosedBoeing A75N1 · Tallulah, LAAug 23, 1979 · N4440N · Substantial damage NTSB FTW79DA102Accident · No injuriesClosedCessna 180 · Mandeville, LAAug 22, 1979 · N3494V · Substantial damage NTSB FTW79FRD50Accident · No injuriesClosedBell 47G-4A · Lafayette, LAAug 19, 1979 · N1400W · Substantial damage NTSB FTW79FA101Accident · 2 fatalClosedCessna A185F · Westwego, LAAug 16, 1979 · N8245Q · Destroyed NTSB FTW79FRJ20Accident · 1 fatalClosedRockwell S-2R · Waterproof, LAAug 15, 1979 · N4251X · Destroyed NTSB FTW79DA100Accident · 1 fatalClosedBell 206B · Morgan City, LAAug 11, 1979 · N5018F · Destroyed NTSB FTW79DRD48Accident · No injuriesClosedCessna 150 · New Roads, LAAug 9, 1979 · N63342 · Substantial damage NTSB FTW79DRD49Accident · Minor injuriesClosedBell 206B · Intracstl City, LAAug 8, 1979 · N90171 · Substantial damage NTSB FTW79DRJ19Accident · No injuriesClosedBell 47G-2A · Plaucheville, LAJul 31, 1979 · N166 · Destroyed NTSB FTW79DRJ18Accident · No injuriesClosedBell 47WASP · Plaucheville, LAJul 28, 1979 · N38092 · Substantial damage NTSB FTW79FA097Accident · 1 fatalClosedCessna A185F · Lafayette, LAJul 20, 1979 · N4616E · Destroyed NTSB FTW79FA096Accident · No injuriesClosedBell 206B · Cut Off, LAJul 17, 1979 · N4715R · Substantial damage NTSB FTW79FRJ17Accident · Minor injuriesClosedSnow S2R · Jonesville, LAJul 13, 1979 · N4958X · Destroyed NTSB FTW79DA093Accident · 1 fatalClosedCessna 140 · Basile, LAJul 6, 1979 · N1607V · Destroyed NTSB FTW79DRD45Accident · No injuriesClosedCessna 185F · Lafayette, LAJul 2, 1979 · N28JL · Substantial damage NTSB FTW79DRD46Accident · No injuriesClosedSchweizer SGS126 · Robert, LAJul 1, 1979 · N17917 · Substantial damage NTSB FTW79FA090Accident · 2 fatalClosedLuscombe 8A · Winnsboro, LAJun 29, 1979 · N45950 · Destroyed NTSB FTW79DRD43Accident · No injuriesClosedGrumman G-164A · Kinder, LAJun 26, 1979 · N8685H · Destroyed NTSB FTW79FRD42Accident · No injuriesClosedCessna 172 · Grand Isle, LAJun 24, 1979 · N73214 · Substantial damage NTSB FTW79FRD41Accident · No injuriesClosedGrumman G-164A · Basile, LAJun 18, 1979 · N6586 · Substantial damage NTSB FTW79DA088Accident · 1 fatalClosedMitsubishi MU-2B · New Orleans, LAJun 18, 1979 · N222LR · Substantial damage NTSB FTW79DRD44Accident · No injuriesClosedBell 206B · Bell Rose, LAJun 17, 1979 · N4830 · Substantial damage NTSB FTW79DA087Accident · Minor injuriesClosedBell 206B · Venice, LAJun 12, 1979 · N16710 · Substantial damage NTSB FTW79FRD40Accident · No injuriesClosedGrumman G-164A · Elton, LAJun 8, 1979 · N8699H · Substantial damage NTSB FTW79DRD39Accident · No injuriesClosedGrumman G-164A · Pine Island, LAJun 5, 1979 · N5379 · Substantial damage NTSB FTW79DA085Accident · Serious injuriesClosedBell 206B · Morgan City, LAJun 3, 1979 · N14852 · Destroyed NTSB FTW79DRD38Accident · No injuriesClosedGrumman G-164A · Kaplan, LAJun 1, 1979 · N9514 · Substantial damage NTSB FTW79FRD34Accident · No injuriesClosedPiper PA-36 · Lafayette, LAMay 29, 1979 · N3712E · Substantial damage NTSB FTW79FRD36Accident · Minor injuriesClosedBoeing 75 · Holmwood, LAMay 28, 1979 · N65368 · Substantial damage NTSB FTW79DRD33Accident · Minor injuriesClosedCessna 150 · Houma, LAMay 27, 1979 · N22113 · Substantial damage NTSB FTW79DA081Accident · Minor injuriesClosedCessna 185F · Morgan City, LAMay 24, 1979 · N4663E · Destroyed NTSB FTW79DRD32Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LAMay 22, 1979 · N6603 · Substantial damage NTSB FTW79DRD31Accident · No injuriesClosedGrumman G-164A · Kaplan, LAMay 22, 1979 · N5262 · Destroyed NTSB FTW79DRD37Accident · No injuriesClosedCessna 185A · Venice, LAMay 19, 1979 · N12NT · Substantial damage NTSB FTW79DA080Accident · No injuriesClosedBell 206B · Sorrento, LAMay 17, 1979 · N203AL · Substantial damage