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 FTW73DRD21Accident · No injuriesClosedCessna 185A · Chauvin, LAApr 30, 1973 · N70279 · Substantial damage NTSB FTW73DRD20Accident · No injuriesClosedGrumman G-164 · Ville Platte, LAApr 30, 1973 · N515Y · Substantial damage NTSB FTW73DRJ30Accident · No injuriesClosedPiper PA-28R · Alexandria, LAApr 4, 1973 · N5349T · Substantial damage NTSB FTW73DRJ29Accident · No injuriesClosedGrumman G-164A · Delhi, LAApr 2, 1973 · N964X · Substantial damage NTSB FTW73FRD18Accident · Minor injuriesClosedGrumman G-164A · Oberlin, LAApr 1, 1973 · N7862 · Substantial damage NTSB FTW73AF056Accident · No injuriesClosedHughes 369HS · Point La Hache, LAMar 28, 1973 · N9031F · Substantial damage NTSB FTW73AF054Accident · No injuriesClosedBell 47G-4A · Cameron, LAMar 22, 1973 · N1445W · Destroyed NTSB FTW73AF053Accident · 2 fatalClosedBell 206B · Patterson, LAMar 20, 1973 · N36AL · Destroyed NTSB FTW73DRJ28Accident · No injuriesClosedBoeing A75 · Mangham, LAMar 7, 1973 · N49954 · Substantial damage NTSB FTW73DRJ26Accident · No injuriesClosedPiper J3C-85 · Glenmora, LAMar 7, 1973 · N6529H · Substantial damage NTSB FTW73AF049Accident · 1 fatalClosedPiper PA-28R · Baton Rouge, LAMar 1, 1973 · N4991J · Destroyed NTSB FTW73AF047Accident · 1 fatalClosedBell 206B · Amelia, LAFeb 22, 1973 · N35AL · Destroyed NTSB FTW73AF044Accident · 5 fatalClosedBell 206B · Morgan City, LAFeb 19, 1973 · N14831 · Destroyed NTSB FTW73AF043Accident · Serious injuriesClosedBell 206B · Patterson, LAFeb 19, 1973 · N2941W · Substantial damage NTSB FTW73FRD17Accident · No injuriesClosedPiper PA-24 · New Orleans, LAFeb 17, 1973 · N8348P · Substantial damage NTSB FTW73DRD15Accident · No injuriesClosedBell 206B · Lake Charles, LAFeb 2, 1973 · N7065J · Substantial damage NTSB FTW73FRD14Accident · No injuriesClosedBeech B95 · New Orleans, LADec 28, 1972 · N635B · Substantial damage NTSB FTW73DRD12Accident · No injuriesClosedGrumman G-164A · Duson, LADec 18, 1972 · N962X · Substantial damage NTSB FTW73AF029Accident · 1 fatalClosedHughes 369HS · Venice, LADec 18, 1972 · N9093F · Destroyed NTSB FTW73AF027Accident · No injuriesClosedBeech C-45H · Houma, LADec 12, 1972 · N3329G · Substantial damage NTSB FTW73AF021Accident · 1 fatalClosedCessna 150F · New Orleans, LANov 30, 1972 · N6958F · Destroyed NTSB FTW73FRD11Accident · No injuriesClosedPiper PA-28 · New Orleans, LANov 22, 1972 · N486FL · Substantial damage NTSB FTW73DRJ24Accident · Minor injuriesClosedAeronca 7DC · Lk Providence, LANov 22, 1972 · N81475 · Substantial damage NTSB FTW73FRJ21Accident · No injuriesClosedCessna 150L · Shreveport, LANov 19, 1972 · N5202Q · Substantial damage NTSB FTW73DRJ22Accident · No injuriesClosedCessna 205 · Bonita, LANov 15, 1972 · N511RJ · Substantial damage NTSB FTW73DRD10Accident · Minor injuriesClosedBell 47G-4A · Dulac, LANov 10, 1972 · N4708R · Substantial damage NTSB FTW73DRJ20Accident · Serious injuriesClosedChampion 7GCB · Lak Providence, LANov 4, 1972 · N8523E · Destroyed NTSB FTW73FRD09Accident · Serious injuriesClosedPiper PA-18 · Bayou Chene, LAOct 15, 1972 · N1860P · Destroyed NTSB FTW73FRD08Accident · Serious injuriesClosedAeronca 7AC · Fenton, LAOct 12, 1972 · N4198E · Substantial damage NTSB FTW73FRD07Accident · Minor injuriesClosedCessna 180 · Patterson, LASep 19, 1972 · N41CH · Substantial damage NTSB FTW73FRJ15Accident · Minor injuriesClosedBoeing E75N1 · Mcdade, LASep 16, 1972 · N5200N · Substantial damage NTSB FTW73FRD06Accident · No injuriesClosedCessna 150E · Chalamette, LASep 15, 1972 · N2590J · Substantial damage NTSB FTW73DRJ16Accident · No injuriesClosedBoeing A75N1 · Evelyn, LASep 13, 1972 · N9199R · Substantial damage NTSB FTW73FRD05Accident · No injuriesClosedBell 47J2A · Leeville, LASep 9, 1972 · N8431E · Substantial damage NTSB FTW73AF009Accident · 1 fatalClosedBeech F35 · Ruston, LASep 4, 1972 · N5048B · Destroyed NTSB FTW73DRJ14Accident · Minor injuriesClosedPiper PA-24 · West Monroe, LASep 2, 1972 · N6166P · Destroyed NTSB FTW73FRD04Accident · No injuriesClosedBell 47J-2A · Venice, LAAug 29, 1972 · N3092G · Substantial damage NTSB FTW73DRD03Accident · No injuriesClosedBeech B23 · Abita Sprgs, LAAug 26, 1972 · N4025T · Substantial damage NTSB FTW73DRJ10Accident · No injuriesClosedTaylorcraft BC12-D · Jones, LAAug 19, 1972 · N96770 · Substantial damage NTSB FTW73FRJ08Accident · No injuriesClosedPiper PA-25 · Holly Ridge, LAAug 15, 1972 · N4525Y · Substantial damage NTSB FTW73FRJ09Accident · 1 fatalClosedPiper PA-18 · Mangham, LAAug 11, 1972 · N9490D · Destroyed NTSB FTW73FRJ11Accident · No injuriesClosedCessna 150 · Natchitoches, LAAug 10, 1972 · N1630Q · 2 aircraft · Substantial damage NTSB FTW73FRD02Accident · No injuriesClosedS.N.I.A.S SA316B · St.Martinville, LAAug 8, 1972 · N5957 · Substantial damage NTSB FTW73DRD01Accident · No injuriesClosedCessna A185E · Jeanerette, LAAug 8, 1972 · N77AM · Substantial damage NTSB FTW73FRJ07Accident · No injuriesClosedChampion 7KCAB · Shreveport, LAAug 5, 1972 · N7600F · Substantial damage NTSB FTW73FRJ06Accident · 1 fatalClosedPiper PA-18 · Tallulah, LAAug 3, 1972 · N7465D · Destroyed NTSB FTW73FRJ05Accident · Serious injuriesClosedCessna U206 · Many, LAAug 2, 1972 · N3944G · Substantial damage NTSB FTW73AF006Accident · 2 fatalClosedCessna 150H · White Castle, LAAug 2, 1972 · N7089S · Destroyed NTSB FTW73IF005Incident · No injuriesClosedBoeing 727 · New Orleans, LAJul 26, 1972 · N4735 · Minor damage NTSB FTW73FRJ04Accident · No injuriesClosedPiper PA-25 · Alexandria, LAJul 17, 1972 · N4824Y · Substantial damage