NTSB investigations, NY
29 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 5 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 2003 | 2 |
| 2004 | 4 |
| 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\" = 'NY' 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\" = 352)
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" = 'NY' 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" = 352) 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 IAD05LA115Accident · No injuriesLimited investigationFinal reportCessna 182B · East Moriches, NYThe improper installation of the right magneto harness to the magneto housing by unidentified maintenance personnel, which resulted in arcing, significant wear, and a subsequent loss of engine power. Factors in the accident were the pilot's failure to attain…NTSB IAD05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150C · East Moriches, NYSeveral mechanical deficiencies which either independently or collectively resulted in a subsequent loss of engine power. A factor in the accident was the obstruction in the forced landing area.NTSB IAD04LA048Accident · Minor injuriesLimited investigationFinal reportBoeing A75N (PT17) · Bayport, NYThe failure of a magneto, which resulted in a loss of engine power. Factors in the accident were the pilot's decision to take off downwind, which resulted in reduced airplane performance, and the tail wind.NTSB NYC04LA192Accident · No injuriesLimited investigationFinal reportWaco QCF · Rhinebeck, NYA partial loss of engine power due to a magneto failure.NTSB NYC04LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brighton Beach, NYA partial loss of engine power during cruise flight for undetermined reasons.NTSB NYC03LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Rhinebeck, NYA loss of engine power due to a failure of the number eight cylinder.NTSB NYC03LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Williamson, NYThe failure of a rocker arm shaft boss, which resulted in a partial loss of power and subsequent forced landing. A factor was the unsuitable terrain.NTSB NYC97LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Easton, NYmechanical binding of the number three exhaust valve, and the pilot/owner's improper planning/decision by failing to ensure the engine was operating properly before takeoff. A related factor was: the pilot/owner's failure to ensure that annual maintenance was…NTSB NYC97LA132Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Yates, NYThe failure of the cylinder bolts, and the lack of suitable terrain for a forced landing.NTSB NYC95LA112Accident · Minor injuriesLimited investigationFinal reportHelio H-250 · Clarkson, NYFailure of the engine fuel pump, which resulted in fuel starvation and loss of engine power over an unsuitable landing area. Factors relating to the accident were: the airplane manufacture did not list the use of the installed electric boost pumps, nor did…NTSB NYC94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · White Plains, NYThe partial loss of engine power as the result of a disconnected throttle cable, and the subsequent forced landing and ditching in water to avoid collision with trees.NTSB NYC93LA176Accident · Minor injuriesLimited investigationFinal reportChampion Citabria 7-GCBC · Fire Island, NYFailure of the #4 cylinder valve stem.NTSB NYC91LA104Accident · Minor injuriesLimited investigationFinal reportPiper J-4A · Mahopac, NYThe erratic performance of the left magneto resulting in inadequate climb capabilities and in flight collision with terrain.NTSB NYC89LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawling, NYOff airport landing in unsuitalbe terrain following a power loss caused by loss of lubrication due to spalling on the camshaft and corresponding tappet body faces.NTSB NYC88LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · East Hampton, NYThe pilot reported that he had experienced a partial power loss on downwind of a VFR traffic pattern. He stated that just after entering downwind he lowered the landing gear. As the speed decreased below 132 knots he advanced the throttles. There was no…NTSB NYC88LA152Accident · No injuriesLimited investigationFinal reportBeech H18 · Utica, NYThe flight had departed syracuse airport enroute to plattsburg, new york transporting ups packages. At about 0810 hours, a loss of power on the left engine was experienced and altitude could not be maintained. The pilot informed griffiss control that he could…NTSB NYC88FA133Accident · 1 fatalField investigationFinal reportBell 206B · Long Island Cty, NYThe Bell 206B was on a sightseeing flight around the Island of manhattan when it experienced a low rotor RPM situation. The pilot said he could not recover rotor RPM and made a forced landing in the east river. The pilot and three passengers exited the…NTSB NYC88LA090Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Oswego, NYDuring a local pleasure flight, a decrease in engine power was experienced and a puff of smoke observed in the cockpit. The pilot applied full power in an attempt to return to the airport, but realized it was not possible. The pilot put the aircraft down in…NTSB NYC87LA175Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Croton Fall, NYAbt 15 minutes aft tkof, the eng started to lose pwr. All efforts to restart it were unsuccessful and the acft was forced to land in a landfill. During lndg roll the acft collided with a hole and the gear sheared off. Exam of the eng revealed a burned piece…NTSB NYC86IA231Incident · No injuriesIncident investigationFinal reportPiper PA-60-600 · Binghamton, NYThe plt stated that after leveling off at 9000 ft MSL. He heard a pop followed by an explosion in the left eng. The entire left side of the upper cowling was protruding into the airstream which caused the aircraft to roll to the right. The pilot had to use…NTSB NYC85LA211Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Del Mar, NYThe plt was reposition the acft at the request of the new owner who was not a rated plt. While climbing thru 2000 ft AGL the plt reported hearing the engine growl and felt a loss of power. During a precautionary descent the engine seized and the plt made a…NTSB NYC85LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cherry Valley, NYDurng a climb to cruise, theengine RPM dropped to 2000. The pilot check the carburetor heat and other instruments and did not find any abnormalities. The engine RPM dropped a second time to 1800 a sound described by the pilot as a loud band was heard and the…NTSB NYC85FHJ03Accident · Minor injuriesFinal reportPiper PA-28-161 · Lewisboro, NYThe acft nosed over on a golf course after striking trees during a forced lndg. The acft had lost power during climb to cruise. Post acc exam showed a failed exhaust valveNTSB NYC85LA055Accident · No injuriesLimited investigationFinal reportCessna 206G · Endicott, NYThe plt stated that the eng RPM dropped to idle when he made his second pwr reduction on downwind in preparation for landing. The throttle could not be pushed in when an attempt to add pwr was made. The acft touched down short of the rwy and came to rest aprx…NTSB NYC84LA116Accident · No injuriesLimited investigationFinal reportCessna 336 · Hogansburg, NYThe acft nosed down in a soggy muddy field during a forced landing. The plt reported a power loss on the rear eng and when attempts to restart were unsuccessful made the forced landing into a soggy muddy field.NTSB NYC84FHM02Accident · Minor injuriesFinal reportBeech A24R · Spring Valley, NYThe acft went off the end of the rwy during an aborted takeoff after the engine backfired and ran rough. The plt closed the throttle as he discontinued the takeoff. Before the acft could be stopped it went off the rwys end and down an embankment. Post…NTSB NYC82DA097Accident · No injuriesFinal reportBell 47G-2 · Brookville, NYWhile returning to the heliport, the pilot noticed a decay in the engine and rotor rpm's. he elected to make a precautionary landing in a plowed field. During landing, the manifold pressure went to the red line while the RPM decayed. The helicopter touched…NTSB NYC82FHJ05Accident · Minor injuriesFinal reportCessna 150 · Bayport, NYDuring takeoff, the engine began to lose power at about 50 ft AGL and then began to vibrate. The pilot checked that the fuel selector switch was on. He turned and attempted to return to the airport; however, he was unable to maintain altitude. Subsequently,…NTSB NYC82DA019Accident · No injuriesFinal reportCessna 152 · Cutchogue, NYAfter experiencing a partial loss of engine power in flight, the instructor took control of the aircraft. He applied carburetor heat, and headed back toward the airport. There was a gradual loss of power and the instructor elected to land in an open field.…