NTSB investigations: Allison 250 SER 317HP, CA
4 cases on aircraft whose registry engine model is Allison 250 SER 317HP. 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
| 1979 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1990 | 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03011'))
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" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03011'))
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 LAX90LA283Accident · Minor injuriesLimited investigationFinal reportBell 206B II · San Francisco, CAThe pilot's failure to maintain directional control of the helicopter. Contributing to the accident was the pilot's decision to operate the helicopter in a flight regime conducive to unanticipated right yaw.NTSB LAX85LA045Accident · No injuriesLimited investigationFinal reportBell 206B · Inverness, CAAn autorotation was initiated at about 300 ft as eng and rotor RPM began to decrease. Touchdown occurred in soft sand with some forward motion. Full aft cyclic was applied causing the main rotor to contact the tailboom. Exam of the acft fuel system revealed…NTSB LAX83FA287Accident · Minor injuriesField investigationFinal reportBell 206B · Temecula, CAThe plt took off on a demonstration flt to familiarize the passengers with the helicopter. He reported that after takeoff, he proceeded northeast at about 100 to 150 ft AGL & 80 KTS in wind that was from the west at 25 gusting 30 KTS. After traveling about 3…NTSB LAX79FUQ39Accident · No injuriesClosedHiller Acft FH1100 · Oxnard, CA