NTSB investigations, 1981, IN

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

19632026
NTSB investigations, 1981, IN per year, 1963–2026: 2,978 cases
19631
1964107
1965116
1966119
1967132
1968106
196988
197083
197181
197288
197377
197466
197586
197678
197790
197895
197970
198076
198152
198255
198354
198455
198554
198658
198753
198866
198945
199042
199133
199229
199335
199438
199533
199631
199736
199835
199922
200034
200129
200225
200320
200426
200520
200628
200723
200822
200930
201027
201126
201226
201322
201416
201519
201623
201722
201819
201922
202017
202121
202221
202316
202417
202513
20269

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\" = 'IN' 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 CHI82FEX05Accident · Serious injuriesClosedCessna 172 · Paoli, INDec 26, 1981 · N5072A · DestroyedNTSB CHI82FEX06Accident · No injuriesClosedCessna 182G · Jeffsonville, INDec 24, 1981 · N3414S · Substantial damageNTSB CHI82DEX03Accident · No injuriesClosedPiper PA-28 · Lafayette, INDec 11, 1981 · N3348T · Substantial damageNTSB CHI82DEX02Accident · No injuriesClosedPiper PA-22 · Anderson, INDec 5, 1981 · N1785P · Substantial damageNTSB CHI82FEX01Accident · Serious injuriesClosedPiper PA-31T · Madison, INNov 30, 1981 · N15SS · Substantial damageNTSB CHI82DET02Accident · No injuriesClosedGulfstream AA-5A · Peru, INNov 26, 1981 · N26758 · Substantial damageNTSB CHI82FA012Accident · 1 fatalClosedCessna 150 · Palmyra, INNov 14, 1981 · N4732X · DestroyedNTSB CHI82FA008Accident · 2 fatalClosedPiper PA-28 · Mooresville, INOct 25, 1981 · N70RA · DestroyedNTSB CHI82FA007Accident · 4 fatalClosedCessna 172 · Kokomo, INOct 22, 1981 · N21766 · DestroyedNTSB CHI82FET01Accident · No injuriesClosedCessna 150 · Ft Wayne, INOct 7, 1981 · N7688G · Substantial damageNTSB CHI81FEX30Accident · No injuriesClosedPiper PA-28 · Noblesville, INSep 29, 1981 · N2819F · Substantial damageNTSB CHI81FEX29Accident · No injuriesClosedAerospatial AS350D · Lynnville, INSep 29, 1981 · N200HE · Substantial damageNTSB CHI81FEX22Accident · Minor injuriesClosedCessna 152 · Cayuga, INSep 25, 1981 · N67946 · Substantial damageNTSB CHI81DEV35Accident · Minor injuriesClosedGrumman G-164A · Dana, INSep 23, 1981 · N9968 · DestroyedNTSB CHI81FET14Accident · 1 fatalClosedPDQ 2D · Goshen, INSep 12, 1981 · N8052F · DestroyedNTSB CHI81FET15Accident · No injuriesClosedBeech V35B · Ft Wayne, INSep 10, 1981 · N1632W · Substantial damageNTSB CHI81FET13Accident · Minor injuriesClosedCessna 172E · Laporte, INSep 8, 1981 · N5508T · Substantial damageNTSB CHI81FA098Accident · No injuriesClosedCessna 172N · Muncie, INSep 4, 1981 · N733XF · Substantial damageNTSB CHI81DEX27Accident · No injuriesClosedCessna 182RG · West Middleton, INJul 18, 1981 · N737HP · Substantial damageNTSB CHI81DEX26Accident · No injuriesClosedCessna 152 · Shelbyville, INJul 11, 1981 · N757MT · Substantial damageNTSB CHI81FEX25Accident · Serious injuriesClosedN American AT-6G · Indianapolis, INJul 7, 1981 · N42JM · Substantial damageNTSB CHI81FET10Accident · No injuriesClosedMooney M20F · South Bend, INJul 5, 1981 · N6373Q · Substantial damageNTSB CHI81FEX23Accident · No injuriesClosedGrum-Amer AA-5A · Waveland, INJul 3, 1981 · N26657 · Substantial damageNTSB CHI81FET09Accident · No injuriesClosedCessna R182 · Plymouth, INJun 28, 1981 · N757DC · Substantial damageNTSB CHI81FA068Accident · 4 fatalClosedGrum Amer AA-5A · Mccordsville, INJun 28, 1981 · N26774 · DestroyedNTSB CHI81FEX20Accident · No injuriesClosedGrumman G-164A · Remington, INJun 27, 1981 · N8571H · Substantial damageNTSB CHI81FEX21Accident · No injuriesClosedTaylorcraft BC-65 · Paoli, INJun 26, 1981 · N27671 · Substantial damageNTSB CHI81DEX24Accident · No injuriesClosedCessna 152 · Sedalia, INJun 26, 1981 · N757YL · Substantial damageNTSB CHI81FEX19Accident · Serious injuriesClosedCessna 172N · Jasonville, INJun 25, 1981 · N6031F · Substantial damageNTSB CHI81FEX18Accident · Minor injuriesClosedCessna 210J · Wirt, INJun 19, 1981 · N3394S · Substantial damageNTSB CHI81FEX17Accident · No injuriesClosedCessna 402 · Jeffersonville, INJun 13, 1981 · N140M · Substantial damageNTSB CHI81FET08Accident · Minor injuriesClosedPiper PA-28 · Syracuse, INJun 12, 1981 · N56459 · Substantial damageNTSB CHI81FEX16Accident · Serious injuriesClosedSchweizer 2-33A · Zionsville, INJun 11, 1981 · N17962 · Substantial damageNTSB CHI81FA064Accident · 2 fatalClosedBrantley B2B · Chesterton, INJun 10, 1981 · N2276U · DestroyedNTSB CHI81FEX15Accident · Serious injuriesClosedSmith Mini DSA-1 · Kokomo, INJun 7, 1981 · N1307 · DestroyedNTSB CHI81FET07Accident · Minor injuriesClosedPDQ 2-D · Ligonier, INJun 7, 1981 · N2282V · Substantial damageNTSB CHI81FA061Accident · 1 fatalClosedBeech T-34B · New Castle, INMay 31, 1981 · N74195 · DestroyedNTSB CHI81FA057Accident · 1 fatalClosedAero Comdr 560 · Walkerton, INMay 24, 1981 · N272GD · DestroyedNTSB CHI81FEX14Accident · No injuriesClosedPitts S-1C · Indianapolis, INMay 2, 1981 · N10FH · Substantial damageNTSB CHI81FA046Accident · 2 fatalClosedBellanca 7KCAB · Lafayette, INApr 12, 1981 · N36334 · DestroyedNTSB CHI81FET06Accident · No injuriesClosedLake LA-4 · Laporte, INApr 9, 1981 · N2892P · Substantial damageNTSB CHI81FEX13Accident · No injuriesClosedCessna 172 · Marion, INApr 5, 1981 · N4104F · Substantial damageNTSB CHI81FEX12Accident · No injuriesClosedPiper PA-28 · Portland, INMar 23, 1981 · N4143J · Substantial damageNTSB CHI81DEX07Accident · No injuriesClosedCessna 172G · Clarksville, INMar 15, 1981 · N4415L · Substantial damageNTSB CHI81FEX11Accident · No injuriesClosedErco 415-E · Carlisle, INFeb 21, 1981 · N94773 · Substantial damageNTSB CHI81FEX10Accident · Serious injuriesClosedCessna 182 · Indianapolis, INFeb 20, 1981 · N5362N · DestroyedNTSB CHI81FA028Accident · 1 fatalClosedPiper PA-28R · Fort Wayne, INFeb 18, 1981 · N7496J · DestroyedNTSB CHI81FA027Accident · 1 fatalClosedPiper PA-32 · Loganspopt, INFeb 18, 1981 · N4341F · DestroyedNTSB CHI81IA025CaseClosedSwearingen SA226 · Indianapolis, INFeb 13, 1981 · N325BANTSB CHI81FET04Accident · No injuriesClosedMitsubishi MU-2B · Wabash, INJan 21, 1981 · N770MA · Substantial damage