NTSB investigations, ID
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\" = 'ID' AND c.\"eventCountry\" = 'USA' 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" = 'ID' AND c."eventCountry" = 'USA' 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 SEA84MA016Accident · 4 fatalMajor investigationFinal reportde Havilland DHC-2 · Challis, IDThe plt took off from the simplot ranch airstrip which was located beside the middle fork of the salmon river, aprx 27 mi northwest of Challis, ID. He departed downriver toward the northeast, but the destination was a usfs strip about 7 mi upriver to the…NTSB SEA84FA015Accident · 2 fatalField investigationFinal reportCessna 150K · Near Challis, IDA witness at the Challis arpt observed the acft takeoff, then turn & depart toward the west. It was found the next day Near Challis creek about 16 mi west of Challis. Impact occurred in a relatively flat area in a narrow wooded valley, at an elevation of…NTSB SEA84LA010Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mccall, IDWhile en route, the plt entered a drainage area in mountainous terrain with the intent of crossing a ridge at the lowest point. As he continued in a canyon, he had a 500 ft/min climb rate & he believed he could easily clear the ridge. However, as he…NTSB SEA84FA007Accident · 1 fatalField investigationFinal reportCessna 182Q · Near Challis, IDThe acft collided with trees at an elevation of 8560 ft MSL. The crash site was on the east side of a ridge & aprx 30 to 40 ft below the ridgeline. The ridge ran northeast-southwest & formed the west side of dry canyon. The plt stated that the eng lost power…NTSB SEA84FA005Accident · Serious injuriesField investigationFinal reportHordemann RV-4 · Kootenai, IDAccording to the plt he was cruising at 11500 MSL when smoke started coming from the lower forward section of the cockpit and a fire developed around his feet. The engine was shut down and the fire subsided or went out. During the glide for landing the engine…NTSB SEA84LA001Accident · No injuriesLimited investigationFinal reportBeech A23 · Burley, IDThe plt was participating in an open course air race to jackpot, NV. He planned to make an en route stop at arco, ID to refuel. The wx forcast called for marginal conditions. The plt made a telephone call to arco & confirmed that the wx (at that time) was…NTSB SEA83LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Colburn, IDThe acft collided with a fence and a ditch during an overrun while landing. The pilot reported he took off with the pitot tube cover on and had flown 7 miles to a private airstrip. The strip was reported to be about 1300 ft long. The pilot stated he landed…NTSB SEA83FA187Accident · 3 fatalField investigationFinal reportCessna 182C · Near Elk River, IDThe acft collided with trees and crashed into heavily wooded area at about 4000 ft MSL. The purpose of flight was to look for game or areas for hunting in a pre-hunting game spotting trip. The acft first impacted a large 200 ft tree about 85 ft below its top.…NTSB SEA83LA194Accident · No injuriesLimited investigationFinal reportEnstrom 280C · N. Hailey, IDThe plt reported that during takeoff from a county road (elevation 5500 ft), he allowed the RPM to drop 'below green.' Reportedly, he had a choice of either setting the helicopter down on the road or flying down a slope to gain airspeed. He elected to land on…NTSB SEA83FA179Accident · No injuriesField investigationFinal reportMooney M20E · Nampa, IDWhile climbing, aprx 10 miles west of the departure airport, the eng lost power. The plt attempted to glide back to the arpt. When he realized he could not reach the arpt, he selected a grassy field for an emergency landing. During the landing roll, the right…NTSB SEA83LA177Accident · No injuriesLimited investigationFinal reportCessna 185E · Boise, IDThe acft landed in a near maximum velocity crosswind and while braking to control/correct a swerve, the right main landing gear separated from the acft. The landing was on rwy 28R and the wind was from 200 degrees at 10 to 14 KTS on final and 12 KTS when the…NTSB SEA83LA170Accident · No injuriesLimited investigationFinal reportAerospatiale SA-315B · Montpelier, IDThe plt & 3 passengers were on a flt to find drilling supplies that had been dropped off of a truck on the previous day. The plt reported that he was hovering down an abandoned road at about 5 to 10 mph & 15 to 20 ft AGL when the helicopter collided with…NTSB SEA83LA165Accident · No injuriesLimited investigationFinal reportCessna T210L · Driggs, IDThe plt stated that the fuel tanks were topped off on the day before he departed el monte, CA. He estimated that the acft had 534 lbs of fuel on board & consumed 80 pph during cruise at 9500 ft MSL. According to the plts operating manual, the acft had an…NTSB SEA83FA162Accident · 1 fatalField investigationFinal reportPiper PA-36 · Firth, IDAccording to witnesses, the acft was overheard returning to the strip for a second load. Reportedly, it went into a steep bank at about 70 ft AGL & turned toward the strip. As the wings leveled, sounds of high eng power ceased & the acft descend to the…NTSB SEA83LA159Accident · Minor injuriesLimited investigationFinal reportVangrunsven RV-3 · Twin Falls, IDThe home built plane was one of a flt of four acft that were being flown on a cross-country flt. While en route from hillsboro, or to Twin Falls, ID, the pilots had to divert around weather. As they were approaching Twin Falls, N17RV lost power from fuel…NTSB SEA83LA154Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Tensed, IDThe acft had made 3 passes since reloading, so the acft was fairly heavy and was on an uphill pass as it began a turn- around. In an attempt to maneuver and clear 100 ft trees the acft stalled and the rt wing tip hit a tree.NTSB SEA83LA149Accident · No injuriesLimited investigationFinal reportCessna 170 · Mullan, IDThe acft collided with a telephone line during maneuvering to stay VFR and clear of ground obstructions. The pilot said he was approaching lookout pass at about 500-800 ft AGL and was following interstate 90 westbound. He inadvertently entered IFR conditions…NTSB SEA83LA144Accident · No injuriesLimited investigationFinal reportCessna 180 · Salmon, IDThe pilot said he encountered a high sink rate during the approach. Directional control was lost after the pilot failed to arrest the sink rate and made a hard landing. The acft left the runway and collided with a fence before coming to rest.NTSB SEA83LA138Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Bliss, IDAccording to the plt, he was returning to a road to land & reload chemicals for aerial application. He stated that the right main tire went flat during flt due to a puncture. During the landing roll-out, the acft veered to the right & nosed over.NTSB SEA83LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Fort Hall, IDThe acft nosed over during a forced landing after a power loss. The pilot stated that during a descent to an arpt the engine suddenly lost power. Emergency start procedures failed and a forced landing was made in a grain field. During roll out the acft nosed…NTSB SEA83LA132Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Jerome, IDThe acft was destroyed by fire after a forced landing due to pwr loss. The pilot stated that he was en route home after an aerial application mission when the engine lost power. He made an auto-rotation downwind and after exiting the acft noticed an engine…NTSB SEA83LA105Accident · No injuriesLimited investigationFinal reportCallair A-9B · Winear, IDThe acft collided with a fence during an off airport forced landing. The pilot was completing an aerial application pass & when the low fuel warning light came on the pilot switched tanks & turned on fuel booster. The engine quit at about 200 feet AGL.…NTSB SEA83LA102Accident · Serious injuriesLimited investigationFinal reportCessna TRI82 · Idaho Falls, IDDuring takeoff, the engine lost power after the plt started to make a turn at aprx 500 ft AGL. An emergency landing was made in a plowed field with the gear & flaps retracted. After touchdown, the acft slid aprx 100 yards, then stopped in a canal. An…NTSB SEA83LA090Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Malad City, IDDuring an interview, the plt reported that he had removed ice from the acft & attempted to depart from a snow covered alfalfa field, aprx 1000 ft long. The acft did not become airborne & the plt elected to abort the takeoff. During the abort, the acft…NTSB SEA83LA083Accident · No injuriesLimited investigationFinal reportHiller 12-E · Near Nordm, IDThe aircraft broke through crusted snow on a county road during landing and rolled over. The helicopter was on a business flight and the pilot did not claim any mechanical discrepancies. The weather was VMC and none of the 3 occupants were injured. The snow…NTSB SEA83LA085Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Blanchard, IDThe aircraft collided with a fence during landing on a narrow strip in a variable crosswind. The pilot had taken off from the same airstrip earlier without difficulty. He said a strong gust of wind struck his aircraft as it was touching down. This displaced…NTSB SEA83LA080Accident · No injuriesLimited investigationFinal reportCessna TU-206 · Dixie, IDThe aircraft collided with a pine tree off the departure end of the runway during landing. The airstrip being used is 1200 feet long. The purpose of using it was to give the pilot under instruction experience in bush-type airstrips. The p.u.I. Was making the…NTSB SEA83LA077Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · American Falls, IDThe acft was damaged in an off airport forced landing due to water in the fuel. The acft took off and at 3OO feet the left engine quit. The pilot was attempting a left turn back to the airport when the right engine started to sputter. Thepilot landed straight…NTSB SEA83LA074Accident · No injuriesLimited investigationFinal reportCessna 172G · Near Homedale, IDThe flt originated before sunset, but the student plt practiced in the local area until the onset of darkness. While attempting to land on his private strip, he made 2 go-arounds. On the second go-around, the acft collided with an electrical wire, then flew…NTSB SEA83LA070Accident · Minor injuriesLimited investigationFinal reportPartenavia P68C/TC · Dixie, IDThe acft stalled, dragged the left wing and collided with a fence during landing. A 2nd pilot with limited multi-engine experience was making the landing. When power was reduced about 10 feet above the threshold, the acft stalled. The left main gear and the…NTSB SEA83FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Glenns Ferry, IDThe acft collided with wires and crashed during a low pass while it was being delivered to a repair station. The pilot was flying low to keep pace with his wife who was following in a car to transport the pilot after landing. Witnesses observed the acft…NTSB SEA83FA113Accident · 2 fatalField investigationFinal reportCessna 182Q · Mccall, IDThe acft impacted a rocky slope of a box canyon at the 6300 foot level. The weather was reported to be IMC with thunderstorms, overcast skies and the mountain tops obscured. The wreckage location was on a direct line between departure point and destination.…NTSB DCA83AA017Accident · Serious injuriesFinal reportde Havilland DHC-6-300 · Hailey, IDThe acft was less than 2 miles from the arpt of intended landing during the approach when the crew experienced a loss ofelevator control. The acft started diving toward the ground when the power was reduced. The plt applied full power to try and restore level…NTSB SEA83LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · Payette, IDThe acft bounced after a hard landing and drifted off the runway into a tree. The acft then stopped in the mud and nosedover. The landing was on runway 31 and the wind was 360 degrees at 8 KTS.NTSB SEA83FA045Accident · 1 fatalField investigationFinal reportCromwell/Pitts S-1S · Athol, IDThe plt tookoff with an estimated 7 gal of fuel on board. While performing aerobatic maneuver, he entered a vertical, climbing, power-on maneuver. Witnesses reported that the acft climbed to zero airspeed at about 2500 ft AGL. Reportedly, the acft then slid…NTSB SEA83LA043Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Pocatello, IDDuring a missed approach a partial power loss occurred during the transition to climb. The plt executed a course reversal to return visually to the arpt. Shortly thereafter he chose to execute an emergency landing on a frontage road which paralleled rr…NTSB DCA83AA010Accident · 2 fatalFinal reportCanadair CL-600-1A11 · Hailey, IDThe acft crashed into the side of a mountain ridge during a VFR attempt to land at an arpt with no instrument approach. The mountain ridge was obscured by broken clounds. The plt had cancelled his IFR clearance, & during the descent to the arpt, he had…NTSB SEA83LA030Accident · Serious injuriesLimited investigationFinal reportTaylorcraft L-2 · Near Gooding, IDThe pilot made a steep turn close to the ground while taking photographs of coyotes. The aircraft stalled and contacted the ground.NTSB SEA83IA027Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Boise, IDShortly after climbout from denver the first officer noticed the captain twitch and asked if he was okay. The captain answered affirmatively but donned his oxygen mask at the co-pilot's suggestion. About 20 minutes later the captain stiffened with his left…NTSB SEA83FA057Accident · 1 fatalField investigationFinal reportCessna TU206G · Soda Springs, IDA search for the aircraft was begun after the pilot's relatives reported it was overdue and residents near the crash site heard the sounds of a low flying plane suddenly terminate. Unofficial reports of the weather indicated it was about 200 ft obscured, 1/4…NTSB SEA83FYA01Accident · 1 fatalFinal reportCessna 180B · Near Irwin, IDThe pilot and two passengers were on a local flight to spot moose. While flying low with the flaps extended, the aircraft collided with trees on rising terrain, then impacted on the ground and burned. Initial impact occurred with a 75 ft tall tree, about 60…NTSB SEA83LA020Accident · No injuriesLimited investigationFinal reportCessna T210G · Mccall, IDThe pilot reported that when he applied back pressure to raise the nose for takeoff, the aircraft felt sluggish, so he released some back pressure to gain airspeed. The pilot reported he then heard a loud metallic "bang" and stated that a vibration started in…NTSB SEA83LA015Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Midvale, IDShortly after lift-off, the engine lost power. The pilot elected to make a forced landing in a plowed field near the end of the runway. The right main gear failed to clear the barbed-wire perimeter fence. Subsequently, the aircraft touched down in a yaw and…NTSB SEA83LA008Accident · No injuriesLimited investigationFinal reportCessna T210M · Ashton, IDDuring a flight from el paso, TX to three forks, MT, the pilot noted clouds below his cruising altitude while crossing the Montana border. When he arrived at his destination, he was above a solid overcast, so he diverted to west yellowstone, MT. During…NTSB SEA83FA009Accident · 2 fatalField investigationFinal reportBoeing Vertol 107 · Cascade, IDDuring a log slinging operation a loud bang was heard & the acft was observed to rapidly descend vertically to the ground with numerous small fragments falling in the same vicinity. The #5 synchronization shaft was found to be fractured at the forward end…NTSB SEA83LA006Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Coeur D'Alene, IDDue to glassy water and dusk conditions, final approach for landing was flown parallel to a log boom for surface reference. After touching down, the aircraft bounced back into the air and a go-around was initiated. During the go-around, the aircraft drifted…NTSB SEA83LA012Accident · No injuriesLimited investigationFinal reportCessna 206 · 40 Nm Wnw Salmo, IDThe pilot began a takeoff from a runway covered with about six inches of wet snow and slush in calm wind conditions. He reported that during the takeoff, the right main wheel settled back to the runway and encountered an area of soft snow and slush. The…NTSB SEA83LA001Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Salmon, IDThe plt reported that the strip had about 1,500 ft of usable length, the remaining 3,050 ft consisted of unpacked snow &slush. The usable width of the first 1,500 ft was reported as 8-12 ft. at the time of takeoff the first 1,500 ft was covered with hard…NTSB SEA82DA172Accident · No injuriesFinal reportCessna 188B · Lava Hot Spring, IDReportedly, the aircraft ran out of fuel during a swath run. During a forced landing, the aircraft struck a fence, then traveled about 400 ft and stopped with the nose down in a potatoe field.NTSB SEA82FA163Accident · 2 fatalField investigationFinal reportde Havilland DHC-II · Mahoney Creek, IDThe acft was observed flying over the strip in what appeared to be a normal downwind pattern. It crashed about 300 ft below windy ridge on the northwest face. The autopsy report indicated the plt had a "patchy healed myocardial infarct" prior to the accident.…