NTSB investigations, 2009, ID

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

Cases per year

20082026
NTSB investigations, 2009, ID per year, 2008–2026: 197 cases
200811
200914
201012
201122
201215
201311
201414
201511
201610
201712
201811
201920
20206
20213
20224
20232
20247
20259
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\") = 2009
    AND c.\"eventStateOrRegion\" = 'ID' 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 WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.Dec 24, 2009 · N1883V · Substantial damageNTSB WPR09LA463Accident · 1 fatalLimited investigationFinal reportFrazier Tangent · Nampa, IDThe pilot's failure to maintain pitch control of the airplane.Sep 24, 2009 · N72TZ · Substantial damageNTSB WPR09CA444Accident · No injuriesData collectionFinal reportBeech V35 · Hailey, IDThe pilot’s failure to maintain directional control of the airplane during landing in crosswind conditions.Sep 13, 2009 · N81895 · Substantial damageNTSB WPR09FA409Accident · 1 fatalField investigationFinal reportStemme S10-VT · Mackay, IDThe pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.Aug 19, 2009 · N35MP · Substantial damageNTSB WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.Aug 11, 2009 · N939RG · Substantial damageNTSB WPR09FA379Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Saint Charles, IDThe pilot’s failure to maintain terrain clearance while maneuvering.Aug 7, 2009 · N6905B · DestroyedNTSB WPR09LA378Accident · 1 fatalLimited investigationFinal reportGray RV-6 · Caldwell, IDThe pilot's failure to maintain adequate airspeed that led to a stall/spin while maneuvering in the traffic pattern.Aug 1, 2009 · N69KG · DestroyedNTSB WPR09LA343Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Yellow Pine, IDThe pilot's failure to maintain clearance from the trees while taking off in a high-density altitude. Contributing to the accident were the pilot's failure to perform pre-takeoff performance calculations, his positioning of the elevator trim in a nose-down…Jul 14, 2009 · N71BS · Substantial damageNTSB WPR09CA346Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Sulphur Creek, IDThe pilot's failure to maintain directional control during the landing roll.Jul 10, 2009 · N199CT · Substantial damageNTSB WPR09CA332Accident · Minor injuriesData collectionFinal reportCessna 182M · Wilson Bar, IDThe pilot’s misjudged approach that led to a long landing and his failure to execute a go-around when he realized that he overshot his intended point of landing.Jul 6, 2009 · N71186 · DestroyedNTSB WPR09LA299Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Saint Anthony, IDA total loss of engine power for undetermined reasons.Jun 19, 2009 · N3089K · DestroyedNTSB WPR09CA233Accident · No injuriesData collectionFinal reportCessna 172R · Coeur d'Alene, IDThe student pilot's inadequate compensation for the crosswinds while landing.May 9, 2009 · N2383Q · Substantial damageNTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.Apr 6, 2009 · N610RJ · Substantial damageNTSB WPR09FA116Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Hagerman, IDThe student pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the pilot's mental condition which could have contributed to the inappropriate decision to fly the…Feb 16, 2009 · N8810P · Destroyed