Final NTSB investigations: U/A Canada PT6A-34
8 cases on aircraft whose registry engine model is U/A Canada PT6A-34. 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 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2019 | 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 ('61534'))
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 ('61534'))
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 GAA20CA020Accident · Minor injuriesData collectionFinal reportAyres S2R · Willacoochee, GAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.NTSB NYC05FA042Accident · 1 fatalField investigationFinal reportEmbraer EMB-110P1 · Swanzey, NHThe pilot's improper decision to attempt a single-engine missed approach with the airplane in a slow airspeed, full flap configuration, which resulted in a minimum control speed (Vmc) roll. Contributing factors included an inoperative engine for undetermined…NTSB MIA01IA144Incident · No injuriesIncident investigationFinal reportGrumman G-73 · Fort Lauderdale, FLThe improper review of component records by company maintenance personnel of returned landing gear components from a laboratory for magnaflux and x-ray. This resulted in unserviceable components being tagged as serviceable, installation of unserviceable parts…NTSB MIA00IA186Incident · No injuriesIncident investigationFinal reportGrumman G-73T · Watson Island, FLthe overload separations of the control yoke on the captain's side.NTSB FTW96LA069Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · West Helena, ARBinding of the power lever linkage, due to corrosion, which resulted in a situation that led to an inadvertent shut-down of the engine at a critical point on the approach to land. A factor relating to the accident was: inadequate maintenance.NTSB DCA86AA021Accident · 3 fatalFinal reportEmbraer EMB-110P1 · Alpena, MIDrg arrival at 2125 EST, simmons airline flt 1746 was adzd by wurtsmith afb apch ctl that the 2052 EST wx at phelps collins arpt was: sky partially obscd, ceiling 100' overcast, vis 1/2 mi with lgt drizzle & fog, & to expect an ILS apch. However, at 2119, a…NTSB CHI83IA103Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110 · Milwaukee, WIThe acft experienced extreme oscillations about the pitch axis with the control column moving fore & aft from 1 to 3 inches. The oscillations varied directly with airspeed. No out of limit conditions were found until after a second occurrence when the…NTSB SEA82IA029Incident · No injuriesIncident investigationFinal reportEmbraer EMB-11OP1 · Boise, IDThis aircraft, which was departing on a scheduled flight to lewiston, ID., was just accelerated to rotation speed when the crew heard one of the passengers scream. The takeoff WA successfuly aborted and the aircraft was returned to the gate. Investigation…