Final NTSB investigations: Short Bros. & Harland SD3-30
7 cases on aircraft the registry lists as Short Bros. & Harland SD3-30. 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
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 2003 | 1 |
| 2017 | 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.aircraft_model_code IN ('8100602'))
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.aircraft_model_code IN ('8100602'))
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 DCA17FA109Accident · 2 fatalField investigationFinal reportShort Bros. & Harland SD3 30 · Charleston, WVthe flight crew's improper decision to conduct a circling approach contrary to the operator's standard operating procedures (SOP) and the captain's excessive descent rate and maneuvering during the approach, which led to inadvertent, uncontrolled contact with…NTSB NYC03LA081Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-30 · Du Bois, PAThe captain's failure to maintain the proper glidepath during the instrument approach, and his failure to perform a go-around. Factors were a low ceiling and reduced visibility due to mist.NTSB BFO86LA030Accident · Serious injuriesLimited investigationFinal reportShort Brothers SD3-30 · Hopewell, VAThe captain reported that moderate to severe turbulence was encountered while passing through some clouds. He called the flight attendant on the intercom and told her to sit down; while she was attempting to answer the intercom, an object from the galley area…NTSB NYC84LA015Accident · 1 fatalLimited investigationFinal reportShort Brothers SD3-30 · Middletown, PAAfter takeoff on a flt to Washington, DC, the aircraft was climbing thru about 3500 ft when a person (riding as a passenger) moved to the right rear door, opened it & departed the acft. Prior to the flt, an associate, who was an acft refueler, saw the person…NTSB NYC81IA061Incident · Minor injuriesClosedShort Bros SD3-30 · Wilkes Barre, PANTSB NYC80FHA21Accident · Minor injuriesClosedShort Bros SD3-30 · Allentown, PANTSB NYC79IA072Incident · No injuriesClosedShort Bros SD3-30 · Reading, PA