NTSB investigations, NY
82 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 7 |
| 1992 | 3 |
| 1993 | 4 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 2 |
| 2006 | 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\" = 130)
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" = 130) 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 NYC06LA121Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350BA · Goshen, NYImproper maintenance of the hydraulic pump/coupling, which resulted in a failure of the hydraulic flight control system. Factors included the substandard materials of the hydraulic pump drive shaft and coupling, and the pilot's failure to maintain an adequate…NTSB NYC04FA197Accident · 2 fatalField investigationFinal reportRobinson R-22 · Northport, NYAn improper maneuver by the flightcrew while attempting to avoid a kite, which resulted in mast bumping, the separation of the main rotor system, and a subsequent uncontrolled descent into water.NTSB NYC04FA117Accident · Serious injuriesField investigationFinal reportEurocopter AS-350BA · Brooklyn, NYThe pilot's failure to maintain control of the helicopter after a loss of hydraulic system pressure due to a failure of the hydraulic pump belt. Factors in this accident were the pilot's misidentification of a hydraulic failure, the pilot's subsequent failure…NTSB NYC03FA067Accident · Serious injuriesField investigationFinal reportBoeing 717-200 · Flushing, NYA failure of the left power control distribution unit (PCDU).NTSB NYC03IA042Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11-C · Jamaica, NYA leak of potable water onto the lateral (aileron) flight control cables, and flap extension cables, which subsequently froze them in place. An additional cause was the improper procedures used by mechanics for floorboard removal which stretched the rubber…NTSB IAD02IA076Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · New York, NYThe partial loss of flight display information for undetermined reasons.NTSB NYC02IA100Incident · No injuriesIncident investigationFinal reportDornier 328-300 · Albany, NYRudder oscillations of an undetermined origin.NTSB NYC01LA167Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Clay, NYFailure of the left aft cluster fitting due to a fatigue crack. Factors in the accident were the mechanic's failure to identify the crack at the last annual inspection, and the pilot's failure to identify the crack during the last daily inspectionNTSB NYC01LA088Accident · Serious injuriesLimited investigationFinal reportBell 206 L-1 · Seneca Falls, NYthe loss of a bolt in a Thomas coupling on the tail rotor drive shaft, for undetermined reasons, during climb, while operating over unsuitable terrain.NTSB NYC00LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Westhampton, NYThe pilot's inadequate flare during the landing. Factors were the entanglement of the tow rope with the rudder horn, and restricted rudder movement.NTSB NYC00IA124Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · White Plains, NYThe pilots of the CRJ were conducting a visual approach at night. As the wing flaps were extended from 30 degrees, to 45 degrees, there was an uncommanded extension of the right wing flight spoiler. A roll to the right accompanied the extension, which was…NTSB NYC00LA206Accident · Serious injuriesLimited investigationFinal reportBeechcraft 1900D · Plattsburgh, NYThe failure of the upper anchor bracket for the airstair door.NTSB NYC00IA036Incident · No injuriesIncident investigationFinal reportBoeing 767-200 · Jamaica, NYTotal failure of the stabilizer control system for undetermined reasons.NTSB NYC00LA021Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Westbury, NYthe failure of the operator to ensure the pilot was adequately trained to conduct all inspections required by the flight manual, which resulted in the pilot's inadequate preflight and subsequent failure of the tail rotor pitch change rod. Factors were the…NTSB NYC98LA198Accident · No injuriesLimited investigationFinal reportCessna CE-500 · Fishers Island, NYAn intermittent short in the right wheel anti-skid system which caused a loss of braking and subsequent overrun.NTSB NYC97LA101Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Granby, NYfailure of the pilot/owner to replace the torsional clutch as specified by the manufacturer, and subsequent failure of the helicopter's clutch, which resulted in a forced landing (autorotation). A related factor was: the encounter with trees in the emergency…NTSB NYC97FA076Accident · 1 fatalField investigationFinal reportEurocopter MBB-BK117-B2 · New York, NYFatigue failure of the vertical fin, accelerated by the installation of blind rivets in lieu of solid rivets in the replacement of the yaw SAS mount support, which resulted in the loss of helicopter directional control and collision with the terrain (water).…NTSB NYC96IA169Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Howard Beach, NYfatigue failure of the fore flap attachment fitting, due to grinding marks on the fitting.NTSB NYC96IA131Incident · No injuriesIncident investigationFinal reportBoeing 767-332ER · Jamaica, NYthe improper installation of the generator feed cable by the manufacturer, which resulted in a severed aileron cable due to arcing between the generator feed cable and aileron cable.NTSB IAD96IA098Incident · No injuriesIncident investigationFinal reportBoeing 747-136 · Jamaica, NYfailure of the constant speed drive (CSD) to disconnect from the generator. Contributing to the cause was the failure of the FAA approved overhaul facility to follow the manufacturer's overhaul manual.NTSB IAD96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-600 · Syracuse, NYthe pilot's failure to ensure that his hand would remain clear of the propeller, while attempting to take remedial action to secure the clam shell door. The unlatching and separation of the clam shell door from the aircraft were related factors.NTSB NYC96LA063Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300B4-605R · Jamaica, NYunsuccessful use of the evacuation slides by passengers during an emergency evacuation of the aircraft. The hydraulic valve failure, subsequent hydraulic leak, and resultant smoke were related factors.NTSB NYC95LA231Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Staten Island, NYFailure of the propeller blade due to fatigue, which resulted in severe vibration, subsequent separation of the engine, and a forced landing.NTSB NYC95LA226Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Auburn, NYthe loss of airplane control as a result of a jammed rudder for undetermined reasons.NTSB BFO95FA082Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · East Moriches, NYthe structural failure of the wing for undetermined reasons.NTSB NYC95LA142Accident · No injuriesLimited investigationFinal reportBell 206-BIII · New York, NYThe pilot' inadequate preflight inspection. A factor was the pilot's diverted attention.NTSB NYC95LA059Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Millbrook, NYThe pilot's failure to manually extend the landing gear which resulted in the landing gear collapsing. A factor was the intermittent loss of electrical power.NTSB NYC95LA017Accident · Minor injuriesLimited investigationFinal reportPitts S-1C · Galeville, NYInadequate maintenance inspection which resulted in disengagement of the rudder clevis bolt and the inflight loss of control during aerobatic manuevers.NTSB NYC95IA020Incident · No injuriesIncident investigationFinal reportCessna 310R · Rochester, NYInadequate maintenance which resulted in undertorqued bolts, fatigue cracking of the hub, and the separation of the propeller assembly from the engine.NTSB BFO94LA098Accident · Minor injuriesLimited investigationFinal reportBellah Rotorway Executive · Johnson City, NYThe failure of the tail rotor drive belt due to undetermined reasons. This led to a loss of directional control and an autorotation.NTSB BFO93IA175Incident · No injuriesIncident investigationFinal reportBoeing 757-200ER · Jamaica, NYThe failure of the left hydraulic pressure switch, which caused the left yaw damper module to become inoperative resulting in uncommanded rudder movements during flight.NTSB NYC93IA184Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · New York, NYThe improper installation of the fairing by company maintenance personnel, resulting in the infligh separation of the fairing in flight.NTSB BFO93FA107Accident · Serious injuriesField investigationFinal reportUS/Lta 138S Airship · New York, NYInadequate design of, and design standards for, the airship which resulted in an envelope failure following separation of a portion of the night sign equipment.NTSB BFO93IA057Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE3201 · Rochester, NYFailure of the main cabin door to be adequately secured for flight for an unknown REAS0N.NTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.NTSB NYC92FA161Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Bradford, NYA mechanical malfunction of the artificial horizon in IMC that resulted in spatial disorientation of the pilot and his inability to maintain airplane orientation. A factor in the accident was the improper maintenance of the artificial horizon.NTSB DCA92MA044Accident · Serious injuriesClass 1 · MajorFinal reportLockheed L-1011-385-1 · Jamaica, NYDesign deficiencies in the stall warning system that permitted a defect to go undetected, the failure of twa's maintenance program to correct a repetitive malfunction of the stall warning system, and inadequate crew coordination between the captain and first…NTSB NYC92IA035Incident · No injuriesIncident investigationFinal reportSaab-Fairchild SF-340A · Buffalo, NYA fatigue fracture on the propeller shaft, that originated at a subsurface slag inclusion, which remained in the material used to manufacture the shaft.NTSB NYC92LA011Accident · No injuriesLimited investigationFinal reportAerospatiale ND-26 · Albany, NYInadequate quality control during maintenance or manufacturing by failing to use corrosion inhibiter, which resulted in corrosion, fatigue, and subsequent failure.NTSB NYC91LA250Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Utica, NYFatigue cracking of the propeller hub.NTSB NYC91IA165Incident · No injuriesIncident investigationFinal reportBoeing 727-254 · Buffalo, NYChaffing fire detector loop on the number one engine.NTSB NYC91LA134Accident · Minor injuriesLimited investigationFinal reportTierra II · Cooperstown, NYThe mechanical failure of the flight control system, which resulted in a a loss or airplane control and subsequent forced landing in trees.NTSB NYC91LA102Accident · 1 fatalLimited investigationFinal reportSchweizer SGS-1-30 · Wurtsboro, NYAn inflight failure of the left wing spar due to overload from pilot induced control inputs, while recovering from a dive. Factors related to the accident were, the pilot's decision to fly with the trim system disconnected and lack of recent experience in…NTSB NYC91DFA02Accident · 1 fatalFinal reportHayes Kolb/Twinstar · Round Lake, NYIn-flight structural failure of the outboard wing attachment fittings on both wings due to an undetermined reason.NTSB NYC90LA116Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Athens, NYInflight loss of control due to loss of airspeed and subsequent stall when the pilot's seat back failed and the pilot hung onto the control wheel, resulting in an excessive nose high attitude.NTSB NYC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lyons, NYA worn out brake on the left main gear. Factors related to the accident were: the owner's decision not to repair the left brake after the right brake had a similar failure 4 hours earlier.NTSB NYC90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Messena, NYThe airplane striking a light pole during an off airport landing on a road, due to a double power loss for unknown reasons. Factors related to the accident were: the pilots unfamiliarity with the airplane.NTSB NYC89LA113Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Utica, NYA fire in the cockpit from an unknown source.NTSB NYC88DHM02Accident · Serious injuriesFinal reportAir Command 532 · Stormville, NYThe acdnt occurred as the non-certificated plt was operating the non-registered gyroplane in the traffic pattern. Witnesses heard a 'loud crack.' They then observed the gyroplane descending in an apparent unusual attitude. The gyroplane collided with trees,…NTSB NYC88IA186Incident · No injuriesIncident investigationFinal reportMBB BK-117 · Manhattan, NYFailure of the main rotor blade appears to be the result of a static downward bending overstress, caused by another helicopter hovering over or very close to the main rotor blade as it was in a static/stopped position.