OpenAirDocs.org

NTSB investigations, NY

23 cases where the phase of flight was Unknown.

Cases per year

19642026

Where

Open the map

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 c.\"eventStateOrRegion\" = 'NY' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 990)
  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 CEN23FA204Accident · 2 fatalClass 3 · FieldFinal reportLuce Buttercup · Lyndonville, NYAn in-flight breakup due to structural overload of the airplane for undetermined reasons.May 28, 2023 · N18263 · DestroyedNTSB ERA22LA287Accident · Serious injuriesClass 3 · LimitedFinal reportMantell Allan T Lightning · Canandaigua, NYThe pilot’s performance of an off-airport landing shortly after takeoff for reasons that could not be determined.Jun 21, 2022 · N51TM · Minor damageNTSB ERA22LA029Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Westhampton Beach, NYA total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.Oct 23, 2021 · N1188L · Substantial damageNTSB ERA12LA360Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Kingston, NYThe pilot’s failure to maintain adequate clearance from trees/foliage at an undetermined point during the flight.May 19, 2012 · N6236C · Substantial damageNTSB NYC07FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-260 · Westhampton, NYUndetermined. The airplane remains missing.Aug 25, 2007 · N5067T · DestroyedNTSB NYC98FA107Accident · 2 fatalField investigationFinal reportErcoupe ERCO-415C · New Lisbon, NYDetonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…May 16, 1998 · N3230H · DestroyedNTSB BFO94LA085Accident · 1 fatalLimited investigationFinal reportPecchio Marchetti 263MP · East Moriches, NYthe loss of control for undetermined reasons resulting in an uncontrolled descent and a subsequent collision with trees.Jun 2, 1994 · N263MP · DestroyedNTSB NYC90GA105Accident · 4 fatalFinal reportBellanca 17-31A · Davis Park, NYThe airplane impacting the water at a high speed for unknown reason(s).May 12, 1990 · N7SF · DestroyedNTSB ATL88IA117Incident · No injuriesIncident investigationFinal reportAero Commander 680E · New York, NYThe airplane had been given a daily insp on 03-10-88 with no structural damage noted. During the next daily inspection on 03-14-88, skin buckling was noted on both wings. Three different pilots had flown the airplane between inspections and all indicated that…Mar 14, 1988 · N50 · Minor damageNTSB NYC87FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310 · Hamburg, NYThe Cessna 310R departed the airport on a svfr departure. The pilot cancelled his clearance a few minutes later and reported in VFR conditions. The aircraft failed to arrive at its destination. Radar tracking showed the aircraft heading toward lake erie. The…Dec 31, 1986 · N5462J · DestroyedNTSB NYC86FA140Accident · 2 fatalField investigationFinal reportAeronca 7AC · Chaumont, NYThe pilot departed his private strip and crashed about 5 minutes later in a steep nose down attitude. Over 50 per cent of the fluid in the carburetor was a contaminant.Jun 5, 1986 · N82079 · DestroyedNTSB NYC86FA002Accident · 3 fatalField investigationFinal reportCessna C-377A · Breakabeen, NYThe plt was advised by several sources that bad wx was located along the intended route of flt. The plt stated that he intended to fly over the bad wx since wx at the destination was good. A mayday call from 24J was broadcasted over the emer. Freq. Witnesses…Oct 5, 1985 · N6524J · DestroyedNTSB NYC84FA107Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Scriba, NYAcft was located, after a 4 day search, in a gravel pit 8 miles from point of departure. Wreckage examination revealed acft collided with terrain in vertical descent with nil forward speed. Investigation of power plant revealed no evidence of torque or power…Mar 8, 1984 · N5649L · DestroyedNTSB NYC83FFJ03Accident · 1 fatalFinal reportSopwith Triplane · Allegany, NYThe owner/plt of the home built, Sopwith triplane took off on a local flt. This was the 1st flt since some maintenance rework & a new propeller installation. After the acft was airborne for aprx 20 min, it was observed flying at about 500 ft AGL. Reportedly,…Jul 22, 1983 · N5004 · DestroyedNTSB NYC83FA083Accident · 1 fatalField investigationFinal reportGrumman AA-1 · Missing Acft, NYThe non-instrument rated pilot called ground control and requested a VFR departure. He was advised that the field was IFR and an IFR clearance was needed. The pilot filed an IFR flight plan and about 15 min later called for his clearance. He had trouble…Jul 12, 1982 · N5637L · DestroyedNTSB NYC82FHJ03Accident · No injuriesClosedPiper PA-30 · East Moriches, NYNov 5, 1981 · N755RY · DestroyedNTSB NYC78FA019Accident · 1 fatalClosedCessna 404 · Buffalo, NYDec 22, 1977 · N404SA · DestroyedNTSB NYC77FA098Accident · 2 fatalClosedPiper PA-28R · Montauk Point, NYSep 16, 1977 · N2375T · DestroyedNTSB NYC69D0191Accident · No injuriesClosedCessna 172 · Oriskany, NYSep 30, 1968 · N7064T · DestroyedNTSB NYC69A0010Accident · 1 fatalClosedBeech 35-33 · Peterboro, NYJul 19, 1968 · N832R · DestroyedNTSB NYC65A0108Accident · 1 fatalClosedPiper PA-23 · Delancey, NYFeb 19, 1965 · N4827P · DestroyedNTSB NYC65A0105Accident · 2 fatalClosedBeechcraft B-35 · South Beach, NYFeb 14, 1965 · N2151D · DestroyedNTSB UNK65X0904Incident · No injuriesClosedBoeing 727 · Flushing, NYDec 2, 1964 · N7025U · Minor damage