NTSB investigations, 2012, CO

12 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2012, CO per year, 2008–2026: 178 cases
200815
200915
20106
20117
201212
20139
20144
20157
20167
20177
20188
20196
202016
202114
20222
202313
20247
202511
202612

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\" = 'CO' 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\" = '230' 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 CEN12LA668Accident · No injuriesLimited investigationFinal reportThompson RV-6 · Pagosa Springs, COThe pilot’s failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of landing experience at high density altitudes.Sep 20, 2012 · N140RV · Substantial damageNTSB CEN12CA641Accident · No injuriesData collectionFinal reportPiper PA-11 · Ft. Morgan, COThe pilot's loss of control during landing after encountering an unexpected wind gust.Sep 10, 2012 · N4589M · Substantial damageNTSB CEN12CA627Accident · No injuriesData collectionFinal reportSchneider John W PT-2A · Watkins, COThe pilot's loss of control during takeoff resulting in a runway excursion. Contributing to the accident was an unexpected wind gust.Sep 4, 2012 · N6744J · Substantial damageNTSB CEN12CA537Accident · No injuriesData collectionFinal reportGage Midget Mustang MM-1 · Erie, COThe pilot's inadequate compensation for the crosswind conditions during takeoff, which resulted in a loss of directional control.Aug 11, 2012 · N41831 · Substantial damageNTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.Aug 1, 2012 · N7808Z · Substantial damageNTSB CEN12LA485Accident · No injuriesLimited investigationFinal reportMooney M20E · Englewood, COThe pilot's loss of directional control during landing.Jul 19, 2012 · N2609W · Substantial damageNTSB CEN12LA350Accident · No injuriesLimited investigationFinal reportGriffiths James Sydney Kokopelli SuperPacer · Kremmling, COThe low spring tension of the rudder and tailwheel cable, which resulted in the loss of control as the airplane decelerated after landing.Jun 10, 2012 · N8VX · Substantial damageNTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.Mar 24, 2012 · N605RV · Substantial damageNTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.Feb 27, 2012 · N3196F · Substantial damageNTSB CEN12CA160Accident · No injuriesData collectionFinal reportCessna 180 · South Fork, COThe pilot's loss of directional control while landing on a patchy snow-covered runway.Feb 18, 2012 · N56180 · Substantial damageNTSB CEN12FA151Accident · No injuriesField investigationFinal reportGates Lear Jet 35 · Pueblo, COThe captain's failure to maintain airplane control during an attempted crosswind takeoff on a contaminated runway.Feb 3, 2012 · N31WS · Substantial damageNTSB CEN12LA126Accident · No injuriesLimited investigationFinal reportAviat A1 · Somerset, COThe pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.Jan 6, 2012 · N127AK · Substantial damage