Final NTSB investigations, ND
60 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 5 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 4 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.NTSB CHI06CA114Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Drayton, NDThe pilot's failure to maintain directional control during takeoff. A related factor was the high wind condition.NTSB CHI05CA098Accident · No injuriesData collectionFinal reportCurl Avid Air Magnum · Cando, NDThe pilot's failure to compensate for the crosswind condition and maintain directional control during landing rollout. Factors to the accident were the crosswind and the muddy drainage ditch.NTSB CHI05LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Grafton, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control during the landing. Factors associated with the accident were the crosswind condition and the snow bank.NTSB CHI05CA068Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Larimore, NDThe CFI's delay in applying remedial action which resulted in a loss of directional control of the airplane. Factors associated with the accident were the student's excessive application of rudder and the snow bank which the airplane contacted.NTSB CHI05CA043Accident · No injuriesData collectionFinal reportBellanca 14-19 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A contributing factorwas the approach light.NTSB CHI04CA208Accident · No injuriesData collectionFinal reportCherkas Murphy Rebel · Dunseith, NDThe pilot's misjudged speed/distance, and his failure to maintain directional control during landing roll, which resulted in the inadvertent ground-loop.NTSB CHI04LA024Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakota, NDThe student pilot not maintaining directional control during takeoff roll on a solo instructional flight. The factor to the accident was the wind gusts.NTSB CHI02LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Langdon, NDThe pilot did not maintain directional control while taxiing. A contributing factor was the wind gust condition present at the time of the accident.NTSB CHI02LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Devils Lake, NDThe student pilot's failure to maintain directional control of the airplane during the takeoff phase of a touch and go landing. Factors associated with the accident were the student's lack of total experience and the runway light which the airplane contacted.NTSB CHI01LA134Accident · No injuriesLimited investigationFinal reportAir Tractor G-164A · Casselton, NDThe pilot's failure to maintain directional control of the airplane while recovering from a bounced landing. A factor was the collapse of the right main landing gear.NTSB CHI00LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Park River, NDdirectional control not being maintained by the pilot during landing.NTSB CHI99LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · Rugby, NDthe pilot failed to maintain directional control.NTSB CHI98LA243Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Minto, NDthe pilot's selection of unsuitable terrain for takeoff. Factors were wet and soft runway conditions, and a ditch and the end of the overrun area.NTSB CHI98LA229Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Portland, NDthe pilot's not maintaining directional control. Factors were landing on a roadway and tall grass.NTSB CHI97LA238Accident · No injuriesLimited investigationFinal reportVelocity Velocity Elite RG · Langdon, NDfailure of the pilot to maintain directional control during the landing roll. The crosswind and proximity of the taxiway sign were related factors.NTSB CHI97LA184Accident · Minor injuriesLimited investigationFinal reportWeatherly 201C · Buffalo, NDthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control of the airplane. Water on the runway and the soft terrain were related factors.NTSB CHI97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dickinson, NDthe student pilots failure to maintain directional control of the airplane. A factor associated with the accident was the pilot's runway selection.NTSB CHI96LA347Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fargo, NDthe pilot's failure to maintain directional control of the airplane during the landing. A factor was the crosswind.NTSB CHI96LA257Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Napoleon, NDthe pilot's improper use of the rudder to correct the airplane's drift to the right. A factor was the pilot's inadequate compensation for the crosswind.NTSB CHI96LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Forks, NDthe pilot's failure to maintain control of the airplane while taxiing. Factors in the accident were the icy condition of the taxiway and the high gusting wind.NTSB CHI95LA152Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Hatton, NDthe pilot's failure to maintain control of the airplane, and the excessive airspeed. Factors associated with the accident were the pilot's selection of unsuitable terrain for landing, and the soft, wet condition of the sod runway.NTSB CHI95LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · West Fargo, NDthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the soft terrain that the airplane encountered.NTSB CHI95LA025Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Beulah, NDthe failure of the pilot to maintain directional control.NTSB CHI94LA223Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Crosby, NDthe pilot's failure to maintain directional control during the takeoff roll. Factors associated with the accident are the rough runway, and the pilot's improper preflight planning.NTSB CHI94DTG01Accident · No injuriesFinal reportGrumman G-164-A · La Moure, NDfailure of the pilot to maintain directional control.NTSB CHI94LA173Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDthe pilot-in-command's not maintaining directional control.NTSB CHI94LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Casselton, NDthe student's failure to attain proper runway alignment and to maintain directional control. A factor related to the accident was the snow covered runway.NTSB CHI93LA159Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDThe pilot's improper use of collective in recovering from a loss of control due to ground resonance.NTSB CHI91DTG04Accident · No injuriesFinal reportCessna T188C · Walhalla, NDInadequate compensation for wind conditions, and failure to maintain directional control. Factors related to the accident are gusty crosswind conditions.NTSB CHI91LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Devils Lake, NDDirectional control not maintained by the pilot. A factor related to the accident was a crosswind condition.NTSB CHI91LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe pilot's failure to maintain directional control during the landing roll. Related to the accident was the pilot's lack of total experience.NTSB CHI91LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Rolla, NDCompensation for wind was inadequate anad directional control not maintain by the PIC. Contributing factors were: snow covered runway, gusty crosswind, and a snowbank.NTSB DEN90LA128Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wahpeton, NDInadequate compensation for the wind conditions by the pilot. A factor was a strong cross wind, with gusts.NTSB DEN89LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Kindred, NDThe pilot's failure to compensate for the wind conditions during the takeoff. Contributing to the accident were the crosswind conditions.NTSB DEN89LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Devils Lake, NDInadequate compensation for wind conditions by the pilot, which resulted in loss of directional control and an inadvertent ground loop/swerve. Contributing factors were: the crosswind and the pilot's lack of familiarity with the aircraft.NTSB DEN89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe failure of the pilot to correct a ground loop swerve. A lack of total flight experience is considered to be a contributing factor.NTSB DEN89LA072Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mayville, NDThe pilot's failure to maintain control of the airplane after touchdown on an icy runway. Contributing to the accident was improper alignment with the runway for touchdown.NTSB DEN88LA038Accident · No injuriesLimited investigationFinal reportCessna T210R · Bismarck, NDThe plt was attempting to takeoff at dusk on a gravel road. The acft veered off of road and hit a ditch.NTSB DEN87LA200Accident · No injuriesLimited investigationFinal reportCessna 185A · Hillsboro, NDThe 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 DEN87LA149Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Driscoll, NDThe 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 DEN87LA129Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mandan, NDThe 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 DEN87LA071Accident · No injuriesLimited investigationFinal reportCessna 172H · Larimore, NDThe plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over.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 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 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 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 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…