NTSB investigations, MN

1,030 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\" = 'MN' 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 CEN13CA508Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Faribault, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 25, 2013 · N4888Z · Substantial damageNTSB CEN13LA462Accident · No injuriesLimited investigationFinal reportEmbraer S A EMB-505 · Eden Prairie, MNThe flight crew's failure to execute a go-around during a non-stabilized approach, which resulted in a runway overrun.Aug 5, 2013 · N327FL · Substantial damageNTSB CEN13CA400Accident · No injuriesData collectionFinal reportCessna 120 · Lakeville, MNThe student pilot's excessive application of the brakes during the landing roll and the flight instructor's delayed remedial action, which resulted in a nose-over.Jul 8, 2013 · N2693N · Substantial damageNTSB CEN13LA376Accident · Serious injuriesLimited investigationFinal reportAvery Jack H Glastar GS-1 · Grand Rapids, MNThe loss of directional control during landing because the autopilot engaged for undetermined reasons because water and recovery damage precluded detailed examination of system components.Jun 25, 2013 · N103A · Substantial damageNTSB CEN13LA374Accident · No injuriesLimited investigationFinal reportAviat A-1B · Ely, MNThe pilot’s failure to maintain control of the amphibious airplane during the water landing.Jun 25, 2013 · N715SB · Substantial damageNTSB CEN13LA579Accident · Minor injuriesLimited investigationFinal reportBeech 58P · St Paul, MNThe pilot's failure to maintain directional control during a rejected landing, which resulted in a collision with an airport sign off the right side of the runway during the transition to the initial climb.Jun 16, 2013 · N5958P · Substantial damageNTSB CEN13CA284Accident · No injuriesData collectionFinal reportStinson 108-1 · Cambridge, MNThe pilot’s loss of directional control while landing with a gusting crosswind.May 17, 2013 · N8931K · Substantial damageNTSB CEN13LA261Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Staples, MNThe pilot’s misjudged landing flare, which resulted in a porpoised landing.May 6, 2013 · N161KT · Substantial damageNTSB CEN13CA247Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Owatonna, MNThe pilot’s loss of directional control during an aborted landing.Apr 27, 2013 · N7780N · Substantial damageNTSB CEN13CA230Accident · No injuriesData collectionFinal reportWing Harold Kitfox II · Blaine, MNThe pilot's improper touchdown and subsequent failure to maintain control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of experience in tailwheel-equipped airplanes.Apr 16, 2013 · N389HW · Substantial damageNTSB CEN13CA176Accident · No injuriesData collectionFinal reportCessna 172A · Vineland, MNThe pilot’s decision to attempt a touch-and-go landing on a narrow, ice-covered road with snow banks on each side.Feb 24, 2013 · N76NG · Substantial damageNTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.Jan 11, 2013 · N110BA · Substantial damageNTSB CEN13CA112Accident · No injuriesData collectionFinal reportCessna 172M · Eveleth, MNThe student pilot’s improper landing flare, which resulted in a hard nosewheel landing.Dec 21, 2012 · N9660H · Substantial damageNTSB CEN13IA059Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Minneapolis, MNLoose electrical connections to the hydraulic system and anomalies in the hydraulic shuttle valve and power pack, which resulted in an uncommanded gear unlock and collapse of the left main landing gear. Contributing to the accident was the operator’s failure…Nov 10, 2012 · N619BA · Minor damageNTSB CEN13CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Eden Prairie, MNThe pilot’s inadequate braking action and decision to abort the landing near the departure end of the runway. Contributing to the accident was the pilot’s attempt to land near the midpoint of the runway.Oct 2, 2012 · N750SR · Substantial damageNTSB CEN12LA584Accident · 1 fatalLimited investigationFinal reportTop Dog TD2 · Bemidji, MNThe pilot's failure to maintain aircraft control and his inadequate flare during landing. Contributing to the accident was the pilot’s failure to obtain training on the operation of the accident aircraft.Aug 27, 2012 · N71314 · Substantial damageNTSB CEN12CA461Accident · No injuriesData collectionFinal reportMooney M20K · Hutchinson, MNThe student pilot’s inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with obstructions.Jul 20, 2012 · N262RW · Substantial damageNTSB CEN12LA452Accident · Minor injuriesLimited investigationFinal reportMikoyan Gurevich MIG 21MF · Minneapolis, MNThe pilot's delayed application of wheel brakes to slow the airplane down on landing and the airplane’s failed drag chute, which resulted in a runway overrun.Jul 12, 2012 · N9307 · Substantial damageNTSB CEN12LA492Accident · No injuriesLimited investigationFinal reportMaule M-4 · Springfield, MNThe tailwheel spring's overload failure during landing, resulting in a ground loop and runway excursion.Jul 10, 2012 · N12026 · Substantial damageNTSB CEN12CA405Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Glencoe, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.Jun 18, 2012 · N59334 · Substantial damageNTSB CEN12LA333Accident · Serious injuriesLimited investigationFinal reportWalters RV-8 · Hutchinson, MNThe pilot's failure to maintain proper airspeed during the landing attempt, his failure to maintain directional control, and his delayed attempted aborted landing at an airspeed that was too low, which resulted in an aerodynamic stall.May 31, 2012 · N808WW · Substantial damageNTSB CEN12CA295Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Moorhead, MNThe failure to maintain adequate airspeed for the wind conditions during landing, which resulted in a loss of airplane control.May 9, 2012 · N9922P · Substantial damageNTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.Jan 13, 2012 · N262RW · Substantial damageNTSB CEN12LA113Accident · No injuriesLimited investigationFinal reportCessna 182J · St. Paul, MNThe pilot's decision to land on a runway with a gusting, quartering tailwind and his inadequate compensation for the wind, which resulted in a hard landing.Dec 26, 2011 · N2618F · Substantial damageNTSB CEN12CA065Accident · No injuriesData collectionFinal reportCessna 182J · Alexandria, MNThe pilot's failure to maintain directional control during the night landing.Nov 12, 2011 · N3051F · Substantial damageNTSB CEN12CA044Accident · No injuriesData collectionFinal reportAviat A-1 · Wolverton, MNThe pilot's inadvertent excessive braking during the landing roll due to momentary pain.Oct 20, 2011 · N93HU · Substantial damageNTSB CEN12CA009Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hibbing, MNThe private pilot's failure to maintain control of the helicopter during the landing flare.Oct 4, 2011 · N4170M · Substantial damageNTSB CEN11CA624Accident · No injuriesData collectionFinal reportCessna 172S · Bemidji, MNThe student pilot's improper flare, which resulted in a hard landing.Sep 5, 2011 · N548ND · Substantial damageNTSB CEN11CA398Accident · Serious injuriesData collectionFinal reportLindstrand LBL120A · Le Center, MNThe failure of the passenger to follow the pilot's instructions during landing, which caused the pilot to be ejected from the balloon and sustain serious injuries.Jun 17, 2011 · N5595L · Substantial damageNTSB CEN11LA328Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fredenberg Township, MNThe pilot's inadequate directional control during a crosswind landing.May 7, 2011 · N195T · Substantial damageNTSB CEN11TA279Accident · No injuriesFinal reportRockwell International 500-S · Eden Prairie, MNThe pilot's inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.Apr 8, 2011 · N51RF · Substantial damageNTSB CEN11LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNThe pilot's loss of directional control during the landing.Feb 12, 2011 · N536PU · Substantial damageNTSB CEN10CA576Accident · No injuriesData collectionFinal reportCessna 172M · Belle Plaine, MNThe pilot's loss of directional control due to an encounter with soft terrain while landing.Sep 28, 2010 · N9659Q · Substantial damageNTSB CEN10CA356Accident · No injuriesData collectionFinal reportBeech C23 · Eden Prairie, MNThe student pilot’s loss of airplane control while landing with gusting wind.Jun 27, 2010 · N9253S · Substantial damageNTSB CEN10CA329Accident · No injuriesData collectionFinal reportPiper/Wally'S Flyers J3C-65 · Crystal, MNThe pilot's failure to maintain directional control during the crosswind landing and the instructor pilot's delayed remedial action.Jun 19, 2010 · N25WF · Substantial damageNTSB CEN10CA260Accident · No injuriesData collectionFinal reportCessna 180 · Duluth, MNThe pilot's failure to maintain directional control during landing.May 16, 2010 · N6545A · Substantial damageNTSB CEN10CA224Accident · No injuriesData collectionFinal reportCessna 170-B · White Bear Lake, MNThe flight instructor's inadequate attempted recovery from a bounced landing and the student pilot's abrupt use of the brakes, which resulted in the airplane nosing over.Apr 25, 2010 · N3201A · Substantial damageNTSB CEN10CA195Accident · No injuriesData collectionFinal reportCessna 175 · Eveleth, MNThe pilot's selection of unsuitable terrain for landing.Apr 6, 2010 · N9266B · Substantial damageNTSB CEN10CA193Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Brook Park, MNThe pilot’s failure to maintain directional control during landing rollout in variable wind conditions.Apr 4, 2010 · N7884D · Substantial damageNTSB CEN09CA596Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Princeton, MNThe pilot's failure to maintain directional control during landing.Sep 19, 2009 · N52PH · Substantial damageNTSB CEN09CA592Accident · No injuriesData collectionFinal reportBordelon Kitfox IV · Dodge Center, MNThe pilot's improper glide path during landing.Sep 18, 2009 · N396BK · Substantial damageNTSB CEN09LA586Accident · No injuriesLimited investigationFinal reportCessna 172S · Duluth, MNThe pilot's failure to maintain aircraft control during landing, resulting in a hard landing and a propeller strike with the ground.Sep 7, 2009 · N568ND · Substantial damageNTSB CEN09CA564Accident · No injuriesData collectionFinal reportCessna 180G · Canby, MNThe pilot's failure to maintain directional control of the airplane while landing in gusting crosswinds.Sep 7, 2009 · N1250W · Substantial damageNTSB CEN09CA539Accident · No injuriesData collectionFinal reportDunn David RAF 2000 C · Lakeville, MNThe pilot's failure to maintain control of the aircraft during the landing flare.Aug 17, 2009 · N2107 · Substantial damageNTSB CEN09CA437Accident · No injuriesData collectionFinal reportCessna 172K · Pine River, MNThe student pilot's failure to maintain directional control during landing.Jul 13, 2009 · N79908 · Substantial damageNTSB CEN09CA357Accident · No injuriesData collectionFinal reportAviat A1 · Garrison, MNThe pilot's improper flare, which resulted in a hard landing on the water and subsequent loss of control.Jun 14, 2009 · N190BA · Substantial damageNTSB CEN09CA321Accident · No injuriesData collectionFinal reportCessna U206C · Brainerd, MNThe pilot's failure to maintain aircraft control while landing in gusty winds.May 25, 2009 · N3970G · Substantial damageNTSB CEN09CA320Accident · No injuriesData collectionFinal reportBeech B19 · Winsted, MNThe student pilot's improper flare during the soft-field landing. Contributing to the accident was the flight instructor's inadequate supervision during the landing.May 21, 2009 · N3214L · Substantial damageNTSB CEN09CA130Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Elrosa, MNThe pilot's inability to maintain control after touchdown on a snow-covered runway.Jan 10, 2009 · N2553S · Substantial damageNTSB CEN09CA120Accident · No injuriesData collectionFinal reportBeech 58 · Brainerd, MNThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the unforcasted freezing rain that obscured the windscreen and hindered the pilot's ability to judge the height of the airplane above the runway.Jan 3, 2009 · N70DD · Substantial damage