NTSB investigations, 1980, NY

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1980, NY per year, 1962–2026: 4,784 cases
19628
19632
1964162
1965197
1966215
1967226
1968181
1969172
1970170
1971164
1972161
1973124
1974167
1975121
1976146
1977152
1978131
1979119
1980101
1981100
198291
198395
198476
198584
198671
198770
198868
198964
199063
199158
199236
199349
199452
199558
199648
199736
199842
199941
200045
200142
200232
200346
200432
200543
200624
200743
200830
200932
201049
201137
201237
201328
201428
201534
201633
201728
201837
201919
202025
202124
202227
202328
202430
202516
202614

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\") = 1980
    AND c.\"eventStateOrRegion\" = 'NY' 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 NYC81IA018Incident · No injuriesClosedAero Cmdr 690 · Dunkirk, NYDec 29, 1980 · N9166N · Minor damageNTSB CHI81FA013Accident · 1 fatalClosedCessna 172M · Ithaca, NYDec 29, 1980 · N5161R · DestroyedNTSB NYC81DFA09Accident · No injuriesClosedPiper PA-28 · Palenville, NYDec 26, 1980 · N4308F · Substantial damageNTSB NYC81FHJ03Accident · Minor injuriesClosedCessna 150 · Massapequa Pk, NYDec 12, 1980 · N63334 · Substantial damageNTSB NYC81FFA08Accident · Serious injuriesClosedCessna 182 · Greene, NYDec 9, 1980 · N2677R · DestroyedNTSB NYC81FHJ05Accident · No injuriesClosedCessna 150 · Ronkonkomoa, NYDec 7, 1980 · N714CM · Substantial damageNTSB NYC81FA016Accident · 4 fatalClosedPiper PA-28R · Jamaica, NYDec 7, 1980 · N29242 · DestroyedNTSB NYC81FHJ02Accident · No injuriesClosedBeech C23 · Farmingdale, NYDec 1, 1980 · N9745L · Substantial damageNTSB NYC81FA013Accident · Minor injuriesClosedSwearingin SA226 · Binghamton, NYNov 25, 1980 · N5356M · Substantial damageNTSB NYC81DFJ02Accident · Serious injuriesClosedSchweizer 1-34R · Dansville, NYNov 22, 1980 · N7700S · Substantial damageNTSB NYC81FFA07Accident · No injuriesClosedAero Comdr 500-A · Glens Falls, NYNov 18, 1980 · N20MA · Substantial damageNTSB NYC81FFA06Accident · Serious injuriesClosedCessna T210K · Duanesburg, NYNov 14, 1980 · N8227M · Substantial damageNTSB NYC81FA009Accident · 1 fatalClosedCessna U206 · West Hurley, NYNov 12, 1980 · N9046H · Substantial damageNTSB NYC81DFA05Accident · No injuriesClosedPiper PA-28 · Accord, NYNov 9, 1980 · N9392W · Substantial damageNTSB NYC81FHJ01Accident · No injuriesClosedSportster HA2M · Brookhaven, NYNov 8, 1980 · N37515 · Substantial damageNTSB NYC81FFA04Accident · No injuriesClosedCessna 182 · Monticello, NYOct 31, 1980 · N58776 · Substantial damageNTSB NYC81FA007Accident · 1 fatalClosedBeech 95-C55 · Canisteo, NYOct 29, 1980 · N171W · DestroyedNTSB NYC81FFA03Accident · No injuriesClosedCessna 185F · Round Lake, NYOct 27, 1980 · N5468E · Substantial damageNTSB NYC81FFA02Accident · Serious injuriesClosedPiper PA-28 · Lake Placid, NYOct 27, 1980 · N54563 · Substantial damageNTSB NYC81FFJ01Accident · No injuriesClosedCessna 172 · Hamburg, NYOct 18, 1980 · N3646S · Substantial damageNTSB NYC81DHM01Accident · No injuriesClosedCessna 177 · Pleasant Vly, NYOct 17, 1980 · N333T · Substantial damageNTSB NYC81FFA01Accident · No injuriesClosedCessna 185 · Round Lake, NYOct 5, 1980 · N2593S · Substantial damageNTSB NYC80FFA26Accident · No injuriesClosedSchreder HP-14 · Lake Placid, NYSep 28, 1980 · C-GUDE · Substantial damageNTSB NYC80FA093Accident · Serious injuriesClosedPiper PA-28R · Farmingdale, NYSep 28, 1980 · N3923T · DestroyedNTSB NYC80FFA25Accident · 1 fatalClosedOsprey II · Kingston, NYSep 27, 1980 · N8020H · DestroyedNTSB NYC80DA090Accident · Serious injuriesClosedAeronca 7AC · Aurora, NYSep 21, 1980 · N2610E · Substantial damageNTSB NYC81FA087Accident · 2 fatalClosedAero Comdr 680E · New Windsor, NYSep 16, 1980 · N1520K · DestroyedNTSB NYC80DA083Accident · No injuriesClosedBeech D55 · Buffalo, NYSep 8, 1980 · N500AC · Substantial damageNTSB NYC80FA080Accident · 2 fatalClosedPiper PA-28 · Herkimer, NYAug 30, 1980 · CF-YFY · Substantial damageNTSB NYC80DA084Accident · No injuriesClosedCessna 150 · Geneseo, NYAug 28, 1980 · N17375 · Substantial damageNTSB NYC80IA077Incident · No injuriesClosedCessna 172 · Rochester, NYAug 27, 1980 · N75845 · Minor damageNTSB NYC80FFJ15Accident · No injuriesClosedCessna 172N · Fulton, NYAug 26, 1980 · N734XT · Substantial damageNTSB NYC80FFJ14Accident · No injuriesClosedCessna 177RG · Canandaigua, NYAug 26, 1980 · N2050Q · Substantial damageNTSB NYC80FFJ13Accident · No injuriesClosedBellanca 17-30 · Akron, NYAug 21, 1980 · N4789V · Substantial damageNTSB NYC80IA073Incident · No injuriesClosedFairchild F-27 · Flushing, NYAug 19, 1980 · N112TA · Minor damageNTSB NYC80DA072Accident · No injuriesClosedPiper PA-38 · W Hampton Bch, NYAug 17, 1980 · N2360P · Substantial damageNTSB NYC80FHJ22Accident · No injuriesClosedCessna 206F · Dunwood, NYAug 16, 1980 · N4622U · Substantial damageNTSB NYC80FHJ21Accident · No injuriesClosedCessna 172 · Islip, NYAug 16, 1980 · N8277E · Substantial damageNTSB NYC80FA070Accident · 1 fatalClosedPiper PA-30 · Cutchogue, NYAug 14, 1980 · N7094Y · DestroyedNTSB NYC80FFA24Accident · No injuriesClosedPiper PA-28 · Kingston, NYAug 10, 1980 · N611VW · Substantial damageNTSB NYC80FFA23Accident · Serious injuriesClosedPiper J3 · Galway, NYAug 10, 1980 · N27968 · Substantial damageNTSB NYC80FHM24Accident · No injuriesClosedCessna 172N · Spring Valley, NYAug 7, 1980 · N739PF · Substantial damageNTSB NYC80FHM22Accident · Minor injuriesClosedPiper PA-30 · Lagrangeville, NYAug 7, 1980 · N7103Y · Substantial damageNTSB NYC80FHJ20Accident · No injuriesClosedCessna 182 · Westhampton, NYAug 7, 1980 · N3093Q · Substantial damageNTSB NYC80FA064Accident · 1 fatalClosedCessna 305A · Farmingdale, NYAug 2, 1980 · N5174G · Substantial damageNTSB NYC80DFA22Accident · Serious injuriesClosedCessna 172 · Saranac Inn, NYAug 1, 1980 · N6935A · DestroyedNTSB NYC80FHM25Accident · No injuriesClosedCessna 150H · Montgomery, NYJul 30, 1980 · N22439 · Substantial damageNTSB NYC80FHJ19Accident · No injuriesClosedN American SNJ · Farmingdale, NYJul 24, 1980 · N62724 · Substantial damageNTSB NYC80FA061Accident · 1 fatalClosedSchweizer SGS126 · Wurtsboro, NYJul 24, 1980 · N17905 · DestroyedNTSB NYC80DFA10Accident · No injuriesClosedSchreder 1 · Grahamsville, NYJul 19, 1980 · N282E · Substantial damage