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 FTW68A0019Accident · 4 fatalClosedBell 206A · Morgan City, LAAug 15, 1967 · N7846S · Destroyed NTSB FTW68F0105Accident · No injuriesClosedPiper PA-18 · Crowville, LAAug 14, 1967 · N3863Z · Substantial damage NTSB FTW68D0204Accident · No injuriesClosedGrumman G-164 · Rayville, LAAug 8, 1967 · N516Y · Substantial damage NTSB FTW68F0104Accident · No injuriesClosedCessna 180A · Patterson, LAAug 7, 1967 · N152S · 2 aircraft · Substantial damage NTSB FTW68F0103Accident · No injuriesClosedPiper PA-25 · Belle Rose, LAAug 4, 1967 · N7759Z · Substantial damage NTSB FTW68D0102Accident · No injuriesClosedCessna 172 · Freemason Isle, LAAug 2, 1967 · N3679S · Substantial damage NTSB FTW68F0075Accident · No injuriesClosedPiper PA-25 · Sterlington, LAJul 30, 1967 · N4580Y · Substantial damage NTSB FTW68F0100Accident · No injuriesClosedGrunman G-164 · Marinquin, LAJul 28, 1967 · N466RF · Substantial damage NTSB FTW68A0009Accident · 1 fatalClosedPiper PA-25 · Oak Grove, LAJul 27, 1967 · N7455Z · Substantial damage NTSB FTW68F0122Accident · Serious injuriesClosedTaylorcraft DCO-65 · Bonita, LAJul 25, 1967 · N52502 · Substantial damage NTSB FTW68D0049Accident · No injuriesClosedCessna 185C · New Iberia, LAJul 18, 1967 · N2679Z · Substantial damage NTSB FTW68F0048Accident · No injuriesClosedPiper PA-28 · Amelia, LAJul 15, 1967 · N7448R · Substantial damage NTSB FTW68A0004Accident · No injuriesClosedBell 204-B · Laplace, LAJul 15, 1967 · N7931S · Substantial damage NTSB FTW68D0074Accident · No injuriesClosedBoeing B75N1 · Powhatten, LAJul 14, 1967 · N64979 · Substantial damage NTSB FTW68F0112Accident · No injuriesClosedCessna 150 · Alexandria, LAJul 12, 1967 · N7805Z · Substantial damage NTSB FTW68F0032Accident · No injuriesClosedPiper PA-25 · Supreme, LAJul 12, 1967 · N6519Z · Substantial damage NTSB FTW68D0030Accident · No injuriesClosedCessna 150 · New Orleans, LAJul 8, 1967 · N6691F · Substantial damage NTSB FTW68A0013Accident · No injuriesClosedBensen B8M · Slidell, LAJul 8, 1967 · N1016 · Substantial damage NTSB FTW68F0064Accident · No injuriesClosedAero Comdr 200D · Baton Rouge, LAJul 3, 1967 · N2902T · Substantial damage NTSB FTW68D0018Accident · No injuriesClosedN American SNJ-5 · Opelousas, LAJun 24, 1967 · N3267G · Substantial damage NTSB FTW68D0041Accident · No injuriesClosedPiper PA-25 · Belle Rose, LAJun 22, 1967 · N4493Y · Substantial damage NTSB FTW67F0019Accident · No injuriesClosedCessna 150 · Houma, LAJun 19, 1967 · N7150F · Substantial damage NTSB FTW68D0040Accident · No injuriesClosedGrumman G-164 · Epps, LAJun 16, 1967 · N498Y · Substantial damage NTSB FTW67D0648Accident · No injuriesClosedCessna 172 · Luling, LAJun 15, 1967 · N1623F · Substantial damage NTSB FTW67A0119Accident · Minor injuriesClosedSikorsky S-55 · Laplace, LAJun 12, 1967 · N751A · Substantial damage NTSB FTW67A0118Accident · No injuriesClosedSikorsky HRS-1 · Laplace, LAJun 12, 1967 · N4957S · Substantial damage NTSB FTW67F0650Accident · No injuriesClosedCessna 172 · Freemason Isle, LAJun 11, 1967 · N7983U · Substantial damage NTSB FTW67A0117Accident · 1 fatalClosedBoeing A75 · Vinton, LAJun 10, 1967 · N50076 · 2 aircraft · Destroyed NTSB FTW67D0651Accident · No injuriesClosedBoeing B75N-1 · Crowley, LAJun 9, 1967 · N75261 · Substantial damage NTSB FTW68F0013Accident · No injuriesClosedFairchild M-62-A · Eunice, LAJun 7, 1967 · N54112 · Substantial damage NTSB FTW67F0646Accident · No injuriesClosedChampion 7EC · Winnsboro, LAJun 4, 1967 · N4364C · Destroyed NTSB FTW68D0036Accident · Serious injuriesClosedGrumman G-164 · Gueydan, LAMay 31, 1967 · N515Y · Substantial damage NTSB FTW67A0116Accident · 1 fatalClosedBeech E35 · Crowley, LAMay 31, 1967 · N7372B · Destroyed NTSB FTW67A0115Accident · 1 fatalClosedCessna 206 · Alexandria, LAMay 30, 1967 · N3462L · Substantial damage NTSB FTW67A0113Accident · 1 fatalClosedCessna 172F · Houma, LAMay 30, 1967 · N8806U · Substantial damage NTSB FTW68D0022Accident · No injuriesClosedCessna 210 · Rayville, LAMay 29, 1967 · N6678X · Substantial damage NTSB FTW68D0020Accident · No injuriesClosedBoeing A75N1 · Lake Charles, LAMay 27, 1967 · N1013M · Substantial damage NTSB FTW67D0626Accident · No injuriesClosedCessna 172 · Chandeleur Isl, LAMay 27, 1967 · N4021F · Substantial damage NTSB FTW67A0112Accident · No injuriesClosedHughes 269A · New Orleans, LAMay 25, 1967 · N8808F · Substantial damage NTSB FTW67F0663Accident · No injuriesClosedSnow 600S2C · Mamou, LAMay 24, 1967 · N1624S · Substantial damage NTSB FTW67D0597Accident · No injuriesClosedPiper PA-32 · Baton Rouge, LAMay 19, 1967 · N3591W · Substantial damage NTSB FTW67F0617Accident · No injuriesClosedCessna 185C · Houma, LAMay 18, 1967 · N5831T · Substantial damage NTSB FTW67D0616Accident · No injuriesClosedPiper PA-20 · Athens, LAMay 18, 1967 · N7057K · Substantial damage NTSB FTW67A0108Accident · 1 fatalClosedCessna 180 · Grand Chenier, LAMay 13, 1967 · N4745U · Destroyed NTSB FTW67F0595Accident · Minor injuriesClosedPiper PA-25 · Bonita, LAMay 12, 1967 · N7281Z · Destroyed NTSB FTW67D0594Accident · No injuriesClosedGrumman G-164 · Washington, LAMay 11, 1967 · N10240 · Substantial damage NTSB FTW67F0570Accident · No injuriesClosedGrumman G-164 · Church Point, LAMay 5, 1967 · N526Y · Substantial damage NTSB FTW67F0591Accident · Serious injuriesClosedCessna 172 · Haynesville, LAMay 3, 1967 · N7895U · Destroyed NTSB FTW67F1004Accident · Serious injuriesClosedCessna 150 · Kentwood, LAApr 30, 1967 · N7710F · Destroyed NTSB FTW67D0544Accident · No injuriesClosedBoeing E75 · Gueydan, LAApr 24, 1967 · N75266 · Substantial damage