Skip to content

NTSB investigations: Short Bros. & Harland SC7 SERIES 3

16 cases on aircraft the registry lists as Short Bros. & Harland SC7 SERIES 3. 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

19762026

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8100512')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8100512'))
  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.aircraft_model_code IN ('8100512'))
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 ANC22LA042Accident · No injuriesClass 4 · LimitedFinal reportShort Bros. & Harland SC7 · Chisana, AKThe pilot’s selection of an unsuitable landing site, which resulted in the nosewheel collapsing.Jun 8, 2022 · N731E · Substantial damage NTSB ANC12CA036Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series 3 · Chefornak, AKThe pilot's misidentification of a nearby snow-covered road as the snow-covered runway in flat light conditions.May 3, 2012 · N1906 · Substantial damage NTSB ANC09CA109Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series · Skwentna, AKThe pilot's failure to maintain directional control while landing on a rough, soft, and narrow airstrip.Sep 26, 2009 · N754BD · Substantial damage NTSB ANC07FA103Accident · 1 fatalField investigationFinal reportShort Bros. SC-7 · McGrath, AKA collision with trees during takeoff-initial climb for an undetermined reason.Sep 20, 2007 · N2088Z · Substantial damage NTSB ANC07LA095Accident · No injuriesLimited investigationFinal reportShort Bros. SC-7 · McGrath, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose gear collapse during the landing roll. Contributing to the accident was the soft terrain.Sep 1, 2007 · N2088Z · Substantial damage NTSB ANC00LA042Accident · No injuriesLimited investigationFinal reportShort Brothers SC7 · Delta Junction, AKThe pilot's inadequate compensation for wind conditions during landing. Factors associated with the accident were an unfavorable wind, a crosswind, and an inadvertent swerve.Apr 5, 2000 · N549WB · Substantial damage NTSB ANC97FA037Accident · 2 fatalField investigationFinal reportShort Brothers SC7 · Nunapitchuk, AKinadequate visual look-out by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplanes.Mar 25, 1997 · N451SA · 2 aircraft · Destroyed NTSB IAD96FA147Accident · No injuriesField investigationFinal reportShort Brothers SC7 · Findlay Twnshp, PAThe pilot's improper in-flight decision to continue to his destination when known en route delays were encountered which resulted in fuel exhaustion.Sep 17, 1996 · N10DA · Destroyed NTSB ANC95LA158Accident · 1 fatalLimited investigationFinal reportShort Brothers SC-7 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions. The weather was a factor.Sep 1, 1995 · N30GA · Destroyed NTSB ANC95LA141Accident · No injuriesLimited investigationFinal reportShort Brothers SC.7 · Nikolai, AKIgnition of hazardous cargo (aviation fuel) by an exposed electrical wire, after leaking from a container of fuel that was being transported on the flight. Factors relating to the accident were: inadequate inspection of the airplane by company maintenance…Aug 11, 1995 · N504FS · Substantial damage NTSB CHI88FA143Accident · No injuriesField investigationFinal reportShort Brothers SC.7 · Cleveland, OHFatigue failure on the radius between the body of the nose landing gear and the portion containing the arms.Jun 25, 1988 · N30GA · Substantial damage NTSB ANC87LA006Accident · No injuriesLimited investigationFinal reportShort Brothers SC7 · Nightmute, AKAccording to the plt-in-command (PIC), when the acft was on final apch to the 1600 ft rwy, it encountered a downdraft. Subsequently, the acft hit hard on the lip of the rwy, then bounced & touched down on the rwy. After the 2nd touchdown, the acft veered to…Oct 21, 1986 · N406TH · Substantial damage NTSB ANC83IA010Incident · Minor injuriesIncident investigationFinal reportShort Bros. SC7 Series 3 · Barrow, AKThe aircraft was on a round trip flight from Barrow, AK to point hope, AK and return. After landing at point hope, there was a 20 min delay while waiting for the ground crew. The pilot stated that he ran the engines for some 10 min or so due to the high winds…Nov 1, 1982 · N50DA · Minor damage NTSB ANC81DA054Accident · Minor injuriesClosedShort SC7 · Slate Creek, AKMay 15, 1981 · N70DA · Substantial damage NTSB ANC78DA008Accident · Serious injuriesClosedShort Bros SC-7 · Toksook Bay, AKDec 31, 1977 · N64AC · Destroyed NTSB NYC76FHJ23Accident · No injuriesClosedShort Bros SC7 · Jamaica, NYJun 24, 1976 · N10DA · Substantial damage