NTSB investigations, NY

6 cases where the first occurrence was “Roll over”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations, NY per year, 1985–2026: 6 cases
1985	1
1996	1
1998	1
1999	1
2001	2

Where

Open the map

Latest cases

Query with SQL

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" = 380) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 380)
  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" = 380)
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 NYC01LA179Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Niagara Falls, NYThe right skid getting snagged on the helicopter-dolly resulting in dynamic rollover.Jul 19, 2001 · N577DB · Substantial damage NTSB NYC01LA087Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe certified flight instructor’s inadequate supervision and delayed remedial action, which resulted in a roll-over. Factors in this accident were the crosswind condition and soft landing area.Mar 10, 2001 · N9077F · Substantial damage NTSB IAD99LA058Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYwas the student pilot's improper control input and the flight instructor's delayed remedial action.Aug 15, 1999 · N4066G · Substantial damage NTSB IAD98LA057Accident · No injuriesLimited investigationFinal reportHughes 269A · Alexandria Bay, NYFailure of the pilot to maintain rotor rpm during practice autorotation, and the flight instructor's inadequate supervision.May 12, 1998 · N8045H · Substantial damage NTSB IAD97LA037Accident · No injuriesLimited investigationFinal reportRobinson R22 HP · Islip, NYThe students pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight.Dec 22, 1996 · N8414H · Substantial damage NTSB NYC85LA221Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ronkonkoma, NYDuring a local training flight the student was attempting a lift off and began to drift to the left. The students control input was to the left aggravating the situation. The instructor took control of the aircraft however the roll over had progressed to an…Aug 24, 1985 · N90773 · Substantial damage