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
| 1969 | 3 |
|---|---|
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1983 | 1 |
| 2000 | 1 |
Where
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.
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" DESCRun 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 IAD00LA015Accident · No injuriesLimited investigationFinal reportBell 206A · Brutus, NYWas the pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness.NTSB 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…NTSB NYC75AN047Accident · No injuriesClosedBell 206 · Garden City, NYNTSB NYC74AN113Accident · No injuriesClosedBell 206A · Brooklyn, NYNTSB NYC74AN009Accident · 1 fatalClosedBell 206A · New York, NYNTSB NYC73AN069Accident · No injuriesClosedBell 206 · Port Washngton, NYNTSB NYC73FHJ03Accident · No injuriesClosedBell 206A · Flushing, NYNTSB NYC71DHM33Accident · No injuriesClosedBell 206A · Montgomery, NYNTSB NYC71DHJ05Accident · Minor injuriesClosedBell 206A · Southampton, NYNTSB NYC70AN094Accident · 2 fatalClosedBell 206A · Floral Park, NYNTSB NYC70D0121Accident · No injuriesClosedBell 206A · Banksville, NYNTSB NYC70I0011Incident · No injuriesClosedBell 206A · New York, NYNTSB NYC70F0074Accident · No injuriesClosedBell 206A · Spring Valley, NY