NTSB investigations, OR
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 SEA03LA189Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Diamond, ORLoss of engine power for undetermined reasons during hover.NTSB SEA03LA182Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Hillsboro, ORThe pilot's failure to maintain the proper distance and altitude while on final approach which led to touching down short of the runway. The pilot's restricted visual lookout was a factor.NTSB SEA03LA180Accident · No injuriesLimited investigationFinal reportLancair LC41 · Bend, ORThe inadequate design of the drogue chute mechanical jettison system, which resulted in its failure to separate from the aircraft during in-flight spin recovery tests, and the incorrectly wired drogue chute cable cutter activation unit, which resulted in the…NTSB SEA03CA178Accident · No injuriesData collectionFinal reportBeech C24R · Bend, ORThe first pilot's premature liftoff and his failure to abort the takeoff. Factors include a fence and a ditch bank located upwind of the runway.NTSB SEA03LA176Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Hood River, ORA power loss due to a mis-seated intake valve on the #1 cylinder resulting in leakage during the compression stroke and low compression. Contributing factors were the rising terrain and trees.NTSB SEA03LA160Accident · Minor injuriesLimited investigationFinal reportHughes 269C-1 · Scappoose, ORThe helicopter encountering a ground resonance condition following a failure to maintain hovering flight. Contributing factors to the accident included the pilot's failure to maintain rotor RPM and the high pressure state of the landing gear shock absorbing…NTSB SEA03LA157Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-24E · Hood River, ORThe pilot's failure to refuel prior to the flight, resulting in fuel exhaustion during the initial climb, followed by the pilot's failure to maintain airspeed. An inadvertent stall was a factor.NTSB SEA03LA152Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hermiston, ORThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.NTSB SEA03LA145Accident · No injuriesLimited investigationFinal reportAndelin S1E · Troutdale, ORThe pilot's inability to maintain directional control due to an obstruction of the left brake line by foreign material resulting in asymmetrical braking.NTSB SEA03CA138Accident · No injuriesData collectionFinal reportBeech F90 · Sunriver, ORThe pilot's misjudgment of distance while landing, which resulted in a runway overrun. Factors include rough uneven terrain and a tailwind.NTSB SEA03LA133Accident · No injuriesLimited investigationFinal reportCessna 402 B · Lakeview, ORFailure of the landing gear shaft roll pin resulting in a main gear collapse during the taxi phase of operation.NTSB SEA03LA126Accident · No injuriesLimited investigationFinal reportDruckman 102 · Alsea, ORThe pilot's failure to maintain directional control during the take-off roll, when his foot became lodged between the rudder pedal and the heel brake. An additional factor is a fence near the area where he was taking off from.NTSB SEA03LA125Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · La Grande, ORThe cross threading and separation of the clutch assembly while maneuvering which resulted in a loss of engine power followed by a hard landing. An inadequate maintenance overhaul was a factor.NTSB SEA03LA122Accident · No injuriesLimited investigationFinal reportCessna 185F · Lexington, ORThe pilot's failure to maintain aircraft control during the landing roll. A partially deflated tire and soft terrain were factors.NTSB SEA03LA118Accident · 1 fatalLimited investigationFinal reportHerrin Hornet · Newberg, ORAircraft control not maintained while maneuvering for landing.NTSB SEA03LA115Accident · No injuriesLimited investigationFinal reportCessna 182C · Bandon, ORLoss of engine power during descent for undetermined reasons.NTSB SEA03FA110Accident · 1 fatalField investigationFinal reportHarshbarger W/Reed RV-8 · Grants Pass, ORCorrosion and contamination within the fuel servo unit and the pilot's delayed turn back to the runway. Contributing factors were trees and the pilot's impairment due to prescription medication.NTSB SEA03LA090Accident · No injuriesLimited investigationFinal reportBeech 95 C-55 · Canby, ORThe pilot's inadequate preflight planning resulting in fuel starvation and subsequent loss of power after takeoff. High vegetation was a factor.NTSB SEA03LA088Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Oregon City, ORThe student pilot's failure to maintain aircraft control during the landing roll. A tailwind and gusting conditions were factors.NTSB SEA03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Salem, ORLoss of power in cruise flight due to a catastrophic engine failure for undetermined reasons.NTSB SEA03LA069Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Bonanza, ORSeparation of the connecting rod cap. Annual maintenance inspections which were disregarded by the owner/pilot was a factor.NTSB SEA03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Coos Bay, ORThe pilot's improper remedial action during takeoff and his failure to maintain airspeed. Contributing factors included the binding of the left brake and the trees.NTSB SEA03LA063Accident · No injuriesLimited investigationFinal reportHerb Six Northstar · Medford, ORThe compressive buckling and collapse of the right main landing gear.NTSB SEA03LA062Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Florence, ORPilot's failure to maintain directional control during the landing roll. Factors include rough terrain.NTSB SEA03FA059Accident · 2 fatalField investigationFinal reportCessna T207 A · Merlin, ORThe pilot's failure to maintain clearance from mountainous terrain while in cruise flight. Factors include low ceilings and mountainous terrain.NTSB SEA03LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lexington, ORThe pilot's inadequate compensation for the cosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.NTSB SEA03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troutdale, ORAircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.NTSB SEA03LA043Accident · No injuriesLimited investigationFinal reportCessna 208B · Creswell, ORWater contamination in the fuel system which resulted in a loss of engine power during the initial climb after takeoff, and the pilot's inadequate pre-flight inspection. Trees were a factor.NTSB SEA03LA044Accident · No injuriesLimited investigationFinal reportCessna 180 A · Malin, ORAircraft control not maintained during landing. Soft terrain was a factor.NTSB SEA03LA039Accident · No injuriesLimited investigationFinal reportKesterson Nieuport 11 · Independence, ORAircraft control not maintained during takeoff. Factors include soft/muddy terrain.NTSB SEA03LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · McMinnville, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds and soft terrain in the area where the aircraft departed the side of the runway.NTSB SEA03FA038Accident · No injuriesField investigationFinal reportBeech A23 · Fort Klamath, ORThe separation of the rod end cap from the connecting rod for an undetermined reason during the descent for landing. The ditch was a factor.NTSB SEA03LA032Accident · No injuriesLimited investigationFinal reportCessna 180 B · Klamath Falls, ORFailure to adequately compensate for wind conditions while landing.NTSB SEA03FA024Accident · Serious injuriesField investigationFinal reportBombardier DHC-8-401 · Medford, ORThe fracture and spalling of the inner-most pane of the aircraft's port side windshield while on a downwind for a night visual approach due to an imposed load beyond that required for windshield certification (multiple bird strikes). Factors include a dark…NTSB SEA03LA010Accident · No injuriesLimited investigationFinal reportLearjet 36A · Astoria, ORCollision with an elk during the takeoff roll. Factors include dark night VFR conditions.NTSB SEA03LA011Accident · Serious injuriesLimited investigationFinal reportPeterson Dragonfly · Mulino, ORFuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing.NTSB SEA03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · La Grande, ORInadequate supervision and the premature raising of flaps before a positive climb was established.NTSB SEA03LA006Accident · Serious injuriesLimited investigationFinal reportRutledge Kitfox · Condon, ORA loose clamp around the gascolator bowl. A related factor was the maintenance inspection not being performed.NTSB SEA03LA001Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air 4000 · Tillamook, ORThe fracture of the weld joining the left main wheel strut to the left/right main wheel axel resulting in separation of the strut from the axle during an unknown phase of operation which ultimately lead to the left gear collapse and subsequent nose-over on…NTSB SEA02FA185Accident · 2 fatalField investigationFinal reportCessna 172S · Medford, ORTerrain clearance was not maintained during cruise flight. Dark night and mountainous terrain were factors.NTSB SEA02LA184Accident · No injuriesLimited investigationFinal reportCessna 182 · Estacada, ORThe entanglement of an inadvertently opened skydiver's parachute in the aircraft’s elevator and rudder just after a group of four skydivers positioned themselves on the aircraft's external jump platform prior to a jump.NTSB SEA02LA176Accident · No injuriesLimited investigationFinal reportEells Air Command 503 · Prineville, ORThe student pilot's failure to maintain airspeed resulting in a hard landing.NTSB SEA02LA168Accident · Serious injuriesLimited investigationFinal reportNolley BD-5 · Corvallis, ORFuel starvation resulting in a loss of engine power during the aircraft's initial climb. A disconnected fuel line was a factor.NTSB SEA02LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Newberg, ORA warped right brake disc resulting in a veer to the right during the landing roll, and the aircraft's subsequent collision with a fence. A contributing factor was the fence.NTSB SEA02LA153Accident · Serious injuriesLimited investigationFinal reportMooney M20L · Newberg, ORThe pilot's inadequate flare and his delay in executing an aborted landing. A contributing factor was the dark night conditions.NTSB SEA02LA152Accident · No injuriesLimited investigationFinal reportBeech B35 · Halfway, ORThe pilot's delay in initiating an aborted takeoff and his failure to establish climb out of ground effect. Contributing factors were the high aircraft weight and high density altitude as well as the fence and berm, which the aircraft struck.NTSB SEA02LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Creswell, ORThe pilot’s improper management of fuel, which resulted in a loss of engine power due to fuel starvation.NTSB SEA02LA142Accident · Minor injuriesLimited investigationFinal reportKaminski RAF 2000 · Newberg, ORThe pilot's inadequate compensation (excessive altitude) for crosswind conditions resulting in the gyroplane's rotors contacting the ground. Contributing factors were the gusty crosswind conditions.NTSB SEA02LA137Accident · No injuriesLimited investigationFinal reportBell 206B · Elsie, ORThe shattering and separation of the forward right (pilot's) windscreen for undetermined reason(s).NTSB SEA02LA135Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Medford, ORPower loss during cruise flight for undetermined reasons. Factors include mountainous terrain and trees.