Skip to content

NTSB investigations, LA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW78FRD37Accident · No injuriesClosedGrumman G-164A · Pine Prairie, LAJun 13, 1978 · N5322 · Substantial damage NTSB FTW78DRJ21Accident · No injuriesClosedCessna 180J · Shreveport, LAJun 13, 1978 · N7801K · Substantial damage NTSB FTW78FRJ20Accident · No injuriesClosedCessna A188B · Jones, LAJun 12, 1978 · N4806Q · Destroyed NTSB FTW78DRD36Accident · Serious injuriesClosedGrumman G-164A · Kaplan, LAJun 12, 1978 · N9944 · Substantial damage NTSB FTW78DRD35Accident · No injuriesClosedCessna 188B · De Ridder, LAJun 12, 1978 · N731HQ · Substantial damage NTSB FTW78FRD34Accident · No injuriesClosedMooney M20E · St.Martinville, LAJun 9, 1978 · N1333W · Substantial damage NTSB FTW78DRD33Accident · No injuriesClosedGrumman G-164A · Basile, LAJun 8, 1978 · N5413 · Substantial damage NTSB FTW78FRD32Accident · No injuriesClosedCessna 421C · Baton Rouge, LAJun 2, 1978 · N37427 · Substantial damage NTSB FTW78DRJ19Accident · No injuriesClosedBeech A23 · Alexandria, LAMay 30, 1978 · N7664R · Substantial damage NTSB FTW78FRD31Accident · No injuriesClosedGrumman G-164A · Kaplan, LAMay 26, 1978 · N9508 · Substantial damage NTSB FTW78FRD30Accident · No injuriesClosedGrumman G-164A · Iowa, LAMay 23, 1978 · N9512 · Substantial damage NTSB FTW78DRD29Accident · No injuriesClosedGrumman G-164A · Iota, LAMay 17, 1978 · N8840H · Substantial damage NTSB FTW78DRD28Accident · No injuriesClosedGrumman G-164A · Oberlin, LAMay 16, 1978 · N8512H · Destroyed NTSB FTW78FRD27Accident · No injuriesClosedGrumman G-164 · Elton, LAMay 11, 1978 · N5413 · Substantial damage NTSB FTW78FRD25Accident · No injuriesClosedGrumman G-164A · Basile, LAMay 10, 1978 · N8605H · Substantial damage NTSB FTW78DRD26Accident · No injuriesClosedGrumman G-164A · Redell, LAMay 10, 1978 · N7227 · Substantial damage NTSB FTW78DRD24Accident · No injuriesClosedBell 206B · Intracstl City, LAApr 28, 1978 · N16718 · Substantial damage NTSB FTW78FA043Accident · 2 fatalClosedAero Comdr 1121A · Flatwoods, LAApr 27, 1978 · N250UA · Destroyed NTSB FTW78FRJ16Accident · Serious injuriesClosedW Pusher WAS 2 · Marksville, LAApr 26, 1978 · N73549 · Substantial damage NTSB FTW78DRJ17Accident · No injuriesClosedPiper PA-18 · Ferriday, LAApr 23, 1978 · N40520 · Substantial damage NTSB FTW78FRJ13Accident · No injuriesClosedBell 47-G2A · Dupont, LAApr 20, 1978 · N8484E · Destroyed NTSB FTW78DRD23Accident · Minor injuriesClosedBoeing A75N1 · Sweet Lake, LAApr 20, 1978 · N62418 · Substantial damage NTSB FTW78DRD22Accident · No injuriesClosedPiper PA-18 · Yacloskey, LAApr 15, 1978 · N5973D · Destroyed NTSB FTW78FAQ41Accident · 1 fatalClosedCessna 180J · New Orleans, LAApr 13, 1978 · N42210 · Destroyed NTSB FTW78DRD21Accident · No injuriesClosedGrumman G-164A · Abbeville, LAApr 8, 1978 · N9643 · Substantial damage NTSB FTW78FA040Accident · 1 fatalClosedCessna 182P · Ferriday, LAApr 7, 1978 · N52317 · Destroyed NTSB FTW78FRD20Accident · Serious injuriesClosedCulver LCA · Lafayette, LAApr 4, 1978 · N37825 · Substantial damage NTSB FTW78DRJ15Accident · No injuriesClosedGrumman G-164A · Bonita, LAApr 2, 1978 · N6635Q · Substantial damage NTSB FTW78DPJ14Accident · Minor injuriesClosedCessna 182A · Monroe, LAMar 31, 1978 · N9122M · Substantial damage NTSB FTW78FRD19Accident · Minor injuriesClosedPiper PA-28 · Jennings, LAMar 28, 1978 · N5736F · Substantial damage NTSB FTW78FA035Accident · 2 fatalClosedBell 47G-4A · Morgan City, LAMar 23, 1978 · N8182J · Destroyed NTSB FTW78FRJ11Accident · No injuriesClosedGrumman G-164A · Cloutierville, LAMar 15, 1978 · N9806 · Substantial damage NTSB FTW78FA031Accident · Serious injuriesClosedMooney M20E · New Orleans, LAMar 14, 1978 · N1984Y · 2 aircraft · Destroyed NTSB FTW78DRD18Accident · Minor injuriesClosedCessna 180J · Westwego, LAFeb 18, 1978 · N9918N · Substantial damage NTSB FTW78FRD17Accident · No injuriesClosedCessna 182A · Jackson, LAFeb 11, 1978 · N5168D · Substantial damage NTSB FTW78FRD16Accident · No injuriesClosedPiper PA-28R · Plaquemine, LAJan 28, 1978 · N56373 · Substantial damage NTSB FTW78FRD14Accident · Minor injuriesClosedCessna 152 · Denham Springs, LAJan 15, 1978 · N24229 · Destroyed NTSB FTW78FRD15Accident · Serious injuriesClosedBell 206B · Venice, LAJan 11, 1978 · N8178J · Destroyed NTSB FTW78DRD13Accident · No injuriesClosedCessna 185A · New Orleans, LAJan 8, 1978 · N4900C · Substantial damage NTSB FTW78DA024Accident · 1 fatalClosedCessna 177RG · New Orleans, LAJan 3, 1978 · N7625V · Destroyed NTSB FTW78DRD12Accident · No injuriesClosedHughes 369HS · Harahan, LADec 31, 1977 · N9104F · Substantial damage NTSB FTW78DA020Accident · No injuriesClosedCessna 180 · Marsh Island, LADec 23, 1977 · N9047M · Substantial damage NTSB FTW78FA016Accident · 17 fatalClosedS.N.I.A.S. SA330J · Intracstl City, LADec 8, 1977 · N4730S · Destroyed NTSB FTW78FRD11Accident · Serious injuriesClosedCessna 305A · Crowley, LADec 6, 1977 · N5176G · Substantial damage NTSB FTW78DRD10Accident · Minor injuriesClosedCessna 182P · White Castle, LADec 1, 1977 · N78152 · Substantial damage NTSB FTW78FRJ08Accident · 1 fatalClosedPiper J-3 · Farmerville, LANov 27, 1977 · N88338 · Destroyed NTSB FTW78DRD09Accident · Minor injuriesClosedCessna 180 · Venice, LANov 16, 1977 · N64467 · Substantial damage NTSB FTW78DRJ07Accident · No injuriesClosedCessna 182 · Shreveport, LANov 13, 1977 · N5846B · Substantial damage NTSB FTW78DRD08Accident · No injuriesClosedCessna 210 · New Orleans, LANov 13, 1977 · N732CS · Substantial damage NTSB FTW78FA011Accident · 3 fatalClosedN.American NA-265 · New Orleans, LANov 7, 1977 · N77AP · Destroyed