Skip to content

NTSB investigations, 1968, NY

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1968, NY per year, 1962–2026: 4,784 cases
1962	8
1963	2
1964	162
1965	197
1966	215
1967	226
1968	181
1969	172
1970	170
1971	164
1972	161
1973	124
1974	167
1975	121
1976	146
1977	152
1978	131
1979	119
1980	101
1981	100
1982	91
1983	95
1984	76
1985	84
1986	71
1987	70
1988	68
1989	64
1990	63
1991	58
1992	36
1993	49
1994	52
1995	58
1996	48
1997	36
1998	42
1999	41
2000	45
2001	42
2002	32
2003	46
2004	32
2005	43
2006	24
2007	43
2008	30
2009	32
2010	49
2011	37
2012	37
2013	28
2014	28
2015	34
2016	33
2017	28
2018	37
2019	19
2020	25
2021	24
2022	27
2023	28
2024	30
2025	16
2026	14

Where

Latest cases

Query with SQL

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") = 1968 AND c."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1968
    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.

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") = 1968
  AND c."eventStateOrRegion" = 'NY' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB NYC69A0065Accident · No injuriesClosedAero Comdr 1121AC · Buffalo, NYDec 19, 1968 · N3032 · Substantial damage NTSB NYC69A0063Accident · No injuriesClosedPiper PA-23 · Jfk Airport, NYDec 15, 1968 · N4319P · Substantial damage NTSB NYC69F0292Accident · Serious injuriesClosedNavion A · Farmingdale, NYDec 12, 1968 · N4184K · Destroyed NTSB NYC69I0062Incident · No injuriesClosedBoeing 707 · Jfk Intl, NYDec 10, 1968 · EI-APG · Minor damage NTSB NYC69D0264Accident · No injuriesClosedPiper J-3 · Amityville, NYDec 8, 1968 · N7381H · Substantial damage NTSB NYC69A0060Accident · No injuriesClosedAero Comdr 1121 · Watertown, NYDec 5, 1968 · N900JL · Substantial damage NTSB NYC69A0059Accident · 1 fatalClosedPiper PA-22 · Lakewood, NYDec 5, 1968 · N3179Z · Substantial damage NTSB NYC69D0297Accident · No injuriesClosedCessna 172 · Roscoe, NYDec 1, 1968 · N46168 · Substantial damage NTSB NYC69F0265Accident · 1 fatalClosedBensen B8M · Stormville, NYNov 26, 1968 · N1056 · Destroyed NTSB NYC69D0250Accident · No injuriesClosedAmer Yankee AA-1 · Oneonta, NYNov 24, 1968 · N5615L · Substantial damage NTSB NYC69F0270Accident · No injuriesClosedCessna 140 · Camillus, NYNov 23, 1968 · N76051 · Substantial damage NTSB NYC69F0245Accident · Minor injuriesClosedCessna 150F · Middletown, NYNov 23, 1968 · N6535F · Substantial damage NTSB NYC69D0283Accident · Serious injuriesClosedPiper PA-28 · Amityville, NYNov 23, 1968 · N6744J · Substantial damage NTSB NYC69F0286Accident · No injuriesClosedAmer Avco AA-1 · Bayport, NYNov 21, 1968 · N5612L · Substantial damage NTSB NYC69A0056Accident · 2 fatalClosedBeech 65 · Latham, NYNov 18, 1968 · N1401M · Destroyed NTSB NYC69D0271Accident · No injuriesClosedNavion A · Cooperstown, NYNov 13, 1968 · N8909H · Substantial damage NTSB NYC69F0272Accident · Minor injuriesClosedPitts SPL S-1A · Frankfort, NYNov 9, 1968 · N3107 · Destroyed NTSB NYC69D0248Accident · No injuriesClosedGrumman G44A · Piseco Lake, NYNov 5, 1968 · N213K · Substantial damage NTSB NYC69D0222Accident · No injuriesClosedMooney MK 20A · Frankfort, NYOct 27, 1968 · N8198E · Substantial damage NTSB NYC69F0229Accident · No injuriesClosedBeech V35 · Albany, NYOct 22, 1968 · N5655D · Substantial damage NTSB NYC69D0211Accident · No injuriesClosedPiper PA-28 · Middletown, NYOct 20, 1968 · N6335W · Substantial damage NTSB NYC69F0221Accident · Minor injuriesClosedCessna 182 · Deer Park, NYOct 13, 1968 · N3436S · Substantial damage NTSB NYC69D0247Accident · No injuriesClosedLuscombe 8A · Glens Falls, NYOct 13, 1968 · N22094 · Substantial damage NTSB NYC69D0223Accident · No injuriesClosedFly Baby 1A · Coram, NYOct 13, 1968 · N343Y · Substantial damage NTSB NYC69F0216Accident · Minor injuriesClosedCessna 180 · Canandaigua, NYOct 8, 1968 · N6823D · Substantial damage NTSB NYC69D0233Accident · No injuriesClosedPiper PA-24 · Montauk, NYOct 5, 1968 · N5759P · Substantial damage NTSB NYC69D0190Accident · No injuriesClosedChampion 7ECA · Bayport, NYOct 5, 1968 · N1876G · Substantial damage NTSB NYC69A0044Accident · Serious injuriesClosedBoeing 707 · Jamaica, NYOct 5, 1968 · N385US · No damage NTSB NYC69D0232Accident · No injuriesClosedCessna 150 · Degrasse, NYOct 2, 1968 · N6487F · Substantial damage NTSB NYC69D0191Accident · No injuriesClosedCessna 172 · Oriskany, NYSep 30, 1968 · N7064T · Destroyed NTSB NYC69D0230Accident · No injuriesClosedBeech 23 · Mahopac, NYSep 29, 1968 · N8884M · Substantial damage NTSB NYC69F0197Accident · No injuriesClosedCessna 150 · East Hampton, NYSep 28, 1968 · N22653 · Substantial damage NTSB NYC69D0209Accident · No injuriesClosedCessna 15OE · Croton On Hud, NYSep 27, 1968 · N2562J · Substantial damage NTSB NYC69A0041Accident · No injuriesClosedDouglas DC-3C · Teterboro, NYSep 26, 1968 · N64423 · Destroyed NTSB NYC69D0208Accident · No injuriesClosedCessna 320C · Tupper Lake, NYSep 23, 1968 · N3024T · Substantial damage NTSB NYC69F0201Accident · No injuriesClosedPiper PA-28 · Canandaigua, NYSep 22, 1968 · N8809W · Substantial damage NTSB NYC69D0215Accident · No injuriesClosedCessna 337 · White Plains, NYSep 15, 1968 · N2511S · Substantial damage NTSB NYC69A0033Accident · 2 fatalClosedPiper PA-28 · Buffalo, NYSep 15, 1968 · N1742J · Destroyed NTSB NYC69A0032Accident · 1 fatalClosedCessna 150G · Endicott, NYSep 15, 1968 · N6341S · Substantial damage NTSB NYC69F0243Accident · 1 fatalClosedMooney M20E · Mahopac, NYSep 14, 1968 · N3499X · Destroyed NTSB NYC69D0174Accident · No injuriesClosedCessna 150 · Callicoon, NYSep 9, 1968 · N7047S · Substantial damage NTSB NYC69F0129Accident · Minor injuriesClosedCessna 172 · Wappinger Fall, NYSep 8, 1968 · N4103L · Substantial damage NTSB NYC69A0030Accident · 2 fatalClosedCessna 402 · Flushing, NYSep 8, 1968 · N8283F · 2 aircraft · Substantial damage NTSB NYC69D0181Accident · Minor injuriesClosedCulver LFA · Perry, NYSep 3, 1968 · N41603 · Substantial damage NTSB NYC69F0149Accident · Serious injuriesClosedCessna 150 · New City, NYSep 1, 1968 · N6592F · Destroyed NTSB NYC69D0204Accident · No injuriesClosedPiper PA-28 · Amityville, NYSep 1, 1968 · N7184R · Substantial damage NTSB NYC69F0164Accident · No injuriesClosedMooney M20A · Croton Lake, NYAug 31, 1968 · CF-MME · Substantial damage NTSB NYC69F0148Accident · No injuriesClosedCessna 150 · La Grangeville, NYAug 31, 1968 · N7209S · Substantial damage NTSB NYC69D0156Accident · No injuriesClosedAero Comdr 100 · Canandaigua, NYAug 31, 1968 · N5568M · Substantial damage NTSB NYC69F0182Accident · No injuriesClosedPiper PA-28 · Croton Lake, NYAug 29, 1968 · N6833W · Substantial damage