NTSB investigations, 1981, LA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, newest first

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\") = 1981
    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 FTW81FRD31Accident · Minor injuriesClosedCessna 140 · Kinder, LAJul 3, 1981 · N3661V · DestroyedNTSB FTW81DA114Accident · No injuriesClosedBell 206B · Franklin, LAJul 2, 1981 · N45AL · Substantial damageNTSB FTW81DRJ20Accident · No injuriesClosedPiper PA-24 · Many, LAJun 24, 1981 · N8136P · Substantial damageNTSB FTW81IA109Incident · No injuriesClosedBeech B99 · Shreveport, LAJun 17, 1981 · N4499S · Minor damageNTSB FTW81FRD30Accident · Minor injuriesClosedPiper PA-38 · Lafayette, LAJun 16, 1981 · N2500N · Substantial damageNTSB FTW81FRD19Accident · 1 fatalClosedPitts S1C · Leroy, LAJun 11, 1981 · N70ST · DestroyedNTSB FTW81FA105Accident · 2 fatalClosedSwearingen SA226T · Cameron, LAJun 10, 1981 · N555AM · DestroyedNTSB FTW81DRJ18Accident · No injuriesClosedGrumman G-164A · Bonita, LAJun 8, 1981 · N6743Q · Substantial damageNTSB FTW81FRJ19Accident · No injuriesClosedCessna 182 · Simsboro, LAJun 7, 1981 · N7183E · Substantial damageNTSB FTW81FRD28Accident · No injuriesClosedGrumman G-164A · Morse, LAJun 4, 1981 · N7699 · Substantial damageNTSB FTW81FRD27Accident · Minor injuriesClosedBell 206B · Plaquemire, LAJun 3, 1981 · N90332 · DestroyedNTSB FTW81DRJ17Accident · No injuriesClosedAyers S2R · Jonesville, LAJun 2, 1981 · N8935Q · Substantial damageNTSB FTW81DRD26Accident · No injuriesClosedGrumman G-164A · Iowa, LAJun 2, 1981 · N4309 · Substantial damageNTSB FTW81FA098Accident · 1 fatalClosedAerospatial AS-350 · Cameron, LAMay 31, 1981 · N3607G · DestroyedNTSB FTW81FA097Accident · 4 fatalClosedBeech A-36TC · Shreveport, LAMay 28, 1981 · N6749H · DestroyedNTSB FTW81DRJ16Accident · No injuriesClosedGrumman G-164 · Jones, LAMay 27, 1981 · N612U · DestroyedNTSB FTW81DRJ15Accident · No injuriesClosedWSK PZL M-18 · Crowville, LAMay 25, 1981 · N4226N · Substantial damageNTSB FTW81DRD25Accident · No injuriesClosedCessna 185F · Westwego, LAMay 21, 1981 · N61741 · Substantial damageNTSB FTW81DA092Accident · Serious injuriesClosedDouglas DC-9 · New Orleans, LAMay 18, 1981 · N1295L · No damageNTSB FTW81FA090Accident · 1 fatalClosedCessna 172A · Verda, LAMay 13, 1981 · N7232T · DestroyedNTSB FTW81DRD24Accident · Serious injuriesClosedBell 206B · Cameron, LAMay 13, 1981 · N16612 · Substantial damageNTSB FTW81DRD23Accident · No injuriesClosedGrumman G-164A · Kinder, LAMay 8, 1981 · N9509 · Substantial damageNTSB FTW81DRJ13Accident · No injuriesClosedGrumman G-164B · Mer Rouge, LAApr 28, 1981 · N6809Q · Substantial damageNTSB FTW81DRD22Accident · No injuriesClosedGrumman G-164B · Swords, LAApr 28, 1981 · N48592 · Substantial damageNTSB FTW81DRD21Accident · No injuriesClosedGrumman G-164 · Chatagnier, LAApr 28, 1981 · N592Y · Substantial damageNTSB FTW81DRD20Accident · No injuriesClosedGrumman G-164A · Morse, LAApr 27, 1981 · N8498 · Substantial damageNTSB FTW81DA081Accident · Minor injuriesClosedBell 206L-1 · Leeville, LAApr 25, 1981 · N5000Y · Substantial damageNTSB FTW81DRD19Accident · No injuriesClosedGrum Amer AA-1B · Grand Isle, LAApr 23, 1981 · N8985L · Substantial damageNTSB FTW81FA071Accident · Minor injuriesClosedCessna 414 · Shreveport, LAApr 16, 1981 · N86EV · Substantial damageNTSB FTW81IA067Incident · No injuriesClosedBell 222 · Lake Charles, LAApr 9, 1981 · N38929 · No damageNTSB FTW81IA066Incident · No injuriesClosedSikorsky S-76A · Morgan City, LAApr 7, 1981 · N1546Z · Minor damageNTSB FTW81DRD17Accident · No injuriesClosedGrumman G-164A · Lake Charles, LAApr 3, 1981 · N6787Q · Substantial damageNTSB FTW81FA059Accident · 1 fatalClosedCessna 172P · Lake Charles, LAMar 27, 1981 · N52710 · DestroyedNTSB FTW81IA058Incident · No injuriesClosedEmbraer 110P1 · Lafayette, LAMar 25, 1981 · N691RA · Minor damageNTSB FTW81FA055Accident · Minor injuriesClosedBell 206L-1 · Cameron, LAMar 24, 1981 · N206EH · DestroyedNTSB FTW81FRD16Accident · No injuriesClosedGrumman G-164A · Bell City, LAMar 21, 1981 · N5477 · Substantial damageNTSB FTW81FRD15Accident · No injuriesClosedCessna 185 · Port Sulphur, LAMar 18, 1981 · N7380Q · DestroyedNTSB FTW81DRD14Accident · No injuriesClosedCessna 402B · Houma, LAMar 17, 1981 · N3767C · Substantial damageNTSB FTW81DRD13Accident · No injuriesClosedCessna 180H · Belle Chase, LAMar 11, 1981 · N9739G · Substantial damageNTSB FTW81FRJ10Accident · Minor injuriesClosedBeech C24R · Bossier City, LAFeb 20, 1981 · N5279M · Substantial damageNTSB FTW81FA030Accident · 4 fatalClosedCessna 310R · Houma, LAFeb 10, 1981 · N1323G · DestroyedNTSB FTW81DA031Accident · No injuriesClosedTed Smith 601 · Hammond, LAFeb 10, 1981 · N9501Q · Substantial damageNTSB FTW81DRJ09Accident · No injuriesClosedPiper PA-28 · Sterlington, LAJan 25, 1981 · N2232W · Substantial damageNTSB FTW81DA025Accident · No injuriesClosedBell 222 · Patterson, LAJan 21, 1981 · N5754B · Substantial damageNTSB FTW81FA024Accident · 3 fatalClosedPiper PA-23 · New Orleans, LAJan 15, 1981 · N6812Y · Destroyed