NTSB investigations: Swearingen SA226TC, 1987
4 cases on aircraft the registry lists as Swearingen SA226TC. 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
| 1977 | 1 |
|---|---|
| 1978 | 3 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2003 | 3 |
| 2004 | 1 |
| 2006 | 3 |
| 2017 | 1 |
| 2021 | 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 year(c.\"eventDate\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780404'))
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 year(c."eventDate") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780404'))
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 BFO88FA010Accident · Serious injuriesField investigationFinal reportSwearingen SA-226 · Chantilly, VAThe acft had descended through a cloud layer enroute for the scheduled lndg at iad and according to the crew had picked up some trace rime ice on its wing surfaces. Although pitot and sas (stall avoidance system) heat were used the captain elected not to use…NTSB ATL87FA123Accident · 2 fatalField investigationFinal reportSwearingen SA-226TC · Wilmington, NCThe right engine failed during takeoff immediately after rotation 3000' down the 7,002' rwy 16. The plt continued the flt and the landing gear remained extended. The unauthorized plt rated pax made xmissions to the tower. Witnesses rpted that the acft reached…NTSB DEN87LA067Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Missoula, MTThe plt of the Piper navajo was taxiing to the active rwy for an IFR departure, directed his attention to the departure procedure chart in the cockpit, and collided with the tail of a swearingen acft holding short of the rwy awaiting takeoff clearance.NTSB ATL87LA070Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Florence, SCDuring the final leg of a domestic scheduled commuter airline flight the aircraft landed with the landing gear in the retracted position. The captain could not recall placing the gear selector handle in the down position and the co-pilot could not remember…