Skip to content

NTSB investigations, LA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 FTW80FA069Accident · 2 fatalClosedBell 206L-1 · Gibson, LAMay 6, 1980 · N5017F · Destroyed NTSB FTW80DRD32Accident · No injuriesClosedGrumman G-164B · Evangeline, LAMay 6, 1980 · N6510K · Substantial damage NTSB FTW80DRD30Accident · No injuriesClosedGrumman G-164A · Jennings, LAMay 6, 1980 · N9546 · Substantial damage NTSB FTW80DRJ17Accident · No injuriesClosedCessna 152 · Shreveport, LAMay 5, 1980 · N4899H · Substantial damage NTSB FTW80DRD29Accident · No injuriesClosedGrumman G-164B · Church Point, LAMay 2, 1980 · N48585 · Substantial damage NTSB FTW80FRJ15Accident · No injuriesClosedRobinson R-22 · Shreveport, LAMay 1, 1980 · N9021M · Substantial damage NTSB FTW80DRD31Accident · No injuriesClosedCessna 172N · Braithwaite, LAMay 1, 1980 · N3151E · Substantial damage NTSB FTW80DRD27Accident · No injuriesClosedCessna 180 · Patterson, LAApr 30, 1980 · N52138 · Substantial damage NTSB FTW80DRD26Accident · Minor injuriesClosedCessna 152 · Houma, LAApr 28, 1980 · N6558B · Substantial damage NTSB FTW80FA068Accident · 1 fatalClosedCessna 404 · New Orleans, LAApr 27, 1980 · N5237J · Substantial damage NTSB FTW80FRD25Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LAApr 25, 1980 · N8369 · Substantial damage NTSB FTW80FRD24Accident · 2 fatalClosedChampion 7GCAA · Maurice, LAApr 20, 1980 · N2894G · Destroyed NTSB FTW80DRD23Accident · No injuriesClosedCessna 170B · Venice, LAApr 20, 1980 · N5729C · Substantial damage NTSB FTW80FRD22Accident · Serious injuriesClosedBell 206L-1 · Holly Beach, LAApr 11, 1980 · N2754X · Destroyed NTSB FTW80DRJ14Accident · No injuriesClosedCessna 182K · Cheneyville, LAApr 8, 1980 · N2684Q · Substantial damage NTSB FTW80DRD21Accident · Minor injuriesClosedCessna 150 · New Orleans, LAApr 5, 1980 · N7841Z · Substantial damage NTSB FTW80FRJ13Accident · Serious injuriesClosedAir Tractor AT-301 · Monroe, LAApr 2, 1980 · N4445S · Destroyed NTSB FTW80FRD20Accident · Serious injuriesClosedCessna 182L · New Orleans, LAMar 22, 1980 · N3357R · Substantial damage NTSB FTW80FA055Accident · Serious injuriesClosedDouglas DC-9 · Baton Rouge, LAMar 17, 1980 · N9103 · Substantial damage NTSB FTW80DRD19Accident · Minor injuriesClosedBell 206B · Venice, LAMar 11, 1980 · N16966 · Destroyed NTSB FTW80FRD18Accident · No injuriesClosedCessna P210W · Lafayette, LAMar 2, 1980 · N3605P · Substantial damage NTSB FTW80DRD17Accident · No injuriesClosedCessna 182F · New Orleans, LAFeb 29, 1980 · N70359 · Substantial damage NTSB FTW80FA048Accident · 7 fatalClosedMitsubishi MU-2B · New Orleans, LAFeb 23, 1980 · N962MA · Destroyed NTSB FTW80DRJ12Accident · Minor injuriesClosedGrumman G-164B · Monroe, LAFeb 22, 1980 · N6670Q · Destroyed NTSB FTW80FA045Accident · 6 fatalClosedSikorsky S-62A · Leeville, LAFeb 21, 1980 · N442Y · Destroyed NTSB FTW80FRD16Accident · No injuriesClosedBell 212 · Houma, LAFeb 18, 1980 · N71AL · Substantial damage NTSB FTW80DA039Accident · 1 fatalClosedBell 206B · Grand Isle, LAFeb 8, 1980 · N4019G · Substantial damage NTSB FTW80DRD15Accident · No injuriesClosedScorpion II · Baton Rouge, LAJan 5, 1980 · N166ER · Substantial damage NTSB FTW80FA030Accident · 1 fatalClosedBell 206B · Montegut, LAJan 3, 1980 · N30TA · 2 aircraft · Destroyed NTSB FTW80DRD13Accident · No injuriesClosedCessna 185 · Morgan City, LADec 28, 1979 · N185M · Substantial damage NTSB FTW80FRD12Accident · Serious injuriesClosedAerospatle AS-350 · Intracstl Cy, LADec 26, 1979 · N3594B · Substantial damage NTSB FTW80FA028Accident · 2 fatalClosedBeech 65-90 · Leeville, LADec 22, 1979 · N724N · Destroyed NTSB FTW80FRD14Accident · No injuriesClosedHughes 369D · Westwego, LADec 19, 1979 · N58270 · Substantial damage NTSB FTW80FA023Accident · 1 fatalClosedCessna 180K · Harvey, LADec 18, 1979 · N2594K · Substantial damage NTSB FTW80FA022Accident · 2 fatalClosedCessna A185F · Venice, LADec 15, 1979 · N1850R · Destroyed NTSB FTW80FRD11Accident · Serious injuriesClosedCessna 421B · Lafayette, LADec 9, 1979 · N5970M · Substantial damage NTSB FTW80FRD09Accident · No injuriesClosedPiper PA-32 · Cameron, LADec 5, 1979 · N321HF · Substantial damage NTSB FTW80FRD10Accident · No injuriesClosedSikorsky S-76A · Intracstl City, LANov 29, 1979 · N476AL · Substantial damage NTSB FTW80DRD05Accident · No injuriesClosedAero-Comdr S2R · Vinton, LANov 27, 1979 · N4857X · Substantial damage NTSB FTW80DRD03Accident · No injuriesClosedCessna 185 · Morgan City, LANov 24, 1979 · N51BC · Substantial damage NTSB FTW80FRJ07Accident · Minor injuriesClosedCessna 150M · Ruston, LANov 2, 1979 · N714LX · Substantial damage NTSB FTW80FRJ06Accident · No injuriesClosedCessna 310P · Shreveport, LAOct 25, 1979 · N5911M · Substantial damage NTSB FTW80FRJ03Accident · No injuriesClosedCessna 310A · Shreveport, LAOct 23, 1979 · N5340A · Substantial damage NTSB FTW80DRD02Accident · No injuriesClosedCessna 180F · Morgan City, LAOct 22, 1979 · N9976N · Substantial damage NTSB FTW80FRD08Accident · No injuriesClosedHughes 369D · Abbeville, LAOct 11, 1979 · N58240 · Substantial damage NTSB FTW80FRD07Accident · No injuriesClosedBell 206L · Lake Charles, LAOct 9, 1979 · N5018N · Destroyed NTSB FTW80DRD06Accident · No injuriesClosedCessna 185F · E Timbalier Is, LAOct 9, 1979 · N5074R · Substantial damage NTSB FTW80FRJ01Accident · Minor injuriesClosedAero Comdr 680W · Alexandria, LAOct 4, 1979 · N713SP · Destroyed NTSB FTW80FRD01Accident · No injuriesClosedPiper PA-23 · Opelousas, LAOct 3, 1979 · N62267 · Substantial damage NTSB FTW80DRD04Accident · No injuriesClosedCessna 152 · Kentwood, LAOct 1, 1979 · N49991 · Substantial damage