NTSB investigations, 1964, LA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.

Cases per year

19622026
NTSB investigations, 1964, LA per year, 1962–2026: 3,066 cases
19621
19633
1964120
1965109
1966108
1967118
1968100
1969100
197091
197175
197275
197388
197484
1975105
197693
1977106
1978108
1979103
1980110
198195
198278
198357
198472
198557
198647
198733
198836
198941
199040
199126
199225
199332
199425
199522
199640
199728
199827
199928
200026
200128
200226
200321
200427
200532
200618
200715
200813
200921
201016
201128
201223
201319
201419
201520
201621
201717
201818
201921
202023
202123
202216
202316
202426
202517
202610

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1964
    AND 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.

NTSB UNK65X1172Accident · No injuriesClosedPiper PA-24 · Opelousas, LADec 28, 1964 · N6994P · Substantial damageNTSB UNK65X1154Accident · No injuriesClosedCessna 172 · Galiano, LADec 27, 1964 · N2519U · Substantial damageNTSB UNK65X1134Accident · 1 fatalClosedPiper PA15 · Denham Springs, LADec 25, 1964 · N4360H · DestroyedNTSB UNK65X1127Accident · No injuriesClosedBeechraft T34A · Jonesboro, LADec 25, 1964 · N1007B · Substantial damageNTSB UNK65X1123Accident · No injuriesClosedBell 47J · Intracoastal C, LADec 24, 1964 · N6771D · Substantial damageNTSB UNK65X1048Accident · No injuriesClosedBeechcraft 35-33 · Mansfield, LADec 19, 1964 · N939T · DestroyedNTSB UNK65X1023Accident · No injuriesClosedCessna 310B · Shreveport, LADec 15, 1964 · N5363A · Substantial damageNTSB UNK65X0996Accident · Minor injuriesClosedCessna 185 · Buras, LADec 13, 1964 · N2690Z · Substantial damageNTSB UNK65X0950Accident · 3 fatalClosedBell 47J2 · Venice, LADec 7, 1964 · N73229 · DestroyedNTSB UNK65X0942Accident · No injuriesClosedCessna 180 · Franklin, LADec 7, 1964 · N9224T · Substantial damageNTSB UNK65X0813Accident · No injuriesClosedCurtiss C-46 · Baton Rouge, LANov 24, 1964 · N9885F · Substantial damageNTSB UNK65X0811Accident · Minor injuriesClosedAeronca 11AC · Benton, LANov 23, 1964 · N86257 · Substantial damageNTSB UNK65X0800Accident · No injuriesClosedBellanca 260A · Westwego, LANov 22, 1964 · N8871R · DestroyedNTSB UNK65X0730Accident · 1 fatalClosedCessna 172 · Caddo Lake, LANov 15, 1964 · N8268X · DestroyedNTSB UNK65X0649Accident · Serious injuriesClosedCessna 180 · Venice, LANov 10, 1964 · N6474X · No damageNTSB UNK65X0428Accident · Minor injuriesClosedCessna 170A · Freemason Is, LAOct 25, 1964 · N5402C · DestroyedNTSB UNK65X0361Accident · Minor injuriesClosedCessna 172 · Covington, LAOct 21, 1964 · N3719S · Substantial damageNTSB UNK65X0173Accident · Minor injuriesClosedNardi FN333 · Chandeleur Is, LAOct 7, 1964 · N622 · DestroyedNTSB UNK65X0161Accident · No injuriesClosedCessna 210 · Crowley, LAOct 6, 1964 · N9483X · Substantial damageNTSB UNK64X4204Incident · No injuriesClosedDouglas DC-6 · New Orleans, LASep 29, 1964 · N90885 · No damageNTSB UNK64X4073Accident · No injuriesClosedHoward DGA15P · Deridder, LASep 20, 1964 · N65595 · DestroyedNTSB UNK64X3983Accident · 1 fatalClosedPiper PA-18 · Rayville, LASep 14, 1964 · N40602 · DestroyedNTSB UNK64X3838Accident · No injuriesClosedCessna 180 · Houma, LASep 7, 1964 · N2677Y · DestroyedNTSB UNK64X3748Accident · No injuriesClosedBeechcraft H35 · Monroe, LASep 3, 1964 · N7959D · Substantial damageNTSB UNK64X3737Accident · 3 fatalClosedBeechcraft 35-33 · Vinton, LASep 2, 1964 · N612V · DestroyedNTSB UNK64X3699Accident · No injuriesClosedBoeing A75N1 · Whitteville, LAAug 31, 1964 · N62425 · Substantial damageNTSB UNK64X3691Accident · No injuriesClosedCessna 120 · Pride, LAAug 30, 1964 · N77008 · Substantial damageNTSB UNK64X3687Accident · No injuriesClosedFairchild 24 · Deridder, LAAug 30, 1964 · N81285 · Substantial damageNTSB UNK64X3650Accident · No injuriesClosedAeronca 7AC · Covington, LAAug 28, 1964 · N84363 · Substantial damageNTSB UNK64X3648Accident · No injuriesClosedAeronca 7AC · Slidell, LAAug 28, 1964 · N2202E · Substantial damageNTSB UNK64X3632Accident · No injuriesClosedHughes 269A · New Orleans, LAAug 27, 1964 · N8824F · Substantial damageNTSB UNK64X3622Accident · Minor injuriesClosedBoeing A75 · Monroe, LAAug 27, 1964 · N121J · DestroyedNTSB UNK64X3593Accident · Serious injuriesClosedPiper PA12 · Timbalier Is, LAAug 25, 1964 · N7669H · DestroyedNTSB UNK64X3571Accident · No injuriesClosedCessna 150 · Lacombe, LAAug 23, 1964 · N377E · No damageNTSB UNK64X3555Accident · No injuriesClosedPiper PA25 · Columbia, LAAug 23, 1964 · N6080Z · DestroyedNTSB UNK64X3534Accident · No injuriesClosedPiper PA24 · Baton Rouge, LAAug 22, 1964 · N8447P · Substantial damageNTSB UNK64X3530Accident · No injuriesClosedGrumman G164 · Tallulah, LAAug 22, 1964 · N696Y · Substantial damageNTSB UNK64X3510Accident · No injuriesClosedCessna 185 · Cypremort Pt, LAAug 21, 1964 · N2689Z · Substantial damageNTSB UNK64X3470Accident · No injuriesClosedBeechcraft D45 · New Orleans, LAAug 19, 1964 · N7810B · Substantial damageNTSB UNK64X3446Accident · No injuriesClosedPiper PA18A · Bunkie, LAAug 18, 1964 · N2892Z · Substantial damageNTSB UNK64X3430Accident · No injuriesClosedBoeing A75N1 · Raceland, LAAug 16, 1964 · N49659 · Substantial damageNTSB UNK64X3387Accident · No injuriesClosedBoeing A75N1 · Thibodaux, LAAug 15, 1964 · N55361 · Substantial damageNTSB UNK64X3377Accident · No injuriesClosedHawker MK11 · Houma, LAAug 14, 1964 · N54M · Substantial damageNTSB UNK64X3373Accident · No injuriesClosedBoeing B75N1 · St James, LAAug 14, 1964 · N64546 · Substantial damageNTSB UNK64X3351Accident · Minor injuriesClosedBoeing A-75 · Vacherie, LAAug 13, 1964 · N67090 · Substantial damageNTSB UNK64X3336Accident · Minor injuriesClosedSikorsky S62A · Leesville, LAAug 11, 1964 · N987 · Substantial damageNTSB UNK64X3318Accident · Minor injuriesClosedPiper PA22 · Thibodaux, LAAug 10, 1964 · N1839P · Substantial damageNTSB UNK64X3168Accident · No injuriesClosedTaylorcraft DC065 · Shreveport, LAAug 2, 1964 · N50128 · Substantial damageNTSB UNK64X3132Accident · Minor injuriesClosedPiper PA18A · Pioneer, LAJul 31, 1964 · N9080D · DestroyedNTSB UNK64X3126Accident · Serious injuriesClosedBell 47G2 · Cameron, LAJul 30, 1964 · N74094 · Substantial damage