# NTSB investigations, 1987, ND: Landing NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. ## Latest cases - [NTSB DEN87LA228](https://openairdocs.org/ntsb/DEN87LA228.md): Cessna 180 · Grassy Butte, ND · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1987 · N2413C · Substantial damage > N2413C, 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… - [NTSB DEN87LA200](https://openairdocs.org/ntsb/DEN87LA200.md): Cessna 185A · Hillsboro, ND · Accident · No injuries · Limited investigation · Final report · Jul 28, 1987 · N1686Z · Substantial damage > The 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… - [NTSB DEN87LA185](https://openairdocs.org/ntsb/DEN87LA185.md): Piper PA-30 · Grandforks, ND · Accident · No injuries · Limited investigation · Final report · Jul 17, 1987 · N7722Y · Substantial damage > The 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… - [NTSB DEN87LA184](https://openairdocs.org/ntsb/DEN87LA184.md): Champion 7ECA · Devils Lake, ND · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N11024 · Substantial damage > The 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. - [NTSB DEN87LA149](https://openairdocs.org/ntsb/DEN87LA149.md): Piper PA-36-285 · Driscoll, ND · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N57773 · Destroyed > The 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… - [NTSB DEN87LA154](https://openairdocs.org/ntsb/DEN87LA154.md): Mooney M20E · Harwood, ND · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N6933U · Substantial damage > The 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… - [NTSB DEN87LA129](https://openairdocs.org/ntsb/DEN87LA129.md): Boeing A75N1 · Mandan, ND · Accident · No injuries · Limited investigation · Final report · May 2, 1987 · N75546 · Substantial damage > The 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… - [NTSB DEN87LA085](https://openairdocs.org/ntsb/DEN87LA085.md): Aero Commander 100-180 · Cando, ND · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1987 · N4069X · Substantial damage > The 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… - [NTSB DEN87LA076](https://openairdocs.org/ntsb/DEN87LA076.md): Cessna 150M · Cavalier, ND · Accident · Minor injuries · Limited investigation · Final report · Mar 28, 1987 · N2848V · Substantial damage > The 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. - [NTSB DEN87LA073](https://openairdocs.org/ntsb/DEN87LA073.md): Mooney M20C · Wahpeton, ND · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N6550U · Substantial damage > A 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. - [NTSB DEN87FA057](https://openairdocs.org/ntsb/DEN87FA057.md): Cessna T210N · West Fargo, ND · Accident · Serious injuries · Field investigation · Final report · Feb 20, 1987 · N9499Y · Substantial damage > The 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… ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 year(c."eventDate") = 1987 AND c."eventStateOrRegion" = 'ND' 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 ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?state=ND&year=1987 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.