Skip to content

NTSB investigations, 1969, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 NYC70F0221Accident · No injuriesClosedAeronca 15AC · Cannan, NYDec 17, 1969 · N1287H · Substantial damage NTSB NYC70D0002Accident · No injuriesClosedHiller Acft FH1100 · Pt Washington, NYDec 10, 1969 · N515FH · Substantial damage NTSB NYC70D0244Accident · No injuriesClosedCessna 177 · Fulton, NYDec 7, 1969 · N2399Y · Substantial damage NTSB NYC70D0222Accident · No injuriesClosedTaylorcraft BC-12 · New Salem, NYDec 7, 1969 · N29756 · Substantial damage NTSB NYC70D0242Accident · Minor injuriesClosedPiper PA-16 · Baldwinsville, NYDec 6, 1969 · N5290H · Substantial damage NTSB NYC70A0060Accident · 1 fatalClosedCessna 150G · Miller Place, NYDec 4, 1969 · N2924S · Destroyed NTSB NYC70I0058Incident · No injuriesClosedBeech G18S · Griffiss Afb, NYDec 2, 1969 · N4416B · Minor damage NTSB NYC70A0059Accident · 1 fatalClosedMooney M20E · Poughkeepsie, NYDec 2, 1969 · N79367 · Destroyed NTSB NYC70D0002Accident · No injuriesClosedBell 47G-5 · Clarkstown, NYDec 1, 1969 · N8593F · Substantial damage NTSB NYC70A0056Accident · 1 fatalClosedCessna 150 · La Grangeville, NYNov 29, 1969 · N61086 · Destroyed NTSB NYC70F0247Accident · Serious injuriesClosedCessna 182K · Lake Katrine, NYNov 26, 1969 · N3040Q · Substantial damage NTSB NYC70F0215Accident · Serious injuriesClosedCessna 140 · Hammondsport, NYNov 23, 1969 · N1639V · Destroyed NTSB NYC70D0219Accident · No injuriesClosedChampion 7FC · Castleton, NYNov 23, 1969 · N7589B · Substantial damage NTSB NYC70F0231Accident · No injuriesClosedBeech 23 · Mattituck, NYNov 22, 1969 · N2361Q · Substantial damage NTSB NYC70D0002Accident · No injuriesClosedPiper PA-30 · Watertown, NYNov 21, 1969 · N8514Y · Substantial damage NTSB NYC70A0053Accident · Minor injuriesClosedCessna 207 · Kerhonkson, NYNov 19, 1969 · N1529U · Destroyed NTSB DCA70A0005Accident · 14 fatalClosedFairchild FH227B · Glens Falls, NYNov 19, 1969 · N7811M · Destroyed NTSB NYC70F0204Accident · No injuriesClosedCessna 150 · Canastota, NYNov 18, 1969 · N2448J · 2 aircraft · Substantial damage NTSB NYC70F0210Accident · No injuriesClosedCessna 172 · Huntington, NYNov 16, 1969 · N1191F · Substantial damage NTSB NYC70D0213Accident · No injuriesClosedCessna 172K · Marcellus, NYNov 16, 1969 · N46639 · Substantial damage NTSB NYC70F0001Accident · No injuriesClosedMooney M20C · Cortland, NYNov 15, 1969 · N6948N · Substantial damage NTSB NYC70F0241Accident · No injuriesClosedBell 47G-4A · Batavia, NYNov 12, 1969 · N7886S · Substantial damage NTSB NYC70F0205Accident · No injuriesClosedMooney M-22 · Albany, NYNov 5, 1969 · N7708M · Substantial damage NTSB NYC70I0048Incident · No injuriesClosedPiper PA-32 · Flushing, NYOct 30, 1969 · N4145R · Minor damage NTSB NYC70F0203Accident · No injuriesClosedPiper PA-28 · Fitchburg, NYOct 30, 1969 · N4670R · Substantial damage NTSB NYC70F0197Accident · Minor injuriesClosedCessna 182A · White Plains, NYOct 26, 1969 · N1010J · Substantial damage NTSB NYC70A0047Accident · 1 fatalClosedCessna 140 · Middleport, NYOct 26, 1969 · N2389V · Substantial damage NTSB NYC70D0243Accident · Minor injuriesClosedPiper PA-28 · Warners, NYOct 25, 1969 · N7323F · Substantial damage NTSB NYC70I0046Incident · No injuriesClosedAero Comdr 500S · Watermill, NYOct 23, 1969 · N5031E · No damage NTSB NYC70D0201Accident · No injuriesClosedSchweizer S2-33A · Bayport, NYOct 18, 1969 · N5798S · Substantial damage NTSB NYC70D0200Accident · Minor injuriesClosedAlon A-2 · Ticonderoga, NYOct 18, 1969 · N5657F · Substantial damage NTSB NYC70F0178Accident · No injuriesClosedPiper J3C-65 · Amityville, NYOct 10, 1969 · N7242H · Substantial damage NTSB NYC70I0041Incident · Minor injuriesClosedDouglas DC-8 · Jamaica, NYOct 9, 1969 · N8022U · No damage NTSB NYC70D0181Accident · No injuriesClosedPiper PA-24 · Olean, NYOct 7, 1969 · N8776P · Substantial damage NTSB NYC70D0172Accident · No injuriesClosedMooney M20C · Middlesex, NYOct 6, 1969 · N7861V · Substantial damage NTSB NYC70A0040Accident · 1 fatalClosedBoeing E75N1 · Nedrow, NYOct 4, 1969 · N69CB · Destroyed NTSB NYC70I0039Incident · No injuriesClosedBeech B80 · Oneonta, NYSep 30, 1969 · N9525Q · Minor damage NTSB NYC70A0036Accident · 1 fatalClosedAeronca 7DC · Cadyville, NYSep 28, 1969 · N2123E · Destroyed NTSB NYC70D0166Accident · No injuriesClosedPiper PA-28 · White Plains, NYSep 26, 1969 · N6730W · Substantial damage NTSB NYC70F0168Accident · Minor injuriesClosedCessna 172I · Little Valley, NYSep 24, 1969 · N46146 · Destroyed NTSB NYC70F0180Accident · Minor injuriesClosedGrumman G-164A · Williamson, NYSep 23, 1969 · N910X · Substantial damage NTSB NYC70D0158Accident · No injuriesClosedCessna 180 · Fort Plain, NYSep 16, 1969 · N9643B · Substantial damage NTSB NYC70A0033Accident · 2 fatalClosedCessna 172G · Germantown, NYSep 14, 1969 · N4601L · Destroyed NTSB NYC70F0185Accident · 1 fatalClosedPiper PA-18A · Geneva, NYSep 13, 1969 · N9452D · Destroyed NTSB NYC70D0148Accident · No injuriesClosedRiley D-16 · Ripley, NYSep 10, 1969 · N91623 · Substantial damage NTSB NYC70F0154Accident · No injuriesClosedCessna 310C · Mattituck, NYSep 7, 1969 · N1838H · Substantial damage NTSB NYC70F0142Accident · Minor injuriesClosedCessna 180 · Walkill, NYSep 6, 1969 · N2963A · Destroyed NTSB NYC70F0150Accident · Serious injuriesClosedCessna 310B · Stony Point, NYSep 4, 1969 · N6609B · Destroyed NTSB NYC70A0030Accident · 2 fatalClosedStinson 108-1 · Colton, NYSep 1, 1969 · N97789 · Destroyed NTSB NYC70F0143Accident · Minor injuriesClosedBeech V35A · Rochester, NYAug 30, 1969 · N7932R · Substantial damage