NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1186Incident · No injuriesClosedDouglas DC-8 · Newark, NJNTSB UNK65X1066Accident · No injuriesClosedCessna 170B · Blairstown, NJNTSB UNK65X1018Accident · No injuriesClosedCessna 172 · Teterboro, NJNTSB UNK65X1009Accident · No injuriesClosedPiper PA28 · Lumberton, NJNTSB UNK65X0959Accident · No injuriesClosedPiper PA28 · Lincoln Park, NJNTSB UNK65X0949Accident · No injuriesClosedBell 47G4 · Bedminster, NJNTSB UNK65X0892Accident · No injuriesClosedPiper PA22 · Newark, NJNTSB UNK65X0865Accident · No injuriesClosedCessna 172 · Blackwood, NJNTSB UNK65X0827Incident · No injuriesClosedCaravelle SE-210 · Newark, NJNTSB NYC65A0078Accident · 4 fatalClosedBeechcraft M35 · Millville, NJNTSB UNK65X0759Incident · No injuriesClosedDouglas DC-6 · Robbinsville, NJNTSB UNK65X0731Accident · 1 fatalClosedCessna 172F · Shrewsbury, NJNTSB UNK65X0728Accident · 4 fatalClosedBeech C18S · Fairfield, NJNTSB UNK65X0715Accident · No injuriesClosedPiper PA24 · Ashland, NJNTSB UNK65X0685Accident · No injuriesClosedPiper PA-22 · Bedminster, NJNTSB UNK65X0497Accident · Minor injuriesClosedNavion A · Manchester, NJNTSB UNK65X0481Accident · No injuriesClosedPiper PA24 · Teterboro, NJNTSB UNK65X0459Accident · No injuriesClosedCessna 150 · Colts Neck, NJNTSB UNK65X0443Incident · No injuriesClosedLockheed L-188 · Woodstown, NJNTSB UNK65X0421Accident · No injuriesClosedPiper PA23 · Cape May, NJNTSB UNK65X0375Accident · No injuriesClosedPiper J3C65 · Lincoln Park, NJNTSB UNK65X0144Accident · No injuriesClosedPiper PA28 · Lumberton, NJNTSB UNK64X4161Accident · No injuriesClosedStinson 10A · Pemberton, NJNTSB UNK64X4094Accident · No injuriesClosedCessna 150 · Hanover, NJNTSB UNK64X4091Incident · No injuriesClosedDouglas DC-3 · Atlantic City, NJNTSB UNK64X4090Incident · No injuriesClosedDouglas DC-3 · Atlantic City, NJNTSB UNK64X4009Accident · No injuriesClosedCessna 150 · Hanover, NJNTSB UNK64X4007Accident · No injuriesClosedForney F1 · Red Bank, NJNTSB UNK64X3947Accident · No injuriesClosedBeechcraft D18S · Linden, NJNTSB UNK64X3896Accident · No injuriesClosedChampion 7FC · S Plainfield, NJNTSB UNK64X3827Accident · No injuriesClosedPiper PA28 · Readington, NJNTSB UNK64X3817Accident · No injuriesClosedPiper PA24 · Princeton, NJNTSB UNK64X3735Accident · No injuriesClosedPiper PA28 · Cape May, NJNTSB UNK64X3717Accident · 1 fatalClosedTaylorcraft BC12D · Berlin, NJNTSB UNK64X3684Accident · No injuriesClosedAero Comm 520 · Morristown, NJNTSB UNK64X3672Accident · No injuriesClosedTaylorcraft BC12D · Cross Keys, NJNTSB UNK64X3608Accident · Minor injuriesClosedNavion Ryan · Atlantic City, NJNTSB UNK64X3581Accident · No injuriesClosedPiper PA28 · Red Bank, NJNTSB UNK64X3563Accident · Minor injuriesClosedPiper PA28 · Pittstown, NJNTSB UNK64X3433Accident · 2 fatalClosedBeech 35-33 · South Plainfld, NJNTSB UNK64X3407Accident · Serious injuriesClosedRyan ST3KR · Fairfield, NJNTSB UNK64X3338Accident · No injuriesClosedAero Comm 500 · Red Bank, NJNTSB UNK64X3303Accident · No injuriesClosedSchweizer 222 · Fairfield, NJNTSB UNK64X3293Accident · No injuriesClosedCessna 150 · Asbury Park, NJNTSB UNK64X3264Accident · No injuriesClosedCessna 210 · Andover, NJNTSB UNK64X3106Accident · No injuriesClosedPiper PA18 · Pluckemin, NJNTSB UNK64X2932Accident · Minor injuriesClosedPiper PA22 · Brigantine, NJNTSB UNK64X2926Accident · No injuriesClosedErcoure 415C · Hanover, NJNTSB UNK64X2922Accident · No injuriesClosedCessna 182 · Long Beach Is, NJNTSB UNK64X2909Accident · 1 fatalClosedPiper PA18 · Colts Neck, NJ