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 CHI95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Williston, NDThe failure of the pilot to maintain directional control on takeoff. The soft condition of the field was a factor.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 CHI95FA124Accident · 1 fatalField investigationFinal reportBeech 65-B80 · Great Bend, NDthe pilot/mechanic's inadequate maintenance (inspection) of aircraft and the pilot's failure to maintain airspeed (VMC). Factors were icing conditions, deteriorated induction air ducting, and failure of a piston assembly.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 CHI95LA076Accident · No injuriesLimited investigationFinal reportBeech V35A-TC · Pembina, NDthe pilot's misjudgement of the actual altitude of the airplane. Factors were the visual illusion caused by the snow covered runway environment and the whiteout weather condition.NTSB CHI95LA072Accident · No injuriesLimited investigationFinal reportStuart/Wagner Mountain Eagle · Halliday, NDThe pilot's premature lift-off and delayed aborted takeoff.NTSB CHI95IA066Incident · No injuriesIncident investigationFinal reportBeech 1900D · Williston, NDthe improper installation and inadequate quality assurance inspection of the elevator trim cable during original manufacture, which resulted in fraying and failure of the cable prior to the first routine scheduled inspection of the system.NTSB CHI95LA046Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Dickinson, NDThe flight instructor (CFI) misjudged the flare, which resulted in a hard landing. Factors related to the accident were: the adverse weather (icing) condition, structural ice, windshield ice, darkness, and the lack of visual cues for the pilot to land.NTSB CHI95LA025Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Beulah, NDthe failure of the pilot to maintain directional control.NTSB CHI95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Grand Forks, NDthe fatigue failure of the crankshaft.NTSB CHI95LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210R · Lakota, NDPartial loss of engine power due to preignition and/or detonation, which resulted in failure of the number 4 cylinder. The unfavorable tailwind for landing was a related factor.NTSB CHI94LA347Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Washburn, NDthe pilot's failure to maintain sufficient airspeed during the landing flare. Factors associated with the accident were the poorly planned approach and the soft terrain.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 CHI94LA316Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot-in-command's (CFI) delayed recovery from a practice autorotation. A factor associated with the accident was the student pilot's improper autorotation.NTSB CHI94T#A03Accident · No injuriesFinal reportBellanca BL28 · Ellendale, NDNTSB CHI94LA285Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hettinger, NDthe pilot's improper use of the wheel brakes.NTSB CHI94LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Spiritwood, NDthe failure of the fuselage tubing in the empennage.NTSB CHI94LA241Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Eckelson, NDthe pilot's failure to maintain clearance from a transmission wire. A factor associated with the accident is the transmission wire.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 CHI94T#A02Accident · No injuriesClass 3Final reportContinental Copters MK 5 Tomcat · Minot, NDNTSB CHI94LA218Accident · No injuriesLimited investigationFinal reportCallair A9B · Minot, NDthe pilot's failure to maintain clearance from the wheat field. A factor was the turbulence.NTSB CHI94DTG02Accident · No injuriesFinal reportAir Tractor AT301 · Lawton, NDThe pilot's improper use of carburetor heat. The carburetor icing weather condition was a factor.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 CHI94LA166Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Hillsboro, NDthe pilot's failure to maintain clearance from a tree.NTSB CHI94LA138Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Fargo, NDthe pilot in command's improper autorotation technique. A factor associated with the accident is the FAA Inspector's delayed remedial action.NTSB CHI94GA093Accident · 4 fatalFinal reportCessna 401A · Minot, NDFailure of the pilot to maintain proper altitude during a missed approach. Factors related to the accident were: the unfavorable weather and snow covered terrain.NTSB CHI94LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Forks, NDFuel starvation due to the improper positioning of the fuel tank selector by the student pilot.NTSB CHI94LA087Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDthe improper maintenance installation (cotter pin) by other maintenance personnel. Factors were main landing gear scissors not safetied properly and extension of landing gear not possible by pilot-in-command (CFI).NTSB CHI94LA085Accident · No injuriesLimited investigationFinal reportCessna 182P · Glen Ullin, NDThe delayed application of the carburetor heat by the pilot-in-command. The carburetor icing weather condition was a factor.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 CHI93IA346Incident · No injuriesIncident investigationFinal reportCessna 414A · Dickinson, NDthe total failure of the airplane's heater system combustion air pressure safety switch.NTSB CHI93DTG03Accident · No injuriesFinal reportPiper PA-25-235 · Washburn, NDthe loss of engine power due to a magneto failure.NTSB CHI93LA318Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Minto, NDThe pilot's failure to maintain adequate aircraft control during ground maneuvering. Inadequate visual outlook by the pilot and the pilot of the other aircraft was a contributing factor.NTSB CHI93LA299Accident · No injuriesLimited investigationFinal reportCessna 170B · Steele, NDThe pilot-in-command's poor in-flight decision and failure to maintain proper clearance.NTSB CHI93DTG02Accident · No injuriesFinal reportAero Commander S2R · Hoople, NDA loss of engine power due to a cracked engine cylinder.NTSB CHI93LA263Accident · No injuriesLimited investigationFinal reportGrumman G164B · Wyndmere, NDthe pilot's decision to land on unsuitable terrain. Factors in the accident are the wet and soft turf runway.NTSB CHI93LA232Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Northwood, NDThe pilot in command's failure to attain a proper touchdown point.NTSB CHI93LA215Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilton, NDFailure of the engine-driven fuel pump. A factor was the pilot's failure to select the auxiliary fuel pump.NTSB CHI93LA208Accident · No injuriesLimited investigationFinal reportHughes 269 · Valley City, NDthe pilot-in-command's failure to maintain clearance from a tree during an aerial application manuever.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 CHI93LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Northwood, NDThe flight instructor's inadequate supervision of the flight.NTSB CHI93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Bismarck, NDThe pilot's failure to refuel the airplane en route to ensure adequate fuel to complete the flight.NTSB CHI93LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, NDThe student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.NTSB CHI93LA093Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Cannonball, NDThe blockage of the inlet air filter from snow.NTSB CHI93FA053Accident · 1 fatalField investigationFinal reportPiper PA-30 · Bowman, NDThe non instrument rated private pilot's failure to maintain adequate terrain clearance after inadvertent VFR flight into instrument meteorological conditions.NTSB CHI93LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Makoti, NDThe pilot not maintaining a proper glidepath during his approach to landing.NTSB CHI93FA028Accident · Minor injuriesField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Wahpeton, NDOther maintenance personnel's improper maintenance (installation).NTSB CHI93LA017Accident · 1 fatalLimited investigationFinal reportPiper PA-25-260 · Trenton, NDThe pilot's improper aircraft handling while maneuvering at low altitude.NTSB CHI93LA013Accident · No injuriesLimited investigationFinal reportSchweizer H-300 · Grand Forks, NDThe pilot's failure to maintain control of the helicopter during a night landing.