OpenAirDocs.org

Final NTSB investigations, ND

340 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    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 DEN90LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Michigan, NDThe failure of the pilot to maintain proper alignment during landing.Jul 11, 1990 · N4940R · Substantial damageNTSB DEN90LA128Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wahpeton, NDInadequate compensation for the wind conditions by the pilot. A factor was a strong cross wind, with gusts.Jun 8, 1990 · N32922 · Substantial damageNTSB DEN90LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe pilot's improper flare and improper recovery from a bounced landing. The wind condition was considered to be a contributing factor.Oct 24, 1989 · N95975 · Substantial damageNTSB DEN89LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Devils Lake, NDInadequate compensation for wind conditions by the pilot, which resulted in loss of directional control and an inadvertent ground loop/swerve. Contributing factors were: the crosswind and the pilot's lack of familiarity with the aircraft.Apr 5, 1989 · N7523K · Substantial damageNTSB DEN89LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Garrison, NDImproper flare by the student and inadequate supervision of the flight by the CFI which damaged the nose gear and restricted movement of the nosewheel steering and rudder control.Mar 31, 1989 · N6071K · Substantial damageNTSB DEN89LA072Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mayville, NDThe pilot's failure to maintain control of the airplane after touchdown on an icy runway. Contributing to the accident was improper alignment with the runway for touchdown.Feb 6, 1989 · N9459D · Substantial damageNTSB DEN89LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Larimore, NDInadequate supervision by the flight instructor. Factors related to the accident were: failure of the student pilot to attain a proper touchdown point, his delay in configuring the aircraft & executing the go-around, icy/snowy runway conditions, and the…Jan 21, 1989 · N9439B · Substantial damageNTSB DEN87LA228Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grassy Butte, NDN2413C, a Cessna 180, was landing in teddy roosevelt national park where the plt and his passengers intended to hunt deer. A flat, Grassy area on a ridge was selected for landing. The area was checked and marked off by friends of the plt before the landing…Aug 29, 1987 · N2413C · Substantial damageNTSB DEN87LA200Accident · No injuriesLimited investigationFinal reportCessna 185A · Hillsboro, NDThe pvt plt was receiving dual instruction for the purpose of a checkout in the Cessna 185. The dual student landed the acft on runway 34 with a right crosswind. During the landing roll the acft began to 'weathervane' and the rt wing began to rise. Remedial…Jul 28, 1987 · N1686Z · Substantial damageNTSB DEN87LA185Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Grandforks, NDThe commercial plt was flying cross country on a personal flight. After takeoff during gear retraction, a loud noise was heard in the cockpit. Upon reaching the first destination, the plt attempted gear down but gear did not extend. Manual extension was…Jul 17, 1987 · N7722Y · Substantial damageNTSB DEN87LA184Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Devils Lake, NDThe pvt plt, an A&P mechanic, was commuting home from the local airport in his aircraft. Upon landing, the main gear sank into soft soil and the acft nosed over.Jul 16, 1987 · N11024 · Substantial damageNTSB DEN87LA149Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Driscoll, NDThe plt rprtd he lost directional control as he was lndg on a paved section of old highway to load chemicals. The acft swerved & went into a ditch. The left main gear collapsed & the acft came to rest back on the roadway, where it was destroyed by a…Jun 14, 1987 · N57773 · DestroyedNTSB DEN87LA154Accident · No injuriesLimited investigationFinal reportMooney M20E · Harwood, NDThe plt was landing his Mooney M20E on a private grass airstrip. He said he lowered the manual landing gear and thought he felt the thumblock snap into place. Upon touchdown the landing gear folded up and the acft slid to a stop, resulting in substantial…Jun 7, 1987 · N6933U · Substantial damageNTSB DEN87LA129Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mandan, NDThe pilot and his son were ferrying a recently purchased Boeing stearman to their home in Ohio. During landing roll, at an en route stop, a gust of wind lifted the tail section and the acft groundlooped. The left wing struck the runway and the acft was…May 2, 1987 · N75546 · Substantial damageNTSB DEN87LA085Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Cando, NDThe acft attempted landing and on short final, the plt recognized a pickup truck obstructing the rwy near midfield. A go around was attempted resulting in an inadvertant stall. The left wing dipped, struck the rwy, and skidded into the vehicle. The acft and…Apr 6, 1987 · N4069X · Substantial damageNTSB DEN87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Cavalier, NDThe pilot was landing with a cross wind. The aircraft bounced and drifted into snow bank along the right edge of the runway. The nose gear was broken off in the collision with the snow bank and the engine was pushed into the firewall.Mar 28, 1987 · N2848V · Substantial damageNTSB DEN87LA073Accident · No injuriesLimited investigationFinal reportMooney M20C · Wahpeton, NDA CFI and a dual student were making practice landings. On the sixth landing, the student failed to lower the landing gear. The CFI did not notice that the acft did not have landing gear extended. The acft landed with gear fully retracted.Mar 27, 1987 · N6550U · Substantial damageNTSB DEN87FA057Accident · Serious injuriesField investigationFinal reportCessna T210N · West Fargo, NDThe acft was observed flying low and slow on final approach to West Fargo arpt. The acft continued flt to the ground, hit hard, bounced and then flew close to the ground in a large sweeping arc until the left wing tip touched the ground. The acft subsequently…Feb 20, 1987 · N9499Y · Substantial damageNTSB DEN86LA255Accident · No injuriesLimited investigationFinal reportBeech B58 · Fargo, NDThe pilot stated that during the landing roll he inadertently retracted the landing gear along with the flaps.Sep 19, 1986 · N9025V · Substantial damageNTSB DEN86LA202Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minot, NDAccording to the plt, the flt proceeded normally until he arrived at an airstrip sw of Minot for a landing. Several low approaches were made before he elected to land. He said that after the touchdown and during his landing roll, the acft swerved and went…Jul 19, 1986 · N2355A · Substantial damageNTSB DEN86LA196Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Fargo, NDThe plt said that he activated the landing gear retraction switch during the landing roll. The gear retracted causing the acft to settle on the rwy.Jul 13, 1986 · N67297 · Substantial damageNTSB DEN86LA084Accident · No injuriesLimited investigationFinal reportCessna 150L · Watford City, NDThe acft made a hard landing on rwy 30 at Watford City muni arpt, ND, and was substantially damaged. The student plt said the accident occurred on the third touch-and-go. The plt said he used only 10 degrees of flaps. He noted some turbulence and an increase…Feb 27, 1986 · N16210 · Substantial damageNTSB DEN86LA064Accident · No injuriesLimited investigationFinal reportCessna 172P · Fargo, NDThe acft contacted a snowbank following a loss of directional control during landing. This was the plt's first landing on his second solo flt. Previous to this landing, the student had been practicing landing on rwy 17 with his CFI.Jan 13, 1986 · N51238 · Substantial damageNTSB DEN86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · West Fargo, NDAccording to the student plt, he was practicing touch and go landings, when the acft veered off the side of the rwy and contacted a snow bank. The plt indicated he had a total flt time of apx 23 hrs, including 1.5 hrs solo. This was his third solo flt.Jan 4, 1986 · N23148 · Substantial damageNTSB DEN86LA035Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Beulah, NDDuring a landing at dusk on a snow covered rwy, the acft encountered deep snow and nosed over onto its back. The plt stated that after touchdown, he realized that there was aprx one ft of snow on the rwy and was unable to make a go-around.Nov 30, 1985 · N8143K · Substantial damageNTSB DEN85LTG09Accident · No injuriesFinal reportPiper PA-30/A · Bowman, NDThe acft was landed gear up. The plt was aware of the condition at one point in the traffic pattern. A check by retarding the throttle(s) on final produced no warning horn so the plt assumed that the gear was down. After the gear up landing, the circuit…Aug 17, 1985 · N7126Y · Substantial damageNTSB DEN85LTG05Accident · No injuriesFinal reportGrumman G164A · Colfax, NDThe plt noticed the spray pump was stuck in the off position shortly after takeoff for the aerial application flt. The decision was made to land on a private strip and during landing on the soft fld, the acft contacted high vegetation and nosed down.Aug 2, 1985 · N5364 · Substantial damageNTSB DEN85LA191Accident · No injuriesLimited investigationFinal reportCessna 172 · Sykeston, NDThe plt said he made a normal landing on an aerial application airstrip. During the rollout the plt spotted an unmarked mail box. The plt said he swerved to avoid colliding with the mail box. The acft went off the side of the strip and into a field. The plt…Jul 19, 1985 · N739GA · Substantial damageNTSB DEN85LA168Accident · No injuriesLimited investigationFinal reportHughes 269C · Grand Forks, NDOn June 18, 1985, a student plt and his instructor were on alocal tng flt. Prior to completing the mission, the instructor had his student execute a 180 degree autorotation. During the maneuver, the main rotor RPM was allowed to decay into the critical range…Jun 18, 1985 · N5203V · DestroyedNTSB DEN85FA113Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · Williston, NDThe flt crew stated after the accident that the flt was uneventful from rap to ins. The first officer was flying the acft when the accident occurred. According to the flt crew all checklist items had been performed prior to the landing. The acft made gnd…Apr 7, 1985 · N3005J · Substantial damageNTSB DEN85LA115Accident · No injuriesLimited investigationFinal reportCessna 150M · Beulah, NDThe pilot reported that he encountered turbulence and gusty winds on landing approach to runway 28. He said his speed was fast to compensate for these conditions but that he did not use a crosswind landing technique because the winds had calmed down. The…Apr 6, 1985 · N66387 · Substantial damageNTSB DEN85LA101Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Grand Forks, NDOn March 21, 1985, a Piper pa 18 ground looped on landing rollout at gran Forks, ND. The instructor stated the aircraft accident occurred when he was checking out another flight instructor in the tailwheel airplane. During the landing roll out the airplane…Mar 21, 1985 · N2582S · Substantial damageNTSB DEN85LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Fargo, NDAccording to the solo student plt, the landing was made in a snow filled ditch aprx 5 ft right of the rwy. The nose gear collapsed and the acft nosed over. The plt and his CFI stated that rwy markings were inadequate.Dec 29, 1984 · N48738 · Substantial damageNTSB DEN85LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Oaks, NDPlt stated that immediately after touchdown, the right wheel seemed to drag. Right drift was initially corrected by use of opposite aileron to reduce weight on right wheel and rudder for directional control. However, as the acft slowed weight settled on the…Nov 22, 1984 · N2759K · Substantial damageNTSB DEN84LA296Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Carrington, NDAccording to the plt, the landing gear were extended on base leg but he did not recall seeing the green light indicating a down and locked configuration. As the acft touched down some resistance was felt by the plt as all 3 gear collapsed and the acft settled…Sep 20, 1984 · N8579P · Substantial damageNTSB DEN84LA255Accident · No injuriesLimited investigationFinal reportCessna 188A · Jamestown, NDPlt stated, 'landing at dusk into sun. Landed into hill. Hard landing knocking feet (right) off rudder. Airplane groundlooped to left, hit ditch and flipped on its top.' Plt also stated fatigue from flying 4 hours on the day of the accident was a contributing…Aug 8, 1984 · N5634J · Substantial damageNTSB DEN84LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Dickinson, NDThe pilot stated that he received landing information for the Dickinson muni airport. He continued to state, 'set plane up for landing, checked plane over everything was set up, started to land, prop hit rwy, the next thing I was sliding down rwy.' The…Jul 11, 1984 · N7099P · Substantial damageNTSB DEN84LA149Accident · No injuriesLimited investigationFinal reportCessna 172N · Kindred, NDThe pilot stated that he made a normal landing approach to runway 15. During touchdown a gust of wind hit the airplane. The pilot said he was caught off guard and before he could regain control, the airplane went off the right side of the runway, struck a…May 14, 1984 · N738FA · Substantial damageNTSB DEN84LA136Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Fargo, NDDuring a Balloon landing which the plt described as normal, a pax banged her knee & broke her knee cap.Apr 23, 1984 · N3604U · No damageNTSB DEN84FA042Accident · Serious injuriesField investigationFinal reportMooney M20J · Bismarck, NDThe plt of N1151N reported that the departure arpt had some drifting snow which caused the r brake to freeze after takeoff. When the acft was landed, the r tire slid until it wore thru, then deflated. The plt stopped the acft on the rwy, informed tower psnl…Dec 15, 1983 · N1151N · Substantial damageNTSB DEN84LA015Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Oakes, NDAfter a brief stop at oaks, ND, for fuel, the plt took off to fly about 5 mi to his private strip in an alfalfa field. During the landing roll, the gear hit a gopher mound & the acft nosed over.Oct 25, 1983 · N2759K · Substantial damageNTSB DEN84LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe acft veered off the rwy and nosed over in the soft grass during landing. The CFI and student had been practicing crosswind landings on rwy 26 with the wind from 290 degrees at 11 KTS. After the landings the CFI got out of acft so that the student could…Oct 5, 1983 · N93844 · Substantial damageNTSB DEN83LA219Accident · No injuriesLimited investigationFinal reportCessna 320B · Mandan, NDThe acft landed gear up after the normal and emergency extension systems failed to extend the landing gear. During the appraoch to land the plt noticed the landing gear down light'would not come on'. A missed approach was executed. The pltdiscussed the…Sep 8, 1983 · N320RD · Substantial damageNTSB DEN83LA179Accident · No injuriesLimited investigationFinal reportCessna 305A · Minot, NDThe acft swerved off the rwy into a ditch after bouncing during landing. The pilot said he was cleared to land on rwy 13THE winds were from 290 degrees at 4 KTS. The pilot said a gust of wind (none reported) hit the acft during flare for a 2 point landing.…Jul 30, 1983 · CFTGG · Substantial damageNTSB DEN83LTG02Accident · No injuriesFinal reportAleson Quickie Q2 · Williston, NDThe acft groundlooped and collided with a rwy light following an inadvertant takeoff and landing during what was supposed to be a high speed taxi test. During the landing roll the acft swerved to the left, departed the rwy and collided with a rwy light. This…Jun 28, 1983 · N916DA · Substantial damageNTSB DEN83LA220Accident · No injuriesLimited investigationFinal reportBeech D35 · St. Thomas, NDThe plt stated that after a flt to inspect farm fields he 'made an approach to the arpt and landed with the gear up.' He said he heard the gear warning as he crossed the threshold but interpeted it as a stall warning.Jun 23, 1983 · N3422B · Substantial damageNTSB DEN83LA130Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cando, NDAfter returning to the arpt, the plt landed on rwy 30 with a right x-wind at about 16, gusting 23 KTS. Reportedly, the grass was aprx 1 ft tall on the rwy & the landing area sloped downward to the west. After touchdown, the plt maintained control of the acft…May 30, 1983 · N6372S · Substantial damageNTSB DEN83LA099Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Belfield, NDThe helicopter rolled over on a slight slope in an open field during a landing. The pilot stated that the acft touched down on the left skid, the acft started to tip to the left and he over corrected so that the acft rolled over to the right.Apr 17, 1983 · N8623B · Substantial damageNTSB DEN83LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powers Lake, NDAccording to the plt, he was landing on a road near a friend's house when the left wing hit a steelpost and caused the acft to veer off the road and into a ditch. The acft then nosed over in the ditch.Apr 2, 1983 · N3944Z · Substantial damageNTSB DEN82DA171Accident · No injuriesFinal reportCessna 190 · Bismarck, NDLeft brake failed. Examination revealed the hydraulic brake line to the left brake had pulled loose from a union fitting. The line also sheared by the shifting of the gear box assembly. There were signs of inadequate flare to the tubing in that it pulled out…Aug 22, 1982 · N3004B · Substantial damage