# NTSB investigations, 2014, CO: Hard landing

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN15LA084](https://openairdocs.org/ntsb/CEN15LA084.md): Enstrom 280FX · Fort Lupton, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 2014 · N409LH · Substantial damage
  > The loss of engine power during cruise flight for reasons that could not be determined based on the available information.
- [NTSB CEN14CA215](https://openairdocs.org/ntsb/CEN14CA215.md): Firefly 8B-15 · Security, CO · Accident · Serious injuries · Data collection · Final report · Apr 19, 2014 · N15095 · No damage
  > An unexpected increase in wind velocity which resulted in a hard landing and the subsequent passenger injury.
- [NTSB CEN14CA125](https://openairdocs.org/ntsb/CEN14CA125.md): Cessna 310I · Aurora, CO · Accident · No injuries · Data collection · Final report · Jan 28, 2014 · N8133M · Substantial damage
  > Loss of engine power due to fuel exhaustion and the pilot's inadequate preflight inspection.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2014
  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
```

This list as a web page: https://openairdocs.org/ntsb-events/092/sequence?state=CO&year=2014

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
