NTSB investigations, 1967, 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\") = 1967
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") = 1967 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 NYC68D0375Accident · No injuriesClosedStinson 108-3 · Berlin, NJNTSB NYC68D0326Accident · Minor injuriesClosedPiper PA-23 · Sea Side Heght, NJNTSB NYC68A0075Accident · No injuriesClosedBeech D18S · Newark, NJNTSB NYC68D0298Accident · No injuriesClosedCessna 337 · Rio Grande, NJNTSB NYC68D0289Accident · No injuriesClosedRyan ST-3KR · Berlin, NJNTSB NYC68F0292Accident · No injuriesClosedCessna 310 · Carlstadt, NJNTSB NYC68A0073Accident · 2 fatalClosedPiper PA-28 · Lakewood, NJNTSB NYC68D0297Accident · No injuriesClosedPiper PA-23 · Ewing, NJNTSB NYC68A0072Accident · Minor injuriesClosedBell 47G · Newark Apt Fac, NJNTSB NYC68F0274Accident · Serious injuriesClosedCessna 150E · Morganville, NJNTSB NYC68F0268Accident · Serious injuriesClosedCessna 140 · Wayne, NJNTSB NYC68F0270Accident · No injuriesClosedBeech V35 · Teterboro, NJNTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJNTSB NYC68D0242Accident · No injuriesClosedPiper PA-28 · Princeton, NJNTSB NYC68D0234Accident · No injuriesClosedPiper PA-28 · Red Bank, NJNTSB NYC68D0273Accident · No injuriesClosedPiper PA-22 · Little Ferry, NJNTSB NYC68F0251Accident · No injuriesClosedBeech A23 · Medford, NJNTSB NYC68F0243Accident · No injuriesClosedCessna 182 · Moorestown, NJNTSB NYC68D0263Accident · Minor injuriesClosedCessna 150 · Toms River, NJNTSB NYC68A0063Accident · No injuriesClosedMooney M20F · Teterboro, NJNTSB NYC68A0062Accident · 2 fatalClosedCessna 172 · So.Hackensack, NJNTSB DIA68F0103Accident · Minor injuriesClosedPiper PA-28 · Laurel, NJNTSB NYC68F0239Accident · Serious injuriesClosedNavion A · Carlstadt, NJNTSB NYC68F0237Accident · No injuriesClosedPiper PA-22 · Salem, NJNTSB NYC68D0285Accident · No injuriesClosedAeronca 7AC · Millville, NJNTSB NYC68F0233Accident · No injuriesClosedCessna 150 · Totowa, NJNTSB NYC68F0215Accident · No injuriesClosedCessna 182 · Hanover, NJNTSB NYC68A0056Accident · No injuriesClosedBeech E18S · Newark, NJNTSB NYC68F0212Accident · Serious injuriesClosedPiper PA-20 · Belford, NJNTSB NYC68D0179Accident · No injuriesClosedPiper PA-24 · Hackettstown, NJNTSB NYC68F0202Accident · No injuriesClosedBeech D95A · Teterboro, NJNTSB NYC68D0223Accident · Serious injuriesClosedCessna 140A · Atlantic City, NJNTSB NYC68F0196Accident · Serious injuriesClosedBellanca 14-13 · So.Plainfield, NJNTSB NYC68D0204Accident · No injuriesClosedCessna 172H · Mays Landing, NJNTSB NYC68A0048Accident · 1 fatalClosedCessna 150 · Vincentown, NJNTSB NYC68D0194Accident · Minor injuriesClosedPiper PA-12 · East Hanover, NJNTSB NYC68D0205Accident · No injuriesClosedCessna 150 · Moorestown, NJNTSB NYC68F0140Accident · Minor injuriesClosedAeronca 7BCM · Princeton, NJNTSB NYC68F0171Accident · No injuriesClosedCessna 310 · Teterboro, NJNTSB NYC68D0114Accident · No injuriesClosedCessna 172 · Andover, NJNTSB NYC68F0151Accident · No injuriesClosedMooney M20C · Neptune, NJNTSB NYC68F0141Accident · No injuriesClosedPiper PA-22 · Red Bank, NJNTSB NYC68D0128Accident · No injuriesClosedPiper PA-28 · Columbia, NJNTSB NYC68F0138Accident · No injuriesClosedPiper PA-22 · Vincentown, NJNTSB NYC68F0144Accident · No injuriesClosedAeronca 65-C · Vincentown, NJNTSB NYC68I0028Incident · No injuriesClosedLockheed L-1049 · Newark, NJNTSB NYC68F0100Accident · No injuriesClosedPiper PA-28 · Red Bank, NJNTSB NYC68F0112Accident · Minor injuriesClosedTemco D-16A · Wayne, NJNTSB NYC68F0092Accident · No injuriesClosedBoeing A75 · Bridgeton, NJNTSB NYC68F0104Accident · 2 fatalClosedPiper PA-30 · Masonville, NJ