NTSB investigations, 1973, 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\") = 1973
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") = 1973 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 NYC74DFJ25Accident · Minor injuriesClosedBeech E18S · Syracuse, NYNTSB NYC74AN057Accident · Serious injuriesClosedCessna 411 · Endicott, NYNTSB NYC74IN055Incident · 1 fatalClosedBoeing 727 · Syracuse, NYNTSB NYC74FHJ17Accident · Serious injuriesClosedHiller Acft FH1100 · Bethpage, NYNTSB NYC74AN056Accident · 2 fatalClosedBeech 95-B55 · Colonie, NYNTSB NYC74FHJ18Accident · No injuriesClosedLear Jet 25 · White Plains, NYNTSB NYC74AN053Accident · Serious injuriesClosedStinson 108-1 · Amityville, NYNTSB NYC73FHJ12Accident · No injuriesClosedAero Comdr 680W · White Plains, NYNTSB NYC74DFJ19Accident · No injuriesClosedPiper PA-12 · Skaneateles, NYNTSB NYC74FHJ16Accident · No injuriesClosedBeech V35B · White Plains, NYNTSB NYC74FFA17Accident · 1 fatalClosedCessna 140A · Scotia, NYNTSB NYC74FFJ18Accident · Minor injuriesClosedHiller Acft UH-12B · Dansville, NYNTSB NYC74AN041Accident · 3 fatalClosedCessna 182P · Dix Hills, NYNTSB NYC74AN040Accident · 3 fatalClosedPiper PA-28 · Farmingdale, NYNTSB NYC74DFJ17Accident · No injuriesClosedCessna 172 · Grand Island, NYNTSB NYC74FFJ15Accident · No injuriesClosedPiper PA-23 · Rochester, NYNTSB NYC74FFJ16Accident · No injuriesClosedLuscombe 8A · Leroy, NYNTSB NYC74FFJ14Accident · Minor injuriesClosedCessna 150H · Warsaw, NYNTSB NYC74FFA16Accident · No injuriesClosedCessna 172I · Alexandria Bay, NYNTSB NYC74DHJ14Accident · No injuriesClosedAeronca 7AC · Deer Park, NYNTSB NYC74DFA14Accident · No injuriesClosedPiper PA-28 · Glens Falls, NYNTSB NYC74DFJ12Accident · Minor injuriesClosedBell 47J-2 · Niagara Falls, NYNTSB NYC74FFA13Accident · No injuriesClosedCessna 172L · Bloomingburg, NYNTSB NYC74FFJ08Accident · No injuriesClosedPiper PA-28 · Owego, NYNTSB NYC74FFJ13Accident · No injuriesClosedCessna 180 · Franklinville, NYNTSB NYC74FFJ11Accident · Minor injuriesClosedSIAI Marche 205-22 · Niagara Falls, NYNTSB NYC74DMM08Accident · No injuriesClosedCessna 150 · Spring Valley, NYNTSB NYC74AN028Accident · No injuriesClosedCessna 172 · Ronkonkoma, NYNTSB NYC74IN027Incident · No injuriesClosedPiper PA-23 · White Plains, NYNTSB NYC74IN024Incident · No injuriesClosedBoeing 747 · Jamaica, NYNTSB NYC74FHJ12Accident · Minor injuriesClosedBensen B8-M · East Moriches, NYNTSB NYC74FFA11Accident · No injuriesClosedBeech V35A · Oriskany, NYNTSB NYC74FFJ10Accident · No injuriesClosedPiper PA-28R · Hornell, NYNTSB NYC74FFA10Accident · No injuriesClosedStinson 108 · Albany, NYNTSB NYC74DHJ15Accident · No injuriesClosedCessna 150 · Deerpark, NYNTSB NYC74DHJ13Incident · No injuriesClosedPiper PA-32 · Farmingdale, NYNTSB NYC74FFJ09Accident · Minor injuriesClosedBellanca 14-19 · Hammondsport, NYNTSB NYC74DFA09Accident · No injuriesClosedPiper PA-32 · Hudson, NYNTSB NYC74DFA08Accident · No injuriesClosedAmer Avco AA-5 · Mt Upton, NYNTSB NYC74FFJ07Accident · Minor injuriesClosedPiper PA-28 · Honeoye Falls, NYNTSB NYC74DFA07Accident · No injuriesClosedCessna 172 · Cobleskill, NYNTSB NYC74DHM05Accident · No injuriesClosedPiper PA-28 · Spring Valley, NYNTSB NYC74DHM04Accident · No injuriesClosedCessna 150 · Bloomingburg, NYNTSB NYC74DFA06Accident · No injuriesClosedPiper PA-28 · Cobleskill, NYNTSB NYC74DHJ10Accident · No injuriesClosedCessna 182E · Riverhead, NYNTSB NYC74DHJ11Accident · No injuriesClosedPiper PA-28 · Amityville, NYNTSB NYC74DFJ06Accident · 1 fatalClosedJeanies Teenie · Homer, NYNTSB NYC74FFA05Accident · No injuriesClosedPiper PA-28 · Poestenkill, NYNTSB NYC74IN013Incident · No injuriesClosedBoeing 727 · Jamaica, NYNTSB NYC74DFJ04Accident · No injuriesClosedCessna 172 · Richland, NY