NTSB investigations: Alliedsign T5317A-1
4 cases on aircraft whose registry engine model is Alliedsign T5317A-1. 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
| 2004 | 2 |
|---|---|
| 2017 | 1 |
| 2020 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('02501'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('02501'))
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 WPR20LA283Accident · 1 fatalClass 3 · LimitedFinal reportKaman K 1200 · Pine Grove, ORAn in-flight breakup resulting from contact of the left rotor system with the right rotor system after an in-flight failure of a servo flap from a left rotor blade.NTSB GAA17CA146Accident · No injuriesData collectionFinal reportKaman Aerospace K 1200 · Julian, CAThe pilot’s failure to conduct a thru-flight walkaround inspection, which resulted in the engine cowling remaining open and subsequently separating from the helicopter and striking the main rotor blades and vertical stabilizer during departure.NTSB SEA04TA158Accident · 1 fatalFinal reportBell 205A1 · Leavenworth, WAThe pilot's failure to maintain clearance from the snag while hovering out of ground effect during an external load operation. Factors were the smoke jumper's misjudgment of the tree heights in the area, which resulted in the use of too short a long line, and…NTSB SEA04LA082Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · West Fork, ORThe pilot's failure to maintain adequate clearance with trees during logging operations. Contributing factors were the trees, mountainous (steeply sloped) terrain, and the pilot's decision to conduct operations in this terrain with a 200 foot long line.