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 FTW69D0016Accident · Minor injuriesClosedBoeing E75 · Jennings, LAJun 18, 1968 · N1332M · Substantial damage NTSB FTW69F0015Accident · No injuriesClosedPiper J3C-65 · New Orleans, LAJun 17, 1968 · N48810 · Substantial damage NTSB FTW69D0029Accident · No injuriesClosedLake LA-4 · Clayton, LAJun 14, 1968 · N7603L · Substantial damage NTSB FTW69F0014Accident · 1 fatalClosedSnow S2C · Ville Platte, LAJun 13, 1968 · N1618S · Substantial damage NTSB FTW68D0618Accident · No injuriesClosedSnow S2C · Lake Arthur, LAJun 10, 1968 · N1652S · Substantial damage NTSB FTW69D0011Accident · No injuriesClosedBoeing A75 · Sulphur, LAJun 7, 1968 · N48761 · Substantial damage NTSB FTW69F0010Accident · No injuriesClosedPiper PA-23 · Alexandria, LAJun 5, 1968 · N6033Y · Substantial damage NTSB FTW68F0602Accident · No injuriesClosedCessna 180E · Breaux Bridge, LAJun 5, 1968 · N2624Y · Destroyed NTSB FTW68D0601Accident · No injuriesClosedCessna 150 · Lafayette, LAJun 3, 1968 · N3239X · Substantial damage NTSB FTW68A0103Accident · 1 fatalClosedBell 206A · Morgan City, LAJun 3, 1968 · N7943S · Destroyed NTSB FTW69F0020Accident · No injuriesClosedGrumman G-164 · Delcambre, LAMay 30, 1968 · N460RF · Substantial damage NTSB FTW68D0596Accident · Minor injuriesClosedPiper J3 · Andrews, LAMay 27, 1968 · N70421 · Substantial damage NTSB FTW68A0098Accident · 1 fatalClosedPiper J5A · Lafayette, LAMay 26, 1968 · N35379 · Destroyed NTSB FTW69F0042Accident · No injuriesClosedGrumman G-164 · Jones, LAMay 24, 1968 · N484Y · Substantial damage NTSB FTW68F0612Accident · Serious injuriesClosedTaylorcraft DC-65 · Mamou, LAMay 24, 1968 · N47847 · Substantial damage NTSB FTW68A0096Accident · 1 fatalClosedGrumman G-44A · Lafitte, LAMay 24, 1968 · N41982 · Destroyed NTSB FTW68D0595Accident · No injuriesClosedGrumman G-164 · Gueydan, LAMay 23, 1968 · N10278 · Substantial damage NTSB FTW68D0594Accident · Minor injuriesClosedPiper PA-12 · State Line, LAMay 21, 1968 · N3135M · Substantial damage NTSB FTW68F0593Accident · No injuriesClosedCessna 180 · Grand Isle, LAMay 20, 1968 · N9929V · Substantial damage NTSB FTW68A0094Accident · 1 fatalClosedChampion 7AC · Tallulah, LAMay 19, 1968 · N82401 · Destroyed NTSB FTW68D0589Accident · No injuriesClosedGrumman G-164 · Reddell, LAMay 17, 1968 · N10292 · Substantial damage NTSB FTW68A0092Accident · No injuriesClosedBell 47G-4 · Leeville, LAMay 17, 1968 · N1331X · Substantial damage NTSB FTW69D0037Accident · No injuriesClosedTaylorcraft BC-65 · Lake Charles, LAMay 12, 1968 · N27497 · Substantial damage NTSB FTW68F0587Accident · No injuriesClosedGrumman G-164 · Elton, LAMay 8, 1968 · N10275 · Substantial damage NTSB FTW69F0001Accident · No injuriesClosedChampion 7FC · Oak Grove, LAMay 5, 1968 · N4851E · Substantial damage NTSB FTW68F0584Accident · No injuriesClosedStinson 108-2 · Alexandria, LAMay 5, 1968 · N361C · Substantial damage NTSB FTW68F0582Accident · No injuriesClosedGrumman G-164 · Lawtel, LAMay 4, 1968 · N10249 · Substantial damage NTSB FTW68D0580Accident · No injuriesClosedCessna 150 · Baton Rouge, LAMay 4, 1968 · N6405F · Substantial damage NTSB FTW68D0579Accident · No injuriesClosedGrumman G-164 · Kaplan, LAMay 2, 1968 · N10281 · Substantial damage NTSB FTW68D0569Accident · Minor injuriesClosedCessna 185 · Houma, LAMay 2, 1968 · N3357L · Substantial damage NTSB FTW68F0573Accident · No injuriesClosedErco 415-G · Bogalusa, LAApr 27, 1968 · N94883 · Substantial damage NTSB FTW68F0561Accident · No injuriesClosedCessna 150G · Welsh, LAApr 25, 1968 · N3242X · Substantial damage NTSB FTW68D0538Accident · No injuriesClosedCessna 180 · Port Sulphur, LAApr 25, 1968 · N2453F · Substantial damage NTSB FTW68D0537Accident · Minor injuriesClosedBoeing A75 · Maxie, LAApr 25, 1968 · N88853 · Substantial damage NTSB FTW68D0558Accident · No injuriesClosedGrumman G164 · Oberlin, LAApr 23, 1968 · N591Y · Substantial damage NTSB FTW68D0535Accident · No injuriesClosedGrumman G-164 · Eunice, LAApr 21, 1968 · N701Y · Substantial damage NTSB FTW68D0533Accident · No injuriesClosedBoeing A75 · Lake Charles, LAApr 19, 1968 · N46888 · Substantial damage NTSB FTW68F0520Accident · Minor injuriesClosedMooney M20F · Many, LAApr 16, 1968 · N6361Q · Substantial damage NTSB FTW68F0551Accident · No injuriesClosedCessna 150 · New Orleans, LAApr 14, 1968 · N6650F · Substantial damage NTSB FTW68D0519Accident · No injuriesClosedStearman A75 · Mamou, LAApr 12, 1968 · N55022 · Substantial damage NTSB FTW68F0517Accident · No injuriesClosedGrumman G-164A · Mamou, LAApr 6, 1968 · N967X · Substantial damage NTSB FTW68F0503Accident · No injuriesClosedBoeing E75 · Vidrine, LAApr 1, 1968 · N59270 · Substantial damage NTSB FTW68F0490Accident · Minor injuriesClosedCessna 150 · Walker, LAMar 30, 1968 · N3412J · Substantial damage NTSB FTW68A0083Accident · No injuriesClosedBell 47G-2A · Leeville, LAMar 30, 1968 · N74096 · Substantial damage NTSB FTW68F0515Accident · No injuriesClosedPiper PA-30 · Alexandria, LAMar 29, 1968 · N7991Y · Substantial damage NTSB FTW68F0501Accident · Minor injuriesClosedBoeing E75 · Elton, LAMar 20, 1968 · N4590N · Substantial damage NTSB FTW68F0477Accident · No injuriesClosedGrumman G-164 · Welsh, LAMar 13, 1968 · N657U · Destroyed NTSB FTW68D0485Accident · Minor injuriesClosedPiper PA-18 · Mer Rouge, LAMar 6, 1968 · N3883Z · Destroyed NTSB FTW68D0456Accident · No injuriesClosedPiper J-3 · Ruston, LAFeb 26, 1968 · N1459N · Substantial damage NTSB FTW68D0468Accident · No injuriesClosedTaylorcraft BC-65 · Bossier City, LAFeb 24, 1968 · N24439 · Substantial damage