NTSB investigations, 1969, NJ
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
| 1963 | 4 |
|---|---|
| 1964 | 107 |
| 1965 | 112 |
| 1966 | 129 |
| 1967 | 134 |
| 1968 | 60 |
| 1969 | 76 |
| 1970 | 85 |
| 1971 | 83 |
| 1972 | 67 |
| 1973 | 59 |
| 1974 | 71 |
| 1975 | 57 |
| 1976 | 51 |
| 1977 | 43 |
| 1978 | 55 |
| 1979 | 57 |
| 1980 | 54 |
| 1981 | 57 |
| 1982 | 44 |
| 1983 | 45 |
| 1984 | 49 |
| 1985 | 47 |
| 1986 | 38 |
| 1987 | 43 |
| 1988 | 44 |
| 1989 | 33 |
| 1990 | 26 |
| 1991 | 29 |
| 1992 | 28 |
| 1993 | 45 |
| 1994 | 27 |
| 1995 | 25 |
| 1996 | 33 |
| 1997 | 36 |
| 1998 | 24 |
| 1999 | 35 |
| 2000 | 38 |
| 2001 | 21 |
| 2002 | 37 |
| 2003 | 19 |
| 2004 | 21 |
| 2005 | 44 |
| 2006 | 32 |
| 2007 | 23 |
| 2008 | 28 |
| 2009 | 25 |
| 2010 | 14 |
| 2011 | 19 |
| 2012 | 17 |
| 2013 | 13 |
| 2014 | 20 |
| 2015 | 14 |
| 2016 | 21 |
| 2017 | 21 |
| 2018 | 14 |
| 2019 | 14 |
| 2020 | 6 |
| 2021 | 17 |
| 2022 | 14 |
| 2023 | 14 |
| 2024 | 11 |
| 2025 | 11 |
| 2026 | 10 |
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\") = 1969
AND c.\"eventStateOrRegion\" = 'NJ' 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") = 1969 AND c."eventStateOrRegion" = 'NJ' 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 NYC70F0245Accident · Minor injuriesClosedPiper PA-28 · East Hanover, NJNTSB NYC70D0229Accident · No injuriesClosedCessna 150 · Lakewood, NJNTSB NYC70D0228Accident · No injuriesClosedCessna 120 · Hancocks Brdge, NJNTSB NYC70F0223Accident · No injuriesClosedCessna 172 · Newton, NJNTSB NYC70D0216Accident · No injuriesClosedLuscombe 8A · Moorestown, NJNTSB NYC70A0055Accident · No injuriesClosedDouglas DC-8 · Newark, NJNTSB NYC70A0054Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJNTSB NYC70D0002Accident · No injuriesClosedBrantly B-2 · Millville, NJNTSB NYC70A0051Accident · No injuriesClosedCessna U206 · Pittstown, NJNTSB NYC70F0194Accident · Minor injuriesClosedBellanca 17-30 · Princeton, NJNTSB NYC70D0208Accident · No injuriesClosedCessna 310L · Woodbine, NJNTSB NYC70D0206Accident · No injuriesClosedPiper PA-28 · Pittstown, NJNTSB NYC70F0250Accident · Serious injuriesClosedSchemp SH-1 · Hanover, NJNTSB NYC70F0189Accident · Minor injuriesClosedPiper PA-28 · Teterboro, NJNTSB NYC70F0167Accident · No injuriesClosedCessna 421 · Newark, NJNTSB NYC70D0162Accident · Minor injuriesClosedTrager T-3 · Millville, NJNTSB NYC70F0161Accident · 1 fatalClosedCessna 337C · Toms River, NJNTSB NYC70F0139Accident · No injuriesClosedCessna 310 · Lakewood, NJNTSB NYC70D0149Accident · No injuriesClosedChampion 7AC · Salem, NJNTSB NYC70F0091Accident · Minor injuriesClosedLuscombe 8E · Basking Ridge, NJNTSB NYC70I0025Incident · No injuriesClosedDouglas DC-9 · Atlantic City, NJNTSB NYC70D0077Accident · No injuriesClosedAeronca 7FC · Basking Ridge, NJNTSB NYC70D0118Accident · No injuriesClosedAmerican AA-1 · Vincentown, NJNTSB NYC70A0022Accident · No injuriesClosedPiper PA-28R · Ocean City, NJNTSB NYC70D0113Accident · No injuriesClosedTaylorcraft L-2 · Tuckahoe, NJNTSB NYC70D0104Accident · No injuriesClosedPiper PA-28 · Vincentown, NJNTSB NYC70D0075Accident · No injuriesClosedCessna 310 · Atco, NJNTSB NYC70F0117Accident · No injuriesClosedCessna 310D · Atlantic City, NJNTSB DCA70A0002Accident · 5 fatalClosedBoeing 707 · Pomona, NJNTSB NYC70D0100Accident · No injuriesClosedCessna 150 · Pennington, NJNTSB NYC70D0034Accident · No injuriesClosedCessna 182 · Manville, NJNTSB NYC70A0007Accident · 2 fatalClosedPiper PA-22 · Bridgeport, NJNTSB NYC70F0043Accident · Minor injuriesClosedPiper PA-28 · Pittstown, NJNTSB NYC70F0035Accident · Minor injuriesClosedLuscombe 8A · Washington, NJNTSB NYC70D0024Accident · No injuriesClosedPiper PA-22 · Pluckemin, NJNTSB NYC70A0005Accident · 2 fatalClosedPiper PA-18 · Sewell, NJNTSB NYC70A0001Accident · 1 fatalClosedTaylorcraft BF12 · Phillipsburg, NJNTSB NYC69A0114Accident · 2 fatalClosedPiper PA-30 · Rancocas, NJNTSB NYC70D0014Accident · No injuriesClosedCessna 150 · Williamstown, NJNTSB NYC69A0113Accident · No injuriesClosedBeech D18S · Morristown, NJNTSB NYC69A0112Accident · 2 fatalClosedCessna 310N · Blairstown, NJNTSB NYC70D0029Accident · No injuriesClosedSchleicher K8B · Blairstown, NJNTSB NYC69F0474Accident · No injuriesClosedBellanca 17-30 · Morristown, NJNTSB NYC70F0023Accident · No injuriesClosedPiper PA-28R · Clifton, NJNTSB NYC70F0057Accident · Serious injuriesClosedLuscombe 8A · Cross Keys, NJNTSB NYC70D0005Accident · Minor injuriesClosedStinson 108-2 · Red Bank, NJNTSB NYC69F0455Accident · No injuriesClosedPiper PA-23 · Andover, NJNTSB NYC70D0018Accident · No injuriesClosedGrumman G-164A · Chatsworth, NJNTSB NYC70F0086Accident · Minor injuriesClosedAeronca 7AC · Moorestown, NJNTSB NYC69F0446Accident · No injuriesClosedPiper PA-18A · Mays Landing, NJ