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 FTW81DA081Accident · Minor injuriesClosedBell 206L-1 · Leeville, LAApr 25, 1981 · N5000Y · Substantial damage NTSB FTW81DRD19Accident · No injuriesClosedGrum Amer AA-1B · Grand Isle, LAApr 23, 1981 · N8985L · Substantial damage NTSB FTW81FA071Accident · Minor injuriesClosedCessna 414 · Shreveport, LAApr 16, 1981 · N86EV · Substantial damage NTSB FTW81IA067Incident · No injuriesClosedBell 222 · Lake Charles, LAApr 9, 1981 · N38929 · No damage NTSB FTW81IA066Incident · No injuriesClosedSikorsky S-76A · Morgan City, LAApr 7, 1981 · N1546Z · Minor damage NTSB FTW81DRD17Accident · No injuriesClosedGrumman G-164A · Lake Charles, LAApr 3, 1981 · N6787Q · Substantial damage NTSB FTW81FA059Accident · 1 fatalClosedCessna 172P · Lake Charles, LAMar 27, 1981 · N52710 · Destroyed NTSB FTW81IA058Incident · No injuriesClosedEmbraer 110P1 · Lafayette, LAMar 25, 1981 · N691RA · Minor damage NTSB FTW81FA055Accident · Minor injuriesClosedBell 206L-1 · Cameron, LAMar 24, 1981 · N206EH · Destroyed NTSB FTW81FRD16Accident · No injuriesClosedGrumman G-164A · Bell City, LAMar 21, 1981 · N5477 · Substantial damage NTSB FTW81FRD15Accident · No injuriesClosedCessna 185 · Port Sulphur, LAMar 18, 1981 · N7380Q · Destroyed NTSB FTW81DRD14Accident · No injuriesClosedCessna 402B · Houma, LAMar 17, 1981 · N3767C · Substantial damage NTSB FTW81DRD13Accident · No injuriesClosedCessna 180H · Belle Chase, LAMar 11, 1981 · N9739G · Substantial damage NTSB FTW81FRJ10Accident · Minor injuriesClosedBeech C24R · Bossier City, LAFeb 20, 1981 · N5279M · Substantial damage NTSB FTW81FA030Accident · 4 fatalClosedCessna 310R · Houma, LAFeb 10, 1981 · N1323G · Destroyed NTSB FTW81DA031Accident · No injuriesClosedTed Smith 601 · Hammond, LAFeb 10, 1981 · N9501Q · Substantial damage NTSB FTW81DRJ09Accident · No injuriesClosedPiper PA-28 · Sterlington, LAJan 25, 1981 · N2232W · Substantial damage NTSB FTW81DA025Accident · No injuriesClosedBell 222 · Patterson, LAJan 21, 1981 · N5754B · Substantial damage NTSB FTW81FA024Accident · 3 fatalClosedPiper PA-23 · New Orleans, LAJan 15, 1981 · N6812Y · Destroyed NTSB FTW81FA020Accident · No injuriesClosedBell 206B · Patterson, LADec 31, 1980 · N222LM · Substantial damage NTSB FTW81DRD11Accident · No injuriesClosedCessna 172M · Belle Chasse, LADec 26, 1980 · N73214 · Substantial damage NTSB FTW81FA018Accident · 3 fatalClosedAero Cmdr 1121 · Many, LADec 19, 1980 · N29LB · Destroyed NTSB FTW81DRD10Accident · No injuriesClosedBoeing 75 · Sulphur, LADec 17, 1980 · N62418 · Substantial damage NTSB FTW81DA014Accident · 1 fatalClosedBell 206B3 · Cameron, LADec 2, 1980 · N5003Q · Destroyed NTSB FTW81DRD09Accident · No injuriesClosedGrum-Amer AA-1A · Clinton, LADec 1, 1980 · N9314L · Substantial damage NTSB FTW81FRJ06Accident · No injuriesClosedCessna 152 · Springhill, LANov 28, 1980 · N47314 · Substantial damage NTSB FTW81DRD07Accident · Minor injuriesClosedPiper PA-32 · Loreauville, LANov 25, 1980 · N4690F · Substantial damage NTSB FTW81DRD06Accident · No injuriesClosedPiper PA-25 · White Castle, LANov 11, 1980 · N7053Z · Substantial damage NTSB FTW81FRD04Accident · No injuriesClosedPitts S-2A · New Orleans, LANov 4, 1980 · N333BD · 2 aircraft · Substantial damage NTSB FTW81DRJ04Accident · No injuriesClosedCessna 152 · Florien, LAOct 26, 1980 · N48825 · Substantial damage NTSB FTW81DRD03Accident · No injuriesClosedCessna 185F · Cameron, LAOct 22, 1980 · N5458E · Substantial damage NTSB FTW81DRD02Accident · No injuriesClosedPiper PA-28 · Lake Charles, LAOct 11, 1980 · N2202W · Substantial damage NTSB FTW81FA003Accident · 1 fatalClosedCessna 182A · Kentwood, LAOct 7, 1980 · N2015G · Destroyed NTSB FTW81DRD05Accident · No injuriesClosedSchweizer 2-33A · Robert, LAOct 4, 1980 · N5732S · Substantial damage NTSB FTW81FRJ01Accident · Serious injuriesClosedGrumman G-164 · Marksville, LAOct 2, 1980 · N494Y · Destroyed NTSB FTW81DRD01Accident · No injuriesClosedCessna T188C · White Castle, LAOct 2, 1980 · N4017J · Substantial damage NTSB FTW80DRJ45Accident · No injuriesClosedCessna 180 · Pitkin, LASep 25, 1980 · N7577K · Substantial damage NTSB FTW80DA121Accident · No injuriesClosedBell 206L-1 · Creole, LASep 24, 1980 · N27483 · Substantial damage NTSB FTW80DRJ44Accident · No injuriesClosedCessna 172C · Rocky Branch, LASep 23, 1980 · N1829Y · Substantial damage NTSB FTW80FA116Accident · 4 fatalClosedPiper PA-32 · Goodwill, LASep 17, 1980 · N1806T · Destroyed NTSB FTW80DA117Accident · No injuriesClosedBell 206B · Intracstl Cy, LASep 16, 1980 · N27758 · Substantial damage NTSB FTW80FA114Accident · 1 fatalClosedCessna 401 · Houma, LASep 12, 1980 · N444CS · 2 aircraft · Destroyed NTSB FTW80DRJ41Accident · No injuriesClosedCessna U206G · Delhi, LASep 11, 1980 · N9942N · Substantial damage NTSB FTW80DRJ40Accident · No injuriesClosedPiper PA-23 · Pineville, LASep 11, 1980 · N62730 · Substantial damage NTSB FTW80FRJ39Accident · No injuriesClosedCessna 150K · Shreveport, LASep 8, 1980 · N5803G · Substantial damage NTSB FTW80DRJ38Accident · No injuriesClosedPiper J-3 · Tallulah, LASep 7, 1980 · N41232 · Substantial damage NTSB FTW80DRD62Accident · No injuriesClosedCessna 180F · Westwego, LASep 7, 1980 · N2135Z · Substantial damage NTSB FTW80FRD61Accident · Serious injuriesClosedPietenpol Aircmp · Patterson, LASep 6, 1980 · N4272 · Destroyed NTSB FTW80FRJ37Accident · 2 fatalClosedBell 47G-2A · Cottonport, LASep 3, 1980 · N73988 · Destroyed NTSB FTW80FA112Accident · No injuriesClosedAerospatial AS350 · Patterson, LASep 3, 1980 · N3602V · Substantial damage