NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 NYC81DHA06Accident · No injuriesClosedPiper PA-28 · Bedminster, NJNTSB NYC81FHD09Accident · No injuriesClosedDehavilland DHC-1 · Ocean City, NJNTSB NYC81FHA04Accident · Minor injuriesClosedCessna 172 · Andover, NJNTSB NYC81DHA05Accident · No injuriesClosedHughes 300C · Whitehouse, NJNTSB NYC81FA011Accident · 4 fatalClosedCessna 177B · Bridgeport, NJNTSB NYC81FA008Accident · Serious injuriesClosedBoeing 727 · Newark, NJNTSB NYC81FHD07Accident · Serious injuriesClosedCessna 177RG · Vineland, NJNTSB NYC81FHD05Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJNTSB NYC81FHD04Accident · Minor injuriesClosedPiper PA-24 · Delran Twnship, NJNTSB NYC81IA006Incident · No injuriesClosedBell 206L · Atlantic City, NJNTSB NYC81FHD03Accident · No injuriesClosedPiper PA-34 · Burlington, NJNTSB NYC81DHA01Accident · No injuriesClosedAeronca 7DC · Pottstown, NJNTSB NYC81IA002Incident · No injuriesClosedLockheed L1011 · Newark, NJNTSB NYC81FHD02Accident · No injuriesClosedBlimp EA-1 · Lakehurst, NJNTSB NYC81DHD01Accident · No injuriesClosedCessna 172 · Woodbine, NJNTSB NYC81FA001Accident · 2 fatalClosedLake 4-200 · Little Egg, NJNTSB NYC80FHD26Accident · No injuriesClosedPiper PA-28 · Berlin, NJNTSB NYC80FA085Accident · Minor injuriesClosedCessna 172N · Hammonton, NJNTSB NYC80DHA29Accident · No injuriesClosedSchweizer SGS126 · Mt Salem, NJNTSB NYC80FA071Accident · 2 fatalClosedPiper PA-24 · Atlantic City, NJNTSB NYC80FHD23Accident · No injuriesClosedCessna 150 · Little Egg Hbr, NJNTSB NYC80FHM23Accident · No injuriesClosedPiper PA-28 · Hanover, NJNTSB NYC80FHD22Accident · No injuriesClosedCessna 206 · Wildwood, NJNTSB NYC80FHM21Accident · No injuriesClosedCessna 150L · Caldwell, NJNTSB NYC80DA081Accident · No injuriesClosedCessna 150 · Princetown, NJNTSB NYC80FA050Accident · 5 fatalClosedPiper PA-28 · Ocean City, NJNTSB NYC80DHD21Accident · No injuriesClosedCessna 172 · Atlantic City, NJNTSB NYC80DHA22Accident · No injuriesClosedCessna 172 · Pittstown, NJNTSB NYC80DHM16Accident · No injuriesClosedSchweizer SGS126 · Colts Neck, NJNTSB NYC80FHA23Accident · No injuriesClosedPiper PA-23 · Somerville, NJNTSB NYC80FHA15Accident · No injuriesClosedCessna 150 · Newton, NJNTSB NYC80FHM17Accident · No injuriesClosedCessna 152 · Morristown, NJNTSB NYC80FHD15Accident · Minor injuriesClosedBede 4 · Bridgeport, NJNTSB NYC80FA044Accident · 1 fatalClosedPiper PA-23 · Neptune, NJNTSB NYC80FA043Accident · 3 fatalClosedCessna 172G · Cape May, NJNTSB NYC80FHD17Accident · No injuriesClosedChampion 7GCBC · Williamstown, NJNTSB NYC80DHA25Accident · No injuriesClosedGrum Amer AA-1 · Sussex, NJNTSB NYC80FHM18Accident · No injuriesClosedCessna 150 · West Milford, NJNTSB NYC80FHD11Accident · No injuriesClosedCessna 177RG · Normandy Beach, NJNTSB NYC80FHD14Accident · No injuriesClosedHarvard MK-4 · Turnersville, NJNTSB NYC80FA040Accident · 4 fatalClosedCessna 411 · Vineland, NJNTSB NYC80FHA12Accident · No injuriesClosedPiper PA-28 · Pittstown, NJNTSB NYC80FHA11Accident · No injuriesClosedBeech M35 · Somerville, NJNTSB NYC80FHM15Accident · No injuriesClosedCessna 150L · Lincoln Park, NJNTSB NYC80FHM14Accident · Minor injuriesClosedCessna 152 · West Milford, NJNTSB NYC80FHM11Accident · No injuriesClosedCessna 172 · New Milford, NJNTSB NYC80FHM12Accident · No injuriesClosedPiper PA-32 · Morristown, NJNTSB NYC80FA027Accident · 1 fatalClosedMooney M20C · Ogdensburg, NJNTSB NYC80FHD09Accident · No injuriesClosedCessna 172 · Cross Keys, NJNTSB NYC80DHA05Accident · No injuriesClosedCessna 340 · Princeton, NJ