Final NTSB investigations, ND
45 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 6 |
| 1990 | 3 |
| 1992 | 4 |
| 1994 | 1 |
| 1995 | 4 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 3 |
| 2003 | 1 |
| 2006 | 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\" = 250)
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" = 250) 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 CHI06CA156Accident · No injuriesData collectionFinal reportCessna 182N · Cooperstown, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control while landing. Factors associated with the accident were the crosswind condition, the high vegetation which the airplane contacted, and the high…NTSB CHI03LA266Accident · No injuriesLimited investigationFinal reportCessna 172G · Bowdon, NDThe 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 CHI01LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's improper flare, and the flight instructor's delayed remedial action, which resulted in a loss of directional control.NTSB CHI01LA273Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Hazelton, NDthe pilot's ostentatious display when he performed a low level manuever and stalled the airplane.NTSB CHI01LA214Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Langdon, NDthe pilot stalled the airplane while manuevering to avoid the power lines. A factor was the power lines.NTSB CHI00LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Portland, NDthe 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 CHI00LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Maddock, NDAircraft control not being maintained by the pilot. Factors to the accident were the turbulent weather condition, the inadvertent stall, and the inadequate weather evaluation by the pilot.NTSB CHI99LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Mcville, NDthe pilot not attaining a proper climb rate. Factors were the stall/mush and the ditch.NTSB CHI99LA020Accident · 1 fatalLimited investigationFinal reportBecker Wag Aero Super Sport · Hamilton, NDthe fatigue failure of the lower wing strut attachment bracket.NTSB CHI98LA361Accident · 2 fatalLimited investigationFinal reportChampion BL-7-GCBC · Upham, NDThe pilot's steep pull and failure to maintain adequate airspeed, which resulted in a stall/spin. Contributing factors were the pilot's lack of familiarity with the airplane's handling qualities, and a lack of recent experience in the airplane.NTSB CHI98LA305Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe 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 CHI98FA119Accident · 1 fatalField investigationFinal reportCessna 208B · Bismarck, NDthe pilot's failure to maintain adequate airspeed during the approach which resulted in an inadvertant stall. Factors associated with the accident were the icing conditions and the pilot's low level experience in this make and model of airplane.NTSB CHI98LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Edgeley, NDThe pilot's inadequate in-flight planning/decision making which resulted in a delayed go-around and his not maintaining aircraft control. A factor was the crosswind.NTSB CHI96LA064Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Munich, NDthe pilot allowed his airspeed to get too low and encountered a stall/mush condition. Factors associated with the accident were the pilot not being able to maintain directional control due to misuse of the controls for wind drift correction and improper use…NTSB CHI95LA323Accident · 1 fatalLimited investigationFinal reportHaugen Kolb Firestar II · Souris, NDthe pilot's failure to maintain control of the ultralight vehicle.NTSB CHI95LA241Accident · No injuriesLimited investigationFinal reportCessna 188 · Bremen, NDthe pilot's inadequate preflight planning. Deteriating aircraft performance was a factor.NTSB CHI95LA217Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Kenmare, NDthe pilot's not obtaining/maintaining proper climb rate.NTSB CHI94LA345Accident · No injuriesLimited investigationFinal reportCessna 150G · New Town, NDThe pilot's improper use of wing flaps and premature lift-off. The pilot's poor preflight preparation was a factor.NTSB CHI92FA220Accident · 3 fatalField investigationFinal reportBeech V35B · Northwood, NDSpatial disorientation of the pilot in command during initial climb.NTSB CHI92LA196Accident · 2 fatalLimited investigationFinal reportLuscombe 8E · Napoleon, NDThe pilot's failure to maintain airspeed above a stall.NTSB CHI92DTG03Accident · No injuriesFinal reportGrumman G-164A · Orr, NDA stall encountered during the spray run reversal turn. Factors related to the accident are the attempted downwind turn, and insufficient altitude for recovery.NTSB CHI92DTG01Accident · Serious injuriesFinal reportPiper PA-25-235 · Gardner, NDAn inadvertent stall with insufficient altitude for recovery.NTSB CHI90FA214Accident · 2 fatalField investigationFinal reportCessna 150L · Donnybrook, NDThe pilot's failure to maintain airspeed while maneuvering in hilly terrain. Contributing factors were the pilot's failure to maintain adequate altitude and the surrounding steeply rising terrain.NTSB DEN90FA161Accident · 2 fatalField investigationFinal reportCessna 150L · Hettinger, NDThe 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 DEN90DTG02Accident · 1 fatalFinal reportEugene N. Rausch RV-4 · Erie, NDAn inadvertent stall.NTSB DEN87FA224Accident · Serious injuriesField investigationFinal reportChampion 7ECA · Devils Lake, NDThe acft was observed flying at low altitude and circling a farm that belonged to the plt's sister. After making two passes by the farm, the acft crashed in a corn field. The plt said he was looking for a field in which to land, and on the 2nd pass, the acft…NTSB DEN87LA196Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fargo, NDPlt 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 DEN87LA137Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Sawyer, NDThe commercial plt and his wife were on a cross country flt and were landing for refueling. On final, the acft began an uncommanded left turn as landing flaps were selected. The plt was unable to correct the turn and struck trees short of the private…NTSB DEN87LA114Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Valley City, NDThe 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 DEN87LA101Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Argusville, NDThe plt took off with a load of 46-0-0 fertilizer and proceeded to the field to be treated. The plt said when he arrived his flagger was not in position so he initiated a goaround. When the plt had turned 90 deg onto the x-wind leg the acft stalled. The plt…NTSB DEN87LA085Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Cando, NDThe acft attempted landing and on short final, the plt recognized a pickup truck obstructing the rwy near midfield. A go around was attempted resulting in an inadvertant stall. The left wing dipped, struck the rwy, and skidded into the vehicle. The acft and…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 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 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 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 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 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 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 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 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 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 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 DEN82DA108Accident · No injuriesFinal reportCallair A-9B · Rolla, NDThe pilot reported that after loading with chemical, water, and fuel, he went to a field and began spraying. He stated that after he had made his first swath run, he was turning for a second swath when the plane stalled and crashed. The landing gear,…NTSB DEN82DA050Accident · Serious injuriesFinal reportPiper PA-11 · Devils Lake, NDThe pilot and passenger/pilot were making low, slow passes over fisherman on the ice. The pilot reversed directions and the aircraft stalled. The pilot stated he was looking at the ground and became distracted.NTSB DEN82DA047Accident · No injuriesFinal reportTaylorcraft BC-12D · Lisbon, NDThe pilot stated that during the landing on runway 15, at an altitude of approximately 20 to 30 feet, the wind coming over the snowbanks on the sides of the runway caused turbulence that raised the aircraft and pushed it to the left of the runway. The…