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 DEN85LA024Accident · No injuriesLimited investigationFinal reportCessna 185C · Williston, NDThe 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 DEN85LTG02Accident · 1 fatalFinal reportPiper PA-38-112 · Berthold, NDThe student solo plt was on a cross-country flt and was appropriately endorsed. Impact occurred at aprx 80 degrees nose down. Wx in the vicinity of the accident was reported to be 300 ft ceilings with visibility of 1/4 mi in fog and rain.NTSB DEN85LTG01Accident · Minor injuriesFinal reportHomebuilt EAA Special · Pembina, NDThis 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 DEN84LA304Accident · No injuriesLimited investigationFinal reportBeech C24R · Bismarck, NDPlt calculated the flt to be 4 hours 33 minutes long and there were 5.2 hrs of fuel on board. Plt stated, en route he was requested to climb from 6,000 ft to 8,000 ft then to 9,000 which was performed at 'full power, fuel full burn.' Stronger headwinds were…NTSB 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…NTSB DEN84LA285Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Berlin, NDThe 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 DEN84LA270Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Grand Forks, NDDuring 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 DEN84LA262Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Kindred, NDThe practice autorotation to touchdown began at 500 ft AGL. Shortly after initiating the flare the tail rotor contacted the ground. The pilot was scheduled for a private pilot helicopter check ride on the afternoon of the accident.NTSB DEN84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Arthur, NDAcft flown at high gross weight in high density altitude conditions. The plt said takeoff pwr was added too late to stopthe descent at the start of a spray run.NTSB DEN84LA258Accident · No injuriesLimited investigationFinal reportPiper PA-25-150 · New Rockford, NDPlt stated, 'on spray run. Got to close to sunflowers. When I started hitting them on the landing gear the plane slowed down and didn't have enough speed or power to get out so the plane landed in the sunflower field in about 50 yards.' Substantial damage…NTSB 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…NTSB DEN84LA238Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Selz, NDThe plt smelled and saw smoke from the engine which began to lose power. An emergency landing was made on a narrow dirt road. After stopping the plt egressed and ran. He said that about 2 minutes later the fuel tanks blew. Post accident examination indicated…NTSB DEN84LA236Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Webster, NDPlt stated the engine began to sputter during an ag flt. A forced landing was made in a wheat field during which the left main gear collapsed and the left wing contacted the ground. Investigation revealed the acft was fueled from an unfiltered 5 gallon can…NTSB 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…NTSB DEN84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Minnewaukan, NDThe pilot of this aircraft overflew his intended landing site, a gravel road, in an attempt to observe any power lines or other obstructions that might be in his way. He did not see anything that would prevent a safe landing. While turning to make the actual…NTSB DEN84LA206Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wyndmere, NDSod was worn from the middle of the strip & the strip was wet. Therefore, the plt elected to use the left side of the sod strip for takeoff. During the takeoff roll, the left spray boom dragged into wheat that was growing beside the rwy & the acft veered…NTSB DEN84LA204Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Page, NDEngine 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…NTSB DEN84LA279Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stanley, NDThe plt reported that he was spraying a field with 2 power lines at the north edge. He had been making passes under the wires, but where 2 poles were too close together, he decided to fly over the wires. After making a procedure turn back toward the field, he…NTSB DEN84LA179Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Kindred, NDThe engine quit on the first swath run after a carburetor change. Substantial damage resulted from the forced landing. Subsequent examination of the carburetor revealed fouling by sealant material partially dissolved by fuel.NTSB 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…NTSB 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.NTSB DEN84LA135Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Mcville, NDThe acft collided with the ground, left wing 1st, during an apch to land. The plt stated that the acft apparently stalled. A patrolman noted an odor of alcohol in the plt's breath. A blood/alcohol test showed an alcohol level of 0.19%. The plt's last medical…NTSB DEN84FTG01Accident · No injuriesFinal reportLee M. Brown Taterbug SB-1 · Sawyer, NDThe plt switched from main tank to aux tank, & about 10 minutes later, the eng began losing power switching back to the main tank did not help. The engine continued running but at greatly reduced power. A forced landing was made in a frozen stubble field. The…NTSB DEN84FA085Accident · 1 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe private non-instrument rated plt received two weather briefings before the flight. During the last briefing at 1350 MST, he was informed that VFR flt was not recommended. At 1554 MST, the acft departed crystal arpt in a westerly direction. Several…NTSB DEN84LA101Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Fortuna, NDThe plt made an off arpt landing on upward sloping terrain which was covered with aprx 4 inches of snow. About 1/2 hr later, he initiated a takeoff on a different section of the field on downward sloping terrain. The snow in that area was initially 4 inches…NTSB 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…NTSB DEN84FU001Accident · Serious injuriesFinal reportEipper Quicksilver E · Fargo, NDThe non-rated plt had taken ground & dual flt instruction in ultralight flying & had soloed earlier that day. He then took off & flew east, away from the designated ultralight training area. Just prior to the accident, witnesses driving east on an interstate…NTSB DEN84LA020Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, NDThe student plt encountered fog immediately after takeoff at about 150 AGL. The plt looked back & could still see the rwy lights, he then began a descending rt turn to the rwy to land. During this descending turn, the rt wing hit the ground followed by the…NTSB 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.NTSB DEN84LA006Accident · Minor injuriesLimited investigationFinal reportArtic S-1A Cadet · Fullerton, NDThe acft collided with trees during a takeoff from an open OAT field.NTSB 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…NTSB DEN83LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28B-150 · Watford City, NDThe acft nose gear collapsed during a precautionary landing due to weather. The plt had been briefed on the weather the evening before the accident. The pilot stated that when the flight was 20 minutes from home he 'thought we could make it.' However, he…NTSB 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…NTSB DEN83LA204Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Manning, NDThe acft collided with the ground after an eng failure while stringing power lines. The acft was in a right side low, nose high attitude pulling a wire attached to the left side of the acft. The wind was from the right rear quarter when the loss of power…NTSB DEN83LA190Accident · No injuriesLimited investigationFinal reportCessna T188L · Wahpeton, NDThe acft collided with the ground during aerial application turn around. The pilot stated that he looked inside the cockpit during the maneuver to see how much chemical was left. He saw the ground out of the corner of his eye and tried to avoid the collision…NTSB DEN83LA191Accident · No injuriesLimited investigationFinal reportPiper PA-25C-235 · Upham, NDThe pilot said he departed souris with aprx 17 gallons of fuel on board and flew for 1 hour at 500 feet to mandan, ND. He departed mandan without refueling and fuel exhaustion occurred about 1 hour later. He had flown for about 2 hours at 500 feet AGL with…NTSB 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.…NTSB DEN83LA166Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Thompson, NDThe acft crashed during descent for the first swath run. Investigation revealed that the pilot applied back pressure to the control stick to flare from the descent. The acft did not respond and continued to descend. The impact was hard enough to tear the left…NTSB DEN83LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Page, NDWhile spraying at dusk, the plt was concerned about injuring a 'non-target crop' across the road to the south from the field that was being sprayed. He stated that an irrigation system was sitting pointed southwest, and that as he was entering a swath to the…NTSB 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…NTSB DEN83LA153Accident · Minor injuriesLimited investigationFinal reportAero Commander Callair A-9B · Rolla, NDDuring a procedure turn-around after the second pass, the acft entered a stall, the left wing dropped & the plane impacted, left wing first, while in a nose down attitude. No preimpact, mechanical malfunction or failure was reported.NTSB 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.NTSB DEN83FTG01Accident · 2 fatalFinal reportStolp SA750 · Harwood, NDThe acft impacted the ground in an inverted position in about a 30 degree nose down attitude. The acft was observed doing aerobatics with the last maneuver a spin. The acft spun to an out of sight position behind the trees and a crash was heard. The CFI on…NTSB DEN83LA139Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Jamestown, NDThe acft landed wheels-up with one engine feathered and nosed over during the slide-out. The pilot had intentionally feathered the left engine to 'try out' the acft. The left engine has the only engine driven hydraulic pump. This pump isnecessary to lower…NTSB 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…NTSB 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.NTSB 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.NTSB DEN83LA067Accident · No injuriesLimited investigationFinal reportCessna 150M · Emerado, NDThe acft made a forced landing due to weather which included icing and low ceilings. According to the plt. The acft would no longer hold level flt due to icing and after the acft broke out at 300-350 ft AGL he landed and the gear collapsed. The plt had…NTSB DEN83LA054Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Jamestown, NDWhile en route, the plt encountered freezing rain and climbed to aprx 3500 ft to be on top of all weather. When he throttled back, the engine began surging and would not produce enough power for level flight. The pilot knew that the ground level in that area…NTSB CHI83IA054Incident · No injuriesIncident investigationFinal reportGates Lear Jet 35A · Over Fargo, NDWhile level at FL370 Over Fargo, ND, the crew heard a loud bang in the engine area and the aircraft experienced a sudden loss of cabin pressure. At the same time, the crew noticed that they had lost power on the #2 engine. After securing the engine and…