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 FTW77FA062Accident · No injuriesClosedBolkow BO-105 · Cameron, LAJun 20, 1977 · N152BB · Substantial damage NTSB FTW77FRD35Accident · No injuriesClosedBoeing A75N1 · Sulphur, LAJun 11, 1977 · N60885 · Substantial damage NTSB FTW77DRJ09Accident · No injuriesClosedGrumman G-164A · Bastrop, LAJun 11, 1977 · N7902 · Substantial damage NTSB FTW77FRD34Accident · Minor injuriesClosedChampion 7FC · Kinder, LAJun 10, 1977 · N9856Y · Substantial damage NTSB FTW77DRD33Accident · No injuriesClosedGrumman G-164 · Pine Prairie, LAJun 8, 1977 · N10292 · Substantial damage NTSB FTW77FA060Accident · Minor injuriesClosedBolkow BO-105 · Intracstl Cy, LAJun 7, 1977 · N90754 · Substantial damage NTSB FTW77FRD30Accident · No injuriesClosedCessna T210F · Baton Rouge, LAJun 3, 1977 · N6153R · Substantial damage NTSB FTW77FRD32Accident · No injuriesClosedGrumman G-164A · Iota, LAJun 2, 1977 · N7480 · Substantial damage NTSB FTW77FRD31Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LAJun 2, 1977 · N7231 · Substantial damage NTSB FTW77FA058Accident · 3 fatalClosedCessna 185 · Houma, LAMay 31, 1977 · N3345L · Destroyed NTSB FTW77DRD29Accident · Serious injuriesClosedCessna 180F · Morgan City, LAMay 27, 1977 · N48091 · No damage NTSB FTW77FRD28Accident · Serious injuriesClosedPiper PA-18 · Gueydan, LAMay 26, 1977 · N40528 · Destroyed NTSB FTW77FRD26Accident · No injuriesClosedMurrayair MA-1B · Sulphur, LAMay 23, 1977 · N1014Y · Substantial damage NTSB FTW77DRD27Accident · Minor injuriesClosedPiper PA 28 · Free Mason Is., LAMay 22, 1977 · N5835U · Substantial damage NTSB FTW77FRD25Accident · No injuriesClosedGrumman G-164A · Welsh, LAMay 18, 1977 · N8548H · Substantial damage NTSB FTW77FRJ07Accident · Serious injuriesClosedCessna 188B · Mer Rouge, LAMay 15, 1977 · N9305G · Destroyed NTSB FTW77DRD23Accident · No injuriesClosedCessna 172 · Melville, LAMay 10, 1977 · N1247U · Destroyed NTSB FTW77DRD21Accident · Minor injuriesClosedBell 206B · Cameron, LAMay 7, 1977 · N7902J · Substantial damage NTSB FTW77DRD24Accident · No injuriesClosedCessna 185 · Venice, LAMay 6, 1977 · N39EC · Substantial damage NTSB FTW77DRD22Accident · No injuriesClosedCessna 185 · Houma, LAMay 6, 1977 · N3469Y · Substantial damage NTSB FTW77DRD20Accident · No injuriesClosedCessna 180J · Dulac, LAMay 6, 1977 · N52035 · Substantial damage NTSB FTW77DRJ06Accident · No injuriesClosedBellanca 8GCBC · Ferriday, LAMay 4, 1977 · N53828 · Substantial damage NTSB FTW77DRD19Accident · No injuriesClosedBoeing A75 · Laccassine, LAMay 4, 1977 · N60885 · Substantial damage NTSB FTW77FRD18Accident · Serious injuriesClosedGrumman G-164B · Eunice, LAApr 30, 1977 · N6653Q · Destroyed NTSB FTW77DRD17Accident · Minor injuriesClosedPiper PA-25 · Crowley, LAApr 29, 1977 · N47637Z · Destroyed NTSB FTW77DRD16Accident · No injuriesClosedGrumman G-164A · Eunice, LAApr 29, 1977 · N9888 · Substantial damage NTSB FTW77DRD13Accident · Minor injuriesClosedGrumman G-164B · Kaplan, LAApr 26, 1977 · N6650Q · Substantial damage NTSB FTW77DRD14Accident · Minor injuriesClosedCessna 185A · Houma, LAApr 25, 1977 · N1984U · Substantial damage NTSB FTW77DRD15Accident · No injuriesClosedCessna 180 · Baton Rouge, LAApr 23, 1977 · N5228D · Substantial damage NTSB FTW77DRD12Accident · No injuriesClosedBell 206B · Leeville, LAApr 22, 1977 · N65AL · Minor damage NTSB FTW77FRD10Accident · Serious injuriesClosedPiper PA-36 · New Roads, LAApr 18, 1977 · N57855 · Destroyed NTSB FTW77FA049Accident · 5 fatalClosedBeech BE200 · Ruddock, LAApr 18, 1977 · N256TM · Destroyed NTSB FTW77FRD09Accident · Serious injuriesClosedBell 47G-4A · Ville Platte, LAMar 29, 1977 · N2218W · Destroyed NTSB FTW77FA044Accident · 1 fatalClosedBell 206B · Intracoastal C, LAMar 17, 1977 · N90071 · Destroyed NTSB FTW77FA043Accident · 3 fatalClosedCessna 150J · Westwego, LAMar 15, 1977 · N50600 · Destroyed NTSB FTW77DRJ04Accident · No injuriesClosedBoeing A75N1 · Shreveport, LAMar 12, 1977 · N63266 · Substantial damage NTSB FTW77IA039Incident · No injuriesClosedConvair 240D · Alexandria, LAMar 3, 1977 · N94239 · Minor damage NTSB FTW77FRD07Accident · No injuriesClosedCessna 421 · Baton Rouge, LAFeb 22, 1977 · N149Y · Substantial damage NTSB FTW77DRD08Accident · Minor injuriesClosedCessna 172 · Jackson, LAFeb 18, 1977 · N7297Q · Substantial damage NTSB FTW77FA036Accident · 2 fatalClosedCessna 150H · Mer Rouge, LAFeb 14, 1977 · N23494 · Destroyed NTSB FTW77DRJ03Accident · No injuriesClosedPiper PA-20 · Shreveport, LAFeb 13, 1977 · N7494K · Substantial damage NTSB FTW77FA035Accident · 3 fatalClosedPiper PA-28 · Baton Rouge, LAFeb 12, 1977 · N4493T · Destroyed NTSB FTW77FA030Accident · 2 fatalClosedCessna 185D · Jennings, LAJan 15, 1977 · N1507F · Destroyed NTSB FTW77FRD06Accident · No injuriesClosedCessna 150 · Oakdale, LAJan 11, 1977 · N23143 · Substantial damage NTSB FTW77FA028Accident · 1 fatalClosedBolkow BO105C · Morgan City, LAJan 6, 1977 · N200BB · Substantial damage NTSB FTW77FA027Accident · 2 fatalClosedCessna 150J · Patterson, LAJan 3, 1977 · N51148 · Destroyed NTSB FTW77FRD05Accident · No injuriesClosedGrumman G-164A · Welsh, LADec 28, 1976 · N8699H · Substantial damage NTSB FTW77FRD04Accident · Serious injuriesClosedPiper PA-22 · Port Sulphur, LADec 24, 1976 · N644A · Substantial damage NTSB FTW77DA021Accident · No injuriesClosedBell 206B · Morgan City, LADec 11, 1976 · N49669 · Substantial damage NTSB FTW77FRJ02Accident · Minor injuriesClosedCessna 182 · Arcadia, LANov 30, 1976 · N52317 · Substantial damage