# NTSB investigations: Boeing 727-225, GA

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 DCA97IA030](https://openairdocs.org/ntsb/DCA97IA030.md): Boeing 727F · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Mar 3, 1997 · N465FE · Minor damage
  > A jammed elevator resulting from a backed-off elevator trim tab nut.
- [NTSB DCA90MA017](https://openairdocs.org/ntsb/DCA90MA017.md): Beech A100 · Atlanta, GA · Accident · 1 fatal · Class 1 · Major · Final report · Jan 19, 1990 · N44UE · 2 aircraft · Destroyed
  > (1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…
- [NTSB ATL90IA033](https://openairdocs.org/ntsb/ATL90IA033.md): Boeing 727-225 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Nov 29, 1989 · N8835E · Minor damage
  > Inadequate maintenance and inspection by the operator.

## 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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1384077'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1384077&state=GA

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