NTSB investigations: Bell 206L, NY
4 cases on aircraft the registry lists as Bell 206L. 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
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1990 | 1 |
| 2005 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181522'))
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 ('1181522'))
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 NYC05FA099Accident · Serious injuriesField investigationFinal reportBell 206L · New York, NYThe pilot's inadequate preflight planning, which resulted in an attempted takeoff with an overweight helicopter, and subsequent impact with a pier and water. Factors were a high ambient temperature and unfavorable winds.NTSB NYC90FA067Accident · 1 fatalField investigationFinal reportBell 206L · New York City, NYThe pilot's misjudgement of the wind resulting in a downwind takeoff. Additionally the loss of lift when the helicopter flew off the heliport platform, prior to reaching effective translational lift, resulted in the helicopter settling into the water.NTSB NYC87LA164Accident · Minor injuriesLimited investigationFinal reportBell 206L · Port Washington, NYThe plt of a Bell 206L made a downwind tkof with the acft loaded more than 100 lbs over the maximum allowable gross tkof weight. At an altitude of approx 100 ft, while complying with noise abatement tkof procedures, the plt experienced decreasing main rotor…NTSB NYC82FHJ04Accident · Minor injuriesFinal reportBell 206L · New York, NYThe accident involved two Bell 206L helicopters that were parked beside one another, but headed in opposite directions. When the pilot of N49575 arrived, the other helicopter, N16696, was operating with the rotors at about 60% RPM (flight idle) while…