NTSB investigations, 1968, NJ
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1968
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") = 1968 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 NYC69I0066Incident · No injuriesClosedDouglas DC-8 · Newark, NJNTSB NYC69F0278Accident · Serious injuriesClosedCessna 411 · Teterboro, NJNTSB NYC69A0061Accident · 1 fatalClosedPiper PA-24 · New Foundland, NJNTSB NYC69D0260Accident · No injuriesClosedLuscombe 8F · Pluckimen, NJNTSB NYC69D0257Accident · No injuriesClosedCessna 150 · Aptistown, NJNTSB NYC69A0051Accident · 2 fatalClosedSwift Globe GC-1B · Willingboro, NJNTSB NYC69D0266Accident · No injuriesClosedBeech 35-C33 · Burlington, NJNTSB NYC69F0210Accident · Serious injuriesClosedCessna 150J · Morristown, NJNTSB NYC69F0203Accident · No injuriesClosedCessna 177 · Newton, NJNTSB NYC69F0237Accident · No injuriesClosedPiper PA-23 · Neptune, NJNTSB NYC69D0225Accident · No injuriesClosedPiper PA-28 · Rio Grande, NJNTSB NYC69F0242Accident · 1 fatalClosedBensen B8M · Mickleton, NJNTSB NYC69F0226Accident · No injuriesClosedMidgt Mstng MM1 · Newfoundland, NJNTSB NYC69A0042Accident · 1 fatalClosedCessna 150 · Clementon, NJNTSB NYC69D0163Accident · No injuriesClosedCessna 210 · Basking Ridge, NJNTSB NYC69F0180Accident · 1 fatalClosedBensen B8M · Bridgeton, NJNTSB NYC69A0027Accident · 2 fatalClosedPiper PA-28 · Manahawkin, NJNTSB NYC69D0139Accident · Minor injuriesClosedAeronca 7AC · Whitehouse, NJNTSB NYC69F0186Accident · No injuriesClosedGlobe GC-1B · Medford, NJNTSB NYC69D0162Accident · No injuriesClosedPiper PA-24 · Atlantic City, NJNTSB NYC69F0132Accident · No injuriesClosedCessna 310 · Pittstown, NJNTSB NYC69F0150Accident · No injuriesClosedCessna 182A · So.Vineland, NJNTSB NYC69D0214Accident · No injuriesClosedAeronca 7DC · Madison, NJNTSB NYC69D0166Accident · No injuriesClosedBeech A23 · Robbinsville, NJNTSB NYC69F0127Accident · No injuriesClosedCessna 150 · Flemington, NJNTSB NYC69D0068Accident · No injuriesClosedPiper PA-28 · Basking Ridge, NJNTSB NYC69F0097Accident · No injuriesClosedAero Comdr 520 · Medford, NJNTSB NYC69D0111Accident · No injuriesClosedBeech 35-B33 · Moorestown, NJNTSB NYC69F0088Accident · Serious injuriesClosedScheibe SF27M · Hopewell Tnshp, NJNTSB NYC69F0048Accident · No injuriesClosedCessna 150F · Medford, NJNTSB NYC69F0093Accident · No injuriesClosedPiper PA-25 · Great Meadows, NJNTSB NYC69F0084Accident · Serious injuriesClosedCessna 177 · Red Bank, NJNTSB NYC69F0050Accident · Serious injuriesClosedCessna 150F · Ringwood, NJNTSB NYC69F0034Accident · Minor injuriesClosedCessna 310H · Totowa, NJNTSB NYC69D0013Accident · Minor injuriesClosedCessna 150F · Lumberton, NJNTSB NYC68A0125Accident · 1 fatalClosedCessna 172 · Berlin, NJNTSB NYC68F0484Accident · Minor injuriesClosedCessna 182 · Medford, NJNTSB NYC68D0501Accident · No injuriesClosedCessna 175 · Sussex, NJNTSB NYC68I0119Incident · No injuriesClosedDouglas DC-9 · Newark, NJNTSB NYC68F0465Accident · No injuriesClosedCessna 150 · Millville, NJNTSB NYC68D0491Accident · No injuriesClosedLuscombe 8A · Seaside, NJNTSB NYC68F0474Accident · No injuriesClosedPiper PA-24 · Medford, NJNTSB NYC68F0485Accident · No injuriesClosedBeech 95-B55 · Atlantic City, NJNTSB NYC68F0495Accident · No injuriesClosedPiper J-4 · Berlin, NJNTSB NYC68D0478Accident · No injuriesClosedCessna 150 · Montville Twp, NJNTSB NYC68F0481Accident · 1 fatalClosedErcoupe 415-C · Williamstown, NJNTSB NYC68A0117Accident · Serious injuriesClosedDouglas DC-8 · Atlantic City, NJNTSB NYC68F0469Accident · No injuriesClosedAlon A2 · Millville, NJNTSB NYC68D0450Accident · No injuriesClosedCessna 177 · Lavallette, NJNTSB NYC68D0451Accident · No injuriesClosedCessna 150 · Medford, NJ