NTSB investigations, RI
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 NYC04LA039Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cranston, RIThe pilot's inadvertent encounter with loss of tail rotor effectiveness. A factor was the wind change.NTSB NYC04FA033Accident · 2 fatalField investigationFinal reportCessna 180 · Westerly, RIThe Piper pilot's improper decision to continue a landing on an occupied runway, which resulted in an in-flight collision with the departing Cessna. Factors related to the accident were the departing Cessna pilot's inattentive radio communications, and the…NTSB NYC03LA184Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Pawtucket, RIA loss of engine power for undetermined reasons.NTSB NYC03LA150Accident · Minor injuriesLimited investigationFinal reportGrumman American AA5B · Block Island, RIThe pilot's failure to maintain directional control while landing, after a loss of engine power as reported by the pilot. Factors in this accident were the pilot's improper flare, which resulted in a hard landing, and the crosswind condition.NTSB NYC03CA149Accident · No injuriesData collectionFinal reportBeech BE36 · Block Island, RIThe pilot misjudged speed and distance while landing, which resulted in an overrun. A factor in the accident was a wet runway.NTSB NYC03LA089Accident · No injuriesLimited investigationFinal reportCessna P206 · Newport, RIThe pilot's inadvertent encounter with propeller blast.NTSB NYC03LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Westerly, RIThe pilot-in-command's delayed remedial action when the airplane flew below the glidepath, and a total loss of engine power for undetermined reasons.NTSB NYC03LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Block Island, RIThe pilot's misjudgment of speed and distance as a result of physical impairment due to smoke.NTSB NYC02LA199Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Pawtucket, RIThe parachutist's failure to obtain the proper touchdown point, which resulted in contact with the operating propeller of a parked airplane.NTSB NYC02LA145Accident · No injuriesLimited investigationFinal reportCessna 172N · Middletown, RIThe pilot's improper flare. A factor was the shifting wind.NTSB IAD02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Providence, RIThe student pilot's failure to maintain directional control during the landing.NTSB NYC02FA060Accident · 1 fatalField investigationFinal reportRockwell 500S · Exeter, RIThe pilot's failure to maintain control after encountering icing conditions while on approach for landing. Factors in this accident were the night light conditions and pilot's failure to select the airplane's propeller de-icing switches to the "on" position.NTSB NYC01LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Watch Hill, RILoss of engine power for undetermined reason.NTSB NYC01FA109Accident · 2 fatalField investigationFinal reportBeech A-36 · Middletown, RIThe pilot's failure to maintain airspeed while landing.NTSB NYC01LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, RIThe loose fuel line, which resulted in fuel starvation to the engine.NTSB NYC00FA248Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · South Kingstown, RIThe pilot's loss of control, and his subsequent overstress of the airplane after a vacuum system failure during flight in instrument meteorological conditions. Factors included the instrument meteorological conditions, a sheared coupling on the vacuum pump,…NTSB NYC00LA236Accident · No injuriesLimited investigationFinal reportCessna 172K · Warwick, RIThe pilot's delayed recovery from a bounced landing.NTSB NYC00LA117Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Middletown, RIan inadequate preflight inspection by the pilot which did not detect the water in the fuel tanks prior to departure.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 NYC99FA220Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Westerly, RIThe pilot's loss of control of the airplane during a turn.NTSB NYC99LA211Accident · Serious injuriesLimited investigationFinal reportAeromot AMT-300 · Block Island, RIThe pilot's failure to abort the takeoffNTSB NYC98FA112Accident · 2 fatalField investigationFinal reportBeech A36 · Middletown, RIThe shift of the number 2 engine bearing, which in turn blocked oil lubrication, and resulted in crankshaft failure. Also causal, was the pilot's decision to continue toward the airport instead of performing a forced landing to an available field. Factors…NTSB IAD97FA117Accident · 5 fatalField investigationFinal reportCessna 182E · Smithfield, RIA loss of engine power for undetermined reason, and the pilot's failure to maintain control of the airplane.NTSB NYC97LA162Accident · Minor injuriesLimited investigationFinal reportSimpson Avid Flyer · Westerly, RIThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB IAD97LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Block Island, RIThe pilot's failure to comply with the airplane's takeoff checklist and his delayed decision to abort the takeoff.NTSB NYC97LA014Accident · Serious injuriesLimited investigationFinal reportCessna 340A · Pawtucket, RIfailure of the pilot to comply with the published instrument approach procedure, by continuing the ILS approach below the decision height, rather than performing a missed approach; and his failure to attain a proper touchdown point for the continued landing.…NTSB NYC96LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's misjudgment of distance and speed during the approach to land, and his failure to go around while there was still sufficient runway remaining, which resulted in an overrun of the runway and collision with trees. The lack of natural lighting at…NTSB NYC96LA148Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Westerly, RIinsufficient information from the manufacturer in the airplane flight manual and flightcrew operating manual regarding the hazards of applying force to the control wheel or column while the autopilot is engaged and adjusting the pitch thumbwheel during a…NTSB NYC96LA150Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Providence, RIthe passenger inadvertently lost his balance and fell, while deplaning.NTSB NYC96LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Block Island, RIthe pilot's inadequate preflight, by failing to remove the control lock and checking the flight controls before takeoff, and his failure to abort the takeoff in a timely manner, which resulted in an overrun, an encounter with brush, and a subsequent nose over…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 NYC95LA206Accident · No injuriesLimited investigationFinal reportCessna 140 · Richmond, RIThe pilot's mismanagement of the fuel supply, and his improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB NYC95FA203Accident · 5 fatalField investigationFinal reportCessna A185F · Block Island, RIthe pilot's failure to touch down a sufficient distance from shore, and his delay in aborting the landing. In addition, the pilot exceeded the airplane's weight and balance limits which reduced the airplane's performance.NTSB NYC95LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · West Kingston, RIthe pilot's failure to obtain the proper touchdown point which resulted in insufficient runway stopping distance and a subsequent overrun of the runway, and collision with trees.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 NYC95LA023Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Coventry, RIimproper emergency procedures by the pilot and inadequate supervision by the flight instructor which resulted in their failure to restart the engine after it lost power due to a failed engine driven fuel pump.NTSB NYC94LA164Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Block Island, RIThe pilot maintaining excessive airspeed during the landing, resulting in a touchdown on the runway with insufficient distance to stop, and a subsequent intentional ground loop and collision with the terrain. Also causal was the pilot's failure to abort the…NTSB NYC94LA150Accident · Minor injuriesLimited investigationFinal reportBeech 58P · Newport, RIThe pilot's inflight planning/decision and failure to attain the proper touchdown point.NTSB NYC94LA139Accident · No injuriesLimited investigationFinal reportCessna 172A · Block Island, RIThe pilot's improper decision to initiate VFR flight into instrument meteorological conditions. The dark night light conditions and the fog were contributing factors.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 BFO94LA012Accident · No injuriesLimited investigationFinal reportAngel Elbert S JR Quickie 200 · North Kingston, RILoss of engine power due to undetermined reasons.NTSB BFO93LA179Accident · No injuriesLimited investigationFinal reportCessna 172 · North Kingstown, RIThe pilot inadvertently allowed the airplane to stall as he was maneuvering to avoid birds on final approach.NTSB BFO93LA158Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Block Island, RIImproper in-flight planning/decision by the pilot, and his failure to attain proper runway alignment.NTSB NYC93LA164Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Westerly, RIThe loss of engine power for undetermined reasons, and the subsequent forced landing and collision with soft terrain.NTSB NYC93LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Hope Valley, RIThe engine failure as the result of ingestion of pieces of carburetor into the cylinders, and the subsequent forced landing and nose over during the landing roll after encountering soft terrain.NTSB BFO93LA096Accident · No injuriesLimited investigationFinal reportRyan Navion · Cumberland, RILoss of engine power due to undetermined reasons. A factor related to the accident was rough and uneven terrain.NTSB BFO93LA066Accident · No injuriesLimited investigationFinal reportQuickie 200 · N. Kingstown, RIImproper flare by the pilot.NTSB NYC93LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Pawtucket, RIThe failure of both pilots to see and avoid, resulting in a ground collision between their two airplanes.NTSB BFO92FA133Accident · 2 fatalField investigationFinal reportCessna 182R · Westerly, RIInadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, self-induced pressure…NTSB BFO92LA018Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Richmond, RIThe pilots failure to maintain directional control during rollout.