# NTSB investigations: Swearingen SA226TC, 2003

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB DEN04FA027](https://openairdocs.org/ntsb/DEN04FA027.md): Swearingen SA226-TC · Denver, CO · Accident · No injuries · Field investigation · Final report · Dec 3, 2003 · N60U · 2 aircraft · Substantial damage
  > the failure of the pilot of the taxiing aircraft to maintain clearance and adequate visual lookout for the stopped aircraft.
- [NTSB DEN04LA023](https://openairdocs.org/ntsb/DEN04LA023.md): Fairchild Swearingen SA226TC · Grand Junction, CO · Accident · No injuries · Limited investigation · Final report · Nov 18, 2003 · N332BA · Substantial damage
  > the operator's improper maintenance and servicing of the airplane's nose landing gear assembly, resulting in the collapse of the nose landing gear during the landing roll. Contributing factors include the nose section of the airplane's subsequent contact with…
- [NTSB DEN03LA076](https://openairdocs.org/ntsb/DEN03LA076.md): Swearingen SA226TC · Denver, CO · Accident · No injuries · Limited investigation · Final report · Apr 16, 2003 · N229AM · Substantial damage
  > The failure of the landing gear system and the flight crew's failure to ascertain that the landing gear was down and locked. A contributing factor was the inadequate maintenance inspections performed by maintenance personnel.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2003
  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
```

This list as a web page: https://openairdocs.org/ntsb?model=8780404&year=2003

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.