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 FTW79FRD35Accident · No injuriesClosedGrumman G-164A · Basile, LAMay 16, 1979 · N8629H · Substantial damage NTSB FTW79FRD30Accident · No injuriesClosedGrumman G164 · Leblanc, LAMay 16, 1979 · N9693 · Substantial damage NTSB FTW79FRD29Accident · No injuriesClosedPiper PA-28 · Patterson, LAMay 16, 1979 · N9301J · Substantial damage NTSB FTW79FRD27Accident · No injuriesClosedLockheed 18 · Melville, LAMay 7, 1979 · N513V · Substantial damage NTSB FTW79DRD25Accident · No injuriesClosedGrumman G-164A · Midland, LAMay 4, 1979 · N5334 · Destroyed NTSB FTW79DRD26Accident · No injuriesClosedCessna 180 · Chandeleur Is, LAMay 3, 1979 · N3197D · Substantial damage NTSB FTW7DDA077Accident · Minor injuriesClosedBell 206L · Cameron, LAApr 28, 1979 · N16779 · Substantial damage NTSB FTW79FRD24Accident · Minor injuriesClosedCessna 180J · Harvey, LAApr 25, 1979 · N42322 · Substantial damage NTSB FTW79FA076Accident · 3 fatalClosedCessna 320E · Covington, LAApr 22, 1979 · N3482Q · Destroyed NTSB FTW79FRD23Accident · No injuriesClosedGrumman G-164A · Basile, LAApr 19, 1979 · N8384 · Substantial damage NTSB FTW79DRD22Accident · No injuriesClosedBeech 58P · Prairieville, LAApr 18, 1979 · N555HS · Substantial damage NTSB FTW79DRD21Accident · No injuriesClosedGrumman G-164A · Church Point, LAApr 16, 1979 · N494Y · Substantial damage NTSB FTW79FA071Accident · Minor injuriesClosedBell 206B · Cameron, LAApr 12, 1979 · N59627 · Substantial damage NTSB FTW79DRJ12Accident · No injuriesClosedCessna 152 · Alto, LAApr 6, 1979 · N24506 · Substantial damage NTSB FTW79IA067Incident · Minor injuriesClosedBeechcraft B99A · Lafayette, LAApr 5, 1979 · N1922T · Minor damage NTSB FTW79DRJ11Accident · Minor injuriesClosedPiper J-3 · Monterey, LAMar 25, 1979 · N6493H · Substantial damage NTSB FTW79DRD20Accident · No injuriesClosedGrumman G-164B · Welsh, LAMar 24, 1979 · N6527K · Substantial damage NTSB FTW79FPD19Accident · No injuriesClosedGrum Amer G-164 · Lake Arthur, LAMar 15, 1979 · N6603 · Substantial damage NTSB FTW79DA061Accident · 2 fatalClosedBeech 65-A80 · New Orleans, LAMar 11, 1979 · N10QH · Substantial damage NTSB FTW79FA060Accident · 4 fatalClosedCessna 172N · Dequincy, LAMar 10, 1979 · N737XR · Destroyed NTSB FTW79DRD18Accident · No injuriesClosedCessna 172M · Franklinton, LAMar 8, 1979 · N80991 · Substantial damage NTSB FTW79DRJ10Accident · No injuriesClosedCessna A188B · Winnsboro, LAMar 6, 1979 · N8260G · Substantial damage NTSB FTW79FRD15Accident · No injuriesClosedSikorsky S-58 · La Place, LAMar 5, 1979 · N46755 · Substantial damage NTSB FTW79DRD16Accident · Minor injuriesClosedAero Comm 520 · New Orleans, LAMar 4, 1979 · N4178B · Destroyed NTSB FTW79FRD17Accident · No injuriesClosedCessna 185A · Plaquemine, LAMar 2, 1979 · N70359 · Substantial damage NTSB FTW79DA057Accident · No injuriesClosedCessna 180J · Morgan City, LAFeb 28, 1979 · N9939N · Substantial damage NTSB FTW79FA052Accident · 1 fatalClosedCessna 210G · Jennings, LAFeb 23, 1979 · N687ST · Destroyed NTSB FTW79FRD14Accident · No injuriesClosedCessna 182P · Slidell, LAFeb 11, 1979 · N20867 · Substantial damage NTSB FTW79DA045Accident · No injuriesClosedCessna 180 · Cameron, LAJan 22, 1979 · N3420Y · Substantial damage NTSB FTW79DRD13Accident · No injuriesClosedCessna 182F · Venice, LAJan 20, 1979 · N42610 · Substantial damage NTSB FTW79FRJ07Accident · No injuriesClosedBeech B60 · Ruston, LAJan 19, 1979 · N24188 · Substantial damage NTSB FTW79FRD12Accident · No injuriesClosedCessna 150 · Mamou, LAJan 6, 1979 · N8275F · Substantial damage NTSB FTW79FRJ06Accident · Serious injuriesClosedCessna 152 · Bonita, LADec 28, 1978 · N49851 · Substantial damage NTSB FTW79DA033Accident · No injuriesClosedBell 206B · Morgan City, LADec 26, 1978 · N90115 · Substantial damage NTSB FTW79FRJ05Accident · Serious injuriesClosedCessna 177 · Jena, LADec 25, 1978 · N34143 · No damage NTSB FTW79FA026Accident · 5 fatalClosedBeech C-45G · Bordelonville, LADec 19, 1978 · N37JR · Destroyed NTSB FTW79DA027Accident · 2 fatalClosedCessna 152 · Husser, LADec 19, 1978 · N25819 · Destroyed NTSB FTW79FRD11Accident · No injuriesClosedAerospatial AS350C · Morgan City, LADec 14, 1978 · N9001P · Substantial damage NTSB FTW79DA021Accident · No injuriesClosedBell 212 · Morgan City, LADec 2, 1978 · N16982 · Substantial damage NTSB FTW79FRD10Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LADec 1, 1978 · N9322N · Substantial damage NTSB FTW79DA018Accident · 1 fatalClosedBolkow B-105 · Morgan City, LANov 29, 1978 · N46977 · Substantial damage NTSB FTW79FRJ04Accident · No injuriesClosedBeagle B-206 · Monroe, LANov 26, 1978 · N206BT · Substantial damage NTSB FTW79DRD09Accident · Minor injuriesClosedBell 206B · Lutcher, LANov 25, 1978 · N33TA · Substantial damage NTSB FTW79DRD08Accident · Serious injuriesClosedCessna A185F · Harvey, LANov 14, 1978 · N101AM · Substantial damage NTSB FTW79FA010Accident · No injuriesClosedLear Jet 25B · Lafayette, LANov 5, 1978 · N336WR · Substantial damage NTSB FTW79DRD07Accident · No injuriesClosedCessna 152 · New Orleans, LANov 4, 1978 · N757SS · Substantial damage NTSB FTW79FA009Accident · 2 fatalClosedAeronca 7EC · Richmond, LANov 2, 1978 · N4378C · Destroyed NTSB FTW79FRD06Accident · Serious injuriesClosedPitts S-2A · Abbeville, LAOct 29, 1978 · N80039 · Destroyed NTSB FTW79DRD05Accident · Minor injuriesClosedGrum Amer AA-1B · Thibodaux, LAOct 25, 1978 · N1423R · Substantial damage NTSB FTW79DRD04Accident · No injuriesClosedCessna 185F · Lafitte, LAOct 24, 1978 · N5211R · Substantial damage