NTSB investigations, 2009, ID

7 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2009, ID per year, 2008–2026: 92 cases
20083
20097
201012
20113
20128
20133
20145
20154
20162
20179
20188
20197
20201
20215
20226
20232
20244
20251
20262

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\" = '300' 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 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 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 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 WPR09CA304Accident · No injuriesData collectionFinal reportStucker Virgil A Avid Magnu · Emmett, IDThe pilot's improper landing flare and recovery from a bounced landing.Jun 21, 2009 · N777DV · Substantial damageNTSB 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 WPR09LA201Accident · No injuriesLimited investigationFinal reportBrinker / Garner BI-PLANE · Caldwell, IDLoss of control during the landing roll for undetermined reasons.Apr 17, 2009 · N375CB · Substantial damage