NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 NYC66F0412Accident · Serious injuriesClosedCessna 150 · Medford, NJNTSB NYC66F0421Accident · Minor injuriesClosedPiper PA-22 · Neptune, NJNTSB NYC66F0413Accident · Minor injuriesClosedAeronca 7AC · Fort Lee, NJNTSB NYC66D0490Accident · No injuriesClosedPiper PA-12 · Morganville, NJNTSB NYC66F0417Accident · No injuriesClosedCessna 320 · Teterboro, NJNTSB NYC66D0397Accident · No injuriesClosedBeechcraft A-23 · Princeton, NJNTSB MKC66F0313Accident · No injuriesClosedMooney M20E · Bloomfield, NJNTSB NYC66F0380Accident · No injuriesClosedErcoupe 415-CD · So Plainfield, NJNTSB NYC66D0379Accident · No injuriesClosedCessna 195B · Salem, NJNTSB NYC66D0372Accident · No injuriesClosedBeechcraft A-23 · Robinsville, NJNTSB NYC66D0480Accident · No injuriesClosedPiper PA-28 · Pitman, NJNTSB NYC66D0374Accident · No injuriesClosedPiper PA-28 · Rancocas, NJNTSB NYC66A0058Accident · Serious injuriesClosedSikorsky S-52-3 · Carlstadt, NJNTSB NYC66A0055Accident · 1 fatalClosedCessna 150 · Fairfield, NJNTSB NYC66F0382Accident · No injuriesClosedHelio 391B · Morristown, NJNTSB NYC66F0354Accident · Serious injuriesClosedLuscombe 8A · Sparta, NJNTSB NYC66D0366Accident · Minor injuriesClosedPiper PA-22 · Salem, NJNTSB NYC66F0381Accident · No injuriesClosedBeechcraft F35 · Fairchild, NJNTSB NYC66F0351Accident · No injuriesClosedPiper PA-23 · Princeton, NJNTSB NYC66F0361Accident · Serious injuriesClosedPiper PA-23 · Mt.Holly, NJNTSB NYC66F0317Accident · No injuriesClosedCessna 150 · Paramus, NJNTSB NYC66D0367Accident · No injuriesClosedPiper PA-22 · Vineland, NJNTSB NYC66F0302Accident · No injuriesClosedWaco UPF-7 · Manville, NJNTSB NYC66F0291Accident · No injuriesClosedHoward DGA-15 · Manville, NJNTSB NYC66D0295Accident · No injuriesClosedCessna 172 · Moorestown, NJNTSB NYC66F0285Accident · No injuriesClosedCessna 180 · Medford, NJNTSB NYC66F0311Accident · No injuriesClosedCessna 172 · Farmingdale, NJNTSB NYC66F0325Accident · No injuriesClosedPiper PA-28 · Teterboro, NJNTSB NYC66F0282Accident · No injuriesClosedCessna 150D · Farmingdale, NJNTSB NYC66F0260Accident · No injuriesClosedCessna 210E · Bedminster, NJNTSB NYC66F0262Accident · No injuriesClosedCessna 320 · So Hackensack, NJNTSB NYC66I0042Incident · No injuriesClosedBoeing B-727 · Newark, NJNTSB NYC66F0276Accident · No injuriesClosedAeronca 57D · Carlstadt, NJNTSB NYC66D0310Accident · No injuriesClosedCessna 150 · So Plainfield, NJNTSB NYC66F0240Accident · No injuriesClosedBeechcraft S-35 · Teterboro, NJNTSB NYC66D0209Accident · No injuriesClosedPiper PA-22 · Andover, NJNTSB NYC66F0192Accident · No injuriesClosedBeechcraft 35 · Somerville, NJNTSB NYC66A0025Accident · 3 fatalClosedBeechcraft 95-55 · Salem, NJNTSB NYC66F0203Accident · No injuriesClosedPiper PA-22 · Vincentown, NJNTSB NYC66F0186Accident · No injuriesClosedPiper PA-24 · Medford, NJNTSB NYC66F0152Accident · No injuriesClosedBeechcraft E-18S · Red Bank, NJNTSB NYC66D0138Accident · No injuriesClosedSchweizer SGU-2 · Flatbrookville, NJNTSB NYC66F0156Accident · No injuriesClosedCessna 170B · Middletown, NJNTSB NYC66D0131Accident · No injuriesClosedPiper PA-28 · Mt Holly, NJNTSB NYC66F0086Accident · No injuriesClosedCessna 172 · Basking Ridge, NJNTSB NYC66D0171Accident · No injuriesClosedCessna 182 · Frenchtown, NJNTSB NYC66D0077Accident · No injuriesClosedCessna 150 · Sussex, NJNTSB NYC66F0105Accident · No injuriesClosedPiper PA-24 · Pluckemin, NJNTSB NYC66D0134Accident · No injuriesClosedCessna 172 · Atlantic City, NJNTSB NYC66F0113Accident · No injuriesClosedPiper J-3 · New Market, NJ