NTSB investigations, 1980, AL

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, 1980, AL per year, 1962–2026: 2,501 cases
19621
19631
196461
196592
196670
196785
196868
196975
197089
197173
197276
197382
197467
197571
197677
197782
197872
197950
198050
198148
198261
198360
198441
198545
198648
198745
198836
198933
199032
199130
199240
199333
199427
199542
199632
199717
199827
199929
200017
200125
200227
200330
200427
200522
200624
200729
200828
200913
20108
201117
201225
201310
201424
201523
201612
201719
201820
201915
202017
202115
202221
202319
202411
202518
202617

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\") = 1980
    AND c.\"eventStateOrRegion\" = 'AL' 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 ATL81DKJ03Accident · No injuriesClosedCessna 402B · Fairhope, ALNov 25, 1980 · N7628Q · Substantial damageNTSB ATL81FA007Accident · 4 fatalClosedCessna T188C · Theodore, ALOct 11, 1980 · N2181J · 2 aircraft · DestroyedNTSB ATL81DKJ01Accident · No injuriesClosedBeech C18S · Theodore, ALOct 5, 1980 · N6806C · Substantial damageNTSB ATL80DKJ32Accident · No injuriesClosedBeech C24R · Decatur, ALSep 29, 1980 · N2225L · Substantial damageNTSB ATL88DKJ34Accident · No injuriesClosedPiper PA-25 · Bay Minette, ALSep 26, 1980 · N7726Z · DestroyedNTSB ATL81FA099Accident · No injuriesClosedSnow AT302A · Selma, ALSep 25, 1980 · N8603S · Substantial damageNTSB ATL80DKJ29Accident · No injuriesClosedCessna 182M · Iron City, ALSep 13, 1980 · N71451 · Substantial damageNTSB ATL81FKJ28Accident · Minor injuriesClosedGrumman G-164 · Bay Minette, ALSep 9, 1980 · N463RF · Substantial damageNTSB ATL80DKJ31Accident · No injuriesClosedPiper PA-28R · Redstone Arsnl, ALSep 8, 1980 · N1996H · Substantial damageNTSB ATL80DKJ27Accident · Minor injuriesClosedPiper PA-28 · Ashville, ALAug 22, 1980 · N4520T · Substantial damageNTSB ATL80FKJ26Accident · Serious injuriesClosedGrumman G-164B · Autaugaville, ALAug 13, 1980 · N6797Q · DestroyedNTSB ATL80DKJ24Accident · No injuriesClosedCessna 150 · Hartselle, ALAug 8, 1980 · N1640Q · Substantial damageNTSB ATL80DKJ25Accident · Minor injuriesClosedGrumman G-164 · Cherokee, ALAug 7, 1980 · N7367 · Substantial damageNTSB ATL80FKJ22Accident · No injuriesClosedCessna R182 · Anniston, ALAug 3, 1980 · N510JL · Substantial damageNTSB ATL80FA080Accident · No injuriesClosedGrumman G-164A · Samson, ALJul 30, 1980 · N8623H · Substantial damageNTSB ATL80DKJ20Accident · No injuriesClosedHughes 269B · Decatur, ALJul 30, 1980 · N9533F · DestroyedNTSB ATL80FKJ19Accident · No injuriesClosedBeech S35 · Selma, ALJul 9, 1980 · N6138V · Substantial damageNTSB ATL80DKJ17Accident · No injuriesClosedBeech 58 · Jackson, ALJul 8, 1980 · N9147Q · Substantial damageNTSB ATL80DKJ18Accident · No injuriesClosedPiper PA-28R · Dothan, ALJul 7, 1980 · N36586 · Substantial damageNTSB ATL80DKJ16Accident · No injuriesClosedCessna 172 · Butler, ALJul 3, 1980 · N738AU · Substantial damageNTSB ATL80FKJ15Accident · No injuriesClosedErco 415-C · Cullman, ALJun 30, 1980 · N2443H · Substantial damageNTSB ATL80FA059Accident · 2 fatalClosedCessna 182 · Omaha, ALJun 23, 1980 · N701SP · DestroyedNTSB ATL80FKJ13Accident · Minor injuriesClosedPitts S-2S · Alabaster, ALJun 21, 1980 · N555JG · DestroyedNTSB ATL80FA054Accident · No injuriesClosedSwearingen SA226A · Birmingham, ALJun 16, 1980 · N205MB · Substantial damageNTSB ATL80FKJ12Accident · Minor injuriesClosedPiper J5A · Cullman, ALJun 7, 1980 · N50674 · Substantial damageNTSB ATL80FKJ11Accident · Minor injuriesClosedCessna 150 · Decatur, ALJun 6, 1980 · N8584G · Substantial damageNTSB ATL80FKJ09Accident · No injuriesClosedCessna T188 · St Elmo, ALJun 2, 1980 · N1992J · Substantial damageNTSB ATL80DKJ08Accident · No injuriesClosedPiper PA-28 · Ashland, ALJun 2, 1980 · N9343W · Substantial damageNTSB ATL80DKJ07Accident · No injuriesClosedCessna 150 · Florence, ALJun 1, 1980 · N50169 · Substantial damageNTSB ATL80FA049Accident · 6 fatalClosedPiper PA-31 · Mobile, ALMay 28, 1980 · N6492L · DestroyedNTSB ATL80DKJ06Accident · No injuriesClosedBeech B19 · Oneonta, ALMay 25, 1980 · N6587R · DestroyedNTSB ATL80DKJ05Incident · No injuriesClosedGlobe GC-1B · Spring Hill, ALMay 22, 1980 · N80776 · Minor damageNTSB ATL80DKJ02Accident · No injuriesClosedCessna 150 · Camden, ALMay 20, 1980 · N7017S · Substantial damageNTSB ATL80DKJ14Accident · No injuriesClosedCessna 172R · Huntsville, ALMay 8, 1980 · N91RA · Substantial damageNTSB ATL80DKJ04Accident · No injuriesClosedCessna 182 · Mobile, ALMay 5, 1980 · N2544R · Substantial damageNTSB ATL80FKJ03Accident · Minor injuriesClosedCessna 182 · Heflin, ALMay 4, 1980 · N9986B · DestroyedNTSB MIA80DKJ31Accident · No injuriesClosedPiper PA-31 · Eufaula, ALApr 25, 1980 · N94EM · Substantial damageNTSB MIA80DKJ30Accident · No injuriesClosedCessna 172 · Clayton, ALApr 22, 1980 · N6624H · Substantial damageNTSB MIA80FKJ29Accident · Minor injuriesClosedPiper PA-28R · Foley, ALApr 16, 1980 · N7422J · Substantial damageNTSB MIA80FKJ34Accident · No injuriesClosedBeech 95-B55 · Montgomery, ALApr 10, 1980 · N75RA · Substantial damageNTSB MIA80FKJ28Accident · No injuriesClosedPiper PA-30 · Birmingham, ALApr 4, 1980 · N8328Y · Substantial damageNTSB MIA80FKJ27Accident · 1 fatalClosedBensen BTS8-M · Selma, ALMar 23, 1980 · N554A · DestroyedNTSB MIA80FA049Accident · 2 fatalClosedCessna U206 · York, ALMar 19, 1980 · N756SM · DestroyedNTSB MIA80DKJ23Accident · No injuriesClosedPiper PA-32 · Hokes Bluff, ALFeb 25, 1980 · N3515M · Substantial damageNTSB MIA80FKJ22Accident · Serious injuriesClosedErco 415-C · Laceys Spring, ALFeb 24, 1980 · N3546H · Substantial damageNTSB MIA80FKJ21Accident · No injuriesClosedCessna 152 · Montgomery, ALFeb 23, 1980 · N24210 · Substantial damageNTSB MIA80FKJ20Accident · No injuriesClosedCessna 150 · North Johns, ALFeb 18, 1980 · N3956J · Substantial damageNTSB MIA80DKJ18Accident · No injuriesClosedMaule M5 · Foley, ALFeb 8, 1980 · N9235E · Substantial damageNTSB MIA80FKJ17Accident · Serious injuriesClosedStinson 108-1 · Irvington, ALFeb 6, 1980 · N8537K · DestroyedNTSB MIA80FA028Accident · No injuriesClosedPiper PA-23 · Mobile, ALJan 11, 1980 · N389EB · Substantial damage