Skip to content

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 NYC80FHJ06Accident · Minor injuriesClosedCougar AJ1 · Bayport, NYDec 30, 1979 · N11112 · Substantial damage NTSB NYC80FA017Accident · 2 fatalClosedCessna 172N · Lindenhurst, NYDec 30, 1979 · N738WX · Destroyed NTSB NYC80DFJ02Accident · No injuriesClosedSchweizer SGS126 · Elmira, NYDec 30, 1979 · N2508H · Substantial damage NTSB NYC80FHJ08Accident · No injuriesClosedPiper PA-28 · Amityville, NYDec 29, 1979 · N4372J · Substantial damage NTSB NYC80FA015Accident · 1 fatalClosedCessna 172 · Washingtnville, NYDec 16, 1979 · N6647A · Destroyed NTSB NYC80FFA07Accident · No injuriesClosedCessna 172 · Sharon Springs, NYDec 15, 1979 · N739GE · Substantial damage NTSB NYC80FHJ05Accident · No injuriesClosedGrum Amer AA1B · Shirley, NYDec 9, 1979 · N1360R · Substantial damage NTSB NYC80FHJ03Accident · No injuriesClosedPiper PA-28R · Flushing, NYNov 28, 1979 · N4668J · Substantial damage NTSB NYC80FHJ04Accident · Serious injuriesClosedEnstrom F28C · Oakdale, NYNov 24, 1979 · N642H · Substantial damage NTSB NYC80FFA06Accident · No injuriesClosedCessna 180K · Utica, NYNov 21, 1979 · N2597K · Substantial damage NTSB NYC80FAMS2Accident · 3 fatalClosedCessna 172 · Shadigee, NYNov 4, 1979 · N737TH · Destroyed NTSB NYC80FHM02Accident · Serious injuriesClosedCessna 172 · E.Fishkill, NYOct 19, 1979 · N7WP · Substantial damage NTSB NYC80FFA03Accident · No injuriesClosedCessna 150M · Albany, NYOct 14, 1979 · N9390U · Substantial damage NTSB NYC80FFA02Accident · No injuriesClosedCessna 185 · Booneville, NYOct 14, 1979 · N1678R · Substantial damage NTSB NYC80FFA01Accident · Serious injuriesClosedRand KR-2 · Ballston, NYOct 10, 1979 · N118MM · Destroyed NTSB NYC80FHJ01Accident · Serious injuriesClosedCessna 185 · Westhampton, NYOct 8, 1979 · N93010 · No damage NTSB NYC80DFJ01Accident · Minor injuriesClosedPiper PA-28 · Montour Falls, NYOct 7, 1979 · N2302T · Substantial damage NTSB NYC80FA004Accident · 1 fatalClosedBell 206B · Old Westbury, NYOct 6, 1979 · N3500M · Destroyed NTSB NYC80FA003Accident · No injuriesClosedPiper PA-23 · Jamaica, NYOct 4, 1979 · N5767Y · Substantial damage NTSB NYC80FFJ28Accident · Serious injuriesClosedCessna 150 · Waterloo, NYSep 22, 1979 · N66309 · Destroyed NTSB NYC79FFA38Accident · No injuriesClosedEnstrom F-28A · Newcomb, NYSep 22, 1979 · N222LP · Substantial damage NTSB NYC79DFJ27Accident · No injuriesClosedLuscombe 8E · Gasport, NYSep 16, 1979 · N2642K · Substantial damage NTSB NYC79IA099Incident · No injuriesClosedBeech E18S · Newburgh, NYSep 15, 1979 · N49MA · Minor damage NTSB NYC79FHJ28Accident · No injuriesClosedCessna U206 · Southold, NYSep 15, 1979 · N60574 · Substantial damage NTSB NYC79FFJ29Accident · Serious injuriesClosedSchweizer 2-33A · Ithaca, NYSep 15, 1979 · N17870 · Substantial damage NTSB NYC80FHJ02Accident · No injuriesClosedCessna 150 · Farmingdale, NYSep 13, 1979 · N8999U · Substantial damage NTSB NYC79FA095Accident · 1 fatalClosedBeech N35 · Olean, NYSep 11, 1979 · N9406Y · Destroyed NTSB NYC80DFA04Accident · Minor injuriesClosedSchleicher KA6 · Wurtsboro, NYSep 9, 1979 · N227PN · Minor damage NTSB NYC79FA089Accident · No injuriesClosedCessna 152 · Warwick, NYSep 3, 1979 · N7332B · Substantial damage NTSB NYC79FA087Accident · Serious injuriesClosedPiper PA-28 · Fishers Island, NYSep 2, 1979 · N6945C · Substantial damage NTSB NYC79DFA36Accident · No injuriesClosedCessna 172 · Shinhopple, NYSep 2, 1979 · N5980R · Substantial damage NTSB NYC79DFA35Accident · No injuriesClosedCessna 172 · Alexandria Bay, NYSep 1, 1979 · N64255 · Substantial damage NTSB NYC79IA084Incident · No injuriesClosedBoeing 747 · Jamaica, NYAug 29, 1979 · N9673 · Minor damage NTSB NYC79FHJ26Accident · Serious injuriesClosedPiper PA-34 · East Quogue, NYAug 28, 1979 · N2080W · Substantial damage NTSB NYC79FFJ26Accident · No injuriesClosedPiper PA-24 · Wellsville, NYAug 24, 1979 · N9232P · Substantial damage NTSB NYC79FA083Accident · Serious injuriesClosedPiper PA-23 · Sundown, NYAug 24, 1979 · N55PH · Destroyed NTSB NYC79FA082Accident · 3 fatalClosedAero Comdr 680FL · Rexville, NYAug 23, 1979 · N5003E · Destroyed NTSB NYC79FFS25Accident · Serious injuriesClosedBushby 22 · Geneseo, NYAug 22, 1979 · N3QB · Substantial damage NTSB NYC79FFA33Accident · Serious injuriesClosedCessna 172M · Schroon Lake, NYAug 21, 1979 · N29391 · Substantial damage NTSB NYC79FA078Accident · No injuriesClosedCessna 152 · Islip, NYAug 16, 1979 · N216DV · Substantial damage NTSB NYC79FFA32Accident · No injuriesClosedBeech B23 · New Paltz, NYAug 15, 1979 · N6047C · Substantial damage NTSB NYC79FA074Accident · 3 fatalClosedBeech D55 · Flushing, NYAug 9, 1979 · N105AC · Destroyed NTSB NYC79FHJ28Accident · No injuriesClosedFlybaby 1B · Shirley, NYAug 8, 1979 · N78FP · Substantial damage NTSB NYC79FFA29Accident · No injuriesClosedPiper PA-25 · Schuylerville, NYAug 6, 1979 · N9838P · Substantial damage NTSB NYC79FHJ24Accident · No injuriesClosedCessna 340 · White Plains, NYAug 5, 1979 · N66AJ · Substantial damage NTSB NYC79FHJ27Accident · Minor injuriesClosedBeech C23 · Mattituck, NYJul 29, 1979 · N60045 · Substantial damage NTSB NYC79FFA27Accident · No injuriesClosedCessna 177 · Wallkill, NYJul 28, 1979 · N3343T · Substantial damage NTSB NYC79DFA28Accident · No injuriesClosedCessna 185 · Durham, NYJul 28, 1979 · N601 · Substantial damage NTSB NYC79IA066Incident · No injuriesClosedShorts SH-7 · Jamaica, NYJul 26, 1979 · N28TC · Minor damage NTSB NYC79IA065Incident · No injuriesClosedConcorde Type 1 · Jamaica, NYJul 21, 1979 · F-BFVD · Minor damage