NTSB investigations, OR
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\" = 'OR' 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" = 'OR' 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 SEA84FA078Accident · 2 fatalField investigationFinal reportBeech N35 · Baker, ORThe plt encountered airframe icing while en route during a x-country flt. He had filed an instrument flt plan to boise, ID, but en route, he changed destinations twice, 1st to ontario, OR, then later to Baker, ID. At 1820 PDT, he reported icing & turbulence…NTSB SEA84LA075Accident · No injuriesLimited investigationFinal reportCessna T210N · Seaside, ORThe acft nosed over during a forced landing in a soft field after a loss of power. The plt said that while the acft was descending thru about 6000 ft MSL, he ran the left fuel tank dry before switching tanks. His attempt to restart the engine, using the right…NTSB SEA84LA067Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Elmira, ORThe acft collided with power lines and trees after a power loss during the takeoff initial climb. The plt stated he attempted a climbing turn to avoid the power lines and trees but the acft entered a departure stall, the acft was using automotive fuel. An FAA…NTSB SEA84LA066Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Forest Grove, ORThe plt reported that while hovering, during an external load operation, the eng lost power & blue smoke & flames exited the back of the helicopter. The helicopter then struck trees before coming to rest. During an investigation, the eng started normally &…NTSB SEA84FA068Accident · 6 fatalField investigationFinal reportPiper PA-28RT-201 · Hood River, ORAfter crossing the dalles at 12,500 ft MSL, the plt reported to ARTCC he was entering solid clouds. He subsequently reported level at 3,000 ft MSL followed by 'if ah we can't stay VFR we'll go ahead and climb up to about five and file IFR.' The acft was…NTSB SEA84LA061Accident · No injuriesLimited investigationFinal reportBeech A33 · White City, ORThe acft crashed into trees after stalling into the ground during an attempted takeoff from a soggy short sod airstrip. The acft was rotated prematurely after which it stalled at about 40 ft AGL. The plt said he should have walked the fieldto determine its…NTSB SEA84FA058Accident · 3 fatalField investigationFinal reportPiper PA-28-J3A5D · Mountaindale, ORThe acft crashed during an instrument approach to hillsboro airport. Witnesses reported seeing the acft below a very low overcast sky condition prior to impact. Examination of the wreckage revealed that the stabilator failed in overload before the point of…NTSB SEA84LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Roseburg, ORThe acft drifted left during the student pilots landing and collided with VASI lights. After the collision the acft nosed over. The CFI on the ground said the wind shifted just prior to the last landing.NTSB SEA84LA056Accident · No injuriesLimited investigationFinal reportNavion A · Albany, ORThe acft crashed into a tree and a fence during a forced landing following engine stoppage during the initial climb after takeoff. Investigation revealed that the acft had only one cup of fuel mixed with water and rust in the tank beingused. The right tip…NTSB SEA84LA054Accident · No injuriesLimited investigationFinal reportAerospatiale AS-341G · Alma, ORThe plt stated he lost partial power on a x-country flt, during cruise, and initiated an autorotation. At about 200 to 300 ft AGL he reduced the throttle to idle. During flare the rotor RPM decayed and the acft landed hard and rolled over. The pilot stated…NTSB SEA84LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Burns, OROn departure the pilot heard a thumping noise from the undercarriage and the landing gear position lights went out. He executed a visual return and approach to a precautionary landing. During the landing roll, the left main gear collapsed.NTSB SEA84FA048Accident · 1 fatalField investigationFinal reportSikorsky S-61L · Medford, ORThe plt deviated from the painted taxi line to avoid a parked fuel truck and collided with a hangar door. The main rotor hit the door and flying debris damaged 2 hangers,3 acft and 2 cars.NTSB SEA84LA047Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Imnaha, ORThe acft nosed over during a forced landing on a snow covered field. The plt reported that the acft began to lose power at about 6500 ft MSL. An inspection of the eng did not reveal any mechanical malfunction or discrepancy.NTSB SEA84LA044Accident · No injuriesLimited investigationFinal reportCessna T21OL · Bend, ORThe plt reported that he departed boulder city, NV with 92 gal of fuel on board. About 4 hrs & 10 min later, he was forced to land when the eng lost power from fuel exhaustion. According to him, the fuel gages had been indicating normal with an indication of…NTSB SEA84LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Klamath Falls, ORThe plt attempted a takeoff on a slushy soft rwy. The takeoff was aborted at the rwy midpoint due to lack of acceleration. During the abort the acft collided with a fence and nosed over. The plt thought the rwy conditions and carburetor ice.NTSB SEA84LA038Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Newport, ORThe acft collided with a ditch during landing. The construction ditch ran across the rwy. The rwy had been notamed as out of service except for the last 2000 ft. the plt stated that the 3 white barriers marking the position of the construction ditch had blown…NTSB SEA84LA034Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Mapleton, ORWhile approaching the spray area, the acft was in a level attitude at 20 to 25 mph & about 100 ft AGL when the plt heard a loud bang & noted a loss of power. He attempted an autorotative landing. During touchdown on hilly terrain, the acft rolled to the right…NTSB SEA84FU001Accident · Serious injuriesFinal reportEipper Quicksilver MX · Junction City, ORAccording to the plt, he was operating the ultralight between 50 & 200 ft AGL, when he experienced throttle control difficulties. He reported that while correcting the problem, his attention to the surrounding environment was reduced. When he returned his…NTSB SEA84LA029Accident · No injuriesLimited investigationFinal reportPiper PA18-A · Rome, ORThe acft nosed over in the snow during an enroute landing while on a cross country. The plt had landed at this arpt a week before. In the meanwhile there had accumulated 14 inches of snow on the rwy. During the rollout in this snow the acft suddenly stopped…NTSB SEA84LA026Accident · No injuriesLimited investigationFinal reportHelio H-391B · Hood River, ORAccording to FAA inspectors, the plt made a hi speed turnoff onto a taxiway after landing & ground looped the acft. The plt stated that the right brake failed, the acft rolled off the rwy into mud & the plane spun 270 deg to the left. However, the right brake…NTSB SEA84LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Oregon City, ORThe plt, who was an a & p mechanic, had just installed an eng that had been overhauled by someone else. He reported that the pretakeoff & run-up checks were normal. At aprx 250 to 300 ft AGL, during takeoff, the eng began to shake violently & lost power. The…NTSB SEA84LA021Accident · Minor injuriesLimited investigationFinal reportEnstrom F28F · Hillsboro, ORThe acft did a hard landing during autorotation after the engine ran rough and quit at 250 ft AGL during takeoff. The pilot had leaned the mixture, he said, prior to takeoff and he was not sure if he pushed the mixture to full rich when the engine started to…NTSB SEA84FA017Accident · 1 fatalField investigationFinal reportCessna A185F · 4nm W Of Boring, ORThe acft collided with 3 major objects, a tree, a house and a motor home during an attempted go-around. The pilot had attempted a landing on a soft short dirt road near his home. The length of the road was 462 ft. he landed 74 ft short ofmarkers at the…NTSB SEA84LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-125 · Bandon, ORThe plt & a flt instructor (CFI) were on a local flt for a biennial flt review. During a simulated forced landing, the acft was allowed to develop a high rate of sink. The CFI stated that they encountered a low level wind shear near the rwy & touched down…NTSB SEA84LA012Accident · No injuriesLimited investigationFinal reportBell 212 · Coos Bay, ORThe helicopter snagged a cable with its skid during takeoff and rolled over. The acft had landed for fuel and was takingoff after refueling when a cable attached to a fertilizer dispencer caught on the helicopter's skid. The acft rolled to the right and…NTSB SEA84LA009Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Portland, ORAccording to the plt, he had made a right turn into the wind after lift-off & had just cleared a fence at 40 to 50 ft AGL, when he began to lose power. He then turned to the right to clear power lines. Since the helicopter did not have enough room to clear…NTSB SEA83LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Gleneden Beach, ORAccording to the plt, he arrived at an unlighted arpt on a dark night. After making 2 passes over the arpt to identify the rwy & landmarks, he made an apch to land. The acft touched down with aprx 1/3 of the 3000 ft rwy remaining. The plt initiated a missed…NTSB SEA83LA202Accident · No injuriesLimited investigationFinal reportCessna 150M · La Grande, ORThe acft made a hard landing during an aborted takeoff. The pilot stated that after takeoff he thought he could not clear the trees at the departure end of the rwy. He closed the throttle and attempted to re-land his acft. During touchdown on the rough dirt…NTSB SEA83LA175Accident · Minor injuriesLimited investigationFinal reportPitts S-1S · Madras, ORThe acft collided with the ground while performing low level aerobatics over the arpt. The pilot stated that was practicing a low level pass over the arpt and that while rolling he felt the acft was not responding correctly. He said his rate of descent was…NTSB SEA83LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Baker, ORThe pilot said the acft veered 180 degrees, hit a depression and then the left wing struck the ground. The pilot was landing on rwy 30 which was closed for resurfacing. The x's had been moved 50 ft off the centerline of the rwy. The acft left landing gear…NTSB SEA83LA169Accident · No injuriesLimited investigationFinal reportCessna 150J · Grants Pass, ORThe acft ran off the departure end of the rwy during a forced landing following engine failure during a touch and go landing. The nosewheel struck a mound of dirt and the acft nosed over. The acft had reached 40 ft AGL and 70 mph when the engine lost power…NTSB SEA83FU008Accident · Serious injuriesFinal reportPterodactyl Ptravler · Grants Pass, ORThe ultralight collided with the terrain in an uncontrolled descent after a takeoff during air taxi practice. The two prospective buyers were taking turns taxiing the vehicle while being instructed by the owner. One of the prospects during his 2nd taxi run…NTSB SEA83LA167Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Klamath Falls, ORThe acft dragged a wing in a lake and cartwheeled during an aerial application maneuver. The pilot said he had turned away from the field he was spraying to remove the bugs from his windshield. The acfts wing struck a lake surface in the turn, cartwheeled and…NTSB SEA83LA166Accident · No injuriesLimited investigationFinal reportCessna 182E · Agness, ORThe pilot said that he overflew the rwy twice to look for cattle. On the third approach during short final cattle began crossing the rwy in use. The pilot maneuvered to use the other rwy and stalled at about 25 ft AGL. Due to the acft's low alt & high…NTSB SEA83LA161Accident · No injuriesLimited investigationFinal reportCessna 182A · Sheridan, ORThe acft lost power on final approach to land and made contact with a fence short of the rwy and nosed over. During preflt the pilot had omitted checking the fuel with a fuel strainer because he did not have one. During inspection the carburetor was found to…NTSB SEA83LA156Accident · Minor injuriesLimited investigationFinal reportFinamore KR-2 · Hillsboro, ORThe acft lost power at about 100 ft AGL during takeoff. The pilot made a forced landing straight ahead into a grain field. The high vegetation caused enough drag on the landing gear to nose the acft over. Examination of the engine revealed that the high…NTSB SEA83LA147Accident · No injuriesLimited investigationFinal reportBell 206B · John Day, ORThe rotorcraft pitched up, yawed right, made 180 degree turnand landed hard after the pilot experienced sunglare during initial climb. The pilot stated that while departing the grass strip for aerial application, the sun burst from behind acloud & blinded him…NTSB SEA83LA140Accident · No injuriesLimited investigationFinal reportBell 205-A1 · John Day, ORThe plt stated that before starting his takeoff, he hovered for aprx 20 min to get the helicopter's weight to where the acft would hover out of ground effect. The takeoff was begun with a climb speed of 45 KTS; however, the helicopter collided with trees. The…NTSB SEA83FU006Accident · Serious injuriesFinal reportAmerican Aerolights Eagle XL · Happy Valley, ORThe ultralight collided with the terrain while maneuvering during an airshow. According to witnesses, the pilot had just executed a touch-and-go landing and commenced a climbing 180 degree left turn to downwind in what was described as a wingover type…NTSB SEA83FA141Accident · 1 fatalField investigationFinal reportMonnett - Larsen Moni · Albany, ORThe home built, powered glider was being flown on a local test flight. According to witnesses, the acft was in unpowered flt (gliding) when it entered a descent & crashed. At about the same time it began descending, they observed something separate from the…NTSB SEA83FA139Accident · Serious injuriesField investigationFinal reportCessna 182Q II · Near Peak, ORThe acft collided with rising terrain as the pilot tried unsuccessfully to avoid the trees and ridges. The two rear seatpassengers reported that they flew up a canyon at about 6500 ft MSL. The ridges on either side were as high as the acft. The pilot was seen…NTSB SEA83LA134Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Lebanon, ORThe helicopter was damaged in a roll-over during a forced landing on a soft plowed field. The pilot stated that he was checking another company pilot and in doing so he abruptly reduced power to simulate engine failure. A total loss of power occurred. The…NTSB SEA83FYM07Accident · Serious injuriesFinal reportMaule M-5-235C · Silverton, ORThe acft landing gear collapsed during a forced landing after an engine failure. The acft had climbed to 1000 ft AGL after takeoff when the pilot switched the fuel selector to the right fuel tank. Immediately the engine quit and switching back to the left…NTSB SEA83LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rome, ORThe acft struck a rock during landing and damaged the landing gear. The pilot was on a fishing trip and landed initiallyon a gravel bar. He decided to move the acft to a longer plateau because of increasing density altitude. Upon landing inthis open field the…NTSB SEA83FA133Accident · Minor injuriesField investigationFinal reportGarlick UH-1B/204 · Fossil, ORThe helicopter collided with a dead tree and crashed while conducting a spray run on an aerial application mission. The pilot said that the dawn light conditions made the obtacle hard to see. In the attempt to clear the tree the spray boom made contact and…NTSB SEA83LA130Accident · Serious injuriesLimited investigationFinal reportCessna 337B · Dayton, ORThe pilot stated he was demonstrating a 'steep letdown' to his passenger from about 3200 MSL. The descent was with full flaps, landing gear extended and power off on both engines. At about 1200 MSL the pilot leveled off and added power and had none on the…NTSB SEA83LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Cascade Locks, ORThe acft collided with a guard rail after making a forced landing on a highway during a student solo cross-country flight. The flight had originated at vancouver WA, and the student pilot had been instructed to refuel at pendleton, OR.a landing was made at…NTSB SEA83LA123Accident · No injuriesLimited investigationFinal reportCessna 177 · Hood River, ORThe acft was damaged in a hard landing during unfavorable wind conditons. The pilot had just come cross country where he encountered turbulence. When he called UNICOM to land they gave him winds of 15-25 KTS velocity from the west and turbulence on the final…NTSB SEA83FYM06Accident · Serious injuriesFinal reportCessna T210L · Hermiston, ORThe acft stalled into the ground in a semi-controlled crash forced landing after the engine quit due to fuel exhaustion.a post accident examination revealed only one ounce of fuel aboard the acft. The acft release form from Boeing aircraft to the pilot for…NTSB SEA83FA118Accident · 4 fatalField investigationFinal reportPiper PA28RT-201T · Gov'T Camp, ORWx conditions along the flt route indicated ceilings of 25,000 ft & unrestricted visibility except for the area south & west of mount hood. Mount hood, elevation 11,239 ft MSL, on the sw side of government Camp & clear lake (accident site),was covered by…