Fatal NTSB investigations, 2017, CT

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
Fatal NTSB investigations, 2017, CT per year, 1962–2026: 186 cases
19621
19641
19653
19665
19675
19686
19693
19709
19714
19724
19737
19745
19757
19763
19775
19787
19796
19802
19813
19822
19835
19848
19852
19863
19876
19884
19893
19904
19916
19924
19934
19943
19951
19962
19971
19984
19993
20014
20024
20031
20043
20052
20061
20071
20101
20112
20122
20131
20161
20176
20181
20191
20211
20231
20241
20251

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\" = 'CT' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 ERA17FA327Accident · 2 fatalField investigationFinal reportMooney M20C · North Branford, CTA total loss of engine power due to fuel starvation as the result of foreign object debris in the fuel selector valve. Contributing to the accident was the pilot's selection of a low cruising altitude, which reduced the available time to troubleshoot the loss…Sep 16, 2017 · N53CP · Substantial damageNTSB ERA17FA272Accident · 1 fatalField investigationFinal reportCessna 172 · New Milford, CTThe flight instructor's failure to ensure that the wing flaps were properly configured for takeoff, which resulted in an aerodynamic stall and loss of control during the initial climb.Aug 11, 2017 · N1727V · 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 ERA17FA167Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Wallingford, CTThe pilot's unstablilized approach and improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain control during a go-around. Contributing to the accident was the pilot's lack of experience in the accident airplane…Apr 24, 2017 · N94LP · DestroyedNTSB 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 · Destroyed