# NTSB investigations, 2001, WA: On ground/water collision with object

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 SEA02LA017](https://openairdocs.org/ntsb/SEA02LA017.md): Cessna 172N · Snohomish, WA · Accident · No injuries · Limited investigation · Final report · Nov 24, 2001 · N733XW · Substantial damage
  > The student pilot misjudged the distance from a fence during taxi. The flight instructors inadequate supervision and the fence were factors.
- [NTSB SEA01LA171](https://openairdocs.org/ntsb/SEA01LA171.md): Cessna 172M · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Sep 8, 2001 · N20675 · Substantial damage
  > Pilot's failure to maintain an adequate visual lookout during taxi. A fence was a factor.
- [NTSB SEA01LA091](https://openairdocs.org/ntsb/SEA01LA091.md): Let L-23 · Arlington, WA · Accident · No injuries · Limited investigation · Final report · May 5, 2001 · N265BA · Substantial damage
  > the flight instructor's improper decision to partially retract the spoilers while the student was attempting to land. Factors include a tailwind, wet grass, and a taxiway sign off the end of the landing area.
- [NTSB SEA01LA065](https://openairdocs.org/ntsb/SEA01LA065.md): Piper J3C-65 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Mar 17, 2001 · N30616 · Substantial damage
  > The pilot's failure to visually detect the barricade, resulting in a collision with the barricade. Factors included the barricade, and inadequate information on the ATIS broadcast.

## 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 year(c."eventDate") = 2001
  AND c."eventStateOrRegion" = 'WA' 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" = 310)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=310&state=WA&year=2001

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
