NTSB investigations, 1973, NY

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 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\") = 1973
    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 NYC74DFJ25Accident · Minor injuriesClosedBeech E18S · Syracuse, NYDec 22, 1973 · N249K · Substantial damageNTSB NYC74AN057Accident · Serious injuriesClosedCessna 411 · Endicott, NYDec 21, 1973 · N424RF · DestroyedNTSB NYC74IN055Incident · 1 fatalClosedBoeing 727 · Syracuse, NYDec 20, 1973 · N964 · No damageNTSB NYC74FHJ17Accident · Serious injuriesClosedHiller Acft FH1100 · Bethpage, NYDec 20, 1973 · N609PD · Substantial damageNTSB NYC74AN056Accident · 2 fatalClosedBeech 95-B55 · Colonie, NYDec 20, 1973 · N5729K · DestroyedNTSB NYC74FHJ18Accident · No injuriesClosedLear Jet 25 · White Plains, NYDec 17, 1973 · N900P · Substantial damageNTSB NYC74AN053Accident · Serious injuriesClosedStinson 108-1 · Amityville, NYDec 15, 1973 · N2641 · 2 aircraft · DestroyedNTSB NYC73FHJ12Accident · No injuriesClosedAero Comdr 680W · White Plains, NYDec 5, 1973 · N5029E · Substantial damageNTSB NYC74DFJ19Accident · No injuriesClosedPiper PA-12 · Skaneateles, NYDec 3, 1973 · N2999M · Substantial damageNTSB NYC74FHJ16Accident · No injuriesClosedBeech V35B · White Plains, NYDec 2, 1973 · N4277A · Substantial damageNTSB NYC74FFA17Accident · 1 fatalClosedCessna 140A · Scotia, NYNov 30, 1973 · N3787V · DestroyedNTSB NYC74FFJ18Accident · Minor injuriesClosedHiller Acft UH-12B · Dansville, NYNov 6, 1973 · N33616 · Substantial damageNTSB NYC74AN041Accident · 3 fatalClosedCessna 182P · Dix Hills, NYNov 6, 1973 · N21208 · 2 aircraft · DestroyedNTSB NYC74AN040Accident · 3 fatalClosedPiper PA-28 · Farmingdale, NYNov 4, 1973 · N8045N · DestroyedNTSB NYC74DFJ17Accident · No injuriesClosedCessna 172 · Grand Island, NYNov 3, 1973 · N19641 · Substantial damageNTSB NYC74FFJ15Accident · No injuriesClosedPiper PA-23 · Rochester, NYOct 30, 1973 · N6249B · Substantial damageNTSB NYC74FFJ16Accident · No injuriesClosedLuscombe 8A · Leroy, NYOct 24, 1973 · N77892 · Substantial damageNTSB NYC74FFJ14Accident · Minor injuriesClosedCessna 150H · Warsaw, NYOct 12, 1973 · N22655 · Substantial damageNTSB NYC74FFA16Accident · No injuriesClosedCessna 172I · Alexandria Bay, NYOct 12, 1973 · N46100 · Substantial damageNTSB NYC74DHJ14Accident · No injuriesClosedAeronca 7AC · Deer Park, NYOct 8, 1973 · N84624 · Substantial damageNTSB NYC74DFA14Accident · No injuriesClosedPiper PA-28 · Glens Falls, NYOct 8, 1973 · N8549W · Substantial damageNTSB NYC74DFJ12Accident · Minor injuriesClosedBell 47J-2 · Niagara Falls, NYOct 7, 1973 · N8453E · Substantial damageNTSB NYC74FFA13Accident · No injuriesClosedCessna 172L · Bloomingburg, NYOct 6, 1973 · N7938G · Substantial damageNTSB NYC74FFJ08Accident · No injuriesClosedPiper PA-28 · Owego, NYOct 3, 1973 · N3814R · Substantial damageNTSB NYC74FFJ13Accident · No injuriesClosedCessna 180 · Franklinville, NYSep 30, 1973 · N4774B · Substantial damageNTSB NYC74FFJ11Accident · Minor injuriesClosedSIAI Marche 205-22 · Niagara Falls, NYSep 30, 1973 · N952W · Substantial damageNTSB NYC74DMM08Accident · No injuriesClosedCessna 150 · Spring Valley, NYSep 27, 1973 · N5997G · Substantial damageNTSB NYC74AN028Accident · No injuriesClosedCessna 172 · Ronkonkoma, NYSep 21, 1973 · N6115E · Substantial damageNTSB NYC74IN027Incident · No injuriesClosedPiper PA-23 · White Plains, NYSep 19, 1973 · N14196 · Minor damageNTSB NYC74IN024Incident · No injuriesClosedBoeing 747 · Jamaica, NYSep 17, 1973 · CS-TJB · Minor damageNTSB NYC74FHJ12Accident · Minor injuriesClosedBensen B8-M · East Moriches, NYSep 16, 1973 · N6890 · Substantial damageNTSB NYC74FFA11Accident · No injuriesClosedBeech V35A · Oriskany, NYSep 14, 1973 · N3358A · Substantial damageNTSB NYC74FFJ10Accident · No injuriesClosedPiper PA-28R · Hornell, NYSep 9, 1973 · N459WE · Substantial damageNTSB NYC74FFA10Accident · No injuriesClosedStinson 108 · Albany, NYSep 9, 1973 · N97954 · Substantial damageNTSB NYC74DHJ15Accident · No injuriesClosedCessna 150 · Deerpark, NYSep 9, 1973 · N60616 · 2 aircraft · Substantial damageNTSB NYC74DHJ13Incident · No injuriesClosedPiper PA-32 · Farmingdale, NYSep 8, 1973 · N4105R · 2 aircraft · Minor damageNTSB NYC74FFJ09Accident · Minor injuriesClosedBellanca 14-19 · Hammondsport, NYSep 7, 1973 · N8530R · Substantial damageNTSB NYC74DFA09Accident · No injuriesClosedPiper PA-32 · Hudson, NYSep 7, 1973 · N8952N · Substantial damageNTSB NYC74DFA08Accident · No injuriesClosedAmer Avco AA-5 · Mt Upton, NYSep 4, 1973 · N5458L · Substantial damageNTSB NYC74FFJ07Accident · Minor injuriesClosedPiper PA-28 · Honeoye Falls, NYSep 3, 1973 · N4262T · Substantial damageNTSB NYC74DFA07Accident · No injuriesClosedCessna 172 · Cobleskill, NYSep 3, 1973 · N46709 · Substantial damageNTSB NYC74DHM05Accident · No injuriesClosedPiper PA-28 · Spring Valley, NYAug 31, 1973 · N16338 · Substantial damageNTSB NYC74DHM04Accident · No injuriesClosedCessna 150 · Bloomingburg, NYAug 26, 1973 · N2978S · Substantial damageNTSB NYC74DFA06Accident · No injuriesClosedPiper PA-28 · Cobleskill, NYAug 25, 1973 · N95091 · Substantial damageNTSB NYC74DHJ10Accident · No injuriesClosedCessna 182E · Riverhead, NYAug 24, 1973 · N3239Y · Substantial damageNTSB NYC74DHJ11Accident · No injuriesClosedPiper PA-28 · Amityville, NYAug 23, 1973 · N7161R · Substantial damageNTSB NYC74DFJ06Accident · 1 fatalClosedJeanies Teenie · Homer, NYAug 23, 1973 · N31JT · DestroyedNTSB NYC74FFA05Accident · No injuriesClosedPiper PA-28 · Poestenkill, NYAug 17, 1973 · N56288 · Substantial damageNTSB NYC74IN013Incident · No injuriesClosedBoeing 727 · Jamaica, NYAug 12, 1973 · N4742 · Minor damageNTSB NYC74DFJ04Accident · No injuriesClosedCessna 172 · Richland, NYAug 12, 1973 · N32042 · Substantial damage