NTSB investigations, 1977, 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\") = 1977
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") = 1977 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 NYC78FHD03Accident · No injuriesClosedBeech V35A · Ocean City, NJNTSB NYC78DHD02Accident · Minor injuriesClosedPiper PA-28R · Lakewood, NJNTSB NYC78FHD01Accident · Serious injuriesClosedPiper PA-34 · Berlin, NJNTSB NYC78FHM01Accident · No injuriesClosedHughes 369D · Monmouth, NJNTSB NYC78FA002Accident · 1 fatalClosedPiper PA-28 · Randolph, NJNTSB NYC77FHD32Accident · No injuriesClosedCessna 172H · Marlton, NJNTSB NYC78FHM04Accident · No injuriesClosedHiller Acft UH-12C · Lincoln Park, NJNTSB NYC77FHD30Accident · Minor injuriesClosedBell 206L · Hightstown, NJNTSB NYC77DHA34Accident · Serious injuriesClosedPiper J4A · Stillwater, NJNTSB NYC77FHD29Accident · No injuriesClosedPiper PA-18A · Ocean City, NJNTSB NYC77FHO26Accident · Minor injuriesClosedPiper PA-28 · Ocean City, NJNTSB NYC77FHM23Accident · Minor injuriesClosedPiper PA-28R · Fairfield, NJNTSB NYC77IA083Incident · No injuriesClosedLear 23 · Teterboro, NJNTSB NYC77FHM22Accident · No injuriesClosedPiper PA-28 · Teterboro, NJNTSB LAX77IA062Incident · No injuriesClosedDouglas DC-10 · Trenton, NJNTSB NYC77FHD23Accident · No injuriesClosedBeech D-18S · Lakewood, NJNTSB NYC77FHD22Accident · No injuriesClosedCessna 188 · Tabernacle, NJNTSB NYC77DHA29Accident · No injuriesClosedCessna 172 · Bedminster, NJNTSB NYC77DHO21Accident · No injuriesClosedEnstrom F28A · Toms River, NJNTSB NYC77DHD20Accident · No injuriesClosedGrum Amer AA1-B · Lakewood, NJNTSB NYC77FHM20Accident · Minor injuriesClosedCessna 150 · Teterboro, NJNTSB NYC77FHD19Accident · Serious injuriesClosedCessna 150 · Atlantic Cy, NJNTSB NYC77FA071Accident · 1 fatalClosedPiper PA-28 · Ocean City, NJNTSB NYC77FHA24Accident · No injuriesClosedCessna 172B · Vernon, NJNTSB NYC77FHD18Accident · Serious injuriesClosedAeronca 7CCM · Egg Harbor, NJNTSB NYC77DHA28Accident · No injuriesClosedPiper PA-28R · Princeton, NJNTSB NYC77DHA26Accident · No injuriesClosedPiper PA-28 · Bedminster, NJNTSB NYC77DHM19Accident · Minor injuriesClosedGrum Amer AA1 · Farmingdale, NJNTSB NYC77FHA23Accident · Serious injuriesClosedCessna 172 · Basking Ridge, NJNTSB NYC77FHM18Accident · Minor injuriesClosedPiper PA-28 · Totowa, NJNTSB NYC77DHA20Accident · No injuriesClosedCessna 150 · Basking Ridge, NJNTSB NYC77IA057Incident · Minor injuriesClosedBeech 24R · Millville, NJNTSB NYC77FA055Accident · 2 fatalClosedGR Lakes 2T1A-2 · Milford, NJNTSB NYC77FHA18Accident · No injuriesClosedCessna 421B · Manville, NJNTSB NYC77FHM17Accident · No injuriesClosedCessna 180 · Red Hook, NJNTSB NYC77FHD28Accident · No injuriesClosedPiper PA-18 · Atlantic City, NJNTSB NYC77FHM12Accident · No injuriesClosedCessna 182 · West Milford, NJNTSB NYC77DHD10Accident · No injuriesClosedPiper PA-28 · Atlantic City, NJNTSB NYC77FHD08Accident · Minor injuriesClosedCessna 150 · Hammonton, NJNTSB NYC77DHA16Accident · No injuriesClosedBell 47G-4 · Blairstown, NJNTSB NYC77FHM10Accident · No injuriesClosedCessna 150M · Matawan, NJNTSB NYC77FHM09Accident · Serious injuriesClosedCessna 150J · Randolph, NJNTSB NYC77FHM08Accident · No injuriesClosedMooney M20F · Lincoln Park, NJ