NTSB investigations, 1966, 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.
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\") = 1966
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") = 1966 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 NYC67D0453Accident · No injuriesClosedCessna 150 · White Plains, NYNTSB NYC67F0434Accident · No injuriesClosedBeech V35 · Wallkill, NYNTSB NYC67D0432Accident · No injuriesClosedCessna 150 · White Plains, NYNTSB NYC67D0442Accident · No injuriesClosedPiper PA-22 · Wappingers Fls., NYNTSB NYC67F0433Accident · No injuriesClosedMooney M20A · Port Jefferson, NYNTSB NYC67A0090Accident · 2 fatalClosedPiper PA-23 · Copenhagen, NYNTSB NYC67F0388Accident · No injuriesClosedBeech A35 · Mcdonough, NYNTSB NYC67A0086Accident · No injuriesClosedBrantly B-2 · Belfast, NYNTSB NYC67D0395Accident · No injuriesClosedCessna 180 · Glens Falls, NYNTSB NYC67F0396Accident · No injuriesClosedRearwin 185 · Yorktown Hts, NYNTSB NYC67D0401Accident · Serious injuriesClosedPiper PA-18 · Richland, NYNTSB NYC67D0394Accident · No injuriesClosedCessna 150 · Amagansett, NYNTSB NYC67A0080Accident · No injuriesClosedBeech K35 · Flushing, NYNTSB NYC67F0370Accident · Serious injuriesClosedBeech M35 · Saranac Lake, NYNTSB NYC67A0075Accident · 3 fatalClosedCessna 205A · East Nassau, NYNTSB NYC67A0073Accident · No injuriesClosedBoeing B-727 · Flushing, NYNTSB NYC67D0381Accident · No injuriesClosedPiper PA-23 · Jamaica, NYNTSB NYC67F0384Accident · No injuriesClosedBeech 35-B33 · Ronkonkoma, NYNTSB NYC67F0343Accident · No injuriesClosedHelio H-391B · Fisher, NYNTSB NYC67D0361Accident · No injuriesClosedPiper PA-28 · Ithaca, NYNTSB NYC67F0359Accident · Serious injuriesClosedAeronca 0-58B · Cambria, NYNTSB NYC67D0288Accident · No injuriesClosedCessna 150 · Croton-Hudson, NYNTSB NYC67D0319Accident · Minor injuriesClosedSchweizer 2-22C · Elmira, NYNTSB NYC67F0320Accident · No injuriesClosedBeech 95-55 · Gardenville, NYNTSB DCA67I0004Incident · No injuriesClosedCurtiss-Wrt C-46 · Buffalo, NYNTSB NYC67D0335Accident · No injuriesClosedCessna 172 · Flushing, NYNTSB NYC67D0328Accident · Minor injuriesClosedSchweizer SGA126 · Waverly, NYNTSB NYC67F0296Accident · Serious injuriesClosedPiper PA-22 · Williamson, NYNTSB NYC67F0292Accident · Minor injuriesClosedPiper PA-12 · Pittsford, NYNTSB NYC67D0295Accident · No injuriesClosedCessna 140 · Lindenhurst, NYNTSB NYC67D0310Accident · No injuriesClosedCessna 310H · Purchase, NYNTSB NYC67F0283Accident · No injuriesClosedDowner 14-19 · Painted Post, NYNTSB NYC67D0286Accident · No injuriesClosedPiper PA-28 · Spring Valley, NYNTSB NYC67A0051Accident · No injuriesClosedHughes 269A · Schuylerville, NYNTSB NYC67F0277Accident · No injuriesClosedCessna A188 · New Platz, NYNTSB NYC67F0268Accident · No injuriesClosedCessna 180A · Stormville, NYNTSB NYC67D0265Accident · No injuriesClosedStinson 108 · Red Hook, NYNTSB NYC67A0055Accident · No injuriesClosedPiper PA-28 · Orient Point, NYNTSB NYC67D0254Accident · No injuriesClosedStinson 108 · Richland, NYNTSB NYC67A0046Accident · No injuriesClosedLockheed 188 · Montezuma, NYNTSB NYC67F0270Accident · Minor injuriesClosedNavion A · Phillipstown, NYNTSB NYC67A0045Accident · 1 fatalClosedPiper PA-28 · Flushing, NYNTSB NYC67F0309Accident · No injuriesClosedCessna 310K · Flushing, NYNTSB NYC67F0248Accident · No injuriesClosedPiper PA-30 · Penn Yan, NYNTSB NYC67D0238Accident · No injuriesClosedLuscombe 8A · Spring Valley, NYNTSB NYC67I0043Incident · No injuriesClosedBoeing 727 · New York, NYNTSB NYC67F0197Accident · No injuriesClosedCessna 182J · Coxsackie, NYNTSB NYC67D0285Accident · No injuriesClosedCessna 140 · Spring Valley, NYNTSB NYC67I0039Incident · No injuriesClosedBoeing 727 · Buffalo, NYNTSB NYC67D0231Accident · No injuriesClosedCessna 150 · Monticello, NY