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 NYC77FA030Accident · 1 fatalClosedCessna 150L · Smithfield, RIFeb 4, 1977 · N6756G · Destroyed NTSB NYC77FNA06Accident · No injuriesClosedCessna 172C · Warwick, RIDec 13, 1976 · N8286X · Substantial damage NTSB NYC77FNA05Accident · No injuriesClosedCessna 172M · West Kingston, RINov 24, 1976 · N64238 · Substantial damage NTSB NYC76AN126Accident · 1 fatalClosedBeech S35 · Block Island, RISep 8, 1976 · N272D · Minor damage NTSB NYC76DNA49Accident · No injuriesClosedCessna 120 · Block Island, RIAug 26, 1976 · N1808N · Substantial damage NTSB NYC76FNA42Accident · Serious injuriesClosedPiper PA-23 · Greene, RIJul 9, 1976 · N2277P · Destroyed NTSB NYC76AN107Accident · 1 fatalClosedPiper PA-28 · Jamestown, RIJul 1, 1976 · N9184K · Destroyed NTSB NYC76AN098Accident · Serious injuriesClosedBell 47K · West Greenwich, RIMay 22, 1976 · N2886 · Destroyed NTSB NYC76FNA37Accident · No injuriesClosedPiper PA-28 · Lincoln, RIMay 1, 1976 · N6797J · Substantial damage NTSB NYC76FNA36Accident · No injuriesClosedMooney M20F · New Shoreham, RIApr 24, 1976 · N3470N · Substantial damage NTSB NYC76FNA30Accident · No injuriesClosedPiper PA-23 · Warwick, RIMar 8, 1976 · N2277P · Substantial damage NTSB NYC76DNA26Accident · No injuriesClosedCessna 172 · Block Island, RIJan 17, 1976 · N20501 · Substantial damage NTSB NYC76FNA19Accident · No injuriesClosedBeech D55 · Warwick, RIOct 21, 1975 · N222AS · Substantial damage NTSB NYC76AN036Accident · No injuriesClosedDassault Falcon · Warwick, RISep 27, 1975 · N25FE · Substantial damage NTSB NYC76FNA05Accident · No injuriesClosedCessna 172M · Block Island, RIJul 27, 1975 · N6657H · Substantial damage NTSB NYC75FNA45Accident · 1 fatalClosedBaby Ace D1 · Green, RIJun 8, 1975 · N4184A · Destroyed NTSB NYC75AN098Accident · 1 fatalClosedCessna 182 · Foster, RIApr 8, 1975 · N71550 · Destroyed NTSB NYC75FNA33Accident · No injuriesClosedPiper PA-23 · Lincoln, RIMar 2, 1975 · N40245 · Substantial damage NTSB NYC75FNA26Accident · No injuriesClosedPiper PA-28 · Warwick, RINov 23, 1974 · N4375T · Substantial damage NTSB NYC75FNA23Accident · No injuriesClosedLuscombe 8F · Block Island, RIOct 24, 1974 · N37087 · Substantial damage NTSB NYC75FNA18Accident · Minor injuriesClosedCessna 172 · Block Island, RISep 22, 1974 · N6206E · Destroyed NTSB NYC75FNA13Accident · 1 fatalClosedCorben Ace MOD-1 · Narragansett, RIAug 25, 1974 · N6442 · Destroyed NTSB NYC75DNA14Accident · Minor injuriesClosedBeech B23 · Block Island, RIAug 25, 1974 · N16BW · Substantial damage NTSB NYC75AN021Accident · 1 fatalClosedBell 47J-2A · Point Judith, RIAug 22, 1974 · N37739 · Destroyed NTSB NYC75DNA07Accident · No injuriesClosedBeech G35 · Pawtucket, RIJul 28, 1974 · N135JL · Substantial damage NTSB NYC74FNA45Accident · No injuriesClosedBeech 35-33 · Smithfield, RIJun 16, 1974 · N9782Y · Substantial damage NTSB NYC74DNA44Accident · No injuriesClosedCessna 150H · Slocum, RIMay 18, 1974 · N50439 · Substantial damage NTSB NYC74AN081Accident · No injuriesClosedPiper PA-31 · Providence, RIMar 15, 1974 · N9057Y · Substantial damage NTSB NYC74FNA23Accident · Minor injuriesClosedButterworth Teenie · W.Kingston, RIOct 21, 1973 · N50GB · Destroyed NTSB NYC74DNA13Accident · No injuriesClosedPiper J-3 · Greene, RISep 1, 1973 · N6987H · Substantial damage NTSB NYC74FNA11Accident · Serious injuriesClosedPiper PA-12 · Greene, RIAug 24, 1973 · N4029H · Substantial damage NTSB NYC74FNA08Accident · No injuriesClosedPiper PA-24 · Lincoln, RIAug 5, 1973 · N5290P · Substantial damage NTSB NYC73FNA51Accident · Minor injuriesClosedCessna 150 · Tiverton, RIJun 3, 1973 · N6517T · Substantial damage NTSB NYC73DNA19Accident · No injuriesClosedNavion A · Providence, RISep 4, 1972 · N91698 · Substantial damage NTSB NYC73DNA16Accident · No injuriesClosedBeech B35 · Block Island, RIAug 25, 1972 · N8874A · Substantial damage NTSB NYC73FNA17Accident · Serious injuriesClosedCessna 172K · West Kingston, RIAug 23, 1972 · N46523 · Substantial damage NTSB NYC73DNA15Accident · No injuriesClosedCessna 172L · Block Island, RIAug 22, 1972 · N7604G · Substantial damage NTSB NYC73FNA18Accident · Minor injuriesClosedAero Comdr 100 · Jamestown, RIAug 13, 1972 · N4159X · Substantial damage NTSB NYC73FNA26Accident · Serious injuriesClosedPiper PA-28 · Block Island, RIJul 15, 1972 · N7259J · Destroyed NTSB NYC73DNA04Accident · No injuriesClosedPiper PA-32 · Warwick, RIJul 13, 1972 · N4088W · Substantial damage NTSB NYC72FNA46Accident · No injuriesClosedCessna 337B · Warwick, RIJun 25, 1972 · N44LB · Substantial damage NTSB NYC72DNA40Accident · No injuriesClosedPiper PA-28 · Lincoln, RIMay 7, 1972 · N98285 · Substantial damage NTSB NYC72FNA34Accident · No injuriesClosedCessna 150L · N.Smithfield, RIFeb 21, 1972 · N6585G · Substantial damage NTSB NYC72DNA32Accident · No injuriesClosedMccullough J-2 · Newport, RIFeb 5, 1972 · N4314G · Substantial damage NTSB NYC72FNA28Accident · No injuriesClosedCessna 150J · Lincoln, RIJan 17, 1972 · N50714 · Substantial damage NTSB NYC72DNA23Accident · No injuriesClosedPiper PA-22 · Block Island, RIDec 18, 1971 · N8537C · Substantial damage NTSB NYC72AN069Accident · 1 fatalClosedAero Comdr 560-A · East Greenwich, RINov 22, 1971 · N87K · Substantial damage NTSB NYC72AN026Accident · No injuriesClosedAero Comdr 500-B · Newport, RIAug 18, 1971 · N6367U · Substantial damage NTSB NYC72FNA06Accident · Serious injuriesClosedBeech E33 · Block Island, RIAug 1, 1971 · N7506N · Substantial damage NTSB NYC72DNA04Accident · No injuriesClosedPiper PA-28 · Block Island, RIJul 28, 1971 · N9524J · Substantial damage