NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 NYC67D0453Accident · No injuriesClosedCessna 150 · White Plains, NYDec 30, 1966 · N7950Z · Substantial damageNTSB NYC67F0434Accident · No injuriesClosedBeech V35 · Wallkill, NYDec 22, 1966 · N5617S · Substantial damageNTSB NYC67D0432Accident · No injuriesClosedCessna 150 · White Plains, NYDec 18, 1966 · N3190X · Substantial damageNTSB NYC67D0442Accident · No injuriesClosedPiper PA-22 · Wappingers Fls., NYDec 13, 1966 · N5802Z · Substantial damageNTSB NYC67F0433Accident · No injuriesClosedMooney M20A · Port Jefferson, NYDec 11, 1966 · N8383E · Substantial damageNTSB NYC67A0090Accident · 2 fatalClosedPiper PA-23 · Copenhagen, NYDec 2, 1966 · N512H · DestroyedNTSB NYC67F0388Accident · No injuriesClosedBeech A35 · Mcdonough, NYNov 27, 1966 · N449B · Substantial damageNTSB NYC67A0086Accident · No injuriesClosedBrantly B-2 · Belfast, NYNov 25, 1966 · N5958X · Substantial damageNTSB NYC67D0395Accident · No injuriesClosedCessna 180 · Glens Falls, NYNov 24, 1966 · N9205T · Substantial damageNTSB NYC67F0396Accident · No injuriesClosedRearwin 185 · Yorktown Hts, NYNov 21, 1966 · N93245 · Substantial damageNTSB NYC67D0401Accident · Serious injuriesClosedPiper PA-18 · Richland, NYNov 20, 1966 · N3258P · DestroyedNTSB NYC67D0394Accident · No injuriesClosedCessna 150 · Amagansett, NYNov 18, 1966 · N8170F · Substantial damageNTSB NYC67A0080Accident · No injuriesClosedBeech K35 · Flushing, NYNov 14, 1966 · N9512R · Substantial damageNTSB NYC67F0370Accident · Serious injuriesClosedBeech M35 · Saranac Lake, NYNov 11, 1966 · N9715R · DestroyedNTSB NYC67A0075Accident · 3 fatalClosedCessna 205A · East Nassau, NYNov 6, 1966 · N4816U · DestroyedNTSB NYC67A0073Accident · No injuriesClosedBoeing B-727 · Flushing, NYNov 2, 1966 · N1983 · Substantial damageNTSB NYC67D0381Accident · No injuriesClosedPiper PA-23 · Jamaica, NYNov 1, 1966 · N309SL · Substantial damageNTSB NYC67F0384Accident · No injuriesClosedBeech 35-B33 · Ronkonkoma, NYOct 28, 1966 · N7918K · Substantial damageNTSB NYC67F0343Accident · No injuriesClosedHelio H-391B · Fisher, NYOct 23, 1966 · N6022 · Substantial damageNTSB NYC67D0361Accident · No injuriesClosedPiper PA-28 · Ithaca, NYOct 21, 1966 · N9103J · Substantial damageNTSB NYC67F0359Accident · Serious injuriesClosedAeronca 0-58B · Cambria, NYOct 16, 1966 · N49514 · Substantial damageNTSB NYC67D0288Accident · No injuriesClosedCessna 150 · Croton-Hudson, NYOct 15, 1966 · N2562J · Substantial damageNTSB NYC67D0319Accident · Minor injuriesClosedSchweizer 2-22C · Elmira, NYOct 12, 1966 · N8648R · Substantial damageNTSB NYC67F0320Accident · No injuriesClosedBeech 95-55 · Gardenville, NYOct 10, 1966 · N434M · Substantial damageNTSB DCA67I0004Incident · No injuriesClosedCurtiss-Wrt C-46 · Buffalo, NYOct 10, 1966 · N618Z · No damageNTSB NYC67D0335Accident · No injuriesClosedCessna 172 · Flushing, NYOct 9, 1966 · N2549Y · Substantial damageNTSB NYC67D0328Accident · Minor injuriesClosedSchweizer SGA126 · Waverly, NYOct 6, 1966 · N923X · Substantial damageNTSB NYC67F0296Accident · Serious injuriesClosedPiper PA-22 · Williamson, NYOct 2, 1966 · N2225A · Substantial damageNTSB NYC67F0292Accident · Minor injuriesClosedPiper PA-12 · Pittsford, NYOct 1, 1966 · N3685N · Substantial damageNTSB NYC67D0295Accident · No injuriesClosedCessna 140 · Lindenhurst, NYSep 28, 1966 · N89262 · Substantial damageNTSB NYC67D0310Accident · No injuriesClosedCessna 310H · Purchase, NYSep 27, 1966 · N234KC · Substantial damageNTSB NYC67F0283Accident · No injuriesClosedDowner 14-19 · Painted Post, NYSep 26, 1966 · N8815R · Substantial damageNTSB NYC67D0286Accident · No injuriesClosedPiper PA-28 · Spring Valley, NYSep 25, 1966 · N6593W · Substantial damageNTSB NYC67A0051Accident · No injuriesClosedHughes 269A · Schuylerville, NYSep 24, 1966 · N8788F · DestroyedNTSB NYC67F0277Accident · No injuriesClosedCessna A188 · New Platz, NYSep 23, 1966 · N5504S · Substantial damageNTSB NYC67F0268Accident · No injuriesClosedCessna 180A · Stormville, NYSep 18, 1966 · N9521B · Substantial damageNTSB NYC67D0265Accident · No injuriesClosedStinson 108 · Red Hook, NYSep 17, 1966 · N97320 · Substantial damageNTSB NYC67A0055Accident · No injuriesClosedPiper PA-28 · Orient Point, NYSep 17, 1966 · N9245J · Substantial damageNTSB NYC67D0254Accident · No injuriesClosedStinson 108 · Richland, NYSep 15, 1966 · N97488 · Substantial damageNTSB NYC67A0046Accident · No injuriesClosedLockheed 188 · Montezuma, NYSep 15, 1966 · N6111A · Substantial damageNTSB NYC67F0270Accident · Minor injuriesClosedNavion A · Phillipstown, NYSep 8, 1966 · N8650H · Substantial damageNTSB NYC67A0045Accident · 1 fatalClosedPiper PA-28 · Flushing, NYSep 5, 1966 · N8754W · Substantial damageNTSB NYC67F0309Accident · No injuriesClosedCessna 310K · Flushing, NYSep 3, 1966 · N366J · Substantial damageNTSB NYC67F0248Accident · No injuriesClosedPiper PA-30 · Penn Yan, NYSep 2, 1966 · N7345Y · Substantial damageNTSB NYC67D0238Accident · No injuriesClosedLuscombe 8A · Spring Valley, NYSep 2, 1966 · N71280 · Substantial damageNTSB NYC67I0043Incident · No injuriesClosedBoeing 727 · New York, NYSep 1, 1966 · N8127N · Minor damageNTSB NYC67F0197Accident · No injuriesClosedCessna 182J · Coxsackie, NYAug 28, 1966 · N3471F · DestroyedNTSB NYC67D0285Accident · No injuriesClosedCessna 140 · Spring Valley, NYAug 28, 1966 · N4022N · Substantial damageNTSB NYC67I0039Incident · No injuriesClosedBoeing 727 · Buffalo, NYAug 27, 1966 · N7025U · Minor damageNTSB NYC67D0231Accident · No injuriesClosedCessna 150 · Monticello, NYAug 25, 1966 · N8266F · Substantial damage