NTSB investigations, CT

4 cases where NTSB found Organizational issues.

Cases per year

20132026
NTSB investigations, CT per year, 2013–2026: 4 cases
20131
20191
20211
20241

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\", '04'))
  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 ERA25FA076Accident · 1 fatalClass 3 · FieldFinal reportCostruzioni Aeronautiche Tecnam P2008 · Greenwich, CTA total loss of engine power due to water-contaminated fuel, and the pilots’ inadequate preflight inspection. Contributing to the water contamination were the missing o-ring or packing and damage to the left fuel cap, and the undetected improperly sealed…Dec 12, 2024 · N298PM · Substantial damageNTSB ERA21FA346Accident · 4 fatalClass 2 · FieldFinal reportCessna 560 · Farmington, CTThe pilot-in-command’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane-nose-down pitching moment that prevented the airplane from becoming airborne within the takeoff…Sep 2, 2021 · N560AR · DestroyedNTSB ERA20MA001Accident · 7 fatalClass 2 · MajorFinal reportBoeing B17 · Windsor Locks, CTThe pilot’s failure to properly manage the airplane’s configuration and airspeed after he shut down the No. 4 engine following its partial loss of power during the initial climb. Contributing to the accident was the pilot/maintenance director’s inadequate…Oct 2, 2019 · N93012 · DestroyedNTSB ERA13LA116Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Ellington, CTThe separation of the collective push-pull tube and jackshaft assembly, which resulted in the total loss of helicopter control and collision with terrain. Contributing to the accident was the inadequate supervision of maintenance personnel by the operator…Jan 17, 2013 · N26NE · Substantial damage