Skip to content

NTSB investigations, LA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 FTW68D0441Accident · No injuriesClosedCessna 185E · Gum Cove, LAFeb 11, 1968 · N3359L · Substantial damage NTSB FTW68F0425Accident · No injuriesClosedPiper PA-28 · Napoleonville, LAFeb 10, 1968 · N3782T · Substantial damage NTSB FTW68F0434Accident · No injuriesClosedCessna 150 · Alexandria, LAFeb 8, 1968 · N2915J · Substantial damage NTSB FTW68D0414Accident · No injuriesClosedCessna 180F · Port Sulphur, LAJan 29, 1968 · N4805 · Substantial damage NTSB FTW68F0413Accident · Serious injuriesClosedPiper PA-28 · Slidell, LAJan 17, 1968 · N6312R · Destroyed NTSB FTW68F0412Accident · No injuriesClosedPiper PA-23 · Baton Rouge, LAJan 4, 1968 · N6285Y · Substantial damage NTSB FTW68A0068Accident · No injuriesClosedDouglas DC-6B · New Orleans, LAJan 3, 1968 · HR-SAO · Substantial damage NTSB FTW68A0066Accident · 6 fatalClosedBeech 95-B55 · New Orleans La, LADec 31, 1967 · N6139V · Destroyed NTSB FTW68D0394Accident · Minor injuriesClosedStinson 108-1 · Gueydan, LADec 25, 1967 · N8238K · Substantial damage NTSB FTW68F0400Accident · No injuriesClosedCessna 15OF · Alexandria, LADec 18, 1967 · N8697S · Substantial damage NTSB FTW68F0369Accident · No injuriesClosedPiper PA-25 · Gonzales, LADec 13, 1967 · N6519Z · Destroyed NTSB FTW68F0381Accident · 1 fatalClosedBeech V-35 · Athens, LADec 7, 1967 · N348E · Destroyed NTSB FTW68A0053Accident · 2 fatalClosedCessna 182D · Rayville, LANov 26, 1967 · N8738X · Destroyed NTSB FTW68F0339Accident · Minor injuriesClosedCessna 172G · Hornbeck, LANov 25, 1967 · N1309F · Substantial damage NTSB FTW68A0052Accident · 1 fatalClosedPiper PA-18 · Transylvania, LANov 25, 1967 · N9776D · Destroyed NTSB FTW68D0359Accident · No injuriesClosedMooney M20F · Mansfield, LANov 8, 1967 · N3275F · Substantial damage NTSB FTW68F0322Accident · Serious injuriesClosedPiper PA-25 · Epps, LAOct 26, 1967 · N6371Z · Destroyed NTSB FTW68F0301Accident · No injuriesClosedBeech S35 · Baton Rouge, LAOct 22, 1967 · N9014S · Substantial damage NTSB FTW68F0299Accident · No injuriesClosedBellanca 14-193 · Kenner, LAOct 21, 1967 · N8515R · Substantial damage NTSB FTW68F0298Accident · No injuriesClosedGlobe GC-1B · Baton Rouge, LAOct 21, 1967 · N78278 · Substantial damage NTSB FTW68F0285Accident · No injuriesClosedCessna 180 · Morgan City, LAOct 17, 1967 · N2700X · Substantial damage NTSB FTW68D0284Accident · No injuriesClosedCessna 150 · Baton Rouge, LAOct 17, 1967 · N6569F · Substantial damage NTSB FTW68F0310Accident · Serious injuriesClosedBoeing B75N1 · Gilliam, LAOct 16, 1967 · N65598 · Destroyed NTSB FTW68A0045Accident · 2 fatalClosedBeech V35 · Monroe, LAOct 16, 1967 · N506SW · Destroyed NTSB FTW68F0273Accident · No injuriesClosedBellanca 14-19 · Shreveport, LAOct 13, 1967 · N9835B · Substantial damage NTSB FTW68D0318Accident · No injuriesClosedBeech D95A · Alexandria, LAOct 13, 1967 · N9496S · Substantial damage NTSB FTW68D0269Accident · No injuriesClosedCessna 180 · Port Sulphur, LAOct 6, 1967 · N7965V · Substantial damage NTSB FTW68D0245Accident · No injuriesClosedCessna 172 · Pine Grove, LAOct 3, 1967 · N1417F · Substantial damage NTSB FTW68F0240Accident · No injuriesClosedCessna 150 · Westwego, LASep 24, 1967 · N8459G · Substantial damage NTSB FTW68A0034Accident · No injuriesClosedBell 47G-2A · Empire, LASep 20, 1967 · N5179B · Substantial damage NTSB FTW68A0041Accident · No injuriesClosedCessna 185 · New Orleans, LASep 19, 1967 · N4718Q · Substantial damage NTSB FTW68D0274Accident · No injuriesClosedCessna 210 · Kenner, LASep 18, 1967 · N3808Y · Substantial damage NTSB FTW68A0031Accident · 1 fatalClosedBoeing N2S-3 · Lake Charles, LASep 14, 1967 · N75423 · Destroyed NTSB FTW68D0225Accident · No injuriesClosedPiper PA-18 · Columbia, LASep 13, 1967 · N3863Z · Destroyed NTSB FTW68A0030Accident · 2 fatalClosedBell 47G-4 · La Place, LASep 13, 1967 · N1350X · Substantial damage NTSB FTW68F0224Accident · Serious injuriesClosedPiper PA-18 · Sondheimer, LASep 11, 1967 · N1266A · Substantial damage NTSB FTW68F0221Accident · No injuriesClosedLuscombe 8F · Lafayette, LASep 9, 1967 · N9916C · Substantial damage NTSB FTW68F0317Accident · No injuriesClosedBoeing A75N1 · Monroe, LASep 8, 1967 · N64567 · Substantial damage NTSB FTW68F0316Accident · No injuriesClosedCessna 210 · Shreveport, LASep 8, 1967 · N215MD · Substantial damage NTSB FTW68A0028Accident · Serious injuriesClosedBell 47G-2 · Leeville, LASep 7, 1967 · N6700D · Destroyed NTSB FTW68F0219Accident · No injuriesClosedBeech P35 · Shreveport, LASep 4, 1967 · N9545Y · Substantial damage NTSB FTW68D0232Accident · No injuriesClosedErco 415-C · Darnell, LASep 4, 1967 · N99690 · Substantial damage NTSB FTW68F0218Accident · Minor injuriesClosedCessna 172 · Pollock, LASep 3, 1967 · N5929R · Substantial damage NTSB FTW68A0026Accident · No injuriesClosedLockheed 188A · New Orleans, LASep 3, 1967 · N5006K · Substantial damage NTSB FTW68A0025Accident · 1 fatalClosedBensen B8M · New Orleans, LASep 2, 1967 · N4971 · Destroyed NTSB FTW68F0257Accident · No injuriesClosedGrumman G-164 · Reserve, LAAug 30, 1967 · N463RF · Substantial damage NTSB FTW68D0195Accident · No injuriesClosedGrumman G-164 · Frisco, LAAug 29, 1967 · N457RF · Substantial damage NTSB FTW68F0176Accident · No injuriesClosedCessna 150 · New Orleans, LAAug 23, 1967 · N6650F · Substantial damage NTSB FTW68F0156Accident · Minor injuriesClosedPiper PA-22 · Shreveport, LAAug 21, 1967 · N1162C · Substantial damage NTSB FTW68A0021Accident · No injuriesClosedCessna 185E · Venice, LAAug 15, 1967 · N4718Q · Substantial damage