Skip to content

NTSB investigations, LA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 FTW80FA111Accident · Minor injuriesClosedSikorsky S-76 · Patterson, LASep 3, 1980 · N766AL · Destroyed NTSB FTW80DRD60Accident · No injuriesClosedCessna 185F · Leeville, LASep 3, 1980 · N5125E · Substantial damage NTSB FTW80DA110Accident · No injuriesClosedCessna 185 · Houma, LASep 1, 1980 · N8308Q · Substantial damage NTSB FTW80DRD59Accident · No injuriesClosedBell 206L-1 · Intracstl Cty, LAAug 29, 1980 · N2775A · Substantial damage NTSB FTW80DA109Accident · No injuriesClosedPiper PA-31 · Patterson, LAAug 29, 1980 · N228CH · Substantial damage NTSB FTW80DRJ36Accident · Minor injuriesClosedWeatherly 201B · Winnsboro, LAAug 28, 1980 · N1285W · 2 aircraft · Substantial damage NTSB FTW80FRJ35Accident · 1 fatalClosedPiper PA-25 · Transylvania, LAAug 23, 1980 · N8503L · Destroyed NTSB FTW80DRD58Accident · No injuriesClosedCessna 185F · Slidell, LAAug 22, 1980 · N4805Q · Substantial damage NTSB FTW80DRD54Accident · Minor injuriesClosedHughes 269B · Wakefield, LAAug 16, 1980 · N1093D · Substantial damage NTSB FTW80FRD56Accident · Serious injuriesClosedCessna 150 · Sulphur, LAAug 14, 1980 · N3660V · Substantial damage NTSB FTW80DRD57Accident · No injuriesClosedCessna 188B · Port Barre, LAAug 12, 1980 · N9230G · Destroyed NTSB FTW80FRD55Accident · Minor injuriesClosedPiper PA-25 · Plaquemine, LAAug 11, 1980 · N4485Y · Destroyed NTSB FTW80DRJ31Accident · No injuriesClosedStearman B75 · Tallulah, LAAug 7, 1980 · N8095E · Substantial damage NTSB FTW80FA100Accident · 13 fatalClosedBell 205A-1 · Houma, LAAug 6, 1980 · N95AL · Destroyed NTSB FTW80DRD53Accident · No injuriesClosedCessna 180 · Empire, LAAug 6, 1980 · N9945V · Destroyed NTSB FTW80DRD50Accident · No injuriesClosedBeech E55 · Houma, LAJul 31, 1980 · N9047V · Substantial damage NTSB FTW80DRD51Accident · No injuriesClosedGrumman G-164A · Kinder, LAJul 29, 1980 · N48377 · Substantial damage NTSB FTW80FA097Accident · 1 fatalClosedCessna 182Q · Vidalia, LAJul 28, 1980 · N759SS · Destroyed NTSB FTW80FA094Accident · 5 fatalClosedSikorsky S-58T · Morgan City, LAJul 18, 1980 · N69CH · Destroyed NTSB FTW80DRD49Accident · No injuriesClosedPiper PA-38 · Lake Charles, LAJul 18, 1980 · N2395K · Substantial damage NTSB FTW80DRD48Accident · No injuriesClosedCessna 185 · Chauvin, LAJul 16, 1980 · N80MW · Substantial damage NTSB FTW80DA092Accident · Serious injuriesClosedGrum-Amer AA-1C · Plain Dealing, LAJul 16, 1980 · N9784U · Destroyed NTSB FTW80FRD45Accident · Minor injuriesClosedCessna P210N · New Orleans, LAJul 13, 1980 · N7345K · Destroyed NTSB FTW80DRD46Accident · No injuriesClosedCessna 180 · Dulac, LAJul 7, 1980 · N66618 · Substantial damage NTSB FTW80FRD44Accident · Minor injuriesClosedSpezio Tu Holer · Hammond, LAJul 6, 1980 · N1034F · Substantial damage NTSB FTW80FRJ28Accident · Serious injuriesClosedPiper PA-32 · Cottonport, LAJul 3, 1980 · N31840 · Substantial damage NTSB FTW80DRJ27Accident · No injuriesClosedPiper PA-25 · Gilliam, LAJul 2, 1980 · N7537Z · Substantial damage NTSB FTW80DRJ26Accident · No injuriesClosedGrumman G164A · Crowville, LAJun 30, 1980 · N917X · Substantial damage NTSB FTW80DRJ25Accident · No injuriesClosedGrumman G-164A · Jones, LAJun 21, 1980 · N932X · Substantial damage NTSB FTW80FRD43Accident · No injuriesClosedCessna 150F · Mamou, LAJun 20, 1980 · N8109F · Substantial damage NTSB FTW80DRD42Accident · No injuriesClosedGrumman G-164 · Hathaway, LAJun 16, 1980 · N458RF · Substantial damage NTSB FTW80DRJ24Accident · No injuriesClosedCessna 150 · Monroe, LAJun 15, 1980 · N3421V · Substantial damage NTSB FTW80DRD41Accident · No injuriesClosedPiper PA-31 · Venice, LAJun 14, 1980 · N27896 · Substantial damage NTSB FTW80DRJ23Accident · No injuriesClosedCessna 188B · Newellton, LAJun 8, 1980 · N731QD · Substantial damage NTSB FTW80DA084Accident · 1 fatalClosedBell 212 · Intracstl City, LAJun 8, 1980 · N68AL · No damage NTSB FTW80FRD39Accident · Serious injuriesClosedBellanca 7ECA · Vinton, LAJun 7, 1980 · N5030V · Destroyed NTSB FTW80DRD38Accident · No injuriesClosedBeech 77 · Grand Isle, LAJun 7, 1980 · N6713Z · Substantial damage NTSB FTW80DRD40Accident · No injuriesClosedCessna 172 · Delacroix, LAJun 5, 1980 · N4478R · Destroyed NTSB FTW80DRD36Accident · No injuriesClosedCessna 185 · Morgan City, LAJun 3, 1980 · N70087 · Substantial damage NTSB FTW80FA081Accident · No injuriesClosedBell 206B · Intercstl City, LAJun 1, 1980 · N59541 · Substantial damage NTSB FTW80FRJ22Accident · No injuriesClosedAero-Comdr S-2R · Cheneyville, LAMay 31, 1980 · N5516X · Substantial damage NTSB FTW80FRJ21Accident · No injuriesClosedBellanca 17-31A · Shreveport, LAMay 29, 1980 · N93719 · Destroyed NTSB FTW80DRD35Accident · Minor injuriesClosedAirtractor AT301 · Eunice, LAMay 26, 1980 · N4411S · Substantial damage NTSB FTW80DA079Accident · Minor injuriesClosedHughes 369D · Houma, LAMay 25, 1980 · N58250 · Substantial damage NTSB FTW80FRD34Accident · No injuriesClosedCessna 180 · New Iberia, LAMay 22, 1980 · N9997N · Substantial damage NTSB FTW80DRD33Accident · No injuriesClosedGrumman G-164A · Kinder, LAMay 16, 1980 · N4846 · Substantial damage NTSB FTW80DA078Accident · No injuriesClosedPiper PA32RT · Pineville, LAMay 16, 1980 · N36546 · Substantial damage NTSB FTW80DRJ20Accident · Minor injuriesClosedCessna 188 · Jonesville, LAMay 12, 1980 · N731UM · Substantial damage NTSB FTW80DRJ19Accident · No injuriesClosedCessna 175 · Bastrop, LAMay 11, 1980 · N8134T · Substantial damage NTSB FTW80DA072Accident · 1 fatalClosedBell 206B · Intracstl Cy, LAMay 9, 1980 · N90095 · Substantial damage