Final NTSB investigations, ND
180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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 CHI01LA309Accident · No injuriesLimited investigationFinal reportCessna T210N · Fargo, NDthe emegency procedure not followed by the pilot.NTSB CHI01LA281Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Kenmare, NDThe pilot failed to maintain clearance with the terrain during the aerial application flight. Factors associated with the accident were the high vegetation and the pilot's diverted attention during the flight.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 CHI01LA252Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Edmore, NDThe incorrect installation of the wheel assembly bolts by maintenance personnel resulting in the stripped bolt threads and ultimate failure of the wheel, and directional control not possible by the pilot. A factor was the ditchNTSB CHI01LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bowman, NDAltitude/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 CHI01LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mandan, NDthe pilot failed to maintain clearance from the powerline. Additional factors were the thermal lift and the powerline.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 CHI01LA188Accident · No injuriesLimited investigationFinal reportAyres S2R-G1 · Mohall, NDthe pilot not maintaining clearance between the airplane and the truck when he backed the airplane off of the loading pad. Factors relating to this accident was the pilot's inadequate visual lookout and the truck.NTSB CHI01LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · West Fargo, NDthe pilot's inadequate preflight planning and the unsuitable landing area selected by the pilot. Additional factors were the uneven terrain and the failed float assembly in overload.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 CHI01LA040Accident · No injuriesLimited investigationFinal reportCessna 150K · Minot, NDthe student pilot's inability to maintain aircraft control on the ground. Factors relating to the accident were the high winds, the slush-covered taxiway, the snowbank, inadequate preflight planning by the flight instructor, and the instructor pilot's failure…NTSB CHI00LA246Accident · Minor injuriesLimited investigationFinal reportSummers RV4 · Bismarck, NDInadequate 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 CHI00LA245Accident · No injuriesLimited investigationFinal reportCessna 152 · Arthur, NDthe water contamination found in the fuel and the pilot misjudging his altitude during the emergency procedure. A factor was the terrain condition of the corn crop.NTSB CHI00LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Park River, NDdirectional control not being maintained by the pilot during landing.NTSB CHI00LA210Accident · No injuriesLimited investigationFinal reportGrumman G164 · Mcville, NDthe pilot's failure to maintain clearance with the power lines. A factor associated with the accident was the power line.NTSB CHI00LA178Accident · 1 fatalLimited investigationFinal reportWeatherly 201C · Tolna, NDthe wing spar fatigue and wing separation while maneuvering. A factor was that the fatigue was not detected by the mechanic during the last annual inspection.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 CHI00LA144Accident · No injuriesLimited investigationFinal reportCessna C-T188C · Elgin, NDthe failure of the pilot in command to maintain clearance with the ground during an aerial application.NTSB CHI00LA133Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Galesburg, NDthe pilot misjudged the landing flare which resulted in a hard landing.NTSB CHI00LA109Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Sherwood, NDcarburetor ice and the pilot's improper decisions when to use carburetor heat and to perform a soft field landing. Factors relating to this accident were the improper use of carburetor heat, the soft field landing attempt, and the snow covered field.NTSB CHI00LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Stanley, NDthe pilot's improperly performed flare.NTSB CHI00LA043Accident · 2 fatalLimited investigationFinal reportMcCarty Wittman W-8 Tailwind · Jamestown, NDthe wing spar failure due to its inadequate construction by the owner/builder.NTSB CHI00LA028Accident · Serious injuriesLimited investigationFinal reportShaffer Evans Volksplane · Stanley, NDrefueling 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 CHI99LA338Accident · No injuriesLimited investigationFinal reportCessna 182R · Fargo, NDthe pilot misjudged the landing flare which resulted in the airplane porpoising during the landing.NTSB CHI99LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 401B · Mccanna, NDthe inadvertent stall 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 CHI99LA230Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fargo, NDthe altitude/clearance not maintained by the pilot.NTSB CHI99LA229Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lefor, NDthe altitude/clearance not maintained by the pilot.NTSB CHI99LA219Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Fargo, NDfuel starvation due to the pilot's fuel mismanagement and the pilot's misjudgment of the landing flare.NTSB CHI99LA215Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Page, NDthe pilot's failure to compensate for the wind conditions. Factors were the sudden windshift and the crops.NTSB CHI99FA196Accident · 1 fatalField investigationFinal reportBeech C-23 · Mandan, NDthe pilot failed to maintain aircraft control on approach to the airport after encountering high winds, gusts, rain, and thunderstorms in the area.NTSB CHI99LA162Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Buxton, NDthe 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 CHI99LA020Accident · 1 fatalLimited investigationFinal reportBecker Wag Aero Super Sport · Hamilton, NDthe fatigue failure of the lower wing strut attachment bracket.NTSB CHI99LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · Rugby, NDthe pilot failed to maintain directional control.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 CHI98LA337Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL M18B · Tappen, NDthe pilot's improper preflight preparation resulting in the airplane exceeding the available airstrip distance during takeoff. A factor contributing to this accident was the swamp.NTSB CHI98LA348Accident · No injuriesLimited investigationFinal reportCessna A185F · Bottineau, NDThe partial loss of engine power for undetermined reasons, and the pilot's excessive use of brake pressure which resulted in the aircraft nosing over..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 CHI98LA306Accident · Minor injuriesLimited investigationFinal reportRockwell S2R · Kindred, NDthe pilot did not maintain clearance with obstructions along his flight path.NTSB CHI98LA301Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · La Moure, NDa loss of engine power due to undetermined reasons.NTSB CHI98LA292Accident · No injuriesLimited investigationFinal reportBell M74L · Grand Forks, NDThe worn rotor clutch shoes, and subsequent loss of main rotor rpm.NTSB CHI98LA266Accident · No injuriesLimited investigationFinal reportCessna R182 · Bismarck, NDThe fatigue failure of the fuel system line fitting.NTSB CHI98LA259Accident · 1 fatalLimited investigationFinal reportAnderson T Craft Special · Pick City, NDThe pilot's failure to maintain sufficient altitude/clearance with terrain. A factor was the pilot's attempted low altitude acrobatic maneuver.NTSB CHI98LA271Accident · Minor injuriesLimited investigationFinal reportVollmers Sonerai II L · Lincoln, NDLoss of engine power due to a corroded ignition wire. Related factors were the tailwind, and ditch.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 CHI98LA241Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fort Ransom, NDA 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 CHI98LA236Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Langdon, NDthe total loss of engine power for reasons undetermined. A factor was rough and uneven terrain.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 CHI98LA222Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer 164B · Hatton, NDthe delayed abort by the pilot, the overweight condition of the airplane, and the pilot's inadequate preparation prior to takeoff. Factors contributing to this accident were the wet condition of the airstrip, the hopper dump valve not working, and the road…