NTSB investigations, 2011

9 cases where NTSB found Action/decision, general.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 56 cases
20083
20094
20109
20119
201210
20135
20143
20151
20162
20172
20191
20201
20212
20231
20253

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\") = 2011
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020400'))
  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 CEN12LA112Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marysville, OHThe pilot’s failure to maintain sufficient altitude from the terrain while performing low-level aerobatics.Dec 22, 2011 · N161PC · Substantial damageNTSB ERA12WA104Accident · No injuriesForeign investigationPiper PA28 · Bogota, ColombiaOn December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…Dec 6, 2011 · HK2308 · Substantial damageNTSB CEN12CA051Accident · Minor injuriesData collectionFinal reportDowner Bellanca 14-19-2 · Borger, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident was the pilot’s diverted attention with the broken fuel gauge knob.Nov 1, 2011 · N711W · Substantial damageNTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.Sep 4, 2011 · N5934Z · Substantial damageNTSB CEN11LA384Accident · Serious injuriesLimited investigationFinal reportFisher Lancair · Azle, TXThe pilot’s inadequate in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.Jun 12, 2011 · N6ZY · Substantial damageNTSB ERA11CA279Accident · No injuriesData collectionFinal reportFranke Harry C Avid Flyer B · Somerset, PAThe pilot’s failure to hold full power for takeoff.Apr 30, 2011 · N145HF · Substantial damageNTSB CEN11LA307Accident · 1 fatalLimited investigationFinal reportCessna 320 · Lake Heron, NMThe pilot’s controlled flight into terrain while conducting a flight at low altitude in instrument meteorological conditions.Apr 24, 2011 · N320AZ · Substantial damageNTSB CEN11FA285Accident · 1 fatalField investigationFinal reportHawker-Beechcraft E-55 · De Queen, ARThe pilot’s loss of control during takeoff for undetermined reasons.Apr 15, 2011 · N3959W · Substantial damageNTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.Jan 1, 2011 · N6725X · Substantial damage