# NTSB investigations: Lycoming 0-360-C1F, WA

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 WPR10LA374](https://openairdocs.org/ntsb/WPR10LA374.md): Lancair 320 · Spokane, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 27, 2010 · N360N · Substantial damage
  > Loss of airplane control due to the asymmetric flap condition.
- [NTSB SEA01LA054](https://openairdocs.org/ntsb/SEA01LA054.md): Robinson R22 · Seattle, WA · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 2001 · N8362Q · Substantial damage
  > Both pilots' exceedance of the proper descent rate during the autorotative descent. Factors included the helicopter's low altitude at maneuver initiation, the failure of both pilots to maintain the proper airspeed during the descent, and both pilots' delay in…
- [NTSB SEA99LA033](https://openairdocs.org/ntsb/SEA99LA033.md): Robinson R-22 · Seattle, WA · Accident · Minor injuries · Limited investigation · Final report · Feb 15, 1999 · N8362Q · Substantial damage
  > The dual student's improper touchdown while drifting during a practice autorotation. Contributing to the accident was the flight instructor (CFI) inadequate remedial action.

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

This list as a web page: https://openairdocs.org/ntsb?engine=41573&state=WA

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