NTSB investigations, 1976, 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, 1976, 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\") = 1976
    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 NYC77FFJ08Accident · No injuriesClosedTed Smith 601 · Dunkirk, NYDec 31, 1976 · N7437S · Substantial damageNTSB NYC77FA026Accident · Serious injuriesClosedPiper PA-30 · College Point, NYDec 31, 1976 · N44SS · DestroyedNTSB NYC77FFJ09Accident · No injuriesClosedPiper PA-28 · Akron, NYDec 27, 1976 · N3916T · Substantial damageNTSB NYC77IA024Incident · No injuriesClosedDouglas DC-10 · Jamicia, NYDec 26, 1976 · XA-DUG · Minor damageNTSB NYC77FHJ08Accident · No injuriesClosedCessna 182 · White Plains, NYDec 21, 1976 · N71520 · Substantial damageNTSB NYC77FFA11Accident · Minor injuriesClosedPiper J-3 · Marlboro, NYDec 18, 1976 · N24565 · Substantial damageNTSB NYC77FGM06Accident · No injuriesClosedBeech C23 · Farmingdale, NYDec 16, 1976 · N2060L · Substantial damageNTSB NYC77FHM06Accident · Minor injuriesClosedBeech B19 · Ramapo Valley, NYDec 15, 1976 · N1947W · Substantial damageNTSB NYC77FFA10Accident · Serious injuriesClosedBell 47J-2A · Ellenville, NYDec 12, 1976 · N3538S · Substantial damageNTSB NYC77FHJ07Accident · No injuriesClosedNavion A-205 · Bayport, NYDec 11, 1976 · N264 · DestroyedNTSB NYC77FFA09Accident · Serious injuriesClosedCessna 180 · Lisbon, NYDec 10, 1976 · N52192 · Substantial damageNTSB NYC77DHJ10Incident · No injuriesClosedMooney M20B · Shirley, NYDec 6, 1976 · N74723 · Minor damageNTSB NYC77FFJ06Accident · No injuriesClosedGrum Amer AA1-B · Centereach, NYDec 5, 1976 · N6505L · Substantial damageNTSB NYC77DFA08Accident · No injuriesClosedCessna 150 · Kingston, NYDec 5, 1976 · N6738G · Substantial damageNTSB NYC77FA018Accident · 5 fatalClosedPiper PA-31 · Grand View, NYDec 4, 1976 · N59825 · 2 aircraft · DestroyedNTSB NYC77FHJ05Accident · Serious injuriesClosedCessna 210T · White Plains, NYDec 1, 1976 · N6123R · DestroyedNTSB NYC76DHJ04Accident · No injuriesClosedCessna 172 · Farmingdale, NYNov 30, 1976 · N46250 · Substantial damageNTSB NYC77FA017Accident · No injuriesClosedDehavilland DH-104 · Albany, NYNov 29, 1976 · N747BB · Substantial damageNTSB NYC77FHM04Accident · No injuriesClosedPiper PA-22 · Spring Valley, NYNov 28, 1976 · CGUCV · Substantial damageNTSB NYC77FFJ07Accident · No injuriesClosedBeech 95A · Buffalo, NYNov 28, 1976 · N6AW · DestroyedNTSB NYC77FA016Accident · 3 fatalClosedPiper PA-28 · Westhampton, NYNov 27, 1976 · N75233 · DestroyedNTSB NYC77DFJ06Accident · No injuriesClosedCessna 172 · Binghamton, NYNov 18, 1976 · N84043 · Substantial damageNTSB NYC77FHJ03Accident · No injuriesClosedPiper PA-28 · Mattituck, NYNov 14, 1976 · N32542 · Substantial damageNTSB NYC77FGM03Accident · No injuriesClosedCessna 172 · West Hickory, NYNov 14, 1976 · N1767F · Substantial damageNTSB NYC77FA011Accident · No injuriesClosedDouglas DC-9 · Buffalo, NYNov 12, 1976 · N979VJ · Substantial damageNTSB NYC77IA010Incident · No injuriesClosedCessna 421B · Syracuse, NYNov 11, 1976 · C-GJGJ · Minor damageNTSB NYC77FHM03Accident · Minor injuriesClosedCessna 195 · Warwick, NYNov 11, 1976 · N9366A · DestroyedNTSB NYC77FA008Accident · 1 fatalClosedBeech 35-B33 · Glenville, NYNov 2, 1976 · N8613Q · DestroyedNTSB NYC77DFJ04Accident · No injuriesClosedCessna T210L · Hornell, NYNov 2, 1976 · N30266 · Substantial damageNTSB NYC77FFJ02Accident · No injuriesClosedCessna 172K · Varna, NYOct 31, 1976 · N79878 · Substantial damageNTSB NYC77FA007Accident · 2 fatalClosedMooney M20C · Andes, NYOct 31, 1976 · N7861V · DestroyedNTSB NYC77DFA06Accident · Minor injuriesClosedPiper PA-23 · Hancock, NYOct 31, 1976 · N2Y · Substantial damageNTSB NYC77DFJ03Accident · No injuriesClosedPiper PA-28 · Arcade, NYOct 30, 1976 · N3926X · Substantial damageNTSB NYC77DFA05Accident · No injuriesClosedCessna 180 · Lake George, NYOct 27, 1976 · N2100Z · Substantial damageNTSB NYC77FFA04Accident · Serious injuriesClosedBeech F35 · Cobleskill, NYOct 26, 1976 · N2LC · Substantial damageNTSB NYC77FHM02Accident · Serious injuriesClosedSchemp Stdcir · Minisink, NYOct 23, 1976 · N11JY · Substantial damageNTSB NYC77FA002Accident · 1 fatalClosedBeech B95A · Frankfort, NYOct 14, 1976 · N2056C · DestroyedNTSB NYC77DFA03Accident · No injuriesClosedPiper PA-25 · Ticonderoga, NYOct 12, 1976 · N9838P · Substantial damageNTSB NYC77FHJ01Accident · No injuriesClosedCessna 185 · Port Washingtn, NYOct 10, 1976 · N5416R · Substantial damageNTSB NYC76DFA02Accident · Minor injuriesClosedLake LA-4 · Stillwater, NYOct 10, 1976 · N1095L · Substantial damageNTSB NYC77FFA01Accident · No injuriesClosedBell 47G-2 · Utica, NYOct 6, 1976 · N73550 · Substantial damageNTSB NYC76FFJ01Accident · Serious injuriesClosedMetcalf Sport · Hamburg, NYOct 2, 1976 · N33513 · Substantial damageNTSB NYC77FHJ02Accident · No injuriesClosedCessna 172K · Farmingdale, NYSep 24, 1976 · N79578 · Substantial damageNTSB NYC76FFJ35Accident · Serious injuriesClosedCessna 175 · Wellsville, NYSep 24, 1976 · N6613E · Substantial damageNTSB NYC76FHJ33Accident · No injuriesClosedPiper PA-28 · Mattituck, NYSep 23, 1976 · N33165 · Substantial damageNTSB NYC76FFA52Accident · No injuriesClosedCessna 172G · Marcy, NYSep 23, 1976 · N1117F · Substantial damageNTSB NYC76DFJ34Accident · Serious injuriesClosedPiper PA-25 · Avoca, NYSep 19, 1976 · N6905Z · Substantial damageNTSB NYC76AN127Accident · Serious injuriesClosedBoeing 747 · Jamaica, NYSep 19, 1976 · N665 · No damageNTSB NYC76DFJ32Accident · No injuriesClosedBell 47D-1 · Warsaw, NYSep 11, 1976 · N10325 · Substantial damageNTSB NYC76DFJ36Accident · No injuriesClosedCessna 172 · Leroy, NYSep 10, 1976 · N4363R · Substantial damage