NTSB investigations, 1979, 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\") = 1979
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") = 1979 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 NYC80FHM06Accident · Serious injuriesClosedCessna 150 · Teaneck, NJNTSB NYC80DHD08Accident · No injuriesClosedCessna 152 · Toms River, NJNTSB NYC80FHM04Accident · No injuriesClosedPiper PA-31 · Teterboro, NJNTSB NYC80FA010Accident · 3 fatalClosedAerostar 601P · Charlstadt, NJNTSB NYC80FHD07Accident · No injuriesClosedHiller UH12B · Mount Holly, NJNTSB NYC80DHD06Accident · No injuriesClosedStinson 108-2 · Toms River, NJNTSB NYC80FHA02Accident · No injuriesClosedCessna 172H · Hackettstown, NJNTSB NYC80FHM01Accident · No injuriesClosedCessna 152 · East Hanover, NJNTSB NYC80FHD03Accident · Minor injuriesClosedHughes 369D · Trenton, NJNTSB NYC80FHM03Accident · Serious injuriesClosedPiper PA-28 · Morganville, NJNTSB IAD79IA090Incident · No injuriesClosedPiper PA-31 · Morristown, NJNTSB NYC79FHM23Accident · No injuriesClosedCessna 150 · Fairfield, NJNTSB NYC79FA079Accident · 1 fatalClosedCessna 150 · Pennington, NJNTSB NYC79FHA27Accident · No injuriesClosedAero Cmdr 112TC · Pittstown, NJNTSB NYC79FHD22Accident · Minor injuriesClosedTeeny 2 · Bridgeport, NJNTSB NYC79FHD20Accident · No injuriesClosedPiper PA-23 · Atlantic, NJNTSB NYC79FHA22Accident · No injuriesClosedCessna 310I · Reddington, NJNTSB NYC79FHA21Accident · Serious injuriesClosedCessna 170A · Sussex, NJNTSB NYC79FA080Accident · 1 fatalClosedRyan PT-22 · Pittstown, NJNTSB NYC79FA076Accident · No injuriesClosedRichard KR-2 · Asbury Park, NJNTSB NYC79IA075Incident · No injuriesClosedLear Jet 35 · Newark, NJNTSB NYC79FA073Accident · Minor injuriesClosedTeal TSC1A2 · Bridgeport, NJNTSB NYC79FHA19Accident · No injuriesClosedCessna 177 · Franklin, NJNTSB NYC79FHD19Accident · Minor injuriesClosedCessna 172 · Ocean City, NJNTSB NYC79FA064Accident · No injuriesClosedBell 206B · Alpine, NJNTSB NYC79FHD18Accident · No injuriesClosedPiper PA-32 · Woodbine, NJNTSB NYC79DA054Accident · No injuriesClosedTed Smith TS-600 · Atlantic City, NJNTSB NYC79FHM22Accident · No injuriesClosedPiper PA-30 · Teterboro, NJNTSB NYC79FA050Accident · 2 fatalClosedPiper PA-12 · Stillmanville, NJNTSB NYC79FHM21Accident · Serious injuriesClosedCessna 172M · Marlboro, NJNTSB NYC79FHD16Accident · Minor injuriesClosedCessna A188B · Cedarville, NJNTSB NYC79FHD15Accident · No injuriesClosedCessna 172N · Woodline, NJNTSB NYC79FHM18Accident · No injuriesClosedCessna 172 · Matawan, NJNTSB NYC79FHM19Accident · No injuriesClosedCessna 150 · Fairfield, NJNTSB NYC79DHD14Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJNTSB DCA79FA014Accident · 3 fatalClosedSikorsky S61-L · Newark, NJNTSB NYC79FA038Accident · Serious injuriesClosedPiper PA-24 · Smithville, NJNTSB NYC79FHM15Accident · No injuriesClosedBrantly B2 · Flanders, NJNTSB NYC79FA033Accident · 2 fatalClosedPiper PA-28 · Allaire, NJNTSB NYC79DHM24Accident · No injuriesClosedCessna 172 · Colts Neck, NJNTSB NYC79FHD12Accident · No injuriesClosedBeech B24R · Robbinsville, NJNTSB NYC79DHM13Accident · No injuriesClosedPiper PA-28 · Morristown, NJNTSB NYC79FHD13Accident · No injuriesClosedCessna 337G · Lumberton, NJNTSB NYC79FA031Accident · 1 fatalClosedPiper PA-28 · Pittstown, NJNTSB NYC79FA027Accident · 1 fatalClosedPiper PA-28 · Newark, NJNTSB NYC79FHM11Accident · Minor injuriesClosedStits Play · Montville, NJNTSB NYC79FHD11Accident · No injuriesClosedCessna 152 · Robbinsville, NJNTSB NYC79FHD10Accident · No injuriesClosedBell 47G-4A · Seaside Park, NJNTSB NYC79DHM10Accident · No injuriesClosedCessna 172M · Lincoln Park, NJNTSB NYC79FHM07Accident · No injuriesClosedVargar 2150A · Flanders, NJ