NTSB investigations, 1975, NJ
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1975
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") = 1975 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 NYC76AN062Accident · 2 fatalClosedCessna 150M · Buena, NJNTSB NYC76DHA19Accident · No injuriesClosedBellanca 7ECA · Califon, NJNTSB NYC76FHM17Accident · Serious injuriesClosedCessna 150 · Fairfield, NJNTSB NYC76FHM16Accident · No injuriesClosedCessna 150 · Wayne Township, NJNTSB NYC76DHA17Accident · No injuriesClosedSchweizer 1-26A · Hainesburg, NJNTSB NYC76AN045Accident · 6 fatalClosedPiper PA-23 · Whitehouse Sta, NJNTSB NYC76FHM14Accident · Minor injuriesClosedCessna 150H · Lincoln Park, NJNTSB NYC76FHA13Accident · Minor injuriesClosedBeech J35 · Basking Ridge, NJNTSB NYC76FHM12Accident · Serious injuriesClosedCessna 182 · Linden, NJNTSB NYC76FHD09Accident · No injuriesClosedPiper PA-24 · Mt Laurel, NJNTSB NYC76FHA13Accident · Minor injuriesClosedSchreder HP-11 · Blairstown, NJNTSB NYC76FHA09Accident · No injuriesClosedCessna 150 · Blairstown, NJNTSB NYC76DHM10Accident · No injuriesClosedPiper PA-12 · Asbury Park, NJNTSB NYC76DHD08Accident · Serious injuriesClosedHughes 369 · Trenton, NJNTSB NYC76AHA07Accident · No injuriesClosedCessna 182M · Basking Ridge, NJNTSB NYC76FHM06Accident · Minor injuriesClosedEnstrom 280 · Mahwah, NJNTSB NYC76FHD05Accident · No injuriesClosedAero Comdr 100 · Atlantic City, NJNTSB NYC76DHM08Accident · No injuriesClosedPiper PA-28 · Fairfield, NJNTSB NYC76DHD06Accident · No injuriesClosedCessna 182 · Ocean City, NJNTSB NYC76AN018Accident · No injuriesClosedCessna 150 · Readington, NJNTSB NYC76FHM05Accident · Serious injuriesClosedBellanca 7GCAA · New Shrewsbury, NJNTSB NYC76DHM09Accident · No injuriesClosedCessna 172 · Marlboro, NJNTSB NYC76FHD02Accident · No injuriesClosedBeech C23 · Smithville, NJNTSB NYC76AN008Accident · 2 fatalClosedCessna 150L · Florham Park, NJNTSB NYC76DHD04Accident · No injuriesClosedHelicorp D · Trenton, NJNTSB NYC76DHA01Accident · No injuriesClosedCessna 172 · Basking Ridge, NJNTSB NYC7KFHD56Accident · Serious injuriesClosedStinson L-5 · Millville, NJNTSB NYC75AN123Accident · No injuriesClosedCessna 150 · Teterboro, NJNTSB NYC75IN121Incident · No injuriesClosedBeech E18S · Newark, NJNTSB NYC75FHA46Accident · Serious injuriesClosedBeech 95-C55 · Basking Ridge, NJNTSB NYC75FHA45Accident · No injuriesClosedN.American Navion · Andover, NJNTSB NYC75AN115Accident · 1 fatalClosedPiper PA-12 · Mount Laurel, NJNTSB NYC75FHD51Accident · No injuriesClosedAeronca 7BCM · Pennington, NJNTSB NYC75FHD47Accident · No injuriesClosedCessna 310N · Trenton, NJNTSB NYC75FHD48Accident · No injuriesClosedPiper PA-25 · Monroeville, NJNTSB NYC75FHM21Accident · Minor injuriesClosedStinson 108-3 · Teterboro, NJNTSB NYC75DHD50Accident · No injuriesClosedHiller Acft UH-12D · Cape May, NJNTSB NYC75AN109Accident · 2 fatalClosedAlon A-2 · Vineland, NJNTSB NYC75DHA44Accident · No injuriesClosedSchweizer 2-22 · Pittstown, NJNTSB NYC75DHM19Accident · No injuriesClosedCessna 177 · West Milford, NJNTSB NYC75FHD43Accident · Serious injuriesClosedPiper PA-28R · Lindenwold, NJNTSB NYC75FHA38Accident · Minor injuriesClosedAero Comdr 100 · Manville, NJNTSB NYC75DHA39Accident · No injuriesClosedSchweizer I-26E · Blairstown, NJNTSB NYC75DHM17Accident · Minor injuriesClosedPiper PA-28 · Marlboro, NJNTSB NYC75FHA35Accident · Minor injuriesClosedMooney M20C · Basking Ridge, NJNTSB NYC75DHA37Accident · No injuriesClosedSchweizer SGS126 · Blairstown, NJNTSB NYC75FHD38Accident · No injuriesClosedPiper PA-24 · Bridgeport, NJNTSB NYC75FHA33Accident · No injuriesClosedCessna 150 · Blairstown, NJNTSB NYC75FHD32Accident · Minor injuriesClosedCessna 172 · Atlantic City, NJNTSB NYC75AN088Accident · 2 fatalClosedBellanca 17-30 · Newton, NJ