NTSB investigations, 2013, CO

7 cases where the sequence of events included Hard landing.

Cases per year

20082026
NTSB investigations, 2013, CO per year, 2008–2026: 73 cases
20084
20094
20108
20115
20122
20137
20143
20153
20166
20175
20182
20194
20203
20211
20221
20233
20243
20253
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\") = 2013
    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\" = '092' 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 CEN14LA054Accident · No injuriesLimited investigationFinal reportQuicksilver Mxii Sport · Erie, COA loss of engine power due to a crankshaft failure, which resulted in a forced landing.Nov 14, 2013 · N2910P · Substantial damageNTSB CEN14CA049Accident · No injuriesData collectionFinal reportMooney M20R · Fort Collins, COThe pilot did not maintain control of the airplane during the go around.Nov 7, 2013 · N1006A · Substantial damageNTSB CEN13CA435Accident · No injuriesData collectionFinal reportCessna 182S · Steamboat Springs, COThe pilot's delay in reacting to the adverse wind conditions.Jul 24, 2013 · N5467C · Substantial damageNTSB CEN13CA372Accident · Serious injuriesData collectionFinal reportKubicek BB70Z · Windsor, COThe pilots’ encounter with increased wind, which resulted in a hard and fast landing.Jun 24, 2013 · N1235J · Minor damageNTSB CEN13LA356Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Golden, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…Jun 8, 2013 · N753ZF · Minor damageNTSB CEN13IA350Incident · Minor injuriesIncident investigationFinal reportUltramagic M-105 · Louisville, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…Jun 8, 2013 · N30018 · Minor damageNTSB CEN13IA349Incident · Minor injuriesIncident investigationFinal reportUltramagic T210 · Boulder, COThe balloon's encounter with unforecast strong gusting wind, which resulted in a high-wind landing. Contributing to the accident was the National Weather Service's misjudgment of the timing and underestimation of the magnitude of the frontal boundary moving…Jun 8, 2013 · N201FW · Minor damage