# Final NTSB investigations, ND: Enroute

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 4 · 154 cases

## Latest cases

- [NTSB CEN22FA017](https://openairdocs.org/ntsb/CEN22FA017.md): Piper PA-28-181 · Buxton, ND · Accident · 1 fatal · Class 3 · Field · Final report · Oct 19, 2021 · N820ND · Destroyed
  > The pilot’s intentional flight into terrain as an act of suicide.
- [NTSB CEN18LA334](https://openairdocs.org/ntsb/CEN18LA334.md): Schweizer 269C · Kindred, ND · Accident · No injuries · Class 3 · Limited · Final report · Aug 16, 2018 · N3625Z · Destroyed
  > The pilot’s failure to adequately inspect the lower coupling driveshaft during his preflight inspection and his non-compliance with an applicable airworthiness directive, which resulted in the failure of the forward drive splines of the lower coupling…
- [NTSB CEN18LA097](https://openairdocs.org/ntsb/CEN18LA097.md): Piper PA 24-260 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Feb 8, 2018 · N9360P · Substantial damage
  > The pilot's failure to use the published emergency procedures to manually extend the landing gear when an electrical failure precluded normal extension of the landing gear, resulting in the gear collapse during landing. Contributing to the accident was the…
- [NTSB CEN16LA012](https://openairdocs.org/ntsb/CEN16LA012.md): Refling RV8 · Bottineau, ND · Accident · No injuries · Limited investigation · Final report · Oct 6, 2015 · UNREG · Substantial damage
  > The pilot/builder’s failure to ensure that the fuel line was properly secured, which resulted in fuel starvation and the subsequent total loss of engine power.
- [NTSB CEN15LA383](https://openairdocs.org/ntsb/CEN15LA383.md): Piper PA 25-235 · Harvey, ND · Accident · No injuries · Limited investigation · Final report · Aug 21, 2015 · N4652Y · Substantial damage
  > The partial loss of engine power due to a failed magneto and two cylinders with low compression. Contributing to the accident was the pilot/owner’s decision to operate the airplane with an ongoing engine issue.
- [NTSB GAA15CA090](https://openairdocs.org/ntsb/GAA15CA090.md): Piper PA 25-260 · Casselton, ND · Accident · Minor injuries · Data collection · Final report · May 25, 2015 · N4793Y · Substantial damage
  > The pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance, which resulted in the inflight collision with power transmission line wires.
- [NTSB CEN14FA400](https://openairdocs.org/ntsb/CEN14FA400.md): Larry Ketterling FEW P-51 Mustang · Lisbon, ND · Accident · 1 fatal · Field investigation · Final report · Aug 1, 2014 · N116LK · Destroyed
  > The partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…
- [NTSB CEN14LA074](https://openairdocs.org/ntsb/CEN14LA074.md): Piper PA 28-181 · Rock Lake, ND · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2013 · N6780F · Substantial damage
  > The noninstrument-rated pilot’s failure to obtain weather briefings immediately before and during the flight and his continued flight into icing conditions, which resulted in the airplane’s loss of performance and the subsequent controlled descent into trees…
- [NTSB CEN12LA587](https://openairdocs.org/ntsb/CEN12LA587.md): Aviat A-1 · Rolla, ND · Accident · No injuries · Limited investigation · Final report · Aug 29, 2012 · N49363 · Substantial damage
  > The pilot's failure to secure the right wing's fuel cap before the flight and to properly manage the available fuel supply during the flight, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN11LA598](https://openairdocs.org/ntsb/CEN11LA598.md): Air Tractor AT-301 · Edgeley, ND · Accident · No injuries · Limited investigation · Final report · Aug 13, 2011 · N73071 · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN10TA194](https://openairdocs.org/ntsb/CEN10TA194.md): Beech 95-B55 · Center, ND · Accident · Serious injuries · Final report · Apr 7, 2010 · N70283 · Substantial damage
  > The inadvertent in-flight collision with several Mallard ducks.
- [NTSB CHI08CA157](https://openairdocs.org/ntsb/CHI08CA157.md): Cessna 172C · Nortonville, ND · Accident · Minor injuries · Data collection · Final report · Jun 4, 2008 · N1437Y · Substantial damage
  > The pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.
- [NTSB CHI08CA131](https://openairdocs.org/ntsb/CHI08CA131.md): Kuntz Kuntz 2000 GTS EFI · Dickinson, ND · Accident · Minor injuries · Data collection · Final report · May 10, 2008 · N610RD · Substantial damage
  > The pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…
- [NTSB CHI07CA215](https://openairdocs.org/ntsb/CHI07CA215.md): Rotorway 162F · Heart, ND · Accident · No injuries · Data collection · Final report · Jul 16, 2007 · CFYAR · Substantial damage
  > The pilot inadvertently shut off the fuel pump switch which resulted in fuel starvation and the subsequent loss of engine power. An additional cause was the pilot's poorly executed autorotation/flare which resulted in a hard landing.
- [NTSB CHI06FA275](https://openairdocs.org/ntsb/CHI06FA275.md): Piper PA-28-140 · Kulm, ND · Accident · 1 fatal · Field investigation · Final report · Aug 24, 2006 · N9714W · Destroyed
  > The non-instrument rated pilot's continued flight into instrument meteorological conditions which resulted in his inadvertent encounter with a thunderstorm and his loss of aircraft control. A factor to the accident was the thunderstorm.
- [NTSB CHI06CA216](https://openairdocs.org/ntsb/CHI06CA216.md): Piper PA-25 · Minot, ND · Accident · No injuries · Data collection · Final report · Aug 5, 2006 · N7587Z · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel calculations and the low airspeed which resulted in the pilot stalling the airplane. A factor was the car on the road which prevented the pilot from landing on the road.
- [NTSB CHI05LA145](https://openairdocs.org/ntsb/CHI05LA145.md): Piper PA-25-235 · Mapleton, ND · Accident · No injuries · Limited investigation · Final report · Jun 11, 2005 · N8619L · Substantial damage
  > The pilot's continued flight into instrument meteorological conditions and his failure to maintain clearance from an object during the precautionary landing. The heavy rain and the unknown object were factors.
- [NTSB CHI05LA012](https://openairdocs.org/ntsb/CHI05LA012.md): Cessna 150M · Ashley, ND · Accident · 1 fatal · Limited investigation · Final report · Oct 21, 2004 · N63439 · Destroyed
  > The non-instrument rated pilot's continued flight into known adverse weather conditions and his not maintaining aircraft control during cruise flight. Factors present were the night condition and low ceilings.
- [NTSB CHI01LA221](https://openairdocs.org/ntsb/CHI01LA221.md): Piper PA-30 · Bowman, ND · Accident · No injuries · Limited investigation · Final report · Jul 21, 2001 · N7382Y · Substantial damage
  > Altitude/clearance not obtained by the pilot during the initial climb. Factors relating to the accident were attaining the proper climb rate not being possible, the microburst, the dark night, and the tree.
- [NTSB CHI00LA246](https://openairdocs.org/ntsb/CHI00LA246.md): Summers RV4 · Bismarck, ND · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 2000 · N131DS · Substantial damage
  > Inadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion. A factor associated with the accident was the drainage ditch that the airplane contacted.
- [NTSB CHI00LA028](https://openairdocs.org/ntsb/CHI00LA028.md): Shaffer Evans Volksplane · Stanley, ND · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1999 · N78VS · Substantial damage
  > refueling not performed by the non-rated pilot and the lack of total experience of the non-rated pilot. Factors to the accident were fuel exhaustion, the unsuitable terrain for landing encountered by the non-rated pilot, and the rough/uneven terrain condition.
- [NTSB CHI99FA196](https://openairdocs.org/ntsb/CHI99FA196.md): Beech C-23 · Mandan, ND · Accident · 1 fatal · Field investigation · Final report · Jun 26, 1999 · N9703Q · Destroyed
  > the pilot failed to maintain aircraft control on approach to the airport after encountering high winds, gusts, rain, and thunderstorms in the area.
- [NTSB CHI99LA162](https://openairdocs.org/ntsb/CHI99LA162.md): Grumman-Schweizer G-164B · Buxton, ND · Accident · No injuries · Limited investigation · Final report · May 25, 1999 · N6524K · Substantial damage
  > the number one cylinder's separation, the pilot's visual lookout not possible through the oil given off by the number one cylinder, and the embankment. A factor in the accident was the oil.
- [NTSB CHI99LA020](https://openairdocs.org/ntsb/CHI99LA020.md): Becker Wag Aero Super Sport · Hamilton, ND · Accident · 1 fatal · Limited investigation · Final report · Nov 3, 1998 · N285BB · Destroyed
  > the fatigue failure of the lower wing strut attachment bracket.
- [NTSB CHI98LA271](https://openairdocs.org/ntsb/CHI98LA271.md): Vollmers Sonerai II L · Lincoln, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 1998 · N317WM · Substantial damage
  > Loss of engine power due to a corroded ignition wire. Related factors were the tailwind, and ditch.
- [NTSB CHI98LA241](https://openairdocs.org/ntsb/CHI98LA241.md): Rockwell S-2R · Fort Ransom, ND · Accident · No injuries · Limited investigation · Final report · Jul 7, 1998 · N4232X · Substantial damage
  > A loss of engine power due to fuel exhaustion. Factors contributing to this accident were the pilot's failure to ensure the airplane had enough fuel to complete the flight, and the fence.
- [NTSB CHI98LA016](https://openairdocs.org/ntsb/CHI98LA016.md): Piper PA-18-150 · Williston, ND · Accident · No injuries · Limited investigation · Final report · Oct 11, 1997 · N9691P · Substantial damage
  > the pilot's inadequate preflight planning/preparation, and his selection of an unsuitable area for landing. The adverse weather condition (low ceiling) and submerged object were related factors.
- [NTSB CHI97LA292](https://openairdocs.org/ntsb/CHI97LA292.md): Boeing 747-422 · Grand Forks, ND · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1997 · N175UA · No damage
  > The flight attendant's seat belt was not secured. A factor was turbulence in the clouds.
- [NTSB FTW97IA261](https://openairdocs.org/ntsb/FTW97IA261.md): Boeing 757-223 · Dickinson, ND · Incident · Minor injuries · Incident investigation · Final report · Jul 10, 1997 · N660AM · Minor damage
  > an encounter with unforecast convection induced turbulence (CIT). Related factors were: the flight crew's improper evaluation of the weather, and an inaccurate preflight weather briefing by company weather personnel.
- [NTSB CHI97LA036](https://openairdocs.org/ntsb/CHI97LA036.md): Cessna 177 · Regan, ND · Accident · No injuries · Limited investigation · Final report · Dec 3, 1996 · N30255 · Substantial damage
  > the pilot's intentional flight into adverse weather. Factors were clouds, the pilot's inadequate in-flight planning/decision making, his poor evaluation of the weather, and the encounter with unsuitable terrain for landing.
- [NTSB CHI97LA037](https://openairdocs.org/ntsb/CHI97LA037.md): Cessna 150 · Bowbells, ND · Accident · No injuries · Limited investigation · Final report · Nov 27, 1996 · CGOCS · Substantial damage
  > the pilot's failure to lean the mixture control after applying carburetor heat as the pilot's operating handbook states should be done. The carburetor icing conditions and the terrain were factors.
- [NTSB CHI96LA259](https://openairdocs.org/ntsb/CHI96LA259.md): Beech C24R · Hazelton, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 1996 · N5247M · Substantial damage
  > inadvertent VFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude control of the airplane, which resulted in a collision with the terrain. Factors relating to the accident were:…
- [NTSB CHI96LA228](https://openairdocs.org/ntsb/CHI96LA228.md): Piper PA-25-235 · Kenmare, ND · Accident · No injuries · Limited investigation · Final report · Jul 5, 1996 · N7730Z · Substantial damage
  > the pilot's improper refueling procedure, inadequate preflight and the inadvertent stall. A factor related to the accident was the low altitude at which the loss of power occurred.
- [NTSB CHI96LA220](https://openairdocs.org/ntsb/CHI96LA220.md): Grumman AA5B · Fryburg, ND · Accident · 1 fatal · Limited investigation · Final report · Jun 25, 1996 · N6249L · Substantial damage
  > the pilot's VFR flight into instrument meteorological conditions. Factors were the fog, low ceiling, and rising terrain.
- [NTSB CHI96FA216](https://openairdocs.org/ntsb/CHI96FA216.md): Fairchild SA227AC · Grand Forks, ND · Accident · No injuries · Field investigation · Final report · Jun 25, 1996 · N2692P · Substantial damage
  > insufficient clearance between the second stage compressor impeller and the shroud. A factor was the subsequent fatigue failure of the impeller.
- [NTSB CHI95FA285](https://openairdocs.org/ntsb/CHI95FA285.md): Piper PA-31-350 · Ardoch, ND · Accident · 2 fatal · Field investigation · Final report · Aug 18, 1995 · N85115 · Destroyed
  > the pilot-in-command's continuing flight into adverse weather. Factors were the pilot-in-command's failure to obtain a weather observation and the adverse weather.
- [NTSB CHI95LA225](https://openairdocs.org/ntsb/CHI95LA225.md): Cessna 206 · Williston, ND · Accident · No injuries · Limited investigation · Final report · Jul 16, 1995 · N29000 · Substantial damage
  > engine failure due to low fuel pressure at high power settings and subsequent detonation. A factor was an evasive maneuver to avoid obstacles which precipitated a stall. Additional factors include the hay bales, farm equipment, and the runway berm.
- [NTSB CHI95LA217](https://openairdocs.org/ntsb/CHI95LA217.md): Schweizer G-164B · Kenmare, ND · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1995 · N6623Q · Destroyed
  > the pilot's not obtaining/maintaining proper climb rate.
- [NTSB CHI95FA124](https://openairdocs.org/ntsb/CHI95FA124.md): Beech 65-B80 · Great Bend, ND · Accident · 1 fatal · Field investigation · Final report · Apr 12, 1995 · N7057J · Destroyed
  > the pilot/mechanic's inadequate maintenance (inspection) of aircraft and the pilot's failure to maintain airspeed (VMC). Factors were icing conditions, deteriorated induction air ducting, and failure of a piston assembly.
- [NTSB CHI95IA066](https://openairdocs.org/ntsb/CHI95IA066.md): Beech 1900D · Williston, ND · Incident · No injuries · Incident investigation · Final report · Jan 12, 1995 · N118UX · Minor damage
  > the improper installation and inadequate quality assurance inspection of the elevator trim cable during original manufacture, which resulted in fraying and failure of the cable prior to the first routine scheduled inspection of the system.
- [NTSB CHI95LA046](https://openairdocs.org/ntsb/CHI95LA046.md): Piper PA-44-180 · Dickinson, ND · Accident · No injuries · Limited investigation · Final report · Nov 26, 1994 · N2127D · Substantial damage
  > The flight instructor (CFI) misjudged the flare, which resulted in a hard landing. Factors related to the accident were: the adverse weather (icing) condition, structural ice, windshield ice, darkness, and the lack of visual cues for the pilot to land.
- [NTSB CHI95LA024](https://openairdocs.org/ntsb/CHI95LA024.md): Piper PA-18 · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Oct 22, 1994 · N587PA · Substantial damage
  > the fatigue failure of the crankshaft.
- [NTSB CHI95LA008](https://openairdocs.org/ntsb/CHI95LA008.md): Cessna T210R · Lakota, ND · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1994 · CGHRG · Substantial damage
  > Partial loss of engine power due to preignition and/or detonation, which resulted in failure of the number 4 cylinder. The unfavorable tailwind for landing was a related factor.
- [NTSB CHI94LA085](https://openairdocs.org/ntsb/CHI94LA085.md): Cessna 182P · Glen Ullin, ND · Accident · No injuries · Limited investigation · Final report · Feb 11, 1994 · N1794M · Substantial damage
  > The delayed application of the carburetor heat by the pilot-in-command. The carburetor icing weather condition was a factor.
- [NTSB CHI93LA299](https://openairdocs.org/ntsb/CHI93LA299.md): Cessna 170B · Steele, ND · Accident · No injuries · Limited investigation · Final report · Jul 30, 1993 · N8163A · Substantial damage
  > The pilot-in-command's poor in-flight decision and failure to maintain proper clearance.
- [NTSB CHI93LA215](https://openairdocs.org/ntsb/CHI93LA215.md): Cessna 150J · Wilton, ND · Accident · No injuries · Limited investigation · Final report · Jun 20, 1993 · N60454 · Substantial damage
  > Failure of the engine-driven fuel pump. A factor was the pilot's failure to select the auxiliary fuel pump.
- [NTSB CHI93LA099](https://openairdocs.org/ntsb/CHI93LA099.md): Cessna 150M · Stanley, ND · Accident · No injuries · Limited investigation · Final report · Feb 28, 1993 · N704AF · Substantial damage
  > The student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.
- [NTSB CHI93LA093](https://openairdocs.org/ntsb/CHI93LA093.md): Piper PA-23-160 · Cannonball, ND · Accident · No injuries · Limited investigation · Final report · Feb 20, 1993 · N4229P · Substantial damage
  > The blockage of the inlet air filter from snow.
- [NTSB CHI93FA053](https://openairdocs.org/ntsb/CHI93FA053.md): Piper PA-30 · Bowman, ND · Accident · 1 fatal · Field investigation · Final report · Dec 17, 1992 · N7243Y · Destroyed
  > The non instrument rated private pilot's failure to maintain adequate terrain clearance after inadvertent VFR flight into instrument meteorological conditions.
- [NTSB CHI92LA117](https://openairdocs.org/ntsb/CHI92LA117.md): Beech F33A · Langdon, ND · Accident · No injuries · Limited investigation · Final report · Mar 21, 1992 · N2046W · Substantial damage
  > Failure of the pilot to fully extend the landing gear using manual procedures after an electrical system failure. A factor associated with the accident is the pilot misreading a published emergency procedure.

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.