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.
Cases, newest first
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' 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 NYC84LA262Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Newport, RIThe plt extended the downwind leg of his landing traffic pattern to allow an acft ahead of him to land with the appropiate spacing between acft. The plt stated that just prior to touchdown he 'lowered the landing gear (too late).' In his recommendation for…NTSB NYC84LA190Accident · No injuriesLimited investigationFinal reportCessna C190 · South Kingston, RIAnticipating deteriorating weather conditions, the pilot decided to land at an unfamiliar airstrip. He landed long and had commenced a go-around but the landing gear caught in swamp growth and collapsed.NTSB NYC84LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Westerly, RIOn final approach to runway 32, the aircraft contacted trees located approximately 600 yard short of the approach end of the runway. The passenger stated after the accident that as the aircraft approached the runway, he noticed the acft was 'a bit too close…NTSB NYC84LA006Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Block Island, RIThe flt was uneventful until the acft was landed at the destination. During the landing, the acft veered off the rwy & was damaged. An exam of the brake sys revealed that the reservoir still had fluid. When checked, the left brake was firm, but the right…NTSB NYC83LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Westerly, RIAfter landing, the plt proceeded to taxi to the ramp area. While maneuvering within the ramp area, the plt taxied the acft into a construction zone. Reportedly, the right main wheel dropped into a rough area & resulted in substantial damage to the right wing…NTSB NYC83LA176Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · West Kingston, RIThe acft overran the rwy hit VASI lights and rolled down an embankment during landing. The pilot was under some pressureto get on the ground because of a hyperventilating passenger. The pilot reported he increased his rate of descent by lowering the acft…NTSB NYC83LA155Accident · Minor injuriesLimited investigationFinal reportCessna TU-206G · Block Island, RIThe float acft nosed over during taxi for takeoff. The pilot had picked up this acft 2 days before in farmingdale NY where a set of floats had been installed. He flew to Block Island to pick up 4 passengers and baggage. During downwind taxi for takeoff…NTSB NYC83LA145Accident · No injuriesLimited investigationFinal reportCessna 172M · Block Island, RIThe plt reported that during a landing, the brakes failed & he was unable to stop on the rwy. The acft ran off the end & came to rest in bushes with substantial damage. According to the plt, the outboard pressure plate & lining had separated from each brake.…NTSB NYC83LA129Accident · No injuriesLimited investigationFinal reportCessna 182N · Newport, RIThe acft went off the wet runway onto the wet grass down an embankment and into some rocks. The instructor was making this final landing. Braking was poor from a light rain. As a turn was started onto a taxiway at the end of runway 22 the acft went onto the…NTSB NYC83LA093Accident · No injuriesLimited investigationFinal reportCessna 182P · Block Island, RIThe acft veered off the runway during landing and collided with a ditch. The approach to Block Island was normal and thelanding was made about one third down the runway. On touchdown, directional control was lost and the acft veered to the left side of the…NTSB NYC82FNA16Accident · 1 fatalFinal reportDavis DA-2A · Lincoln, RIThe pilot was on a local pleasure flight to see that the aircraft was functioning properly after a routine inspection. Just prior to the accident, witnesses heard the engine sputter, then become quiet. The plane was observed to continue straight ahead for…NTSB NYC82DA128Accident · No injuriesFinal reportBell 206B · Jamestown, RIThe helicopter was being used to photograph ships. According to the pilot, it began to spin while he was in a low level hover over the water. Subsequently, the helicopter struck the water, rolled over, then sank in about 104 ft of water and was not recovered.NTSB NYC82DA046Accident · No injuriesFinal reportCessna T188C · Block Island, RIWhile on a ferry flight approaching the nantucket VOR the pilot stated that the engine began to run rough. The aircraft was turned back towards Block Island at which time the fuel pressure began to fluctuate and decrease along with the manifold pressure. The…NTSB NYC82DA044Accident · No injuriesFinal reportCessna 182RG · Smithfield, RIAccording to the pilot, while on final approach to runway 33, a severe downdraft was experienced and he was unable to recover. He landed short of the runway on firm grass, bounced and came to rest a short distance from the downwind end of the runway.…NTSB NYC82DA049Accident · No injuriesFinal reportCessna 421C · Westerly, RIThe aircraft touched down hard during a night landing after the pilot encountered icing conditions in flight. Several witnesses reported that the aircraft had 1/2 to 3/4 inch of ice on the leading edges of the wings and verticle stabilizer. The gross landing…NTSB DCA82AA016Accident · 1 fatalFinal reportde Havilland DHC-6 · Providence, RIAprx 15 min aft tkof, lgt icg was noted on the windshield. The aircrew activated the windshield washer/deice sys which used isopropyl alcohol. However, only a little deicing fluid was noted on either side. The sys was activated again. Aft hldg the sw svrl…NTSB NYC82FNA08Accident · No injuriesClosedCessna 140 · Westerly, RINTSB NYC81FNA18Accident · 1 fatalClosedRand KR-2 · N Kingstown, RINTSB NYC81FNA19Accident · No injuriesClosedBell 47G-3B · Pawtucket, RINTSB NYC81FNA16Accident · Minor injuriesClosedCessna 172N · Cranston, RINTSB NYC81FNA12Accident · Minor injuriesClosedPiper PA-28 · Chepachet, RINTSB NYC81DNA04Accident · No injuriesClosedBell 206B · Warwick, RINTSB NYC81FNA06Accident · No injuriesClosedSonerai II · East Greenwich, RINTSB NYC81FNA02Accident · Minor injuriesClosedCessna 172 · Warwick, RINTSB NYC80FNA28Accident · No injuriesClosedBellanca 7KCAB · Lincoln, RINTSB NYC81FA005Accident · 1 fatalClosedCessna 210 · Newport, RINTSB NYC80IA076Incident · No injuriesClosedAerospatial SA330J · N Kingstown, RINTSB NYC80FA075Accident · 1 fatalClosedPiper PA-18 · Exeter, RINTSB NYC80DNA22Accident · No injuriesClosedStinson 108-2 · Quonset, RINTSB NYC80FA039Accident · Serious injuriesClosedPiper PA-38 · Pawtucket, RINTSB NYC80FNA09Accident · No injuriesClosedCessna 150G · Foster, RINTSB NYC80FNA07Accident · Minor injuriesClosedBeech B23 · Block Island, RINTSB NYC79FNA27Accident · No injuriesClosedPiper PA-23 · Newport, RINTSB NYC79FNA25Accident · Serious injuriesClosedGrum Amer AA1B · W.Greenwich, RINTSB NYC79FNA14Accident · No injuriesClosedCessna 172 · Newport, RINTSB NYC78FNA46Accident · No injuriesClosedCessna 170 · Block Island, RINTSB NYC78FNA37Accident · Serious injuriesClosedBeech A23-24 · E Providence, RINTSB NYC78FNA36Accident · No injuriesClosedLuscombe 8A · Kingstown, RINTSB NYC78FA069Accident · 4 fatalClosedPiper PA-32 · Westerly, RINTSB NYC78FNA33Accident · No injuriesClosedCurtiss C 12Q · Westerly, RINTSB NYC78FNA32Accident · No injuriesClosedGrum Amer AA1-A · Lincoln, RINTSB NYC78FNA30Accident · No injuriesClosedPiper PA-24 · Block Island, RINTSB NYC78FNA23Accident · No injuriesClosedMooney M20C · Westerly, RINTSB NYC78FNA09Accident · No injuriesClosedPiper PA-22 · Westerly, RINTSB NYC78FNA06Accident · No injuriesClosedAeronca 7AC · Lincoln, RINTSB NYC78FA024Accident · 1 fatalClosedTemco GC1B · Newport, RINTSB NYC78FNA03Accident · No injuriesClosedCessna 172 · Providence, RINTSB NYC77FNA28Accident · No injuriesClosedCessna 120 · N.Kingstown, RINTSB NYC77DNA23Accident · Minor injuriesClosedCessna 150 · Block Island, RINTSB NYC77FA044Accident · Minor injuriesClosedPiper PA-28 · Johnston, RI