Final NTSB investigations: Pratt & Whitney Canada PW207C
6 cases on aircraft whose registry engine model is Pratt & Whitney Canada PW207C. 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
| 2014 | 1 |
|---|---|
| 2016 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2024 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52203'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52203'))
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 WPR25LA006Accident · Minor injuriesClass 4 · LimitedFinal reportAgustawestland AW109SP · Kamas, UTThe pilot’s exceedance of the helicopter’s available power while landing in a confined area, which resulted in a loss of tail rotor effectiveness and a hard landing.NTSB WPR21LA039Accident · Serious injuriesClass 3 · LimitedFinal reportAgusta A109 · Los Angeles, CAThe loss of tail rotor control due to the separation of the tail rotor duplex bearing ring nut from the thrust sleeve, which resulted in the loss of helicopter control.NTSB WPR20LA029Accident · No injuriesClass 3 · LimitedFinal reportAgusta A109 · Salt Lake City, UTThe flight nurse’s inadvertent application of left anti-torque pedal during cruise flight, which resulted in a rapid yaw and pitch movement that caused the tail rotor blades to contact the tailboom.NTSB CEN19FA185Accident · 2 fatalClass 2 · FieldFinal reportAgusta A109 · Brainerd, MNThe pilot's spatial disorientation during an instrument approach in dark night instrument meteorological conditions, which resulted in a loss of control and subsequent impact with terrain.NTSB CEN16FA372Accident · Serious injuriesField investigationFinal reportAgusta A109 · Alexandria, MNThe pilot's excessive cyclic input during a missed approach maneuver in night instrument meteorological conditions, which resulted in a loss of control and spiraling descent into terrain.NTSB WPR14LA160Accident · Serious injuriesLimited investigationFinal reportAgustawestland AW109SP · Astoria, ORThe decision by the ship pilot and the helicopter crew to lower the ship pilot to a location on the ship that did not provide the helicopter pilot with an adequate view of the ship. Contributing to the accident was the inadequate pre-mission coordination…