NTSB investigations: Swearingen SA226TC, 1983
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\") = 1983
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") = 1983
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 DCA83AA037Accident · No injuriesFinal reportSwearingen SA226TC · Hot Springs, ARTurning onto the rwy the coplt observed a flash behind his inst panel. He then received an elect shock to his right arm from the right console. A fire then erupted at the lower right hand corner of his inst panel. The crew & pax evacuated the acft. The…NTSB NYC83FA074Accident · Minor injuriesField investigationFinal reportSwearingen SA226TC · Albany, NYThe plt reported that during arrival, he followed the ILS glide slope to touchdown about 1000 ft down the rwy. He reported the landing was smooth, and when the acft was aprx 100 ft from the intersection of rwys 1/19 and 10/28, he saw a ridge of snow and ice…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 ATL83LA080Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Laurel, MSAt 11,000 ft MSL during cruise a prop separated from the left eng. The eng was feathered & the plt observed the eng displaced inboard & downward. An emergency landing was made & upon landing the left main gear was found to be retracted. The acft slid to a…