# NTSB investigations, DC: 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 BFO90LA043](https://openairdocs.org/ntsb/BFO90LA043.md): Boeing B-737 · Washington, DC · Accident · Serious injuries · Limited investigation · Final report · May 11, 1990 · N990UA · No damage
  > The aircraft encountered turbulence, resulting in injury to a flight attendant.
- [NTSB MIA87IA204](https://openairdocs.org/ntsb/MIA87IA204.md): Boeing 727-225 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Jul 11, 1987 · N8892Z · Minor damage
  > Drg arr, the acft's radar showed tstms in the area of the arpt. As the flt contd, ATIS info chgd. When the plts ctcd Washington apch ctl with old ATIS info, the ctlr did not correct the flt. They were adzd of hvy rain, strong wnds & a PIREP of wndshr nr the…
- [NTSB DCA82IA031](https://openairdocs.org/ntsb/DCA82IA031.md): Boeing 727 · Washington, DC · Incident · Serious injuries · Incident investigation · Final report · Sep 3, 1982 · N288WA · No damage
  > The announcement of the possibility of turbulence during the descent and approach was made. During the lulls in the turbulence the cabin attendants were attending their duties and were hurt when intermittent jolts of rough air were encountered while two of…

## 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" = 'DC' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE 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?occurrence=240&state=DC

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