Fatal NTSB investigations: U/A Canada PT6 SER 578HP
13 cases on aircraft whose registry engine model is U/A Canada PT6 SER 578HP. 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
| 1968 | 1 |
|---|---|
| 1977 | 2 |
| 1985 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2009 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('61501', '61502'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('61501', '61502'))
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 ERA09LA435Accident · 1 fatalLimited investigationFinal reportBeech B90 · West Point, VAThe inadvertent deployment of the instructor's reserve parachute.NTSB NYC08FA218Accident · 1 fatalField investigationFinal reportDehavilland DHC6 · Hyannis, MAThe pilot's failure to remove the flight control lock prior to takeoff. Contributing to the accident was the Federal Aviation Administration's failure to issue an airworthiness directive making the manufacturer's previously-issued flight control lock service…NTSB CHI06FA210Accident · 6 fatalClass 1 · FieldFinal reportde Havilland DHC-6-100 · Sullivan, MOthe pilot's failure to maintain airspeed following a loss of power in the right engine due to the fracturing of compressor turbine blades for undetermined reasons. Contributing to some parachutists' injuries was the lack of a more effective restraint system…NTSB FTW01LA132Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 Twin Otter · Fentress, TXthe King Air pilot's inadequate in-flight planning/decision in that he failed to remain in the agreed on formation position, resulting in one of his skydiver's contacting the propeller of the de Havilland airplane. A contributing factor was the lack of total…NTSB LAX00FA130Accident · 1 fatalField investigationFinal reportBell 212 · Snelling, CAthe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.NTSB DCA97MA009Accident · 14 fatalClass 1 · MajorFinal reportBeech 1900C · Quincy, ILthe failure of the pilots in the King Air A90 to effectively monitor the common traffic advisory frequency or to properly scan for traffic, resulting in their commencing a takeoff roll when the Beech 1900C (United Express flight 5925) was landing on an…NTSB MIA96LA135Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Raeford, NCfailure of the passenger to follow the instructions of ground personnel as she exited the aircraft.NTSB FTW95LA309Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Belen, NMThe parachutist's failure to follow procedures on exiting the aircraft. A factor was the parachutist's incapacitation due to hitting his head on the doorway floor.NTSB MIA94MA048Accident · 10 fatalMajor investigationFinal reportBeech B90 · Okeechobee, FLThe pilot's improper remedial action concerning a right engine power anomaly, and his failure to maintain adequate airspeed during go-around from an aborted precautionary landing, which resulted in a loss of aircraft control and an uncontrolled descent.…NTSB NYC86FA006Accident · 1 fatalField investigationFinal reportde Havilland DHC-6 · Homer City, PAThe acft was observed flying at low altitude along about a 5 mile distance. Some witnesses described the acft altitude as just above treetops. Witness heard engine sounds and saw lights on the acft. The acft flight was on a southeast direction before it…NTSB MIA77FA093Accident · 1 fatalClosedBeech 100 · Auburn, ALNTSB OAK77FA037Accident · 1 fatalClosedSikorski S58FT · Golconda, NVNTSB CHI69A0041Accident · 7 fatalClosedBeech 65-A90 · Cleveland, OH