NTSB investigations, RI

15 cases where NTSB found Use of equip/info.

Cases per year

20082026
NTSB investigations, RI per year, 2008–2026: 15 cases
20083
20101
20141
20152
20162
20172
20191
20201
20241
20261

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\" = 'RI' 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\", '020630'))
  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 ERA26LA336Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · West Kingston, RIThe pilot’s failure to bring the airplane to a stop on the available runway, which resulted in a runway excursion.Sep 9, 2026 · N4056W · Substantial damageNTSB ERA24LA343Accident · Minor injuriesClass 4 · LimitedFinal reportYakovlev YAK-55M · North Kingstown, RIThe non-certificated pilot’s lack of experience in the tailwheel-equipped airplane and his decision to land in a quartering tailwind, which resulted in a loss of directional control on landing.Aug 10, 2024 · N55YA · Substantial damageNTSB ERA20CA264Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20J · Block Island, RIA hard landing and subsequent loss of control.Jul 18, 2020 · N58066 · Substantial damageNTSB CEN19LA213Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Smithfield, RIThe pilot’s failure to use carburetor heat on approach in weather conditions conducive to carburetor icing, which resulted in a forced landing to a pond.Jun 22, 2019 · N415WP · Substantial damageNTSB GAA18CA021Accident · Minor injuriesData collectionFinal reportPiper PA32R · Block Island, RIThe pilot's use of an incorrect airspeed during landing, which resulted in a runway overrun.Oct 1, 2017 · N1054S · DestroyedNTSB GAA17CA577Accident · No injuriesData collectionFinal reportFlight Design Ctls · Newport, RIThe student pilot’s improper landing flare, which resulted in a hard, bounced landing.Sep 2, 2017 · N547CT · Substantial damageNTSB ERA17LA014Accident · No injuriesLimited investigationFinal reportCessna 525 · Pawtucket, RIThe flight crew's failure to maintain an appropriate approach speed and obtain an appropriate touchdown point on the runway, which resulted in a runway overrun.Oct 13, 2016 · N518AR · Substantial damageNTSB ERA16CA218Accident · No injuriesData collectionFinal reportPiper PA32 · Block Island, RIThe pilot's failure to attain the proper touchdown point and the airplane’s subsequent collision with obstacles during an attempted go-around.Jun 19, 2016 · N44255 · Substantial damageNTSB GAA15CA045Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Newport, RIThe pilot's failure to maintain directional control during landing.Apr 18, 2015 · N684CT · Substantial damageNTSB ERA15CA153Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe student pilot's failure to maintain aircraft control during landing, and his subsequent failure to recover from a bounced landing, which resulted in a hard landing.Mar 8, 2015 · N65645 · Substantial damageNTSB ERA14CA438Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Block Island, RIA loss of control during the attempted go-around, which resulted in an aerodynamic stall and impact with trees.Aug 10, 2014 · N2149F · Substantial damageNTSB ERA10CA303Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Block Island, RIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with a fence.Jun 2, 2010 · N47661 · Substantial damageNTSB ERA09FA060Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIThe pilot's improper descent below the published minimum descent altitude during the approach, which resulted in controlled flight into terrain.Nov 17, 2008 · N2316P · Substantial damageNTSB NYC08LA299Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Cumberland, RIThe pilot's improper fuel management practices, which resulted in fuel starvation and a complete power loss. Contributing to the accident was the pilot's misdiagnosis of the situation, and his cessation of trouble-shooting to positively identify and correct…Sep 1, 2008 · N5529J · Substantial damageNTSB NYC08CA179Accident · Minor injuriesData collectionFinal reportCessna T182T · Newport, RIThe pilot's failure to maintain adequate airspeed during a go-around. Contributing to the accident was the pilot's improper weather evaluation and a tailwind.May 10, 2008 · N65433 · Substantial damage