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 MIA65A0114Accident · 1 fatalClosedCessna 175 · Houma, LAMay 19, 1965 · N6963E · Destroyed NTSB FTW66D0041Accident · Minor injuriesClosedCessna 185 · Morgan City, LAMay 18, 1965 · N2689Z · Destroyed NTSB FTW65F0041Accident · No injuriesClosedBeechcraft C-35 · Hammond, LAMay 15, 1965 · N634D · Substantial damage NTSB FTW66D0049Accident · No injuriesClosedCessna 175 · Bastrop, LAMay 10, 1965 · N9378B · Substantial damage NTSB FTW66F0072Accident · No injuriesClosedPiper PA-28 · Newellton, LAMay 9, 1965 · N6038W · Substantial damage NTSB FTW66F0037Accident · Serious injuriesClosedMooney M20C · Hall Summit, LAMay 9, 1965 · N6732U · Substantial damage NTSB FTW66D0024Accident · No injuriesClosedGrumman G-164 · Esterwood, LAMay 6, 1965 · N520Y · Substantial damage NTSB FTW66F0150Accident · Serious injuriesClosedFairchild PT-19 · Farmerville, LAApr 25, 1965 · N46410 · Destroyed NTSB FTW65F0007Accident · No injuriesClosedCessna 180 · Westwego, LAApr 22, 1965 · N2101Z · Substantial damage NTSB FTW65F0054Accident · No injuriesClosedGrumman G-164 · Welsh, LAApr 21, 1965 · N10244 · Substantial damage NTSB FTW65D0051Accident · No injuriesClosedBoeing B-75N1 · Lake Charles, LAApr 20, 1965 · N9412N · Substantial damage NTSB FTW65F0028Accident · No injuriesClosedPiper PA-16 · Monroe, LAApr 19, 1965 · N5887H · Substantial damage NTSB FTW65D0050Accident · No injuriesClosedBoeing E-75 · Crowley, LAApr 19, 1965 · N66290 · Substantial damage NTSB FTW65D0027Accident · No injuriesClosedCessna 150 · Kaplan, LAApr 18, 1965 · N6040T · Destroyed NTSB FTW65A0104Accident · 3 fatalClosedCessna 120 · Plaquemine, LAApr 18, 1965 · N77380 · Destroyed NTSB FTW65A0105Accident · Minor injuriesClosedBell 47G2 · Marsh Island, LAApr 17, 1965 · N13658 · Substantial damage NTSB FTW65F0046Accident · Serious injuriesClosedGrumman G164 · Kaplan, LAApr 16, 1965 · N590Y · 2 aircraft · Destroyed NTSB FTW65F0006Accident · Serious injuriesClosedGrumman G-44A · Abbeville, LAApr 16, 1965 · N86627 · Minor damage NTSB FTW65A0101Accident · 1 fatalClosedCessna 182 · Lafayette, LAApr 10, 1965 · N8722X · No damage NTSB FTW65F0043Accident · No injuriesClosedBeechcraft M-35 · New Orleans, LAApr 7, 1965 · N9734R · Substantial damage NTSB FTW65F0014Accident · Minor injuriesClosedGrumman G-164 · Crowley, LAApr 7, 1965 · N406Y · Substantial damage NTSB FTW65F0017Accident · No injuriesClosedMooney M20C · Welsh, LAApr 6, 1965 · N7862V · Substantial damage NTSB FTW66F0136Accident · No injuriesClosedMooney M20C · Baton Rouge, LAApr 1, 1965 · N6673R · Substantial damage NTSB FTW66D0011Accident · No injuriesClosedCessna 180G · E Timbalier Is, LAMar 19, 1965 · N4682U · Substantial damage NTSB UNK65X1473Accident · No injuriesClosedCessna 172 · Elizabeth, LAMar 17, 1965 · N8416U · Substantial damage NTSB FTW66F0005Accident · No injuriesClosedPiper PA-24 · Baton Rouge, LAMar 8, 1965 · N8086P · Substantial damage NTSB FTW66D0004Accident · Minor injuriesClosedCessna 180B · Empire, LAMar 7, 1965 · N5298E · Substantial damage NTSB FTW66D0202Accident · No injuriesClosedCessna 172 · Chandeleur Isl, LAMar 2, 1965 · N8125X · Substantial damage NTSB UNK65X1435Accident · No injuriesClosedPiper PA-28 · Lake Charles, LAFeb 18, 1965 · N7300W · Substantial damage NTSB UNK65X1424Accident · No injuriesClosedCessna 210 · Baton Rouge, LAFeb 15, 1965 · N9673T · Substantial damage NTSB UNK65X1423Accident · No injuriesClosedCessna 175 · Abbeville, LAFeb 14, 1965 · N6681E · Substantial damage NTSB UNK65X1422Accident · No injuriesClosedCessna 172 · Church Point, LAFeb 14, 1965 · N2945U · Substantial damage NTSB UNK65X1413Accident · No injuriesClosedCessna 180 · Leeville, LAFeb 10, 1965 · N9311T · Substantial damage NTSB UNK65X1378Accident · No injuriesClosedCessna 172A · Lake Charles, LAFeb 1, 1965 · N21965 · Substantial damage NTSB UNK65X1371Accident · No injuriesClosedPiper J4A · Bastrop, LAJan 29, 1965 · N28235 · Destroyed NTSB UNK65X1339Accident · No injuriesClosedPiper PA24 · Lake Charles, LAJan 24, 1965 · N5623P · Substantial damage NTSB UNK65X1321Accident · No injuriesClosedCessna 310I · Monroe, LAJan 20, 1965 · N8088M · Substantial damage NTSB FTW65A0074Accident · 2 fatalClosedPiper J3 · Kaplan, LAJan 17, 1965 · N7404 · Destroyed NTSB FTW65A0073Accident · No injuriesClosedBrantly B2B · New Orleans, LAJan 14, 1965 · N2162U · Substantial damage NTSB FTW65A0071Accident · No injuriesClosedBell 47J2 · Venice, LAJan 12, 1965 · N513T · Destroyed NTSB UNK65X1263Accident · No injuriesClosedPiper PA24 · Baton Rouge, LAJan 10, 1965 · N7812P · Substantial damage NTSB FTW65A0070Accident · 1 fatalClosedBell 47J2 · Morgan City, LAJan 9, 1965 · N73253 · Destroyed NTSB UNK65X1172Accident · No injuriesClosedPiper PA-24 · Opelousas, LADec 28, 1964 · N6994P · Substantial damage NTSB UNK65X1154Accident · No injuriesClosedCessna 172 · Galiano, LADec 27, 1964 · N2519U · Substantial damage NTSB UNK65X1134Accident · 1 fatalClosedPiper PA15 · Denham Springs, LADec 25, 1964 · N4360H · Destroyed NTSB UNK65X1127Accident · No injuriesClosedBeechraft T34A · Jonesboro, LADec 25, 1964 · N1007B · Substantial damage NTSB UNK65X1123Accident · No injuriesClosedBell 47J · Intracoastal C, LADec 24, 1964 · N6771D · Substantial damage NTSB UNK65X1048Accident · No injuriesClosedBeechcraft 35-33 · Mansfield, LADec 19, 1964 · N939T · Destroyed NTSB UNK65X1023Accident · No injuriesClosedCessna 310B · Shreveport, LADec 15, 1964 · N5363A · Substantial damage NTSB UNK65X0996Accident · Minor injuriesClosedCessna 185 · Buras, LADec 13, 1964 · N2690Z · Substantial damage