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 UNK65X0950Accident · 3 fatalClosedBell 47J2 · Venice, LADec 7, 1964 · N73229 · Destroyed NTSB UNK65X0942Accident · No injuriesClosedCessna 180 · Franklin, LADec 7, 1964 · N9224T · Substantial damage NTSB UNK65X0813Accident · No injuriesClosedCurtiss C-46 · Baton Rouge, LANov 24, 1964 · N9885F · Substantial damage NTSB UNK65X0811Accident · Minor injuriesClosedAeronca 11AC · Benton, LANov 23, 1964 · N86257 · Substantial damage NTSB UNK65X0800Accident · No injuriesClosedBellanca 260A · Westwego, LANov 22, 1964 · N8871R · Destroyed NTSB UNK65X0730Accident · 1 fatalClosedCessna 172 · Caddo Lake, LANov 15, 1964 · N8268X · Destroyed NTSB UNK65X0649Accident · Serious injuriesClosedCessna 180 · Venice, LANov 10, 1964 · N6474X · No damage NTSB UNK65X0428Accident · Minor injuriesClosedCessna 170A · Freemason Is, LAOct 25, 1964 · N5402C · Destroyed NTSB UNK65X0361Accident · Minor injuriesClosedCessna 172 · Covington, LAOct 21, 1964 · N3719S · Substantial damage NTSB UNK65X0173Accident · Minor injuriesClosedNardi FN333 · Chandeleur Is, LAOct 7, 1964 · N622 · Destroyed NTSB UNK65X0161Accident · No injuriesClosedCessna 210 · Crowley, LAOct 6, 1964 · N9483X · Substantial damage NTSB UNK64X4204Incident · No injuriesClosedDouglas DC-6 · New Orleans, LASep 29, 1964 · N90885 · No damage NTSB UNK64X4073Accident · No injuriesClosedHoward DGA15P · Deridder, LASep 20, 1964 · N65595 · Destroyed NTSB UNK64X3983Accident · 1 fatalClosedPiper PA-18 · Rayville, LASep 14, 1964 · N40602 · Destroyed NTSB UNK64X3838Accident · No injuriesClosedCessna 180 · Houma, LASep 7, 1964 · N2677Y · Destroyed NTSB UNK64X3748Accident · No injuriesClosedBeechcraft H35 · Monroe, LASep 3, 1964 · N7959D · Substantial damage NTSB UNK64X3737Accident · 3 fatalClosedBeechcraft 35-33 · Vinton, LASep 2, 1964 · N612V · Destroyed NTSB UNK64X3699Accident · No injuriesClosedBoeing A75N1 · Whitteville, LAAug 31, 1964 · N62425 · Substantial damage NTSB UNK64X3691Accident · No injuriesClosedCessna 120 · Pride, LAAug 30, 1964 · N77008 · Substantial damage NTSB UNK64X3687Accident · No injuriesClosedFairchild 24 · Deridder, LAAug 30, 1964 · N81285 · Substantial damage NTSB UNK64X3650Accident · No injuriesClosedAeronca 7AC · Covington, LAAug 28, 1964 · N84363 · Substantial damage NTSB UNK64X3648Accident · No injuriesClosedAeronca 7AC · Slidell, LAAug 28, 1964 · N2202E · Substantial damage NTSB UNK64X3632Accident · No injuriesClosedHughes 269A · New Orleans, LAAug 27, 1964 · N8824F · Substantial damage NTSB UNK64X3622Accident · Minor injuriesClosedBoeing A75 · Monroe, LAAug 27, 1964 · N121J · Destroyed NTSB UNK64X3593Accident · Serious injuriesClosedPiper PA12 · Timbalier Is, LAAug 25, 1964 · N7669H · Destroyed NTSB UNK64X3571Accident · No injuriesClosedCessna 150 · Lacombe, LAAug 23, 1964 · N377E · No damage NTSB UNK64X3555Accident · No injuriesClosedPiper PA25 · Columbia, LAAug 23, 1964 · N6080Z · Destroyed NTSB UNK64X3534Accident · No injuriesClosedPiper PA24 · Baton Rouge, LAAug 22, 1964 · N8447P · Substantial damage NTSB UNK64X3530Accident · No injuriesClosedGrumman G164 · Tallulah, LAAug 22, 1964 · N696Y · Substantial damage NTSB UNK64X3510Accident · No injuriesClosedCessna 185 · Cypremort Pt, LAAug 21, 1964 · N2689Z · Substantial damage NTSB UNK64X3470Accident · No injuriesClosedBeechcraft D45 · New Orleans, LAAug 19, 1964 · N7810B · Substantial damage NTSB UNK64X3446Accident · No injuriesClosedPiper PA18A · Bunkie, LAAug 18, 1964 · N2892Z · Substantial damage NTSB UNK64X3430Accident · No injuriesClosedBoeing A75N1 · Raceland, LAAug 16, 1964 · N49659 · Substantial damage NTSB UNK64X3387Accident · No injuriesClosedBoeing A75N1 · Thibodaux, LAAug 15, 1964 · N55361 · Substantial damage NTSB UNK64X3377Accident · No injuriesClosedHawker MK11 · Houma, LAAug 14, 1964 · N54M · Substantial damage NTSB UNK64X3373Accident · No injuriesClosedBoeing B75N1 · St James, LAAug 14, 1964 · N64546 · Substantial damage NTSB UNK64X3351Accident · Minor injuriesClosedBoeing A-75 · Vacherie, LAAug 13, 1964 · N67090 · Substantial damage NTSB UNK64X3336Accident · Minor injuriesClosedSikorsky S62A · Leesville, LAAug 11, 1964 · N987 · Substantial damage NTSB UNK64X3318Accident · Minor injuriesClosedPiper PA22 · Thibodaux, LAAug 10, 1964 · N1839P · Substantial damage NTSB UNK64X3168Accident · No injuriesClosedTaylorcraft DC065 · Shreveport, LAAug 2, 1964 · N50128 · Substantial damage NTSB UNK64X3132Accident · Minor injuriesClosedPiper PA18A · Pioneer, LAJul 31, 1964 · N9080D · Destroyed NTSB UNK64X3126Accident · Serious injuriesClosedBell 47G2 · Cameron, LAJul 30, 1964 · N74094 · Substantial damage NTSB UNK64X3117Accident · No injuriesClosedCessna 180 · Lake Salvadore, LAJul 30, 1964 · N4626U · Substantial damage NTSB UNK64X2897Accident · No injuriesClosedPiper PA25 · Reserve, LAJul 18, 1964 · N6151Z · Substantial damage NTSB UNK64X2854Accident · Minor injuriesClosedBoeing E75N1 · Hosston, LAJul 16, 1964 · N5945V · Substantial damage NTSB UNK64X2828Accident · Minor injuriesClosedRyan Navion · St James, LAJul 14, 1964 · N4205K · Substantial damage NTSB UNK64X2819Accident · No injuriesClosedPiper PA24 · Ruston, LAJul 14, 1964 · N5987P · Substantial damage NTSB UNK64X2808Accident · No injuriesClosedWaco ASO · Delta Bridge, LAJul 13, 1964 · N268M · Substantial damage NTSB UNK64X2681Accident · No injuriesClosedChampion 7FC · Kaplan, LAJul 6, 1964 · N4851E · Destroyed NTSB UNK64X2680Accident · No injuriesClosedGrumman G164 · Basile, LAJul 6, 1964 · N460RF · Substantial damage