NTSB investigations, 1973, 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\") = 1973
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") = 1973 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 NYC74DHM14Accident · No injuriesClosedCessna 150 · Lincoln Park, NJNTSB NYC74FHA23Accident · No injuriesClosedCessna 177B · Manville, NJNTSB NYC74FHD28Accident · 1 fatalClosedTaylor Mono · Millville, NJNTSB NYC74FHM13Accident · Serious injuriesClosedCessna 150L · Linden, NJNTSB NYC74FHM12Accident · Minor injuriesClosedBrantly B-2 · North Bergen, NJNTSB NYC74FHD21Accident · No injuriesClosedCessna 150L · Pitman, NJNTSB NYC74DHM11Accident · No injuriesClosedCessna 172 · Colts Neck, NJNTSB NYC74FHM10Accident · Minor injuriesClosedBellanca 7ACA · Hanover, NJNTSB NYC74FHA16Accident · Serious injuriesClosedTaylorcraft BC12-D · Montague, NJNTSB NYC74DHD19Accident · No injuriesClosedCessna 150 · Hammonton, NJNTSB NYC73AN038Accident · Serious injuriesClosedBeech V35A · Robbinsville, NJNTSB NYC74FHD18Accident · No injuriesClosedPietenpol Aircam · Lakewood, NJNTSB NYC74FHD12Accident · Minor injuriesClosedPiper PA-28 · Moorestown, NJNTSB NYC74FHA13Accident · Minor injuriesClosedCessna 206A · Pittstown, NJNTSB NYC74DHM09Accident · Minor injuriesClosedCessna 172 · East Hanover, NJNTSB NYC74DHD17Accident · No injuriesClosedPiper PA-28 · Berlin, NJNTSB NYC74DHD16Accident · No injuriesClosedMooney M20F · Williamston, NJNTSB NYC74FHA10Accident · Minor injuriesClosedPiper PA-30 · Manville, NJNTSB NYC74FHM07Accident · Minor injuriesClosedCessna 310F · Neptune, NJNTSB NYC74FHM06Accident · No injuriesClosedCessna 172 · Farmingdale, NJNTSB NYC74FHD15Accident · No injuriesClosedPiper PA-28 · Berlin, NJNTSB NYC74FHM03Accident · No injuriesClosedEnstrom F-28A · Teterboro, NJNTSB NYC74FHD08Accident · No injuriesClosedFokker DR-1 · Woodbine, NJNTSB NYC74DHD07Accident · No injuriesClosedCessna 172H · Vineland, NJNTSB NYC74DHD04Accident · No injuriesClosedCessna 182 · Berlin, NJNTSB NYC74FHD06Accident · No injuriesClosedBell 47G-4A · Barnegat, NJNTSB NYC74FHD13Accident · No injuriesClosedBeech C35 · Rio Grand, NJNTSB NYC74DHD03Accident · No injuriesClosedGrumman G-164 · Pittsgrove, NJNTSB NYC74DHD02Accident · No injuriesClosedSopwith Camel · Woodbine, NJNTSB NYC74FHA02Accident · No injuriesClosedCessna 150 · Sussex, NJNTSB NYC74FHM02Accident · Minor injuriesClosedPiper PA-28 · Marboro, NJNTSB NYC74FHM01Accident · Minor injuriesClosedBellanca 17-30 · Linden, NJNTSB NYC73FHD38Accident · No injuriesClosedEaa Biplane P-2 · Medford, NJNTSB NYC74FHD20Accident · 1 fatalClosedJeanie 2 Teenie · Tuckerton, NJNTSB NYC73FHM33Accident · Serious injuriesClosedCessna 150K · Hackensack, NJNTSB NYC73AN149Accident · 3 fatalClosedMooney M20F · Atlantic City, NJNTSB NYC73FHM32Accident · No injuriesClosedCessna 172K · Marlboro, NJNTSB NYC73FHM31Accident · Serious injuriesClosedGlobe GC-1B · Fairfield, NJNTSB NYC73FHA25Accident · No injuriesClosedWaco UPF-7 · Bedminster, NJNTSB NYC73FHM29Accident · No injuriesClosedPiper PA-28 · Clark, NJNTSB NYC73FHD32Accident · Minor injuriesClosedCessna 150G · Rancocas, NJNTSB NYC73DHD36Accident · No injuriesClosedCessna 150 · Williamstown, NJNTSB NYC73FHA24Accident · No injuriesClosedCessna 172 · Basking Ridge, NJNTSB NYC73AN132Accident · 6 fatalClosedBeech 65-A80 · Bricktown, NJNTSB NYC73DHD30Accident · No injuriesClosedPiper PA-28 · Williamstown, NJNTSB NYC73DHA20Accident · No injuriesClosedCessna 182A · Pittstown, NJNTSB NYC73AN127Accident · 1 fatalClosedPiper J4A · Pennington, NJNTSB NYC73FHM23Accident · No injuriesClosedPiper PA-24 · Carlstadt, NJNTSB NYC73FHA18Accident · No injuriesClosedPiper PA-28 · Pittstown, NJNTSB NYC73FHM25Accident · No injuriesClosedCessna 172 · Farmingdale, NJ