NTSB investigations, 2012, OR

6 cases where the defining event was Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2012, OR per year, 2008–2026: 112 cases
20088
20094
20105
20112
20126
20135
20143
20154
20164
20179
201811
20199
20203
20217
202211
20231
20249
20255
20266

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\") = 2012
    AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230')
  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 WPR12CA424Accident · No injuriesData collectionFinal reportCessna A185F · Andrews, ORThe pilot's failure to maintain directional control during a crosswind landing.Sep 15, 2012 · N1164Q · Substantial damageNTSB WPR12LA391Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Toledo, ORThe pilot’s failure to maintain directional control of the airplane after landing.Sep 3, 2012 · N3700V · Substantial damageNTSB WPR12CA368Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McMinnville, ORThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.Aug 21, 2012 · N8154N · Substantial damageNTSB WPR12CA299Accident · No injuriesData collectionFinal reportBellanca 17-30 · Hillsboro, ORThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with an airport lighting system.Jul 6, 2012 · N7322V · Substantial damageNTSB WPR12CA251Accident · No injuriesData collectionFinal reportCessna 172S · Bend, ORThe pilot’s inadequate crosswind correction, which resulted in a loss of airplane control and runway excursion into a berm.Jun 9, 2012 · N698SP · Substantial damageNTSB WPR12CA158Accident · No injuriesData collectionFinal reportFairchild 24 C8C · Redmond, ORThe pilot’s loss of airplane control as a result of excessive brake application. Contributing to the accident was the pilot’s lack of experience in the airplane.Apr 6, 2012 · N14722 · Substantial damage