NTSB investigations, RI
9 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1983 | 3 |
|---|---|
| 1987 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 2002 | 1 |
| 2007 | 2 |
Where
Open the mapLatest 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 ATL07CA124Accident · No injuriesData collectionFinal reportCessna C172R · Pawtucket, RIThe student pilot's failure to maintain control of the aircraft during the takeoff roll.NTSB ATL07CA109Accident · No injuriesData collectionFinal reportCessna 172P · Newport, RIThe pilot's failure to maintain directional control during the landing roll.NTSB IAD02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Providence, RIThe student pilot's failure to maintain directional control during the landing.NTSB NYC96LA043Accident · No injuriesLimited investigationFinal reportPiper J3F · Westerly, RIthe pilot's inadequate compensation for the wind condition, which subsequently resulted in the aircraft nosing over. The gusty crosswind condition was a related factor.NTSB NYC90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Middleton, RILoss of direction control by the pilot when he came in high and fast and touched down at improper touchdown point.NTSB NYC87LA270Accident · No injuriesLimited investigationFinal reportRockwell 112A · No Kingstown, RIThe aircraft bounced on landing and directional control was lost. The airplane veered to the left side of the runway and struck a pile of rubble and continued into the bay.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 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…