NTSB investigations, NY
112 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 6 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 11 |
| 1987 | 10 |
| 1988 | 5 |
| 1989 | 5 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 3 |
| 1998 | 7 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 5 |
| 2006 | 2 |
| 2007 | 5 |
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\" = 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" = '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" = 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 ANC08LA010Accident · No injuriesLimited investigationFinal reportPiper 601P · Penn Yan, NYThe loss of engine power during cruise flight for an undetermined reason.NTSB NYC07LA207Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Goshen, NYA loss of engine power during cruise flight for undetermined reasons.NTSB ATL07LA112Accident · Serious injuriesLimited investigationFinal reportFalcon Safety Craft Falcon XP · Montgomery, NYA total loss of engine power during initial climb for undetermined reasons.NTSB DEN07LA130Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cooperstown, NYThe loss of engine power due to carburetor icing. Contributing factors were the lack of suitable terrain for a forced landing and the weather conditions conducive for carburetor icing.NTSB NYC07LA094Accident · 2 fatalLimited investigationFinal reportRomeo Lancair Legacy RG · Fulton, NYA loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB NYC06CA164Accident · Serious injuriesData collectionFinal reportBaker, Timithy Falco F8L · Montgomery, NYThe pilot's inadequate pre-flight inspection, which resulted in a loss of engine power due to fuel contamination.NTSB NYC06LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Yonkers, NYA loss of engine power for undetermined reasons, which resulted in a ditching.NTSB IAD05LA139Accident · No injuriesLimited investigationFinal reportHart None · Broadalbin, NYA loss of engine power for undetermined reasons.NTSB NYC05LA133Accident · Serious injuriesLimited investigationFinal reportPalen Nieuport 11 · Rhinebeck, NYA loss of engine power for undetermined reasons.NTSB NYC05LA129Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Penn Yan, NYThe loss of engine power due to a fatigue fractured pushrod.NTSB IAD05LA070Accident · Minor injuriesLimited investigationFinal reportSnyder Sky Scout · Round Lake, NYA loss of engine power for undetermined reasons. A factor was the soft field.NTSB NYC05FA048Accident · 1 fatalField investigationFinal reportBeech V35B · Norwich, NYA loss of engine power for undetermined reasons.NTSB NYC04LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, NYThe pilot's inadequate pre-flight inspection, which resulted in his failure to remove the engine inlet covers and subsequent loss of engine power.NTSB NYC04LA041Accident · Minor injuriesLimited investigationFinal reportRussell Cozy MK III · Holbrook, NYThe pilot's improper fuel management, which resulted in fuel starvation and subsequent loss of engine power.NTSB IAD03LA066Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Hampton Bays, NYA loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC03FA020Accident · 1 fatalField investigationFinal reportCessna 210L · Rochester, NYA loss of engine power for undetermined reasons. A factor in this accident was the night light condition which precluded the pilot's ability to adequately view suitable forced landing areas.NTSB NYC02LA130Accident · Serious injuriesLimited investigationFinal reportWheeler Volksplane VP-2 · Collins, NYThe separation of an ignition lead to the distributor cap, which resulted in a total loss of engine power. Factors in the accident were trees and power lines.NTSB IAD02LA049Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Westhampton Bch, NYLoss of engine power for undetermined reasons.NTSB NYC02LA078Accident · No injuriesLimited investigationFinal reportCessna 150M · Salisbury Ctr, NYThe pilot's delayed decision to ask for help which led to a power loss due to fuel starvation.NTSB IAD01LA048Accident · No injuriesLimited investigationFinal reportCessna 208B · Plattsburgh, NYThe incorrect installation of the propeller reversing lever and carbon block assembly, which resulted in a loss of propeller thrust.NTSB NYC00LA091Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Pawling, NYLoss of engine power for undetermined reasons.NTSB NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…NTSB NYC99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Duanesburg, NYThe instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…NTSB NYC98LA159Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1A · Point Of Woods, NYImproper maintenance which resulted in the installation of an incorrect venturi and the subsequent loss of engine power.NTSB NYC98LA140Accident · Serious injuriesLimited investigationFinal reportFithian Falcon XP · Mahopac, NYThe failure of the engine crankshaft, which resulted in a loss of engine power, and the pilot's improper decision to conduct flight over terrain unsuitable for the completion of a forced landing.NTSB NYC98LA125Accident · Serious injuriesLimited investigationFinal reportBeech BE 65-80 · Malone, NYThe pilot's failure to follow emergency procedures, and his failure to maintain control of the airplane after a loss of power from one engine. Factors include fuel filter blockage, inadequate maintenance, and the pilot's lack of experience in multi-engine…NTSB NYC98FA107Accident · 2 fatalField investigationFinal reportErcoupe ERCO-415C · New Lisbon, NYDetonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…NTSB NYC98LA108Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Farmingdale, NYThe engine's inability to provide full power, and the pilot's failure to use performance data. Factors in the accident were conditions conductive for carburetor icing at reduced power, and the unsuitable terrain during the forced landing.NTSB NYC98LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · Lockport, NYThe pilot's misjudgment of altitude and distance during a forced landing in the traffic pattern. A factor in the accident was the carburetor icing conditions.NTSB IAD98LA028Accident · No injuriesLimited investigationFinal reportBeech 55B · Buffalo, NYImproper use of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB IAD97LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Claverack, NYloss of engine power for undetermined reasons.NTSB NYC96LA186Accident · No injuriesLimited investigationFinal reportMooney M20K · Islip, NYloss of engine power for undetermined reason(s), which resulted in an emergency/wheels-up landing.NTSB NYC96LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmingdale, NYloss of engine power for undetermined reasons.NTSB NYC95LA205Accident · No injuriesLimited investigationFinal reportCessna 172M · Williamson, NYthe loss of engine power and the eruption of a fire for undetermined reasons.NTSB NYC95LA191Accident · No injuriesLimited investigationFinal reportBeech 23 · Spafford, NYthe loss of engine power for undetermined reasons resulting in a forced landing over unsuitable terrain and the subsequent collision with trees.NTSB NYC95FA167Accident · 1 fatalField investigationFinal reportDouglas DC-3 · Independence, NYThe loss of engine power for undetermined reasons, and the pilot's shutdown of the wrong engine, which resulted in a forced landing and collision with trees.NTSB NYC95LA140Accident · No injuriesLimited investigationFinal reportNicolas Beasely NB-8 · Bayport, NYThe loss of power for undetermined reasons.NTSB BFO95LA073Accident · Minor injuriesLimited investigationFinal reportKemp ACRO-SPORT II · Honeoye Falls, NYthe pilot's inadequate preflight planning/preparation and his misjudging of the touchdown during the forced landing. Related factors are the pilot's improper maintenance, and fuel contamination.NTSB BFO95LA052Accident · Serious injuriesLimited investigationFinal reportCurtiss-Wright P-40E · Phelps, NYLoss of engine power for undetermined reasons. A factor related to the accident was the lack of suitable terrain for the forced landing.NTSB NYC95LA008Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Amityville, NYThe loss of engine power for undetermined reasons. Also causal was the inspector's improper inflight decision to simulate an emergency beyong the gliding distance to a suitable landing area.NTSB BFO94LA048Accident · No injuriesLimited investigationFinal reportJenks Skybolt · Brockport, NYA loss of engine power due to undetermined reason (s). A factor in this accident was the snow covered, rough/uneven terrain which caused the airplane to nose over during landing roll.NTSB BFO94LA011Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Elmira, NYA loss of engine power at a critical point on a practice autorotation, and failure of the pilot to attain a flare for the landing. Factors related to the accident were: the adverse wind and downdraft.NTSB NYC93LA170Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Skaneateles, NYThe improper installation of the engine oil filter, and the subsequent loss of oil and engine power, resulting in forced landing and collsion with trees.NTSB NYC93LA077Accident · No injuriesLimited investigationFinal reportFawcett Titan Tornado · East Moriches, NYThe loss of engine power for undetermined reasons.NTSB BFO93LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Poestenkill, NYThe total loss of engine power due to undetermined reasons.NTSB BFO93LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Red Hook, NYThe pilot's inadvertent deactivation of the electric fuel boost pump. A factor related to the accident was the failure of the engine driven fuel pump during takeoff.NTSB BFO92LA085Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Watkins Glen, NYFuel starvation as a result of improper rigging of the fuel control unit.NTSB NYC92LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · New York, NYA power loss of undetermined origin over unsuitable terrain.NTSB BFO92LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · West Hempstead, NYLoss of engine power for an unknown reason. The lack of suitable terrain for an emergency landing was a related factor.NTSB NYC91IA133Incident · No injuriesIncident investigationFinal reportBoeing 747SP · Churchville, NYA failure of the sixth rotating airseal which led to an uncontained engine failure.