NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 NYC67F0443Accident · No injuriesClosedCessna 320D · Morristown, NJNTSB NYC67D0494Accident · No injuriesClosedCessna 172 · Moorestown, NJNTSB NYC67D0474Accident · No injuriesClosedCessna 150 · Morristown, NJNTSB NYC67D0484Accident · No injuriesClosedPiper PA-28 · Hanover, NJNTSB NYC67D0435Accident · No injuriesClosedCessna 120 · Jobstown, NJNTSB NYC67D0406Accident · No injuriesClosedPiper PA-28 · Medford, NJNTSB NYC67D0534Accident · No injuriesClosedStinson V-77 · Medford, NJNTSB NYC67D0447Accident · No injuriesClosedCessna 150 · West Caldwell, NJNTSB NYC67F0449Accident · No injuriesClosedBeech D18S · Williamstown, NJNTSB NYC67F0408Accident · No injuriesClosedPiper PA-28 · Red Bank, NJNTSB NYC67F0389Accident · No injuriesClosedCessna 310L · Morristown, NJNTSB NYC67I0084Incident · No injuriesClosedFairchild FH-227 · Newark, NJNTSB NYC67D0399Accident · No injuriesClosedCessna 150 · Lincoln Park, NJNTSB NYC67D0405Accident · No injuriesClosedPiper PA-30 · Bridgeport, NJNTSB NYC67D0383Accident · No injuriesClosedPiper PA28 · Bridgeton, NJNTSB NYC67F0385Accident · No injuriesClosedNavion A · Denville, NJNTSB NYC67F0382Accident · No injuriesClosedStinson 108-3 · Piscataway, NJNTSB NYC67D0371Accident · No injuriesClosedChampion 7EC · Lakewood, NJNTSB NYC67A0071Accident · No injuriesClosedPiper PA-23 · Farmingdale, NJNTSB NYC67A0070Accident · No injuriesClosedPiper PA-23 · Trenton, NJNTSB NYC67D0330Accident · No injuriesClosedBeech A23 · Linden, NJNTSB NYC67F0308Accident · No injuriesClosedHelio H-391B · Manville, NJNTSB NYC67F0337Accident · Minor injuriesClosedPiper PA-28 · So.Hackensack, NJNTSB NYC67F0316Accident · No injuriesClosedCessna 210E · So-Hackensack, NJNTSB NYC67D0327Accident · No injuriesClosedLuscombe 8E · Middletown, NJNTSB NYC67D0312Accident · No injuriesClosedCessna 150 · Franklin, NJNTSB NYC67D0339Accident · No injuriesClosedStinson 108-1 · Linden, NJNTSB NYC67D0338Accident · No injuriesClosedAeronca 7AC · Asbury Park, NJNTSB NYC67D0322Accident · No injuriesClosedCessna 182 · Bridgeport, NJNTSB NYC67F0297Accident · No injuriesClosedPiper PA-28 · Ocean City, NJNTSB NYC67F0287Accident · No injuriesClosedCessna 310 · Morristown, NJNTSB NYC67F0289Accident · No injuriesClosedLuscombe 8B · West Milford, NJNTSB NYC67D0290Accident · Minor injuriesClosedCessna 150 · Long Valley, NJNTSB NYC67F0275Accident · Minor injuriesClosedBoeing A75N1 · Pennington, NJNTSB NYC67F0251Accident · Minor injuriesClosedAeronca 7GCA · Warwick, NJNTSB NYC67F0266Accident · No injuriesClosedBeech 95-55 · Newark, NJNTSB NYC67D0279Accident · No injuriesClosedStinson 108-2 · So.Plainfield, NJNTSB NYC67A0047Accident · No injuriesClosedLockheed 14N · Medford, NJNTSB NYC67F0274Accident · Serious injuriesClosedStearman B75 · Seabrook, NJNTSB NYC67D0284Accident · No injuriesClosedCessna 310K · Teterboro, NJNTSB NYC67F0364Accident · No injuriesClosedPiper PA-23 · Medford, NJNTSB NYC67F0261Accident · No injuriesClosedBeech A23 · Medford, NJNTSB NYC67D0198Accident · No injuriesClosedPiper PA-23 · Pittstown, NJNTSB NYC67D0314Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJNTSB NYC67D0257Accident · No injuriesClosedPiper PA-22 · Sandy Hook, NJNTSB NYC67F0267Accident · Minor injuriesClosedPiper PA-28 · S. Plainfield, NJNTSB NYC67D0208Accident · No injuriesClosedPiper PA-24 · Millville, NJNTSB NYC67D0209Accident · No injuriesClosedPiper PA-12 · Atlantic City, NJNTSB NYC67F0205Accident · No injuriesClosedPiper PA-28 · Medford, NJNTSB NYC67D0219Accident · No injuriesClosedAero Cmdr 1121 · Morristown, NJ