NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 NYC81IA018Incident · No injuriesClosedAero Cmdr 690 · Dunkirk, NYNTSB CHI81FA013Accident · 1 fatalClosedCessna 172M · Ithaca, NYNTSB NYC81DFA09Accident · No injuriesClosedPiper PA-28 · Palenville, NYNTSB NYC81FHJ03Accident · Minor injuriesClosedCessna 150 · Massapequa Pk, NYNTSB NYC81FFA08Accident · Serious injuriesClosedCessna 182 · Greene, NYNTSB NYC81FHJ05Accident · No injuriesClosedCessna 150 · Ronkonkomoa, NYNTSB NYC81FA016Accident · 4 fatalClosedPiper PA-28R · Jamaica, NYNTSB NYC81FHJ02Accident · No injuriesClosedBeech C23 · Farmingdale, NYNTSB NYC81FA013Accident · Minor injuriesClosedSwearingin SA226 · Binghamton, NYNTSB NYC81DFJ02Accident · Serious injuriesClosedSchweizer 1-34R · Dansville, NYNTSB NYC81FFA07Accident · No injuriesClosedAero Comdr 500-A · Glens Falls, NYNTSB NYC81FFA06Accident · Serious injuriesClosedCessna T210K · Duanesburg, NYNTSB NYC81FA009Accident · 1 fatalClosedCessna U206 · West Hurley, NYNTSB NYC81DFA05Accident · No injuriesClosedPiper PA-28 · Accord, NYNTSB NYC81FHJ01Accident · No injuriesClosedSportster HA2M · Brookhaven, NYNTSB NYC81FFA04Accident · No injuriesClosedCessna 182 · Monticello, NYNTSB NYC81FA007Accident · 1 fatalClosedBeech 95-C55 · Canisteo, NYNTSB NYC81FFA03Accident · No injuriesClosedCessna 185F · Round Lake, NYNTSB NYC81FFA02Accident · Serious injuriesClosedPiper PA-28 · Lake Placid, NYNTSB NYC81FFJ01Accident · No injuriesClosedCessna 172 · Hamburg, NYNTSB NYC81DHM01Accident · No injuriesClosedCessna 177 · Pleasant Vly, NYNTSB NYC81FFA01Accident · No injuriesClosedCessna 185 · Round Lake, NYNTSB NYC80FFA26Accident · No injuriesClosedSchreder HP-14 · Lake Placid, NYNTSB NYC80FA093Accident · Serious injuriesClosedPiper PA-28R · Farmingdale, NYNTSB NYC80FFA25Accident · 1 fatalClosedOsprey II · Kingston, NYNTSB NYC80DA090Accident · Serious injuriesClosedAeronca 7AC · Aurora, NYNTSB NYC81FA087Accident · 2 fatalClosedAero Comdr 680E · New Windsor, NYNTSB NYC80DA083Accident · No injuriesClosedBeech D55 · Buffalo, NYNTSB NYC80FA080Accident · 2 fatalClosedPiper PA-28 · Herkimer, NYNTSB NYC80DA084Accident · No injuriesClosedCessna 150 · Geneseo, NYNTSB NYC80IA077Incident · No injuriesClosedCessna 172 · Rochester, NYNTSB NYC80FFJ15Accident · No injuriesClosedCessna 172N · Fulton, NYNTSB NYC80FFJ14Accident · No injuriesClosedCessna 177RG · Canandaigua, NYNTSB NYC80FFJ13Accident · No injuriesClosedBellanca 17-30 · Akron, NYNTSB NYC80IA073Incident · No injuriesClosedFairchild F-27 · Flushing, NYNTSB NYC80DA072Accident · No injuriesClosedPiper PA-38 · W Hampton Bch, NYNTSB NYC80FHJ22Accident · No injuriesClosedCessna 206F · Dunwood, NYNTSB NYC80FHJ21Accident · No injuriesClosedCessna 172 · Islip, NYNTSB NYC80FA070Accident · 1 fatalClosedPiper PA-30 · Cutchogue, NYNTSB NYC80FFA24Accident · No injuriesClosedPiper PA-28 · Kingston, NYNTSB NYC80FFA23Accident · Serious injuriesClosedPiper J3 · Galway, NYNTSB NYC80FHM24Accident · No injuriesClosedCessna 172N · Spring Valley, NYNTSB NYC80FHM22Accident · Minor injuriesClosedPiper PA-30 · Lagrangeville, NYNTSB NYC80FHJ20Accident · No injuriesClosedCessna 182 · Westhampton, NYNTSB NYC80FA064Accident · 1 fatalClosedCessna 305A · Farmingdale, NYNTSB NYC80DFA22Accident · Serious injuriesClosedCessna 172 · Saranac Inn, NYNTSB NYC80FHM25Accident · No injuriesClosedCessna 150H · Montgomery, NYNTSB NYC80FHJ19Accident · No injuriesClosedN American SNJ · Farmingdale, NYNTSB NYC80FA061Accident · 1 fatalClosedSchweizer SGS126 · Wurtsboro, NYNTSB NYC80DFA10Accident · No injuriesClosedSchreder 1 · Grahamsville, NY