NTSB investigations, 2010, NJ

7 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2010, NJ per year, 2008–2026: 128 cases
200812
200910
20107
20117
20129
20137
201410
20157
20168
201713
201810
20194
20202
20215
20225
20233
20244
20253
20262

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\") = 2010
    AND 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\" = '470' 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.

NTSB ERA11LA093Accident · Serious injuriesLimited investigationFinal reportCessna 182 · West Milford, NJThe pilot's delayed application of carburetor heat while taking off in weather conditions conducive to serious carburetor icing, which resulted in a partial loss of engine power.Dec 18, 2010 · N1462M · Substantial damageNTSB ERA10LA437Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Williamstown, NJThe partial loss of engine power during takeoff due to weak spark plugs on the No. 1 cylinder.Aug 21, 2010 · N209RC · Substantial damageNTSB ERA10FA347Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Fairfield, NJThe pilot's failure to maintain aircraft control during the go-around following a hard landing. Contributing to the accident was the pilot's continuance of an unstabilized final approach and the improper use of flaps during the go-around.Jul 5, 2010 · N764CD · Substantial damageNTSB ERA10LA322Accident · Serious injuriesLimited investigationFinal reportCessna 172N · West Milford, NJThe student pilot’s control interference which resulted in a landing with a higher than normal airspeed, and the commercial pilot’s failure to initiate a go-around to avoid the runway overrun.Jun 20, 2010 · N738QZ · Substantial damageNTSB ERA10CA304Accident · No injuriesData collectionFinal reportCessna 305A · Toms River, NJThe pilot-in-command's loss of airplane control during landing, which resulted in a ground-loop.Jun 8, 2010 · N5075K · Substantial damageNTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.Apr 3, 2010 · N5528T · Substantial damageNTSB ERA10FA140Accident · 5 fatalField investigationFinal reportCessna T337G · Farmingdale, NJThe pilots’ failure to adhere to the airplane’s operating limitations, which resulted in overload failure of the right wing. Findings of the investigation were the adverse effects of multiple supplemental type certificates (STC) to the airframe wing structure…Feb 15, 2010 · N12NA · Substantial damage