NTSB investigations, NJ
17 cases where the sequence of events included Attempted remediation/recovery.
Cases per year
| 2008 | 2 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 5 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 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\" = '060' 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" = '060' 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 ERA22LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Pemberton Township, NJThe pilot’s improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of control.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 GAA19CA322Accident · No injuriesData collectionFinal reportCirrus SR22 · Trenton, NJThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a runway excursion and subsequent substantial damage.NTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB GAA18CA556Accident · No injuriesData collectionFinal reportCessna R182 · Mount Holly, NJThe pilot’s failure to maintain lateral control of the airplane during landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA18CA024Accident · No injuriesData collectionFinal reportCessna 172 · Old Bridge, NJThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA17LA205Accident · Minor injuriesLimited investigationFinal reportCessna P206 · West Creek, NJThe pilot's improper fuel management, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB GAA17CA253Accident · No injuriesData collectionFinal reportCirrus SR20 · Lakewood, NJThe student pilot’s failure to adequately compensate for crosswind conditions during a go-around and the flight instructor’s delayed remedial action.NTSB ERA17LA110Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Bayonne, NJMaintenance personnel’s incorrect installation of the No. 3 cylinder’s hydraulic valve tappet plunger, which resulted in a failure of the No. 3 cylinder’s intake valve and the subsequent partial loss of engine power.NTSB ERA16FA325Accident · 2 fatalField investigationFinal reportMooney M20J · Pittstown, NJThe pilot's improper landing touchdown attitude, which resulted in a propeller strike, and his inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and led to an aerodynamic stall during…NTSB GAA15CA277Accident · No injuriesData collectionFinal reportMooney M20M · Manville, NJThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a fence.NTSB ERA14CA394Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · Readington, NJThe pilot's failure to maintain aircraft control during landing which resulted in an aircraft nose-over.NTSB ERA12CA204Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCAA · Bedminster, NJThe pilot receiving instruction’s inadvertent movement of the pitch trim control to the nose-down position while attempting a go-around.NTSB ERA11CA236Accident · No injuriesData collectionFinal reportCessna 172N · Millville, NJThe pilot’s improper recovery from a bounced landing which resulted in a loss of aircraft control during the go-around.NTSB MIA08LA199Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Linden, NJThe flight instructor’s delayed remedial action (flight control inputs) during a practice autorotation/run-on landing resulting in fracture damage to the main rotor system Starflex.NTSB MIA08LA166Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Woodbine, NJThe student pilot's failure to maintain airspeed during a go-around. Contributing to the accident was the student pilot's degraded emotional/mental state due to stress.