NTSB investigations, 2018, NJ

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

Cases per year

20082026
NTSB investigations, 2018, 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\") = 2018
    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 GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.Dec 30, 2018 · N2651R · Substantial damageNTSB ERA19LA062Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Paramus, NJMaintenance personnel's improper assembly of the engine during overhaul, which resulted in lubrication restriction due to a bearing shift and the subsequent engine failure.Dec 9, 2018 · N5756W · Substantial damageNTSB ERA19TA042Accident · Serious injuriesClass 3Final reportMooney M20C · Wildwood, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation during the initial climb. Contributing to the accident was the pilot’s decision to initiate a 180° turn following the loss of power.Nov 10, 2018 · N78870 · Substantial damageNTSB ERA19FA023Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Woodbine, NJThe pilot's failure to maintain the proper airspeed during takeoff, which resulted in the exceedance of the airplane’s critical angle of attack and the airplane experiencing an aerodynamic stall.Oct 23, 2018 · N9667M · DestroyedNTSB 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.Sep 15, 2018 · N7304T · Substantial damageNTSB 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.Aug 10, 2018 · N92TR · Substantial damageNTSB ERA18LA210Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power due to the formation of carburetor ice, a forced landing and impact with terrain.Aug 4, 2018 · N87000 · Substantial damageNTSB ERA18FA167Accident · 2 fatalField investigationFinal reportRaytheon 58 · Springfield Township, NJA loss of control due to spatial disorientation while climbing after departure in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument experience.Jun 13, 2018 · N218BL · DestroyedNTSB ERA18FA138Accident · 1 fatalField investigationFinal reportPiper PA32 · West Milford, NJAn in-flight fire and total loss of engine power after takeoff due to a loose fuel line. Contributing to the accident was the installation of an unapproved fuel line by unknown personnel.May 2, 2018 · N4153R · DestroyedNTSB WPR18LA125Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Andover, NJA partial loss of engine power for undetermined reasons.Apr 23, 2018 · N8737V · Substantial damage