Final NTSB investigations, ND
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "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'
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.
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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN86FTG02Accident · Serious injuriesFinal reportRarsch RV-4 · Erie, NDThe plt said he was making a short field apch to a private, sod, strip. He said he was in a shallow lt bank on final apch when he noticed the acft was in a slip and descending too fast to avoid a collision with trees 500 ft from the apch end of the strip. The…NTSB DEN86LA248Accident · No injuriesLimited investigationFinal reportCessna 150J · Goodrich, NDPlt said he was flying low and chasing black birds from his sunflower fields. Terrain was rolling hills. Plt said he made one pass over field and was turning around for another pass. 'I got my airspeed too low and started to stall. I brought it out of the…NTSB DEN86LA239Accident · No injuriesLimited investigationFinal reportPiper PA-23E-250 · Grand Forks, NDThe acft was en route from flin flon airport, manitoba, cd, to mason city, IA, and had stopped at Grand Forks, ND, for fuel and to clear customs. During taxi for takeoff, the acft struck a 1-inch concrete lip on the ramp and the right main landing gear…NTSB DEN86LA230Accident · No injuriesLimited investigationFinal reportCessna A188B · Langdon, NDWhile ground taxiing for takeoff the acft left main gear brake failed. During the ensuing right ground loop the left main gear collapsed and the left wing impacted the asphalt taxiway.NTSB DEN86LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fargo, NDThe plt reports that the flt was descending through 7,000 ft approaching the dest arpt when the eng began to run rough and lost pwr. The flt continued toward to the arpt but was unable to reach the rwy and landed about 1/4 mi short. After touchdown the acft…NTSB DEN86LA205Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Grandin, NDPlt was attempting to take off from 2600 ft x 50 ft sod strip with full fuel (36 gal) and 160 gal of M22, a fungicide. Center of rwy was soft from recent rains. Plt began takeoff roll on right side of rwy. Right wing and spray boom contacted tall grain stalks…NTSB 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…NTSB 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.NTSB DEN86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Williston, NDDuring the telephone interview, the plt stated the eng of his crop duster quit due to fuel exhaustion and a forced landing was made.NTSB DEN86LA174Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · La Moure, NDAccording to the plt, during a swath run, the acft he was piloting encountered 'bad air' and descended until the wings and wheels contacted the crop of grain he was spraying. The plt stated the acft stalled and contacted the ground.NTSB DEN86LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · South Heart, NDAccording to the plt, during a swath run (agricultural spraying), the eng quit & a forced landing was accomplished. During the interview, the plt stated the eng quit due to fuel exhaustion.NTSB DEN86FTG01Accident · Serious injuriesFinal reportPiper PA25-235 · Stanley, NDThe 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 DEN86LA157Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Williston, NDPlt stated that he was unfamiliar with the geographical area on this flt. He also stated, 'I was paying attention to the pwr lines and road and did not realize the hill out front was as high as it was...I attempted to turn back out, but with downwind it blew…NTSB DEN86LA153Accident · No injuriesLimited investigationFinal reportCessna 172G · Charlson, NDAccording 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 DEN86LA151Accident · Minor injuriesLimited investigationFinal reportBell 206B · Portal, NDThe plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side.NTSB DEN86LA145Accident · No injuriesLimited investigationFinal reportMooney M20 · Fargo, NDThe plt reports that he experienced difficulty in retracting the landing gear after departure but it did retract after several attempts. He said the gear system seemed to be hanging up. Upon reaching destination the gear again seemed to hang up when extension…NTSB DEN86FA142Accident · 3 fatalField investigationFinal reportCessna T210N · Elgin, NDPlt received wx briefing prior to departure. VFR flt not recommended by fss. Plt radioed that he was in thunderstorm activity, IFR conditions and was attempting to turn around. Witnesses stated that they observed acft descending at a high rate of speed of a…NTSB DEN86LA113Accident · No injuriesLimited investigationFinal reportde Havilland DHC · Pembina, NDThe plt stated the eng quit because the fuel cap had not been properly secured and the fuel had siphoned out in flt.NTSB DEN86LA106Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Tioga, NDThe plt dept minot, ND, with his son aboard, for a pvt airstrip near his home of windrose, ND. He said because of high winds he landed at Tioga, ND. He said that while taxiing after landing strong gusty winds flipped his acft upside down. The acft was…NTSB DEN86LA095Accident · Minor injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P Aerostar · Dickinson, NDWhile enroute on an IFR flight plan, the plt changed destination to Dickinson, ND, which extended the length of the flt. He did not desiginate an alternate arpt or have an adequate fuel reserve as required. On arrival at the destination, he executed an…NTSB DEN86LA091Accident · No injuriesLimited investigationFinal reportCessna 175 · Kulm, NDAccording 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 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…NTSB DEN86FA075Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Bismarck, NDThe 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 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.NTSB 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.NTSB DEN86LA062Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Hope, NDThe plt stated the citabria he was piloting failed to obtain flying speed before reaching the end of the snow covered private airstrip. According to the pilot, he aborted the takeoff too late. The acft contacted a snowbank and nosed over. The plt said that…NTSB 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.NTSB DEN86LA032Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Fargo, NDThe plt stated that during the ground taxi after landing, the right main gear collapsed. During the investigation, it was determined the down lock mechanism was not engaged. Upon examination, it was determined that the main gear lock activator rod was…NTSB DEN86LA017Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Bismarck, NDShortly 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 DEN86LA003Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Sawyer, NDThe plt allowed the airspeed to decrease to the extent of activating the acft stall warning system on final apch at 100 ft above the ground and 200 ft from the end of the rwy. He corrected the low airspeed condition by lowering the nose, resulting in a high…NTSB DEN85LTG08Accident · Minor injuriesFinal reportPiper PA-28-140 · Underwood, NDThe acft nosed over during a forced landing following a loss of pwr. The plt stated he was practicing slow flt on the return flt from picking the acft up after an annual inspection. As the acft slowed to 90 mph during slow flt, the plt attempted to increase…NTSB DEN85LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · Rocklake, NDThe student plt got lost during her 1st solo x-country flt. She subsequently attempted a lng on a gravel road but swerved the a/c off the road to avoid an oncoming car & the a/c received substantial damage.NTSB DEN85LTG07Accident · No injuriesFinal reportAeronca 058B · Mott, NDWhile departing a stubble field, the aircraft's tire ran into a soft spot in the ground and the aircraft turned and struck the shoulder of a road. The right gear broke and the right wing tip struck the ground, the right strut broke, the tail wheel and rudder…NTSB 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…NTSB DEN85LA219Accident · No injuriesLimited investigationFinal reportCessna C-172 · Killdeer, NDThe 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 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.NTSB DEN85LTG06Accident · No injuriesFinal reportBell 47G-4A · Minot, NDThe 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 DEN85LTG04Accident · No injuriesFinal reportPiper PA-25 · Antler, NDThe left wing of the acft received substantial damage when it contacted trees during a pull-up at the end of a swath run. The plt then flew the acft to a fld aprx 1 mile away and a precautionary landing was made.NTSB 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…NTSB DEN85LTG03Accident · No injuriesFinal reportPiper PA-25-235 · Kramer, NDThe acft collided with the shoulder of a hwy when the plt attempted to avoid power lines during an aerial application flt.NTSB 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…NTSB DEN85LA166Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Leonard, NDDuring an aerial spray operation, the plt returned to a field with his 2nd chemical load. As he descended over trees to begin a swath run, he began a flare, but the acft continued descending & impacted the ground. The right landing gear was torn off & the…NTSB DEN85LA147Accident · Minor injuriesLimited investigationFinal reportIntermountain Mfg. Callair A-9 · Michigan, NDThe plt elected to fly the newly purchased acft around the airstrip to test the spray sys. Shortly after taking off, the eng stopped running while the acft was over a slough. The plt was unable to glide the acft to suitable terrain, & subsequently, the acft…NTSB 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…NTSB 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…NTSB 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…NTSB DEN85LA071Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Grand Forks, NDOn 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 DEN85LA061Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Newburg, NDPlt attempted takeoff on a slippery, snow covered field with a 45 degree x-wind. Acft veered during the takeoff ground run and left main gear sheared off after contacting a snowbank.NTSB 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.NTSB 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…