NTSB investigations, 2021, NJ
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2021
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") = 2021 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 DCA22LA053Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330 · Newark, NJTurkish Airlines flightcrew’ s misperception of the distance to safely pass the stopped Republic Airways airplane.NTSB ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.NTSB ERA22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Old Bridge, NJThe student pilot’s loss of control during a go-around, which resulted in an aerodynamic stall.NTSB ERA22FA058Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Branchville, NJThe flight instructor’s failure to recover from a steep spiral turn during an instructional flight.NTSB ERA22LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ringwood, NJA loss of engine power in flight due to fuel exhaustion as a result of the pilot’s failure to secure the left wing’s fuel cap.NTSB ERA22LA040Accident · No injuriesClass 4 · LimitedFinal reportJack A Frohbieter Questair Venture · Robbinsville, NJThe pilot’s failure to extend the landing gear prior to landing, which resulted in substantial damage to the lower fuselage. Contributing to the accident was the pilot’s failure to utilize the aircraft checklist.NTSB ENG22LA002Incident · Minor injuriesClass 3 · LimitedFinal reportAirbus A320-271N · Atlantic City, NJThe ingestion of a bird into the right engine during the takeoff roll caused a fan blade to fracture near the blade platform resulting in high fan blade off loads and engine vibrations sufficient to result in an eventual failure of a fuel tube in the right…NTSB DCA22LA002Accident · No injuriesClass 4 · LimitedFinal reportBoeing 757-224 · Newark, NJThe nose high attitude on landing resulted in a tailstrike.NTSB ERA21LA375Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Andover Township, NJThe student pilot's excessive asymmetrical application of the brakes, which resulted in a nose over.NTSB ERA21LA389Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Fairfield, NJThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB ERA21LA337Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV7 · Mount Holly, NJThe pilot’s improper recovery from a bounced landing, resulting in a touchdown on the nose gear first, resulting in damage to the nose gear and a runway excursion.NTSB ERA21LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 210N · Somerville, NJThe pilot’s failure to extend the landing gear, which resulted in a gear up landing and substantial damage to the fuselage.NTSB ERA21LA312Accident · No injuriesClass 4 · LimitedFinal reportBeech K35 · Readington, NJThe failure of the forward end of the landing gear actuator rod.NTSB ERA21LA241Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Robbinsville, NJThe pilot’s mismanagement of fuel, which resulted in a total loss of engine power.NTSB ERA21LA226Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lincoln Park, NJThe pilot's loss of directional control during an aborted landing in crosswind conditions.NTSB ERA21LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Hardwick Township, NJThe pilot’s inadequate prefight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB ERA21LA102Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar · Vineland, NJA steep descent and impact with terrain during final approach for reasons that could not be determined.