NTSB investigations, 2002, NJ

18 cases where the phase of flight was Landing.

Cases per year

19632026
NTSB investigations, 2002, NJ per year, 1963–2026: 961 cases
19631
196445
196571
196674
196759
196823
196932
197038
197127
197231
197322
197426
197522
197616
19779
197821
197915
198020
198119
198219
198313
198411
198516
19869
198716
198815
19897
19905
199110
199216
199315
19946
19957
19967
199716
199811
199911
200011
20018
200218
20034
20043
200515
20069
20072
20088
20099
20106
20119
20129
20136
20149
20152
20167
20178
20183
20197
20203
20217
20224
20232
20242
20254
20265

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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\") = 2002
    AND c.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  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 NYC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Blairstown, NJThe pilot's failure to maintain directional control during the landing roll.Dec 30, 2002 · N6780B · Substantial damageNTSB IAD03LA014Accident · No injuriesLimited investigationFinal reportCessna 182P · Lincoln Park, NJThe student pilot's improper power management during the short-field landing procedure, and the flight instructor's delayed remedial action.Nov 12, 2002 · N1835M · Substantial damageNTSB NYC02FA171Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Andover, NJThe flight instructor's delayed remedial action to correct the low rotor condition. A factor was the student pilot's improper use of the collective, which created the low rotor condition.Aug 21, 2002 · N6147L · Substantial damageNTSB NYC02LA157Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Atlantic City, NJThe pilot's improper flare during approach.Aug 3, 2002 · N44EK · Substantial damageNTSB NYC02LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · West Milford, NJThe flight instructor's improper recovery from a bounced landing.Jul 11, 2002 · N1502E · Substantial damageNTSB NYC02LA137Accident · No injuriesLimited investigationFinal reportCessna 177 · Millville, NJThe pilot's improper bounced landing recovery. A factor was the dark night conditions.Jul 5, 2002 · N29321 · Substantial damageNTSB IAD02LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Ocean City, NJThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind. A factor was a wind gust.Jul 4, 2002 · N58166 · Substantial damageNTSB NYC02LA107Accident · No injuriesLimited investigationFinal reportKarl & Dot Comp Air 7SL · Cross Keys, NJFatigue fracture of the tail wheel spring, which resulted in a loss of control and impact with a ditch.Jun 1, 2002 · N753KD · Substantial damageNTSB IAD02LA054Accident · Minor injuriesLimited investigationFinal reportMiller Barnet J4B-2 · Manville, NJThe pilot's improper flare prior to touchdown. A factor was the pilot's lack of experience in aircraft type, make, and model.May 26, 2002 · N8121M · Substantial damageNTSB NYC02LA093Accident · No injuriesLimited investigationFinal reportD'Apuzzo D-260 · Andover, NJThe pilot's failure to obtain proper runway alignment while landing, which resulted in a gear collapse.May 5, 2002 · N112JF · Substantial damageNTSB NYC02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Teterboro, NJThe pilot's improper flare and his improper recovery from a bounced landing, which resulted in a hard landing. A factor in this accident was the crosswind condition.May 1, 2002 · N4468N · Substantial damageNTSB NYC02LA090Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Blairstown, NJThe pilot's improper flare, and his failure to maintain obstacle clearance which resulted in a tail strike.May 1, 2002 · N37731 · Substantial damageNTSB IAD02LA045Accident · No injuriesLimited investigationFinal reportCessna P210N · Linden, NJThe pilot's failure to lower the landing gear prior to landing.Apr 20, 2002 · N734VS · Substantial damageNTSB NYC02LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Matawan, NJThe pilot's inadequate weather evaluation, and excessive airspeed while landing. A factor was a tailwind.Apr 18, 2002 · N4737L · Substantial damageNTSB NYC02LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Belmar, NJThe student pilot's failure to maintain runway alignment during landing. A factor in the accident was the winds.Apr 2, 2002 · N44636 · Substantial damageNTSB IAD02LA038Accident · No injuriesLimited investigationFinal reportCessna 172P · Ocean City, NJThe pilot's inadequate compensation for wind and his failure to maintain directional control.Mar 24, 2002 · N9847L · Substantial damageNTSB NYC02LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Atlantic City, NJThe pilot's failure to lower the landing gear prior to landing.Feb 23, 2002 · N9055P · Substantial damageNTSB NYC02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point.Feb 23, 2002 · N9182X · Substantial damage