NTSB investigations, 2000, NJ

11 cases where the phase of flight was Landing.

Cases per year

19632026
NTSB investigations, 2000, 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\") = 2000
    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 NYC00LA259Accident · No injuriesLimited investigationFinal reportMihlebach Waco · Williamstown, NJThe pilot's failure to execute an adequate flare, which resulted in a hard landing.Sep 2, 2000 · N521S · Substantial damageNTSB NYC00LA218Accident · No injuriesLimited investigationFinal reportBeech BE-58 · West Milford, NJThe pilot's failure to maintain directional control during the landing flare and touchdown, which resulted in a blown tire, and a continued loss of directional control during the landing roll.Aug 6, 2000 · N58TZ · Substantial damageNTSB IAD00LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Princeton, NJthe student pilot's failure to maintain control of the airplane during the aborted landing.Jul 29, 2000 · N65827 · Substantial damageNTSB NYC00LA187Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wildwood, NJan improper flare by the pilot which induced an overload failure on the left side landing gear bolts. Factors were the corrosion on the bolts, and the failure of the operator to change the u-bolt in accordance with the manufacturer's recommendations.Jul 6, 2000 · N10989 · Substantial damageNTSB NYC00LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Robbinsville, NJThe pilot's inadequate compensation for wind conditions, which resulted in a loss of aircraft control. A factor was a crosswind.Jun 25, 2000 · N36355 · Substantial damageNTSB NYC00LA148Accident · No injuriesLimited investigationFinal reportBeech 19 · West Milford, NJThe pilot's failure to maintain directional control during the aborted landing.Jun 1, 2000 · N100RF · Substantial damageNTSB NYC00LA145Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Hammonton, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the crosswind condition.May 26, 2000 · N16FJ · Substantial damageNTSB IAD00LA030Accident · Serious injuriesLimited investigationFinal reportMaule M-4-220C · Lincoln Park, NJthe pilot's failure to maintain control during landing roll. A factor was the crosswind.Mar 31, 2000 · N2060U · Substantial damageNTSB NYC00LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · West Milford, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the gusty crosswind conditions.Mar 5, 2000 · N2761M · Substantial damageNTSB NYC00LA074Accident · No injuriesLimited investigationFinal reportGrumman American AA1 · Wildwood, NJThe student pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.Feb 7, 2000 · N9555U · Substantial damageNTSB NYC00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Vincentown, NJThe CFI's delay in remedial action after the student pilot lost control of the airplane. A factor in the accident was the CFI's lack of total experience in flight instruction.Feb 6, 2000 · N624FL · Substantial damage