NTSB investigations, 2012, CO

15 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2012, CO per year, 2008–2026: 183 cases
200820
200911
20108
201116
201215
201313
201415
201512
20169
20175
20186
20195
202011
202110
20228
20234
20244
20256
20265

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\" = '240' 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 CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.Dec 2, 2012 · N562BG · Substantial damageNTSB CEN13FA066Accident · 1 fatalField investigationFinal reportBrian P North RAF SE5A Replica · Watkins, COThe pilot’s loss of airplane control and inadvertent stall while attempting to return for landing.Nov 21, 2012 · N17SE · Substantial damageNTSB CEN13CA005Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to maintain airspeed during the landing with known structural icing, which resulted in the airplane’s stall. Contributing to the accident was the pilot’s failure to divert to an area where conditions were not conducive to icing.Oct 5, 2012 · N6661P · Substantial damageNTSB CEN12FA638Accident · 1 fatalField investigationFinal reportMchenry George B JR KR2S · Pueblo, COThe pilot’s loss of airplane control while maneuvering to land, which resulted in a stall and uncontrolled descent.Sep 16, 2012 · N966G · Substantial damageNTSB CEN12FA594Accident · 2 fatalField investigationFinal reportPiper PA-12 · Rye, COThe pilot’s selection of a flightpath toward rising terrain that exceeded the climb capability of the airplane.Aug 31, 2012 · N3031M · Substantial damageNTSB CEN12FA572Accident · Serious injuriesField investigationFinal reportEberle John S Fokker DR-1 Triplane · Parker, COThe pilot's loss of control of the airplane due to the airplane’s reduced climb performance during high density altitude operations.Aug 26, 2012 · N152RB · Substantial damageNTSB CEN12CA576Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Watkins, COThe pilot did not maintain control of the airplane while landing in gusty wind conditions.Aug 25, 2012 · N215VS · Substantial damageNTSB CEN12FA571Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Milner, COThe student pilot's impairment from alcohol, marijuana, and hypoxia, which adversely affected his ability to maintain control of the airplane.Aug 24, 2012 · N7774P · Substantial damageNTSB CEN12LA493Accident · No injuriesLimited investigationFinal reportCessna 182G · Montrose, COThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jul 30, 2012 · N3198S · Substantial damageNTSB CEN12FA462Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Walsenburg, COThe pilot's failure to maintain airplane control while turning from base to final leg in the traffic pattern.Jul 21, 2012 · N96YK · Substantial damageNTSB CEN12CA442Accident · Minor injuriesData collectionFinal reportDoppelt Fredric F F. 8L Falco · Durango, COThe pilot's failure to maintain control of the airplane and the instructor's delayed remedial action.Jul 15, 2012 · N532FD · Substantial damageNTSB CEN12CA370Accident · Minor injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot’s improper performance of a soft field takeoff procedure, which resulted in a loss of airplane control, and the flight instructor’s delayed remedial action to correct the situation.Jun 14, 2012 · N617EV · Substantial damageNTSB CEN12FA320Accident · 1 fatalField investigationFinal reportTackabury Air-Cam · Fort Morgan, COThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an aerodynamic stall.May 28, 2012 · N788RJ · Substantial damageNTSB CEN12CA200Accident · Minor injuriesData collectionFinal reportCessna 172P · Colorado Springs, COThe pilot did not maintain control of the airplane during takeoff, which resulted in a hard landing and subsequent nose over.Mar 24, 2012 · N97LP · Substantial damageNTSB CEN12CA183Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Fort Collins, COThe pilot did not maintain adequate airspeed and airplane control during the go-around, which resulted in the airplane impacting trees.Mar 8, 2012 · N2986P · Substantial damage