# NTSB investigations: Boeing 727-223: In flight encounter with weather

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 MIA90LA155](https://openairdocs.org/ntsb/MIA90LA155.md): Boeing 727-223 · Fort Myers, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 18, 1990 · N6834 · No damage
  > Unforecasted encounter with weather. The airplane encountered severe turblence during enroute descent, resulting in one flight attendant sustaining serious injury, and one passenger sustaining minor injury.
- [NTSB DCA86IA017](https://openairdocs.org/ntsb/DCA86IA017.md): Boeing 727-223 · Harlingen, TX · Incident · No injuries · Incident investigation · Final report · Feb 8, 1986 · N871AA · Minor damage
  > While en route, the company dispatcher notified American flt 844 (via acars) that Harlingen (hrl) had unforecast fog & was 300' obscd with 1/2 mi vis. At 2335, as the flt bgn a dscnt fm FL 310, the same ceiling & vis were rprtd. However, as the flt was clrd…
- [NTSB CHI85FA174](https://openairdocs.org/ntsb/CHI85FA174.md): Boeing 727-223 · Little Rock, AR · Accident · Serious injuries · Field investigation · Final report · Apr 23, 1985 · N856AA · No damage
  > The aircraft was paralleling a line of thunderstorms and needed to get on the other side of the line to get to his destination. The center controller suggested that he reverse course to fly around the closer end of the line but the pilot decided to penetrate…

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

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

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