NTSB investigations, NY
11 cases where the first occurrence was “On ground/water encounter with weather”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 3 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2007 | 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\" = 330)
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" = 330) 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 DCA08IA019Incident · No injuriesIncident investigationFinal reportEmbraer 145 · Jamaica, NYthe failure of the elevator control rods due to exposure to high winds while the aircraft was parked overnight. Contributing to this incident was the failure of the existing airworthiness directive to adequately detect this discrepancy given the known…NTSB NYC03LA033Accident · No injuriesLimited investigationFinal reportMBB BK 117 A-4 · Albany, NYThe inadvertent encounter with a downdraft during engine start, which flexed the main rotor blades and subsequently damaged the tail boom assembly. A factor related to the accident was the failure of the operator to comply with a service bulletin.NTSB NYC95LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Niagra Falls, NYThe pilot's inadequate weather evaluation and the on ground encounter with gusty winds.NTSB NYC91LA082Accident · Minor injuriesLimited investigationFinal reportLatham Pitts Special S-1C · Glens Falls, NYA loss of control on the ground due to the improper operation of flight controls by the pilot. A factor related to the accident was the variable wind.NTSB NYC90LA217Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Red Hook, NYThe pilot's loss of directional control and departure off the side of the runway during the landing roll, resulting in a collision with a tree. Contributing to the accident was the pilot's lack of expereince in the aircraft.NTSB NYC90LA012Accident · No injuriesLimited investigationFinal reportCessna 180H · Niagara Falls, NYThe pilot's loss of directional control during takeoff roll due to strong wind gusts.NTSB NYC87LA047Accident · No injuriesLimited investigationFinal reportPiper J-3 · East Moriches, NYDuring the takeoff roll on an instructional solo flight, the flight encountered a crosswind which pushed the Piper off the runway to the left colliding with trees and bush.NTSB NYC85LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Batavia, NYThe commercial rated-flight instructor took off genesee co. airport and flew a normal pattern for landing. Some gustiness was noted by the pilot by observing the wind sock. During landing roll out, a slight swerve to the south, aircraft landing to the west,…NTSB NYC85LA115Accident · Serious injuriesLimited investigationFinal reportCessna C172 · Poestenkill, NYCessna 172TD encountered strong gusty crosswind while taking from rensselaer airpark and directional control was lost. The aircraft verred off the left side off the run-way and collid with the terrain. Full right rudder was applied to correct the deviation.…NTSB NYC85FA097Accident · 2 fatalField investigationFinal reportCessna 421B · Johnson City, NYAfter a heavy snow shower passed over the airport, the accident acft attempted a departure. Immediately after takeoff the plt transmitted that he was coming back to land. The acft crashed shortly thereafter, 1 mile southwest of the airport. Ground witnesses…NTSB NYC84LA166Accident · No injuriesLimited investigationFinal reportCessna C188 · Seneca Falls, NYPilot attempted to compensate for gusty wnd cond by lnding the acft tail high. The acft began to wx vane and in an effort to correct, the plt used excessive rt brake. The braking action combined with the gusty wnd exceeded the elevator authority and the acft…