NTSB investigations, 1973, OH

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1973, OH per year, 1962–2026: 4,364 cases
19621
19631
1964199
1965184
1966193
1967189
1968187
1969129
1970142
1971147
1972121
1973124
1974142
1975101
1976103
1977112
197899
1979115
1980109
198181
198281
198381
198484
198573
198659
198769
198859
198974
199052
199152
199256
199346
199452
199554
199644
199743
199829
199938
200046
200133
200239
200346
200434
200537
200623
200741
200843
200932
201037
201143
201230
201322
201429
201517
201634
201733
201833
201927
202022
202127
202230
202319
202416
202523
202623

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\" = 'OH' 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 CHI74FEK12Accident · No injuriesClosedCessna 170B · Lima, OHDec 28, 1973 · N813MD · Substantial damageNTSB CHI74FEK10Accident · No injuriesClosedCessna 150J · Vanwert, OHDec 28, 1973 · N50675 · Substantial damageNTSB CHI74FEK18Accident · No injuriesClosedCessna 172M · Defiance, OHDec 22, 1973 · N13364 · Substantial damageNTSB CHI74FEK09Accident · No injuriesClosedAero Comdr 500B · Findly, OHDec 9, 1973 · N354MA · Substantial damageNTSB CHI74FEI17Accident · No injuriesClosedMooney M20B · Elyria, OHDec 8, 1973 · N74585 · Substantial damageNTSB DCA74AZ012Accident · Serious injuriesClosedDouglas DC-9 · North Canton, OHNov 27, 1973 · N8967E · Substantial damageNTSB CHI74AC044Accident · 3 fatalClosedPiper PA-23 · Sandusky, OHNov 26, 1973 · N3364P · DestroyedNTSB CHI74DEI14Accident · No injuriesClosedSchweizer 2-33A · Middlefield, OHNov 11, 1973 · N2448W · Substantial damageNTSB CHI74AC040Accident · 2 fatalClosedNavion B · Columbus, OHNov 7, 1973 · N5264K · DestroyedNTSB CHI74FEK08Accident · Minor injuriesClosedPiper PA-32 · Warsaw, OHNov 4, 1973 · N4280T · Substantial damageNTSB CHI74DEI15Accident · Minor injuriesClosedCessna 182 · Atwater, OHNov 4, 1973 · N9930B · Substantial damageNTSB CHI74AC038Accident · 2 fatalClosedAerostar 601 · Raymond, OHNov 3, 1973 · N7430S · DestroyedNTSB CHI74DEI11Accident · No injuriesClosedPiper PA-22 · Norwalk, OHOct 31, 1973 · N2573A · DestroyedNTSB CHI74FEI16Accident · No injuriesClosedPiper PA-24 · Ashland, OHOct 30, 1973 · N6453P · Substantial damageNTSB CHI74DEK07Accident · No injuriesClosedPiper PA-28 · Pandora, OHOct 28, 1973 · N4231T · Substantial damageNTSB NYC74AN034Accident · 2 fatalClosedBeech 65-A80 · Cincinnati, OHOct 25, 1973 · N6875Q · DestroyedNTSB CHI74DEG12Accident · Serious injuriesClosedBeech V35B · Vandalia, OHOct 25, 1973 · N9274Q · No damageNTSB CHI74FEG11Accident · No injuriesClosedMooney M20 · Miamisburg, OHOct 21, 1973 · N5210B · Substantial damageNTSB CHI74AC037Accident · 2 fatalClosedHughes 269B · Springfield, OHOct 16, 1973 · N9342F · DestroyedNTSB CHI74FEG10Accident · Minor injuriesClosedCessna A150K · Mcarthur, OHOct 14, 1973 · N8313M · DestroyedNTSB CHI74FEG09Accident · Serious injuriesClosedCessna 150 · Oxford, OHOct 14, 1973 · N23502 · Substantial damageNTSB CHI74AC035Accident · 1 fatalClosedMooney M20A · Summitville, OHOct 10, 1973 · N6034X · DestroyedNTSB CHI74AC032Accident · 1 fatalClosedCessna 150F · Columbiana, OHOct 8, 1973 · N8059F · DestroyedNTSB CHI74FEK06Accident · Serious injuriesClosedCessna 172 · Caledonia, OHOct 6, 1973 · N7121T · Substantial damageNTSB CHI74DEI21Accident · Minor injuriesClosedCessna 177 · Perrysville, OHSep 27, 1973 · N3380T · DestroyedNTSB CHI74FEG08Accident · No injuriesClosedBell 47-G5 · Washingtn Ch, OHSep 24, 1973 · N4101G · Substantial damageNTSB CHI74FEK05Accident · No injuriesClosedCessna 150 · Newark, OHSep 19, 1973 · N18086 · Substantial damageNTSB CHI74FEI10Accident · Serious injuriesClosedCorben ACE · Brookfield, OHSep 14, 1973 · N1298V · Substantial damageNTSB CHI74AC022Accident · No injuriesClosedPiper PA-28 · New Carisle, OHSep 12, 1973 · N7792W · 2 aircraft · Substantial damageNTSB CHI74FEI12Accident · Minor injuriesClosedPiper PA-28 · Gustavus, OHSep 9, 1973 · N5318W · Substantial damageNTSB CHI74AC021Accident · 1 fatalClosedPiper J-3 · Marysville, OHSep 6, 1973 · N2051M · Substantial damageNTSB CHI74FEG06Accident · No injuriesClosedHoward DGA-15 · Amelia, OHSep 3, 1973 · N5450N · Substantial damageNTSB CHI74FEG07Accident · No injuriesClosedCessna 172 · Forest Park, OHSep 1, 1973 · N7110A · Substantial damageNTSB CHI74AC017Accident · No injuriesClosedBeech E18S · Urbana, OHAug 30, 1973 · N5632D · Substantial damageNTSB CHI74DEI13Accident · Serious injuriesClosedSchweizer 2-22 · Medina, OHAug 25, 1973 · N8679R · Substantial damageNTSB CHI74FEI07Accident · Serious injuriesClosedAmer Avco AA1-B · Painsville, OHAug 20, 1973 · N9688L · No damageNTSB CHI74AC014Accident · No injuriesClosedPiper PA-28 · Batavia, OHAug 17, 1973 · N15897 · 2 aircraft · Substantial damageNTSB CHI74DEI06Accident · No injuriesClosedCessna 150F · Strongsville, OHAug 16, 1973 · N8625S · Substantial damageNTSB CHI74FEK04Accident · No injuriesClosedCessna 180D · Columbus, OHAug 14, 1973 · N6423X · Substantial damageNTSB CHI74FEK03Accident · No injuriesClosedCessna 182N · Newark, OHAug 12, 1973 · N9096G · Substantial damageNTSB CHI74FEI23Accident · Minor injuriesClosedCessna 172 · S Parkman, OHAug 5, 1973 · N19940 · Substantial damageNTSB CHI74DEI22Accident · No injuriesClosedCessna 150 · Clyde, OHAug 5, 1973 · N6995G · Substantial damageNTSB CHI74FEG05Accident · Serious injuriesClosedMooney M20E · Harrison, OHAug 3, 1973 · N3430X · DestroyedNTSB CHI74DEI08Accident · No injuriesClosedCessna 150 · Brunswick, OHAug 2, 1973 · N6835G · Substantial damageNTSB CHI74DEG04Accident · No injuriesClosedPiper PA-32 · Vandalia, OHJul 31, 1973 · N4740S · Substantial damageNTSB CHI74FEK02Accident · Serious injuriesClosedCessna 150L · Gallion, OHJul 30, 1973 · N16155 · DestroyedNTSB CHI74FEI05Accident · No injuriesClosedSwearingen SA26 · N.Phildelpha, OHJul 30, 1973 · N4252X · Substantial damageNTSB CHI74FEI09Accident · Minor injuriesClosedBellanca 7GCBC · E.Liverpool, OHJul 29, 1973 · N57429 · Substantial damageNTSB CHI74FEG03Accident · 1 fatalClosedBeech 95-C55 · Cincinnati, OHJul 27, 1973 · N3786Q · DestroyedNTSB CHI74FEG02Accident · Minor injuriesClosedBoeing A75N1 · W.Carrollton, OHJul 27, 1973 · N57348 · Substantial damage