NTSB investigations, CT

6 cases where NTSB found Angle of attack.

Cases per year

20152026
NTSB investigations, CT per year, 2015–2026: 6 cases
20151
20161
20173
20191

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 c.\"eventStateOrRegion\" = 'CT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062042'))
  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 GAA19CA287Accident · No injuriesData collectionFinal reportJihlavan Airplanes Sro KP5 · East Haddam, CTThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.May 25, 2019 · N235KP · Substantial damageNTSB ERA17LA261Accident · 1 fatalLimited investigationFinal reportCessna 172 · Danbury, CTThe pilot's exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to operate the airplane above its maximum gross weight, which likely reduced…Jul 30, 2017 · N612DF · Substantial damageNTSB ERA17FA156Accident · 2 fatalField investigationFinal reportLuscombe 8 · East Windsor, CTThe flying pilot's excessive maneuvering of the airplane at a slow airspeed, which resulted in exceedance of the critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilots' operation of the airplane over its maximum…Apr 18, 2017 · N8554Y · Substantial damageNTSB ERA17FA112Accident · 1 fatalField investigationFinal reportPiper PA38 · East Haven, CTThe failure of the fuel selector valve in a position that restricted fuel flow to the engine, resulting in a total loss of engine power during initial climb due to fuel starvation. Also causal was the operator's failure to effectively detect and resolve the…Feb 22, 2017 · N2452C · DestroyedNTSB GAA16CA514Accident · No injuriesData collectionFinal reportCessna 205 · Ellington, CTThe pilot's exceedance of the airplane's critical angle-of-attack during the initial climb after an attempted go-around, which resulted in an aerodynamic stall.Sep 26, 2016 · N8433Z · Substantial damageNTSB ERA15LA365Accident · Minor injuriesLimited investigationFinal reportClark 1000 · Warehouse Point, CTThe pilot’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's decision to…Sep 19, 2015 · N9018R · Substantial damage