NTSB investigations: Swearingen SA226TC, 1985
5 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\") = 1985
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") = 1985
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 CHI86LA051Accident · No injuriesLimited investigationFinal reportFairchild SA226TC · Cleveland, OHThe crew obtained visual contact with the rw evironment 100 ft above dh. During the landing roll the a/c traveled along the left edge of the runway until it collided with a snow bank. The runway was covered with patches of ice and packed snow.NTSB LAX85FA373Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC Metro II · Fresno, CAWhile in cruise flight at 16,000 feet one of the three propeller blades separated at the shank. The unbalanced condition twisted the eng from its mounts and into the fuselage. The cabin was punctured and rapid decompression followed. The crew was able to…NTSB CHI85IA160Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Dayton, OHOn short final at an airspeed bet 120 and 125 KTS full flaps were lowered for landing. When the flaps reached the full down position, the stall warning horn came on and the stick pusher on the rosemont stall avoidance system activated. The captain disengaged…NTSB MKC85IA057Incident · No injuriesIncident investigationFinal reportSwearingen SA-226-TC · Berkeley, MOCrew accomplished descent checklist. Checklist was approved manufacturer's checklist. Descent was made through 2500 footthick clouds with OAT below freezing without auto-ignition switch on auto/continuous position. Both engines quit on final approach.…NTSB MKC85IA045Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · St. Louis, MOAfter departing st Louis and reaching cruise flt the crew experienced a continual trim pitch-up which had to be relieved by a reduced airspeed. No aural indication was noted by the crew. The return to the airport was uneventful. Follow-up inspection of the…