NTSB investigations, 2017, CO

8 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2017, CO per year, 2008–2026: 87 cases
20088
20092
20106
20117
20126
20134
20145
20153
20162
20178
20187
20193
20204
20216
20224
20234
20245
20252
20261

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\") = 2017
    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\" = '440' 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 CEN18LA042Accident · No injuriesLimited investigationFinal reportMotley Gary W Zenith CH750 Cruzer · Louviers, COThe engine’s excessive cylinder head temperatures and the subsequent seizing of the engine, which resulted from an engine control unit that caused the engine’s fuel-air mixture to be too lean.Nov 27, 2017 · N956GM · Substantial damageNTSB CEN18LA034Accident · No injuriesLimited investigationFinal reportErcoupe 415 CD · Aurora, COThe failure of the engine-driven fuel pump and the pilot's failure to identify the pump's failure, which resulted in a loss of engine power due to fuel starvation and a forced landing on a road, during which the airplane hit obstacles.Nov 20, 2017 · N3067H · Substantial damageNTSB CEN18CA021Accident · No injuriesData collectionFinal reportCessna T210N · Eagle, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 23, 2017 · N5129C · Substantial damageNTSB CEN18LA013Accident · No injuriesLimited investigationFinal reportRussell E Oberg Murphy Rebel · Fort Collins, COA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat.Oct 12, 2017 · N734R · Substantial damageNTSB CEN17LA247Accident · No injuriesLimited investigationFinal reportCessna P210N · Eagle, COThe loss of engine power due to fuel starvation for reasons that could not be determined because an examination of the airplane and engine did not reveal any malfunctions or failures that would have precluded normal operation.Jun 30, 2017 · N210HG · Substantial damageNTSB CEN17LA236Accident · Minor injuriesLimited investigationFinal reportWells John L JR Stol CH 701 · Canon City, COFuel starvation due to the deterioration of a fuel hose.Jun 18, 2017 · N999WX · Substantial damageNTSB CEN17LA220Accident · Serious injuriesLimited investigationFinal reportBellanca 17 30 · Watkins, COThe pilot's in-flight fuel mismanagement, which resulted in fuel starvation and a total loss of engine power.Jun 8, 2017 · N7328V · Substantial damageNTSB CEN17LA073Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Meeker, COA partial loss of engine power due to fuel contamination from an undetermined source.Jan 7, 2017 · N5VK · Substantial damage