NTSB investigations, 1981, AL

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1981, 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\") = 1981
    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 ATL82FKJ08Accident · No injuriesClosedCessna 152 · Phenix City, ALDec 13, 1981 · N64992 · DestroyedNTSB ATL82FKJ07Accident · No injuriesClosedCessna 150 · Birmingham, ALDec 9, 1981 · N11623 · Substantial damageNTSB ATL82FKJ06Accident · Serious injuriesClosedCessna 150 · Russellville, ALNov 11, 1981 · N7206S · Substantial damageNTSB ATL82FKJ04Accident · No injuriesClosedCessna 172M · Selma, ALNov 8, 1981 · N82DJ · DestroyedNTSB ATL82DKJ03Accident · No injuriesClosedCessna T210N · Bayou La Batre, ALNov 8, 1981 · N6335C · DestroyedNTSB ATL82FKJ05Accident · No injuriesClosedBeech 3NM · Ohatchee, ALNov 2, 1981 · N16139 · Substantial damageNTSB ATL82FA011Accident · No injuriesClosedBeech 58 · Selma, ALOct 27, 1981 · N755CF · Substantial damageNTSB ATL82DKJ01Accident · No injuriesClosedPiper PA-28 · Dothan, ALOct 7, 1981 · N22199 · Substantial damageNTSB ATL82DKJ02Accident · No injuriesClosedPiper PA-28 · Hurtsboro, ALOct 4, 1981 · N47321 · Substantial damageNTSB ATL82FA001Accident · 2 fatalClosedPiper PA-38 · Gadsden, ALOct 1, 1981 · N2591C · DestroyedNTSB ATL81DKJ37Accident · No injuriesClosedCessna 182 · Elberta, ALSep 19, 1981 · N6075B · Substantial damageNTSB ATL81FKJ36Accident · Minor injuriesClosedAir & Space 18A · Huntsville, ALSep 13, 1981 · N6154S · Substantial damageNTSB ATL81FA116Accident · 2 fatalClosedPiper PA-38 · Cullman, ALSep 13, 1981 · N2471B · DestroyedNTSB ATL81FKJ35Accident · No injuriesClosedBellanca 14-19 · Weaver, ALSep 12, 1981 · N36KC · Substantial damageNTSB ATL81DA113Incident · No injuriesClosedBoeing 727 · Birmingham, ALSep 11, 1981 · N8888Z · No damageNTSB ATL81FKJ34Accident · No injuriesClosedCessna 172 · Bay Minette, ALAug 31, 1981 · N7006A · Substantial damageNTSB ATL81DKJ33Accident · Minor injuriesClosedPiper PA-28 · Brundidge, ALAug 26, 1981 · N2155F · Substantial damageNTSB ATL81DKJ32Accident · Serious injuriesClosedPiper PA-32 · Tuscaloosa, ALAug 16, 1981 · N4529X · DestroyedNTSB ATL81DKJ31Accident · Minor injuriesClosedCessna 150 · Huntsville, ALAug 15, 1981 · N22626 · DestroyedNTSB ATL81DKJ30Accident · No injuriesClosedCessna 150M · Hamilton, ALAug 13, 1981 · N8127U · DestroyedNTSB ATL81DKJ29Accident · No injuriesClosedCessna 172N · Daviston, ALAug 10, 1981 · N5697E · Substantial damageNTSB ATL81DKJ28Accident · No injuriesClosedPiper PA-32 · Butler, ALAug 8, 1981 · N8165H · Substantial damageNTSB ATL81FKJ27Accident · No injuriesClosedAyres S2R · Ft Mitchel, ALAug 3, 1981 · N9063N · Substantial damageNTSB ATL81DKJ26Accident · No injuriesClosedPiper PA-28 · Bessemer, ALJul 25, 1981 · N5119G · DestroyedNTSB ATL81FA101Accident · 4 fatalClosedCessna 210B · Plantersville, ALJul 24, 1981 · N9713X · DestroyedNTSB ATL81FKJ25Accident · Serious injuriesClosedCessna 177B · Wetumpka, ALJul 17, 1981 · N30760 · DestroyedNTSB ATL81FKJ23Accident · No injuriesClosedStinson 108-2 · Huntsville, ALJul 14, 1981 · N9388K · DestroyedNTSB ATL81FKJ24Accident · 1 fatalClosedPiper J3C-65 · Fadette, ALJul 13, 1981 · N2220M · Substantial damageNTSB ATL81DKJ22Accident · No injuriesClosedHiller Acft UH-12E · Centreville, ALJul 10, 1981 · N702WA · DestroyedNTSB ATL81FA090Accident · 2 fatalClosedCessna 182M · Haleyville, ALJul 2, 1981 · N71859 · DestroyedNTSB ATL81FKJ38Accident · Serious injuriesClosedCessna U206 · Elberta, ALJun 28, 1981 · N5277U · DestroyedNTSB ATL81FA083Accident · 2 fatalClosedPiper PA-38 · Smiths Station, ALJun 18, 1981 · N2599B · DestroyedNTSB ATL81FKJ21Accident · No injuriesClosedCessna 182RG · Gadsden, ALMay 25, 1981 · N4949S · Substantial damageNTSB ATL81DKJ20Accident · No injuriesClosedCessna 152 · Huntsville, ALMay 23, 1981 · N6489M · Substantial damageNTSB ATL81FA067Accident · No injuriesClosedAdams A50S · Montevallo, ALApr 18, 1981 · N1062X · Substantial damageNTSB ATL81IA065Incident · No injuriesClosedCessna 414 · Montgomery, ALApr 16, 1981 · N5637C · Minor damageNTSB ATL81DKJ17Accident · Minor injuriesClosedCessna 172 · Maysville, ALApr 9, 1981 · N12667 · DestroyedNTSB ATL81FKJ16Accident · No injuriesClosedCessna 150 · Ozark, ALMar 19, 1981 · N8207S · Substantial damageNTSB ATL81DKJ14Accident · No injuriesClosedPiper PA-38 · Auburn, ALMar 15, 1981 · N2523T · Substantial damageNTSB ATL81DKJ13Accident · No injuriesClosedPiper PA-38 · Bessemer, ALMar 6, 1981 · N2534C · Substantial damageNTSB ATL81FA052Accident · 4 fatalClosedBeech B23 · Mobile, ALMar 2, 1981 · N7606R · DestroyedNTSB ATL81FA051Accident · 1 fatalClosedPiper PA-30 · Autaugaville, ALMar 1, 1981 · N7443Y · DestroyedNTSB ATL81FKJ12Accident · No injuriesClosedBeech K35 · Wetumpka, ALFeb 26, 1981 · N133VW · Substantial damageNTSB ATL81DKJ11Accident · No injuriesClosedPiper PA-18 · Alabaster, ALFeb 15, 1981 · N6715C · Substantial damageNTSB ATL81FKJ10Accident · No injuriesClosedBeech V35TC · Eufaula, ALFeb 9, 1981 · N265T · Substantial damageNTSB ATL81FKJ09Accident · No injuriesClosedPiper PA-32R · Birmingham, ALJan 22, 1981 · N1435H · Substantial damageNTSB ATL81DKJ06Accident · No injuriesClosedCessna 172 · Dothan, ALJan 13, 1981 · N78803 · Substantial damageNTSB ATL81FKJ05Accident · Minor injuriesClosedCessna 185 · Evergreen, ALJan 3, 1981 · N6305E · Destroyed