NTSB investigations, NY
22 cases where the defining event was Loss of engine power (partial).
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 5 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2026 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '342') 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 ERA26FA317Accident · 2 fatalClass 3 · FieldPreliminary reportConsolidated Aeronautics Lake LA-4-200 · Ithaca, NYOn August 30, 2026, about 1250 eastern daylight time, a Consolidated Aeronautics Inc., Lake LA-4-200, N6185V, was substantially damaged when it was involved in an accident near Ithaca, New York. The pilot and passenger were fatally injured. The airplane was…NTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…NTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.NTSB ERA23LA285Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA40 · Yorktown Heights, NYA fatigue failure of the turbocharger housing, which resulted in a partial loss of engine power.NTSB ERA22LA369Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jamestown, NYA partial loss of engine power for reasons that could not be definitively determined.NTSB ERA21LA199Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20C · Warwick, NYA loose stand-off clamp which resulted in a throttle assembly malfunction, and the inability of the engine to produce full power during the attempted takeoff.NTSB ERA19FA249Accident · 2 fatalClass 3 · FieldFinal reportCessna T303 · Lagrangeville, NYA partial loss of engine power in both engines during initial climb for reasons that could not be determined based on the available information.NTSB ERA19LA145Accident · Minor injuriesClass 3 · LimitedFinal reportBell 222 · Montgomery, NYA partial loss of engine power, as reported by the pilot, during takeoff for reasons that could not be determined based on available information.NTSB ERA18LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Babylon, NYThe partial loss of engine power after a simulated engine failure for reasons that could not be determined because a postaccident examination and an engine test run did not reveal any anomalies that would have precluded normal operation.NTSB ERA16LA065Accident · No injuriesClass 3 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Modena, NYA partial loss of engine power due to a stuck No. 1 cylinder exhaust valve.NTSB ERA14LA261Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Cooperstown, NYThe pilot’s delayed use of carburetor heat during the approach to landing, which resulted in the formation of carburetor ice, a partial loss of engine power, and the airplane’s subsequent inability to sustain flight.NTSB ERA13CA375Accident · Minor injuriesData collectionFinal reportMark C Pauls RV-7A · Cortland, NYA partial loss of engine power during go-around due to incorrect maintenance of the fuel system by the pilot/builder.NTSB ERA13LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Inlet, NYA loss of engine power for reasons that could not be determined during postaccident examination.NTSB ERA13LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Yonkers, NYA partial loss of engine power for reasons that could not be determined because examination of the engine and associated components did not reveal any mechanical malfunction or failure that would have precluded normal operation.NTSB ERA12FA514Accident · 2 fatalField investigationFinal reportSocata TB 10 · Shirley, NYThe pilot/owner's operation of the airplane with known deficiencies, and the mechanic's failure to reattach the mixture control cable to the mixture control arm following maintenance of the carburetor.NTSB ERA12LA428Accident · No injuriesLimited investigationFinal reportCessna R172K · Greene, NYAn undetected fatigue crack on the outer surface of the No. 3 cylinder barrel that could only have been detected visually and not by a differential compression test , resulting in separation of the head from the barrel and a subsequent partial loss of engine…NTSB ERA12LA365Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dansville, NYA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA349Accident · Minor injuriesLimited investigationFinal reportBelcher, Gerald C BEL Aire 2000 · Tyre, NYA partial loss of engine power for reasons that could not be determined during the postaccident investigation.NTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…NTSB ERA11FA349Accident · 4 fatalField investigationFinal reportCessna T210N · Armonk, NYThe pilot's decision to depart on the flight with a suspected mechanical deficiency and his subsequent decision to fly the final approach at a reduced power setting. Contributing to the accident was the improper timing of the magneto(s) that resulted in a…NTSB ERA10CA220Accident · Minor injuriesData collectionFinal reportCessna 150G · Cooperstown, NYA partial loss of engine power during a simulated engine-out demonstration due to carburetor icing.NTSB NYC08LA271Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Lockport, NYA partial loss of engine power, as reported by the pilot, for undetermined reasons. Contributing to the accident was the pilot's inadequate preflight planning and the overweight condition of the airplane.