NTSB investigations, 1971, 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\") = 1971
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") = 1971 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 NYC72FHM24Accident · Minor injuriesClosedCessna 150 · West Caldwell, NJNTSB NYC72FHD24Accident · Minor injuriesClosedChampion 7FC · Moorestown, NJNTSB NYC72AN082Accident · Serious injuriesClosedPiper PA-23 · Haledon, NJNTSB NYC72FHM23Accident · Serious injuriesClosedAero Comdr 500S · Morristown, NJNTSB NYC72FHM22Accident · No injuriesClosedCessna 150 · Linden, NJNTSB NYC72FHD23Accident · No injuriesClosedCessna 177 · Sewell, NJNTSB NYC72FHD22Accident · Minor injuriesClosedMooney M20F · Vineland, NJNTSB NYC72FHM17Accident · No injuriesClosedPiper PA-28 · Belmar, NJNTSB NYC72FHD21Accident · No injuriesClosedCessna 182J · Williamstown, NJNTSB NYC72DHM15Accident · No injuriesClosedCessna 150 · Teterboro, NJNTSB NYC72IN062Incident · No injuriesClosedDehavilland DHC-6 · Atlantic City, NJNTSB NYC72FHA22Accident · Minor injuriesClosedPiper PA-22 · Branchville, NJNTSB NYC72DHD20Accident · No injuriesClosedPiper PA-28 · Millville, NJNTSB NYC72FHM14Accident · No injuriesClosedCessna 150H · East Hanover, NJNTSB NYC72FHA21Accident · No injuriesClosedBell 206A · Somerville, NJNTSB NYC72DHD18Accident · No injuriesClosedPiper PA-28R · Atlantic City, NJNTSB NYC72FHD17Accident · No injuriesClosedBeech V35A · Atlantic City, NJNTSB NYC72DHA19Accident · No injuriesClosedCessna 150 · Manville, NJNTSB NYC72FHM12Accident · Serious injuriesClosedCessna 172E · Paramus, NJNTSB NYC72FHM11Accident · No injuriesClosedPiper PA-22 · Marlboro, NJNTSB NYC72FHD12Accident · Serious injuriesClosedBeech A23 · Atlantic City, NJNTSB NYC72DHD16Accident · No injuriesClosedLuscombe 8A · Cross Keys, NJNTSB NYC72AN036Accident · 2 fatalClosedPiper PA-28 · Princeton, NJNTSB NYC72AN035Accident · 1 fatalClosedPiper PA-24 · Quakertown, NJNTSB NYC72FHM09Accident · No injuriesClosedBeech A23A · Linden, NJNTSB NYC72FHM08Accident · Serious injuriesClosedBensen B8M · New Shrewsbury, NJNTSB NYC72FHD10Accident · Minor injuriesClosedPiper PA-28 · Berlin, NJNTSB NYC72DHD06Accident · No injuriesClosedCessna 150 · Wildwood, NJNTSB NYC72FHM06Accident · 1 fatalClosedBell 47G2A · Monmouth, NJNTSB NYC72DHA13Accident · No injuriesClosedPiper PA-24 · Pittstown, NJNTSB NYC72AN031Accident · 2 fatalClosedBeech F33A · Andover, NJNTSB NYC72FHD14Accident · No injuriesClosedErco 415-C · Pemberton, NJNTSB NYC72FHD08Accident · No injuriesClosedNaval Fcty N3N-3 · Atlantic City, NJNTSB NYC72FHM03Accident · No injuriesClosedBeech 23 · Morganville, NJNTSB NYC72DHD05Accident · No injuriesClosedPiper PA-28 · Marlton, NJNTSB NYC72AN013Accident · 2 fatalClosedPiper PA-28 · Wanaque, NJNTSB NYC72DHD03Accident · No injuriesClosedPiper PA-24 · Rio Grande, NJNTSB NYC72DHD04Accident · No injuriesClosedPiper PA-28 · Ocean City, NJNTSB NYC72FHA04Accident · Serious injuriesClosedPiper PA-23 · Sussex, NJNTSB NYC72FHD02Accident · No injuriesClosedCessna 172 · Atlantic City, NJNTSB NYC72FHD01Accident · Minor injuriesClosedLuscombe 8A · Marlton, NJNTSB NYC71FHM34Accident · Minor injuriesClosedPiper PA-22 · So Orange, NJNTSB NYC71DHD58Accident · Minor injuriesClosedPiper J-3 · Mickleton, NJNTSB NYC71FHM31Accident · Minor injuriesClosedCessna 172 · Fairfield, NJNTSB NYC71FHA51Accident · 1 fatalClosedBell 47G2 · Branchville, NJNTSB NYC72AN091Accident · 1 fatalClosedN.American SNJ-4 · Cape May, NJNTSB NYC71AN119Accident · 2 fatalClosedN.American SNJ-5 · North Cape May, NJNTSB NYC71AN118Accident · 1 fatalClosedN.American SNJ-5 · North Cape May, NJNTSB NYC71FHD52Accident · Serious injuriesClosedCessna 150 · Evesham, NJNTSB NYC71FHD54Accident · Minor injuriesClosedCooney R-3 · Woodbine, NJ