NTSB investigations, RI

6 cases where NTSB found Action.

Cases per year

20082026
NTSB investigations, RI per year, 2008–2026: 6 cases
20082
20111
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\" = '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\", '020410'))
  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 ERA24LA164Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · North Kingstown, RIA total loss of engine power during final approach due to the pilot’s failure to recognize that the environmental conditions were susceptible to carburetor icing and apply carburetor heat, which resulted in the formation of carburetor ice. Contributing to the…Mar 30, 2024 · N7538P · Substantial damageNTSB ERA21LA371Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · New Shoreham, RIThe pilot’s improper decision to reject the takeoff at an excessive speed, resulting in a runway excursion and collision with a fence. Contributing to the accident was the pilot’s failure to lock the door as required by the placarded door closing procedures.Jul 27, 2021 · N110CG · 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 ERA12CA025Accident · No injuriesData collectionFinal reportCessna 177RG · Westerly, RIThe pilot's failure to maintain airplane control while starting the engine.Oct 6, 2011 · N177MW · Substantial damageNTSB NYC08FA237Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Middletown, RIThe flight instructor's failure to initiate a go-around during a high approach, and his inadequate remedial action during an attempted touch-and-go.Jul 3, 2008 · N9888K · Substantial damageNTSB NYC08LA207Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pawtucket, RIBoth pilots' failure to see and avoid the other airplane. Contributing to the accident was the air traffic controllers failure to notify either pilot of the potential conflict.Jun 6, 2008 · N27199 · 2 aircraft · Substantial damage