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 FTW75AF036Accident · Minor injuriesClosedBell 47G-4A · Venice, LANov 30, 1974 · N7848S · Destroyed NTSB FTW75DRJ20Accident · No injuriesClosedGrumman G-164A · Natchitoches, LANov 22, 1974 · N7804 · Substantial damage NTSB FTW75AF034Accident · Serious injuriesClosedBoeing 727 · Grand Isle, LANov 17, 1974 · N4611 · No damage NTSB FTW75FRD14Accident · Minor injuriesClosedBeech 35-B33 · Belle Chasse, LAOct 27, 1974 · N460SR · Substantial damage NTSB FTW75FRD15Accident · No injuriesClosedCessna A185E · Westwego, LAOct 26, 1974 · N3365L · Substantial damage NTSB FTW75FRD12Accident · No injuriesClosedGrumman G-164A · Clinton, LAOct 21, 1974 · N5257 · Substantial damage NTSB FTW75FRJ17Accident · Minor injuriesClosedPiper PA-23 · Leesville, LAOct 19, 1974 · N1043P · Substantial damage NTSB FTW75FRD13Accident · 1 fatalClosedLockheed P-38L · Lafayette, LAOct 19, 1974 · N38LL · Destroyed NTSB FTW75DRD11Accident · No injuriesClosedCessna A185E · Patterson, LAOct 13, 1974 · N2212T · Substantial damage NTSB FTW75FRD10Accident · No injuriesClosedCessna 150 · Edgerly, LAOct 6, 1974 · N5930G · Substantial damage NTSB FTW75FRD09Accident · Minor injuriesClosedPiper PA-25 · Port Barre, LAOct 3, 1974 · N8938L · Destroyed NTSB FTW75FRD08Accident · No injuriesClosedAero Comdr 112 · Bellrose, LAOct 2, 1974 · N1060J · Substantial damage NTSB FTW75DRJ15Accident · Serious injuriesClosedCessna A188B · Simmesport, LASep 27, 1974 · N53375 · Destroyed NTSB FTW75AF016Accident · No injuriesClosedBrittnorman BN-2A · Baton Rouge, LASep 10, 1974 · N80CA · Substantial damage NTSB FTW75AF013Accident · 4 fatalClosedBeech P35 · Jena, LASep 1, 1974 · N6515R · Destroyed NTSB FTW75DRJ09Accident · No injuriesClosedPiper PA-25 · Simmesport, LAAug 24, 1974 · N4634Y · Substantial damage NTSB FTW75DRJ10Accident · Serious injuriesClosedPiper PA-25 · Lecompte, LAAug 23, 1974 · N4585Y · Destroyed NTSB FTW75DRJ11Accident · Serious injuriesClosedPiper PA-25 · Vidalia, LAAug 22, 1974 · N6970Z · Destroyed NTSB FTW74DRJ08Accident · Minor injuriesClosedCessna 150L · Vidalia, LAAug 21, 1974 · N18532 · Substantial damage NTSB FTW75FRJ07Accident · Minor injuriesClosedCessna A188B · Lk Providence, LAAug 20, 1974 · N9429G · Substantial damage NTSB FTW75FRD07Accident · Serious injuriesClosedCessna 210E · Renner, LAAug 20, 1974 · N2355F · Substantial damage NTSB FTW75FRJ05Accident · Serious injuriesClosedAero Comdr 600S2R · Lk Providence, LAAug 17, 1974 · N5507X · Substantial damage NTSB FTW75FRJ06Accident · 1 fatalClosedPiper PA-25 · Colfax, LAAug 16, 1974 · N8826L · Destroyed NTSB FTW75DRJ03Accident · No injuriesClosedCessna 188B · Mer Rouge, LAAug 10, 1974 · N5706G · Substantial damage NTSB FTW75AF006Accident · No injuriesClosedBell 206B · Grand Isle, LAAug 9, 1974 · N4111G · Destroyed NTSB FTW75FRD06Accident · No injuriesClosedGrumman G-164 · Branch, LAAug 6, 1974 · N631U · Substantial damage NTSB FTW75DRD04Accident · Minor injuriesClosedPiper PA-24 · Donaldsonville, LAAug 4, 1974 · N8573P · Substantial damage NTSB FTW75FRD05Accident · No injuriesClosedPiper PA-32 · Port Barre, LAJul 20, 1974 · N3765W · Substantial damage NTSB FTW75DRJ02Accident · No injuriesClosedCessna A188 · Mangham, LAJul 11, 1974 · N9921G · Substantial damage NTSB FTW75DRJ01Accident · Serious injuriesClosedPiper PA-25 · Winnsboro, LAJul 9, 1974 · N7011Z · Destroyed NTSB FTW75FRD03Accident · Minor injuriesClosedGrumman G-164 · Jeanerette, LAJul 8, 1974 · N464RF · Substantial damage NTSB FTW75FRD02Accident · 1 fatalClosedPiper PA-25 · Franklin, LAJul 2, 1974 · N6946Z · Destroyed NTSB FTW75DRD01Accident · No injuriesClosedGrumman G-164 · Lake Arthur, LAJul 1, 1974 · N471Y · Substantial damage NTSB FTW74FRD51Accident · Serious injuriesClosedCessna 177RG · New Orleans, LAJun 23, 1974 · N1965Q · Destroyed NTSB FTW74DRJ37Accident · No injuriesClosedPiper PA-25 · Collinston, LAJun 21, 1974 · N8791L · Substantial damage NTSB FTW74FRJ38Accident · Minor injuriesClosedGrumman G-164A · Mer Rouge, LAJun 19, 1974 · N6604 · Substantial damage NTSB FTW74DRD49Accident · No injuriesClosedBoeing A75N1 · Edgerly, LAJun 12, 1974 · N65361 · Substantial damage NTSB FTW74FRD50Accident · No injuriesClosedBoeing A75N1 · Elton, LAJun 11, 1974 · N75010 · Substantial damage NTSB FTW74FRD48Accident · No injuriesClosedGrumman G-164A · Kaplan, LAJun 10, 1974 · N9700 · Substantial damage NTSB FTW74DRD47Accident · No injuriesClosedGrumman G-164A · Mamou, LAJun 5, 1974 · N9522 · Substantial damage NTSB FTW74FRD46Accident · No injuriesClosedGrumman G-164A · Delcambre, LAJun 4, 1974 · N6639 · Substantial damage NTSB FTW74FRD45Accident · No injuriesClosedGrumman G-164A · Frey, LAJun 3, 1974 · N508Z · Substantial damage NTSB FTW74FRD42Accident · No injuriesClosedGrumman G-164A · Gueydan, LAMay 29, 1974 · N463RF · Substantial damage NTSB FTW74FRD41Accident · No injuriesClosedGrumman G-164A · Gueydan, LAMay 29, 1974 · N939X · Substantial damage NTSB FTW74DRD44Accident · Minor injuriesClosedCessna 172 · Chandeleur Is, LAMay 26, 1974 · N1655Y · Substantial damage NTSB FTW74DRJ35Accident · No injuriesClosedKaman Acft K-600 · Mer Rouge, LAMay 24, 1974 · N61757 · Destroyed NTSB FTW74FRD43Accident · No injuriesClosedPiper PA-36 · Chataignier, LAMay 23, 1974 · N55909 · Substantial damage NTSB FTW74DRJ36Accident · No injuriesClosedAmer Avco AA1-B · Blanchard, LAMay 23, 1974 · N9669L · Substantial damage NTSB FTW74DRD40Accident · Minor injuriesClosedGrumman G-164A · Morrow, LAMay 23, 1974 · N5268 · Substantial damage NTSB FTW74AF085Accident · 1 fatalClosedCessna 150L · Abita Springs, LAMay 21, 1974 · N10484 · Destroyed