NTSB investigations, ME

310 cases where the phase of flight was Landing.

Cases, newest first

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 = 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 ERA09CA416Accident · Minor injuriesData collectionFinal reportMaule M7 · Turner, METhe pilot's failure to maintain aircraft control during the landing rollout.Jul 23, 2009 · N595Z · Substantial damageNTSB ERA09CA309Accident · No injuriesData collectionFinal reportCessna 172A · Glenburn, METhe pilot's misjudgment of distance and speed during landing.May 26, 2009 · N6843X · Substantial damageNTSB ERA09CA252Accident · No injuriesData collectionFinal reportCessna/Air Repair 305F · Embden, METhe pilot's failure to obtain the proper touchdown point while landing.Apr 18, 2009 · N60537 · Substantial damageNTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.Sep 20, 2008 · N2318T · Substantial damageNTSB NYC08CA101Accident · No injuriesData collectionFinal reportCessna 182K · Greenville, METhe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the snow covered runway and sun glare light conditions.Feb 15, 2008 · N3047Q · Substantial damageNTSB MIA08CA037Accident · No injuriesData collectionFinal reportCessna 170A · Ellsworth, METhe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's selection of an unsuitable landing area.Jan 6, 2008 · N5407C · Substantial damageNTSB ANC08LA007Accident · No injuriesLimited investigationFinal reportCessna 172M · Rangeley, METhe pilot's failure to maintain aircraft control during the landing flare/touchdown. A factor contributing to the accident was the pilot's diverted attention.Oct 18, 2007 · N92737 · Substantial damageNTSB ATL07LA110Accident · 1 fatalLimited investigationFinal reportCessna T206H · Lovell, METhe pilot's failure to retract the amphibious floatplane's landing gear during a water landing.Aug 4, 2007 · N206MW · Substantial damageNTSB NYC07CA150Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Machias, METhe pilot's inadequate in-flight planning.Jun 26, 2007 · N5457P · Substantial damageNTSB NYC07LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Livermore Falls, METhe pilot's failure to maintain directional control during landing, which resulted in a groundloop.Dec 3, 2006 · N8019F · Substantial damageNTSB NYC06CA084Accident · No injuriesData collectionFinal reportCessna 180F · Greenville, METhe pilot's failure to maintain directional control during landing, resulting in a ground loop. A factor was the rough/uneven runway condition.Mar 25, 2006 · N2165Z · Substantial damageNTSB NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.Feb 15, 2006 · N47105 · Substantial damageNTSB NYC05LA142Accident · No injuriesLimited investigationFinal reportRaytheon BE-390 · Rockland, METhe pilot's failure to maintain aircraft control during landing.Sep 15, 2005 · N701DF · Substantial damageNTSB IAD05CA128Accident · No injuriesData collectionFinal reportPresley RV-4 · Biddeford, METhe pilot's failure to maintain directional control. Contributing to the accident was the wind gusts.Aug 27, 2005 · N228X · Substantial damageNTSB IAD05CA117Accident · Minor injuriesData collectionFinal reportCessna C-172G · Eustis, METhe pilot's failure to maintain clearance from a bush during the aborted landing.Aug 5, 2005 · N5924R · Substantial damageNTSB IAD04CA038Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Eliot, METhe pilot's failure to maintain airspeed above stall which resulted in a hard landing and collapse of the landing gear. Also causal was the flight instructor's inadequate supervision.Aug 17, 2004 · N4631J · Substantial damageNTSB NYC04CA190Accident · Serious injuriesData collectionFinal reportClassic Waco YMF · Bar Harbor, METhe pilot's inadequate compensation for wind conditions. A factor was the crosswind.Aug 9, 2004 · N723SR · Substantial damageNTSB IAD04LA029Accident · No injuriesLimited investigationFinal reportCessna 421B · Portland, MEFailure of the right main landing gear down-lock mechanism resulting in the collapse of the right main landing gear.Jul 2, 2004 · N421KS · Substantial damageNTSB NYC04LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Turner, METhe pilot's misjudgment of speed/distance and the delayed aborted landing. A factor in this accident was the tail wind condition.Mar 14, 2004 · N7872G · Substantial damageNTSB NYC03LA210Accident · No injuriesLimited investigationFinal reportSimoneau Kitfox Classic IV · Limington, METhe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the pilot's lack of experience in make and model.Sep 14, 2003 · N10224 · Substantial damageNTSB IAD03CA072Accident · No injuriesData collectionFinal reportCessna C-170 · Kennebunkport, METhe pilot's failure to obtain the proper touchdown point, which resulted in the abrupt maneuver and subsequent failure of the landing gear.Aug 31, 2003 · N11576 · Substantial damageNTSB NYC03LA178Accident · No injuriesLimited investigationFinal reportAerofab Lake 250 · Phippsburg, METhe airplane's collision with a submerged object during a water landing.Aug 17, 2003 · N8550U · Substantial damageNTSB NYC03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Turner, METhe pilot's misjudgment of distance which resulted in an overrun.Nov 9, 2002 · N223T · Substantial damageNTSB IAD03LA009Accident · No injuriesLimited investigationFinal reportCessna 185 · Waterville, METhe pilot's excessive braking during the landing roll, which resulted in a nose over. A factor was the quartering tailwind.Oct 22, 2002 · N7321H · Substantial damageNTSB NYC03FA002Accident · Serious injuriesField investigationFinal reportCessna 525A · Dexter, MEwas the pilot's improper decision to land with excessive speed, and his delayed decision to perform an aborted landing, both of which resulted in a runway overrun. A factor was the tail wind.Oct 7, 2002 · N57EJ · Substantial damageNTSB IAD02LA019Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Livermore Falls, METhe pilot's failure to maintain proper altitude clearance while landing, which resulted in a collision with trees. A factor was the crosswind.Dec 7, 2001 · N40621 · Substantial damageNTSB NYC02LA023Accident · No injuriesLimited investigationFinal reportBeech 1900C · Bar Harbor, MEA deer, which had been crossing the runway as the airplane touched down. A factor was the dark night conditions.Nov 2, 2001 · N210CJ · Substantial damageNTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.Aug 25, 2001 · N2009A · Substantial damageNTSB NYC00LA193Accident · No injuriesLimited investigationFinal reportCessna U206G · North Haven, METhe pilot's failure to perform a go-around. Factors related to the accident were the pilot's lack of total flight experience in make and model, and the short landing area.Jul 6, 2000 · N756HK · Substantial damageNTSB NYC00LA168Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Turner, METhe pilot's failure to maintain directional control after landing. A factor in this accident was the high grass along the runway edge which disguised an embankment.Jun 17, 2000 · N2063N · Substantial damageNTSB NYC00LA143Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Pittsfield, METhe pilot's improper use of unsuitable terrain for landing. A factor in the accident was the soft terrain.May 26, 2000 · N8872 · Substantial damageNTSB NYC00LA025Accident · Serious injuriesLimited investigationFinal reportKnox HI-MAX · Dixfield, METhe pilot's failure to obtain the proper touchdown point. A factor in the accident was the pilot's lack of experience in make and model.Nov 5, 1999 · N63307 · Substantial damageNTSB NYC00LA003Accident · No injuriesLimited investigationFinal reportPiper PA-60-700P · Greenville, METhe pilot's inadequate preflight planning and his inadequate visual lookout.Oct 3, 1999 · N407SA · Substantial damageNTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.Sep 13, 1999 · N5337L · Substantial damageNTSB IAD99LA073Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Limington, MEPilot's failure to maintain directional control during the landing rollout.Feb 14, 1999 · N10730 · Substantial damageNTSB NYC98LA176Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bingham, METhe pilot's inattention to changing wind conditions, and lack of correction for the change. A factor in the accident was the damp grass runway.Aug 28, 1998 · N735PS · Substantial damageNTSB NYC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185 · Norway, METhe pilot's failure to maintain control of the airplane while maneuvering to avoid an obstacle.Jul 25, 1997 · N8717Z · Substantial damageNTSB NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.Sep 1, 1996 · N2009A · Substantial damageNTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.Jan 16, 1996 · N913A · Substantial damageNTSB NYC96LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Sanford, MEthe pilot's failure to adequately compensate for a crosswind during the landing roll, which resulted in a collision with a snowbank. Factors relating to the accident were: ice on the runway and the gusty crosswind condition.Dec 12, 1995 · N734QZ · Substantial damageNTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.Aug 18, 1995 · N16915 · DestroyedNTSB NYC95LA094Accident · No injuriesLimited investigationFinal reportCessna 172G · Augusta, METhe student pilot's delay in aborting the landing attempt. The crosswind, and the pilot's inadequate compensation for the crosswind were factors.Apr 25, 1995 · N3799L · Substantial damageNTSB NYC95LA093Accident · No injuriesLimited investigationFinal reportCessna 185 · Bangor, MEthe pilot's improper flare, which resulted in a hard landing and collapse of the right main gear.Apr 24, 1995 · N62EC · Substantial damageNTSB BFO95LA007Accident · No injuriesLimited investigationFinal reportCessna A185F · N New Portland, METhe pilot's failure to verify the landing gear was in the proper position for landing.Oct 23, 1994 · N9667Q · Substantial damageNTSB BFO94LA148Accident · No injuriesLimited investigationFinal reportPiper PA -28-181 · Skowhegan, METhe pilot's failure to do a go around which resulted in an inflight collision with trees during a delayed aborted landing to avoid a runway overrun.Aug 25, 1994 · N11HK · Substantial damageNTSB BFO94LA115Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Orrington, METhe pilot misjudged his altitude and airspeed which resulted in a hard landing. Related factors were the soft, and upslope field.Jun 18, 1994 · N2000U · Substantial damageNTSB BFO94LA020Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Rockland, ME1) The pilot's failure to maintain adequate rotor RPM, 2) the pilot's failure to maintain directional control on landing, resulting in a dynamic rollover.Nov 27, 1993 · N8380J · Substantial damageNTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.Aug 8, 1993 · N25211 · Substantial damageNTSB BFO93LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150J · East Corinth, METhe pilot's misjudgement of airspeed while making a precautionary landing without airspeed indication, and the block pitot tube.Jul 13, 1993 · N50896 · Substantial damageNTSB BFO93LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsfield, MELoss of the tail wheel steering due to undetermined reason(s).Jul 5, 1993 · N61058 · Substantial damage