NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 NYC66F0474Accident · No injuriesClosedCessna 310D · Lindenhurst, NYDec 28, 1965 · N18Y · Substantial damageNTSB NYC66F0432Accident · No injuriesClosedPiper PA-22 · Spring Valley, NYDec 26, 1965 · N5529Z · Substantial damageNTSB NYC66D0400Accident · No injuriesClosedBeechcraft 35 · Montauk, NYDec 26, 1965 · N3135V · DestroyedNTSB NYC66D0415Accident · No injuriesClosedCessna 170B · Island Park, NYDec 24, 1965 · N2724C · Substantial damageNTSB NYC66F0428Accident · No injuriesClosedPiper PA-28 · Montour Falls, NYDec 22, 1965 · N9055W · Substantial damageNTSB NYC66F0429Accident · No injuriesClosedPiper PA-28 · Narrowsburg, NYDec 19, 1965 · N7981W · Substantial damageNTSB NYC66D0462Accident · No injuriesClosedPiper PA-28 · Montgomery, NYDec 15, 1965 · N8944W · Substantial damageNTSB NYC66F0391Accident · No injuriesClosedCessna 150E · Ronkonkoma, NYDec 14, 1965 · N4050U · Substantial damageNTSB NYC66A0065Accident · 1 fatalClosedPiper PA-30 · White Plains, NYDec 12, 1965 · N7056Y · DestroyedNTSB NYC66D0409Accident · No injuriesClosedBeech J35 · New Paltz, NYDec 9, 1965 · N8292D · Substantial damageNTSB NYC66F0422Accident · Serious injuriesClosedPiper PA-32 · Frewsberg, NYDec 8, 1965 · N3298W · DestroyedNTSB NYC66F0408Accident · No injuriesClosedLuscombe 8C · Henrietta, NYDec 5, 1965 · N28734 · Substantial damageNTSB NYC66D0384Accident · No injuriesClosedCessna 150 · Mattituck, NYDec 5, 1965 · N6078T · Substantial damageNTSB DCA66A0005Accident · 4 fatalClosedLockheed L1049C · Carmel, NYDec 4, 1965 · N6218C · 2 aircraft · DestroyedNTSB NYC66A0063Accident · 2 fatalClosedNavion NAV-A · Fort Ann, NYDec 3, 1965 · N4053K · DestroyedNTSB NYC66A0062Accident · 1 fatalClosedCessna 337 · Glen Falls, NYDec 3, 1965 · N2252X · DestroyedNTSB NYC66I0059Incident · No injuriesClosedBowing 707 321 · Jamaica, NYNov 25, 1965 · N405PA · Minor damageNTSB NYC66D0390Accident · No injuriesClosedPiper PA-28 · Spring Valley, NYNov 23, 1965 · N6593W · Substantial damageNTSB NYC66F0371Accident · No injuriesClosedPiper PA-32 · Tupper Lake, NYNov 15, 1965 · N3323W · Substantial damageNTSB NYC66A0054Accident · No injuriesClosedCessna 172 · Jamaica, NYNov 10, 1965 · N7760U · Substantial damageNTSB NYC66D0339Accident · No injuriesClosedCessna 150 · Croton, NYNov 7, 1965 · N2562J · Substantial damageNTSB NYC66I0051Incident · No injuriesClosedDouglas DC-8 · Jamaica, NYNov 5, 1965 · N8613 · No damageNTSB NYC66F0332Accident · No injuriesClosedPiper PA-22 · Rochester, NYOct 31, 1965 · N3396A · Substantial damageNTSB NYC66D0357Accident · No injuriesClosedBeechcraft G35 · Olean, NYOct 31, 1965 · N4219D · Substantial damageNTSB NYC66F0329Accident · No injuriesClosedPiper PA-22 · Buffalo, NYOct 25, 1965 · N4726Z · Substantial damageNTSB NYC66D0328Accident · No injuriesClosedBeechcraft S35 · Flushing, NYOct 20, 1965 · N5826K · Substantial damageNTSB NYC66F0385Accident · No injuriesClosedCessna 180 · North Creek, NYOct 17, 1965 · N9228C · Substantial damageNTSB NYC66F0323Accident · No injuriesClosedCessna 150E · Deer Park, NYOct 17, 1965 · N6191T · Substantial damageNTSB NYC66F0312Accident · No injuriesClosedCessna 172 · Tupper Lake, NYOct 15, 1965 · N2456U · Substantial damageNTSB NYC66F0307Accident · No injuriesClosedPiper PA-22 · East Amherst, NYOct 12, 1965 · N5569Z · Substantial damageNTSB NYC66F0340Accident · Serious injuriesClosedBeech J35 · Red Hook, NYOct 10, 1965 · N7208B · Substantial damageNTSB NYC66D0278Accident · No injuriesClosedLuscombe 8E · Owego, NYOct 9, 1965 · N2034K · Substantial damageNTSB NYC66F0313Accident · No injuriesClosedErcoupe 415-C · Montour Falls, NYOct 3, 1965 · N99843 · Substantial damageNTSB NYC66F0257Accident · No injuriesClosedNavion A · Montgomery, NYOct 3, 1965 · N5594A · Substantial damageNTSB NYC66I0045Incident · No injuriesClosedBoeing 720 · Jamaica, NYOct 2, 1965 · N7532A · Minor damageNTSB NYC66F0277Accident · No injuriesClosedPiper PA-28 · Amityville, NYOct 2, 1965 · N8496W · Substantial damageNTSB NYC66D0369Accident · No injuriesClosedCessna 150 · Spring Valley, NYOct 2, 1965 · N5969T · Substantial damageNTSB NYC66A0046Accident · 1 fatalClosedCessna 310 · Woodstock, NYOct 1, 1965 · N5229A · DestroyedNTSB NYC66D0300Accident · No injuriesClosedCessna 150 · Buffalo, NYSep 30, 1965 · N3535J · Substantial damageNTSB NYC66F0251Accident · No injuriesClosedPiper PA-28 · Wellsville, NYSep 27, 1965 · N6385W · Substantial damageNTSB NYC66D0279Accident · No injuriesClosedChampion 7AC · Jordanville, NYSep 26, 1965 · N85294 · Substantial damageNTSB NYC66A0061Accident · 1 fatalClosedBeechcraft G-35 · Binghamton, NYSep 26, 1965 · N4557D · DestroyedNTSB NYC66F0314Accident · Minor injuriesClosedCessna 210 · Binghamton, NYSep 25, 1965 · N9682T · Substantial damageNTSB NYC66A0038Accident · No injuriesClosedPiper PA-22 · Jamaica, NYSep 23, 1965 · N4824Z · 2 aircraft · Substantial damageNTSB NYC66F0266Accident · No injuriesClosedStinson 108 · Amherst, NYSep 22, 1965 · N97498 · Substantial damageNTSB NYC66F0225Accident · No injuriesClosedPiper PA-22 · Rochester, NYSep 17, 1965 · N5810Z · Substantial damageNTSB NYC66D0283Accident · No injuriesClosedLuscombe 8E · Spring Valley, NYSep 11, 1965 · N2050K · Substantial damageNTSB NYC66D0245Accident · No injuriesClosedPiper PA-22 · Stormville, NYSep 6, 1965 · N5767Z · Substantial damageNTSB NYC66D0232Accident · No injuriesClosedHelio 391B · Livingston Mnr, NYSep 6, 1965 · N74037 · Substantial damageNTSB NYC66F0261Accident · Minor injuriesClosedPiper PA-23 · Flushing, NYSep 4, 1965 · N1260 · 2 aircraft · Substantial damage