# Final NTSB investigations, ND: Initial climb

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.

Page 1 of 3 · 107 cases

## Latest cases

- [NTSB CEN23LA347](https://openairdocs.org/ntsb/CEN23LA347.md): Air Tractor AT-401 · Jamestown, ND · Accident · No injuries · Class 4 · Limited · Final report · Aug 3, 2023 · N6015W · Substantial damage
  > The pilot’s failure to maintain proper airspeed after liftoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.
- [NTSB CEN21LA044](https://openairdocs.org/ntsb/CEN21LA044.md): Piper PA-22-135 · Dunn Center, ND · Accident · 1 fatal · Class 3 · Limited · Final report · Nov 8, 2020 · N3606A · Destroyed
  > The noninstrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in a loss of control.
- [NTSB CEN19LA311](https://openairdocs.org/ntsb/CEN19LA311.md): Cessna 172 · Grassy Butte, ND · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 10, 2019 · N5347T · Substantial damage
  > A total loss of engine power due to water contamination of the fuel, and the pilot's failure to conduct a preflight inspection.
- [NTSB CEN18LA354](https://openairdocs.org/ntsb/CEN18LA354.md): Beech 35 · Bowman, ND · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 2018 · N666WW · Substantial damage
  > The loss of engine power due to fuel starvation.
- [NTSB CEN16FA212](https://openairdocs.org/ntsb/CEN16FA212.md): Piper PA 28-140 · Wishek, ND · Accident · 3 fatal · Field investigation · Final report · Jun 9, 2016 · N6223W · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…
- [NTSB CEN11CA071](https://openairdocs.org/ntsb/CEN11CA071.md): Grumman G-164 · Michigan, ND · Accident · No injuries · Data collection · Final report · Oct 11, 2010 · N554Y · Substantial damage
  > The pilot's failure to abort the takeoff roll following a noticeable loss of engine power due to low engine compression and a magneto failure.
- [NTSB CEN09CA470](https://openairdocs.org/ntsb/CEN09CA470.md): Raytheon C90A · Bismarck, ND · Accident · No injuries · Data collection · Final report · Jul 23, 2009 · N405DD · Substantial damage
  > The cabin entry door inadvertently opening during initial climb.
- [NTSB CHI08CA201](https://openairdocs.org/ntsb/CHI08CA201.md): Grumman G-164D · Esmond, ND · Accident · Minor injuries · Data collection · Final report · Jul 21, 2008 · N996QC · Substantial damage
  > The pilot's delay in advancing the throttle during the takeoff which resulted in inadequate airspeed and the subsequent stall/mush. Factors associated with the accident were the leaking hopper, the pilot continuing to operate the airplane with the known…
- [NTSB CHI07CA248](https://openairdocs.org/ntsb/CHI07CA248.md): Beech B60 · Bismark, ND · Accident · No injuries · Data collection · Final report · Aug 1, 2007 · N529R · Substantial damage
  > The improper fuel grade due to the improper fueling of the airplane by the fixed base operator, which led to the loss of engine power of both engines. A factor was the unsuitable terrain encountered during the forced landing.
- [NTSB CHI07CA161](https://openairdocs.org/ntsb/CHI07CA161.md): Weatherly 201C · Mc Clusky, ND · Accident · No injuries · Data collection · Final report · Jun 5, 2007 · N1246W · Substantial damage
  > The pilot's failure to check for fuel contamination during the preflight inspection, which resulted in a loss of engine power shortly after takeoff due to water contamination. Contributing factors to the accident included the rough/uneven field and the…
- [NTSB CHI05CA246](https://openairdocs.org/ntsb/CHI05CA246.md): Ayres S2R-G10 · Davenport, ND · Accident · No injuries · Data collection · Final report · Aug 29, 2005 · N3024U · Substantial damage
  > The pilot failed to gain suffient altitude during takeoff in order to clear the corn crop at the end of the runway. A factor associated with the accident was the corn crop.
- [NTSB CHI05CA074](https://openairdocs.org/ntsb/CHI05CA074.md): Cessna 177RG · Fargo, ND · Accident · Serious injuries · Data collection · Final report · Feb 26, 2005 · N1623H · Substantial damage
  > The mechanic's improper installation of the oil filter canister base gasket, which resulted in an oil leak and the separation of the connecting rod due to oil starvation. Factors to the accident were the unsuitable terrain encountered during the forced…
- [NTSB CHI03LA266](https://openairdocs.org/ntsb/CHI03LA266.md): Cessna 172G · Bowdon, ND · Accident · No injuries · Limited investigation · Final report · Aug 16, 2003 · N6057R · Substantial damage
  > The pilot's failure to maintain adequate airspeed which led to a stall. Contributing to the accident was the pilot's lack of experience, the crosswind condition, wind gusts and power lines.
- [NTSB CHI00LA177](https://openairdocs.org/ntsb/CHI00LA177.md): Air Tractor AT-502 · Portland, ND · Accident · No injuries · Limited investigation · Final report · Jun 29, 2000 · N91891 · Substantial damage
  > the pilot intentionally operated the airplane with known damage on the left wing which resulted in the pilot's inability to maintain control of the airplane during takeoff.
- [NTSB CHI98LA337](https://openairdocs.org/ntsb/CHI98LA337.md): WSK PZL Mielec PZL M18B · Tappen, ND · Accident · No injuries · Limited investigation · Final report · Sep 11, 1998 · N4450M · Destroyed
  > the pilot's improper preflight preparation resulting in the airplane exceeding the available airstrip distance during takeoff. A factor contributing to this accident was the swamp.
- [NTSB CHI98LA305](https://openairdocs.org/ntsb/CHI98LA305.md): Air Tractor AT-301 · Edgeley, ND · Accident · No injuries · Limited investigation · Final report · Aug 9, 1998 · N4443S · Substantial damage
  > The pilot's failure to maintain flying airspeed resulting in a stall/mush condition during the initial climb. Contributing factors were the high density altitude, high aircraft weight, and pilot's delayed jettison of the load, as well as the roadway and crop.
- [NTSB CHI98LA301](https://openairdocs.org/ntsb/CHI98LA301.md): Grumman-Schweizer G-164A · La Moure, ND · Accident · No injuries · Limited investigation · Final report · Aug 4, 1998 · N8693H · Substantial damage
  > a loss of engine power due to undetermined reasons.
- [NTSB CHI98LA266](https://openairdocs.org/ntsb/CHI98LA266.md): Cessna R182 · Bismarck, ND · Accident · No injuries · Limited investigation · Final report · Jul 20, 1998 · N9142C · Substantial damage
  > The fatigue failure of the fuel system line fitting.
- [NTSB CHI98LA062](https://openairdocs.org/ntsb/CHI98LA062.md): Piper PA-28-140 · Dawson, ND · Accident · No injuries · Limited investigation · Final report · Dec 9, 1997 · N55259 · Substantial damage
  > The pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.
- [NTSB CHI97LA213](https://openairdocs.org/ntsb/CHI97LA213.md): Piper PA-28-151 · Fessenden, ND · Accident · No injuries · Limited investigation · Final report · Jul 17, 1997 · N41371 · Substantial damage
  > the pilot's premature liftoff and/or failure to abort the takeoff while there was sufficient runway remaining.
- [NTSB CHI97LA157](https://openairdocs.org/ntsb/CHI97LA157.md): Cessna A188B · La Moure, ND · Accident · No injuries · Limited investigation · Final report · Jun 5, 1997 · N8293G · Substantial damage
  > a loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.
- [NTSB CHI96LA250](https://openairdocs.org/ntsb/CHI96LA250.md): Poppenhagen PUD Knocker Special · Grafton, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1996 · N380BP · Substantial damage
  > the inadequate fuel system design by the builder which led to fuel starvation.
- [NTSB CHI95LA250](https://openairdocs.org/ntsb/CHI95LA250.md): Grumman G-164 · Park River, ND · Accident · No injuries · Limited investigation · Final report · Jul 27, 1995 · N949X · Substantial damage
  > the loss of power due to the primary lead in the left magneto being grounded against the case, and the improper clearance of the breaker point gaps. A factor was the lack of suitable terrain on which to perform the forced landing.
- [NTSB CHI95LA167](https://openairdocs.org/ntsb/CHI95LA167.md): Piper PA-16 · Williston, ND · Accident · No injuries · Limited investigation · Final report · Jun 3, 1995 · N5328H · Substantial damage
  > The failure of the pilot to maintain directional control on takeoff. The soft condition of the field was a factor.
- [NTSB CHI94LA345](https://openairdocs.org/ntsb/CHI94LA345.md): Cessna 150G · New Town, ND · Accident · No injuries · Limited investigation · Final report · Sep 23, 1994 · N6685F · Substantial damage
  > The pilot's improper use of wing flaps and premature lift-off. The pilot's poor preflight preparation was a factor.
- [NTSB CHI93FA028](https://openairdocs.org/ntsb/CHI93FA028.md): Smith, Ted Aerostar Aerostar 601 · Wahpeton, ND · Accident · Minor injuries · Field investigation · Final report · Nov 6, 1992 · N72AW · Substantial damage
  > Other maintenance personnel's improper maintenance (installation).
- [NTSB CHI93DTG01](https://openairdocs.org/ntsb/CHI93DTG01.md): King BOWERS-FLYBABY · Buffalo, ND · Accident · No injuries · Final report · Oct 22, 1992 · N199 · Substantial damage
  > Partial loss of engine power due to improper installation of the carburetor, by the pilot/owner.
- [NTSB CHI92FA220](https://openairdocs.org/ntsb/CHI92FA220.md): Beech V35B · Northwood, ND · Accident · 3 fatal · Field investigation · Final report · Jul 31, 1992 · N8BL · Destroyed
  > Spatial disorientation of the pilot in command during initial climb.
- [NTSB CHI91DTG03](https://openairdocs.org/ntsb/CHI91DTG03.md): Schweizer G164 · Gwinner, ND · Accident · No injuries · Final report · Jun 16, 1991 · N48687 · Substantial damage
  > Inadvertent closing of the mixture by the pilot. Factors related to the accident are inadequate control shape, or size, and inattentiveness of the pilot.
- [NTSB DEN90FA161](https://openairdocs.org/ntsb/DEN90FA161.md): Cessna 150L · Hettinger, ND · Accident · 2 fatal · Field investigation · Final report · Jul 13, 1990 · N11580 · Destroyed
  > The pilot's failure to maintain airspeed during climbout. Contributing factors were: the pilot's lack of recent experience, and the over maximum gross weight condition of the aircraft.
- [NTSB DEN90LA146](https://openairdocs.org/ntsb/DEN90LA146.md): Grumman G-164A · Edgeley, ND · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1990 · N6887Q · Substantial damage
  > A momentary power interruption during initial climb for unknown reasons.
- [NTSB DEN90DTG02](https://openairdocs.org/ntsb/DEN90DTG02.md): Eugene N. Rausch RV-4 · Erie, ND · Accident · 1 fatal · Final report · Jun 23, 1990 · N319ER · Destroyed
  > An inadvertent stall.
- [NTSB MKC89IA082](https://openairdocs.org/ntsb/MKC89IA082.md): Gulfstream 690A · Bismark, ND · Incident · No injuries · Incident investigation · Final report · Mar 21, 1989 · N690MF · No damage
  > A failed (cracked) engine plenum resulting in loss of engine power.
- [NTSB DEN87LA196](https://openairdocs.org/ntsb/DEN87LA196.md): Piper PA-18-150 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Jul 28, 1987 · N7174B · Substantial damage
  > Plt installed new aerial application chemical tank. The tank was filled with water for a test flight. Plt could not hold nose down after takeoff. Acft stalled into trees and landed in field beyond trees. Acft nosed over and damaged fuselage and vertical…
- [NTSB DEN87LA157](https://openairdocs.org/ntsb/DEN87LA157.md): Hiller UH-12E · Ray, ND · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N68012 · Substantial damage
  > The plt reports that he was departing from an aerial app operating area. He said there was a tree line along a road with an opening and the takeoff was made toward the opening. There were wires across the opening and the poles were obscured by the trees on…
- [NTSB DEN87LA114](https://openairdocs.org/ntsb/DEN87LA114.md): Piper PA-25 · Valley City, ND · Accident · No injuries · Limited investigation · Final report · Apr 28, 1987 · N6749Z · Substantial damage
  > The commercial pilot was trying out an acft with the stated intention of leasing it. A takeoff was planned from a stretch of gravel road. During the takeoff ground run, the acft became airborne then touched down in a field, bounced across an intersecting road…
- [NTSB DEN87LA004](https://openairdocs.org/ntsb/DEN87LA004.md): Piper PA-32R-301T · Grafton, ND · Accident · No injuries · Limited investigation · Final report · Oct 8, 1986 · N8125H · Substantial damage
  > Plt made forced landing on dirt road shortly after takeoff when the eng reportedly lost power. Plt extended landing gear but acft touched down before gear locked and left main landing gear collapsed. Left wing also struck a mailbox during rollout. Post…
- [NTSB DEN86FTG01](https://openairdocs.org/ntsb/DEN86FTG01.md): Piper PA25-235 · Stanley, ND · Accident · Serious injuries · Final report · Jun 18, 1986 · N6535Z · Destroyed
  > The acft went off the departure end of the rwy and collided with a ditch after which it erupted in flames. The temperature was 87 degrees with light wind. The density alt was computed to be 5000 ft. the plt had stated to the operator that he thought it was…
- [NTSB DEN86LA153](https://openairdocs.org/ntsb/DEN86LA153.md): Cessna 172G · Charlson, ND · Accident · No injuries · Limited investigation · Final report · Jun 6, 1986 · N1136F · Substantial damage
  > According to the plt, he lndd in an off arpt field to make a rest stop. He stated that bfr taking off again, he checked for wind & fnd none. He then initiated a soft field takeoff twd the NE with 20 deg of flaps. He stated that after lift-off, he 'took some…
- [NTSB DEN86LA091](https://openairdocs.org/ntsb/DEN86LA091.md): Cessna 175 · Kulm, ND · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N7647M · Substantial damage
  > According to the plt, the eng lost partial pwr on takeoff due to carberetor ice. A forced landing was made during which the nose gear collapsed resulting in substantial damage to the acft.
- [NTSB DEN86FA075](https://openairdocs.org/ntsb/DEN86FA075.md): Piper PA-34-200 · Bismarck, ND · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1986 · N55654 · Destroyed
  > The acft was observed descending out of a low ceiling when it suddenly made an abrupt left turn. Engine noise seemed to increase momentarily and then the nose of the acft dropped to a near vertical position. The twin engine acft crashed into a vacant house…
- [NTSB DEN86LA017](https://openairdocs.org/ntsb/DEN86LA017.md): Beech A36TC · Bismarck, ND · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 1985 · N3663K · Substantial damage
  > Shortly after takeoff, the plt of the Beech A36TC acft activated what he believed was the flap retraction lever, and the eng quit. The plt made a forced landing aprx 1000 ft from the rwy departure end. During the investigation, the eng was started and…
- [NTSB DEN85LA219](https://openairdocs.org/ntsb/DEN85LA219.md): Cessna C-172 · Killdeer, ND · Accident · No injuries · Limited investigation · Final report · Aug 15, 1985 · N7202A · Substantial damage
  > The plt said he measured the length of the r/w prior to t/o. the t/o was normal on a downsloping r/w with trees at the FAR end. The plt said that as the a/c lifted off the r/w the a/c struck the trees. He said a gust of wind caused the a/c to settle into the…
- [NTSB DEN85LTG06](https://openairdocs.org/ntsb/DEN85LTG06.md): Bell 47G-4A · Minot, ND · Accident · No injuries · Final report · Jul 30, 1985 · N1041B · Substantial damage
  > The plt was engaged by a deputy sheriff to fly the helicopter about 2-1/2 mi to the Minot intl arpt for impoundment. During takeoff, it began climbing, then the plt lost control & the helicopter entered a descent & crashed. Initial impact occurred about 35 ft…
- [NTSB DEN85LA071](https://openairdocs.org/ntsb/DEN85LA071.md): Beech 76 · Grand Forks, ND · Accident · Serious injuries · Limited investigation · Final report · Jan 27, 1985 · N1850S · Substantial damage
  > On Sunday 1/27/85 at approximately 0849 MST, a Beech DUCHESSN1850S, on lease to the university of north dakota crashed after takeoff from the Grand Forks airport, Grand Forks, ND.the student pilot and certified flight instructore were not injured. Two…
- [NTSB DEN85LA024](https://openairdocs.org/ntsb/DEN85LA024.md): Cessna 185C · Williston, ND · Accident · No injuries · Limited investigation · Final report · Nov 8, 1984 · N5831T · Substantial damage
  > The acft collided with a bridge during an aborted takeoff after failing to get airborne. The plt aborted the takeoff butthe acft failed to stop in time to avoid a collision with a railroad bridge abutment made of concrete. The plt stated that the acft had…
- [NTSB DEN85LTG01](https://openairdocs.org/ntsb/DEN85LTG01.md): Homebuilt EAA Special · Pembina, ND · Accident · Minor injuries · Final report · Oct 8, 1984 · N4632T · Substantial damage
  > This was the pilot's first operation in this make and model. During taxi, excessive use of brakes caused the aircraft to weave severely. Power was not reduced but back stick input was made. The aircraft became airborne prematurely in ground effect, stalled at…
- [NTSB DEN84LA285](https://openairdocs.org/ntsb/DEN84LA285.md): Grumman G-164A · Berlin, ND · Accident · No injuries · Limited investigation · Final report · Sep 6, 1984 · N6887Q · Substantial damage
  > The acft collided with the ground in a soft field and nosed over. The plt reported that the engine lost power and he could not dump his load because the dump handle came off. The plt said 100 gallons of liquid fertilizer was loaded on the acft. The plt did…
- [NTSB DEN84LA270](https://openairdocs.org/ntsb/DEN84LA270.md): Weatherly 201B · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Aug 27, 1984 · N1268W · Substantial damage
  > During initial takeoff climb at an alt of aprx 100 ft AGL, engine began missing. Unable to maintain alt, forced landing was made in a plowed field during which landing gear was torn from the acft. Inspection revealed #5 cylinder head separated from the…
- [NTSB DEN84LA204](https://openairdocs.org/ntsb/DEN84LA204.md): Grumman G-164A · Page, ND · Accident · No injuries · Limited investigation · Final report · Jun 29, 1984 · N5332 · Substantial damage
  > Engine siezed during takeoff climb at alt of aprx 100 ft AGL. Acft contacted trees during the forced landing. Examination of engine turbo section revealed the blower section had separated as a result of bearing failure. According to a mechanic who…

Next page: https://openairdocs.org/ntsb-phases/350/cases.md?status=final&state=ND&page=2

## 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 c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?state=ND&status=final

---
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.