Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 NYC73FHM19Accident · Serious injuriesClosedPiper PA-24 · Spring Valley, NYDec 29, 1972 · N5451P · No damage NTSB NYC73FHJ11Accident · Minor injuriesClosedCessna 172L · Deer Park, NYDec 29, 1972 · N4507Q · Substantial damage NTSB NYC73FHM18Accident · Serious injuriesClosedBell 47G-4A · Suffern, NYDec 28, 1972 · N2238W · Substantial damage NTSB NYC73AN090Accident · 3 fatalClosedLockheed L1329 · Saranac Lake, NYDec 27, 1972 · N400M · Destroyed NTSB NYC73AN091Accident · 2 fatalClosedBeech C35 · Malone, NYDec 19, 1972 · N5754K · Destroyed NTSB NYC73AN084Accident · 3 fatalClosedCessna 421 · Cheektowaga, NYDec 16, 1972 · N121X · Destroyed NTSB NYC73AN080Accident · No injuriesClosedBoeing 707 · Jamaica, NYDec 12, 1972 · N788TW · Substantial damage NTSB NYC73FHJ10Accident · No injuriesClosedCessna 150L · N.Bayshore, NYDec 3, 1972 · N5358Q · Substantial damage NTSB NYC73DHJ15Accident · No injuriesClosedCessna 182L · Jamaica, NYNov 24, 1972 · N141HB · Substantial damage NTSB NYC73FFJ14Accident · Minor injuriesClosedCessna 150J · Brockport, NYNov 21, 1972 · N61103 · Substantial damage NTSB NYC73AN069Accident · No injuriesClosedBell 206 · Port Washngton, NYNov 20, 1972 · N7941S · Substantial damage NTSB NYC73FFJ13Accident · Minor injuriesClosedCessna 172L · Leroy, NYNov 17, 1972 · N7549G · Substantial damage NTSB NYC73FHM15Accident · Serious injuriesClosedPiper PA-24 · Spring Valley, NYNov 7, 1972 · N5500P · Substantial damage NTSB NYC73AN063Accident · 1 fatalClosedPiper PA-28R · Mariaville, NYNov 4, 1972 · N3075R · Destroyed NTSB NYC73DFA22Accident · No injuriesClosedAeronca 7AC · Plattsburgh, NYNov 1, 1972 · N1486E · Substantial damage NTSB NYC73DFA21Accident · No injuriesClosedPiper PA-28 · Poestenkill, NYOct 30, 1972 · N583FL · Substantial damage NTSB NYC73FFA19Accident · No injuriesClosedCessna 182P · Essex, NYOct 18, 1972 · N9353G · Substantial damage NTSB NYC73DFA20Accident · No injuriesClosedCessna 206 · Rouse Point, NYOct 16, 1972 · N5129U · Substantial damage NTSB NYC73FFJ11Accident · No injuriesClosedCessna 140 · Etna, NYOct 11, 1972 · N89814 · Substantial damage NTSB NYC73FFA18Accident · No injuriesClosedCessna A185E · Massena, NYOct 11, 1972 · N70077 · Substantial damage NTSB NYC73DFA26Incident · No injuriesClosedPiper PA-28 · Adams, NYOct 10, 1972 · N467FL · Minor damage NTSB NYC73FHJ09Accident · Minor injuriesClosedScorpion 1 · Crotn On Hudsn, NYOct 8, 1972 · N3378 · Substantial damage NTSB NYC73DFJ12Accident · Serious injuriesClosedAmer Avco AA-5 · Montour Falls, NYOct 8, 1972 · N5813L · Substantial damage NTSB NYC73DFJ10Accident · No injuriesClosedPiper PA-22 · Wolcott, NYSep 20, 1972 · N3840P · Substantial damage NTSB NYC73FFJ09Accident · No injuriesClosedCessna 150 · Brockport, NYSep 16, 1972 · N60950 · Substantial damage NTSB NYC73FFA17Accident · Minor injuriesClosedCessna 140 · Postenkill, NYSep 16, 1972 · N2897N · Substantial damage NTSB NYC73FFA16Accident · Serious injuriesClosedEclectic 1C · Cairo, NYSep 16, 1972 · N9211 · Substantial damage NTSB NYC73FFA15Accident · No injuriesClosedBeech A23 · Albany, NYSep 16, 1972 · N7980L · Substantial damage NTSB NYC73DFJ08Accident · Minor injuriesClosedPiper PA-28 · Hamburg, NYSep 15, 1972 · N5885W · Substantial damage NTSB NYC73FHM14Accident · No injuriesClosedPiper PA-28 · Spring Valley, NYSep 10, 1972 · N8042N · Substantial damage NTSB NYC73FFA14Accident · No injuriesClosedPiper PA-28 · Greene, NYSep 10, 1972 · N5183L · Substantial damage NTSB NYC73FFA13Accident · Serious injuriesClosedCessna 140 · Knox, NYSep 10, 1972 · N3054N · Substantial damage NTSB NYC73AN042Accident · 1 fatalClosedMooney M20G · Skaneateles, NYSep 8, 1972 · N6806N · Destroyed NTSB NYC73DFJ07Accident · No injuriesClosedSchweizer 1-23 · Campbell, NYSep 4, 1972 · N1140S · Substantial damage NTSB NYC73AN040Accident · Serious injuriesClosedBoeing 747 · Jamaica, NYSep 1, 1972 · N93101 · Minor damage NTSB NYC73FHJ07Accident · No injuriesClosedBeech A23 · Central Islip, NYAug 31, 1972 · N3696Q · Substantial damage NTSB NYC73FHM09Accident · No injuriesClosedPiper PA-28 · Newburgh, NYAug 29, 1972 · N95412 · Substantial damage NTSB NYC73FFJ06Accident · Serious injuriesClosedSchweizer TSC1A1 · Watkins Glen, NYAug 29, 1972 · N2020T · Destroyed NTSB NYC73IN037Incident · No injuriesClosedN.American NA-265 · White Plains, NYAug 28, 1972 · N360N · Minor damage NTSB NYC73FFJ05Accident · Minor injuriesClosedPiper PA-28 · Weedsport, NYAug 27, 1972 · N659FL · Substantial damage NTSB NYC73DHM08Accident · No injuriesClosedCessna 172 · Spring Valley, NYAug 26, 1972 · CK-EKS · Substantial damage NTSB NYC73AN033Accident · 2 fatalClosedCessna 177 · Almond, NYAug 24, 1972 · N2225Y · Destroyed NTSB NYC73FFA12Incident · No injuriesClosedBeech 95-B55 · Glens Falls, NYAug 23, 1972 · N7474N · Minor damage NTSB NYC73FFA11Incident · No injuriesClosedCessna 210 · Hudson, NYAug 23, 1972 · N6176R · Minor damage NTSB NYC73AN032Accident · 2 fatalClosedCessna 150F · Andes, NYAug 22, 1972 · N948MA · Destroyed NTSB NYC73AN031Accident · 1 fatalClosedCessna 150F · Smithtown, NYAug 22, 1972 · N6983F · Destroyed NTSB NYC73FFA10Accident · No injuriesClosedCessna 150 · Hudson, NYAug 20, 1972 · N6207G · Substantial damage NTSB NYC73IN030Incident · No injuriesClosedBoeing 727 · Jamaica, NYAug 19, 1972 · N1987 · Minor damage NTSB NYC73AN027Accident · 2 fatalClosedLake LA-4 · Cairo, NYAug 14, 1972 · N1163L · Destroyed NTSB DCA73A0001Accident · Minor injuriesClosedBoeing 707 · Jamaica, NYAug 13, 1972 · YU-AGA · Substantial damage