NTSB investigations, 1981, NY

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

19622026
NTSB investigations, 1981, 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\") = 1981
    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 NYC82FA014Accident · 1 fatalClosedPiper PA-23 · Owego, NYDec 31, 1981 · N22P · DestroyedNTSB NYC82DFJ10Accident · No injuriesClosedBeech 95-B55 · Fulton, NYDec 28, 1981 · N9035S · Substantial damageNTSB NYC82FFA02Accident · No injuriesClosedCessna 172 · Edinburg, NYDec 26, 1981 · N734LH · Substantial damageNTSB NYC82FHM04Accident · No injuriesClosedCessna 150 · Newburgh, NYDec 5, 1981 · N4191U · Substantial damageNTSB NYC82FFJ09Accident · Minor injuriesClosedPiper PA-28R · Syracuse, NYDec 3, 1981 · N1087H · Substantial damageNTSB NYC82FHM02Accident · No injuriesClosedCessna 152 · Mahopac, NYNov 26, 1981 · N24790 · 2 aircraft · DestroyedNTSB NYC82FHJ02Accident · No injuriesClosedCessna 152 · Hudson River, NYNov 23, 1981 · N5365L · Substantial damageNTSB NYC82FA010Accident · Minor injuriesClosedBell 206B · New York City, NYNov 20, 1981 · N35TA · Substantial damageNTSB NYC82FFJ08Accident · No injuriesClosedCessna 180K · Jamestown, NYNov 15, 1981 · N66048 · Substantial damageNTSB NYC82FFJ06Accident · No injuriesClosedPiper PA-28 · Rochester, NYNov 15, 1981 · N4509F · Substantial damageNTSB NYC82FA008Accident · 1 fatalClosedPiper PA-28 · North Hudson, NYNov 11, 1981 · N4919T · DestroyedNTSB NYC82DFJ04Accident · No injuriesClosedSchweizer 1-26 · Lockport, NYNov 8, 1981 · N2767R · Substantial damageNTSB NYC82FHJ03Accident · No injuriesClosedPiper PA-30 · East Moriches, NYNov 5, 1981 · N755RY · DestroyedNTSB NYC82FFJ02Accident · Serious injuriesClosedCessna 152 · Lockport, NYNov 4, 1981 · N45970 · Substantial damageNTSB NYC82DFJ07Accident · No injuriesClosedSpezio DAL-1 · Ceres, NYNov 3, 1981 · N14921 · Substantial damageNTSB NYC82FA006Accident · 3 fatalClosedPiper PA-28 · Farmingdale, NYOct 28, 1981 · N8140H · DestroyedNTSB NYC82FA005Accident · Minor injuriesClosedBeech 36 · Marlborough, NYOct 27, 1981 · N7981R · DestroyedNTSB NYC82FA003Accident · Serious injuriesClosedCessna 152 · Fishers Island, NYOct 15, 1981 · N24524 · DestroyedNTSB NYC82FHM01Accident · Minor injuriesClosedCessna 152 · Blooming Grove, NYOct 14, 1981 · N4943B · Substantial damageNTSB NYC82DFJ01Accident · No injuriesClosedPiper PA-32R · Rochester, NYOct 12, 1981 · N38642 · Substantial damageNTSB NYC82FHJ01Accident · No injuriesClosedCessna 172 · Westhampton, NYOct 10, 1981 · N7062Q · Substantial damageNTSB NYC82FFA01Accident · Serious injuriesClosedPiper PA-28 · Milton, NYOct 10, 1981 · N6923W · DestroyedNTSB NYC82FA002Accident · 1 fatalClosedCessna 150H · Worth, NYOct 7, 1981 · N6445S · DestroyedNTSB NYC81FHJ19Accident · No injuriesClosedBeech A36 · White Plains, NYSep 24, 1981 · N722BH · Substantial damageNTSB NYC81FHJ18Accident · No injuriesClosedCessna 172 · Brookhaven, NYSep 23, 1981 · N333MD · Substantial damageNTSB NYC81FFJ25Accident · Serious injuriesClosedAeronca 7AC · Honeoye Falls, NYSep 17, 1981 · N84947 · Substantial damageNTSB NYC81IA080Incident · No injuriesClosedCessna U206G · New York, NYSep 14, 1981 · N734VB · Minor damageNTSB NYC81DFJ26Accident · No injuriesClosedGrum Amer AA-5B · Hamburg, NYSep 14, 1981 · N1591R · Substantial damageNTSB NYC81FHJ17Accident · No injuriesClosedBell 47G-2 · Farmingdale, NYSep 13, 1981 · N6733D · Substantial damageNTSB NYC81DFJ24Accident · No injuriesClosedLuscombe 8E · Nunda, NYSep 13, 1981 · N2449K · Substantial damageNTSB NYC81FFA25Accident · Serious injuriesClosedBellanca 7GCBC · Ancramdale, NYSep 12, 1981 · N5024Y · DestroyedNTSB NYC81FHJ16Accident · No injuriesClosedCessna 182E · Mattituck, NYSep 6, 1981 · N735PS · Substantial damageNTSB NYC81FHJ15Accident · Minor injuriesClosedTeal TSC1A2 · Verplanck, NYSep 5, 1981 · N1365W · Substantial damageNTSB NYC81FHJ14Accident · No injuriesClosedCessna 185E · Westhampton B, NYAug 27, 1981 · N1603M · DestroyedNTSB NYC81FHJ13Accident · Minor injuriesClosedCessna 150 · Shelter Island, NYAug 23, 1981 · N5590G · Substantial damageNTSB NYC81FFJ22Accident · No injuriesClosedSchweizer SG233A · Mayville, NYAug 22, 1981 · N57985 · Substantial damageNTSB NYC81DFA24Accident · Minor injuriesClosedCessna 150M · Hancock, NYAug 21, 1981 · N8999U · Substantial damageNTSB NYC81DA078Accident · No injuriesClosedBeech C24 · Kingston, NYAug 21, 1981 · N9162S · Substantial damageNTSB NYC81FFA23Accident · No injuriesClosedGulf Amer AA-5A · Amsterdam, NYAug 18, 1981 · N26759 · Substantial damageNTSB NYC81FFA21Accident · No injuriesClosedLake LA-4 · Lake George, NYAug 15, 1981 · N65723 · Substantial damageNTSB DCA81IA024Incident · No injuriesClosedBritish Aer Concrd · Jamaica, NYAug 9, 1981 · G-BOAG · Minor damageNTSB NYC81FFJ23Accident · No injuriesClosedCessna 337A · Pembroke, NYAug 8, 1981 · N6277R · Substantial damageNTSB NYC81FFJ21Accident · Minor injuriesClosedNeukom S3 · Horseheads, NYAug 5, 1981 · N5190 · Substantial damageNTSB NYC81FFA19Accident · Minor injuriesClosedPiper PA-28 · Delanson, NYAug 3, 1981 · N9363J · DestroyedNTSB NYC81FFJ20Accident · No injuriesClosedCessna 170 · Great Valley, NYAug 2, 1981 · N4251V · DestroyedNTSB NYC81FHM11Accident · Serious injuriesClosedBeech H35 · Wappingers Fls, NYJul 30, 1981 · N7915D · Substantial damageNTSB NYC81FHJ12Accident · No injuriesClosedCessna 152 · Ronkonkomoa, NYJul 29, 1981 · N4677H · Substantial damageNTSB NYC81FHJ11Accident · No injuriesClosedMaule M-4 · Farmingdale, NYJul 27, 1981 · N9861M · Substantial damageNTSB NYC81FHJ10Accident · No injuriesClosedPiper PA-32R · Farmingdale, NYJul 17, 1981 · N36201 · Substantial damageNTSB NYC81FFA20Accident · No injuriesClosedChristen Eagle · Duanesburg, NYJul 15, 1981 · N3764L · Substantial damage