# NTSB investigations: Saab-Fairchild 340A: Airframe/component/system failure/malfunction

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 CHI02IA275](https://openairdocs.org/ntsb/CHI02IA275.md): Saab-Scania 340A · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Sep 4, 2002 · N110XJ · No damage
  > A malfunctioning yaw damper.
- [NTSB MKC89IA012](https://openairdocs.org/ntsb/MKC89IA012.md): Saab-Scania 340A · Springfield, MO · Incident · No injuries · Incident investigation · Final report · Oct 24, 1988 · N347AM · Minor damage
  > The a.c. generator mounted on the left engine failed and resulted in an in-flight fire. The captain elected to shut down the left engine and divert the flight to the Springfield, Missouri regional airport. A single engine precautionary landing was completed…
- [NTSB MKC86IA018](https://openairdocs.org/ntsb/MKC86IA018.md): SAAB-Fairchild SF340A · Lincoln, NE · Incident · No injuries · Incident investigation · Final report · Oct 29, 1985 · N342AM · No damage
  > During landing roll at the Lincoln airport, the outboard wheel of the left main landing gear separated from the axle. The acft was not hampered in its landing roll and taxithe landing gear assembly revealed that a retaining nut washer was not installed on…

## 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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7850100')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7850100&occurrence=130

---
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.