NTSB investigations, NJ
16 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 2 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 c."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA26LA003Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · West Milford, NJThe pilot’s failure to adequate clearance from obstacles while maneuvering during the landing approach and the instructor pilot’s delayed remedial action, which resulted in the airplane contacting a tree and terrain.NTSB ERA20CA139Accident · No injuriesData collectionFinal reportBeech 200 · Morristown, NJThe airplane hydroplaning while landing on a wet runway, which degraded its braking capability and resulted in a runway overrun onto grass and mud and the nose landing gear collapsing. Contributing to the accident was the pilot's improper decision to land the…NTSB ERA19FA184Accident · 1 fatalClass 2 · FieldFinal reportMooney M20J · Cape May, NJThe pilot's intentional flight into water as an act of suicide.NTSB GAA18CA483Accident · No injuriesData collectionFinal reportRobinson R22 · Ocean City, NJThe flight instructor's decision to conduct hover practice at a lower altitude than recommended and his delayed remedial action during recovery from an unstable hover, which resulted in a dynamic rollover.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA17LA182Accident · Minor injuriesLimited investigationFinal reportStinson 108 · West Creek, NJA total loss of engine power due to the No. 4 cylinder’s exhaust valve getting stuck and the subsequent fracturing of the valve face stem.NTSB GAA17CA162Accident · No injuriesData collectionFinal reportCessna T337 · Linden, NJThe pilot’s abrupt maneuver to avoid birds during short final approach, which resulted in a hard, bounced landing.NTSB ERA16LA291Accident · Serious injuriesLimited investigationFinal reportLuscombe 8 · Marlboro, NJThe pilot's inadequate in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB GAA16CA413Accident · Minor injuriesData collectionFinal reportCessna 172 · Cross Keys, NJThe pilot's failure to maintain lateral bank control during final approach, which resulted with an impact with a tree and substantial damage to the left and right wings.NTSB ERA15FA348Accident · 1 fatalField investigationFinal reportAerofab Lake LA-4-250 · Somerset, NJThe pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…NTSB ERA15LA274Accident · No injuriesLimited investigationFinal reportCessna 172S · Linden, NJThe pilot’s delayed decision to reject the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot’s failure to properly configure the flaps for maximum takeoff performance with the airplane near its maximum gross weight.NTSB ERA14CA216Accident · No injuriesData collectionFinal reportAgusta Aerospace AW119 Mkii · Lumberton, NJThe flightcrew's improper recovery from a simulated engine failure after takeoff. Contributing to the accident was the flight instructor's failure to clarify who had control of the helicopter.NTSB ERA12CA427Accident · No injuriesData collectionFinal reportCessna 182A · Sussex, NJThe pilot’s delayed decision to abort the landing and perform a go-around, which resulted in a runway overrun.NTSB ERA11CA356Accident · No injuriesData collectionFinal reportCessna A185F · Trinca, NJThe pilot's failure to maintain directional control, and the flight instructor's inadequate remedial action, which resulted in a ground-loop.NTSB OPS08IA009Incident · No injuriesIncident investigationFinal reportLearjet 45 · Teterboro, NJThe local air traffic controller's failure to follow published procedures and directives, resulting in a landing airplane coming in close proximity to runway workers.NTSB MIA08CA072Accident · No injuriesData collectionFinal reportEurocopter France AS350B1 · Linden, NJThe pilot's improper preflight preparation and his failure to maintain control of the helicopter.