NTSB investigations, RI
12 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 2 |
| 1993 | 2 |
| 1997 | 1 |
| 2001 | 1 |
| 2003 | 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\" = 350)
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" = 350) 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 NYC03LA184Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Pawtucket, RIA loss of engine power for undetermined reasons.NTSB NYC01LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Watch Hill, RILoss of engine power for undetermined reason.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 BFO94LA012Accident · No injuriesLimited investigationFinal reportAngel Elbert S JR Quickie 200 · North Kingston, RILoss of engine power due to undetermined reasons.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 NYC91LA217Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Jamestown, RIThe pilot's improper use of carburetor heat, resulting in carburetor ice formation and subsequent loss of engine power and a forced landing in trees.NTSB NYC91LA201Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Westerly, RIEngine failure for an undetermined reason. A factor was the pilot misjudging the clearance over a fence during an attempted forced landing.NTSB NYC87LA222Accident · No injuriesLimited investigationFinal reportRobinson R22 · Burrville, RIAircraft lost engine power shortly after takeoff at an altitude of about 200 feet. Pilot attempted to autorotate back to the lake but during a turn to avoid collision with a boat, the helicopter crashed into the water. The reason for the engine power loss was…NTSB NYC86LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Block Island, RIThe eng lost partial power on the initial climb-out as the plt was taking off from rwy 28. He initiated a left turn back to the arpt, but the eng lost all power. Subsequently, the acft was landed in an area of brush & small trees near the west end of the…NTSB NYC86LA026Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Block Island, RIThe floatplane experienced a pwr loss about 15 miles south of martha's vineyard VOR. The eng manifold pressure dropped and the RPM became erratic. The plt attempted to restart the eng using primary and emergency fuel pumps but the eng would not restart. 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 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…