Fatal NTSB investigations: Swearingen SA-26AT
7 cases on aircraft the registry lists as Swearingen SA-26AT. 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
| 1970 | 1 |
|---|---|
| 1972 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2003 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780112'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780112'))
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 MIA04FA029Accident · 1 fatalField investigationFinal reportSwearingen SA-26-AT · Jacksonville, FLThe pilot's descent below decision height while performing an ILS approach with low ceilings and fog, resulting in an in-flight collision with trees and the ground. A factor associated with the accident was the pilot's decision to attempt the instrument…NTSB ANC98FA091Accident · 2 fatalField investigationFinal reportSwearingen SA-26AT · St. George, AKThe pilot-in-command's failure to adequately monitor the instrument approach and the co-pilot's failure to intercept and maintain the proper NDB bearing on the approach. Contributing factors were the pilot-in-command's obstructed view of the NDB indicator and…NTSB NYC94FA064Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Winchester, VAThe pilot's decision to operate the airplane with known deficiencies in the fuel quantity measuring system which resulted in a power loss due to fuel starvation, followed by improper emergency procedures which resulted in a loss of control inflight and…NTSB FTW85FA259Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Rocksprings, TXAs the acft was climbing thru 14,800' for 19,000', the plt reported a rapid decompression. Two minutes later, he reported that he has lost the tail. Acft impacted in an inverted flat spin and the tail and a section of empennage were found about 3/4 mile away…NTSB ATL81FA022Accident · 3 fatalClosedSwearigen SA26AT · Albany, KYNTSB MIA72AM101Accident · 4 fatalClosedSwearingen SA26AT · Nashville, TNNTSB CHI70AC048Accident · 1 fatalClosedSwearingen SA26AT · Willoughby H, OH