NTSB investigations, 1973, 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, 1973, 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\") = 1973
    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 CHI74FET16Accident · Serious injuriesClosedPiper PA-24 · Fort Wayne, INDec 27, 1973 · N8074D · DestroyedNTSB CHI74AC051Accident · 2 fatalClosedBeech 95-C55 · Rochester, INDec 19, 1973 · N6299V · DestroyedNTSB CHI74DET15Accident · No injuriesClosedBeech A35 · Logansport, INDec 9, 1973 · N708B · DestroyedNTSB CHI74DEA22Accident · No injuriesClosedPiper PA-22 · Francisco, INDec 1, 1973 · N4698Z · Substantial damageNTSB CHI74DEA21Accident · No injuriesClosedPiper PA-28R · Madison, INNov 23, 1973 · N9482N · Substantial damageNTSB CHI74AC042Accident · 5 fatalClosedCessna 421 · Plymouth, INNov 14, 1973 · N550T · DestroyedNTSB CHI74FEA20Accident · No injuriesClosedPiper PA-22 · Monroe City, INNov 12, 1973 · N4919Z · Substantial damageNTSB CHI74DEA19Accident · No injuriesClosedCessna 172 · Terre Haute, INNov 7, 1973 · N4423Q · Substantial damageNTSB CHI74FET11Accident · Serious injuriesClosedCessna 150 · Michigan City, INNov 2, 1973 · N6987G · Substantial damageNTSB CHI74DEA18Accident · Minor injuriesClosedCessna 150 · Brazil, INOct 27, 1973 · N4027J · Substantial damageNTSB CHI74FET12Accident · No injuriesClosedPiper PA-34 · Osceola, INOct 26, 1973 · N55145 · Substantial damageNTSB CHI74FEA17Accident · Minor injuriesClosedPiper PA-23 · Terre Haute, INOct 26, 1973 · N1365P · DestroyedNTSB CHI74FEA16Accident · Minor injuriesClosedCessna 172F · Lafayette, INOct 19, 1973 · N8509U · Substantial damageNTSB CHI74FEA15Accident · 1 fatalClosedCorbin B-ACE · Franklin, INOct 9, 1973 · N10BA · DestroyedNTSB CHI74AC027Accident · Minor injuriesClosedLockheed 1049H · Gary, INSep 24, 1973 · N566E · Substantial damageNTSB CHI74FEA14Accident · Serious injuriesClosedTeenie TWO · Monticello, INSep 23, 1973 · N99151 · DestroyedNTSB CHI74DET10Accident · Minor injuriesClosedCessna 172 · Peru, INSep 23, 1973 · N1617F · Substantial damageNTSB CHI74DEA13Accident · No injuriesClosedBell 47G-2A · Veedersburg, INSep 16, 1973 · N7579 · Substantial damageNTSB CHI74FET09Accident · No injuriesClosedCessna 182F · Elkhart, INSep 7, 1973 · N3260U · Substantial damageNTSB CHI74FET08Accident · Serious injuriesClosedCessna 182P · Valparaiso, INSep 5, 1973 · N58509 · DestroyedNTSB CHI74AC020Accident · 2 fatalClosedCessna 337A · Gary, INSep 4, 1973 · N6270F · 2 aircraft · DestroyedNTSB CHI74DET07Accident · Minor injuriesClosedLuscombe 8F · Crown Point, INAug 31, 1973 · N1883B · Substantial damageNTSB CHI74FEA09Accident · No injuriesClosedPiper PA-24 · Lanesville, INAug 26, 1973 · N8552P · Substantial damageNTSB CHI74DEA12Accident · No injuriesClosedPiper PA-28 · Radnor, INAug 26, 1973 · N6018W · Substantial damageNTSB CHI74AC016Accident · Serious injuriesClosedAero Comdr 520 · Michigan City, INAug 25, 1973 · N2634B · DestroyedNTSB CHI74AC015Accident · 1 fatalClosedStinson L-5E · Demotte, INAug 19, 1973 · N5163V · DestroyedNTSB CHI74FET06Accident · No injuriesClosedCessna 310C · Griffith, INAug 18, 1973 · N1845H · Substantial damageNTSB CHI74FET04Accident · No injuriesClosedPiper PA-23 · Walton, INAug 7, 1973 · N436CB · Substantial damageNTSB CHI74DEA08Accident · No injuriesClosedPiper PA-25 · Kentland, INAug 4, 1973 · N6569Z · DestroyedNTSB CHI74DET05Accident · No injuriesClosedPiper PA-25 · Morocco, INAug 2, 1973 · N7761Z · Substantial damageNTSB CHI74AC010Accident · 1 fatalClosedPiper PA-28R · Fountaintown, INAug 1, 1973 · N2102T · DestroyedNTSB CHI74DET02Accident · Serious injuriesClosedJeanies TWO · Merriville, INJul 30, 1973 · N4X · Substantial damageNTSB CHI74FEA06Accident · No injuriesClosedPiper PA-22 · Hartford City, INJul 28, 1973 · N3033Z · Substantial damageNTSB CHI74DEA10Accident · No injuriesClosedPiper PA-28 · Kokomo, INJul 27, 1973 · N5219T · Substantial damageNTSB CHI74DEA07Accident · No injuriesClosedGreat Lakes Baby · Anderson, INJul 15, 1973 · N132SP · Substantial damageNTSB CHI74FEA04Accident · Serious injuriesClosedBell 47G-3 · Dana, INJul 13, 1973 · N8416E · Substantial damageNTSB CHI74FEA11Accident · No injuriesClosedCessna 210D · Evansville, INJul 8, 1973 · N3804Y · Substantial damageNTSB CHI74FEA03Accident · No injuriesClosedBell 47G-2A · Little York, INJul 5, 1973 · N73257 · Substantial damageNTSB CHI74DEA05Accident · No injuriesClosedPitts S1-D · Greentown, INJul 5, 1973 · N6RD · Substantial damageNTSB CHI74FEA02Accident · No injuriesClosedAeronca 7AC · Speedway, INJul 4, 1973 · N84304 · Substantial damageNTSB CHI74AC003Accident · 4 fatalClosedCessna 172F · No.Webster, INJul 4, 1973 · N5526R · DestroyedNTSB CHI74AC001Accident · 4 fatalClosedCessna T210J · Pleasant Lake, INJul 2, 1973 · N20EA · DestroyedNTSB CHI74FEA01Accident · Minor injuriesClosedCessna 210 · North Vernon, INJul 1, 1973 · N9538T · Substantial damageNTSB CHI73FET25Accident · Minor injuriesClosedChampion 7KCAB · Griffith, INJun 25, 1973 · CF-ASI · Substantial damageNTSB CHI73DEA42Accident · No injuriesClosedPiper PA-20 · Portland, INJun 25, 1973 · N8290C · Substantial damageNTSB CHI73DEA40Accident · No injuriesClosedCessna 150F · Mc Cordsville, INJun 24, 1973 · N6427F · Substantial damageNTSB CHI73DEA39Accident · No injuriesClosedCessna 172 · Hagerstown, INJun 24, 1973 · N1642E · Substantial damageNTSB CHI73DEA41Accident · No injuriesClosedCessna 182 · Ramsey, INJun 22, 1973 · N5035D · Substantial damageNTSB CHI73FEA38Accident · Serious injuriesClosedBeech 23 · Lanesville, INJun 13, 1973 · N1493L · DestroyedNTSB CHI73AC095Accident · 1 fatalClosedRyan ST-3KR · Greenfield, INJun 9, 1973 · N47368 · Destroyed