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 FTW74DPJ08Accident · No injuriesClosedCessna 175C · Hollis, LASep 2, 1973 · N8369T · Substantial damage NTSB FTW74FRJ11Accident · Minor injuriesClosedAmer Avco AA-1 · Converse, LASep 1, 1973 · N5928L · Substantial damage NTSB FTW74FRJ10Accident · Minor injuriesClosedPiper PA-28 · Shreveport, LAAug 31, 1973 · N5064T · Substantial damage NTSB FTW74DRJ09Accident · No injuriesClosedBoeing A75N1 · Mansfield, LAAug 29, 1973 · N212PC · Substantial damage NTSB FTW74DRD08Accident · Minor injuriesClosedGrumman G-164A · Welsh, LAAug 27, 1973 · N6647 · Destroyed NTSB FTW74FRJ12Accident · Minor injuriesClosedPiper PA-25 · Rayville, LAAug 24, 1973 · N7581Z · Destroyed NTSB FTW74DRJ07Accident · No injuriesClosedCessna 150H · Ruston, LAAug 23, 1973 · N23392 · Substantial damage NTSB FTW74DRJ06Accident · Minor injuriesClosedAmer Avco AA1-A · Leesville, LAAug 22, 1973 · N6448L · Destroyed NTSB FTW74FRD06Accident · No injuriesClosedAmer Avco AA-5 · Westwego, LAAug 18, 1973 · N6382L · Substantial damage NTSB FTW74DRJ08Accident · No injuriesClosedTaylorcraft BC12-D · Collingston, LAAug 17, 1973 · N4359A · Substantial damage NTSB FTW74DRD05Accident · Minor injuriesClosedCessna 185E · Venice, LAAug 14, 1973 · N5818J · Substantial damage NTSB FTW74FRJ04Accident · No injuriesClosedPiper PA-32 · Minden, LAAug 11, 1973 · N3691W · Substantial damage NTSB MIA74AM013Accident · Serious injuriesClosedDouglas DC-10 · New Orleans, LAAug 10, 1973 · N67NA · No damage NTSB FTW74DRD07Accident · No injuriesClosedGrumman G-164A · Bell City, LAAug 7, 1973 · N5305 · Substantial damage NTSB FTW74FRJ03Accident · Minor injuriesClosedBell 47G-5A · Shreveport, LAJul 30, 1973 · N58077 · Substantial damage NTSB FTW74AF006Accident · 1 fatalClosedBeech B35 · Natchitoches, LAJul 28, 1973 · N8798A · Destroyed NTSB FTW74DRD04Accident · Serious injuriesClosedCessna 150K · Baton Rouge, LAJul 26, 1973 · N8359M · Destroyed NTSB FTW74FRD03Accident · No injuriesClosedGrumman G-164A · Lake Charles, LAJul 19, 1973 · N4864 · Substantial damage NTSB FTW74AF003Accident · 3 fatalClosedBeech A60 · New Orleans, LAJul 18, 1973 · N7658D · Destroyed NTSB FTW74FRD02Accident · No injuriesClosedGrumman G-164 · Parks, LAJul 17, 1973 · N463RF · Substantial damage NTSB FTW74DRD01Accident · No injuriesClosedGrumman G-164 · Lake Arthur, LAJul 16, 1973 · N468RF · Substantial damage NTSB FTW74FRJ01Accident · No injuriesClosedCessna 310 · Ruston, LAJul 4, 1973 · N2606C · Substantial damage NTSB FTW74FRJ02Accident · Minor injuriesClosedAmer Avco AA-1B · West Monroe, LAJul 2, 1973 · N6277L · Destroyed NTSB FTW73FRD38Accident · No injuriesClosedGrumman G-164 · Thornwell, LAJun 27, 1973 · N464RF · Substantial damage NTSB FTW73DRD37Accident · Minor injuriesClosedGrumman G-164 · Breaux Bridge, LAJun 25, 1973 · N492Y · Substantial damage NTSB FTW73DRJ41Accident · No injuriesClosedAmer Avco AA-5 · Zwolle, LAJun 19, 1973 · N6177L · Substantial damage NTSB FTW73FRJ40Accident · 1 fatalClosedPiper PA-25 · Monroe, LAJun 14, 1973 · N8943L · Destroyed NTSB FTW73DRD36Accident · No injuriesClosedGrumman G-164 · Ville Platte, LAJun 5, 1973 · N10292 · Substantial damage NTSB FTW73DRD35Accident · No injuriesClosedGrumman G-164A · Abbeville, LAJun 4, 1973 · N7839 · Substantial damage NTSB FTW73FRD34Accident · No injuriesClosedGrumman G-164 · Church Point, LAJun 2, 1973 · N552Y · Substantial damage NTSB FTW73FRJ38Accident · Minor injuriesClosedBeech B23 · Monroe, LAMay 30, 1973 · N6102N · Substantial damage NTSB FTW73FRD32Accident · No injuriesClosedCessna 180 · St.Francisvlle, LAMay 28, 1973 · N9254C · Substantial damage NTSB FTW73FRD33Accident · No injuriesClosedGrumman G-164A · Kaplan, LAMay 26, 1973 · N6530 · Substantial damage NTSB FTW73DRD31Accident · No injuriesClosedCessna 150G · Lockport, LAMay 22, 1973 · N4092J · Substantial damage NTSB FTW73FRD30Accident · No injuriesClosedCessna 177 · New Orleans, LAMay 20, 1973 · N3146T · Substantial damage NTSB FTW73AF070Accident · 1 fatalClosedLuscombe 8A · Ama, LAMay 20, 1973 · N45882 · Destroyed NTSB FTW73DRD29Accident · Minor injuriesClosedBoeing A75 · Iowa, LAMay 19, 1973 · N62418 · Substantial damage NTSB FTW73FRD28Accident · Minor injuriesClosedCessna 172 · Braithwaite, LAMay 18, 1973 · N1195F · Substantial damage NTSB FTW73DRJ34Accident · No injuriesClosedCessna 180 · Mer Rouge, LAMay 16, 1973 · N4758B · Substantial damage NTSB FTW73FRD24Accident · Minor injuriesClosedCessna 150L · Baton Rouge, LAMay 14, 1973 · N18043 · Substantial damage NTSB FTW73FRJ33Accident · No injuriesClosedCessna 177RG · Shreveport, LAMay 13, 1973 · N1944Q · Substantial damage NTSB FTW73FRD27Accident · No injuriesClosedBoeing A75 · Crowley, LAMay 12, 1973 · N51440 · Substantial damage NTSB FTW73FRD26Accident · No injuriesClosedGrumman G-164A · Kinder, LAMay 12, 1973 · N951X · Substantial damage NTSB FTW73FRD25Accident · No injuriesClosedGrumman G-164 · Cade, LAMay 10, 1973 · N463RF · Substantial damage NTSB FTW73DRJ32Accident · No injuriesClosedPiper PA-25 · Mer Rouge, LAMay 10, 1973 · N7295Z · Substantial damage NTSB FTW73AF069Accident · Minor injuriesClosedCessna 180 · Houma, LAMay 10, 1973 · N4744U · Substantial damage NTSB FTW73DRD23Accident · No injuriesClosedBoeing A75 · Lacassine, LAMay 8, 1973 · N75263 · Substantial damage NTSB FTW73DRD22Accident · No injuriesClosedGrumman G-164 · Welsh, LAMay 8, 1973 · N458RF · Substantial damage NTSB FTW73AF068Accident · 2 fatalClosedCessna 172L · Slaughter, LAMay 7, 1973 · N7847G · Destroyed NTSB FTW73FRD19Accident · Minor injuriesClosedBeech B23 · St.Francisvlle, LAMay 3, 1973 · N7614R · Substantial damage