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 UNK64X2632Accident · No injuriesClosedCessna 190 · New Orleans, LAJul 4, 1964 · N1406 · Substantial damage NTSB UNK64X2611Accident · 1 fatalClosedBeechcraft 35 · Angola, LAJul 2, 1964 · N90589 · Destroyed NTSB UNK64X2592Accident · No injuriesClosedBoeing A75N1 · Raceland, LAJul 1, 1964 · N1348M · Substantial damage NTSB UNK64X2497Accident · No injuriesClosedBoeing A75 · Columbia, LAJun 26, 1964 · N69763 · Substantial damage NTSB UNK64X2465Accident · Minor injuriesClosedCessna 172 · Freemason Is, LAJun 24, 1964 · N7368T · Destroyed NTSB UNK64X2452Accident · No injuriesClosedBell 47G · Vivian, LAJun 23, 1964 · N4734S · Substantial damage NTSB UNK64X2357Accident · No injuriesClosedLuscombe 8A · Monroe, LAJun 18, 1964 · N1378K · Substantial damage NTSB UNK64X2313Accident · Minor injuriesClosedCessna 182 · Melville, LAJun 16, 1964 · N9975T · Destroyed NTSB UNK64X2265Accident · No injuriesClosedCessna 210 · Shreveport, LAJun 13, 1964 · N7302E · Substantial damage NTSB UNK64X2253Accident · 1 fatalClosedPiper J3C · Dequincy, LAJun 12, 1964 · N33470 · Destroyed NTSB UNK64X2232Accident · No injuriesClosedNavion A · Cameron, LAJun 11, 1964 · N4961C · Substantial damage NTSB UNK64X2227Accident · No injuriesClosedGrumman G164 · Mamdu, LAJun 11, 1964 · N10292 · Substantial damage NTSB UNK64X2216Accident · Minor injuriesClosedTaylorcraft BC-12D · Slidell, LAJun 10, 1964 · N96003 · Substantial damage NTSB UNK64X2189Accident · No injuriesClosedPiper PA18 · Empire, LAJun 8, 1964 · N3387P · Substantial damage NTSB UNK64X2086Accident · No injuriesClosedPiper PA23 · Deer Park, LAJun 3, 1964 · N1362P · Substantial damage NTSB UNK64X2060Accident · No injuriesClosedPiper J3 · Abbeville, LAMay 31, 1964 · N98571 · Substantial damage NTSB UNK64X2037Accident · No injuriesClosedMooney M20E · Pollock, LAMay 30, 1964 · N6969U · Substantial damage NTSB UNK64X2011Accident · 1 fatalClosedBellanca 14-13 · Mansfield, LAMay 29, 1964 · N86783 · Destroyed NTSB UNK64X1976Accident · Minor injuriesClosedGrumman G164 · Chataignier, LAMay 27, 1964 · N460RF · Substantial damage NTSB UNK64X1873Accident · No injuriesClosedPiper PA24 · Freemason Is, LAMay 22, 1964 · N6206P · Substantial damage NTSB UNK64X1826Accident · No injuriesClosedGrumman G164 · Church Point, LAMay 18, 1964 · N462RF · Substantial damage NTSB UNK64X1817Accident · No injuriesClosedCessna 172 · Gramercy, LAMay 18, 1964 · N8362X · Substantial damage NTSB UNK64X1776Accident · Minor injuriesClosedBell 47G2A · 10se Houma, LAMay 15, 1964 · N6702D · Destroyed NTSB UNK64X1683Accident · No injuriesClosedStearman A75N1 · Gueydan, LAMay 9, 1964 · N3939C · Destroyed NTSB UNK64X1618Accident · 2 fatalClosedPiper PA22 · Baton Rouge, LAMay 4, 1964 · N3646Z · 2 aircraft · Destroyed NTSB UNK64X1609Accident · No injuriesClosedGrumman G164 · Morse, LAMay 4, 1964 · N577Y · Substantial damage NTSB UNK64X1570Accident · No injuriesClosedCessna 310B · Vivian, LAMay 2, 1964 · N125ET · Substantial damage NTSB UNK64X1532Accident · Serious injuriesClosedHiller UH12E · Tallulah, LAApr 30, 1964 · N5380V · Substantial damage NTSB UNK64X1524Accident · No injuriesClosedGrumman G164 · Leroy, LAApr 30, 1964 · N464RF · Substantial damage NTSB UNK64X1498Accident · No injuriesClosedBoeing A75 · Ville Platte, LAApr 28, 1964 · N1703B · Substantial damage NTSB UNK64X1457Accident · 1 fatalClosedBoeing E75 · Kaplan, LAApr 25, 1964 · N5319N · Destroyed NTSB UNK64X1445Accident · No injuriesClosedPiper PA23 · Cameron, LAApr 25, 1964 · N4181P · Substantial damage NTSB UNK64X1422Accident · Minor injuriesClosedBoeing A75N1 · Gueydan, LAApr 23, 1964 · N49717 · Substantial damage NTSB UNK64X1322Accident · No injuriesClosedCessna 180C · Hopedale, LAApr 15, 1964 · N9342T · Substantial damage NTSB UNK64X1218Accident · No injuriesClosedGrumman G21A · Lafayette, LAApr 8, 1964 · N60X · Substantial damage NTSB UNK64X1174Accident · Serious injuriesClosedPiper PA24 · Alexandria, LAApr 4, 1964 · N7752P · Destroyed NTSB UNK64X1122Accident · No injuriesClosedCessna 172D · Tallulah, LAApr 1, 1964 · N2501Y · Substantial damage NTSB UNK64X1100Accident · 2 fatalClosedLuscombe 8E · Houma, LAMar 29, 1964 · N2636K · Destroyed NTSB UNK64X1064Accident · Serious injuriesClosedBell 47G2A · Leeville, LAMar 27, 1964 · N6747D · Destroyed NTSB UNK64X0969Accident · No injuriesClosedMooney M20 · Houma, LAMar 18, 1964 · N6712U · Substantial damage NTSB UNK64X0918Accident · No injuriesClosedBell 47G · Ruston, LAMar 15, 1964 · N85Z · Substantial damage NTSB UNK64X0867Accident · 2 fatalClosedBell 47G · Grand Isle, LAMar 10, 1964 · N994B · Destroyed NTSB UNK64X0785Accident · Serious injuriesClosedBeechcraft J35 · New Orleans, LAMar 1, 1964 · N3041C · Destroyed NTSB UNK64X0731Accident · No injuriesClosedBoeing A75N1 · Shreveport, LAFeb 28, 1964 · N59735 · Substantial damage NTSB UNK64X0722Accident · No injuriesClosedGrumman G-164 · Loranger, LAFeb 28, 1964 · N501Y · Substantial damage NTSB UNK64X0710Accident · No injuriesClosedBeechcraft 95 · Shreveport, LAFeb 27, 1964 · N665T · Substantial damage NTSB UNK64X0704Accident · 2 fatalClosedPiper PA24 · New Orleans, LAFeb 27, 1964 · N7871P · Destroyed NTSB UNK64X0687Accident · 58 fatalClosedDouglas DC-8 · New Orleans, LAFeb 25, 1964 · N8607 · Destroyed NTSB UNK64X0657Accident · No injuriesClosedCessna 170B · Cut Off, LAFeb 22, 1964 · N2620D · Substantial damage NTSB UNK64X0612Accident · No injuriesClosedCessna 180 · New Orleans, LAFeb 19, 1964 · N7710A · Substantial damage