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 FTW69F0370Accident · No injuriesClosedCessna 140 · Cecilia, LAJan 19, 1969 · N2187N · Substantial damage NTSB FTW69D0359Accident · No injuriesClosedPiper PA-28 · Amelia, LAJan 17, 1969 · N7448R · Substantial damage NTSB FTW69D0344Accident · No injuriesClosedCessna 150G · Alexandria, LAJan 11, 1969 · N3282J · Substantial damage NTSB FTW69F0331Accident · No injuriesClosedBell 47G-2A · Shreveport, LAJan 7, 1969 · N73219 · Destroyed NTSB FTW69F0366Accident · No injuriesClosedCessna 177 · Baton Rouge, LAJan 4, 1969 · N29655 · Substantial damage NTSB FTW69F0350Accident · No injuriesClosedBeech M35 · Pineville-La, LAJan 2, 1969 · N9310Y · Substantial damage NTSB FTW69D0351Accident · No injuriesClosedAeronca 7AC · Florien, LAJan 2, 1969 · N84543 · Substantial damage NTSB FTW69A0046Accident · 5 fatalClosedPiper PA-24 · Oakdale, LADec 30, 1968 · N7702P · Destroyed NTSB FTW69F0373Accident · No injuriesClosedCessna 172 · Oak Grove, LADec 28, 1968 · N7281A · Substantial damage NTSB FTW69F0319Accident · Serious injuriesClosedGrumman G-44 · Lutcher, LADec 27, 1968 · N111W · Substantial damage NTSB FTW69D0342Accident · No injuriesClosedBeech A23 · Spearsville, LADec 22, 1968 · N2396L · Substantial damage NTSB FTW69D0334Accident · No injuriesClosedSikorsky H-19G · Covington, LADec 17, 1968 · N1029 · Substantial damage NTSB FTW69F0326Accident · No injuriesClosedCessna 150F · New Orleans, LADec 14, 1968 · N3521L · Substantial damage NTSB FTW69D0314Accident · No injuriesClosedCessna 337 · Newellton, LADec 9, 1968 · N5340S · Substantial damage NTSB FTW69D0313Accident · No injuriesClosedCessna 172 · Lake Charles, LADec 7, 1968 · N8058L · Substantial damage NTSB FTW69F0306Accident · No injuriesClosedCessna 150F · Alexandria, LANov 23, 1968 · N8092S · Substantial damage NTSB FTW69D0285Accident · No injuriesClosedCessna 180 · Berwick, LANov 23, 1968 · N8230V · Substantial damage NTSB FTW69F0305Accident · Serious injuriesClosedChampion 7FC · Jones, LANov 21, 1968 · N9001B · Destroyed NTSB FTW69D0276Accident · Minor injuriesClosedCessna 150H · Baton Rouge, LANov 20, 1968 · N6743S · Substantial damage NTSB FTW69D0300Accident · No injuriesClosedCessna 180C · Leeville, LANov 9, 1968 · N9356T · Substantial damage NTSB FTW69F0266Accident · Minor injuriesClosedGrumman G-44 · Belle Chasse, LANov 1, 1968 · N70U · Substantial damage NTSB FTW69F0290Accident · No injuriesClosedPiper PA-28 · Natchitoches, LAOct 30, 1968 · N6541J · Substantial damage NTSB FTW69D0272Accident · No injuriesClosedCessna 182 · Labadieville, LAOct 25, 1968 · N3261S · Substantial damage NTSB FTW69F0262Accident · Minor injuriesClosedLuscombe 8A · Slidell, LAOct 20, 1968 · N1123K · Destroyed NTSB FTW69D0288Accident · No injuriesClosedPiper PA-25 · Wisner, LAOct 19, 1968 · N7226Z · Substantial damage NTSB FTW69D0287Accident · Minor injuriesClosedBeech J35 · Natchitoches, LAOct 16, 1968 · N523B · Substantial damage NTSB FTW69F0244Accident · No injuriesClosedSikorsky H-19G · Mandeville, LAOct 1, 1968 · N1023 · Substantial damage NTSB FTW69D0193Accident · No injuriesClosedAeronca L-16 · Slidell, LASep 29, 1968 · N4018B · Substantial damage NTSB FTW69D0211Accident · No injuriesClosedChampion 7FC · Collinston, LASep 21, 1968 · N7532E · Substantial damage NTSB FTW69D0181Accident · No injuriesClosedPiper PA-25 · Pioneer, LASep 18, 1968 · N4618Y · Destroyed NTSB FTW69D0237Accident · No injuriesClosedGrumman G-164A · Ferriday, LASep 16, 1968 · N930X · Substantial damage NTSB FTW69F0160Accident · Minor injuriesClosedBoeing A75N1 · Lecompte, LASep 7, 1968 · N61618 · Substantial damage NTSB FTW69F0158Accident · No injuriesClosedPiper PA-25 · St.Joseph, LASep 7, 1968 · N4668Y · Substantial damage NTSB FTW69F0346Accident · No injuriesClosedGrumman G-164 · Jeanerette, LAAug 17, 1968 · N468RF · Substantial damage NTSB FTW69D0113Accident · No injuriesClosedGrumman G-164 · Lydia, LAAug 12, 1968 · N462RF · Substantial damage NTSB FTW69F0161Accident · No injuriesClosedSikorsky S-62A · Grand Isle, LAAug 11, 1968 · N59224 · Substantial damage NTSB FTW69D0138Accident · No injuriesClosedPiper PA-28 · Dixie, LAAug 3, 1968 · N1857J · Substantial damage NTSB FTW69D0144Accident · No injuriesClosedPiper PA-25 · Gilbert, LAAug 1, 1968 · N4622Y · Substantial damage NTSB FTW69F0075Accident · Minor injuriesClosedBoeing A75 · Bossier City, LAJul 30, 1968 · N52549 · Substantial damage NTSB FTW69F0090Accident · Serious injuriesClosedMooney M20E · Jackson, LAJul 28, 1968 · N3217F · Substantial damage NTSB FTW69D0117Accident · No injuriesClosedGrumman G-73 · Grand Isle, LAJul 23, 1968 · N1627 · Substantial damage NTSB FTW69F0061Accident · No injuriesClosedPiper PA-25 · Cheneyville, LAJul 22, 1968 · N4414Y · Substantial damage NTSB FTW69D0056Accident · No injuriesClosedCessna 180 · Houma, LAJul 20, 1968 · N751MC · Substantial damage NTSB FTW69F0051Accident · No injuriesClosedTaylorcraft BC12-D · Amelia, LAJul 19, 1968 · N43328 · Substantial damage NTSB FTW69F0063Accident · No injuriesClosedLuscombe 8A · Slidell, LAJul 12, 1968 · N37055 · Substantial damage NTSB FTW69F0045Accident · No injuriesClosedPiper PA-25 · Newellton, LAJul 9, 1968 · N4732Y · Substantial damage NTSB FTW69D0050Accident · No injuriesClosedAero Cmdr 600S-2 · Luling, LAJul 6, 1968 · N1711S · Substantial damage NTSB FTW69F0036Accident · No injuriesClosedPiper PA-25 · Bosco, LAJul 5, 1968 · N7088Z · Substantial damage NTSB FTW69F0034Accident · Serious injuriesClosedPiper J3C-65 · Gueydan, LAJun 26, 1968 · N3255N · Substantial damage NTSB FTW68F0620Accident · No injuriesClosedCessna 310 · Freemason Isle, LAJun 23, 1968 · N6939T · Substantial damage