Skip to content

NTSB investigations, 1978, 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 NYC79FFJ07Accident · Minor injuriesClosedPiper PA-28 · Rochester, NYDec 29, 1978 · N55112 · Substantial damage NTSB NYC79FFA06Accident · No injuriesClosedCessna 172 · Albany, NYDec 28, 1978 · N3891S · Substantial damage NTSB NYC79DFJ08Accident · No injuriesClosedPiper PA-23 · Weedsport, NYDec 28, 1978 · N6929Y · Substantial damage NTSB NYC79FA044Accident · 3 fatalClosedPiper PA-31 · Saranac Lake, NYDec 25, 1978 · N114TA · Substantial damage NTSB NYC79FFA07Accident · No injuriesClosedPiper PA-38 · Oneonta, NYDec 23, 1978 · N2483A · Substantial damage NTSB NYC79FA016Accident · 1 fatalClosedCessna 182 · Panama, NYDec 21, 1978 · N71206 · Substantial damage NTSB NYC79FFA05Accident · No injuriesClosedCessna 182M · Albany, NYDec 17, 1978 · N71606 · Substantial damage NTSB NYC79FHJ05Accident · No injuriesClosedCessna 150 · Farmingdale, NYDec 11, 1978 · N714BZ · No damage NTSB NYC79DFA04|NYC79FFA04Accident · Minor injuriesClosedDehavilland DHC-6 · Watertown, NYDec 2, 1978 · N59AN · 2 aircraft · Substantial damage NTSB NYC79FHJ03Accident · No injuriesClosedCessna 150 · Farmingdale, NYNov 20, 1978 · N8999U · Substantial damage NTSB NYC79DFA03Accident · No injuriesClosedLuscombe 8F · Saratoga Spgs, NYNov 19, 1978 · N1917B · Substantial damage NTSB NYC79IA010Incident · No injuriesClosedDouglas DC-8 · Jamaica, NYNov 14, 1978 · N8007U · Minor damage NTSB NYC79FHJ04Accident · No injuriesClosedPipep PA-28 · Riverhead, NYNov 9, 1978 · N3990R · Substantial damage NTSB NYC79FFJ05Accident · Serious injuriesClosedPiper PA-28 · Boston, NYNov 5, 1978 · N5935U · Destroyed NTSB NYC79DFJ04Accident · No injuriesClosedBellanca 7GCBC · Ithaca, NYNov 4, 1978 · N8368V · Substantial damage NTSB NYC79FHM02Accident · No injuriesClosedCessa 182J · Tuxedo, NYNov 3, 1978 · N2617F · Substantial damage NTSB NYC79FA007Accident · 2 fatalClosedCessna 172 · Marcy, NYNov 2, 1978 · N46037 · Substantial damage NTSB NYC79FFJ03Accident · Minor injuriesClosedGrumman G-164B · Wolcott, NYOct 30, 1978 · N48724 · Substantial damage NTSB NYC79DFA02Accident · No injuriesClosedCessna 180 · Wallkill, NYOct 29, 1978 · N7853A · Substantial damage NTSB NYC79FHJ02Accident · Minor injuriesClosedCessna 150 · Brooklyn, NYOct 16, 1978 · N11302 · Substantial damage NTSB NYC79DFA01Accident · Minor injuriesClosedBellanca 7ACA · Tupper Lake, NYOct 16, 1978 · N9176L · Substantial damage NTSB NYC79FFJ03Accident · Minor injuriesClosedAeronca 11AC · Collins, NYOct 8, 1978 · N3635E · Substantial damage NTSB NYC79FFJ01Accident · Minor injuriesClosedCessna 182 · Jamestown, NYOct 2, 1978 · N8128M · Substantial damage NTSB NYC79FFJ06Accident · 1 fatalClosedFly Baby JD-1 · Java Center, NYOct 1, 1978 · N12JD · Substantial damage NTSB NYC79FFJ40Accident · 1 fatalClosedVarieze CN-VEZ · Angola, NYSep 27, 1978 · N56CN · Substantial damage NTSB NYC78FHJ25Accident · No injuriesClosedCessna 172 · Farmingdale, NYSep 26, 1978 · N1273U · 2 aircraft · Substantial damage NTSB NYC78DFJ42Accident · No injuriesClosedCessna 172 · Wellsville, NYSep 26, 1978 · N5968A · Substantial damage NTSB NYC78FHJ22Accident · Minor injuriesClosedCessna 172 · Islip, NYSep 23, 1978 · N9892Q · Substantial damage NTSB NYC78FFJ41Accident · No injuriesClosedPiper PA-23 · Sherman, NYSep 17, 1978 · CF-PMR · Substantial damage NTSB NYC78FFJ39Accident · No injuriesClosedAero Comdr 112 · Jamestown, NYSep 16, 1978 · N4663W · Substantial damage NTSB NYC78FA093Accident · 2 fatalClosedCessna R172K · Venice Center, NYSep 16, 1978 · N9655V · Substantial damage NTSB NYC78FHJ26Accident · No injuriesClosedPiper PA-28 · Amityville, NYSep 13, 1978 · N6771J · Substantial damage NTSB NYC78FA091Accident · 3 fatalClosedAero Comdr 500S · Hammondsport, NYSep 11, 1978 · N40MA · Substantial damage NTSB NYC78FFJ38Accident · No injuriesClosedN.American N265 · Elmira, NYSep 10, 1978 · N711WK · Substantial damage NTSB NYC78FFA32Accident · No injuriesClosedCessna 182C · Hudson, NYSep 10, 1978 · N8956T · Substantial damage NTSB NYC78DFA30Accident · No injuriesClosedPiper PA-28 · Barneveld, NYSep 10, 1978 · N8666E · Substantial damage NTSB NYC78FFA31Accident · Minor injuriesClosedCessna 177B · Lake Placid, NYSep 6, 1978 · N30857 · Substantial damage NTSB NYC78FFJ37Accident · Minor injuriesClosedGrum Amer AA-5B · Cortland, NYSep 5, 1978 · N74355 · Substantial damage NTSB NYC78FHJ24Accident · Minor injuriesClosedPiper PA-24 · North Castle, NYSep 2, 1978 · N7388P · Destroyed NTSB NYC78FFA28Accident · No injuriesClosedGrum Amer AA1-B · Mechanicville, NYSep 2, 1978 · N1454R · Substantial damage NTSB NYC78FHJ23Accident · Minor injuriesClosedBensen B-8M · Bayport, NYSep 1, 1978 · N16654 · Substantial damage NTSB NYC78FFA29Accident · Minor injuriesClosedBeech E18S · Latham, NYSep 1, 1978 · N58H · Destroyed NTSB NYC78FHJ21Accident · Minor injuriesClosedMccolloch T-1 · South Haven, NYAug 27, 1978 · N4301G · Substantial damage NTSB NYC78FFJ36Accident · Minor injuriesClosedCessna 172 · W.Bloomfield, NYAug 27, 1978 · N6447B · Substantial damage NTSB NYC78FA084Accident · Minor injuriesClosedN American AT-6 · Ellenville, NYAug 21, 1978 · N8992 · Substantial damage NTSB NYC78FA080Accident · No injuriesClosedPiper PA-28 · Cassadaga, NYAug 13, 1978 · N5841F · Substantial damage NTSB NYC78FA079Accident · No injuriesClosedBell 47G · Riverhead, NYAug 13, 1978 · N8593F · Substantial damage NTSB NYC78DFJ35Accident · Minor injuriesClosedMcdonald II · Mayville, NYAug 12, 1978 · N12825 · Substantial damage NTSB NYC78FA078Accident · No injuriesClosedBell 47G4A · New Rochelle, NYAug 11, 1978 · N473FW · Substantial damage NTSB NYC78FA076Accident · Minor injuriesClosedPiper PA-31 · East Hampton, NYAug 7, 1978 · N9093Y · Substantial damage