OpenAirDocs.org

NTSB investigations, ME

13 cases where the phase of flight was Standing.

Cases per year

19652026

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\" = 'ME' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 150)
  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 ERA15CA095Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, METhe pilot's failure to properly set the throttle prior to engine start, which resulted in a loss of control and collision with parked airplanes.Jan 7, 2015 · N70037 · Substantial damageNTSB NYC06IA226Incident · No injuriesIncident investigationFinal reportCessna 206F · Matinicus Islnd, MEAn engine kick back of undetermined origin during engine start.Sep 1, 2006 · N8411Q · Minor damageNTSB NYC04LA060Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sanford, MEAn engine fire for undetermined reasons during start-up.Jan 25, 2004 · N6234M · DestroyedNTSB NYC00LA070Accident · No injuriesLimited investigationFinal reportCessna 150 · Wiscasset, METhe pilot's inadequate preflight inspection.Jan 29, 2000 · N7854E · Substantial damageNTSB NYC94LA041Accident · No injuriesLimited investigationFinal reportCessna 172N · Bar Harbor, MEA disconnected fuel line with the carburetor not installed, and improper dispatch of the aircraft.Dec 17, 1993 · N5753E · Substantial damageNTSB NYC88LA208Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Auburn-Lewiston, METhe student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170.Aug 3, 1988 · N169WS · Substantial damageNTSB NYC87LA168Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Sanford, METhe acft was being hand propped from behind the prop on the rgt side when the eng started. The plane jumped the chock, knocked the plt to the ground, turned to the rgt & collided with a parked acft in the tie-down area. The acft was not tied down & only the…Apr 22, 1987 · N58032 · Substantial damageNTSB NYC78FNC51Accident · Serious injuriesClosedCessna 172M · Old Town, MESep 17, 1978 · N9604H · No damageNTSB NYC76AN068Accident · 1 fatalClosedPiper PA-28R · Auburn, MEJan 24, 1976 · N2074T · No damageNTSB NYC72FNC21Incident · 1 fatalClosedStinson 108-3 · Princeton, MEJan 7, 1972 · N6070M · Minor damageNTSB NYC69A0094Accident · No injuriesClosedPiper PA-23 · Portland, MEApr 18, 1969 · N5090Y · Substantial damageNTSB NYC68D0145Accident · No injuriesClosedTaylorcraft BC12-D · Bethel, MEAug 21, 1967 · N24321 · 2 aircraft · Substantial damageNTSB NYC66F0044Accident · No injuriesClosedTaylorcraft BL-65 · Harrison, MEJun 17, 1965 · N27672 · Substantial damage