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 FTW72AF024Accident · 2 fatalClosedCessna 206 · Bossier City, LAOct 28, 1971 · N5168U · Destroyed NTSB FTW72FRD15Accident · Serious injuriesClosedBell 206A · Morgan City, LAOct 25, 1971 · N7020J · Substantial damage NTSB FTW72FRD14Accident · Minor injuriesClosedCessna 180 · Paincourtville, LAOct 24, 1971 · N91304 · Substantial damage NTSB FTW72DRJ12Accident · No injuriesClosedCessna 150 · Alexandria, LAOct 23, 1971 · N8353M · Substantial damage NTSB FTW72FRD13Accident · Minor injuriesClosedAero Comdr 200D · Kentwood, LAOct 17, 1971 · N2909T · Substantial damage NTSB FTW72DRJ11Accident · Minor injuriesClosedCessna 172 · Lecompte, LAOct 16, 1971 · N7486A · Substantial damage NTSB FTW72FRD12Accident · Minor injuriesClosedCessna 172 · Washington, LAOct 9, 1971 · N3721F · Substantial damage NTSB FTW72FRD10Accident · No injuriesClosedBell 47G4A · Morgan City, LASep 18, 1971 · N4708R · Substantial damage NTSB FTW72DRJ08Accident · No injuriesClosedBell 47G4A · Jonesville, LASep 14, 1971 · N4024G · Substantial damage NTSB FTW72FRJ07Accident · No injuriesClosedAero Comdr A-9B · Ferriday, LASep 7, 1971 · N7737V · Substantial damage NTSB FTW72FRD09Accident · No injuriesClosedPiper PA-24 · Baton Rouge, LASep 6, 1971 · N8178P · Substantial damage NTSB FTW72FRD05Accident · No injuriesClosedMckinnon G-21E · Westwego, LASep 2, 1971 · N121H · Substantial damage NTSB FTW72FRJ05Accident · 1 fatalClosedPiper PA-25 · Mangham, LAAug 22, 1971 · N7573Z · Destroyed NTSB FTW72DRD11Accident · No injuriesClosedPiper PA-25 · Belle Rose, LAAug 22, 1971 · N7226Z · Substantial damage NTSB FTW72DRD08Accident · No injuriesClosedGrumman G-164 · Jeanerette, LAAug 14, 1971 · N461RF · Destroyed NTSB FTW72FRD06Accident · Serious injuriesClosedCessna 177 · Baton Rouge, LAAug 11, 1971 · N2951X · 2 aircraft · Substantial damage NTSB FTW72FRJ04Accident · Serious injuriesClosedPiper PA-28 · Farmerville, LAAug 8, 1971 · N5754U · Destroyed NTSB FTW72FRD04Accident · No injuriesClosedStinson 108-1 · De Quincy, LAAug 8, 1971 · N9098K · Substantial damage NTSB FTW72FRD07Accident · No injuriesClosedSnow 600S2D · Vacherie, LAAug 5, 1971 · N1778S · Substantial damage NTSB FTW72DRD02Accident · No injuriesClosedBoeing A75 · Houma, LAAug 2, 1971 · N60M · Substantial damage NTSB FTW72AF009Accident · 1 fatalClosedBeech D18S · Loreauville, LAAug 1, 1971 · N296RB · Destroyed NTSB FTW72FRD01Accident · Serious injuriesClosedBell 47G-4A · Carlisle, LAJul 29, 1971 · N7930S · Destroyed NTSB FTW72FRJ02Accident · No injuriesClosedPiper PA-25 · Bonita, LAJul 26, 1971 · N8526L · Substantial damage NTSB FTW72AF005Accident · 2 fatalClosedPiper PA-18 · Houma, LAJul 19, 1971 · N4994P · 2 aircraft · Destroyed NTSB FTW72FRJ01Accident · No injuriesClosedCessna 411 · Plain Dealing, LAJul 15, 1971 · N944SP · Destroyed NTSB FTW72AF004Accident · No injuriesClosedBell 47G4A · Morgan City, LAJul 14, 1971 · N4708R · Substantial damage NTSB FTW71AF086Accident · No injuriesClosedCessna 180H · Palmetto, LAJun 26, 1971 · N8236V · Substantial damage NTSB FTW71AF085Accident · 1 fatalClosedBell 47G-4A · New Orleans, LAJun 21, 1971 · N7814S · Destroyed NTSB FTW71FRJ39Accident · Minor injuriesClosedCessna 206 · Ruston, LAJun 20, 1971 · N3817G · Substantial damage NTSB FTW71FRD54Accident · No injuriesClosedTaylorcraft BC12-D · Baker, LAJun 20, 1971 · N44044 · Substantial damage NTSB FTW71FRJ38Accident · Serious injuriesClosedCessna 140 · Alexandria, LAJun 16, 1971 · N76143 · Destroyed NTSB FTW71FRD53Accident · No injuriesClosedGrumman G-164 · Crowley, LAJun 15, 1971 · N645U · Substantial damage NTSB FTW71DRJ37Accident · Minor injuriesClosedCessna 180 · Ringgold, LAJun 13, 1971 · N180A · Substantial damage NTSB FTW71FRD52Accident · No injuriesClosedGrumman G-164 · Perry, LAJun 9, 1971 · N468RF · Substantial damage NTSB FTW71FRD51Accident · No injuriesClosedBoeing B75N1 · Elton, LAJun 8, 1971 · N47896 · Substantial damage NTSB FTW71FRD50Accident · Serious injuriesClosedCessna 188 · Church Point, LAJun 1, 1971 · N9950G · Destroyed NTSB FTW71FRD49Accident · No injuriesClosedCessna A185E · New Orleans, LAJun 1, 1971 · N1620M · Substantial damage NTSB FTW71FRD47Accident · No injuriesClosedS.N.I.A.S. SA318C · Grand Isle, LAMay 21, 1971 · N8267 · Substantial damage NTSB FTW71FRJ34Accident · Serious injuriesClosedAeronca 7AC · Waterproof, LAMay 15, 1971 · N83076 · Destroyed NTSB FTW71DRD46Accident · No injuriesClosedBoeing A75 · Vinton, LAMay 15, 1971 · N75263 · Substantial damage NTSB FTW71DRD48Accident · No injuriesClosedBoeing A75 · Rayne, LAMay 14, 1971 · N59364 · Substantial damage NTSB FTW71DRJ33Accident · Minor injuriesClosedPiper PA-25 · Lake Providnce, LAMay 8, 1971 · N7082Z · Substantial damage NTSB FTW71FRD45Accident · Minor injuriesClosedBell 47G-4 · Westwego, LAMay 5, 1971 · N73283 · Substantial damage NTSB FTW71DRD44Accident · Serious injuriesClosedBoeing E75 · Reeves, LAMay 3, 1971 · N75244 · Substantial damage NTSB FTW71FRD41Accident · Serious injuriesClosedBoeing A75N1 · Opelousas, LAApr 25, 1971 · N49731 · Destroyed NTSB FTW71FRD42Accident · Serious injuriesClosedBoeing E75 · Maxie, LAApr 24, 1971 · N97987 · Destroyed NTSB FTW71DRD43Accident · No injuriesClosedGrumman G-164 · Abbeville, LAApr 24, 1971 · N6549 · Substantial damage NTSB FTW71DRD40Accident · No injuriesClosedCessna 172 · Merryville, LAApr 23, 1971 · N3677L · Substantial damage NTSB FTW71FRD38Accident · Serious injuriesClosedBeech V35 · Wilson, LAApr 16, 1971 · N6111A · Destroyed NTSB FTW71AF070Accident · No injuriesClosedGates Lear 25 · Lake Charles, LAApr 11, 1971 · N954FA · Substantial damage