NTSB investigations: Swearingen SA227-TT
6 cases on aircraft the registry lists as Swearingen SA227-TT. 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
| 1984 | 2 |
|---|---|
| 1985 | 1 |
| 1993 | 1 |
| 2017 | 1 |
| 2018 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780620'))
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 ('8780620'))
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 CEN18LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227 TT · Houston, TXThe failure of the left starter relay during engine start, which resulted in a loss of electrical and battery power during the flight and led to a forced landing with the nose landing gear not fully extended, causing substantial damage to the engines.NTSB GAA17CA333Accident · No injuriesData collectionFinal reportSwearingen SA227 TT · Santa Monica, CAThe pilot’s unstabilized approach after encountering wake turbulence, which resulted in a hard landing.NTSB ATL93MA068Accident · 4 fatalMajor investigationFinal reportFairchild SA227-TT · Blountville, TNFailure of the pilot to follow procedures concerning use of the engine inlet anti-ice system and/or continuous ignition while operating in icing conditions, which resulted in probable ice ingestion and loss of engine power; and the pilot's failure to maintain…NTSB NYC85LA256Accident · No injuriesLimited investigationFinal reportSwearingen 226T · Hamilton, NYThe aircraft was on approach for landing at Hamilton, new york when the cross power levers were pulled back to flight idle. The left prop went into beta mode stalling the left wing at about 8 feet above the runway. The aircraft rolled about 20 degrees to the…NTSB CHI84IA252Incident · No injuriesIncident investigationFinal reportFairchild SA-227-TT · Pontiac, MIThe aircrew noticed a 'nose up' pitch change during descent at about the time they were leveling to slow for the arpt pattern & traffic. The plt reported that full forward yoke pressure was required to stop the nose up condition. The acft was landed without…NTSB NYC84LA079Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Philadelphia, PAThe plt broke out of the overcast at 1000 ft lowered flaps and landed the acft with the gear retracted. The plt said he had lowered the gear. The gear warning horn reportedly did not sound.