NTSB investigations, 1981, 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\") = 1981
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") = 1981 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 NYC82DHA07Accident · No injuriesClosedCessna 150 · Blairstown, NJNTSB NYC82FHA03Accident · Serious injuriesClosedCessna 150K · Andover, NJNTSB NYC82DHA04Accident · No injuriesClosedCessna 152 · Manville, NJNTSB NYC82FHD05Accident · Minor injuriesClosedCessna 177B · Bridgeport, NJNTSB NYC82DHD04Accident · No injuriesClosedCessna 152 · Toms River, NJNTSB NYC82DFJ05Accident · No injuriesClosedPiper PA-22 · Fulton, NJNTSB NYC82DHA02Accident · No injuriesClosedPiper PA-32R · Princeton, NJNTSB NYC82FHD02Accident · Minor injuriesClosedCessna 150H · Manahawkin, NJNTSB NYC82FHA01Accident · No injuriesClosedCessna 210 · Blairstown, NJNTSB NYC82FHD03Accident · No injuriesClosedPiper PA-20 · Atlantic City, NJNTSB NYC81FHD40Accident · No injuriesClosedPiper PA-38 · Lumberton, NJNTSB DCA81AA028Accident · 2 fatalClosedPiper PA-34 · E.Rutherford, NJNTSB DCA81AA027Accident · No injuriesClosedLockheed L-1011 · Colts Neck, NJNTSB NYC81FHM16Accident · No injuriesClosedCessna 150M · Caldwell, NJNTSB NYC81FHA23Accident · No injuriesClosedCessna 177 · Stillwater, NJNTSB NYC81DHA22Accident · Minor injuriesClosedSchweizer 1-23H · Blairstown, NJNTSB NYC81FA081Accident · 1 fatalClosedPiper PA-28R · Randolph, NJNTSB NYC81DHD37Accident · Minor injuriesClosedPiper PA-28R · Manahawkin, NJNTSB NYC81FHA21Accident · Minor injuriesClosedCessna 152 · Sparta, NJNTSB NYC81FHD36Accident · Serious injuriesClosedMorrisey 2150A · Port Republic, NJNTSB NYC81FHM15Accident · Minor injuriesClosedGyro Sport 1-39 · Lincoln Park, NJNTSB NYC81FHD34Accident · Minor injuriesClosedCessna T188C · Woodstown, NJNTSB NYC81FHM13Accident · No injuriesClosedPiper PA-18 · Colts Neck, NJNTSB NYC81DHD35Accident · No injuriesClosedPiper PA-28R · Robbinsville, NJNTSB NYC81FHD31Accident · No injuriesClosedPiper PA-28R · Lumberton, NJNTSB NYC81FHD32Accident · Minor injuriesClosedMooney M20E · Bridgeport, NJNTSB NYC81FHM12Accident · No injuriesClosedCessna 172N · Ridgefield Prk, NJNTSB NYC81FHD30Accident · Serious injuriesClosedPiper PA-18 · Atlantic City, NJNTSB NYC81FHM14Accident · No injuriesClosedPiper PA-18 · Colts Neck, NJNTSB NYC81FHM09Accident · Minor injuriesClosedEngr & Rsch 415-D · Matawan, NJNTSB NYC81FA068Accident · 3 fatalClosedBeech A24R · Manahawkin, NJNTSB NYC81FA067Accident · Minor injuriesClosedCessna 172 · Bridgeport, NJNTSB NYC81FA064Accident · No injuriesClosedMooney M20K · Atlantic City, NJNTSB NYC81DA065Accident · No injuriesClosedCessna 182 · Pittstown, NJNTSB NYC81IA059Incident · No injuriesClosedPiper PA-34 · Newark, NJNTSB NYC81FHD28Accident · Minor injuriesClosedCessna 150 · Hamilton Sq, NJNTSB DCA81IA016Incident · No injuriesClosedDehavilland DHC-7 · Atlantic City, NJNTSB NYC81FHA15Accident · No injuriesClosedBeech V35B · Stockton, NJNTSB NYC81IA054Accident · Serious injuriesClosedPiper PA-28 · Skullville, NJNTSB NYC81IA051Incident · No injuriesClosedSwearingen SA226 · Newark, NJNTSB NYC81FHM07Accident · No injuriesClosedPiper PA-28 · New Milford, NJNTSB NYC81FHD26Accident · No injuriesClosedStearman PT-17 · Salem, NJNTSB NYC81FHM06Accident · Minor injuriesClosedPiper PA-28 · West Milford, NJNTSB NYC81FHD23Accident · No injuriesClosedCessna 172N · Elmer, NJNTSB NYC81FA047Accident · 4 fatalClosedCessna 177B · Forked River, NJNTSB NYC82IHD22Accident · Serious injuriesClosedPiper PA-28 · Bridgeport, NJNTSB NYC81DHA12Accident · Minor injuriesClosedSchweizer 1-35C · Blairstown, NJNTSB NYC81FHD20Accident · No injuriesClosedPorterfield FP-65 · Robbinsville, NJNTSB NYC81DHA09Accident · Minor injuriesClosedSikorsky S-55B · Stillwater, NJNTSB NYC81FHM03Accident · Minor injuriesClosedPiper PA-28 · Franklin Lakes, NJ