NTSB investigations, NY
33 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1984 | 2 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 4 |
| 2005 | 2 |
| 2007 | 3 |
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\" = 430)
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" = 430) 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 NYC07LA202Accident · No injuriesLimited investigationFinal reportLearjet 60 · Westhampton, NYThe captain's failure to properly align the airplane prior to touchdown.NTSB ATL07CA101Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus-CS · Freehold, NYThe pilot's inadvertent activation of the tow release handle at a low altitude following an encounter with turbulence.NTSB NYC07LA121Accident · No injuriesLimited investigationFinal reportDouglas DC-9-31 · Syracuse, NYThe senior ground agent's failure to follow written procedures and directives.NTSB IAD05FA121Accident · 1 fatalField investigationFinal reportCessna 150M · Wht Sulfur Sprg, NYThe pilot's inadequate visual lookout during a precautionary landing, which resulted in collision with a wire and terrain. Factors in the accident were the pilot's inadequate in-flight planning which resulted in his becoming lost/disoriented, and a low fuel…NTSB NYC05LA110Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-22 · Haverstraw, NYThe pilot's physiological condition, which resulted in his incapacitation during the flight, and subsequent loss of aircraft control.NTSB NYC04LA042Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Jamaica, NYAn encounter with an unoccupied belt loader, after the belt loader driver inadvertently fell to the ground while maneuvering. Factors in this accident were the gusty wind conditions and the failure of the operator to require that persons operating belt…NTSB NYC04IA010Incident · No injuriesIncident investigationFinal reportBeech 1900D · Albany, NYThe maintenance technician's improper maintenance performed on the airplane, and his failure to perform a functional check, which resulted in a restricted movement of the elevator trim wheel. Factors were the captain's inadequate preflight inspection, and…NTSB NYC03FA186Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Jamaica, NYA fractured nose gear spray deflector due to contact with a tow bar during pushback, which subsequently jammed and prevented nose gear extension during landing. A factor in this accident was the tow operator's failure to detect the damaged spray deflector.NTSB NYC03LA133Accident · Serious injuriesLimited investigationFinal reportMBB BO-105C · Buffalo, NYThe pilot's improper interpretation of a descent as a power loss and subsequent decision to autorotate, which resulted in a hard landing. A factor in the accident was the collective friction.NTSB NYC03LA016Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Flushing, NYAn inadvertent trauma to the passenger's foot during an emergency evacuation.NTSB NYC01LA150Accident · Serious injuriesLimited investigationFinal reportRaven S60A · Mumford, NYThe ground handler's failure to follow instructions to release her line during the balloon's unintended ascent, due to panic.NTSB NYC99LA235Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · New York, NYInadequate counterbalancing to compensate for the weight of the cargo door.NTSB NYC99IA036Incident · No injuriesIncident investigationFinal reportBoeing 737 · New York, NYThe Cessna pilot's incorrect visual identification of the Boeing 737's altitude, and decision to take evasive action that was not required, which resulted in the two airplanes coming within 500 feet horizontally, and 0 feet vertically of one another.NTSB NYC98LA199Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly AX-9 · Brookhaven, NYThe failure of the passenger to comply with the pilot briefing, and properly brace herself for landing.NTSB NYC98LA130Accident · No injuriesLimited investigationFinal reportCessna 172R · Milford, NYThe pilot's decision to intentionally fly below wires, which resulted in the collision with trees. A factor in the accident was the soft grass airstrip.NTSB IAD97LA082Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Poughkeepsie, NYThe pilot's delayed decision to abort the landing.NTSB NYC97LA095Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe vehicle's driver failure to maintain adequate clearance from and resulted in a collision with a parked aircraft.NTSB NYC97LA064Accident · 1 fatalLimited investigationFinal reportLockheed L-1011 · Jamaica, NYThe failure of the right wing walker, also the push back supervisor, to identify and avoid a hazardous condition, which resulted in his activity near the airplane's nose wheel during tow operations, and where he was subsequently caught under the nose wheel. A…NTSB NYC95LA083Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-11 · Jamaica, NYexcessive flames/tailpipe fire from the number 2 engine for an unknown reason, which required an emergency evacuation.NTSB NYC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ellisburg, NYA fuel or fuel system problem that was probably related to the pilot/owner's failure to assure proper maintenance and/or inspection of the airplane before flight. A factor related to the accident was: soft terrain in the emergency landing area.NTSB NYC93LA174Accident · Serious injuriesLimited investigationFinal reportCameron HAB-N90 · Niagara Falls, NYThe inadequate bracing of the passenger for landing which resulted in a fall.NTSB DCA90MA019Accident · 73 fatalClass 1 · MajorFinal reportBoeing 707-321B · Cove Neck, NYThe failure of the flightcrew to adequately manage the airplane's fuel load, and their failure to communicate an emergency fuel situation to air traffic control before fuel exhaustion occurred. Contributing to the accident was the flightcrew's failure to use…NTSB NYC89LA156Accident · No injuriesLimited investigationFinal reportCessna 185 · Fishers, NYLoss of control during an aborted takeoff due to improper float operation aborted takeoff procedure on terra firma, as opposed to the more logical environment of water, the intended element for the design hardware.NTSB NYC88LA142Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Red Creek, NYWhile the pilot was waiting for liftoff, three ground crewmen were sitting on the basket holding the Balloon down. As the pilot prepared for liftoff, he announced that he was ready for liftoff and untied the rope. As the Balloon reached an altitude of about…NTSB ATL88IA117Incident · No injuriesIncident investigationFinal reportAero Commander 680E · New York, NYThe airplane had been given a daily insp on 03-10-88 with no structural damage noted. During the next daily inspection on 03-14-88, skin buckling was noted on both wings. Three different pilots had flown the airplane between inspections and all indicated that…NTSB NYC88LA020Accident · No injuriesLimited investigationFinal reportAgusta 109A · Spring Valley, NYThe helicopter had been refueled and the pilot was attempting to ground taxi. Prior to turning the aircraft around to taxi to a parking area the helicopter went into ground resonance as soon as the aircraft was moved. Collective was lowered, the engine…NTSB NYC88LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Croghan, NYThe pvt plt & one passenger became disoriented while they were on a x-country pleasure flt. The plt was unable to contact any communication center, so she landed in a field & obtained info to get her bearings. She took off again using short/soft field…NTSB NYC87LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Stanford, NYDuring enroute flight from rock island, providence to lincoln park, an engine power loss was experienced. In addition the pilot stated that he had become lost and disoriented due to darkness. When the aircraft started to descend, the pilot looked for a spot…NTSB NYC86LA086Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Tioga, NYThe pilot decided to make an off airport landing after becoming confused as to his exact location. During the landing a wind from the right caught the aircraft and it drifted left into trees. The pilot stated he had VFR sectional charts with him at the time…NTSB NYC86FA076Accident · Serious injuriesField investigationFinal reportLockheed L-1011-385-1 · Jamaica, NYThe no. 3 eng torched during a start attempt and resulted in a internal eng tailcone fire. Several paxs panicked upon seeing the torch flame/tailcone fire and between 30 to 50 paxs made an unauthorized evacuation of the acft via the L3 and L4 exits. Paxs…NTSB NYC85LA158Accident · No injuriesLimited investigationFinal reportCessna P210 · White Plains, NYA gear up landing was made following a loss of oil during takeoff. The acft was serviced with oil at skyport aviation prior to the attempted takeoff. The plt reported that after the oil was added he checked the oil level with the dip stick. Shortly after…NTSB NYC85FA047Accident · 1 fatalField investigationFinal reportCessna 402B · Rochester, NYPrior to tkf the plt was informed of wind shear as centerfield winds as 270 deg at 25 KTS gust to 46 KTS & nw boundary winds as 280 deg at 13 KTS. During tkf the plt reported an opened door & requested to return to land. The acft turned left and descended to…NTSB NYC84LA172Accident · Serious injuriesLimited investigationFinal reportCessna 305A · West Hampton, NYThe acft had just landed & the plt was taxiing to hook up to another glider when the acft became lodged n soft dirt. Two ground crewmembers came over to the acft. The plt stated that he told one of them to 'stay behind the strut while I shutdown'. He then…