NTSB investigations: Swearingen SA226TC, MO
6 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
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 MKC86FA059Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Kansas City, MODuring a climb to cruise, the pilot-in-command declared an emergency & requested to dscnd & return to the arpt. The landing was uneventful. An exam of the left prop revealed that 1 of its 3 blades had failed at the butt end & had separated. Subsequently, the…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…NTSB MKC84IA185Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Joplin, MOWhile taxiing to takeoff & on the takeoff roll, the left brake overheated. Ten to fifteen mins after departure both tires on the left main landing gear exploded. The bearings and brakes also seized due to the high temperatures. Upon arrival at the dest, the…NTSB MKC83FA072Accident · Serious injuriesField investigationFinal reportSwearingen SA 226TC · St. Louis, MORotating right prop struck a female child passenger who had run down the acft airstair to retrieve a doll she had dropped while climbing the airstair to board for the flt. A company attendant was stationed at the left (stopped) prop, but not on or near the…NTSB MKC82FA149Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Kansas City, MODuring the approach to topeka the crew was unable to extend the left gear. The crew diverted to Kansas City, and after many unsuccessful attempts to lower the left gear elected to land wheels-up. The left main gear was jammed into the geardoors. The aft hinge…