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 CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.Dec 17, 2008 · N845D · Substantial damageNTSB CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…Oct 1, 2008 · N251ND · Substantial damageNTSB CHI08CA289Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Crookston, MNThe pilot's failure to maintain directional control during landing and the flight instructor's delayed remedial action.Sep 19, 2008 · N18ND · Substantial damageNTSB CHI08CA262Accident · No injuriesData collectionFinal reportSchweizer G-164B · Nielsville, MNThe pilot's failure to maintain directional control of the airplane during the crosswind landing. Factors associated with the accident were the crosswind and the rough terrain.Aug 23, 2008 · N773D · Substantial damageNTSB DCA08MA085Accident · 8 fatalClass 1 · MajorFinal reportRaytheon Corporate Jets BAE 125-800A · Owatonna, MNThe captain’s decision to attempt a go-around late in the landing roll with insufficient runway remaining. Contributing to the accident were (1) the pilots’ poor crew coordination and lack of cockpit discipline; (2) fatigue, which likely impaired both pilots’…Jul 31, 2008 · N818MV · DestroyedNTSB CHI08CA227Accident · No injuriesData collectionFinal reportHead Balloons AX9-118 · Cook, MNThe pilot's decision to land in a confined area. Contributing to the accident were the hidden power transmission lines and the confined landing site.Jul 31, 2008 · N3106K · DestroyedNTSB CHI08LA228Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Maple Lake, MNThe certified flight instructor's delayed remedial action to the encountered stall. Contributing to the accident was the student pilot's slow airspeed and inadvertent stall.Jul 28, 2008 · N605EV · Substantial damageNTSB CHI08CA221Accident · Minor injuriesData collectionFinal reportCessna 150G · Grand Rapids, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the crosswind and wind gusts.Jul 25, 2008 · N8668J · Substantial damageNTSB CHI08CA167Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Wadena, MNThe pilot's failure to maintain control of the tail wheel airplane during the landing roll. A factor associated with the accident was the pilot's lack of recent experience in tail wheel airplanes.Jun 17, 2008 · N697DM · Substantial damageNTSB CHI08CA155Accident · No injuriesData collectionFinal reportCessna 180 · Eveleth, MNThe pilot elected to land on a grass airstrip that was unsuitable for landing due to the wet, soft runway conditions. The wet, soft runway were factors.Jun 7, 2008 · N4701U · Substantial damageNTSB CHI08CA069Accident · No injuriesData collectionFinal reportCessna 172N · South St. Paul, MNThe student pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident were the snow-covered runway and the gusty wind conditions.Jan 22, 2008 · N738UE · Substantial damageNTSB CHI08CA042Accident · Minor injuriesData collectionFinal reportCessna 180 · Becker, MNThe pilot maintained excessive airspeed during the landing approach and failed to achieve a proper touchdown point. A factor associated with the accident was the fence that the airplane contacted.Nov 11, 2007 · N5248E · Substantial damageNTSB CHI08CA030Accident · No injuriesData collectionFinal reportCessna 172M · Duluth, MNThe pilot's inadequate compensation for wind conditions during the landing approach. Contributing to the accident was the crosswind weather condition.Oct 28, 2007 · N4366R · Substantial damageNTSB CHI08CA018Accident · No injuriesData collectionFinal reportBell 407 · St Cloud, MNThe pilot's failure to execute a go-around when a normal approach to the intended landing point could not be maintained. An additional cause was the excessive descent rate that developed during the approach. Contributing factors were the tailwind condition…Oct 15, 2007 · N407LL · Substantial damageNTSB CHI08CA004Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey · Cokato, MNThe inadequate flare by the pilot during landing. Contributing factors were the lack of an endorsement by the pilot, the lack of total experience in the type of aircraft by the pilot, and the glassy water.Oct 4, 2007 · N452TR · Substantial damageNTSB CHI07CA299Accident · No injuriesData collectionFinal reportSchweizer 300 CBI · Minneapolis, MNThe dual student's improper flare during the simulated autorotation, and the flight instructor's delayed remedial action.Sep 13, 2007 · N269HB · DestroyedNTSB CHI07CA253Accident · No injuriesData collectionFinal reportCessna 180A · Duluth, MNThe pilot's failure to maintain directional control, which resulted in impact with terrain during an attempted aborted landing. A factor in the accident was the geese impacted during the landing roll.Aug 1, 2007 · N5016E · Substantial damageNTSB CHI07CA233Accident · No injuriesData collectionFinal reportSchweizer SGS 1-35C · Northfield, MNThe pilot's failure to maintain adequate airspeed, which resulted in a stall during the off-airport landing. A factor contributing to the accident was the dirt/rock pile.Jul 20, 2007 · N135EX · Substantial damageNTSB CHI07CA120Accident · No injuriesData collectionFinal reportChampion 7GCAA · Grand Rapids, MNThe pilot's failure to maintain directional control and his excessive use of brakes during the landing which resulted in a nose-over. The downhill slope was a contributing factor.Apr 25, 2007 · N1646G · Substantial damageNTSB CHI07CA109Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Walker, MNThe pilot's inadvertent failure to lower the landing gear.Apr 13, 2007 · N770C · Substantial damageNTSB CHI07CA014Accident · No injuriesData collectionFinal reportBellanca 7ECA · Eden Prairie, MNThe pilot not maintaining directional control of the tailwheel airplane during the landing roll. A factor was the runway sign that was impacted.Oct 27, 2006 · N57410 · Substantial damageNTSB CHI07CA006Accident · No injuriesData collectionFinal reportCessna 172N · Grand Rapids, MNThe student pilot's misjudged landing flare and improper recovery from the bounced landing which led to the failure of the nose landing gear. The overload failure of the nose landing gear was a factor.Oct 9, 2006 · N739XK · Substantial damageNTSB CHI06CA261Accident · No injuriesData collectionFinal reportBeech B19 · Eden Prarie, MNThe pilot not maintaining directional control of the airplane during the landing. A factor was the ditch.Aug 7, 2006 · N214RS · Substantial damageNTSB CHI06CA221Accident · No injuriesData collectionFinal reportAir Tractor AT-400 · Springfield, MNThe pilot's inability to maintain directional control of the airplane as a result of the partial failure of the tail wheel assembly. A factor associated with the accident was the crop that the airplane contacted.Jul 31, 2006 · N23720 · Substantial damageNTSB CHI06CA209Accident · No injuriesData collectionFinal reportCessna 180M · Chisholm, MNThe pilot's inadequate compensation for the wind condition. A factor associated with the accident was the gusty wind condition.Jul 30, 2006 · N3336T · Substantial damageNTSB CHI06LA208Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Claremont, MNThe procedure not followed by the passenger during landing and the inadequate supervision of the passenger by the pilot during landing. A contributing factors were the barbed wire fence.Jul 21, 2006 · N3639Q · No damageNTSB CHI06LA212Accident · No injuriesLimited investigationFinal reportCessna R172K · Grand Rapids, MNThe pilot's failure to maintain control of the airplane during the landing. A factor associated with the accident was the gusty tailwind that prevailed.Jul 9, 2006 · N736VM · Substantial damageNTSB CHI06LA175Accident · 1 fatalLimited investigationFinal reportCessna A185E · Clear Lake, MNThe pilot's misjudged flare that resulted in a hard landing and subsequent nose over. A factor to the accident was the grass runway that the forward landing gear dug into during the hard landing, resulting in the amphibian airplane nosing over.Jul 1, 2006 · N1972U · Substantial damageNTSB CHI06LA146Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Faribault, MNDirectional control not obtained/maintained by the pilot during landing. A contributing factor was the ditch.Jun 3, 2006 · N63790 · Substantial damageNTSB CHI06CA120Accident · No injuriesData collectionFinal reportCessna 172E · Wadena, MNThe pilot's inadequate compensation for the wind conditions during the landing. Factors were the crosswinds, the gusts, and the ditch.Apr 19, 2006 · N5766T · Substantial damageNTSB CHI06CA113Accident · No injuriesData collectionFinal reportCessna 195 · Pine Creek, MNThe pilot's improper flare and improper recovery from a bounced landing.Apr 8, 2006 · N3456V · Substantial damageNTSB CHI06LA101Accident · No injuriesLimited investigationFinal reportCessna 180G · Eveleth, MNThe pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane departing the left side of the runway. Contributing to the accident was the airport fence and the drainage ditch.Mar 26, 2006 · N1250W · Substantial damageNTSB CHI06LA100Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South St. Paul, MNThe pilot's failure to maintain directional control during landing roll, which resulted in the collapse of the right main landing gear. A factor associated with the accident was a tailwind.Mar 25, 2006 · N1579A · Substantial damageNTSB CHI06CA104Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Tower, MNThe unsuitable landing area selected by the pilot which led to the subsequent nose-over. The terrain condition was a factor.Mar 25, 2006 · N1856G · Substantial damageNTSB CHI06LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Worthington, MNThe missed approach not performed by the pilot and the directional control not maintained by the pilot during landing. Contributing factors were the crosswind, wind information not available due to inoperative meteorological equipment, and a Notices to Airman…Jan 5, 2006 · N190PH · Substantial damageNTSB CHI06CA020Accident · No injuriesData collectionFinal reportStinson SR-6A · Glencoe, MNThe pilot's inadequate wind compensation and his failure to maintain directional control during the landing rollout. A factor to the accident was the gusting crosswind condition.Oct 28, 2005 · N15127 · Substantial damageNTSB CHI05CA258Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Fertile, MNThe flightcrew's failure to extend the landing gear prior to touchdown, and the flight instructor's inadequate supervision of the flight.Sep 7, 2005 · N291ND · Substantial damageNTSB CHI05LA228Accident · No injuriesLimited investigationFinal reportAuseth Kitfox IV · Little Grand La, MNThe inadequate flare during landing by the pilot.Aug 10, 2005 · N912PJ · Substantial damageNTSB CHI05LA223Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Brainerd, MNThe delayed go-around and inadequate flare by the pilot during landing.Aug 10, 2005 · N795WW · Substantial damageNTSB CHI05CA215Accident · No injuriesData collectionFinal reportRosner Acro Sport II · Princeton, MNThe airplane nosed over during landing as a result of the pilot's failure to maintain control of the airplane when he applied excessive braking.Aug 7, 2005 · N89CJ · Substantial damageNTSB CHI05CA255Accident · No injuriesData collectionFinal reportLet L 33 Solo · Stanton, MNThe pilot's failure to maintain a proper descent rate during landing due to the wind gusts. The wind gusts were a factor.Jul 28, 2005 · N93205 · Substantial damageNTSB CHI05CA187Accident · No injuriesData collectionFinal reportMcDaniels Kitfox Classic IV · Bagley, MNThe pilot's inadvertent lift-off and failure to maintain adequate airspeed while recovering from a loss of directional control during landing. Contributing factors to the accident were the pilot's inadequate wind compensation and failure to maintain aircraft…Jul 16, 2005 · N6261M · Substantial damageNTSB CHI05CA168Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Minneapolis, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors associated with the accident were the crosswind and the taxiway sign.Jul 4, 2005 · CGGJB · Substantial damageNTSB CHI05CA174Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Willmar, MNThe pilot's improper flare which resulted in a hard landing.Jun 26, 2005 · N9027F · Substantial damageNTSB CHI05CA152Accident · No injuriesData collectionFinal reportCessna 172M · Rochester, MNThe pilot flared improperly and failed to recover from a bounced landing.Jun 18, 2005 · N73328 · Substantial damageNTSB CHI05CA084Accident · No injuriesData collectionFinal reportCessna 172 · Baudette, MNThe pilot's inadequate compensation for the crosswind which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, the snow covered surface on which the landing was being made, and the…Mar 26, 2005 · N8954B · Substantial damageNTSB CHI05LA064Accident · No injuriesLimited investigationFinal reportCessna A185F · Minneapolis, MNA failure of the tail wheel locking mechanism which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.Feb 3, 2005 · N1767R · Substantial damageNTSB CHI05CA058Accident · No injuriesData collectionFinal reportCessna 172F · Willmar, MNThe student pilot's failure to properly compensate for the crosswind conditions and his failure to maintain directional control during the landing rollout. Contributing factors were the crosswind and the snow bank.Jan 26, 2005 · N8205U · Substantial damageNTSB CHI05CA034Accident · No injuriesData collectionFinal reportCessna 172N · Lakeville, MNThe pilot misjudged his distance and speed which resulted in an overrun.. Factors were the wet runway, the grass and the berm.Nov 20, 2004 · N737CR · Substantial damageNTSB CHI04CA244Accident · Minor injuriesData collectionFinal reportBeech BE-18 · Lakeville, MNThe pilot's inadequate flare, the improper recovery from a bounced landing, the loss of directional control, and inadequate compensation for the crosswind. A factor was the crosswind.Aug 29, 2004 · N5180V · Substantial damage