NTSB investigations, 2007, NJ
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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
Open the mapLatest 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\") = 2007
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") = 2007 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 OPS08IA004Incident · No injuriesIncident investigationFinal reportGulfstream American G5 · Teterboro, NJThe probable cause of this incident was the TEB tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll.NTSB NYC08LA070Accident · No injuriesLimited investigationFinal reportCessna 182R · Pittstown, NJA loss of engine power for undetermined reasons.NTSB NYC08CA042Accident · No injuriesData collectionFinal reportCessna 172N · Hamilton, NJThe pilot's inadequate fuel consumption calculations which resulted in fuel exhaustion.NTSB NYC08FA022Accident · No injuriesField investigationFinal reportCessna 650 · Atlantic City, NJThe first officer's failure to maintain airspeed during approach, and the captain's inadequate remedial action. Contributing to the accident was the first officer's failure to comply with procedures, windshear, and the lack of windshear warning from air…NTSB ATL07LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Pittsgrove, NJA partial loss of engine power due to low compression for undetermined reasons.NTSB ATL07LA130Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900 · Teterboro, NJThe steamroller driver's improper decision to operate the vehicle without a wing walker present.NTSB NYC07LA221Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Bernardsville, NJThe failure by unidentified maintenance personnel to follow appropriate procedures when attaching the No. 3 cylinder, which was replaced subsequent to the engine overhaul and not entered in the logbook, resulting in fatigue failures of the cylinder studs.NTSB NYC07CA211Accident · Minor injuriesData collectionFinal reportAeronca O-58B · Lincoln Park, NJA bird strike, as reported by the pilot.NTSB NYC07LA197Accident · No injuriesLimited investigationFinal reportCessna T210N · Old Bridge, NJThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation during approach.NTSB OPS07IA008Incident · No injuriesIncident investigationFinal reportLearjet 45 · Teterboro, NJA runway incursion occurred when the local controller did not ensure that N145AP has passed the intersection of runways 1 and 6 prior to authorizing N336FX to depart runway 1.NTSB NYC07LA192Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Frenchtown, NJA partial loss of engine power for undetermined reasons.NTSB ATL07LA106Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Sussex, NJA loss of engine power for undetermined reasons.NTSB NYC07LA160Accident · Minor injuriesLimited investigationFinal reportCessna Ector 305A · Berkeley Townsh, NJA loss of engine power during cruise flight for undetermined reasons.NTSB ANC07LA063Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pedricktown, NJThe first pilot's inadequate preflight inspection, and water contamination of the airplane's fuel system. A factor contributing to the accident was rough/uneven terrain.NTSB NYC07LA146Accident · No injuriesLimited investigationFinal reportBell-Carson 47G-Super C-4 · Wall Township, NJA total failure of the number one connecting rod during approach.NTSB OPS07IA005Incident · No injuriesIncident investigationFinal reportPiaggio Industrie P180 · Teterboro, NJThe TEB local controller's failure to ensure separation between two aircraft departing intersecting runways.NTSB NYC07CA133Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lumberton, NJThe flight instructor's improper decision to simulate an engine failure in the traffic pattern by cutting off fuel to the engine, and his subsequent failure to maintain directional control during an aborted landing.NTSB NYC07CA101Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Pompton Plains, NJA loss of engine power during the initial climb for undetermined reasons.NTSB NYC07FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Howell, NJThe pilot's improper decision to attempt a flight with known serious medical conditions, which resulted in impairment during cruise flight, likely due to a stroke or transient ischemic attack. A factor was the pilot providing false information on his medical…NTSB NYC07CA076Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Farmingdale, NJThe pilot's failure to verify the amount of fuel onboard before takeoff. Factors in the accident were the airplane being under fueled, the refueler's experience, the airplane's inoperative fuel gauges, unsuitable terrain for landing, and night lighting…NTSB NYC07LA061Accident · No injuriesLimited investigationFinal reportCessna 310Q · Atlantic City, NJThe inoperative safe gear indicator light switch. Contributing to the accident was the pilot hand-cranking the landing gear past the physical stop.NTSB NYC07FA056Accident · 1 fatalField investigationFinal reportBeech A36 · Wayne, NJThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB NYC07CA054Accident · No injuriesData collectionFinal reportCessna R182 · Hackettstown, NJThe pilot-in-command's delayed aborted takeoff, which resulted in a runway overrun and collision with terrain. A factor was the rocks off the end of the runway.