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 FTW66F0384Accident · No injuriesClosedCessna 172 · Tallulah, LASep 30, 1965 · N7895U · Substantial damage NTSB FTW66D0324Accident · No injuriesClosedCessna 185 · Baton Rouge, LASep 25, 1965 · N5885T · Substantial damage NTSB FTW66F0312Accident · Serious injuriesClosedCessna 150 · Westwego, LASep 23, 1965 · N4323U · Substantial damage NTSB FTW66D0323Accident · No injuriesClosedBeechcraft M-23 · Afton, LASep 20, 1965 · N3551R · Substantial damage NTSB FTW66D0322Accident · No injuriesClosedCessna 172 · New Orleans, LASep 19, 1965 · N1803Y · Substantial damage NTSB FTW66D0311Accident · No injuriesClosedPiper PA-18 · Slidell, LASep 16, 1965 · N7187Z · Substantial damage NTSB FTW66F0286Accident · No injuriesClosedChampion 7GC · Shreveport, LASep 8, 1965 · N8523E · Substantial damage NTSB FTW66F0479Accident · Serious injuriesClosedAeronca 11AC · Schriever, LASep 7, 1965 · N9049E · Substantial damage NTSB FTW66F0278Accident · No injuriesClosedCessna 195 · Bossier City, LASep 7, 1965 · N7807B · Destroyed NTSB FTW66F0253Accident · 1 fatalClosedPiper PA-25 · Bonita, LAAug 31, 1965 · N7281Z · 2 aircraft · Substantial damage NTSB FTW66D0272Accident · No injuriesClosedCessna 172 · De Quincy, LAAug 26, 1965 · N5621A · Substantial damage NTSB FTW66A0023Accident · 1 fatalClosedPiper PA-18A · Rayville, LAAug 26, 1965 · N4074Z · Destroyed NTSB FTW66F0247Accident · No injuriesClosedPiper PA-25 · Newellton, LAAug 20, 1965 · N6656Z · Substantial damage NTSB FTW66F0226Accident · No injuriesClosedBeechcraft 35 · Shreveport, LAAug 20, 1965 · N3105V · Substantial damage NTSB FTW66F0200Accident · No injuriesClosedPiper PA-25 · Sterlington, LAAug 18, 1965 · N7267Z · Substantial damage NTSB FTW66F0246Accident · No injuriesClosedGrumman G-164 · Maringouin, LAAug 17, 1965 · N463RF · Substantial damage NTSB FTW66A0018Accident · No injuriesClosedBell 47G4 · Intracostl Cty, LAAug 15, 1965 · N73263 · Substantial damage NTSB FTW66D0224Accident · No injuriesClosedCessna 210 · Baton Rouge, LAAug 14, 1965 · N2326F · Substantial damage NTSB FTW66F0198Accident · No injuriesClosedGrumman G-164 · Welsh, LAAug 11, 1965 · N10275 · Substantial damage NTSB FTW66F0195Accident · Serious injuriesClosedPiper PA-18A · Franklin, LAAug 9, 1965 · N6999D · Substantial damage NTSB FTW66F0192Accident · Minor injuriesClosedPiper PA-18A · Waterproof, LAAug 8, 1965 · N1629A · Destroyed NTSB FTW66F0265Accident · No injuriesClosedTaylorcraft L-2M · Covington, LAAug 7, 1965 · N50084 · Substantial damage NTSB FTW66F0170Accident · No injuriesClosedGrumman G-164 · Lakeland, LAAug 7, 1965 · N463RF · Substantial damage NTSB FTW66F0264Accident · No injuriesClosedBoeing A-75N1 · Houma, LAAug 5, 1965 · N1559M · Substantial damage NTSB FTW66F0167Accident · No injuriesClosedPiper PA-18 · Oak Grove, LAJul 25, 1965 · N8059C · Substantial damage NTSB FTW66F0182Accident · No injuriesClosedPiper PA-24 · New Orleans, LAJul 22, 1965 · N8188P · Substantial damage NTSB FTW66A0006Accident · 4 fatalClosedPiper PA-24 · Lake Charles, LAJul 22, 1965 · N7769P · Destroyed NTSB FTW66F0236Accident · Serious injuriesClosedBoeing B75 · Bosco, LAJul 20, 1965 · N5242N · Substantial damage NTSB FTW66F0138Accident · Serious injuriesClosedBoeing A-75 · Sulphur, LAJul 16, 1965 · N75227 · Destroyed NTSB FTW66D0157Accident · No injuriesClosedBeechcraft T-34A · Baton Rouge, LAJul 15, 1965 · N3889C · Substantial damage NTSB FTW66F0130Accident · No injuriesClosedPiper PA-25 · Newellton, LAJul 14, 1965 · N7175Z · Substantial damage NTSB FTW66F0156Accident · No injuriesClosedLuscombe 8A · Westwego, LAJul 13, 1965 · N71267 · Substantial damage NTSB FTW66F0129Accident · Minor injuriesClosedCessna 210-5A · Sicily Island, LAJul 13, 1965 · N4832U · Substantial damage NTSB FTW66D0260Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LAJul 10, 1965 · N8245W · Substantial damage NTSB FTW66F0145Accident · No injuriesClosedPiper J3C · Washington, LAJul 2, 1965 · N70930 · Substantial damage NTSB FTW66F0122Accident · No injuriesClosedNaval Acrft N3N-3 · Mamou, LAJul 2, 1965 · N45162 · Substantial damage NTSB FTW65A0128Accident · No injuriesClosedHiller UH-12B · Mer Rouge, LAJun 28, 1965 · N5307V · Destroyed NTSB FTW66D0152Accident · No injuriesClosedCessna 182 · Baton Rouge, LAJun 26, 1965 · N2477X · Substantial damage NTSB FTW66F0108Accident · Minor injuriesClosedTaylorcraft DC-65 · Monroe, LAJun 21, 1965 · N5337N · Destroyed NTSB FTW66F0053Accident · Minor injuriesClosedCessna 172 · Troy, LAJun 21, 1965 · N2758U · Destroyed NTSB FTW66D0066Accident · No injuriesClosedBoeing A-75N1 · Church Point, LAJun 11, 1965 · N5519 · Substantial damage NTSB FTW66D0065Accident · No injuriesClosedCessna 172 · Baton Rouge, LAJun 10, 1965 · N7902U · Substantial damage NTSB FTW66F0051Accident · No injuriesClosedGrumman G-164 · Tallulah, LAJun 8, 1965 · N10238 · Substantial damage NTSB FTW66D0093Accident · No injuriesClosedGrumman G-164 · Washington, LAJun 8, 1965 · N10240 · Substantial damage NTSB FTW66F0092Accident · No injuriesClosedGrumman G-164 · Eunice, LAJun 7, 1965 · N459Y · Substantial damage NTSB FTW66F0091Accident · No injuriesClosedSnow S-2C · Chataignier, LAJun 7, 1965 · N1624S · Substantial damage NTSB FTW66D0062Accident · No injuriesClosedBoeing E-75 · Eunice, LAMay 31, 1965 · N9984H · Destroyed NTSB FTW66D0029Accident · No injuriesClosedPiper PA-18 · Chandeleur Is, LAMay 26, 1965 · N4051Z · Substantial damage NTSB FTW66D0175Accident · No injuriesClosedCessna 170A · Jonesville, LAMay 21, 1965 · N8291A · Substantial damage NTSB FTW66D0061Accident · No injuriesClosedPiper PA-25 · Wisner, LAMay 21, 1965 · N6959Z · Substantial damage