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 SEA89LA083Accident · Serious injuriesLimited investigationFinal reportDavis Starship Alpha · Star, IDFailure of the propeller drive belt (stripped teeth). Contributing factors were: strong/gusty winds and the hilly terrain.NTSB SEA89LA071Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Grangeville, IDA partial power loss due to a blower failure. A factor related to the accident was the soft field condition.NTSB SEA89LA058Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Jerome, IDThe failure of another person to report a hard landing which resulted in the airplane not being inspected by authorized personnel.NTSB SEA89LA048Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cottonwood, IDThe pilot misjudging his altitude due to the white out conditions. Contributing to the accident was the pilots lack of experience in this aircraft and this type of operation.NTSB SEA89LA046Accident · No injuriesLimited investigationFinal reportCessna 180J · Elk City, IDThe pilot's failure to maintain a proper runway alignment on touchdown. Contributing to the accident were the soft snow conditions on the ranch airstrip.NTSB SEA89LA028Accident · No injuriesLimited investigationFinal reportCessna 210D · Twin Falls, IDPrior to landing, the pilot was unable to lower the nose gear by using either the normal or emergency systems. Subsequently, he landed the acft with the main gear extended & the nose gear in the retracted position. After landing, the nose gear uplock actuator…NTSB SEA89LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Idaho Falls, IDPlt reportedly stole acft and departed about midnight in snowstorm. For 3 hours he buzzed local residences vehicles until fuel exhaustion. Forced lndg made in rough field. Investigation revealed plt had long history of mental illness and had falsified medical…NTSB SEA89LA023Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Murphy, IDWhile making a low pass over a snow-covered airstrip, the plt misjudged his altitude. The aircraft's main gear made contact with six inch deep snow, & after traveling aprx 100 ft, the plane nosed over.NTSB SEA89LA014Accident · No injuriesLimited investigationFinal reportCessna 150G · Post Falls, IDThe plt rprtd that due to the airstrip conds, he was making a low, flat apch. He was using carb heat. When power application became necessary, just before landing, the eng did not respond immediately. The plt maintained a nose high attitude to avoid obstacles…NTSB SEA89FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Sun Valley, IDThe pilot flew into a box canyon at a low altitude above the ground near 9000 ft MSL. While attempting to climb over a ridgeline, the aircraft stalled, entered a spin, and descended nose down until impact with the ground.NTSB SEA89LA011Accident · 1 fatalLimited investigationFinal reportRoman LONG-EZ · Salmon, IDThe purpose of the flight was to spot wild game during feeding time (at dusk). The surviving passenger estimated the flight visibility was about one to two mi with smoke. While flying in close proximity to rugged, mountainous terrain, the acft struck a tree…NTSB SEA89LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Fork, IDThe pilot flew the aircraft into a box canyon at dawn. The aircraft was unable to outclimb rising terrain. The aircraft impacted heavily wooded terrain at a slow airspeed at 8,000 feet MSL about 50 yards short of the crest.NTSB SEA88LA185Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Coeur D'Alene, IDWhen pax became ill, plt elected to land in a pasture. Gear contacted dirt mound hidden by tall grass, separating gear.NTSB SEA88LA173Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Priest River, IDOn approach for lndg on rwy 27, the plt noted that the windsock was indicating strong, shifting winds. The acft settled in the flare, despite added power, resulting in hard landing.NTSB SEA88LA172Accident · No injuriesLimited investigationFinal reportYoung-Owens Cassutt 3M · Caldwell, IDOn test flt in preparation for reno air races, plt entered power dive at 10000 ft to 230 KTS and experienced vibrations. He reduced power and entered a steep nose high climb allowing the aircraft to decelerate to near stall speed. The vibration continued. At…NTSB SEA88LA168Accident · Serious injuriesLimited investigationFinal reportCessna 180B · Dixie, IDWhile on final apch to land at the high alt arpt, the plt elected to go around & land at a slower speed. He rprtd that as he neared the rwy on the 2nd apch, the acft enctrd a sudden wind shear, which caused it to drop & bank to the left. Subsequently, the…NTSB SEA88FA166Accident · 1 fatalField investigationFinal reportCessna 150H · Caldwell, IDThe plt flew to hubler field (a pvt 2800' strip) & landed. After landing on rwy 10, he taxied back to the apch end & took off again. As the acft was climbing, about 60' over trees at the departure end, it rolled abruptly to the left, entered a steep descent &…NTSB SEA88LA159Accident · No injuriesLimited investigationFinal reportCessna 150D · Athol, IDAcft had been modified to conventional lndg gear. On landing roll, variable and gusty surface winds were encountered. Plt lost control of acft, which nosed over.NTSB SEA88LA153Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Oreana, IDPlt was circling a friend's ranch at low alt when acft began an uncommanded left roll. Plt was able to level wings before ground contact in rough terrain. Investigation revealed aileron attach bolt missing. Aileron had just undergone repair.NTSB SEA88LA145Accident · No injuriesLimited investigationFinal reportBeech K-35 · Halley, IDEngine pwr loss occurred approaching destinaton about 2000 ft AGL. Plt switched fuel and attempted restart but failed to utilize proper procedures. Acft collided with wire fence hidden in tall vegetation on chosen forced lndg site. Investigation revealed left…NTSB SEA88LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Coeur D'Alene, IDAfter low pass over intended landing area, acft would not outclimb rising terrain in canyon. Plt mushed into brushy clearcut area rather than collide with rough terrain. Plt report stated finding of low compression on 3 cyls. Density altitude estimated at…NTSB SEA88LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Athol, IDThe student pilot was practicing full stop landings. He failed to raise the flaps from full down after the previous landing. On the subsequent takeoff, the aircraft became airborne prematurely. The pilot reduced the power and the aircraft stall/mushed onto…NTSB SEA88FA122Accident · 5 fatalField investigationFinal reportCessna TU-206-G · Root Ranch, IDShortly after takeoff, prior to reaching 500 feet AGL, the pilot lost control of the aircraft and struck trees. After striking trees the aircraft then impacted the ground and exploded into flames. Witnesses stated that from the time of rotation to the time…NTSB SEA88LA118Accident · 1 fatalLimited investigationFinal reportI.C.A. Brasov IS-29D · Athol, IDPlt was on third flt in make/model. Witness stated approach was too low and slow to make airport. Acft made a turn to the left and then to the right. Wing dropped and acft entered stall/spin to the right and continued rotation to the ground.NTSB SEA88LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Orofino, IDPlt stated that due to encircling tstms, elected a precautionary landing at 1800-foot usfs (forrest service) emrrgency strip. Touchdown was long and go-around resulted in a stall/mush into the trees.NTSB SEA88LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Athol, IDPlt landed long to avoid potential conflict with truck waiting to cross rwy. The pilot stated he experienced a tailwind after touchdown. He initiated a go-around but contacted rough terrain in overrun before becoming airborne.NTSB SEA88LA100Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Clementsville, IDThe pilot was using a road as his base of operations for an aerial applications operation. During takeoff the aircrafts' wingtip struck a moving automobile's windshield. The plt did not file an accident report.NTSB SEA88LA081Accident · 1 fatalLimited investigationFinal reportRockwell A-9B · Grace, IDPlt/owner not certificated for aerial application. No record found of prior experience in aerial application. Replaced certificated plt for undet reason. Witnesses observed acft enter stall/spin during first aerial application turnaround maneuver in strong…NTSB SEA88FA069Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Soda Springs, IDWhile en route on a night IFR cargo flt, the plt reqd & was clrd for a dscnt from an IFR cruise alt of 16,000 ft to proceed vfr-on-top. The last transmission from the acft was at 2106 when the plt acknowledged that he was familiar with the terrain along the…NTSB SEA88LA061Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Blackfoot, IDThe pilot lost directional control of the aircraft during gusting crosswinds. During landing rollout the aircraft veered from the centerline of the runway to the right striking a fence. The pilot had only 7 hours of flight time in this aircraft.NTSB SEA88LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Twin Falls, IDWhen the pilot attempted to reduce power to descend to land he was unable to obtain a power reduction due to the throttle rod end separating in flight. The pilot made a spiralling descent and then shut down the engine. The pilot misjudged his altitude and…NTSB SEA88LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172M · St. Anthony, IDDuring landing onto the 50 foot wide snow covered runway, directional control was lost with the aircraft drifting to the left of the runway, striking a snow berm, and then nosing over inverted.NTSB SEA88FA039Accident · 3 fatalField investigationFinal reportBeech B23 · Hamer, IDThe two non instrument rated pilots (owner/pilot in command and second pilot) as well as a passenger departed medicine hat, alberta, Canada, on a pleasure flight to las vegas, Nevada. Upon arrival at great falls, Montana, both pilots were briefed on the…NTSB SEA88LA080Accident · 2 fatalLimited investigationFinal reportCessna 180 · Hailey, IDThis Cessna 180 was on a VFR flight from gooding, Idaho to Hailey, Idaho when it disappeared. The wreckage was later found in a steep canyon about 15 miles from the destination. No mechanical failures were found. Good VFR weather conditions existed at the…NTSB SEA88FA024Accident · 2 fatalField investigationFinal reportCessna 180G · Cambridge, IDDuring a fuel stop at elko, NV the pilot requested a weather briefing for VFR flight to lander, WY or to couer d'alene, ID. The FAA fss briefed him on adverse weather to both destinations, with flight advisories for mountain obscurations, occasional severe…NTSB SEA88LA009Accident · No injuriesLimited investigationFinal reportNapper Vancraft · Pocatello, IDThe experimental gyrocopter was on a test flight when the right rudder pedal pivot bolt broke. The aircraft began a spiral in a counter-clockwise direction with the rudder separating from the aircraft at the hinge points. The aircraft continued to spiral to…NTSB SEA87MA192Accident · Serious injuriesMajor investigationFinal reportFairchild SA227-AC · Twin Falls, IDChk plt was conducting capt proficiency chk on another company plt (PIC) under dark ngt condtns. Subsequent to full stop ldg on rwy 25, takeoff chklst was recited. PIC commenced t/o on rwy 07. Chk plt simulated VI eng cut after liftoff. PIC was unable to…NTSB SEA87FA190Accident · 3 fatalField investigationFinal reportCessna T210L · Hailey, IDAfter dark night takeoff, acft was observed to execute an immediate left turn up a canyon into rising terrain. During climb, acft lights were seen to perform maneuver characteristic of stall/spin. Investigation showed acft struck terrain slightly nose low. No…NTSB SEA87LA183Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Star, IDThe aircraft was to the left of the centerline during takeoff run on the 60 foot wide airstrip. A cross wind was present from the right. The aircraft's left wing struck a person standing close to the runway edge. The pilot stated that he had his eyes on his…NTSB SEA87LA182Accident · No injuriesLimited investigationFinal reportCessna 180H · Salmon, IDWhile on approach for landing a total loss of power occurred for undetermined reasons.NTSB SEA87LA174Accident · 1 fatalLimited investigationFinal reportLutz Flying Dutchman · Twin Falls, IDThe purpose of the flt was to check the acft after replacing a wooden prop with an all metal prop & to prepare for entry in the reno air races. Bfr entering the air races. The plt needed to demonstrate his ability to make a 'barrel roll' & to make 3 lndgs.…NTSB SEA87LA164Accident · No injuriesLimited investigationFinal reportBeech A36TC · Cascade, IDThe plt elected to divert due to hvy rain at his destn. While lndg at an alternate arpt at ngt, hydroplaning occurred & braking was not effective. Drg a go-around, the acft rolled onto the overrun & lifted off, but the acft's main gear struck a rock pile on…NTSB SEA87LA159Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Hamer, IDThe plt rprtd that he bgn taking off on a downhill strip (aprx 1/2 mi long) with a left quartering tail wind. As the takeoff roll progressed, he realized an overrun was developing, so he bgn dumping his load & attempted to lift- off. He said the acft settled…NTSB SEA87LA155Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Mahoney Creek, IDDrg arrival, the plt inadvertently lndd at the mohoney Creek arpt with a 2050' strip, instead of the intended arpt (indian Creek) which had a 5000' rwy. The arpt elev was 4618'; the density alt was about 7800'. While landing, an overrun occurred & the landing…NTSB SEA87LA146Accident · No injuriesLimited investigationFinal reportDavis Starship Alpha · Burley, IDA loss of power occurred shortly after takeoff at about 100 feet AGL. Due to obstacles in the pilot's flight path landing had to be made in a river where the aircraft was substantially damaged. The reason for the power loss could not be determined.NTSB SEA87LA143Accident · No injuriesLimited investigationFinal reportCessna 170B · Coeur D'Alene, IDOn initial climb a partial loss of power occurred and the pilot made a forced landing in a wheat field. During landing roll the aircraft's left main gear struck an irrigation pipe and the aircraft nosed over inverted. No evidence of a preimpact mechanical…NTSB SEA87FA145Accident · 2 fatalField investigationFinal reportCessna T210N · Avery, IDWhile in cruise at 15000 ft MSL, plt requested ATC deviation around tstm shown on acft stormscope. After passing, ATC gave vector to rejoin airway. Plt requested further deviation around another cell. Radio and radar contact were then lost. Investigation…NTSB SEA87IA139Incident · No injuriesIncident investigationFinal reportBeech 55 · Rigby, IDDuring descent for landing, with both engines being fed from the right main fuel tank, a loss of power occurred due to fuel exhaustion. A forced landing was made on a wheat field and during landing rollout the aircraft struck a ditch. Investigation revealed…NTSB SEA87LA163Accident · No injuriesLimited investigationFinal reportCessna T-207 · Mccall, IDDuring climb out to cruise altitude the pilot noticed a drop in manifold pressure and a loss of oil pressure. The pilot was in the process of attempting to reach an airstrip when the oil pressure dropped to zero followed by a total loss of power. An off…NTSB SEA87LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Sun Valley, IDAfter landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence.