NTSB investigations, 2021, OR

12 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2021, OR per year, 2008–2026: 200 cases
200815
200910
201018
201110
201217
20138
20145
201514
201613
201715
201814
201927
20206
202112
20221
20234
20243
20255
20263

Latest cases

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 year(c.\"eventDate\") = 2021
    AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB WPR22LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Hillsboro, ORThe on-ground collision with a tree during an off airport precautionary landing. Contributing was the partial loss of engine power for undetermined reasons.Dec 9, 2021 · N152BT · Substantial damageNTSB WPR22LA019Accident · No injuriesClass 3 · LimitedFinal reportLancair ES · Fall Creek, ORTotal loss of engine power due to fatigue failure of the camshaft gear.Oct 15, 2021 · N511ZZ · Substantial damageNTSB WPR22LA003Accident · No injuriesClass 4 · LimitedFinal reportInterstate S-1A · Independence, ORThe separation of the left rudder pedal interconnect cable during takeoff, which resulted in the student pilot’s inability to maintain directional control.Oct 2, 2021 · N37317 · Substantial damageNTSB WPR22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportZenith CH750 · Oregon City, ORThe total loss of engine power for undetermined reasons.Oct 2, 2021 · N99HX · Substantial damageNTSB WPR21LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Salem, ORThe pilot’s improper landing flare in a tailwind, which resulted in a hard landing and subsequent impact with terrain.Sep 26, 2021 · N101MB · Substantial damageNTSB WPR21LA292Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180K · Mt. Hood, ORThe total loss of engine power while in cruise flight for reasons that could not be determined based on available evidence. Contributing to the accident was the presentation of an abandoned airport as available for use in the Federal Aviation Administration…Jul 24, 2021 · N8884 · Substantial damageNTSB WPR21LA252Accident · No injuriesClass 4 · LimitedFinal reportSilverLight AR-1 · Lakeside, ORThe pilot’s inadequate decision to continue the takeoff after sufficient airspeed was not attained and his failure to maintain aircraft control while maneuvering to avoid obstructions, which resulted in a collision with the ground.Jun 29, 2021 · N159WT · Substantial damageNTSB WPR21FA233Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-135 · White City, ORThe pilot’s failure to maintain control of the airplane during a go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s impairment due to his medical conditions and the effects of his medications.Jun 20, 2021 · N2618A · DestroyedNTSB WPR21LA204Accident · Serious injuriesClass 3 · LimitedFinal reportMcclure B J Glasair III · Eugene, ORThe pilot’s loss of airplane control during the approach to landing due to an asymmetrical flap deployment for reasons that could not be determined based on the available evidence.May 20, 2021 · N54CB · DestroyedNTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.Apr 17, 2021 · N51080 · Substantial damageNTSB WPR21LA094Accident · Minor injuriesClass 3 · LimitedFinal reportRandy Wayne Maloney M1 · Eagle Point, ORA partial loss of engine power for reasons that could not be determined based on available evidence.Jan 21, 2021 · N322TR · DestroyedNTSB WPR21LA082Accident · 1 fatalClass 3 · LimitedFinal reportCessna 560 · Warm Springs, ORA loss of airplane control due to pilot incapacitation for reasons that could not be determined.Jan 9, 2021 · N3RB · Destroyed