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 CEN11CA521Accident · No injuriesData collectionFinal reportMills GS-2 · Jamestown, NDThe pilot's loss of directional control during landing in gusty crosswind conditions.NTSB CEN11CA477Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Minot, NDThe pilot's inadequate inspection of the takeoff area which resulted in a collision with terrain and the subsequent loss of control during takeoff.NTSB CEN11LA397Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDThe student pilot's inadequate recovery from an autorotation and the CFI's delayed remedial action.NTSB CEN11LA386Accident · No injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe flight instructor’s delayed remedial action to the student pilot’s bounced landing and subsequent loss of aircraft control.NTSB CEN11LA390Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.NTSB CEN11CA306Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Crosby, NDThe pilot’s failure to maintain directional control of the airplane during the crosswind landing.NTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.NTSB CEN11CA071Accident · No injuriesData collectionFinal reportGrumman G-164 · Michigan, NDThe pilot's failure to abort the takeoff roll following a noticeable loss of engine power due to low engine compression and a magneto failure.NTSB CEN10CA412Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Edmore, NDThe pilot's selection of unsuitable terrain for landing.NTSB CEN10CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Northwood, NDThe pilot’s failure to maintain adequate clearance from the transmission wire.NTSB CEN10CA333Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawa-Okecie PZL-104 Wilga 80 · Linton, NDThe pilot's failure to maintain aircraft control during landing with a 90-degree crosswind.NTSB CEN10CA228Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Jamestown, NDThe pilot's failure to lower the landing gear, resulting in a gear-up landing.NTSB CEN10TA194Accident · Serious injuriesFinal reportBeech 95-B55 · Center, NDThe inadvertent in-flight collision with several Mallard ducks.NTSB CEN10CA191Accident · No injuriesData collectionFinal reportMaule M-5-210C · Bismarck, NDThe pilot’s failure compensate for the crosswinds resulting in a loss of directional control while landing.NTSB CEN10CA026Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Grand Forks, NDThe flight instructor's failure to ensure the landing gear was extended prior to landing.NTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09LA565Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Arvilla, NDThe aircraft owner/mechanic/pilot's installation of an improper tail boom assembly and the resulting fatigue failure of the tail boom's attach fittings.NTSB CEN09CA470Accident · No injuriesData collectionFinal reportRaytheon C90A · Bismarck, NDThe cabin entry door inadvertently opening during initial climb.NTSB CEN09CA452Accident · Minor injuriesData collectionFinal reportWeatherly 620B · New England, NDThe loss of engine power for undetermined reasons while maneuvering at low altitude.NTSB CEN09CA404Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare that resulted in a hard landing.NTSB CEN09CA402Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.NTSB CEN09LA231Accident · No injuriesLimited investigationFinal reportCessna R172K · Hazen, NDThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN09CA219Accident · No injuriesData collectionFinal reportAeronca 7AC-CONV · Stanley, NDThe pilot's failure to maintain directional control during landing.NTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.NTSB CHI08CA238Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Buffalo, NDThe pilot's excessive descent rate and his failure to maintain clearance from terrain during the spray run entry.NTSB CHI08CA201Accident · Minor injuriesData collectionFinal reportGrumman G-164D · Esmond, NDThe pilot's delay in advancing the throttle during the takeoff which resulted in inadequate airspeed and the subsequent stall/mush. Factors associated with the accident were the leaking hopper, the pilot continuing to operate the airplane with the known…NTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.NTSB CHI08CA142Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's failure to maintained directional control during the aborted landing. Contributing to the accident was the student pilot's total lack of experience in the type of airplane.NTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…NTSB CHI08LA101Accident · 2 fatalLimited investigationFinal reportCessna 172K · Roseglen, NDThe pilot failed to maintain obstacle clearance from the TV antenna during a low altitude maneuver. Contributing factors were the antenna, the night conditions, and pilot impairment due to alcohol.NTSB CHI08IA022Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Fargo, NDThe failure of the Brake and Steering Control Unit, which allowed the nose landing gear to turn to the 90-degree position.NTSB CHI08CA021Accident · Minor injuriesData collectionFinal reportBell 206B-III · Medora, NDThe pilot failed to maintain clearance from the fence while maneuvering at a low altitude, which resuled in the helicopter rolling over and impacting the terrain. A factor associated with the accident was the fence.NTSB CHI08CA002Accident · No injuriesData collectionFinal reportPiper PA28-161 · Grand Forks, NDThe lack of experience and the excessive taxi speed by the pilot. A contributing factors was the airport sign.NTSB CHI07CA298Accident · Minor injuriesData collectionFinal reportMaule M-4-220C · Keene, NDThe pilot's failure to maintain control of the airplane during takeoff due to the high crosswind condition. Contributing factors were the high, gusting crosswind, and the tree.NTSB CHI07CA267Accident · No injuriesData collectionFinal reportSnow S-2C · Hazelton, NDThe loss of engine power for undetermined reasons.NTSB CHI07LA254Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Overly, NDThe pilot's failure to maintain terrain clearance during the agricultural application flight. Contributing to the accident was the wheat crop.NTSB CHI07CA248Accident · No injuriesData collectionFinal reportBeech B60 · Bismark, NDThe improper fuel grade due to the improper fueling of the airplane by the fixed base operator, which led to the loss of engine power of both engines. A factor was the unsuitable terrain encountered during the forced landing.NTSB CHI07CA226Accident · No injuriesData collectionFinal reportHamilton Rotorway Exec 90 · Harvey, NDThe pilot's failure to maintain clearance from the airport ramp area during the return for landing, which resulted in the landing skid dragging on the edge of the pavement and causing the helicopter to roll over.NTSB CHI07CA215Accident · No injuriesData collectionFinal reportRotorway 162F · Heart, NDThe pilot inadvertently shut off the fuel pump switch which resulted in fuel starvation and the subsequent loss of engine power. An additional cause was the pilot's poorly executed autorotation/flare which resulted in a hard landing.NTSB CHI07CA209Accident · Serious injuriesData collectionFinal reportAir Tractor AT-301 · Lignite, NDThe pilot's poor in-flight planning and failure to maintain control of the airplane when he encountered his own vortex turbulence at a low altitude.NTSB CHI07CA181Accident · No injuriesData collectionFinal reportBell 206B · Grand Forks, NDThe certified flight instructor's inadequate compensation for the gusting wind conditions and failure to maintain control of the helicopter during a hover for takeoff. A factor contributing to the accident was the gusting wind conditions.NTSB CHI07LA162Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Watford City, NDThe agricultural pilot's failure to maintain clearance from the terrain while maneuvering to avoid power lines. The power lines were a contributing factor in the accident.NTSB CHI07CA161Accident · No injuriesData collectionFinal reportWeatherly 201C · Mc Clusky, NDThe pilot's failure to check for fuel contamination during the preflight inspection, which resulted in a loss of engine power shortly after takeoff due to water contamination. Contributing factors to the accident included the rough/uneven field and the…NTSB ENG07IA030Incident · No injuriesIncident investigationFinal reportLearjet 36 · Bismarck, NDA total loss of engine power during takeoff due to the right engine sustaining a fractured fan blade after the ingestion of a mallard duck. Some liberated fan blade fragments were uncontained, penetrating the nacelle.NTSB CHI07LA064Accident · No injuriesLimited investigationFinal reportCessna 414A · Dickinson, NDThe undetermined failure of the emergency landing gear system and the retraction of the right main landing gear during landing.NTSB CHI07CA019Accident · No injuriesData collectionFinal reportAviat S2B · Larimore, NDThe pilot's failure to maintain proper alignment with the runway which resulted in the airplane nosing over. A factor associated with the accident was the soft terrain encountered.NTSB CHI07CA003Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Fargo, NDThe pilot's inadequate flare which resulted in a hard landing. Factors associated with the accident were the gusty winds and the pilot's lack of experience.NTSB CHI06CA257Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Anamoose, NDThe pilot not maintaining altitude/clearance from terrain during the aerial application pass.NTSB CHI06FA275Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kulm, NDThe non-instrument rated pilot's continued flight into instrument meteorological conditions which resulted in his inadvertent encounter with a thunderstorm and his loss of aircraft control. A factor to the accident was the thunderstorm.