Final NTSB investigations: Swearingen SA26-T
11 cases on aircraft the registry lists as Swearingen SA26-T. 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
| 1966 | 1 |
|---|---|
| 1970 | 1 |
| 1973 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1985 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780102'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780102'))
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 FTW85LA101Accident · No injuriesLimited investigationFinal reportSwearingen SA26-T · Dallas, TXThe landing gear retracted during the takeoff roll & the acft dropped to the rwy surface & slid to a stop. No obvious reason for the unwanted retraction was noted by FAA maintenance personnel who did a post accident exam of the acft. The gear selector handle…NTSB DEN83LA065Accident · No injuriesLimited investigationFinal reportSwearingen SA-26T · Madison, SDThe aircraft collided with a snowbank 10 feet beyond the threshold during landing. After the accident the pilot reportedthat during the final approach to a landing on runway 32, the left main landing gear contacted a 2 foot high snowbank just beyond the…NTSB FTW83LA109Accident · No injuriesLimited investigationFinal reportSwearingen SA-26T · Houston, TXThe plt reported that after the nosewheel touched down, it began a violent & uncontrollable oscillation, then locked aprx 25 deg to the left. The acft veered off the left side of the runway, crossed an area of soft ground and angled across a taxiway. After…NTSB LAX82DA177Accident · No injuriesFinal reportSwearingen SA26-T · Fresno, CAThe aircraft was observed to make a gear up landing. Investigation revealed that the gear operated normally and that the gear lever was found in the down position. The circuit breaker was popped.NTSB DEN80DTC10Accident · No injuriesClosedSwearingen SA26T · Jackson, WYNTSB LAX80FA005Accident · 2 fatalClosedSwearingen SA26AT · Palo Alto, CANTSB DEN79FTE22Accident · No injuriesClosedSwearingen SA26T · Craig, CONTSB IAD79FA017Accident · 1 fatalClosedSwearingen SA26-T · Memphis, TNNTSB ANC74AA046Accident · 2 fatalClosedSwearingen SA26T · Deadhorse, AKNTSB ANC70AA071Accident · No injuriesClosedSwearingen SA26AT · Anaktuvuk, AKNTSB FTW66F0604Accident · No injuriesClosedSwearingen SA26T · San Antonio, TX