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 NYC66F0688Accident · Serious injuriesClosedPiper PA-23 · Lincoln, RIMay 25, 1966 · N2184P · Destroyed NTSB NYC66F0685Accident · Serious injuriesClosedBeech S35 · West Warwick, RIMay 7, 1966 · N829G · Destroyed NTSB NYC66D0637Accident · No injuriesClosedAeronca 7FC · Coventry, RIMay 4, 1966 · N7583B · Substantial damage NTSB NYC66D0554Accident · No injuriesClosedCessna 150 · Newport, RIJan 29, 1966 · N4404U · Substantial damage NTSB NYC66A0078Accident · 3 fatalClosedPiper PA-28 · Warwick, RIJan 22, 1966 · N5562W · 2 aircraft · Destroyed NTSB NYC66F0466Accident · No injuriesClosedBeech A45 · Glocester, RIJan 17, 1966 · N10410 · Substantial damage NTSB NYC66F0344Accident · No injuriesClosedTaylorcraft BC12D1 · Westerly, RINov 7, 1965 · N44331 · Substantial damage NTSB NYC66D0157Accident · No injuriesClosedCessna 172 · Slocum, RIJul 30, 1965 · N7062A · Substantial damage NTSB NYC66A0013Accident · No injuriesClosedBell 47D1 · West Kingston, RIJul 27, 1965 · N210B · Substantial damage NTSB NYC66F0041Accident · No injuriesClosedCessna 182 · Slocum, RIJun 22, 1965 · N9926B · Substantial damage NTSB NYC65A0150Accident · 2 fatalClosedTaylorcraft DCO-65 · Westerly, RIJun 19, 1965 · N58041 · Destroyed NTSB NYC66F0012Accident · No injuriesClosedMooney M20 · Lincoln, RIMay 30, 1965 · N7863V · Substantial damage NTSB NYC65F0197Accident · No injuriesClosedAero Cmdr 500 · Block Island, RIMay 2, 1965 · N3841C · Substantial damage NTSB UNK65X0724Accident · No injuriesClosedPiper PA12 · Woonsocket, RINov 15, 1964 · N4136M · Substantial damage NTSB UNK65X0605Incident · No injuriesClosedBenson Gyro D8M · No Smithfield, RINov 8, 1964 · N8759R · Minor damage NTSB UNK64X4030Accident · Minor injuriesClosedPiper PA24 · Block Is, RISep 18, 1964 · N5260P · Substantial damage NTSB UNK64X3044Accident · No injuriesClosedStinson 108-2 · Woonsocket, RIJul 26, 1964 · N875D · Substantial damage NTSB UNK64X2832Accident · No injuriesClosedBell 47D1 · Kingston, RIJul 14, 1964 · N210B · Substantial damage NTSB UNK64X2661Accident · No injuriesClosedAero Comm 680 · Midletown, RIJul 5, 1964 · N6841S · Substantial damage NTSB UNK64X2242Accident · No injuriesClosedCessna 182 · Block Island, RIJun 12, 1964 · N5489B · Substantial damage NTSB UNK64X1925Accident · Minor injuriesClosedBensen · Smithfield, RIMay 23, 1964 · N8756B · Substantial damage NTSB UNK64X1830Accident · Minor injuriesClosedBeechcraft G35 · Warwick, RIMay 18, 1964 · N5857C · Destroyed NTSB UNK64X1274Accident · No injuriesClosedAeronca 65TL · Smithfield, RIApr 12, 1964 · N31722 · Substantial damage NTSB UNK64X1235Accident · No injuriesClosedCessna 172E · Prudence Is, RIApr 9, 1964 · N3558S · Substantial damage NTSB UNK64X0668Accident · No injuriesClosedBenson B8M · Smithfield, RIFeb 23, 1964 · N8756R · Substantial damage NTSB UNK64X0326Accident · Minor injuriesClosedLuscombe 8F · Warwick, RIJan 23, 1964 · N1854B · Substantial damage NTSB UNK64X0128Accident · No injuriesClosedCessna 150 · Warwick, RIJan 3, 1964 · N7360X · Substantial damage