NTSB investigations, NY
86 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 10 |
| 1984 | 6 |
| 1985 | 13 |
| 1986 | 6 |
| 1987 | 1 |
| 1988 | 5 |
| 1989 | 6 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 4 |
| 1997 | 3 |
| 1998 | 2 |
| 2000 | 2 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 4 |
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\" = 240)
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" = 240) 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 NYC05CA037Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Johnstown, NYThe pilot's inadequate in-flight planning/decision which resulted in airframe ice with subsequent degradation of aircraft performance, and inadequate airspeed during the landing flare.NTSB NYC05FA001Accident · 2 fatalField investigationFinal reportCessna 172N · Germantown, NYThe pilot's inadequate in-flight planning/decision which led to VFR flight into IMC and his loss of aircraft control. Factors were night and cloud conditions.NTSB IAD04LA050Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-135KL · Clyde, NYAn unexpected encounter with clear air turbulence.NTSB NYC04FA144Accident · 1 fatalField investigationFinal reportCessna P210N · Dunkirk, NYThe pilot's loss of aircraft control and the subsequent overstress and separation of the wing during an encounter with convection induced turbulence.NTSB NYC03CA179Accident · No injuriesData collectionFinal reportCessna 172RG · Glens Falls, NYThe pilot's failure to maintain control during the flare/touchdown, which resulted in a hard landing. Factors in this accident were wind gusts and the pilot's improper decision to land during thunderstorm activity.NTSB NYC03FA024Accident · 1 fatalField investigationFinal reportSocata TB-20 · Massena, NYThe pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot.NTSB NYC02LA103Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Roxbury, NYThe airplane encountering an unanticipated downdraft that exceeded the climb performance of the airplane.NTSB NYC02LA092Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Saratoga Spring, NYThe glider encountering an unanticipated downdraft, which resulted in insufficient altitude to reach a suitable landing area.NTSB NYC02IA076Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Jefferson, NYAn in-flight encounter with lightning, which severed two of the four elevator cables.NTSB NYC00LA251Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Wurtsboro, NYThe pilot's improper weather evaluation and decision to initiate a flight with an approaching rain shower. A factor in this accident was heavy rain, which reduced visibility.NTSB IAD00LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Halfmoon, NYThe pilot's inadequate preflight planning, and his continued flight into, and attempted landing during a thunderstorm. A factor was the thunderstorm.NTSB NYC98LA193Accident · Serious injuriesLimited investigationFinal reportBoeing DHC-8-102 · Islip, NYClear air turbulence.NTSB IAD98FA106Accident · 5 fatalField investigationFinal reportPiper PA-46-350P · Centerville, NYThe pilot's inadvertent flight into adverse weather conditions. Factors related to the accident were the pilot's failure to use weather detection equipment and use of airspeeds in excess of limitations.NTSB NYC97LA187Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 · Long Island, NYAn in-flight encounter with clear air turbulence and the passenger's failure to comply with the fasten seatbelt sign.NTSB NYC97FA139Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Jones Beach, NYVFR flight by the pilot into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain (water). Related factors were: the adverse weather…NTSB NYC97FA092Accident · 1 fatalField investigationFinal reportCessna T337G · North Dansville, NYthe pilot's improper decision to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance from rising/wooded terrain. The adverse weather conditions and rising wooded terrain were related factors.NTSB NYC96LA011Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102CS · Lake Placid, NYthe pilot's inadequate evaluation of the weather. Contributing factors were the high winds and downdrafts.NTSB NYC96FA004Accident · 1 fatalField investigationFinal reportCessna P206A · Fishkill, NYThe pilot's VFR flight into instrument meteorological conditions. Contributing factors were the fog and dusk light conditions.NTSB NYC95LA182Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Owego, NYThe pilot's inadequate evaluation of weather conditions which resulted in an encounter with a downdraft, inflight loss of control, and a collision with a vehicle.NTSB NYC95FA080Accident · 1 fatalField investigationFinal reportCessna 172P · Naples, NYThe pilot's continued VFR flight into instrument meteorological conditions. Factors contributing to the accident were: the night conditions, fog, low ceiling, and hilly terrain.NTSB NYC95LA047Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Lancaster, NYThe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel to return to the home airport after proceeding to an alternate airport and making a missed approach. Factors related to the accident were:…NTSB NYC94LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Crown Point, NYThe pilot's failure to maintain adequate terrain clearance. Other related factors are cloud conditions and the pilot's failure to maintain flight in visual meteorological conditions.NTSB NYC94LA111Accident · Serious injuriesLimited investigationFinal reportBoeing 767-200 · East Hampton, NYIn-flight encounter with turbulence in the vicinity of thunderstorms. A factor related to the accident was: improper planning/decision by the pilot(s).NTSB NYC94FA052Accident · 2 fatalField investigationFinal reportCessna 340 · Westhampton, NYThe pilot's inadequate inflight decision which resulted in ice accretion on the aircraft, degradation of aircraft performance, an aerodynamic stall, loss of control and inflight collision with the ground. Factors were icing conditions.NTSB NYC93FA080Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Lapeer, NYThe pilot's improper inflight decision to continue flight into known icing conditions. Factors which contributed to the accident were: the pilot's failure to obtain updated weather information prior to departure, the icing conditions, and the degraded…NTSB NYC92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Danville, NYThe decision by the pilot to land during a heavy rain shower, which resulted in a long landing, and his attempted takeoff with insufficient available runway and subsequent loss of airplane control.NTSB NYC92LA041Accident · No injuriesLimited investigationFinal reportCessna 150 · Gansevoort, NYThe pilot's improperly planned approach, resulting in a landing on an icy runway at excessive speed; and unable to stop on the available runway and subsequent collision with trees. Factors related to the accident were the pilot's failure to obtain a weather…NTSB NYC91FA099Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Naples, NYFlight by the pilot into known icing conditions, which resulted in structural (wing) ice and subsequent loss of aircraft control. The weather condition was a related factor.NTSB NYC91LA077Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Wallkill, NYDecision by the non-instrument rated pilot to attempt flight into instrument meteorological conditions, resulting in airframe icing, loss of control and collision with trees. A factor related to the accident was the failure of the pilot to receive a…NTSB NYC91FA073Accident · 2 fatalField investigationFinal reportBeech BE-58 · Skaneateles, NYThe pilot's loss of situational awareness/disorientation due to the influences of cocaine, which resulted in the loss of airplane control in instrument meteorological conditions. Factors related to the accident were: psychological impairment, fatigue and…NTSB NYC91FA042Accident · 2 fatalField investigationFinal reportBeech A24R · Owls Head, NYThe pilot's continued VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: darkness, adverse weather conditions, and mountainous terrain.NTSB NYC90FA223Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Livingston, NYThe pilot failed to maintain control of the aircraft while maneuvering for an ILS approach. Factors related to the accident were the pilot's lack of recent instrument flight experience, low cloud ceilings and fog, and failure to follow IFR procedures.NTSB NYC90LA057Accident · Serious injuriesLimited investigationFinal reportCameron AX-8 · Schodack, NYThe inflight encounter with unforecast high winds.NTSB NYC90FA129Accident · 2 fatalField investigationFinal reportCessna 337G · Harrison, NYThe pilot's decision to continue VFR flight into IMC and his subsequent loss of control of the airplane. The weather conditions and the pilot's lack of instrument flight experience were factors in the accident.NTSB NYC90FA083Accident · 1 fatalField investigationFinal reportCessna 150F · Lloyd, NYPilot factor in that he was attempting VFR flight in inc conditions and collided with a multipurpose communications tower.NTSB NYC90FA030Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · New Castle, NYThe pilot failed to maintain proper altitude and alignment with the ILS during the ILS approach and failed to perform the missed approach.NTSB NYC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Palmyra, NYThe pilot failed to maintain airspeed during a tight closed pattern turn to final. Contributing factor(s) was: the pilot initiating flight into known adverse weather conditions, which included fog and reduced visibility.NTSB NYC89FA204Accident · 1 fatalField investigationFinal reportCessna U206F · West Point, NYContinued VFR flight by the pilot into an area of marginal visual meteorological conditions, and his failure to maintain sufficient altitude over mountainous/hilly terrain. Factors related to the accident were: dark night, high terrain, low clouds/ceiling,…NTSB NYC89IA107Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Albany, NYThe crew's failure to use full engine anti-ice systems which resulted in ice blocking the engine inlets.NTSB NYC89FA097Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Lake Placid, NYThe pilot's departure into known adverse weather conditions and his continued VFR flight into instrument meteorological conditions. Contributing factor(s) was: the adverse weather conditions.NTSB NYC89FA080Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Lyon Mountain, NYThe pilot decided to fly in weather conditions that were beyond his and the aircraft's capabilities.NTSB NYC89LA027Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Montauk, NYLoss of control, inflight, while landing, due to low level wind shear.NTSB NYC88FA196Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pocantico Hills, NYThe non-instrument rated private pilot departed in instrument flight conditions against the advice of several people he talked to. Approximately 1 hour and 30 minutes after departure the first of four or five mayday calls were heard by bridgeport radio and an…NTSB NYC88LA188Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions AX-7 · Wellsville, NYAbout 35 hot air balloons were entered in the great Wellsville balloon rally. At 0625 EDT, the plt (of c-gdgk) attended a wx briefing that was given to the plts by the balloonmeister. The plt said the balloonmeister indicated that there would be suitable…NTSB NYC88LA178Accident · No injuriesLimited investigationFinal reportChampion 7GBC · Staten Island, NYThe pilot stated that after flying into a thunderstorm he encountered strong turbulence, heavy downdrafts and rain, which forced him into the water. When he realized that he was going down he dropped the banner he was towing 'but the airplane didn't want to…NTSB NYC88LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Jamestown, NYThe Piper PA-28-181 departed with two pilots onboard. About one hour after takeoff, the PIC got very sick and could not continue flying. She experienced a severe headache and vomitting. The non-instrument rated pilot continued the flight. The aircraft made…NTSB NYC88FA045Accident · 4 fatalField investigationFinal reportCessna T210N · Skaneateles, NYPrior to departure from holland, mi the pilot received a briefing which included flight precautions for IFR conditions over his entire route of flight and occasional light to moderate rime and/or mixed icing in clouds below 18,000 feet. The pilot elected to…NTSB NYC87FA021Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Jamestown, NYThe non-inst rated plt had received a telephone wx briefing prior to the planned flt. Marginal VFR wx was forecast for the route with vis 1/8 mile and fog. The acft was located aprx 24 hrs later in a heavily wooded area about 200 yds east of and parallel to…NTSB NYC87FA011Accident · 1 fatalField investigationFinal reportCessna 172 · Croton On Hud., NYStudent pilot advised by millville fss that VFR flight not recommended due to current and forecast IFR conditions throughout route of flight. Acft observed flying near base of low clouds and in and out of clouds prior to crashing in a residential area.NTSB NYC86FA237Accident · 2 fatalField investigationFinal reportCessna 337D · Lapeer, NYThe acft collided with the terrain during the plts attempt to complete a night x-country in IMC wx conditions. The flt had progressed aprx 4 hrs & 34 min from SC to NY prior to the crash. The plt was not currently rated to fly IFR. The plt reported by radio…