NTSB investigations, 2011, NJ

9 cases where the phase of flight was Landing.

Cases per year

19632026
NTSB investigations, 2011, 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\") = 2011
    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 ERA12CA083Accident · Minor injuriesData collectionFinal reportCessna 162 · Lincoln Park, NJThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control, a runway excursion, and collision with trees.Nov 25, 2011 · N5216J · Substantial damageNTSB ERA12CA004Accident · No injuriesData collectionFinal reportCessna 182P · Lincoln Park, NJThe pilot's improper landing flare.Oct 2, 2011 · N1835M · Substantial damageNTSB ERA11LA421Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJThe pilot’s improper touchdown point, resulting in a runway overrun and collision with a guardrail.Jul 23, 2011 · N869BC · Substantial damageNTSB ERA11LA390Accident · Serious injuriesLimited investigationFinal reportAero Vodochody L39C · West Milford, NJThe pilot's excessive airspeed and failure to attain the proper landing point, which resulted in the airplane touching down too fast and too far down the short runway. Contributing to the accident was the pilot's failure to retract the flaps after landing,…Jul 9, 2011 · N111XN · Substantial damageNTSB ERA11CA358Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Linwood, NJThe pilot's improper brake application during the landing roll which resulted in a nose over.Jun 20, 2011 · N87020 · Substantial damageNTSB ERA11CA356Accident · No injuriesData collectionFinal reportCessna A185F · Trinca, NJThe pilot's failure to maintain directional control, and the flight instructor's inadequate remedial action, which resulted in a ground-loop.Jun 18, 2011 · N714TX · Substantial damageNTSB ERA11CA280Accident · No injuriesData collectionFinal reportBombardier BD700 1A10 · Teterboro, NJThe pilot's loss of aircraft control during landing in gusty wind conditions.Apr 21, 2011 · N113CS · Substantial damageNTSB ERA11CA193Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Pittstown, NJThe student pilot's inadequate flare and the certified flight instructor's inadequate remedial action, which resulted in a hard landing.Mar 8, 2011 · N470Q · Substantial damageNTSB ERA11CA171Accident · No injuriesData collectionFinal reportAerostar PA-60-601P · Princeton, NJThe pilot’s failure to stop the airplane resulting in a runway overrun.Feb 25, 2011 · N444TT · Substantial damage