NTSB investigations, 1965, 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.
Cases per year
| 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
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\") = 1965
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") = 1965 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 NYC66F0474Accident · No injuriesClosedCessna 310D · Lindenhurst, NYNTSB NYC66F0432Accident · No injuriesClosedPiper PA-22 · Spring Valley, NYNTSB NYC66D0400Accident · No injuriesClosedBeechcraft 35 · Montauk, NYNTSB NYC66D0415Accident · No injuriesClosedCessna 170B · Island Park, NYNTSB NYC66F0428Accident · No injuriesClosedPiper PA-28 · Montour Falls, NYNTSB NYC66F0429Accident · No injuriesClosedPiper PA-28 · Narrowsburg, NYNTSB NYC66D0462Accident · No injuriesClosedPiper PA-28 · Montgomery, NYNTSB NYC66F0391Accident · No injuriesClosedCessna 150E · Ronkonkoma, NYNTSB NYC66A0065Accident · 1 fatalClosedPiper PA-30 · White Plains, NYNTSB NYC66D0409Accident · No injuriesClosedBeech J35 · New Paltz, NYNTSB NYC66F0422Accident · Serious injuriesClosedPiper PA-32 · Frewsberg, NYNTSB NYC66F0408Accident · No injuriesClosedLuscombe 8C · Henrietta, NYNTSB NYC66D0384Accident · No injuriesClosedCessna 150 · Mattituck, NYNTSB DCA66A0005Accident · 4 fatalClosedLockheed L1049C · Carmel, NYNTSB NYC66A0063Accident · 2 fatalClosedNavion NAV-A · Fort Ann, NYNTSB NYC66A0062Accident · 1 fatalClosedCessna 337 · Glen Falls, NYNTSB NYC66I0059Incident · No injuriesClosedBowing 707 321 · Jamaica, NYNTSB NYC66D0390Accident · No injuriesClosedPiper PA-28 · Spring Valley, NYNTSB NYC66F0371Accident · No injuriesClosedPiper PA-32 · Tupper Lake, NYNTSB NYC66A0054Accident · No injuriesClosedCessna 172 · Jamaica, NYNTSB NYC66D0339Accident · No injuriesClosedCessna 150 · Croton, NYNTSB NYC66I0051Incident · No injuriesClosedDouglas DC-8 · Jamaica, NYNTSB NYC66F0332Accident · No injuriesClosedPiper PA-22 · Rochester, NYNTSB NYC66D0357Accident · No injuriesClosedBeechcraft G35 · Olean, NYNTSB NYC66F0329Accident · No injuriesClosedPiper PA-22 · Buffalo, NYNTSB NYC66D0328Accident · No injuriesClosedBeechcraft S35 · Flushing, NYNTSB NYC66F0385Accident · No injuriesClosedCessna 180 · North Creek, NYNTSB NYC66F0323Accident · No injuriesClosedCessna 150E · Deer Park, NYNTSB NYC66F0312Accident · No injuriesClosedCessna 172 · Tupper Lake, NYNTSB NYC66F0307Accident · No injuriesClosedPiper PA-22 · East Amherst, NYNTSB NYC66F0340Accident · Serious injuriesClosedBeech J35 · Red Hook, NYNTSB NYC66D0278Accident · No injuriesClosedLuscombe 8E · Owego, NYNTSB NYC66F0313Accident · No injuriesClosedErcoupe 415-C · Montour Falls, NYNTSB NYC66F0257Accident · No injuriesClosedNavion A · Montgomery, NYNTSB NYC66I0045Incident · No injuriesClosedBoeing 720 · Jamaica, NYNTSB NYC66F0277Accident · No injuriesClosedPiper PA-28 · Amityville, NYNTSB NYC66D0369Accident · No injuriesClosedCessna 150 · Spring Valley, NYNTSB NYC66A0046Accident · 1 fatalClosedCessna 310 · Woodstock, NYNTSB NYC66D0300Accident · No injuriesClosedCessna 150 · Buffalo, NYNTSB NYC66F0251Accident · No injuriesClosedPiper PA-28 · Wellsville, NYNTSB NYC66D0279Accident · No injuriesClosedChampion 7AC · Jordanville, NYNTSB NYC66A0061Accident · 1 fatalClosedBeechcraft G-35 · Binghamton, NYNTSB NYC66F0314Accident · Minor injuriesClosedCessna 210 · Binghamton, NYNTSB NYC66A0038Accident · No injuriesClosedPiper PA-22 · Jamaica, NYNTSB NYC66F0266Accident · No injuriesClosedStinson 108 · Amherst, NYNTSB NYC66F0225Accident · No injuriesClosedPiper PA-22 · Rochester, NYNTSB NYC66D0283Accident · No injuriesClosedLuscombe 8E · Spring Valley, NYNTSB NYC66D0245Accident · No injuriesClosedPiper PA-22 · Stormville, NYNTSB NYC66D0232Accident · No injuriesClosedHelio 391B · Livingston Mnr, NYNTSB NYC66F0261Accident · Minor injuriesClosedPiper PA-23 · Flushing, NY