NTSB investigations, 1971, IN

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1971, 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\") = 1971
    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 CHI72FEA25Accident · No injuriesClosedCessna 172 · Greencastle, INDec 20, 1971 · N46374 · Substantial damageNTSB CHI72AC052Accident · 1 fatalClosedPiper PA-22 · Evansville, INDec 16, 1971 · N8641C · DestroyedNTSB CHI72DEA24Accident · No injuriesClosedCessna 172 · Martinsville, INDec 11, 1971 · N7613G · Substantial damageNTSB CHI72FET11Accident · Serious injuriesClosedCessna 175 · Auburn, INDec 4, 1971 · N7627M · Substantial damageNTSB CHI72FEA23Accident · Minor injuriesClosedCessna 150 · Pittsboro, INNov 26, 1971 · N5988G · Substantial damageNTSB CHI72FEA19Accident · No injuriesClosedPiper PA-28 · Indianapolis, INNov 12, 1971 · N4953L · Substantial damageNTSB CHI72FEA21Accident · No injuriesClosedCessna 310J · Monticello, INNov 8, 1971 · N3109L · Substantial damageNTSB CHI72FEA17Accident · No injuriesClosedBensen B8M · Greenwood, INOct 30, 1971 · N8609E · Substantial damageNTSB CHI72FET10Accident · No injuriesClosedHughes 269A · Griffith, INOct 26, 1971 · N8810F · Substantial damageNTSB CHI72DEA22Accident · No injuriesClosedBeech J35 · Anderson, INOct 22, 1971 · N3056C · Substantial damageNTSB CHI72FET09Accident · No injuriesClosedCessna 170 · Winamac, INOct 8, 1971 · N4412V · Substantial damageNTSB CHI72DEA16Accident · No injuriesClosedPiper PA-32 · Anderson, INOct 6, 1971 · N8620N · Substantial damageNTSB CHI72DEA14Accident · No injuriesClosedStinson 108-3 · Acton, INOct 2, 1971 · N6919M · DestroyedNTSB CHI72DEA15Accident · No injuriesClosedTaylorcraft BC12-D · Palmyra, INOct 1, 1971 · N5610M · Substantial damageNTSB CHI72FEA20Accident · No injuriesClosedCessna 210G · Laconia, INSep 26, 1971 · N5901F · Substantial damageNTSB CHI72FEA12Accident · No injuriesClosedWilson B8M · Columbus, INSep 24, 1971 · N4274 · Substantial damageNTSB CHI72FET08Accident · Minor injuriesClosedLuscombe 8A · Elkhart, INSep 16, 1971 · N71375 · Substantial damageNTSB CHI72DEA18Accident · No injuriesClosedCessna 172L · Martinsville, INSep 3, 1971 · N2427L · Substantial damageNTSB CHI72AC019Accident · 2 fatalClosedPiper PA-22 · Angola, INSep 3, 1971 · N2730P · DestroyedNTSB CHI72FEA11Accident · Serious injuriesClosedBeech B35 · Monon, INSep 1, 1971 · N5166C · DestroyedNTSB CHI72DEA13Accident · No injuriesClosedPiper PA-28 · Delphi, INAug 30, 1971 · N6018W · Substantial damageNTSB CHI72FET06Accident · Minor injuriesClosedBell 47G-2 · Laporte, INAug 18, 1971 · N2495B · DestroyedNTSB CHI72FEA10Accident · No injuriesClosedBellanca 14-13 · Whitestown, INAug 18, 1971 · N86874 · Substantial damageNTSB CHI72FET05Accident · Minor injuriesClosedTaylorcraft BC-12D · Syracuse, INAug 15, 1971 · N5242M · Substantial damageNTSB CHI72FEA09Accident · Minor injuriesClosedCessna 172K · Wolcott, INAug 15, 1971 · N7102G · Substantial damageNTSB CHI72DET04Accident · No injuriesClosedCessna 120 · Warsaw, INAug 8, 1971 · N1831V · Substantial damageNTSB CHI72FET03Accident · No injuriesClosedHughes 269B · Griffith, INAug 7, 1971 · N9559F · Substantial damageNTSB CHI72FEA04Accident · No injuriesClosedBeech V35 · Winchester, INJul 24, 1971 · N9478S · Substantial damageNTSB CHI72FET02Accident · Minor injuriesClosedBrantly 305 · Monroeville, INJul 20, 1971 · N2211U · DestroyedNTSB CHI72FEA07Accident · No injuriesClosedPiper PA-25 · Roachdale, INJul 17, 1971 · N8681L · Substantial damageNTSB CHI72FEA03Accident · Minor injuriesClosedPiper J4A · Cloverdale, INJul 9, 1971 · N25733 · Substantial damageNTSB CHI72FEA01Accident · No injuriesClosedBoeing A75N1 · Greensburg, INJul 8, 1971 · N49954 · Substantial damageNTSB CHI72DEA08Accident · No injuriesClosedCessna 140 · Lebanon, INJul 6, 1971 · N77201 · Substantial damageNTSB CHI72AC004Accident · 1 fatalClosedBeech C35 · Crown Point, INJul 6, 1971 · N5983C · DestroyedNTSB CHI72FET01Accident · No injuriesClosedAerostar 201 · Gary, INJul 5, 1971 · N9296V · Substantial damageNTSB CHI72FEA02Accident · Minor injuriesClosedPiper PA-24 · Perrysville, INJul 5, 1971 · N6756P · Substantial damageNTSB CHI71DEA40Accident · No injuriesClosedPiper PA-28 · Jeffersonvile, INJun 28, 1971 · N7285J · Substantial damageNTSB CHI71FET31Accident · Serious injuriesClosedFleet 16B · Osceola, INJun 26, 1971 · N39601 · Substantial damageNTSB CHI72DEA05Accident · No injuriesClosedBellanca 14-193 · Evansville, INJun 25, 1971 · N8853R · Substantial damageNTSB CHI71IC092Incident · No injuriesClosedDouglas DC-9 · Indianapolis, INJun 23, 1971 · N937F · Minor damageNTSB CHI71FEA39Accident · No injuriesClosedBensen B8-M · Delphi, INJun 23, 1971 · N6661 · DestroyedNTSB CHI71FET30Accident · No injuriesClosedCessna 177 · South Bend, INJun 21, 1971 · N30100 · Substantial damageNTSB CHI71AC091Accident · 2 fatalClosedPiper PA-30 · Fort Wayne, INJun 19, 1971 · XB-RIG · DestroyedNTSB CHI71AC087Accident · 2 fatalClosedChampion 7ECA · Poseyville, INJun 10, 1971 · N11097 · DestroyedNTSB CHI71DET29Accident · No injuriesClosedPiper PA-24 · Michigan City, INJun 6, 1971 · N6799J · Substantial damageNTSB CHI71AC086Accident · 2 fatalClosedCessna 182 · Lafayette, INJun 6, 1971 · N2127G · DestroyedNTSB CHI71FET28Accident · No injuriesClosedBeech 23 · Wolcottville, INJun 3, 1971 · N2325L · Substantial damageNTSB CHI71DEA38Accident · No injuriesClosedPiper PA-20 · Seymour, INMay 30, 1971 · N7430K · Substantial damageNTSB CHI71FEA37Accident · No injuriesClosedPiper PA-28 · Muncie, INMay 22, 1971 · N1692T · Substantial damageNTSB CHI71FEA36Accident · No injuriesClosedCessna 182 · Muncie, INMay 8, 1971 · N4090D · Substantial damage