Skip to content

Final NTSB investigations: U/A Canada PT6A-27-28

27 cases on aircraft whose registry engine model is U/A Canada PT6A-27-28. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19712026

Where

Latest cases

Query with SQL

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 ('61504')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('61504'))
  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 ('61504'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C90 · Lancaster, TXThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.Apr 28, 2025 · N501MS · Substantial damage NTSB CEN23LA028Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E-90 · Slidell, LAThe pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.Nov 7, 2022 · N809DM · Destroyed NTSB ERA23FA024Accident · 2 fatalClass 3 · FieldFinal reportBeech E-90 · Marietta, OHStructural icing on the tailplane that resulted in a tailplane stall and subsequent loss of control.Oct 18, 2022 · N515GK · Substantial damage NTSB CEN20MA044Accident · 5 fatalClass 2 · MajorFinal reportPiper PA 31T · Lafayette, LAThe pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.Dec 28, 2019 · N42CV · Destroyed NTSB ERA15LA333Accident · No injuriesLimited investigationFinal reportBeech E 90 · Fayetteville, TNA total loss of electrical power for reasons that could not be determined and the pilot's subsequent failure to properly follow the manual landing gear extension procedures, which resulted in the landing gear not extending.Aug 28, 2015 · N891PC · Substantial damage NTSB CEN13FA105Accident · 2 fatalField investigationFinal reportBeech E-90 · Amarillo, TXThe pilot’s loss of control of the airplane after encountering icing conditions and heavy to extreme turbulence and the subsequent exceedance of the airplane’s design limit, which led to an in-flight breakup.Dec 15, 2012 · N67PS · Substantial damage NTSB CEN12FA421Accident · 1 fatalField investigationFinal reportBeech E90 · Karnack, TXThe pilot's inadvertent flight into thunderstorm activity, which resulted in the loss of airplane control and the subsequent exceedance of the airplane's design limits and in-flight breakup. Contributing to the accident was the failure of air traffic control…Jul 7, 2012 · N987GM · Destroyed NTSB CEN11LA192Accident · No injuriesLimited investigationFinal reportBeech E-90 · Des Moines, IAThe improper installation of the right aileron by maintenance personnel.Feb 15, 2011 · N51DN · Substantial damage NTSB LAX08FA026Accident · 2 fatalField investigationFinal reportBeech A100 · Chino, CAThe pilot's failure to maintain a positive climb rate during an instrument takeoff. Contributing to the accident was the low visibility.Nov 6, 2007 · N30GC · Destroyed NTSB LAX07FA200Accident · 2 fatalField investigationFinal reportBeech E90 · Carlsbad, CAThe pilot's failure to maintain clearance from wires during an instrument takeoff attempt. Contributing to the accident were fog, reduced visibility, and the low ceiling.Jul 3, 2007 · N47LC · Destroyed NTSB CHI07LA050Accident · Minor injuriesLimited investigationFinal reportBeech B-99 · Rapid City, SDThe pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.Dec 29, 2006 · N99TH · Substantial damage NTSB DEN03LA053Accident · Minor injuriesLimited investigationFinal reportBeech E-90 · Kremmling, COthe pilot's improper in-flight planning and his failure to maintain safe clearance from the high terrain. Factors contributing to the accident were the high terrain and the dark night.Mar 20, 2003 · N711TZ · Substantial damage NTSB CHI02FA199Accident · 2 fatalField investigationFinal reportBeech E-90 · Bloomington, ILThe cause of the accident is undetermined.Jul 21, 2002 · N12KA · Destroyed NTSB FTW02LA172Accident · No injuriesLimited investigationFinal reportBeech BE-100-A100 · Little Rock, ARThe malfunction of the left main landing gear retraction/extension assembly due to a missing lock pin/washer/nut on the clevis of the push/pull gear extension tube that resulted from improper maintenance.Jun 5, 2002 · N799DD · Substantial damage NTSB SEA00LA183Accident · No injuriesLimited investigationFinal reportBeech B99 · Missoula, MTA loss of directional control due to a brake locked as a result of snow and ice contamination.Sep 22, 2000 · N99TH · Substantial damage NTSB NYC00FA067Accident · 4 fatalField investigationFinal reportBeech C-90 · Somerset, KYthe failure of the pilot to follow his approach clearance, and subsequent descent into unprotected airspace which resulted in a collision with the guy wire. Factors were the failure of the air traffic controller to verify the approach he cleared the pilot to…Jan 18, 2000 · N74CC · Destroyed NTSB LAX93IA029Incident · No injuriesIncident investigationFinal reportPiper PA-31T-620 · Medford, ORFatigue failure of the elevator control tube rod end bearing resulting in a loss of elevator control.Nov 5, 1992 · N131AF · No damage NTSB CHI92LA237Accident · No injuriesLimited investigationFinal reportBeech C90 · Pontiac, MIThe pilot's not understanding the fuel system, and his subsequent inadvertent discontinuance of fuel to both engines.Aug 6, 1992 · N90RG · Substantial damage NTSB NYC90FA199Accident · 3 fatalField investigationFinal reportPiper PA-31T2 · Mattapan, MAThe pilot's improper in-flight planning/decision, which resulted in his failure to maintain control of the aircraft. Factors related to the accident were: failure of the left fuel control unit, and the adverse weather conditions.Aug 24, 1990 · N85HB · Destroyed NTSB DEN89IA071Incident · No injuriesIncident investigationFinal reportBeech E90 · Lander, WYDeer on the runway.Jan 31, 1989 · N87CH · Minor damage NTSB MKC89FA027Accident · 6 fatalField investigationFinal reportBeech E-90 · Locust Grove, ARThe pilot's failure to maintain obstacle clearance altitude and exceeding the minimum descent altitude published in the approach procedure.Nov 19, 1988 · N308PS · Destroyed NTSB ATL88MA048Accident · 2 fatalMajor investigationFinal reportBeech C90 · Beaufort, SCAt 0938, while clbg thru 9000', the plt was clrd to clb to FL 210. Aprx 10 min later, the ATC ctlr noted the acft's mode c rtrn wasn't being displayed on his scope. He tried to adz the plt, but couldn't establish radio contact. The acftbroke up in flt & the…Nov 30, 1987 · N4463W · Destroyed NTSB MIA87LA027Accident · Minor injuriesLimited investigationFinal reportBeech A100 · Brooksville, FLThe pilot stated that shortly after departure the cockpit filled with smoke. While returning for landing his visibility was reduced due to the smoke and ground fog. On landing roll the the aircraft ran off the left side of the runway, went through a cow fence…Nov 8, 1986 · N78L · Destroyed NTSB MIA86MA057Accident · 2 fatalMajor investigationFinal reportPiper PA-31T · Jacksonville, FLWhile being vectored for an ILS rwy 7 apch, the plt was told to maint 3000' & advised he was flwg a Boeing 727. The min apch alt bfr intercepting the ILS glide slope (g/s) at the final apch fix/outer marker (om) was 1900'. As the acft was apchg the om, the…Jan 10, 1986 · N700CM · Destroyed NTSB ANC85FA054Accident · Serious injuriesField investigationFinal reportde Havilland DHC-6-300 · Barter Island, AKAcft crashed during missed apch to temporary winter landing strip. Acft hit in steep nose down attitude. Marginal wx conditions prevailed, with icing reported.Mar 12, 1985 · N540N · Substantial damage NTSB MIA80IA108Incident · No injuriesClosedBeech B99 · Orlando, FLSep 23, 1980 · N99TH · Minor damage NTSB FTW72AF037Accident · No injuriesClosedBeech A99A · Houston, TXDec 17, 1971 · N1923T · Substantial damage