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 FTW74FRD38Accident · No injuriesClosedGrumman G-164 · Livonia, LAMay 18, 1974 · N7952 · Substantial damage NTSB FTW74FRD37Accident · No injuriesClosedGrumman G-164 · Opelousas, LAMay 17, 1974 · N619U · Substantial damage NTSB FTW74DRJ34Accident · No injuriesClosedGrumman G-164A · Bonita, LAMay 17, 1974 · N7443 · Substantial damage NTSB FTW74FRD39Accident · No injuriesClosedGrumman G-164A · Jennings, LAMay 16, 1974 · N5272 · Substantial damage NTSB FTW74FRD36Accident · No injuriesClosedAero Comdr 600S2R · Rayne, LAMay 12, 1974 · N4072X · Substantial damage NTSB FTW74DRJ33Accident · No injuriesClosedCessna 150 · Leesville, LAMay 9, 1974 · N6157G · Substantial damage NTSB FTW74FRD35Accident · No injuriesClosedBoeing A75N1 · Rayne, LAMay 8, 1974 · N59364 · Substantial damage NTSB FTW74AF081Accident · No injuriesClosedCessna 185 · Lafitte, LAMay 8, 1974 · N2219T · 2 aircraft · Minor damage NTSB FTW74FRD34Accident · No injuriesClosedPiper PA-36 · Chataignier, LAMay 7, 1974 · N56614 · Substantial damage NTSB FTW74DRD33Accident · No injuriesClosedGrumman G-164A · Gueydan, LAMay 5, 1974 · N5296 · Substantial damage NTSB FTW74DRD32Accident · No injuriesClosedGrumman G-164A · Abbeville, LAMay 1, 1974 · N6543 · Substantial damage NTSB FTW74DRJ32Accident · No injuriesClosedPiper PA-25 · Winnfield, LAApr 26, 1974 · N4590Y · Substantial damage NTSB FTW74DRF31Accident · Minor injuriesClosedErco 415-C · Gretna, LAApr 21, 1974 · N99295 · Destroyed NTSB FTW74DRD30Accident · No injuriesClosedGrumman G-164A · Lake Arthur, LAApr 20, 1974 · N462RF · Substantial damage NTSB FTW74DRD29Accident · No injuriesClosedAero Cmdr 600S2R · Eunice, LAApr 18, 1974 · N3652X · Substantial damage NTSB FTW74DRD28Accident · Serious injuriesClosedGrumman G-164A · Lake Charles, LAApr 18, 1974 · N5345 · Substantial damage NTSB FTW74FRJ30Accident · Serious injuriesClosedCessna T210K · Shreveport, LAApr 14, 1974 · N8205M · Substantial damage NTSB FTW74DRD27Accident · No injuriesClosedCessna 180 · Houma, LAApr 12, 1974 · N9723G · Substantial damage NTSB FTW74FRD26Accident · No injuriesClosedBell 206B · Patterson, LAApr 11, 1974 · N30AL · Substantial damage NTSB FTW74FRD25Accident · No injuriesClosedPiper PA-23 · Lake Charles, LAApr 7, 1974 · N5323Y · Substantial damage NTSB FTW74DRJ29Accident · No injuriesClosedGrumman G-164A · Mer Rouge, LAApr 5, 1974 · N7364 · Substantial damage NTSB FTW74DRD23Accident · No injuriesClosedBell 206B · Gloria, LAMar 8, 1974 · N4833 · Destroyed NTSB FTW74DRJ27Accident · No injuriesClosedMooney M20C · Ruston, LAFeb 17, 1974 · N7898V · Substantial damage NTSB FTW74AF060Accident · Serious injuriesClosedDouglas DC-9 · Alexandria, LAFeb 15, 1974 · N1288L · No damage NTSB FTW74FRD22Accident · Minor injuriesClosedCessna 180H · Empire, LAJan 31, 1974 · N71RD · Substantial damage NTSB FTW74DRJ24Accident · Minor injuriesClosedLuscombe 8A · Rayville, LAJan 27, 1974 · N77923 · Substantial damage NTSB FTW74DRJ23Accident · No injuriesClosedPiper PA-12 · Jonesville, LAJan 13, 1974 · N4252M · Substantial damage NTSB FTW74AF053Accident · 1 fatalClosedBell 206B · Venice, LAJan 8, 1974 · N4020G · Destroyed NTSB FTW74DRJ22Accident · No injuriesClosedCessna 177 · Jonesville, LADec 29, 1973 · N3170T · Substantial damage NTSB FTW74AF048Accident · 1 fatalClosedCessna 150A · Grand Isle, LADec 27, 1973 · N7133X · Destroyed NTSB FTW74AF042Accident · No injuriesClosedCessna 180H · Pilottown, LADec 13, 1973 · N7994V · Substantial damage NTSB FTW74DRJ19Accident · Minor injuriesClosedCessna 150 · Minden, LANov 23, 1973 · N11229 · Substantial damage NTSB FTW74AF036Accident · 1 fatalClosedPiper PA-28 · Slidell, LANov 22, 1973 · N6629J · Destroyed NTSB FTW74AF034Accident · Minor injuriesClosedBell 206B · Intrcstl Cty, LANov 20, 1973 · N7904J · Destroyed NTSB FTW74AF032Accident · 1 fatalClosedPitts S-2A · Bogalusa, LANov 17, 1973 · N80022 · Destroyed NTSB FTW74AF031Accident · 2 fatalClosedCessna 150D · Melville, LANov 17, 1973 · N4113U · Destroyed NTSB FTW74AF030Accident · Minor injuriesClosedBell 206B · Intracstl Cty, LANov 13, 1973 · N2929W · Substantial damage NTSB FTW74FRD18Accident · Minor injuriesClosedBell 47G-5A · Belle Chasse, LANov 8, 1973 · N2994W · Destroyed NTSB FTW74FRD17Accident · No injuriesClosedGrumman G-164 · Eunice, LAOct 25, 1973 · N592Y · Substantial damage NTSB FTW74FRD16Accident · No injuriesClosedCessna 150L · Clinton, LAOct 22, 1973 · N1661Q · Destroyed NTSB FTW74DRJ17Accident · Serious injuriesClosedCessna A188 · Oak Ridge, LAOct 22, 1973 · N8170V · Destroyed NTSB FTW74DRD15Accident · No injuriesClosedCessna 177 · Bogalusa, LAOct 17, 1973 · N34517 · Substantial damage NTSB FTW74DRJ15Accident · No injuriesClosedGrumman G-164 · Mer Rouge, LAOct 6, 1973 · N6625 · Substantial damage NTSB FTW74DRJ16Accident · No injuriesClosedLuscombe 8F · Kilbourne, LAOct 1, 1973 · N2129B · Substantial damage NTSB FTW74FRD14Accident · No injuriesClosedPiper PA-25 · Norwood, LASep 26, 1973 · N8506L · Destroyed NTSB FTW74AF017Accident · 6 fatalClosedBeech E18S · Natchitoches, LASep 20, 1973 · N50JR · Destroyed NTSB FTW74AF016Accident · 2 fatalClosedBell 47G-4A · Leeville, LASep 18, 1973 · N4800R · Destroyed NTSB FTW74FRD13Accident · No injuriesClosedGrumman G-164A · Indian Village, LASep 17, 1973 · N6609 · Destroyed NTSB FTW74DRD10Accident · No injuriesClosedCessna 180F · Romer Pass, LASep 14, 1973 · N91291 · Substantial damage NTSB FTW74FRD09Accident · No injuriesClosedAmer Avco AA1-B · Slidell, LASep 9, 1973 · N9917L · Substantial damage