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 CHI06CA242Accident · No injuriesData collectionFinal reportBell 47G-5 · Sanborn, NDThe pilot's failure to maintain clearance from the power lines during the aerial application flight. The power lines were a factor.NTSB CHI06LA240Accident · No injuriesLimited investigationFinal reportCessna A188B · Rolla, NDThe pilot's failure to maintain clearance from terrain during the aerial-application flight, and the loss of engine power due to the overstress failure of the engine crankshaft sustained during ground impact. Contributing to the accident was the low-altitude…NTSB CHI06CA229Accident · No injuriesData collectionFinal reportCessna 150 · Jamestown, NDThe pilot's inadequate preflight planning resulted in the pilot not attaining the proper takeoff climb and failure to maintain terrain clearance. Contributing factors included the transmission wires, the row of trees, and the field of corn.NTSB CHI06CA216Accident · No injuriesData collectionFinal reportPiper PA-25 · Minot, NDThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel calculations and the low airspeed which resulted in the pilot stalling the airplane. A factor was the car on the road which prevented the pilot from landing on the road.NTSB CHI06LA223Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Underwood, NDThe pilot's failure to maintain clearance with the power line during the aerial application flight.NTSB CHI06CA162Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Bowbells, NDThe pilot's failure to maintain clearance to the rising terrain while maneuvering during the agricultural application flight. Contirbuting factors were the low altitude operation and the rising terrain.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 CHI06CA168Accident · No injuriesData collectionFinal reportSchweizer 269C · Grand Forks, NDThe dual student's failure to maintain rotor speed during the recovery from the intentional autorotation and the flight instructor's delayed remedial action. Contributing factors were the flight crew's intentional autorotation and dual student's misjudged…NTSB CHI06CA153Accident · No injuriesData collectionFinal reportCessna R182 · Cooperstown, NDThe pilot's inability to gain sufficient altitude during the aborted landing. Factors associated with the accident were the tailwind, the pilot's selection of the runway used, the wet runway, the roadway, and the corn crop.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 CHI05CA246Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Davenport, NDThe pilot failed to gain suffient altitude during takeoff in order to clear the corn crop at the end of the runway. A factor associated with the accident was the corn crop.NTSB CHI05LA211Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Buchanan, NDThe pilot failed to maintain obstacle clearance from the power lines. Factors included the glare on the windshield and the power lines.NTSB CHI05LA188Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Langdon, NDThe pilot's failure to maintain clearance from the terrain while attempting an abrupt turning maneuver at a low altitude.NTSB CHI05CA183Accident · Serious injuriesData collectionFinal reportRockwell S-2R · Guelph, NDThe pilot's failure to maintain clearance to the guy wire during the agricultural application pass. Contributing factors were the guy wire, and low altitude flight.NTSB CHI05LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Buxton, NDA loss of engine power on takeoff due to undetermined reasons. A factor was the ditch that the airplane contacted during the forced landing.NTSB CHI05LA154Accident · No injuriesLimited investigationFinal reportCessna A188B · Washburn, NDThe separation of the tailwheel assembly, the pilot's directional control of the airplane not possible during the takeoff, and the unsuitable terrain the pilot encountered.NTSB CHI05LA145Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Mapleton, NDThe pilot's continued flight into instrument meteorological conditions and his failure to maintain clearance from an object during the precautionary landing. The heavy rain and the unknown object were factors.NTSB CHI05LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Bismarck, NDRupture of the hydraulic powerpak drain line which resulted in a loss of hydraulic fluid and the inability to properly lower the landing gear despite the pilot's execution of the emergency extension procedures. A contributing factor was the runway light…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 CHI05CA074Accident · Serious injuriesData collectionFinal reportCessna 177RG · Fargo, NDThe mechanic's improper installation of the oil filter canister base gasket, which resulted in an oil leak and the separation of the connecting rod due to oil starvation. Factors to the accident were the unsuitable terrain encountered during the forced…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 CHI05LA012Accident · 1 fatalLimited investigationFinal reportCessna 150M · Ashley, NDThe non-instrument rated pilot's continued flight into known adverse weather conditions and his not maintaining aircraft control during cruise flight. Factors present were the night condition and low ceilings.NTSB CHI04LA278Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Gwinner, NDThe pilot's failure to maintain altitude during the circling maneuver. Contributing factors were the pilot's improper decision to execute the approach when weather conditions were below minimums and the low light (dark night) conditions.NTSB CHI04LA225Accident · 1 fatalLimited investigationFinal reportCessna A188B · Mylo, NDThe pilot's failure to maintain clearance from the windmill. The windmill was a contributing factor.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 CHI04CA152Accident · No injuriesData collectionFinal reportCessna 172N · Hillsboro, NDDirectional control not obtained/maintained by the pilot during landing roll.NTSB CHI04CA151Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Hope, NDThe pilot's failure to maintain clearance from the tree branches during the aerial-application flight. A factor to the accident was the trees.NTSB CHI04CA139Accident · No injuriesData collectionFinal reportCessna TR182 · Hamberg, NDThe pilot's inadequate in-flight planning/decision and his misjudgment of speed and distance.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 CHI04LA134Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Argusville, NDThe altitude/clearance not maintained from transmission wire(s) by the pilot during an unknown phase of flight. The transmission wire(s) were a contributing factor.NTSB CHI03LA275Accident · No injuriesLimited investigationFinal reportCessna 170 · Neche, NDThe unsuitable terrain encountered during the precautionary landing. Contributing factors to the accident include the pilot becoming lost/disoriented, his decision to perform a precautionary landing, and the soft terrain encountered during landing.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 CHI03LA215Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Esmond, NDThe obstruction of the windshield by the application chemical restricting the pilot's visual lookout, and the pilot's failure to perform an aborted takeoff. Factors contributing to the accident were the leak in the hopper lid and the drainage ditch.NTSB CHI03LA204Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Ft. Yates, NDThe inadvertent settling with power and unsuccessful remedial action by the pilot. A factor to the accident was the potato crop.NTSB CHI03LA160Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Harvey, NDThe aborted takeoff not performed by the pilot. The inadequate short field takeoff procedure by the pilot and the short grass runway were contributing factors.NTSB CHI03LA139Accident · No injuriesLimited investigationFinal reportErcoupe 415E · Manvel, NDThe pilot's improper flare and inadequate recovery from a bounced landing. A factor contributing to the accident was the collapse of the nose landing gear strut.NTSB CHI03LA134Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Melville, NDThe pilot's failure to maintain clearance from the wires. The low altitude operation and the wires were contributing factors.NTSB CHI03LA122Accident · No injuriesLimited investigationFinal reportCessna 182S · Hatton, NDFailure by the flight instructor to maintain clearance to the tree. Contributing factors were the delayed remedial action by the flight instructor and the tree.NTSB CHI03LA019Accident · Minor injuriesLimited investigationFinal reportCessna 150M · New Town, NDThe pilot's failure to maintain terrain clearance and his inadequate in-flight planning/decision. Contributing factors are the pilot becoming lost/disoriented and night conditions.NTSB CHI02FA269Accident · 2 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe pilot's inadequate visual lookout and his failure to maintain clearance of the transmission wires. Also causal was inadequate preflight planning. Factors associated with the accident were the low altitude and airspeed when the abrupt maneuver was made and…NTSB CHI02LA257Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Kenmare, NDThe pilot's misjudgment of distance and speed. Factors associated with the accident were the sudden wind shift which resulted in a tailwind condition and the rough terrain encountered during the overrun landing.NTSB CHI02CA248Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Ray, NDThe pilot inadvertently stalled the airplane during takeoff. A factor was the tailwind.NTSB CHI02CA192Accident · No injuriesData collectionFinal reportCessna 188B · Tolley, NDThe pilot's failure to attain lift-off speed and his failure to abort the takeoff.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 CHI02LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot not maintaining clearance from a parked van while taxiing to the parking area. The van was a factor.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 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 CHI01LA294Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Alice, NDThe pilot's unsuccessful recovery from an intentional aerobatic stall/spin maneuver. Contributing to the accident were the pilot's impairment (alcohol), and his psychological condition.