NTSB investigations, RI
9 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 1 |
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\" = 130)
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" = 130) 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 NYC06CA053Accident · No injuriesData collectionFinal reportBeech E-55 · Providence, RIThe pilot's failure to verify landing gear extension after a landing gear malfunction, which resulted in a wheels up landing.NTSB NYC01FA109Accident · 2 fatalField investigationFinal reportBeech A-36 · Middletown, RIThe pilot's failure to maintain airspeed while landing.NTSB NYC00LA085Accident · Serious injuriesLimited investigationFinal reportBoeing 747-236 · Providence, RIMaintenance personnel's failure to reconnect the pitot connections to the elevator feel computer which resulted in an elevator control surface deflection which was outside of the normal autopilot elevator authority. The uncommanded autopilot input to the…NTSB NYC95LA163Accident · No injuriesLimited investigationFinal reportHelio H-295 · Block Island, RIthe failure of the crosswind castering gear to remain locked on the right main gear during the takeoff roll which resulted in directional control not possible.NTSB NYC94FA106Accident · No injuriesField investigationFinal reportSikorsky S-76B · Newport, RIthe failure of the left hand helical gear in the main gear box (MGB), due to undertorqued attaching bolts installed by the manufacturer, which resulted in a partial MGB failure. This failure resulted in the loss of the number one engine, illumination of the…NTSB NYC91LA153Accident · No injuriesLimited investigationFinal reportCessna 310R · Westerly, RIImproper installation of the right propeller which resulted in thread failure in the propeller hub and separation of the propeller in flight. A factor related to the accident was the right propeller striking the right main landing gear causing its separation…NTSB NYC88DNA01Accident · No injuriesFinal reportGrosvenor Quickie · Middletown, RIThe worn propeller transmission (reduction gear assembly), which failed to transmit power to the propeller at a critical point in the go-around.NTSB NYC87LA254Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Block Island, RIJust before lift-off, after the aircraft had accellerated to about 115 mph, the door on the passenger's side came open. The pilot immediately aborted the takeoff, but was unable to stop on the remaining portion of the 2500' runway. After departing the runway,…NTSB NYC85LA074Accident · No injuriesLimited investigationFinal reportAero Commander 680V · Kingstown, RIWhile en route at 12,500 ft, the plt noted a slight shudder & heard a 'wind noise' then the gear unsafe light illuminated. The plt slowed the acft to 135 KTS & tried recycling the gear, but the gear only dropped to the point where it would twist. All attempts…