Skip to content

NTSB investigations, RI

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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.

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'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB NYC72AN010Accident · 2 fatalClosedCessna 172K · Esmond, RIJul 25, 1971 · N84446 · Destroyed NTSB NYC71FNA60Accident · 1 fatalClosedGrumman F8F-2 · No.Kingstown, RIJun 5, 1971 · N7700C · Destroyed NTSB NYC71FFD41Accident · No injuriesClosedPiper PA-24 · Lincoln, RIMar 30, 1971 · N8233P · Substantial damage NTSB NYC71FFD38Accident · No injuriesClosedPiper PA-24 · Smithfield, RIFeb 6, 1971 · N1Q · Substantial damage NTSB NYC71AN061Accident · Serious injuriesClosedCessna 310D · Warwick, RINov 17, 1970 · N6769T · Destroyed NTSB NYC71AN024Accident · 1 fatalClosedErco 415-E · Lincoln, RIAug 19, 1970 · N94832 · Destroyed NTSB NYC71AN045Accident · No injuriesClosedAero Comdr 680-FL · Middletown, RIJul 18, 1970 · N4528E · Substantial damage NTSB NYC70AN126Accident · 2 fatalClosedMess-Boelkw B0-105 · Little Compton, RIJun 3, 1970 · N197F · Destroyed NTSB NYC70DFD17Accident · No injuriesClosedBensen B-8M · Charlestown, RIMay 30, 1970 · N8212 · Substantial damage NTSB NYC70DFD20Accident · No injuriesClosedPiper PA-22 · Smithfield, RIMay 28, 1970 · N4932Z · Substantial damage NTSB NYC70DFD12Accident · No injuriesClosedPiper PA-32 · Smithfield, RIMay 2, 1970 · N3913W · Substantial damage NTSB NYC70AN110Accident · 1 fatalClosedCessna 150B · Cranston, RIApr 5, 1970 · N1198Y · Destroyed NTSB NYC70AN090Accident · No injuriesClosedLear Jet 24B · Warwick, RIFeb 15, 1970 · N754M · Substantial damage NTSB NYC70F0249Accident · No injuriesClosedStinson 108-1 · Warwick, RIDec 25, 1969 · N400T · Substantial damage NTSB NYC70F0186Accident · No injuriesClosedBell 47G-4 · E Providence, RIOct 16, 1969 · N73943 · Substantial damage NTSB NYC70A0035Accident · No injuriesClosedN.American NA-265 · Westerly, RISep 18, 1969 · N881MC · Substantial damage NTSB NYC70A0020Accident · 1 fatalClosedBeech E35 · Block Island, RIAug 6, 1969 · N8818A · Destroyed NTSB NYC70D0041Accident · No injuriesClosedBeech C55 · Block Island, RIJun 26, 1969 · N9562Q · Substantial damage NTSB NYC70D0016Accident · Minor injuriesClosedCessna 150G · Coventry, RIMay 30, 1969 · N3688J · Destroyed NTSB NYC69F0441Accident · No injuriesClosedCessna 150F · Coventry, RIMay 13, 1969 · N8066S · Substantial damage NTSB NYC69A0095Accident · 5 fatalClosedCessna 150H · Middletown, RIApr 23, 1969 · N23140 · 2 aircraft · Destroyed NTSB NYC69A0083Accident · No injuriesClosedPiper PA-30B · Warwick, RIFeb 26, 1969 · N8555Y · Substantial damage NTSB NYC69A0037Accident · No injuriesClosedPiper PA-28 · Lincoln, RISep 19, 1968 · N6690J · 2 aircraft · Minor damage NTSB NYC69D0099Accident · No injuriesClosedBeech T-34A · Lincoln, RIAug 1, 1968 · N5504A · Substantial damage NTSB NYC69A0013Accident · 3 fatalClosedCessna 182H · Jamestown, RIAug 1, 1968 · N8317S · Destroyed NTSB NYC69D0112Accident · No injuriesClosedLuscombe 8F · Westerly, RIJul 20, 1968 · N1885B · Substantial damage NTSB NYC68A0128Accident · No injuriesClosedCessna 210 · Middletown, RIMay 28, 1968 · N6599X · Substantial damage NTSB NYC68A0108Accident · 2 fatalClosedCessna 182 · Potters Cove, RIMar 19, 1968 · N2623F · Substantial damage NTSB NYC68D0366Accident · No injuriesClosedCessna 210F · Slocum, RIFeb 11, 1968 · N5811F · Substantial damage NTSB NYC68D0148Accident · No injuriesClosedPiper PA-30 · Block Island, RIAug 18, 1967 · N7324Y · Substantial damage NTSB NYC68D0089Accident · No injuriesClosedChampion 7FC · Block Island, RIAug 13, 1967 · N9893B · Substantial damage NTSB NYC68A0007Accident · No injuriesClosedBell 47D1 · N Kingston, RIJul 13, 1967 · N210B · Substantial damage NTSB NYC68F0266Accident · Serious injuriesClosedPiper PA-22 · Block Island, RIJul 4, 1967 · N2768P · Destroyed NTSB NYC68D0158Accident · No injuriesClosedCessna 140 · No-Kingstown, RIMay 30, 1967 · N72708 · Substantial damage NTSB NYC68F0127Accident · No injuriesClosedStinson V-77 · Lincoln, RIMay 20, 1967 · N69985 · Substantial damage NTSB NYC68F0180Accident · No injuriesClosedCessna 310K · Block Island, RIMay 4, 1967 · N6921L · Substantial damage NTSB NYC67D0637Accident · No injuriesClosedPiper PA-22 · Coventry, RIApr 25, 1967 · N2469A · Substantial damage NTSB NYC67D0626Accident · No injuriesClosedCessna 182 · Providence, RIApr 11, 1967 · N2092R · Substantial damage NTSB NYC67D0624Accident · No injuriesClosedCessna 172E · Block Island, RIMar 25, 1967 · N3500S · Substantial damage NTSB NYC67D0503Accident · No injuriesClosedCessna 172 · Warwick, RIFeb 16, 1967 · N9810T · Substantial damage NTSB NYC67F0478Accident · No injuriesClosedPiper PA-24 · Lincoln, RIJan 29, 1967 · N9002P · Substantial damage NTSB NYC67F0409Accident · No injuriesClosedNavion A · Warwick, RIDec 15, 1966 · N91454 · Substantial damage NTSB NYC67F0403Accident · No injuriesClosedMooney M20C · Smithfield, RINov 23, 1966 · N1384W · Substantial damage NTSB NYC67A0087Accident · No injuriesClosedCessna 182B · Block Island, RINov 22, 1966 · N2570G · Substantial damage NTSB NYC67D0207Accident · No injuriesClosedCessna 172 · Slocum, RISep 18, 1966 · N7062A · Substantial damage NTSB NYC67A0049Accident · 1 fatalClosedHughes 269A · Lincoln, RISep 16, 1966 · N8799F · Destroyed NTSB NYC67A0029Accident · Minor injuriesClosedCessna U206 · Westerly, RIAug 17, 1966 · N8077Z · Destroyed NTSB NYC67D0137Accident · No injuriesClosedBeech 23 · Block Island, RIJul 15, 1966 · N2370L · Substantial damage NTSB NYC67F0054Accident · No injuriesClosedLuscombe 8E · Newport, RIJul 12, 1966 · N1689K · Substantial damage NTSB NYC67D0356Accident · No injuriesClosedCulver V · Westerly, RIJun 15, 1966 · N6544C · Substantial damage