NTSB investigations: Bell 206A, NY

13 cases on aircraft the registry lists as Bell 206A. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19692026
NTSB investigations: Bell 206A, NY per year, 1969–2026: 13 cases
19693
19702
19711
19722
19731
19742
19831
20001

Latest 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181508'))
  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.

NTSB IAD00LA015Accident · No injuriesLimited investigationFinal reportBell 206A · Brutus, NYWas the pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness.Jan 5, 2000 · N206GR · Substantial damageNTSB NYC83FA188Accident · 4 fatalField investigationFinal reportCessna U206G · Brooklyn, NYA Cessna U206G float plane, N5328X, & a bell 206A police helicopter, N4797R, collided in flt over Brooklyn, NY. The aircrew of the police helicopter were on a traffic observation flt & had just reported traffic conditions in the vicinity of a toll station…Jul 22, 1983 · N5328X · 2 aircraft · DestroyedNTSB NYC75AN047Accident · No injuriesClosedBell 206 · Garden City, NYOct 15, 1974 · N143Q · Substantial damageNTSB NYC74AN113Accident · No injuriesClosedBell 206A · Brooklyn, NYJun 21, 1974 · N4797R · Substantial damageNTSB NYC74AN009Accident · 1 fatalClosedBell 206A · New York, NYJul 28, 1973 · N4087G · DestroyedNTSB NYC73AN069Accident · No injuriesClosedBell 206 · Port Washngton, NYNov 20, 1972 · N7941S · Substantial damageNTSB NYC73FHJ03Accident · No injuriesClosedBell 206A · Flushing, NYJul 14, 1972 · N4042G · Substantial damageNTSB NYC71DHM33Accident · No injuriesClosedBell 206A · Montgomery, NYJun 17, 1971 · N100FW · Substantial damageNTSB NYC71DHJ05Accident · Minor injuriesClosedBell 206A · Southampton, NYAug 25, 1970 · N11DL · Substantial damageNTSB NYC70AN094Accident · 2 fatalClosedBell 206A · Floral Park, NYMar 1, 1970 · N7867S · DestroyedNTSB NYC70D0121Accident · No injuriesClosedBell 206A · Banksville, NYAug 1, 1969 · N1431W · Substantial damageNTSB NYC70I0011Incident · No injuriesClosedBell 206A · New York, NYJul 24, 1969 · N4026G · No damageNTSB NYC70F0074Accident · No injuriesClosedBell 206A · Spring Valley, NYJul 20, 1969 · N4781R · Destroyed