NTSB investigations, 1972, 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\") = 1972
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") = 1972 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 NYC73AN125Accident · No injuriesClosedLockheed 1011 · Atlantic City, NJNTSB NYC73FHM20Accident · No injuriesClosedCessna 150 · S.Hackensack, NJNTSB NYC73FHM17Accident · Minor injuriesClosedCessna 150H · Newfoundland, NJNTSB NYC73FHA12Accident · 1 fatalClosedBensen Gyro B8M · Reddington, NJNTSB NYC73DHD15Accident · No injuriesClosedCessna 150 · Hammaton, NJNTSB NYC73FHM16Accident · Minor injuriesClosedPiper PA-22 · Colts Neck, NJNTSB NYC73FHA10Accident · No injuriesClosedCessna 150K · Manville, NJNTSB NYC73FHD18Accident · No injuriesClosedBeech C-45H · Millville, NJNTSB NYC73INO54Accident · No injuriesClosedCessna 411 · Marlton, NJNTSB NYC73DHD19Accident · No injuriesClosedPiper PA-24 · Marlton, NJNTSB NYC73FHD16Accident · No injuriesClosedPiper PA-28 · Bridgeport, NJNTSB NYC73DHA09Accident · No injuriesClosedSwift GC-1B · Blairstown, NJNTSB NYC73FHM13Accident · No injuriesClosedStinson 108 · Flanders, NJNTSB NYC73AN045Accident · 2 fatalClosedBeech E18S · Newark, NJNTSB NYC73FHM12Accident · No injuriesClosedBell 47G-4A · Cranbury, NJNTSB NYC73FHM11Accident · No injuriesClosedBellanca 260 · Sea Bright, NJNTSB NYC73FHM10Accident · No injuriesClosedPiper PA-28 · East Hanover, NJNTSB NYC73DHD10Accident · No injuriesClosedPiper PA-28 · Marlton, NJNTSB NYC73FHM06Accident · No injuriesClosedPiper PA-30 · Fairfield, NJNTSB NYC73FHM04Accident · No injuriesClosedCessna 172L · Oakland, NJNTSB NYC73FHD06Accident · No injuriesClosedAmer Avco AA1A · Atco, NJNTSB NYC73DHD09Accident · No injuriesClosedBeech V35 · Absecon, NJNTSB NYC73IN017Incident · No injuriesClosedBeech 95-C55 · Fairfield, NJNTSB NYC73FHD07Accident · No injuriesClosedAmer Avco AA1 · Atlantic City, NJNTSB NYC73FHD04Accident · Minor injuriesClosedPiper PA-12 · Wildwood, NJNTSB NYC73FHD03Accident · No injuriesClosedCessna 150L · Ocean City, NJNTSB NYC73DHD02Accident · No injuriesClosedPiper PA-28 · Albion, NJNTSB NYC73DHD01Accident · Serious injuriesClosedPiper J-3 · Rio Grande, NJNTSB NYC72FHM59Accident · Minor injuriesClosedCessna 150K · Mahwah, NJNTSB NYC72AN155Accident · 3 fatalClosedPiper PA-24 · Atlantic City, NJNTSB NYC72AN153Accident · 2 fatalClosedCessna 177A · Columbia, NJNTSB NYC72FHM56Accident · No injuriesClosedBell 47G-5 · Freehold, NJNTSB NYC72DHD41Accident · No injuriesClosedWoodbury Tapsik · Millville, NJNTSB NYC72FHD40Accident · Minor injuriesClosedChampion 7ECA · Ocean City, NJNTSB NYC72FHM55Accident · No injuriesClosedCessna 310H · Lincoln Park, NJNTSB NYC72FHM51Accident · No injuriesClosedPiper PA-28 · Clark, NJNTSB NYC72FHD39Accident · No injuriesClosedBeech 35 · Woodbine, NJNTSB NYC72AN140Accident · Minor injuriesClosedBeech B95 · Atlantic City, NJNTSB NYC72AN138Accident · No injuriesClosedSwearingen SA26AT · Fairfield, NJNTSB NYC72DHD37Accident · No injuriesClosedAeronca 7AC · Medford, NJNTSB NYC72FHM45Accident · No injuriesClosedAero-Comdr 100 · Fairfield, NJNTSB NYC72FHA37Accident · No injuriesClosedBensen B-8M · Readington, NJNTSB NYC72IN132Incident · No injuriesClosedDouglas DC-8 · Newark, NJNTSB NYC72FHM42Accident · Minor injuriesClosedCessna 150H · Fort Lee, NJNTSB NYC72AN129Accident · 3 fatalClosedMitsubishi MU-2G · Atlantic City, NJNTSB NYC72FHD35Accident · No injuriesClosedCessna 182M · Marlton, NJNTSB NYC72FHM40Accident · Minor injuriesClosedCessna 150G · East Hanover, NJNTSB NYC72FHD32Accident · No injuriesClosedSiai-Marche S20522 · Atlantic City, NJNTSB NYC72FHM36Accident · No injuriesClosedCessna 182 · Linden, NJNTSB NYC72DHA36Accident · Minor injuriesClosedPiper PA-28 · Bedminister, NJ