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 SEA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182 · Redmond, ORThe pilot's improper flare.NTSB SEA99LA088Accident · No injuriesLimited investigationFinal reportRyan Navion B · Klamath Falls, ORThe pilot's failure to reinstall the engine oil filler cap during preflight, resulting in engine oil loss and the necessity for an immediate landing.NTSB SEA99GA085Accident · 2 fatalFinal reportCessna 182R · Enterprise, ORThe pilot's failure to maintain aircraft control while maneuvering in a canyon, and the mentor's failure to take adequate remedial action. Factors included box canyon terrain and high density altitude conditions.NTSB SEA99LA098Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Pendleton, ORA fouled external load cable, and the pilot's operation of the helicopter with a non-approved external bucket installation, resulting in misrouted hydraulic lines and consequent malfunction of the external load release system.NTSB SEA99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Hillsboro, ORA loose alternator drive belt, and the flight crew's decision to continue flight with a known electrical system deficiency, resulting in disabling of the aircraft electrical system and landing with the gear not down-and-locked.NTSB SEA99LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ORAircraft control was not maintained. The pilot's misjudged flare and inadequate remedial action, along with the flight instructors delayed remedial action were factors.NTSB SEA99LA068Accident · No injuriesLimited investigationFinal reportCessna 182N · Granite, ORClearance was not maintained. A sign and the selection of unsuitable terrain for landing were factors.NTSB SEA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Salem, ORThe pilot's improper decision not to apply carburetor heat during a reduced power descent in conditions conducive to carburetor icing. Factors include weather conditions conducive to carburetor icing, and high vegetation and a fence post in the area where the…NTSB SEA99FA060Accident · No injuriesField investigationFinal reportBeech 36 · Portland, ORImproper installation of the strobe light system. Factors include a leak in the fuel bladder and electrical arcing.NTSB SEA99LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Detroit, ORThe pilot's inadvertent visual flight rules flight into instrument meteorological conditions, eventually resulting in a non-mechanical loss of engine power. Factors were: the pilot's inadequate preflight planning and preparation; a snowstorm with icing…NTSB SEA99LA053Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Hillsboro, ORA landing gear collapse for undetermined reasons.NTSB SEA99TA051Accident · Minor injuriesFinal reportI.C.A. Brasov IS-28B2 · North Plains, ORThe second pilot did not maintain clearance from power lines. The pilot-in-command did not adequately supervise the second pilot, and the second pilot's diverted attention and lack of familiarity with the geographic area were factors.NTSB SEA99LA048Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Pendleton, ORA loss of power due to water contamination of the fuel. Factors include the inability of the helicopter to perform a successful autorotation immediately after takeoff.NTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.NTSB SEA99LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Salem, ORThe pilot-in-command's misjudgment of distance/altitude on final approach, and overload of the left main landing gear. A factor was the embankment at the end of the landing strip.NTSB SEA99LA035Accident · No injuriesLimited investigationFinal reportCessna 150L · Hillsboro, ORThe pilot's failure to maintain directional control of the aircraft. A related factor was the crosswind condition.NTSB SEA99FA028Accident · 2 fatalField investigationFinal reportPacific Aviation Composites LC 40-550FG · Portland, ORAircraft control was not maintained and the pilot's lack of total experience in type operation. Weather conditions reported ceilings below approach/landing minimums and a dark night condition were factors.NTSB SEA99FA027Accident · 4 fatalField investigationFinal reportBeech 58P · Yamhill, ORThe pilot's failure to maintain clearance from hilly terrain while maneuvering below a low ceiling. Factors include a dark night, a low ceiling, fog, and hilly terrain.NTSB SEA99LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe pilot's failure to maintain aircraft control.NTSB SEA99LA014Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Portland, ORThe flight crew's entry of an incorrect weight figure in the Flight Management System (FMS) computer, resulting in the approach being flown at an improper (low) Vref speed and an excessively nose-high attitude through the landing flare.NTSB SEA99LA005Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Scappoose, ORAircraft control was not maintained. Inadequate remedial action is a factor.NTSB SEA98LA187Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Medford, ORDirectional control was not maintained.NTSB SEA98LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Christmasvalley, ORA jammed nose gear. A corroded cable and the failure of the owner to have an annual inspection performed on the airplane were factors.NTSB SEA98LA184Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Flying M Ranch, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), and the resultant stall/mush of the aircraft into the terrain. Factors include the pilot's improper decision to attempt a go-around into rising terrain, landing with a tailwind, and trees…NTSB SEA98LA182Accident · 1 fatalLimited investigationFinal reportCora Allegro · Cresent Lake, ORThe pilot's failure to maintain clearance from trees located off the departure end of the runway. Factors include strong, variable, gusty winds, terrain-induced turbulence, a high density altitude, and trees off the departure end of the runway.NTSB SEA98LA177Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Spray, ORA partial loss of engine power, and the pilot's subsequent misjudgment of clearance with a transmission wire during a precautionary landing approach. The reason for the power loss was not determined; however, the pilot reported that it was not of a mechanical…NTSB SEA98LA180Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Lincoln City, ORThe pilot's inadequate remedial action to correct for a crosswind gust. The crosswind gust was a factor.NTSB SEA98LA162Accident · Minor injuriesLimited investigationFinal reportCessna T337E · Hillsboro, ORThe disengagement of the pilot seat forward and aft movement locking pin, followed by the pilot's seat sliding to the rear of the seat track.NTSB SEA98LA163Accident · No injuriesLimited investigationFinal reportSix/Huber RV-6 · Roseburg, ORA total loss of engine power for undetermined reasons.NTSB SEA98GA159Accident · No injuriesFinal reportBell 212 · Juntura, ORThe pilot-in-command's failure to maintain proper clearance between the long line cable and hell hole structure resulting in airframe contact and binding of the cable. This resulted in separation/disabling of the fuel control solenoid and a subsequent…NTSB SEA98LA154Accident · 1 fatalLimited investigationFinal reportCessna 172 · Baker City, ORThe pilot's failure to maintain terrain clearance and inadequate in-flight planning/decision. Contributing to the accident was mountain obscuration.NTSB SEA98TA152Accident · Minor injuriesFinal reportCessna TU206G · Burns, ORFatigue failure of the crankshaft.NTSB SEA98LA149Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Ashland, ORThe pilot's improper landing flare, which resulted in a hard landing.NTSB SEA98LA145Accident · 1 fatalLimited investigationFinal reportBaggarley Glasair II-FT · Vernonia, ORA loss of aircraft control for undetermined reasons.NTSB SEA98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Pacific City, ORThe pilot's improper compensation for wind conditions (landing with a tail wind.) Related factors were tail wind conditions, a short runway, and diminished brake system effectiveness.NTSB SEA98LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Miltonfreewater, ORThe pilots failure to maintain proper terrain clearance. Factors contributing to the accident are high density altitude and rising terrain.NTSB SEA98LA134Accident · Minor injuriesLimited investigationFinal reportNelson Cygnet SF-2A · Newberg, ORThe pilot-in-command's failure to maintain directional control. Factors contributing were the pilot-in-command's lack of experience in make of aircraft (i.e., use of toe brakes) and the fence post.NTSB SEA98LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Oregon City, ORThe pilot's improper flare.NTSB SEA98LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Aurora, ORDirectional control was not maintained by the pilot in command. Factors include rough terrain and hidden obstructions.NTSB SEA98FA109Accident · No injuriesField investigationFinal reportNolley BD-5T · Corvallis, ORThe introduction of a fuel containing an ethanol additive into fuel tanks sloshed/sealed with a compound incompatible with alcohols, resulting in debonding of the compound from the fuel tank walls, leading to partial blockage of an in-line fuel filter, and a…NTSB SEA98LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manzanita, ORThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a crosswind gust during the takeoff roll.NTSB SEA98LA103Accident · No injuriesLimited investigationFinal reportCasa BU-131 · Harrisburg, ORA failed bracket attaching the throttle linkage, which resulted in the inability to control power, and unsuitable terrain for a successful forced landing. Factors include soft terrain with high vegetation.NTSB SEA98LA099Accident · Minor injuriesLimited investigationFinal reportCessna T210M · La Pine, ORFuel starvation for undetermined reasons.NTSB SEA98LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Independence, ORA loss of power due to fatigue failure and cracking of an engine cylinder barrel.NTSB SEA98LA094Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · North Plains, ORThe pilot's failure to maintain directional control and his failure to maintain clearance from a pole. Contributing factors were rain and an overcast which resulted in less than optimal conditions to detect the pole.NTSB SEA98FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Hillsboro, ORImproper installation (bushing), mechanical binding (bushing), mechanical binding (connecting rod), and fatigue within the crankshaft. Contributing factors were inadequate major (engine) overhaul and trees.NTSB SEA98LA065Accident · No injuriesLimited investigationFinal reportKaman K-1200 · La Grande, ORThe pilot's inadvertent shutdown of the engine with the FUEL/OIL shutoff switch. Contributing to the accident were: the manufacturer's inadequate location and design of the FUEL/OIL shutoff switch; the FAA's inadequate determination of the type design's…NTSB SEA98LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Redmond, ORThe passenger-pilot's excessive rate of descent during touchdown. Factors include the pilot-in-command's inadequate recovery from a hard/bounced landing, the passenger-pilot's failure to execute a go-around after taking control of the aircraft, and gusty…NTSB SEA98LA059Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Hillsboro, ORThe flight instructor's inadequate supervision and the dual student's premature lift off which resulted in inadequate airspeed, a stall, and collision with the ground.NTSB SEA98LA058Accident · No injuriesLimited investigationFinal reportCessna 195A · Bend, ORSeparation by fracture of the left main gear leg, as the result of fatigue cracks that initiated in corrosion pits on the gear leg surface.