NTSB investigations, MA
11 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2007 | 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\" = 'MA' 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\" = 354)
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" = 'MA' 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" = 354) 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 NYC07CA165Accident · No injuriesData collectionFinal reportPiper J3C-65 · Uxbridge, MAA partial loss of engine power for undetermined reasons.NTSB IAD05LA002Accident · No injuriesLimited investigationFinal reportBradley Renegade · Stow, MAA partial loss of engine power for undetermined reasons, which resulted in the airplane's inability to climb over a stand of trees.NTSB IAD02LA094Accident · 1 fatalLimited investigationFinal reportGarlick OH-58AT · Rochester, MAThe pilot's failure to center the sling load prior to commencing forward flight. Also causal, was the pilot's improper decision to attempt a takeoff with a quartering tailwind, which resulted in an engine compressor stall.NTSB NYC97LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · North Andover, MAFuel vents blocked by frozen moisture which resulted in restricted fuel flow to the engine and subsequent loss of engine power.NTSB NYC95LA177Accident · No injuriesLimited investigationFinal reportPincince Corbin Baby ACE · Palmer, MAcontamination in the carburetor which resulted in fuel starvation, a total loss of engine power and forced landing.NTSB NYC91LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, MAThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain in which the emergency landing was made.NTSB NYC88LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Plymouth, MAThe pilot of the PA-24 said everything was normal until he switched fuel tanks and turned on the boost pump. He said a power loss followed. He was unable to get the engine restarted prior to making an off airport landing. A witness in the aircraft said the…NTSB NYC85LA249Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5B · Manchester, MAPlt stated that during cruise flight at an altitude of 1200 ft the engine RPM decreaseed from cruise setting to between 900-1100 RPM. The acft was overwater and 2 miles from the coastline. He was unable to maintain altitude and he started a descent toward…NTSB NYC84FNE03Accident · 1 fatalFinal reportPiper J4A · Gardner, MADuring climbout, plt noted slight pwr loss, applied carb heat & eng regained pwr. On removal of carb heat, pwr loss (aprx 200 RPM) again occurred. Application of carb heat again resorted pwr but plt elected to turn back to field and land. During turn, plt…NTSB NYC84FA090Accident · 1 fatalField investigationFinal reportBeech 76 · Beverly, MAA commercially rated plt (student) was receiving multi-eng training from an instructor plt (CFI). The student stated that on final apch to landing, he noticed the airspeed was slow when the CFI shut down the right eng by using the mixture control. The acft…NTSB NYC84LA050Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC Citabria · Nantucket, MAThe acft experienced a power loss and crashed during a low pass to observe an object on the ground. The flt had departednantucket and flown over to tuckernuck isl where a descent was made to observe an unusual object on a shoal. Carburetor heat was applied…