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 GAA18CA241Accident · No injuriesData collectionFinal reportAeronca 65 LB · Carrington, NDThe pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.NTSB CEN18LA097Accident · No injuriesLimited investigationFinal reportPiper PA 24-260 · Fargo, NDThe pilot's failure to use the published emergency procedures to manually extend the landing gear when an electrical failure precluded normal extension of the landing gear, resulting in the gear collapse during landing. Contributing to the accident was the…NTSB CEN18LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Dickinson, NDThe pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN17LA275Accident · Minor injuriesLimited investigationFinal reportGolden Circle Air T-BIRD II · Dunn Center, NDThe pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.NTSB CEN17LA244Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 602 · Stirum, NDThe pilot's decision to attempt flight with low-level fog in the area, which resulted in an encounter with instrument meteorological conditions and impact with terrain.NTSB CEN17FA045Accident · 1 fatalField investigationFinal reportCessna 340 · Fargo, NDThe loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.NTSB CEN17LA004Accident · No injuriesLimited investigationFinal reportVolaircraft 10A · Mandan, NDThe student pilot’s failure to maintain the proper approach path on landing, which resulted in impact with terrain short of the runway.NTSB CEN16CA393Accident · No injuriesData collectionFinal reportBell 230 · Fargo, NDThe pilot's failure to maintain clearance from the ground obstacle during the landing with gusting winds present.NTSB CEN16LA350Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Upham, NDThe pilot's failure to obtain a proper aimpoint during landing due to reduced visibility from the setting sun.NTSB CEN16LA314Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Valley City, NDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB GAA16CA326Accident · No injuriesData collectionFinal reportSchweizer G 164 · Cummings, NDThe pilot's failure to maintain an adequate rate of descent while landing, which resulted in a hard landing, short of the runway.NTSB CEN16FA212Accident · 3 fatalField investigationFinal reportPiper PA 28-140 · Wishek, NDThe pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…NTSB GAA16CA168Accident · No injuriesData collectionFinal reportHughes 369 · Jamestown, NDThe pilot's excessive descent rate while flaring during a practice autorotation with a power recovery, which resulted in an impact with terrain.NTSB CEN16LA098Accident · No injuriesLimited investigationFinal reportCessna 441 · Fargo, NDThe pilot’s failure to cycle the surface deice boots during the instrument approach in icing conditions, which led to ice accumulation on the leading edges of the wings and empennage, and resulted in an aerodynamic stall and subsequent hard landing.NTSB CEN16LA089Accident · No injuriesLimited investigationFinal reportCessna 208B · Grand Forks, NDThe pilot's failure to properly calculate the airplane's weight and balance and center of gravity, which resulted in the tail striking the ground.NTSB CEN16LA012Accident · No injuriesLimited investigationFinal reportRefling RV8 · Bottineau, NDThe pilot/builder’s failure to ensure that the fuel line was properly secured, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB CEN15LA383Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Harvey, NDThe partial loss of engine power due to a failed magneto and two cylinders with low compression. Contributing to the accident was the pilot/owner’s decision to operate the airplane with an ongoing engine issue.NTSB GAA15CA144Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Williston, NDThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with runway marking signs.NTSB GAA15CA090Accident · Minor injuriesData collectionFinal reportPiper PA 25-260 · Casselton, NDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance, which resulted in the inflight collision with power transmission line wires.NTSB GAA15CA103Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Steele, NDThe pilot's failure to maintain directional control during landing, which resulted in a collision with objects while attempting to abort the landing.NTSB CEN14CA513Accident · No injuriesData collectionFinal reportSchweizer 269C · Grand Forks, NDThe flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a tail rotor strike.NTSB CEN14CA410Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Beach, NDThe student pilot's failure to initiate a go-around sooner, and his failure to maintain directional control.NTSB CEN14FA400Accident · 1 fatalField investigationFinal reportLarry Ketterling FEW P-51 Mustang · Lisbon, NDThe partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…NTSB CEN14CA366Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Cavalier, NDThe pilot's loss of control during the takeoff roll.NTSB CEN14LA358Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Garrison, NDExcessive wear between the power turbine shaft and quill shaft spline, which led to the disconnection of the power turbine wheel, an overspeed of the power turbine, and the subsequent loss of engine power. Contributing to the accident was maintenance…NTSB CEN14CA187Accident · No injuriesData collectionFinal reportCessna 172 · Larimore, NDFailure of the pilot to attain and maintain sufficient control inputs to compensate for the crosswind. Contributing to the accident was the flight instructor's failure to adequately monitor the pilot and the flight.NTSB CEN14LA074Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-181 · Rock Lake, NDThe noninstrument-rated pilot’s failure to obtain weather briefings immediately before and during the flight and his continued flight into icing conditions, which resulted in the airplane’s loss of performance and the subsequent controlled descent into trees…NTSB CEN13LA353Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · Minot, NDThe pilot’s failure to maintain adequate clearance from trees during an aerial application flight.NTSB CEN13LA348Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate recovery from a bounced landing, which resulted in an aerodynamic stall during the go-around.NTSB CEN13CA345Accident · Minor injuriesData collectionFinal reportCessna 140 · Minot, NDThe pilot's failure to maintain aircraft control during takeoff.NTSB CEN13IA107Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · Williston, NDThe snowplow driver’s failure to ensure that the runway was clear before driving onto it, which resulted in a runway incursion with a departing airplane.NTSB CEN12LA615Accident · 1 fatalLimited investigationFinal reportGoodyear F2G · Valley City, NDThe pilot’s decision to initiate the aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.NTSB CEN12LA587Accident · No injuriesLimited investigationFinal reportAviat A-1 · Rolla, NDThe pilot's failure to secure the right wing's fuel cap before the flight and to properly manage the available fuel supply during the flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN12CA542Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Harvey, NDThe pilot’s decision to take off with the airplane over its maximum gross weight on a turf runway and with a tailwind, and his subsequent failure to maintain airplane control.NTSB CEN12LA516Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe loss of directional control during landing roll, which resulted in a runway excursion. The reason for the loss of directional control could not be determined because postaccident examination did not reveal any malfunctions or anomalies that would have…NTSB CEN12LA444Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to adequately monitor his student's actions during the approach.NTSB CEN12LA437Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Mott, NDThe rupture of a corroded oil line, which resulted in a total loss of engine power due to oil starvation.NTSB CEN12CA426Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot’s inadequate landing flare, which resulted in a hard landing.NTSB CEN12CA430Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Williston, NDThe pilot's failure to ensure a suitable landing surface.NTSB CEN12LA458Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egeland, NDThe partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB CEN12CA423Accident · Serious injuriesData collectionFinal reportEipper Quicksilver · Manvel, NDThe non-certificated pilot’s failure to maintain clearance from a wheat field.NTSB CEN12LA344Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Kenmare, NDThe pilot's failure to maintain directional control during an aborted takeoff.NTSB CEN12LA336Accident · 1 fatalLimited investigationFinal reportBellanca 8GCBC · Zahl, NDThe non-certificated pilot's improper preflight planning, which resulted in fuel exhaustion, and his failure to maintain airplane control after a total loss of engine power.NTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.NTSB CEN11LA593Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-400 · Monango, NDThe pilot did not maintain adequate separation from a tree during the aerial-application flight.NTSB CEN11LA598Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN11CA570Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Minot, NDThe pilot's failure to maintain directional control during the crosswind landing, resulting in a ground loop.NTSB CEN11LA541Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Hettinger, NDInternal failure of the engine for undetermined reasons.NTSB CEN11FA508Accident · 1 fatalField investigationFinal reportBeech A36 · Williston, NDThe pilot's improper fuel management, which resulted in fuel starvation and a partial loss of engine power while maneuvering at a low altitude.NTSB CEN11CA502Accident · No injuriesData collectionFinal reportCessna A188B · Devils Lake, NDThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall during the aerial application.