NTSB investigations, 1981, NJ

19 cases where the phase of flight was Landing.

Cases per year

19632026
NTSB investigations, 1981, 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\") = 1981
    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 NYC82DHA07Accident · No injuriesClosedCessna 150 · Blairstown, NJDec 20, 1981 · N1650Q · Substantial damageNTSB NYC82DHA04Accident · No injuriesClosedCessna 152 · Manville, NJNov 27, 1981 · N89301 · Substantial damageNTSB NYC82DHD04Accident · No injuriesClosedCessna 152 · Toms River, NJNov 8, 1981 · N89132 · Substantial damageNTSB NYC82FHA01Accident · No injuriesClosedCessna 210 · Blairstown, NJOct 17, 1981 · N9605T · Substantial damageNTSB NYC82FHD03Accident · No injuriesClosedPiper PA-20 · Atlantic City, NJOct 15, 1981 · N7396K · Substantial damageNTSB NYC81FHM16Accident · No injuriesClosedCessna 150M · Caldwell, NJSep 20, 1981 · N7614U · Substantial damageNTSB NYC81DHA22Accident · Minor injuriesClosedSchweizer 1-23H · Blairstown, NJSep 9, 1981 · N8622R · Substantial damageNTSB NYC81DHD37Accident · Minor injuriesClosedPiper PA-28R · Manahawkin, NJSep 4, 1981 · N6SD · DestroyedNTSB NYC81DHD35Accident · No injuriesClosedPiper PA-28R · Robbinsville, NJAug 7, 1981 · N3978X · Substantial damageNTSB NYC81FHD31Accident · No injuriesClosedPiper PA-28R · Lumberton, NJJul 29, 1981 · N3737T · Substantial damageNTSB NYC81FHM14Accident · No injuriesClosedPiper PA-18 · Colts Neck, NJJul 7, 1981 · N6879B · Substantial damageNTSB NYC81FA064Accident · No injuriesClosedMooney M20K · Atlantic City, NJJun 24, 1981 · N231AN · Substantial damageNTSB NYC81DA065Accident · No injuriesClosedCessna 182 · Pittstown, NJJun 23, 1981 · N1539M · Substantial damageNTSB NYC81IA059Incident · No injuriesClosedPiper PA-34 · Newark, NJJun 16, 1981 · N7678C · Minor damageNTSB DCA81IA016Incident · No injuriesClosedDehavilland DHC-7 · Atlantic City, NJJun 10, 1981 · C-GNBX-X · Minor damageNTSB NYC81FHM07Accident · No injuriesClosedPiper PA-28 · New Milford, NJMay 25, 1981 · N2257Q · Substantial damageNTSB NYC81FHD26Accident · No injuriesClosedStearman PT-17 · Salem, NJMay 22, 1981 · N92X · DestroyedNTSB NYC81FHM06Accident · Minor injuriesClosedPiper PA-28 · West Milford, NJMay 18, 1981 · N2049A · Substantial damageNTSB NYC81FHD20Accident · No injuriesClosedPorterfield FP-65 · Robbinsville, NJApr 27, 1981 · N117F · Substantial damage