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 SEA85LA070Accident · No injuriesLimited investigationFinal reportFairchild SA-227AC · Hailey, IDOn ldg the experienced captn encountered a right drift on the dry rwy with negligible winds. Rudder/pwr/nosewheel steering inputs were insufficient to regain directional control. Right drift translated into a strong right swerve with continued application of…NTSB SEA85LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Nampa, IDWhile flying at ngt in the LCL practice area south of Nampa, the plt thought he had flown into IMC, but the wx was good. He was unable to see the ground, so he made a 180 deg turn, then noted problems seeing his instrument panel. Suspecting psbl carbon…NTSB SEA85FA067Accident · 1 fatalField investigationFinal reportCessna 175 · Bancroft, IDThe acft impacted level terrain aprx 500 yards east of the Bancroft arpt. N9386B was one of a flt of two acft returning to Bancroft from preston, ID. The wx had deteriorated during the flt with snow showers and blowing snow. While the other acft was landing…NTSB SEA85LA064Accident · No injuriesLimited investigationFinal reportLyoyd Thompson Pober Pixie · Nampa, IDLeft main gear contacted runway-taxiway intersection lights during a landing roll. Acft then nosed over. Rwy width is 75 ft.NTSB SEA85LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Boise, IDWhile taxiing on the ramp after landing, the right wing of the acft struck a jet blast fence. The plt stated two linemen were guiding the acft at the time.NTSB SEA85LA037Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Boise, IDOn final approach, the pilot's wife, also a rated pilot, was reviewing the landing check list. At item 'heaters off' she inadvertently turned fuel selectors to off. Both engines lost pwr and pilot executed a forced landing short of runway in rough terrain,…NTSB SEA85LA041Accident · No injuriesLimited investigationFinal reportCessna 441 · Coeur D' Alene, IDOn takeoff run, acft drifted left of center line, left seat pilot made corrective rudder input then right seat pilot made additional corrective input. Acft yawed moderately to left and contacted a snow berm. Acft spun left 180 degrees and slid backward to a…NTSB SEA85LA026Accident · No injuriesLimited investigationFinal reportCessna 402C · Boise, IDDescent was made to aprx 50 ft AGL to observe a herd of cattle. Acft contacted power lines cutting off the left wing tip. Flt continued and landing was made at Boise air terminal without incident. Plt stated he did not see wires.NTSB SEA85LA023Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Pocatello, IDThe acft had descended to about 900 AGL after passing through icing conditions with a light accumulation of ice. When the landing gear was lowered the acft started yawing and the acft engine instruments were flucuating. The plt thought that the engines were…NTSB SEA85LA022Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Nampa, IDFollowing a power loss-induced forced landing two days prior, the acft fuel pump and carburetor were changed and fuel lines flushed. Six hours of uneventful operations ensued before the power loss leading to this mishap occurred. Pwrloss occurred when the…NTSB SEA85LA033Accident · No injuriesLimited investigationFinal reportCessna 175 · Indian Meadows, IDLanded long and acft slid off end of rwy on compact snow and ice contacting a snow berm near end of rwy.NTSB SEA85LA019Accident · 3 fatalLimited investigationFinal reportCessna U206 · Dixie, IDThe acft crashed shortly after takeoff from yellow pine bar airstrip, witnesses observed the acft depart to the sw, enter a steep left turn immediately after liftoff, cross the river in a turn and impact the south bank abeam the airstrip. A ground fire broke…NTSB SEA85LA007Accident · No injuriesLimited investigationFinal reportCessna 180 · Burley, IDAs plt initiated takeoff in a left x-wind, acft began to weathervane to the left. Increased right rudder and repeated applications of right brake failed to arrest an increasing swerve to left, with right brake pedal eventually bottoming out. As acft departed…NTSB SEA85LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Aberdeen, IDAccording to the solo student plt, while accelerating through 40 KTS during takeoff the acft began to drift to the left. The acft departed the rwy, rolled through two fences and nosed over in the soft ground.NTSB SEA84LA231Accident · No injuriesLimited investigationFinal reportDrake Quickie II · Twin Falls, IDThe plt said that the acft porpoised 2 or 3 times after initial touchdown. After bouncing, the acft veered to the rt, ground looped and nosed over after contacting the soft ground off the side of the rwy.NTSB SEA84LA230Accident · No injuriesLimited investigationFinal reportCessna R-182 · Mountain Home, IDThe pilot was landing on a road to visit friends when the acft collided with a gate during the roll. The pilot had originally intended to land at a nearby municipal arpt after flying over the friends house. Due to the close proximity of Mountain Home air…NTSB SEA84FA228Accident · Serious injuriesField investigationFinal reportPiper PA-32-301T · Burley, IDWhile climbing after takeoff, the eng surged twice, then quit. The plt repositioned the fuel selector, checked that the electric fuel pump was 'on' & restarted the eng, then started to return to the departure arpt. However, about 1 min later, the eng lost…NTSB SEA84LA226Accident · No injuriesLimited investigationFinal reportMaule M6 · Driggs, IDAfter landing long and fast brakes were applied, directional control was lost and the acft ground looped off of the rwy. The acft collided with and came to rest in a ditch.NTSB SEA84FA217Accident · 4 fatalField investigationFinal reportCessna 210K · Mccall, IDTwo acft departed in trail intending to follow a river through the mountainous terrain in their climb above the ridge line. The first acft proceeded as planned along the river and turned toward the dest at a safe alt. About 1/4 of a mile behind, the second…NTSB SEA84LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Shoshone, IDThe plt attempted takeoff from a wet alfalfa field. High vegetation and soft terrain prevented proper acceleration to lift off speed. The nosewheel struck an embankment and the aircraft nosed over.NTSB SEA84LA208Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Shelley, IDThe pilot indicated that he was en route to spray a local field when the engine began to run rough. He diverted to an ag strip nearby, but the engine ceased operation prior to reaching the strip. The aircraft struck an irrigation pivot during the forced…NTSB SEA84LA199Accident · No injuriesLimited investigationFinal reportRockwell Thrush SR2 · Nampa, IDThe acft began to lose power while engaged in aerial application so the plt dumped his load and headed for the airstrip. Enroute the power deteriorated so the plt elected to land. Cutting the mixture gave the engine a surge which caused an overshoot into…NTSB SEA84LA195Accident · Serious injuriesLimited investigationFinal reportCessna 210-5(205) · Mountain Home, IDDuring climb the rpms started to decrease. The acft was unable to maintain alt and a forced landing was made. During investigation a bogus fuel filter was found between the fuel control unit and the fuel injector. The filter was clogged with debris. The…NTSB SEA84FA196Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · Bonners Ferry, IDThe plt took off with 3 adult passengers & a 2 yr old child on board & flew aprx 1.3 hrs. Just prior to the accident, he reported on a left downwind for rwy 20. As the plt continued the apch, the acft was observed over the rwy at aprx 100' AGL, reportedly at…NTSB SEA84LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Elk City, IDThe plt stated that while landing on the uphill curved airstrip a 30 knot tailwind gust occurred. Due to obstacled and the wind, the plt disregarded an aborted landing and continued straight ahead on the runway. The acft traveled off the departure end of the…NTSB SEA84LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Burley, IDThe acft made a forced landing in a potato field and nosed over after the engine lost power. The plt said she used carburetor heat when the engine started running rough. The engine did not immediately improve but was running in surges from 1800-2200 RPM. The…NTSB SEA84LA177Accident · No injuriesLimited investigationFinal reportCessna 150H · Worley, IDThe pilot was performing a touch-and-go landing on an 80 foot wide, turf and gravel runway. The plt stated that he made a normal lnding but during the takeoff the acft lifted off the gnd then settled back on the rwy. The acft then swerved off the left side of…NTSB SEA84LA188Accident · No injuriesLimited investigationFinal reportCessna 182 · Craigmont, IDAccording to the plt, during landing the brakes failed and the acft came to a stop about 10 ft beyond the end of the rwy after rolling into a shallow ditch. Maint personnel examined the right wheel brake system and found no mechanical malfunction or leakage…NTSB SEA84LA161Accident · No injuriesLimited investigationFinal reportCessna 172 · Moscow, IDThe acft ran off the rwy into tall wet weeds during a landing on a private agricultural airstrip. The plt said a x-wind caused the swerve. A weather reporting station 6 NM away reported the wind as 7 KTS with no gusts. The plt landed to thenorth and the…NTSB SEA84LA151Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Shelley, IDThe acft collided with the ground during an ag flt. The plt reported the winds were 3 to 5 KTS with no gusts when the accident occurred but that the winds are unpredictable at the base of the mountains and a gust of wind caught the acft. The plt also stated…NTSB SEA84LA118Accident · Minor injuriesLimited investigationFinal reportVarga 2150-A · Mountain Home, IDThe student plt became lost on the last leg of his x-country, solo flt. He final determined that his position was over boise, ID, about 35 mi from his destination. He turned to follow railroad tracks. About 15 min later, the eng ceased operating due to fuel…NTSB SEA84FA110Accident · 1 fatalField investigationFinal reportRockwell S-2R · American Falls, IDThe load/ground crew reported that the plt planned to make 1 more spray run before flying back to the home base. When the acft did not return to the loading area, they assumed he had returned to the base. They drove 20 mi back to the base, but found neither…NTSB SEA84LA109Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Craigmont, IDDuring aerial application the engine lost power & a forced landing was initiated to a wheat field. During the landing approach the acft stalled at about 10 to 20 feet AGL. The acft landed hard and flipped over. Examination of the engine revealed a broken…NTSB SEA84LA105Accident · No injuriesLimited investigationFinal reportHelio H-700-SP · Meridian, IDThe plt stated that while landing onto his own field the left main gear caught in a deep furrow. The acft then veered to the right striking a woven wire & barbed wire fence, & a railroad tie.NTSB SEA84LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Driggs, IDDuring a landing, the plt encountered a porpoise which increased in severity. He added full power, raised the nose & initiated a go-around, during which, the stall warning horn sounded. The plt reported that he left the carburetor heat on & left the flaps in…NTSB SEA84LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Challis, IDThe student plt on a supervised solo flt made a hard landing and during the bouncing the acft hit nose gear first. The nose gear collapsed and the acft slid to a stop in a nose down attitude.NTSB SEA84LA079Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Idaho Falls, IDThe student plt was on a solo x-country flt & had refueled at twin Falls, ID. When she took off, both fuel tanks were full. While descending thru about 6000 ft, near the destination arpt, the eng sputtered & quit running. The student enriched the mixture,…NTSB SEA84LA074Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Hailey, IDThe student plt attempted to taxi back on the active rwy after landing and groundlooped. During the swerve the left wingcontacted a snow bank. The student plt recommended no tail-up taxiing.NTSB SEA84LA073Accident · No injuriesLimited investigationFinal reportCessna 152II · Preston, IDThe solo student plt was making a takeoff after a touch-and-go landing. The acft swerved to the left, collided with a snowbank, and nosed over.NTSB SEA84FA071Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Humphrey, IDWhile on a x-country flt, the acft entered an area of rising terrain & blowing snow & the plt initiated a turn to reverse direction. During the turn, he encountered reduced visibility & the acft collided with the top of a knoll on snow covered rolling…NTSB SEA84FA065Accident · 5 fatalField investigationFinal reportPiper PA-28-181 · Lewiston, IDThe acft crashed in mountainous terrain while the non-instrument rated plt was on a flt in marginal wx conditions. An investigation revealed that the acft had impacted in a steep nose down, high speed descent. No preimpact/mechanical problem was found. About…NTSB SEA84FA063Accident · 2 fatalField investigationFinal reportEnstrom 280C · Middleton, IDThe acft collided with the terrain during a test flt. Witnesses observed the acft rotate about 180 degrees about its vertical axis go nose low and descend vertically to the ground. A noise change described as a 'sputter' or tone change' was heard during this…NTSB SEA84LA059Accident · No injuriesLimited investigationFinal reportCessna 172RGII · Grangeville, IDThe acft ground looped during landing on an icy rwy and nosed over after leaving the rwy. The landing was made with a right quartering tailwind.NTSB SEA84LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Burley, IDThe plt stated the engine lost power because of fuel exhaustion. A forced landing was performed in a field during which the acft contacted a ditch. The acft was flown 4.1 hrs since it had last been refueled.NTSB SEA84LA035Accident · No injuriesLimited investigationFinal reportHughes 269C · Almo, IDThe plt stated, he was attempting to depart with visibility of 1/8 to 1/4 mi in fog. Shortly after departure the visibility dropped to approximately 50 to 100 ft. he attempted a slow runing landing and landed hard.NTSB SEA84FA036Accident · 3 fatalField investigationFinal reportCessna C172N · Arco, IDAccording to company personnel, the flt was operated as a charter. The plt, also the company director of operations, was not authorized to conduct FAR 135 flights under instrument flight conditions. He was reported to have stated that he was going to 'get a…NTSB SEA84FA030Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Pocatello, IDDuring arrival, the plt initiated an ILS apch to rwy 2L. At that time, the wx in part was 700 ft scattered to broken, 1300 to 1500 ft overcast,visibility 1 to 1 1/2 mi with light snow & fog. About 3 min after calling inbound on the apch, the plt initiated a…NTSB SEA84LA028Accident · No injuriesLimited investigationFinal reportCessna A-185F II · Driggs, IDThe acft collided with a hidden snow berm while landing on a snow covered rwy. The new snow was 2 to 3 inches deep over a compacted snow base. The rwy was plowed to a width of 30 to 35 ft with 3 ft berms. The plt stated that he encountered a whiteout during…NTSB SEA84LA025Accident · No injuriesLimited investigationFinal reportBell 206-BIII · Kooskia, IDThe helicopter landed hard and rolled over to the right. The events started when the pilot heard the end of a seat belt banging against the outside of the acft where it had been caught in the door. The pilot decided to land and secure the belt. During landing…NTSB SEA84FA020Accident · 1 fatalField investigationFinal reportJodel-Bernier Jodel F-11 · Inkom, IDThe acft crashed during a forced landing attempt after the engine quit. The pilot reported the engine stopped while in cruise flt. It started and stopped and started a 2nd time but would not maintain flt. The pilot turned toward a hayfieldfor landing. The…