NTSB investigations, 1976, 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\") = 1976
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") = 1976 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 NYC77FFJ08Accident · No injuriesClosedTed Smith 601 · Dunkirk, NYNTSB NYC77FA026Accident · Serious injuriesClosedPiper PA-30 · College Point, NYNTSB NYC77FFJ09Accident · No injuriesClosedPiper PA-28 · Akron, NYNTSB NYC77IA024Incident · No injuriesClosedDouglas DC-10 · Jamicia, NYNTSB NYC77FHJ08Accident · No injuriesClosedCessna 182 · White Plains, NYNTSB NYC77FFA11Accident · Minor injuriesClosedPiper J-3 · Marlboro, NYNTSB NYC77FGM06Accident · No injuriesClosedBeech C23 · Farmingdale, NYNTSB NYC77FHM06Accident · Minor injuriesClosedBeech B19 · Ramapo Valley, NYNTSB NYC77FFA10Accident · Serious injuriesClosedBell 47J-2A · Ellenville, NYNTSB NYC77FHJ07Accident · No injuriesClosedNavion A-205 · Bayport, NYNTSB NYC77FFA09Accident · Serious injuriesClosedCessna 180 · Lisbon, NYNTSB NYC77DHJ10Incident · No injuriesClosedMooney M20B · Shirley, NYNTSB NYC77FFJ06Accident · No injuriesClosedGrum Amer AA1-B · Centereach, NYNTSB NYC77DFA08Accident · No injuriesClosedCessna 150 · Kingston, NYNTSB NYC77FA018Accident · 5 fatalClosedPiper PA-31 · Grand View, NYNTSB NYC77FHJ05Accident · Serious injuriesClosedCessna 210T · White Plains, NYNTSB NYC76DHJ04Accident · No injuriesClosedCessna 172 · Farmingdale, NYNTSB NYC77FA017Accident · No injuriesClosedDehavilland DH-104 · Albany, NYNTSB NYC77FHM04Accident · No injuriesClosedPiper PA-22 · Spring Valley, NYNTSB NYC77FFJ07Accident · No injuriesClosedBeech 95A · Buffalo, NYNTSB NYC77FA016Accident · 3 fatalClosedPiper PA-28 · Westhampton, NYNTSB NYC77DFJ06Accident · No injuriesClosedCessna 172 · Binghamton, NYNTSB NYC77FHJ03Accident · No injuriesClosedPiper PA-28 · Mattituck, NYNTSB NYC77FGM03Accident · No injuriesClosedCessna 172 · West Hickory, NYNTSB NYC77FA011Accident · No injuriesClosedDouglas DC-9 · Buffalo, NYNTSB NYC77IA010Incident · No injuriesClosedCessna 421B · Syracuse, NYNTSB NYC77FHM03Accident · Minor injuriesClosedCessna 195 · Warwick, NYNTSB NYC77FA008Accident · 1 fatalClosedBeech 35-B33 · Glenville, NYNTSB NYC77DFJ04Accident · No injuriesClosedCessna T210L · Hornell, NYNTSB NYC77FFJ02Accident · No injuriesClosedCessna 172K · Varna, NYNTSB NYC77FA007Accident · 2 fatalClosedMooney M20C · Andes, NYNTSB NYC77DFA06Accident · Minor injuriesClosedPiper PA-23 · Hancock, NYNTSB NYC77DFJ03Accident · No injuriesClosedPiper PA-28 · Arcade, NYNTSB NYC77DFA05Accident · No injuriesClosedCessna 180 · Lake George, NYNTSB NYC77FFA04Accident · Serious injuriesClosedBeech F35 · Cobleskill, NYNTSB NYC77FHM02Accident · Serious injuriesClosedSchemp Stdcir · Minisink, NYNTSB NYC77FA002Accident · 1 fatalClosedBeech B95A · Frankfort, NYNTSB NYC77DFA03Accident · No injuriesClosedPiper PA-25 · Ticonderoga, NYNTSB NYC77FHJ01Accident · No injuriesClosedCessna 185 · Port Washingtn, NYNTSB NYC76DFA02Accident · Minor injuriesClosedLake LA-4 · Stillwater, NYNTSB NYC77FFA01Accident · No injuriesClosedBell 47G-2 · Utica, NYNTSB NYC76FFJ01Accident · Serious injuriesClosedMetcalf Sport · Hamburg, NYNTSB NYC77FHJ02Accident · No injuriesClosedCessna 172K · Farmingdale, NYNTSB NYC76FFJ35Accident · Serious injuriesClosedCessna 175 · Wellsville, NYNTSB NYC76FHJ33Accident · No injuriesClosedPiper PA-28 · Mattituck, NYNTSB NYC76FFA52Accident · No injuriesClosedCessna 172G · Marcy, NYNTSB NYC76DFJ34Accident · Serious injuriesClosedPiper PA-25 · Avoca, NYNTSB NYC76AN127Accident · Serious injuriesClosedBoeing 747 · Jamaica, NYNTSB NYC76DFJ32Accident · No injuriesClosedBell 47D-1 · Warsaw, NYNTSB NYC76DFJ36Accident · No injuriesClosedCessna 172 · Leroy, NY