Skip to content

NTSB investigations, LA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 FTW73IF003Incident · Minor injuriesClosedBell 206A · Morgan City, LAJul 15, 1972 · N7944S · Minor damage NTSB FTW73FRJ03Accident · No injuriesClosedGrumman G-164A · Ferriday, LAJul 14, 1972 · N7355 · Substantial damage NTSB FTW73AF001Accident · 5 fatalClosedPiper PA-28 · Intrcoastl Cty, LAJul 4, 1972 · N8602W · Destroyed NTSB FTW72DRD39Accident · No injuriesClosedCessna 180H · Venice, LAJun 29, 1972 · N3461Y · Substantial damage NTSB FTW72AF087Accident · 2 fatalClosedBell 206B · Cameron, LAJun 28, 1972 · N1457W · Destroyed NTSB FTW72DRD38Accident · No injuriesClosedSnow S2C · Eunice, LAJun 26, 1972 · N1624S · Substantial damage NTSB FTW72DRJ31Accident · Serious injuriesClosedPiper PA-25 · Ferriday, LAJun 24, 1972 · N8719L · Destroyed NTSB FTW72DRD36Accident · No injuriesClosedGrumman G-164 · Welsh, LAJun 20, 1972 · N459RF · Substantial damage NTSB FTW72DRD35Accident · Minor injuriesClosedBoeing A75N1 · Elton, LAJun 20, 1972 · N59378 · Substantial damage NTSB FTW72AF086Accident · Minor injuriesClosedAlouette II SA318C · Venice, LAJun 20, 1972 · N6458 · Substantial damage NTSB FTW72DRD34Accident · No injuriesClosedPiper PA-22 · New Orleans, LAJun 17, 1972 · N5905D · Substantial damage NTSB FTW72DRD32Accident · No injuriesClosedCessna 206 · Lake Charles, LAJun 16, 1972 · N2515X · Substantial damage NTSB FTW72FRD30Accident · No injuriesClosedCessna 180 · Westwego, LAJun 10, 1972 · N2800T · Substantial damage NTSB FTW72DRJ30Accident · No injuriesClosedCessna 150 · Frierson, LAJun 7, 1972 · N6427G · Substantial damage NTSB FTW72AF083Accident · No injuriesClosedBeech 65-B80 · Baton Rouge, LAJun 5, 1972 · N284M · Substantial damage NTSB FTW72DRD28Accident · No injuriesClosedCessna 172 · Venice, LAMay 29, 1972 · N9114B · Substantial damage NTSB FTW72AF081Accident · 11 fatalClosedBell 205A-1 · Dulac, LAMay 29, 1972 · N2256W · Destroyed NTSB FTW72AF080Accident · 2 fatalClosedPiper PA-32 · Hammond, LAMay 23, 1972 · N7736J · Destroyed NTSB FTW72AF078Accident · 1 fatalClosedCessna 177 · Many, LAMay 18, 1972 · N3344T · Destroyed NTSB FTW72DRD29Accident · Minor injuriesClosedBoeing B75N1 · Mermentau, LAMay 17, 1972 · N50082 · Substantial damage NTSB FTW72AF076Accident · 4 fatalClosedBeech 95 · Zachary, LAMay 14, 1972 · N362 · Destroyed NTSB FTW72DRJ28Accident · No injuriesClosedCessna 150 · Bastrop, LAMay 10, 1972 · N5719G · Substantial damage NTSB FTW72FRD26Accident · 1 fatalClosedHughes 369 · Harahan, LAMay 9, 1972 · N9092F · Minor damage NTSB FTW72DRJ26Accident · No injuriesClosedBeech S35 · Winnfield, LAMay 9, 1972 · N5825K · Substantial damage NTSB FTW72DRD27Accident · No injuriesClosedPiper PA-12 · Boothville, LAMay 9, 1972 · N3666M · Substantial damage NTSB FTW72DRJ27Accident · No injuriesClosedGrumman G-164 · Lake Providnce, LAMay 8, 1972 · N696Y · Substantial damage NTSB FTW72AF074Accident · No injuriesClosedConvair 600 · Alexandria, LAMay 8, 1972 · N94236 · Substantial damage NTSB FTW72FRD25Accident · No injuriesClosedGrumman G-164 · Welsh, LAMay 6, 1972 · N10210 · Substantial damage NTSB FTW72FRD24Accident · No injuriesClosedBoeing A75N1 · Rayne, LAMay 4, 1972 · N59364 · Substantial damage NTSB FTW72FRD22Accident · Minor injuriesClosedBoeing 75 · Iowa, LAMay 1, 1972 · N46888 · Substantial damage NTSB FTW72DRD23Accident · No injuriesClosedHughes 369HS · Lafayette, LAApr 30, 1972 · N9071F · Substantial damage NTSB FTW72FRJ22Accident · Serious injuriesClosedPiper PA-22 · Downsville, LAApr 14, 1972 · N5012Z · Substantial damage NTSB FTW72AF063Accident · No injuriesClosedPiper PA-28 · Kenner, LAMar 28, 1972 · N3981T · Substantial damage NTSB FTW72DRJ21Incident · No injuriesClosedPiper PA-28 · Jonesville, LAMar 27, 1972 · N9440W · Minor damage NTSB FTW72DRD21Accident · Minor injuriesClosedCessna U206D · Labadieville, LAMar 23, 1972 · N71994 · Substantial damage NTSB FTW72DRD20Accident · Minor injuriesClosedCessna 172D · Lorcauville, LAFeb 28, 1972 · N2424Y · Substantial damage NTSB FTW72AF053Accident · 3 fatalClosedCessna 185C · Marksville, LAFeb 15, 1972 · N2659Z · Destroyed NTSB FTW72AF051Accident · No injuriesClosedS.N.I.A.S SA318C · Dulac, LAFeb 7, 1972 · N8262 · Substantial damage NTSB FTW72DRD19Accident · No injuriesClosedPiper PA-28 · Merryville, LAFeb 6, 1972 · N7736W · Substantial damage NTSB FTW72DRJ19Accident · No injuriesClosedCessna 210H · Cottonport, LAJan 14, 1972 · N5958F · Substantial damage NTSB LAX72AL043Accident · Serious injuriesClosedBoeing 747 · Lake Charles, LAJan 4, 1972 · N77772 · Minor damage NTSB FTW72DRJ17Accident · No injuriesClosedCessna 170B · Robson, LADec 25, 1971 · N2309D · Substantial damage NTSB FTW72DRD18Accident · No injuriesClosedCessna 172K · Gonzales, LADec 23, 1971 · N46421 · Substantial damage NTSB FTW72DRD17Accident · No injuriesClosedCessna A185E · Leeville, LADec 15, 1971 · N5818J · Substantial damage NTSB FTW72AF031Accident · 3 fatalClosedAero Comdr 680T · New Orleans, LADec 5, 1971 · N78D · Destroyed NTSB FTW72DRJ16Accident · No injuriesClosedCessna 170B · Tallulah, LADec 4, 1971 · N3165B · Substantial damage NTSB FTW72DRJ15Accident · Minor injuriesClosedCessna 172K · Jonesville, LANov 18, 1971 · N84612 · Destroyed NTSB FTW72FRJ14Accident · 1 fatalClosedCessna 150 · Monroe, LANov 12, 1971 · N7937E · No damage NTSB FTW72FRD16Accident · No injuriesClosedBoeing E75N1 · Elton, LANov 7, 1971 · N4874N · Substantial damage NTSB FTW72AF027Accident · No injuriesClosedCessna 180H · Grand Isle, LANov 4, 1971 · N4777U · Substantial damage