# NTSB investigations: Fairchild SA227-AT

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 ERA24LA131](https://openairdocs.org/ntsb/ERA24LA131.md): Fairchild SA227-AT · Smyrna, TN · Accident · No injuries · Class 4 · Limited · Final report · Mar 4, 2024 · N563TR · Substantial damage
  > The airplane encountered a sink hole while taxiing.
- [NTSB CEN23LA037](https://openairdocs.org/ntsb/CEN23LA037.md): Fairchild SA227-AT · Pewaukee, WI · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 15, 2022 · N247DH · Substantial damage
  > The flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…
- [NTSB FTW00LA078](https://openairdocs.org/ntsb/FTW00LA078.md): Swearingen SA-227-AT · Fayetteville, AR · Accident · No injuries · Limited investigation · Final report · Jan 29, 2000 · N245DH · Substantial damage
  > The flight crew's failure to extend the landing gear. Contributing factors were the flight crew's non-compliance with the checklist, the pilot-in-command's diverted attention as a result of the loss of instrument approach/runway lighting, the partial failure…
- [NTSB MKC86LA136](https://openairdocs.org/ntsb/MKC86LA136.md): Fairchild SA-227 · Lincoln, NE · Accident · No injuries · Limited investigation · Final report · Jul 1, 1986 · N243DH · Substantial damage
  > Flare for touchdown ended short of the active rwy at Lincoln, Nebraska. The PIC rptd windshear on final but wind conditions were rptd as being 340 degrees at 15 KTS, a headwind for this landing. No mechanical control pblm was reportedly experienced during…

## 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 ('3377510'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3377510

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