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 FTW67A0035Accident · Serious injuriesClosedSikorsky S-62A · Morgan City, LASep 19, 1966 · N324Y · Destroyed NTSB FTW67F0253Accident · No injuriesClosedMooney M-18C · Monroe, LASep 18, 1966 · N4051 · Substantial damage NTSB FTW67D0204Accident · No injuriesClosedCessna 172 · Boyce, LASep 18, 1966 · N8233U · Substantial damage NTSB FTW67A0036Accident · 1 fatalClosedLuscombe 8A · Holly Ridge, LASep 18, 1966 · N25380 · Destroyed NTSB FTW67D0252Accident · No injuriesClosedPiper PA-22 · Cloutierville, LASep 12, 1966 · N4964Z · Substantial damage NTSB FTW67D0201Accident · No injuriesClosedCessna 140A · Springhill, LASep 11, 1966 · N5317C · Substantial damage NTSB FTW67F0196Accident · Minor injuriesClosedStinson 108 · St.Francisvlle, LASep 4, 1966 · N97163 · Substantial damage NTSB FTW67A0029Accident · 1 fatalClosedPiper J-3 · Morgan City, LASep 3, 1966 · N30746 · Destroyed NTSB FTW67D0192Accident · Minor injuriesClosedCessna 150 · Slaughter, LASep 1, 1966 · N6585F · Substantial damage NTSB FTW67F0185Accident · No injuriesClosedCessna 140A · Sikes, LAAug 25, 1966 · N5330C · Substantial damage NTSB FTW67D0137Accident · No injuriesClosedCessna 180 · Westwego, LAAug 18, 1966 · N2786X · Substantial damage NTSB FTW67D0138Accident · No injuriesClosedCessna 150 · Freemason Isle, LAAug 16, 1966 · N8459G · Substantial damage NTSB FTW67F0159Accident · No injuriesClosedPiper PA-18 · Vick, LAAug 11, 1966 · N3949Z · Substantial damage NTSB FTW67F0148Accident · Serious injuriesClosedCessna 150 · Gueydan, LAAug 7, 1966 · N6412Z · Destroyed NTSB FTW67F0157Accident · No injuriesClosedPiper PA-18 · Vick, LAAug 4, 1966 · N5390Y · Destroyed NTSB FTW67D0131Accident · No injuriesClosedPiper PA-18 · La Place, LAAug 2, 1966 · N1158C · Substantial damage NTSB FTW67F0124Accident · No injuriesClosedBeech 95-B55 · Shreveport, LAJul 26, 1966 · N275D · Substantial damage NTSB FTW67F0127Accident · Serious injuriesClosedAeronca 7AC · Lake Providenc, LAJul 25, 1966 · N82630 · Substantial damage NTSB FTW67A0018Accident · 2 fatalClosedPiper PA-18 · Cameron, LAJul 25, 1966 · N4101Z · 2 aircraft · Destroyed NTSB FTW67F0107Accident · No injuriesClosedBeech B35 · New Orleans, LAJul 22, 1966 · N5246C · Substantial damage NTSB FTW67F0096Accident · No injuriesClosedCessna 150F · Bogalusa, LAJul 16, 1966 · N8457G · Substantial damage NTSB FTW67D0070Accident · No injuriesClosedCessna 180 · St Martin, LAJul 14, 1966 · N9541B · Substantial damage NTSB FTW66F0094Accident · No injuriesClosedBoeing D75N1 · Tallulah, LAJul 14, 1966 · N75043 · Substantial damage NTSB FTW67D0067Accident · No injuriesClosedCessna 180 · Venice, LAJul 12, 1966 · N9227T · Substantial damage NTSB FTW67D0067Accident · Minor injuriesClosedCessna 185 · Houma, LAJul 10, 1966 · N1690Z · Substantial damage NTSB FTW67D0205Accident · No injuriesClosedGrumman G-164 · Mittie, LAJul 8, 1966 · N591Y · Substantial damage NTSB FTW67F0052Accident · No injuriesClosedBeech M35 · Shreveport, LAJul 2, 1966 · N9734R · Substantial damage NTSB FTW67F0063Accident · Minor injuriesClosedCessna 172G · Mandeville, LAJun 29, 1966 · N11B · Substantial damage NTSB FTW67D0069Accident · No injuriesClosedCessna 180 · Leeville, LAJun 29, 1966 · N2486F · Substantial damage NTSB FTW67F0324Accident · No injuriesClosedBoeing E75 · Kapaln, LAJun 28, 1966 · N4593N · Substantial damage NTSB FTW66A0119Accident · 1 fatalClosedBoeing A75N1 · Welsh, LAJun 26, 1966 · N4513N · Destroyed NTSB FTW67F0080Accident · Minor injuriesClosedPiper PA-28 · Dubach, LAJun 25, 1966 · N9041J · Destroyed NTSB FTW67F0025Accident · Serious injuriesClosedCessna 150 · Bogalusa, LAJun 25, 1966 · N8036S · Substantial damage NTSB FTW67D0045Accident · No injuriesClosedPiper PA-25 · Whiteville, LAJun 22, 1966 · N6566Z · Substantial damage NTSB FTW67A0117Accident · Minor injuriesClosedBell 47G-2A · Morgan City, LAJun 21, 1966 · N73233 · Destroyed NTSB FTW67F0013Accident · No injuriesClosedCessna 172 · Hackberry, LAJun 12, 1966 · N3719S · Substantial damage NTSB FTW67D0035Accident · Minor injuriesClosedBoeing A75N1 · Esterwood, LAJun 7, 1966 · N52856 · Substantial damage NTSB FTW66A0113Accident · No injuriesClosedBell 47G-2 · New Orleans, LAJun 5, 1966 · N6359X · Substantial damage NTSB FTW66D0706Accident · No injuriesClosedCessna 210 · Lafayette, LAJun 4, 1966 · N9675X · Substantial damage NTSB FTW66D0700Accident · Minor injuriesClosedPiper PA-22 · Freemason Isle, LAJun 4, 1966 · N6713P · Substantial damage NTSB FTW66F0686Accident · No injuriesClosedStinson 108-2 · Shreveport, LAJun 3, 1966 · N8012K · Substantial damage NTSB FTW67D0030Accident · No injuriesClosedCessna 182 · Crowley, LAMay 29, 1966 · N8583S · Substantial damage NTSB FTW66A0109Accident · 1 fatalClosedCessna 172 · Boyce, LAMay 28, 1966 · N5886A · Destroyed NTSB FTW66F0683Accident · No injuriesClosedPiper PA-28 · Metairie, LAMay 26, 1966 · N7533W · Substantial damage NTSB FTW66F0674Accident · No injuriesClosedPiper J3C-65 · Crowville, LAMay 19, 1966 · N26783 · Substantial damage NTSB FTW66F0673Accident · No injuriesClosedBoeing A7571 · Kaplan, LAMay 18, 1966 · N264HC · Substantial damage NTSB FTW67F0017Accident · No injuriesClosedPiper PA23 · Lafayette, LAMay 17, 1966 · N4121P · Substantial damage NTSB FTW66F0664Accident · No injuriesClosedCessna 172 · Newellton, LAMay 8, 1966 · N6941X · Substantial damage NTSB FTW66D0662Accident · No injuriesClosedPiper PA-25 · Basile, LAMay 7, 1966 · N7122Z · Substantial damage NTSB FTW66D0661Accident · No injuriesClosedPiper PA-28 · Minden, LAMay 7, 1966 · N8461W · Substantial damage