NTSB investigations, 1981, NY
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1981
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") = 1981 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 NYC82FA014Accident · 1 fatalClosedPiper PA-23 · Owego, NYNTSB NYC82DFJ10Accident · No injuriesClosedBeech 95-B55 · Fulton, NYNTSB NYC82FFA02Accident · No injuriesClosedCessna 172 · Edinburg, NYNTSB NYC82FHM04Accident · No injuriesClosedCessna 150 · Newburgh, NYNTSB NYC82FFJ09Accident · Minor injuriesClosedPiper PA-28R · Syracuse, NYNTSB NYC82FHM02Accident · No injuriesClosedCessna 152 · Mahopac, NYNTSB NYC82FHJ02Accident · No injuriesClosedCessna 152 · Hudson River, NYNTSB NYC82FA010Accident · Minor injuriesClosedBell 206B · New York City, NYNTSB NYC82FFJ08Accident · No injuriesClosedCessna 180K · Jamestown, NYNTSB NYC82FFJ06Accident · No injuriesClosedPiper PA-28 · Rochester, NYNTSB NYC82FA008Accident · 1 fatalClosedPiper PA-28 · North Hudson, NYNTSB NYC82DFJ04Accident · No injuriesClosedSchweizer 1-26 · Lockport, NYNTSB NYC82FHJ03Accident · No injuriesClosedPiper PA-30 · East Moriches, NYNTSB NYC82FFJ02Accident · Serious injuriesClosedCessna 152 · Lockport, NYNTSB NYC82DFJ07Accident · No injuriesClosedSpezio DAL-1 · Ceres, NYNTSB NYC82FA006Accident · 3 fatalClosedPiper PA-28 · Farmingdale, NYNTSB NYC82FA005Accident · Minor injuriesClosedBeech 36 · Marlborough, NYNTSB NYC82FA003Accident · Serious injuriesClosedCessna 152 · Fishers Island, NYNTSB NYC82FHM01Accident · Minor injuriesClosedCessna 152 · Blooming Grove, NYNTSB NYC82DFJ01Accident · No injuriesClosedPiper PA-32R · Rochester, NYNTSB NYC82FHJ01Accident · No injuriesClosedCessna 172 · Westhampton, NYNTSB NYC82FFA01Accident · Serious injuriesClosedPiper PA-28 · Milton, NYNTSB NYC82FA002Accident · 1 fatalClosedCessna 150H · Worth, NYNTSB NYC81FHJ19Accident · No injuriesClosedBeech A36 · White Plains, NYNTSB NYC81FHJ18Accident · No injuriesClosedCessna 172 · Brookhaven, NYNTSB NYC81FFJ25Accident · Serious injuriesClosedAeronca 7AC · Honeoye Falls, NYNTSB NYC81IA080Incident · No injuriesClosedCessna U206G · New York, NYNTSB NYC81DFJ26Accident · No injuriesClosedGrum Amer AA-5B · Hamburg, NYNTSB NYC81FHJ17Accident · No injuriesClosedBell 47G-2 · Farmingdale, NYNTSB NYC81DFJ24Accident · No injuriesClosedLuscombe 8E · Nunda, NYNTSB NYC81FFA25Accident · Serious injuriesClosedBellanca 7GCBC · Ancramdale, NYNTSB NYC81FHJ16Accident · No injuriesClosedCessna 182E · Mattituck, NYNTSB NYC81FHJ15Accident · Minor injuriesClosedTeal TSC1A2 · Verplanck, NYNTSB NYC81FHJ14Accident · No injuriesClosedCessna 185E · Westhampton B, NYNTSB NYC81FHJ13Accident · Minor injuriesClosedCessna 150 · Shelter Island, NYNTSB NYC81FFJ22Accident · No injuriesClosedSchweizer SG233A · Mayville, NYNTSB NYC81DFA24Accident · Minor injuriesClosedCessna 150M · Hancock, NYNTSB NYC81DA078Accident · No injuriesClosedBeech C24 · Kingston, NYNTSB NYC81FFA23Accident · No injuriesClosedGulf Amer AA-5A · Amsterdam, NYNTSB NYC81FFA21Accident · No injuriesClosedLake LA-4 · Lake George, NYNTSB DCA81IA024Incident · No injuriesClosedBritish Aer Concrd · Jamaica, NYNTSB NYC81FFJ23Accident · No injuriesClosedCessna 337A · Pembroke, NYNTSB NYC81FFJ21Accident · Minor injuriesClosedNeukom S3 · Horseheads, NYNTSB NYC81FFA19Accident · Minor injuriesClosedPiper PA-28 · Delanson, NYNTSB NYC81FFJ20Accident · No injuriesClosedCessna 170 · Great Valley, NYNTSB NYC81FHM11Accident · Serious injuriesClosedBeech H35 · Wappingers Fls, NYNTSB NYC81FHJ12Accident · No injuriesClosedCessna 152 · Ronkonkomoa, NYNTSB NYC81FHJ11Accident · No injuriesClosedMaule M-4 · Farmingdale, NYNTSB NYC81FHJ10Accident · No injuriesClosedPiper PA-32R · Farmingdale, NYNTSB NYC81FFA20Accident · No injuriesClosedChristen Eagle · Duanesburg, NY