NTSB investigations, 1978, 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\") = 1978
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") = 1978 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 NYC79DHD07Accident · Minor injuriesClosedCessna 172N · Robbinsville, NJNTSB NYC79FHA05Accident · Minor injuriesClosedPiper PA-24 · Blairstown, NJNTSB NYC79FHM03Accident · No injuriesClosedCessna 152 · Morristown, NJNTSB NYC79FHD06Accident · Serious injuriesClosedLake LA-4 · North Beach, NJNTSB NYC79IA013Incident · No injuriesClosedDouglas DC-9 · Newark, NJNTSB NYC79FHD04Accident · No injuriesClosedPiper PA-38 · Albion, NJNTSB NYC79FHD03Accident · No injuriesClosedPiper PA-30 · Lumberton, NJNTSB NYC79FHD02Accident · Minor injuriesClosedRyan ST-3KR · Albion, NJNTSB NYC79FA003Accident · 2 fatalClosedPiper PA-28R · Parsippany, NJNTSB NYC79FHM01Accident · Minor injuriesClosedPiper PA-28 · Caldwell, NJNTSB NYC79FHD01Accident · Serious injuriesClosedBeech 35 · Wrightstown, NJNTSB NYC78FHA39Accident · 1 fatalClosedBlanik L-3 · Pittstown, NJNTSB NYC78FHA35Accident · No injuriesClosedCessna 150 · Rock Hill, NJNTSB NYC78FA092Accident · 5 fatalClosedPiper PA-32R · Robbinsville, NJNTSB NYC78FHM29Accident · No injuriesClosedPiper PA-23 · Marlboro, NJNTSB NYC78FHM28Accident · No injuriesClosedCessna 150 · West Milford, NJNTSB NYC78FA087Accident · 1 fatalClosedCessna 150 · Dover, NJNTSB NYC79FHD23Accident · No injuriesClosedCessna 150L · Robinsville, NJNTSB NYC78FHA33Accident · No injuriesClosedCessna 210T · Princeton, NJNTSB NYC78FHM27Accident · No injuriesClosedHiller 12C · Neptune, NJNTSB NYC78FHM26Accident · Serious injuriesClosedPiper PA-32 · Matawan, NJNTSB NYC78FA083Accident · Minor injuriesClosedPiper PA-28 · Sussex, NJNTSB NYC78DHM25Accident · Minor injuriesClosedCessna C172H · Morristown, NJNTSB NYC79FA075Accident · 1 fatalClosedCessna 310P · Sussex, NJNTSB NYC79FHD21Accident · Minor injuriesClosedErcoupe 415 · Manahawkin, NJNTSB NYC78FHD19Accident · No injuriesClosedPiper PA-25 · Skulville, NJNTSB NYC78FHM20Accident · Serious injuriesClosedCessna 182 · Fairfield, NJNTSB NYC78FHA30Accident · Minor injuriesClosedTaylorcraft BC12-D · Manville, NJNTSB NYC78FA068Accident · No injuriesClosedPiper PA-28 · Millville, NJNTSB NYC78FHD18Accident · No injuriesClosedChampion 7KCAB · Point Pleasant, NJNTSB NYC78DHA28Accident · No injuriesClosedBeech B19 · Basking Ridge, NJNTSB NYC78FDH16Accident · Minor injuriesClosedGrum Amer AA5 · Cross Keys, NJNTSB NYC78FHM17Accident · No injuriesClosedSwearingen SA26AT · Teterboro, NJNTSB NYC78FHA22Accident · No injuriesClosedPiper PA-28 · Pittstown, NJNTSB NYC78FA047Accident · 2 fatalClosedCessna 150 · Mantoloking, NJNTSB NYC78FHM14Accident · No injuriesClosedBellanca 7GCBC · Lincoln Park, NJNTSB NYC78FHA21Accident · 1 fatalClosedBensen B8M · Pittstown, NJNTSB NYC78FHA20Accident · No injuriesClosedPiper PA-28 · Pittstown, NJNTSB NYC78DHD15Accident · No injuriesClosedCessna 150 · Jobstown, NJNTSB NYC78IA043Incident · No injuriesClosedBoeing 747 · Coyle, NJNTSB NYC78FHM13Accident · No injuriesClosedRallye 150ST · Teterboro, NJNTSB NYC78FHD13Accident · Minor injuriesClosedBeech B-19 · Hammonton, NJNTSB NYC78FHD11Accident · No injuriesClosedCessna 152 · Pitman, NJNTSB NYC78IA037Incident · No injuriesClosedBeech 99 · Newark, NJNTSB NYC78DHD10Accident · No injuriesClosedCessna 180 · Williamstown, NJNTSB NYC78DHA19Accident · No injuriesClosedBeech A23 · Sussex, NJNTSB NYC78FHM07Accident · No injuriesClosedCessna 150 · West Milford, NJNTSB NYC78IA029Incident · No injuriesClosedNord 262A · Newark, NJNTSB NYC78FHD06Accident · No injuriesClosedCessna 150 · Winslow, NJNTSB NYC78FHM06Accident · No injuriesClosedCessna 172 · Colts Neck, NJ